2024 KS2 SATs Mathematics Test and Question Level Analysis

2024 KS2 Mathematics Test and Question Level Analysis

Requires Excel with macros enabled.

Summary of Features

• Pupil Summary shows total marks for each paper, number of questions unanswered (possibly indicating need to increase pace), number of incorrect answers, total overall score (and percent), total score in each strand. Option to adjust the colour thresholds to make it easier to spot patterns and gaps. All Versions from 2016.
• Pupil Reports show a summary of performance in each strand for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers. All Versions from 2016.
• Contextual Analysis shows a breakdown by key groups (gender, SEND status, disadvantaged, EAL) plus up to four custom groups. Compares school data (grades and scaled scores) to national data in a detailed but user-friendly report. All Versions from 2016.
• Cohort Summary shows an overview of the cohort against each strand. This is also compared to national data where it is available. This page gives a summary of attainment including number and percent at expected and higher standard. All Versions from 2016.
• Strand Summary shows a the weighting of each strand and the performance within it. For example, in a grammar test a cohort may perform poorly in identifying sentence types and equally poorly in identifying punctuation. However as there is more weighting given to punctuation, it would be advisable to focus on this area. All Versions from 2016.
• Other Charts Charts which show performance for each question, organised by most correct to incorrect, by strand and also by year group question (for mathematics). The most powerful chart orders questions from most correct to incorrect enabling you to see precisely where there are strengths and weaknesses. All Versions from 2016.