Preparing nutritional status reports can take time, especially when teachers or school coordinators need to consolidate data from different grade levels and sections. To help make the process faster and more organized, this post shares a free automated Summary of Nutritional Status Report template for both Elementary and Secondary levels.
The template is designed as an editable Excel file with grade-level sheets and a summary sheet. It can help schools organize learner nutritional status data based on SF8 records and generate a cleaner consolidated report for checking, printing, or submission.
This resource is useful for class advisers, school health coordinators, feeding program coordinators, and school heads who need a more efficient way to summarize learner health and nutrition data.
Resource Information
| Resource Details | Description |
|---|---|
| Resource Title | Automated Summary of Nutritional Status Report |
| File Type | Excel Workbook |
| Available Versions | Elementary and Secondary |
| Main Use | Consolidating nutritional status data by grade level and section |
| Data Source | School Form 8 or learner health and nutrition records |
| Features | Grade-level sheets, summary sheet, built-in formulas, editable format |
| Target Users | Class advisers, school health coordinators, feeding coordinators, school heads |
| Editable | Yes |
What Is a Summary of Nutritional Status Report?
A Summary of Nutritional Status Report is a consolidated school report that presents the nutritional classification of learners based on recorded health and nutrition data.
In schools, nutritional status data is commonly based on information recorded in School Form 8 or SF8, also known as the Learner’s Basic Health and Nutrition Report. SF8 records health-related learner data such as height, weight, BMI, nutritional status, and other related indicators.
A summary report helps school personnel see the overall nutritional profile of learners by grade level, section, or school level. This is helpful when preparing reports for school health monitoring, feeding program planning, intervention tracking, and school-level consolidation.
Why This Template Is Useful
Manual counting and consolidation can be time-consuming, especially for schools with many grade levels and sections. An automated Excel template helps reduce repetitive work and keeps the report more organized.
This template can help users:
- Encode nutritional status totals by grade level and section
- Organize data in separate grade-level sheets
- Automatically consolidate data into a summary sheet
- Prepare a cleaner report for review or printing
- Reduce manual counting errors
- Save time during reporting periods
- Keep a consistent format across grade levels
The template does not replace proper measurement, validation, or official school reporting procedures. It simply helps organize and summarize the data more efficiently.
DepEd Reporting Context
School Form 8 or SF8 is the Learner’s Basic Health and Nutrition Report used for recording learner health and nutrition information. It provides a structured way to document data such as height, weight, BMI, nutritional status, and other health indicators.
Nutritional status monitoring is also connected with school health and feeding program implementation. DepEd’s School-Based Feeding Program guidelines identify improvement of beneficiary nutritional status as one of the program goals, especially for learners classified as wasted or severely wasted.
For this reason, having an organized summary of nutritional status can support school-level monitoring, reporting, and planning for interventions.
Available Template Versions
This resource includes two separate Excel files:
| Version | Included Grade-Level Sheets |
|---|---|
| Elementary Version | Kinder, Grade 1, Grade 2, Grade 3, Grade 4, Grade 5, Grade 6, and SPED |
| Secondary Version | Grade 7, Grade 8, Grade 9, Grade 10, Grade 11, and Grade 12 |
Both versions include a Guide sheet and a SUMMARY sheet.
The Guide sheet explains the purpose of the workbook, the workbook structure, and important reminders for using the tool properly.
What’s Inside the Excel Template?
The automated workbook includes the following parts:
| Workbook Part | Purpose |
|---|---|
| Guide Sheet | Provides instructions and reminders on how to use the workbook |
| Summary Sheet | Consolidates totals from the grade-level sheets |
| Grade-Level Sheets | Used for encoding data per grade level and section |
| Built-in Formulas | Help summarize and consolidate data automatically |
| Printable Layout | Provides a cleaner format for checking or printing |
The tool is designed to support up to multiple sections per grade level, depending on the workbook format. Users should avoid deleting rows or cells because doing so may affect the formulas.
Nutritional Status Categories Commonly Used
Depending on the official form, school instructions, or reporting tool used, nutritional status reports may include categories such as:
| BMI Category | Meaning |
|---|---|
| Severely Wasted | Learner is far below the expected BMI-for-age range |
| Wasted | Learner is below the expected BMI-for-age range |
| Normal | Learner is within the expected BMI-for-age range |
| Overweight | Learner is above the expected BMI-for-age range |
| Obese | Learner is significantly above the expected BMI-for-age range |
Some reports may also include height-for-age classifications such as normal height, stunted, or severely stunted.
Always follow the official tool, school nurse guidance, or division instructions when classifying learners.
Recommended Data Source: SF8
To make the summary accurate, the data should come from verified learner health and nutrition records. One common source is School Form 8 or SF8.
SF8 usually contains important learner health information such as:
- Learner name
- Date of birth
- Age
- Sex
- Height
- Weight
- BMI
- Nutritional status
- Height-for-age classification
- Remarks or other health-related information
Before transferring data to the summary template, make sure the SF8 entries have been checked and validated by the responsible personnel.
How the Template Works
The workflow is simple:
| Step | Action |
|---|---|
| Step 1 | Prepare or verify the SF8 data |
| Step 2 | Open the correct Excel file: Elementary or Secondary |
| Step 3 | Go to the appropriate grade-level sheet |
| Step 4 | Encode the needed totals or section data |
| Step 5 | Review the automatic summary sheet |
| Step 6 | Check totals for accuracy |
| Step 7 | Print, save, or submit the report as needed |
The summary sheet is designed to automatically reflect data from the grade-level sheets, so users should encode only in the intended input areas.
Elementary Template Overview
The Elementary version is useful for schools handling Kinder to Grade 6 learners. It also includes a SPED sheet, which may be helpful for schools that need a separate area for special program or learner group reporting.
Included sheets:
- Guide
- SUMMARY
- Kinder
- Grade 1
- Grade 2
- Grade 3
- Grade 4
- Grade 5
- Grade 6
- SPED
This version is best for elementary schools and integrated schools that need to consolidate elementary-level nutritional status data.
Secondary Template Overview
The Secondary version is designed for junior high school and senior high school levels.
Included sheets:
- Guide
- SUMMARY
- Grade 7
- Grade 8
- Grade 9
- Grade 10
- Grade 11
- Grade 12
This version is best for secondary schools, integrated schools, and senior high school coordinators who need a separate summary for Grades 7 to 12.
Key Features of the Template
| Feature | Benefit |
|---|---|
| Separate grade-level sheets | Keeps data organized by grade level |
| Summary sheet | Provides a consolidated view of nutritional status data |
| Built-in formulas | Reduces manual computation and repetitive counting |
| Editable workbook | Allows schools to adjust labels, headers, and details |
| Elementary and Secondary versions | Lets users choose the correct template for their school level |
| Guide sheet | Gives reminders on how to use the workbook properly |
| Printable format | Helps users prepare a clean report copy |
These features make the file more practical for school reporting, especially during periods when multiple reports need to be prepared quickly.
Important Encoding Reminders
To avoid errors in the workbook, observe the following reminders:
- Encode only in the designated input cells.
- Do not delete rows, columns, or cells unless you fully understand the formulas.
- Do not rename sheets without checking formulas.
- Check that totals match your source data.
- Use the correct file version for your school level.
- Save a backup copy before editing.
- Review the summary sheet before printing or submitting.
- Coordinate with the school health coordinator or school nurse when validating nutritional classifications.
These reminders are important because automated workbooks rely on formulas and linked sheets.
Common Mistakes to Avoid
| Mistake | Better Practice |
|---|---|
| Encoding data in the summary sheet | Encode in the proper grade-level sheets |
| Deleting unused rows | Leave blank rows unused instead of deleting them |
| Using unverified totals | Base entries on checked SF8 or official records |
| Mixing elementary and secondary data in one file | Use the correct workbook version |
| Forgetting to review formulas | Check the summary after encoding |
| Submitting without validation | Have the data reviewed by the assigned coordinator |
| Editing protected or formula cells | Edit only the designated input areas |
Avoiding these mistakes helps keep the report reliable and easier to check.
Who Can Use This Template?
This automated Summary of Nutritional Status Report template is useful for:
- Class advisers
- School health coordinators
- Feeding program coordinators
- MAPEH teachers assisting with health records
- School nurses
- School heads
- Grade-level chairpersons
- Teachers assigned to consolidate reports
- School-Based Feeding Program focal persons
The file may also be helpful for schools that need a consistent format for organizing data before submission.
Suggested Supporting Documents
When preparing a nutritional status report, it is helpful to keep supporting documents organized.
Possible supporting documents include:
- School Form 8 or SF8
- Learner height and weight records
- BMI computation records
- Feeding program beneficiary list
- Baseline nutritional status report
- Endline nutritional status report
- Section-level summaries
- Grade-level consolidated reports
- School health coordinator notes
- Accomplishment or narrative report, if required
Always follow your school or division instructions on what documents are required.
How to Customize the Template
You may customize the template based on your school’s reporting needs. Before editing, save a backup copy first.
You may update:
- School name
- School year
- Reporting period
- Region, division, and district
- Grade-level labels, if needed
- Section names
- Signatory names
- Printing layout
- Report title or subtitle
- Additional remarks or notes, if allowed
Avoid changing formula cells unless you are confident with Excel formulas.
Download the Free Automated Nutritional Status Report Templates
You may download the free Excel templates below.
Reminder: These files are sample automated templates only. Please check all formulas, validate your source data, and follow the reporting instructions given by your school, district, or division office.
Frequently Asked Questions
What is the Summary of Nutritional Status Report?
It is a consolidated report showing the nutritional status of learners by grade level, section, or school level. It helps school personnel organize and review learner nutrition data.
What is the source of data for this report?
The common source is School Form 8 or SF8, also known as the Learner’s Basic Health and Nutrition Report. Schools may also use other verified health and nutrition records as instructed by their school or division office.
Is this template automated?
Yes. The workbook includes built-in formulas and a summary sheet that helps consolidate data from grade-level sheets.
Is there a separate file for Elementary and Secondary?
Yes. The Elementary version includes Kinder to Grade 6 and SPED sheets. The Secondary version includes Grade 7 to Grade 12 sheets.
Can I edit the template?
Yes. The file is editable. However, be careful when editing formula cells, sheet names, rows, and columns because changes may affect the automatic summary.
Can this replace SF8?
No. This template does not replace SF8. It is a summary and consolidation tool that may use SF8 data as source.
Who should validate the nutritional status data?
Validation should be done by the appropriate school personnel, such as the school health coordinator, school nurse, adviser, or other assigned personnel, depending on your school process.
Can this be used for SBFP monitoring?
It may help organize nutritional status data for monitoring and reporting, especially when used with verified source records. Always follow the official SBFP and division reporting requirements.
Related Resources
You may also check these related school forms and teacher tools:
- Free Download Automated SF8 Learner’s Health and Nutrition Report
- Free Editable School Action Plan Sample for PMES Objective 2
- Free Editable Reading Remedial and Intervention Plan
- Free Reading Intervention Report Sample
Important Reminder and Disclaimer
This Automated Summary of Nutritional Status Report template is provided as a free editable educational resource only. It is not an official DepEd form unless adopted, required, or approved by your school, district, or division.
Users should validate all learner health and nutrition data before using the summary for reporting. Nutritional classifications should be based on verified source records, proper measurements, and the official tools or instructions provided by the appropriate school or division personnel.
Do not rely on the template alone for final health-related decisions. Always coordinate with the school health coordinator, school nurse, school head, or authorized personnel when preparing and submitting nutritional status reports.
Final Notes
An organized nutritional status summary can help schools monitor learner health data more efficiently. With separate grade-level sheets, a guide sheet, and an automated summary, this template can reduce manual work and make reporting easier.
Use the Elementary or Secondary version depending on your school level, encode carefully, and always verify your data before submission.