This pack comprises QLA (question level analysis) spreadsheets for the 2019, 2022, 2023 and 2024 KS2 SPaG SATs papers.
These are designed to work on Office 365 (please note that some formulae may not work if you are not using Office 365). A Google Sheets version is available in the How-to document (please use this if you do not have access to Office 365).
Record children’s names and marks and it will provide a detailed analysis, including:

individual child focus topics, focus groups by topic and class focus topics for SPaG
individual children’s levels
percentage of class that attained each level (as well as cusp children who are close to attaining the next level)
links to SATs smashers for each focus topic

...