AQA English Language Data Collation Spreadsheet aka "The Machine"

Attached is a spreadsheet that does an awful lot of work for you. To summarise, it does the following:

Allows for easy collation of GCSE Language marks on a paper by paper basis AND as a whole examination
Allows for easy identification of various student demagraphics - EAL, PP and so on
Allows you to measure progress against students best, average and last marks across both papers
Works out "how many marks" until you hit target grades for individual students
Colour codes grades and marks to allow for at a glance progress checks

Once you buy this spreadsheet, you will not need to get another LANGUAGE spreadsheet. The document contains instructions on the ARRAY tab as to how to update .

Oh, and if you do get this, I suggest you LOCK the individual spreadsheets ASAP: the document is set up to allow you to do this and still enter the data, you just won't be able to accidentally delete any of the coding, thus removing any brain overloads that might ensue.

I am using this at my current school and there are several other schools who are using this system with good reports.

Happy spread-sheeting!

PS - Yes, there is a page that reads exactly the same but for a version that caters for the AQA Literature course. The spreadsheets are different. Here's the link/address to the LITERATURE version:

https://www.tes.com/teaching-resource/aqa-english-literature-data-collation-spreadsheet-aka-the-machine-11405407