Part of National Child Measurement Programme 2024/25 IT system user guide part 3: Pupil data management
Identifying “very thin” and “severely obese” children in the combined extract
The BMI categories “very thin” and “severely obese” are flagged in the pupil grid but not currently included in the combined extract.
You can identify these children in the Combined extract using the following steps:
1. Produce a “Combined” extract for more information read the Exporting pupil data files section of this guide.
2. The BMI centile is provided in column X:
3. Very thin” is defined as a BMI centile of less than or equal to 0.4 and “Severely obese” is defined as a BMI centile of greater than or equal to 99.6.
4. The following formula can be added to the extract in cell AA2 to automatically identify these records:
=IF(X2<=0.4, "Very thin", IF(X2>=99.6,"Severely obese",""))
5. Drag this formula down to the final record in the extract.
Contact us
Last edited: 19 October 2023 2:36 pm