SPaG spreadsheet analysis

author avatar

You’re downloading this resource from snowdropfox


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
Download Icon


grammar analysis template

xls, 37 KB

Role details
CreatedFeb 7, 2013
UpdatedNov 22, 2013

12 Reviews

  • 5
    user avatarJPCRETON7 months 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
    user avatarpennybickley9 months agoReport

    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 avatarsquggle2 years agoReport

    Thank you

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