This Formula will copy the contents of a selected column into another column.
Select Equalsfrom the Formula Typedrop-down list.
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.
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 Datachapter 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 Aand can be imported into SIMS Analysis from the SIMS .netfolder.
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.
Select Predictionfrom the Formula Typedrop-down list.
For this example, select Progression Linefrom the Trend Linedrop-down list.
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.
Choose the column (please see Selecting Column/Constant Values on page 142). The Progression Line will analyse this column.
To use a Value Added Line: select Value Added Linefrom the Trend Linedrop-down list.
Click the LineBrowser button to display the Value Added Line Browser.
Select the required Value Added Line and click the Update button to return to the wizard.
Choose the column, as in step 6 above.
Select one of Lower Quartile, Medianor Upper Quartilefrom the Percentiledrop-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).
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.
These descriptions are entered in the Ethnic/Culturalpanel of the Studentpage in SIMS.
NOTE: The Study Welsh formula must be defined in a Data Review column. Define a Heading for the Column.
Select Study Welsh from the Formula Type drop-down list.
Click the Finish button.
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.
From the Template Details page, click the Categories hyperlink or scroll down the page to view the Categoriespanel.
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.
Click the Savebutton on to save the Category associations.