simply enter the scores for each child for each question for the 2016 SPAG test, their gender, SEN and PPg status and the spreadsheet will give you:
a breakdown of each question percentage
the percentage overall, boys and girls for each area - meaning, retrieval, inference, prediction, content, words and phrases and comparison.
overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN
ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development
Links to resources
GaPS
https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084
Maths
https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237
Reading
https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959
All 3 spreadshseets
https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970
a breakdown of each question percentage
the percentage overall, boys and girls for each area - meaning, retrieval, inference, prediction, content, words and phrases and comparison.
overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN
ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development
Links to resources
GaPS
https://www.tes.com/teaching-resource/detailed-analysis-of-2016-sats-grammar-punctuation-and-spelling-test-11313084
Maths
https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-maths-2016-sats-test-11314237
Reading
https://www.tes.com/teaching-resource/detailed-question-level-breakdown-and-analysis-of-2016-sats-reading-test-11314959
All 3 spreadshseets
https://www.tes.com/teaching-resource/detailed-question-level-breaskdown-and-analysis-of-2016-sats-gaps-reading-and-maths-test-11314970
Get this resource as part of a bundle and save up to 33%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
The review below is speaking about the mathematics analysis, from what I can see there are no faults with the reading analysis. I think it is a good resource and has saved me a lot of time and effort creating some thing similar myself.
Breaks questions down into all the usual groups, however, there are errors in the commands relating to Reasoning Paper A. It only calculates cell 60-64, when totalling responses, instead of 5-64; I've gone through and changed each 60 to 5 (which took a long time!) The questions are also incorrectly numbered in the 'ReA Qns' tab, but there are correct in the 'Reasoning A' and 'Qn Type' tab. Use with caution!! This is the first time I've bought a download from the website, I'll think twice before doing so again.
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.
£3.00