TP Maths Actual Spr column) against set targets (the TP Maths Target column), using the CES Tracking Progress MathsYear 3 marksheet.
A range of colours is used to indicate pupil/student progress against target. A red background indicates the pupil/student is performing below target, yellow for pupil/students performing against target and green for those exceeding target.
Select Nested If Then Else from the Formula Type drop-down list.
Choose the IF Columnvalue (please see Selecting Column/Constant Values on page 142).
In this example, select TP Maths Actual Spr as the Column value.
Select the Comparatorfrom the drop-down list, such as >, >=, =, etc.
In this example, select <, to identify pupil/students performing below target.
Choose the Column/Constant to compare against on the right-hand side of the screen.
In this example, select TP Maths Target to identify pupil/students whose scores in the TP Maths Actual Spr column are less than the target set in the TP Maths Target column.
Select the THENcolumn/constant. If you want to go directly to the ELSE clause having selected a THEN clause, enter a full stop or similar character (because you cannot leave the field blank). Colour coding can also be applied by clicking the Field Browserbutton adjacent to the Colour field and selecting a colour. For this example, enter – as the Column Constant and red as the Colour to display the following screen.
Click the OK button to return to the Formula Details dialog.
Repeat steps 2 through 6 as required, to enter up to a maximum of 4 comparisons using the ELSE IF and THEN fields, then enter the final ELSE column/constant, if required.
For this example, set up an ELSE IF statement using the same columns/constant values as before with a Comparator of = and a THEN statement of = and colour it yellow. Set up another ELSE IF statement using the same columns/constant values as before with a