Spreadsheet: 027432bf-73a7-4dbc-ad93-22e776219aeb
Sheet: Sheet1

School Building BMI Collection Tool
This tool is for use by the schools and should be submitted to the school district only.
Senate [NAME] (SB 210) Healthy Choices for Healthy Children Legislation requires the Ohio Department of Health (ODH) to receive body mass index (BMI) data for students in grades K, 3, 5 and 9, for each school district or non-public school.  This workbook was developed to assist with data collection and is based on the Centers for Disease Control and Prevention (CDC) Children's BMI Tool for [NAME], which may also be used for data collection. The variables to be collected are: [NAME], Sex, Date of Birth, Date of Measurement, Height, Weight, BMI, and BMI Percentile (%ile). The required variables to be submitted to the school district are: [NAME], Sex, and BMI %ile.  Please note: the CDC tool does not include a column for grade level, which must be added to the "DISTRICT SUMMARY" worksheet prior to submission. Once you have collected and recorded the data, forward the "DISTRICT SUMMARY" worksheet or this workbook to your school district based on your district's recommendations. The school district will combine the Grade Level, Sex and BMI %ile data from your school building with other school buildings in your district to submit to ODH.  Please contact your district representative for instructions on transferring data to the district. *If you are a chartered non-public school, send only the "DISTRICT SUMMARY" worksheet directly to ODH.
Note: This tool was created in Microsoft Excel version 97-03.  Some of the features in this workbook will not be supported by earlier versions of Excel.  If the "Compatibility Checker" box appears when working with or saving this file, click "Continue."
1. This Excel workbook (School Building BMI Collection Tool.xls) has 3 worksheets, titled "INSTRUCTIONS," "MEASUREMENTS" and "DISTRICT SUMMARY."  You can move to each of these using the tabs at the bottom of the screen.  The "MEASUREMENTS" worksheet is where children's measurements are entered.  The "DISTRICT SUMMARY" contains the data that must be submitted by the District to ODH (Grade Level, Sex, BMI %ile). No data entry is necessary in the "DISTRICT SUMMARY" worksheet if the "MEASUREMENTS" worksheet in this tool is used for data collection.
2. Before entering any data, save this Excel workbook with a new name.  The new name should be in the following format: "(School Name) BMI Collection Tool MMDDYY".  For example, "Washington Elementary BMI Collection Tool 050111".  To do this, click "Save As," select "[NAME]," select where you would like to save your data (e.g., C:\BMI) and enter the new file name in the "File Name" box.
3. Enter your school name at the top of the "MEASUREMENTS" worksheet.  This field MUST be completed for district use only.
4. Enter information on Grade Level, Sex, Date of Birth, Date of Measurement, Height, and Weight into the "MEASUREMENTS" worksheet.  ID and Name are optional.  An example is provided at the bottom of this page.
5. Enter the child's current grade in the "Grade Level" column.  Enter "K" for kindergarten, "3" for 3rd grade, "5" for 5th grade, and "9" for 9th grade.  A drop-down list is provided.
6. Enter the child’s sex in the "Sex" column using “M” to indicate male or “F” to indicate female.  A drop-down list is provided.
7. Enter the child’s date of birth in the "Date of Birth" column, using month/day/year format.  For example, July 17, 1996, would be entered as 7/17/1996.
8. Enter the child’s date of measurement in the "Date of Measurement" column, using month/day/year format.  For example, October 5, 2007, would be entered as 10/5/2007. The child's age must be less than 20 years.
9. Enter the child's height in feet in the "Feet" column.  If applicable, enter the child's height in inches to the nearest 1/8 inch (1/8, 1/4, 3/8, 1/2, 5/8, 3/4, 7/8) in the "Inches" column.  For example, a height of 4 feet and 7 3/8 inches would be entered as "4" in the "Feet" column and "7 3/8" in the "Inches" column.
10. Enter the child's weight in pounds to the nearest 1/4 pound (1/4, 1/2, 3/4) in the "Weight" column.  For example, 56.75 pounds or 56 3/4 pounds would be entered as "56 3/4."
11. Use the Centers for Disease Control and Prevention "BMI Percentile Calculator for Child and Teen," available at: http://apps.nccd.cdc.gov/dnpabmi/Calculator.aspx to calculate the child's BMI and BMI percentile.  Enter all information as requested and click "Calculate." Enter the resulting BMI in the "BMI" column and the resulting BMI percentile in the "BMI %ile" column in the "MEASUREMENTS" worksheet.
http://apps.nccd.cdc.gov/dnpabmi/Calculator.aspx
to calculate the child's BMI and BMI percentile.  Enter all information as requested and click "Calculate." Enter the resulting BMI in the "BMI" column and the resulting BMI percentile in the "BMI %ile" column in the "MEASUREMENTS " worksheet.
12. The "MEASUREMENTS" and "DISTRICT SUMMARY" worksheets are designed to collect data for up to 2,000 children. If additional lines are needed, highlight the last row in each worksheet (above the blue line), right click the mouse, and select insert.
13. When the data for all participating children in your school have been entered, send the data to your school district (not ODH or the Ohio Department of Education) according to your district's recommendations. Please note: School districts are required to submit data to ODH by June 1 of the current school year. *If you are a chartered non-public school, send only the "DISTRICT SUMMARY" worksheet information directly to ODH by June 1 of the current school year at [EMAIL].
Measurements
District Summary