Getting Started In This Chapter

Copying Data from the Spreadsheet

Download 12.14 Mb.
Size12.14 Mb.
1   ...   47   48   49   50   51   52   53   54   ...   209

Copying Data from the Spreadsheet

  1. Open the Excel spreadsheet containing the Age Standardised Scores.

  1. Select the cells containing the score data (including the row and column descriptors) and copy them (Ctrl+C).

  2. Return to SIMS Assessment and click the Paste button to paste the data into the Lookup Table.

    Paste button

  3. 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.

      1. Entering Data Manually

To enter data into the Lookup Table manually:

  1. Click the Apply button to populate the grid with the stepped Ages and Scores that you have already defined.

Apply button

The Ages show as column headings and the stepped Scores will display down the side, one per row.

  1. You can then enter the required standardised scores into each cell of the grid.

  2. 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.

  1. To move rows up or down, click in the required row and click the Up or Down button, adjacent to the Lookup Table.

Up button

Down button
      1. 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:

  1. Scroll down or click the Categories hyperlink to display the Categories panel.

  1. Click the + or symbols to expand or contract the Category Types as necessary.

  2. Choose the required Category or Categories by selecting the adjacent check box(es).

  3. Click the Save button to save the Category associations.

More Information:

Creating and Maintaining Categories on page 81

  1. Share with your friends:
1   ...   47   48   49   50   51   52   53   54   ...   209

The database is protected by copyright © 2019
send message

    Main page