In This Chapter
Creating the Lookup Table 106
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
The Age Standardized Scores are provided as an Excel spreadsheet.
The first row of the table consists of the Age, either in years and months or in months only, and the first column of the table consists of the Score.
The standardised scores are defined in the cells of the table.
The standardised scores use a mean of 100.
You can either copy the data from this spreadsheet to create the lookup table in SIMS Assessment, or you can create one yourself, typing in your own data.
To create the Lookup Table:
Select Focus | Assessment | Lookup Tables to display the Lookup Tables browser.
Click the New button to create a new table. The Lookup Table Details page is displayed.
Enter a Name for the Lookup Table (maximum 25 characters).
Enter any notes that you wish, to describe the table.
Specify the Type of aspect that will display the resulting data.
Enter the Age range as yy/mm of the pupil/students whose data you wish to compare.
State how the ages in the table are to be stepped. (For example, monthly would be 1, bi-monthly would be 2, etc.)
From the drop-down box select the Order of the Age columns as ascending or descending.
Enter the Score range.
State how the Scores in the table are to be stepped (for example, in increments of 1, 5, 10 etc.).
From the drop-down box select the Order of the Score rows as ascending or descending.