As so many schools have evidently used the sample tests to help ascertain their pupils’ progress towards the expected standard (whatever that might be), I’m sure many will welcome the opportunity to analyse the outcomes.
Emily Hobson, (@miss_hobson) of Oasis Academies, has kindly agreed to share the template she put together for analysing the KS2 tests.
The spreadsheet can be downloaded below, and then data entered to scrutinise your pupils’ progress in the main areas, and for each question.
Names need only be entered onto the first page; these will then carry across to later pages.
You can also adjust the % thresholds on the first page, and these will be reflected in the colour bands marked for each pupil.