Skip to main content

Part of National Child Measurement Programme 2021/22 IT system user guide part 3: Pupil data management

Identifying “very thin” and “severely obese” children in the combined extract

Current Chapter

Current chapter – 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

 

 

Last edited: 25 August 2021 7:38 am