Year 6 CGP Sats 2016 Set A Gap Analysis Maths and SPAG
An Excel spreadsheet to allow you to enter which child got which question right and then work out where the gaps lie in your class' knowledge. This one is set for a year group of 35. To amend, just change the formula in the percentage cells from CELL/35*100 to CELL/your number*100. Will total score for each Maths paper and then add together. There is a sheet at the back for SPAG. There is a column for you to enter the standardised score from the total.
Save for later
  • Gap-Analysis-KS2-CGP-Set-A-Sats-Master.xlsx

About this resource


Created: Dec 15, 2016

Updated: May 4, 2017


xlsx, 39 KB


Report a problem

Tes Paid Licence

How can I re-use this?