2022 KS2 SATs Gap Analysis Spreadsheets – Maths, Reading & SPaG

This bundle includes Excel-based gap analysis spreadsheets for the 2022 KS2 SATs papers in Maths, Reading and Spelling, Punctuation and Grammar (SPaG). Each spreadsheet allows teachers to enter scores for a class of up to 30 pupils, with the flexibility to add or remove pupils as required.

All formulas are fully inbuilt, meaning teachers simply input marks while the spreadsheets automatically collate results. This provides a clear overview of strengths and areas for development across the cohort, helping teachers to identify patterns quickly and plan targeted teaching and intervention.

The spreadsheets have been designed to complement the 2022 SATs papers and mark schemes, supporting effective post-test analysis. While this bundle is not endorsed by the Department for Education or any national curriculum body, it has been created by a UK primary teacher to support colleagues during assessment, review, and planning.