Skip directly to search Skip directly to A to Z list Skip directly to navigation Skip directly to site content Skip directly to page options
CDC Home

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.

Microsoft Excel 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*.

Contact Us:
  • Centers for Disease Control and Prevention
    1600 Clifton Rd
    Atlanta, GA 30333
  • 800-CDC-INFO
    TTY: (888) 232-6348
  • Contact CDC-INFO The U.S. Government's Official Web PortalDepartment of Health and Human Services
Centers for Disease Control and Prevention   1600 Clifton Rd. Atlanta, GA 30329-4027, USA
800-CDC-INFO (800-232-4636) TTY: (888) 232-6348 - Contact CDC-INFO