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 - grammar, sentence strructure, phrases, verb forms, punctuation, vocabulary and standard English
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 - grammar, sentence strructure, phrases, verb forms, punctuation, vocabulary and standard English
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
Something went wrong, please try again later.
The problems are: Student SEN data from paper 1 isn't linked to paper 2. Paper 2 the % are not accurate.<br /> Overview 2016 GAPS analysis doesn't link at all except spelling and that is inaccurate. 'Pupil Results' Paper 2 data only says 1 mark even when more were entered on sheet 'paper 2'. Sheets 'G1 to G7' none are linked to the sheets 'paper 1' and 'paper 2'. All in all something has gone very wrong with this excel spread sheet.
I have downloaded this, but there are 4 questions that award 2 points yet the spreadsheet only allows 0 or 1 as a score. Questions 16, 30, 34 and 38 have 2 parts to the answers. This means the total and the scaled scores are not accurate.
Hi guys I have the same issue as danmarie30, please could the author respond with a fix please :-)
I've tried to use the spreadsheet set up for 60 pupils but it is not possible to enter the information for gender, SEN and PP status. Unlike the sheet for 30 pupils, you are not offered the correct options in the drop down menus, so it is unusable.
A fantastic resource which clearly shows you the gaps that need to be taught. Looking forward to the other ones!
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