Children's BMI Tool for Schools
Assessing Your Weight: Children's BMI Tool for Schools
The Children's BMI Tool for Schools is an Excel spreadsheet intended for use by school, child care, and other professionals who want to compute Body Mass Index (BMI)-for-age for a group of up to 2000 children, for example a school class room or grade.
This calculator computes BMI and BMI percentiles for individual children in a group using height and weight measurements, sex, date of birth, and date of measurement information that you enter, or import from a spreadsheet or data file. It provides a group summary of children's BMI-for-age categories and graphs for Prevalence of Overweight and Obesity, and Prevalence of Overweight and Obesity by Sex.
This calculator is an Excel spreadsheet that can be downloaded onto your computer. To allow all of the features of this calculator to work, please click "Enable Macros" if prompted when you open the application. The spreadsheet has 3 worksheets entitled "INSTRUCTIONS", "MEASUREMENTS", and "GROUP SUMMARY". You can view each of these using the tabs at the bottom of the window.
Note: A new version was posted on September 13, 2010 with updates to the instructions for newer versions of Microsoft Excel.
Body Mass Index Measurements in Schools
This guidance document describes the purpose of school-based BMI surveillance and screening, examines current practices, summarizes the recommendations of experts, identifies concerns surrounding programs, and outlines needs for future research. Guidance is provided on specific safeguards that need to be addressed before schools decide to collect BMI information.
Description: Microsoft Excel is a spreadsheet program
used to calculate, analyze, and store data. Text in Excel files can be
easily modified or copied for use in other applications.
File extensions: .xls
Viewing: If you do not already have Excel, you can download Excel Viewer for free*.