Getting Started In This Chapter



Download 14.49 Mb.
Page75/209
Date conversion08.07.2018
Size14.49 Mb.
1   ...   71   72   73   74   75   76   77   78   ...   209

Inserting a Plus Formula


This formula will add a chosen number to the number found in a Marks column.

This might be used for target setting. For example, you might add the value 10 to the Mark achieved this term and display it in a column as the target for next term’s mark.



  1. Select Plus from the Formula Type drop-down list.

  2. Choose the column (please see Choosing a Selection of Columns on page 143) (e.g. Spanish Marks).

  3. Enter the number you wish to add to the selected column value (e.g. 10).

NOTE: When reference is made to an empty cell in a marksheet, a blank outcome is generated.
      1. Inserting an Equals Formula


This Formula will copy the contents of a selected column into another column.

  1. Select Equals from the Formula Type drop-down list.

  2. Choose the column (please see Selecting Column/Constant Values on page 142) (e.g. Spanish Marks).

NOTE: When reference is made to an empty cell in a marksheet, a blank outcome is generated.
      1. Inserting a Prediction Formula


This formula produces a predicted outcome by using either a Progression Line Value or a Value Added Line, to analyse an input score.

NOTE: Before proceeding, you must make sure that the Trend Line you wish to use has been imported into SIMS Analysis. For more information, please see the Importing and Exporting Data chapter in the Analysis in SIMS handbook.

In the following example we will select the Progression Line that uses the Average Key Stage 2 Point Score to predict pupils’/students’ Key Stage 3 Maths Level. This Progression Line is called 02QCA K2 Av Pt-K3 Ma Lv A and can be imported into SIMS Analysis from the SIMS .net folder.



  1. Before selecting the Prediction formula column you should have added a column to hold the input score (i.e. the data the Progression Line will analyse). In this example, a Data Entry column (KS2: Average Points Score), which holds each pupil/student’s Average Points Score, has been added already.

  2. To add the formula column, name the column heading that will hold the predicted outcome.

  3. Select Prediction from the Formula Type drop-down list.

  4. For this example, select Progression Line from the Trend Line drop-down list.

  5. Click the Line Browser button to display the Progression Lines Browser. Select the required Progression Line and click the Update button to return to the wizard.

  6. Choose the column (please see Selecting Column/Constant Values on page 142). The Progression Line will analyse this column.

  7. To use a Value Added Line: select Value Added Line from the Trend Line drop-down list.

  8. Click the Line Browser button to display the Value Added Line Browser.

  9. Select the required Value Added Line and click the Update button to return to the wizard.

  10. Choose the column, as in step 6 above.

  11. Select one of Lower Quartile, Median or Upper Quartile from the Percentile drop-down list.

In the example that has been used, you would also need to add a Marks to grade formula column, which uses the KS3 Test Levels grade set, in order to convert the predicted points column (Marks aspect) to a Test level (grade aspect).

Once a group has been attached to this template, this is how the marksheet would appear.

The first column, KS2: Average Points, is a Data Entry column and would be the column analysed by the Prediction formula.

The Prediction formula column is a formula Data Review column and has been made a hidden column.

The second column displayed, Predicted KS3 Maths Level, is a formula Data Entry column and takes the points in the formula column and converts them to a grade (i.e. predicted Maths Level). This column has not been made Read-only, so that the teacher can edit the predictions.

Alternatively, you could make this column Read-only and add another Data Entry column for teacher predictions.


      1. Inserting a Study Welsh Formula


The Study Welsh formula is only for schools in Wales, although it is visible to other schools. The formula displays the Taught Welsh at School code for each pupil/student. These codes are:


Code

Description

1

Taught Welsh as a first language

2

Taught Welsh as a second language

3

Taught other Welsh

4

Not taught Welsh at all

5

Disapplied from curriculum by SEN statement

These descriptions are entered in the Ethnic/Cultural panel of the Student page in SIMS.

NOTE: The Study Welsh formula must be defined in a Data Review column.

  1. Define a Heading for the Column.

  2. Select Study Welsh from the Formula Type drop-down list.

  3. Click the Finish button.
    1. Associating Templates with Categories


In order to make it easier to find templates and marksheets in their respective browsers, it is possible to associate a template with one or more Categories. Any marksheets associated with the template will also inherit the associations with the Categories.

  1. From the Template Details page, click the Categories hyperlink or scroll down the page to view the Categories panel.



  1. Expand the Category Types as necessary and select the Category or Categories with which you wish to associate the template. For example, you might associate the template with the Arts Category or Year 7 Category, or both.

  2. Click the Save button on to save the Category associations.
1   ...   71   72   73   74   75   76   77   78   ...   209


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

    Main page