PNG, 70.07 KB
PNG, 70.07 KB
PNG, 39.34 KB
PNG, 39.34 KB
PNG, 65.7 KB
PNG, 65.7 KB
PNG, 14.85 KB
PNG, 14.85 KB
PNG, 26.68 KB
PNG, 26.68 KB
PNG, 36.35 KB
PNG, 36.35 KB
PNG, 27.88 KB
PNG, 27.88 KB
PNG, 26.09 KB
PNG, 26.09 KB
PNG, 28.77 KB
PNG, 28.77 KB
PNG, 24.31 KB
PNG, 24.31 KB
PNG, 19.32 KB
PNG, 19.32 KB
xlsx, 221.69 KB
xlsx, 221.69 KB
xlsx, 226.44 KB
xlsx, 226.44 KB
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

Reviews

2.6

Something went wrong, please try again later.

CMiddleton1

7 years ago
1

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.

Non-blonde

8 years ago
3

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.

DaviesY6

8 years ago
2

Hi guys I have the same issue as danmarie30, please could the author respond with a fix please :-)

danmarie30

8 years ago
2

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.

carlajw

8 years ago
5

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.