KS2 Maths SATs 2023 – Gap Analysis Spreadsheet (Year 6)

This editable spreadsheet provides a clear question-level gap analysis of the 2023 KS2 Maths SATs, designed to help Year 6 teachers quickly identify strengths, weaknesses and priority areas.

Each SATs question is clearly labelled by mathematical skill, making gaps visible at skill level rather than relying on broad strand averages.

The spreadsheet is set up for a class of 30 pupils, with all question codes and calculations already built in. This can be easily tweaked to suit different cohort sizes if required.

Features

Question-level analysis of the 2023 Maths SATs papers

Each question labelled by mathematical skill

Automatic calculation of scores, percentages and RAG ratings

Clear visual layout to highlight patterns and gaps

Fully editable

No formulas need editing – simply enter pupil scores for each question

Ideal for Year 6 teachers, maths leads and SLT looking for a quick, reliable way to analyse SATs outcomes and plan targeted intervention.