Getting Started In This Chapter



Download 14.49 Mb.
Page50/209
Date conversion08.07.2018
Size14.49 Mb.
1   ...   46   47   48   49   50   51   52   53   ...   209

Creating Lookup Tables

In This Chapter


Introduction 105

Creating the Lookup Table 106
  1. Introduction


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.


More Information:

Inserting a Lookup Formula on page 151

Entering and Reviewing Data using Marksheets on page 5
      1. Data Format


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.


    1. Creating the Lookup Table


To create the Lookup Table:

  1. Select Focus | Assessment | Lookup Tables to display the Lookup Tables browser.



  1. Click the New button to create a new table. The Lookup Table Details page is displayed.



New button



  1. Enter a Name for the Lookup Table (maximum 25 characters).

  2. Enter any notes that you wish, to describe the table.

  3. Specify the Type of aspect that will display the resulting data.

  4. Enter the Age range as yy/mm of the pupil/students whose data you wish to compare.

  5. State how the ages in the table are to be stepped. (For example, monthly would be 1, bi-monthly would be 2, etc.)

  6. From the drop-down box select the Order of the Age columns as ascending or descending.

  7. Enter the Score range.

  8. State how the Scores in the table are to be stepped (for example, in increments of 1, 5, 10 etc.).

  9. From the drop-down box select the Order of the Score rows as ascending or descending.
1   ...   46   47   48   49   50   51   52   53   ...   209


The database is protected by copyright ©dentisty.org 2016
send message

    Main page