2023 KS2 SATs Gap Analysis Spreadsheets – Maths, Reading & SPaG (Year 6)

This bundle includes gap analysis spreadsheets for the 2023 KS2 SATs across Maths, Reading and SPaG, designed to help Year 6 teachers quickly identify strengths, weaknesses and priority areas.

Each spreadsheet is set up for a class of 30 pupils, with all question numbers, skills and calculations already built in. Analysis is presented at question and skill level, making gaps clear and supporting targeted teaching and intervention.

The resources are compatible with the 2023 KS2 SATs papers but have not been officially endorsed. They are practical tools designed and used by a Year 6 teacher, shared in the hope they may be useful to others.

Fully editable (Excel / Google Sheets compatible). Simply enter pupil scores — no formulas need editing.