KS2 Maths – Question Level Analysis

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.mathsqla

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.

Question Level Analysis (Sample Material) – Mathematics

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.


10 thoughts on “KS2 Maths – Question Level Analysis

  1. Elaine Parmiter 14 March 2016 at 7:11 am Reply

    This is very useful, thank you. Is there a password so we can unlock and input our class names?

    • Michael Tidd 14 March 2016 at 7:20 am Reply

      The class names can be put it on the first screen

    • Michael Tidd 14 March 2016 at 7:21 am Reply

      Hello, Just in case you do need it for anything, the password for the maths spreadsheet is Oasis

      Best wishes Michael On 14 Mar 2016 07:11, “Ramblings of a Teacher” wrote:


  2. Sally Olaru 14 March 2016 at 10:57 am Reply

    How do you add extra names in?

  3. Monika Mazur 14 March 2016 at 6:01 pm Reply

    There are some good free KS1 question level analysis tools on primarytools.co.uk for maths and grammar papers if they are of any interest.

  4. Abigail Greig 15 March 2016 at 10:44 am Reply

    Hi Michael. This may be the wrong forum on which to ask this, but when registering our children for the KS2 tests, how do we know if they are working below the standard of the test? In previous years, we would assess whether they were working below Level 3, but now, do we register them as below if they are working towards the national standard? Help!

    • Michael Tidd 15 March 2016 at 11:47 am Reply

      The guidance from the STA is that no *more* children should be not sitting the test than in the past, because the difficulty of the easiest questions has not changed. So arguably, the old <L3 rule still works.

  5. Georgina Cooper 23 March 2016 at 8:55 pm Reply


    I have added more names in to the first screen, but don’t know how to get this information to transfer to the other pages. Could somebody please let me know how to do this, thanks.

  6. Jaye Louise 11 October 2016 at 11:13 am Reply

    This is an amazing resource, thank you :D. Does anyone know of similar spreadsheet for the reading and grammar papers for the July 2015 samples?
    Many thanks in advance 🙂

  7. H Wallace 15 February 2017 at 8:04 pm Reply

    The spreadsheet is fabulous – thank you. Has anyone got the same for the actual 2016 SATs maths tests?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: