2023 KS1 SATs Mathematics Test and Question Level Analysis

2023 KS1 Mathematics Test and Question Level Analysis
Requires Excel with macros enabled.

Summary of Features (please note some features may not be available depending on the test type):

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.

Pupil Reports show a summary of performance in each strand and per question for an individual pupils. Useful for feeding back to pupils, parents and informing intervention teachers.

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.

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.

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.

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.