KS2  2018 SATs Maths Gap Analysis / Question Level Analysis (QLA)

These are excel spreadsheets Gap Analysis documents for the May 2018 Year Six SATs Papers for Maths (Arithmetic, Reasoning 1 and Reasoning 2).

The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.

If their total score for a subject goes green, it means they would have passed the 2018 SATs with that score. If it goes Purple with a white font, it means that child would have achieved a ‘More Able’ score for that tested subject.

I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.

All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.

The sheets are set up for 30 or 90 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken. This password will not be given out, but I am more than happy to make adaptations or changes for you, provided you show proof of purchase. All of my contact details are in the resource.

I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.

Please remember to rate this resource as I made this to save teachers time. Thank-you.

Save for later
  • Mathematics-SATS-2018-Gap-Grid-90-pupils.xlsx
  • Mathematics-SATS-2018-Gap-Grid-30-pupils.xlsx

About this resource


Created: May 29, 2018

Updated: Feb 11, 2019


xlsx, 515 KB



xlsx, 497 KB


Report a problem

Tes Paid Licence

How can I re-use this?