The Qualifications and Curriculum Authority (QCA) provides Age Standardised Scores, which you can use to measure a pupil/student’s mark or grade against the national average for their age.
Standardised scores take into account a child’s age in years and months, giving an indication of how each child is performing relative to other children of the same age. Age standardised scores do not affect the child’s test levels.
To measure a pupil/student’s mark or grade in this way, you first need to create the Lookup Table from the QCA data. You can then define the template, to include a Data Review column that contains the Lookup formula, and then a marksheet to enter, calculate and display the results.
Inserting a Lookup Formula on page 151
Entering and Reviewing Data using Marksheets on page 5