The Lookup Table is populated with the data from the spreadsheet. The Age must be in the format yy/mm. If not, you cannot save the table.
Entering Data Manually
To enter data into the Lookup Table manually:
Click the Apply button to populate the grid with the stepped Ages and Scores that you have already defined.
The Ages show as column headings and the stepped Scores will display down the side, one per row.
You can then enter the required standardised scores into each cell of the grid.
To add, edit or delete a column or row, right-click anywhere in the grid to display a pop-up menu. Select the required option. Rows are always added at the bottom and columns are always added at the far right.
Selecting Edit Row or Edit Column from the pop-up menu enables you to edit the column or row heading only. To edit the content, just click in the appropriate cell and type the changes.
To move rows up or down, click in the required row and click the Up or Down button, adjacent to the Lookup Table.
Associating the Lookup Table with a Category
A Lookup Table can be associated with one or more previously defined Categories. This enables the subsequent view of Lookup Tables to be filtered by Category e.g. only show Maths Lookup Tables, only show Reading Age Lookup Tables, etc.
To assign a Lookup Table to one or more Categories: