Just as term ended, Tim Clarke (@tim_jumpclarke) sent me an excel spreadsheet he had created to record assessment against the key objectives for Maths and Writing and Reading.
After a few emails and a bit of tweaking, we’re releasing what will hopefully be a useful tool for schools choosing to use the Key Objectives approach. For each subject there is a spreadsheet covering all year groups (although it would, of course, be possible to combine sheets from different files to put, say all the Y5 pages into one document).
For each subject and year group, there is a list of objectives and a grid into which the numbers 1, 2 or 3 can be entered (representing, say ‘Working Towards’, ‘Achieved’ and ‘Exceeded’, or whatever such terminology as you choose to use). The cells change colour, and importantly the summary at the foot of the column does too, to represent the number of points scored. The percentage values for these can be set for your school. (The default is that 50% of points awarded turns orange; 75% turns green)
The files can be downloaded from here:
(The booklets of key objectives are available on this page)
For those schools considering a mastery approach to mathematics, I have also created an adapted version into which the value 2 is deemed to be “mastered”. The totals at the bottom of each column in this case calculate the number of objectives which have been deemed to be mastered, changing the colour according to the percentage of objectives mastered (rather than just by an average of point scores). This version can also be downloaded: