This pack comprises a QLA (question level analysis) spreadsheet for the 2019, 2022, 2023 and 2024 KS2 Maths 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 Past Paper QLA 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 both arithmetic and reasoning
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

...