xlsm, 737.7 KB
xlsm, 737.7 KB

2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis
Requires Excel with macros enabled.

Summary of Features:

Questions Versus National compares the performance of your cohort against the performance of pupils nationally in each question. A powerful chart which instantly shows you which questions you are strong or weak on. As it uses national data, it considers the difficulty of each question, compares it the performance of your cohort and orders the results from strongest to weakest. 2016 to 2022 KS2 versions only, Q vs National will be added to the 2023 KS2 version at a later date.

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 for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers.

Contextual Analysis (2019 versions onwards) 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 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.

2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis

Get this resource as part of a bundle and save up to 28%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

2022 KS1 and KS2 Test and Question Level Analysis Pack

2022 KS1 and KS2 Test and Question Level Analysis Pack Includes all 2022 Analysis Tools for KS1 and KS2: * 2022 KS1 SATs Grammar, Punctuation and Spelling Test and Question Level Analysis * 2022 KS1 SATs Mathematics Test and Question Level Analysis * 2022 KS1 SATs Reading Test and Question Level Analysis * 2022 KS2 Grammar, Punctuation & Spelling Test and Question Level Analysis * 2022 KS2 Mathematics Test and Question Level Analysis * 2022 KS2 Reading Test and Question Level Analysis * 2022 Phonics Check Question Level Analysis Requires Excel with macros enabled. Summary of Features (please note some features may not be available depending on the test type): Questions Versus National compares the performance of your cohort against the performance of pupils nationally in each question. A powerful chart which instantly shows you which questions you are strong or weak on. As it uses national data, it considers the difficulty of each question, compares it the performance of your cohort and orders the results from strongest to weakest. 2016 to 2022 KS2 versions only, Q vs National will be added to the 2023 KS2 version at a later date. 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 for an individual pupils. Available in 2017 versions and later excluding reading. 2018 versions and later contain detailed feedback on each question. Useful for feeding back to pupils, parents and informing intervention teachers. Contextual Analysis (2019 versions onwards) 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. 2022 KS1 and KS2 Test and Question Level Analysis Pack

£60.00

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.