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

This Excel-based gap analysis spreadsheet is designed to support teachers in analysing pupil performance in the 2019 KS2 Maths SATs papers (Arithmetic and both Reasoning papers).

Teachers can quickly enter marks for each pupil and instantly see a clear picture of strengths and areas for development across the class, making it ideal for targeted intervention planning and post-test analysis.

What this resource does

• Compatible with the 2019 National Curriculum KS2 Maths SATs papers

• Allows teachers to enter individual pupil marks for each question

• Automatically collates scores and highlights patterns across the cohort

• Uses RAG colour-coding to clearly identify strengths and gaps

• Provides a low-cost alternative to paid assessment software

Key features

• Automatic colour-coding: 0 marks appear red; full marks appear green; partial marks (for 2- or 3-mark questions) appear yellow.

• Row totals are colour-coded to show highest and lowest scores

• Question-level analysis at the bottom of each sheet highlights which questions were strongest and weakest for the class

• 2- and 3-mark questions are weighted fairly so they do not distort the overall analysis

Spreadsheet structure

• Four tabs in total: Paper 1: Arithmetic; Paper 2: Reasoning; Paper 3: Reasoning; Overall totals tab

• Brief question descriptions are shown at the top and beneath totals to make analysis quick and intuitive

This spreadsheet makes gap analysis quick and visual, allowing teachers to clearly identify strengths and areas for development across a class. It supports targeted teaching and intervention by highlighting patterns at question level and is easy to use - simply enter pupil names and marks. The resource is reusable year after year and is particularly useful for Year 6 teachers and maths leads.

This resource is designed to support assessment and analysis of the 2019 KS2 Maths SATs papers. It is not endorsed by the Department for Education and has been created by a UK primary teacher to support colleagues during assessment and review.