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: The English version was updated on April 2, 2009, to fix a decimal entry problem.
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.
Microsoft Excel
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*.
- Page last reviewed: April 2, 2009
- Page last updated: April 2, 2009
- Content source: Division of Nutrition, Physical Activity and Obesity, National Center for Chronic Disease Prevention and Health Promotion
Contact Us:
-
Division of Nutrition, Physical Activity and Obesity
4770 Buford Highway, NE, MS/K-24
Atlanta GA 30341-3717 - 800-CDC-INFO
(800-232-4636)
TTY: (888) 232-6348
24 Hours/Every Day - cdcinfo@cdc.gov