GCSE English - Spreadsheet for P1 Q1-4 Progress Tests (generates feedback sheets automatically)

This will be of use if you have done a progress test focusing on Paper 1 Q1-Q4.

I’ve created the attached spreadsheet (the template file) which enable you to enter marks and generate grades for the students. The grade boundaries are from November 2018 but you can adapt this spreadsheet easily to other papers.

Student names and numbers need to be entered on to the front sheet - as well as the marks for each question. This will generate an overall grade for the students and count how many get each grade in your class.

I’ve added a bit more functionality, though. Once the grades have gone in, they generate a progress report for each student which can be used as a feedback sheet. The mark that they get for each question generates a comment about it…

You will need to add a comment on each of these but I have put 30 examples of comments on the second sheet in the spreadsheet which you could adapt, copy and paste…

You will also need to do a comment on attendance, punctuality and behaviour using drop down lists (at the bottom of each student sheet).

Please feel free to use, adapt and so on!