An excel spreadsheet for collating and analysing the sample SPaG test. It is linked with the KS2 programme of study reference and the grammar, punctuation and spelling reference codes. It is made for a class of up to 30 and can be used for analysing the gaps in their knowledge and /or understanding. If you need to add more pupils simply insert a row and the formulae should automatically adjust.


  • grammar analysis template.xls

About this resource


Created: Feb 7, 2013

Updated: Nov 22, 2013

Report a problem

This resource is designed for UK teachers. View US version .

12 Reviews

  • 5
    user avatarJPCRETONa year agoreport

    Just what I need. This will save me hours. Bless you. Check out my stuff - some of it may be of use to you. Cheers.

  • 5

    Thank you, this is great and has saved me so much time.

  • 5

    Really good for pupil tracking, thank you for sharing with others.

  • 4
    user avatardanob572 years agoreport

  • 3
    user avatarsquggle3 years agoreport

    Thank you