12 Point ‘On Track’ Analysis Marksheets

On Track Analysis Screenshot (pupil names have been cropped off the left hand side)

I’ve been working with a few schools recently to develop a set of marksheets that we’ve called ’12 Point On-Track’ marksheets. The aim of these marksheets is to highlight KS2 pupils who are not making the expected progress to 12 points. You can see an example of this kind of marksheet above.

The marksheets work on the basis of pupil having to reach a given threshold to be considered as ‘on track’ to attain 12 points. For example, a pupil in the summer term of year 4 should have achieved 6 points of progress to be considered ‘on track’. In the screenshot above, a group of year 5 pupils in the spring term is considered ‘on track’ if they have achieved 8 points of progress.

Columns from left to right:

1. each pupil’s KS1 results (columns 1-3)
2. the English KS1 result, calculated automatically as the average of Reading and Writing (column 4)
3. each pupil’s most recent assessment in Maths, Reading and Writing (columns 5-7)
4. the most recent English result, calculated as the average of Reading and Writing (column 8)
5. the number of points progress since KS1 is then calculated for English and Maths (columns 9 and 10)
6. if the pupil has made the threshold value in Maths, column 11 displays a yellow ‘=’ (equals)
7. if the pupils has not made the threshold value, column 11 displays a red ‘-‘ (minus)
8. otherwise column 11 displays a green ‘+’ (plus)
9. column 12 displays the same colour code as per column 11 but this time for English
10. column 13 compares both previous columns and displays a green ‘2’ is the pupil is making the required progress in both English and Maths, a yellow ‘1’ if they are making progress in just one subject or a red ‘0’ if they are not making progress in either subject.
11. The remaining columns use thresholds to indicate if the pupil is on track to attain a level 4 or a level 5.

The great thing about these marksheets is that there’s no extra data to input as all the data is already input via other marksheets. Senior leaders just need to press the ‘calculate’ button and all the data flood-fills the columns. All the columns are defined as grade aspects, so right clicking the column heading allows users to display the grade distributions – instantly displaying what percentage of pupils are on track. This example is for KS2 pupils, but the same principle can be adapted for KS1 and KS3.

Next month I’ll upload a screencast of these marksheets in action.

If you want more information, feel free to contact me.