AQA English Literature 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 Literature 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 LITERATURE spreadsheet. The document contains instructions as to how to update the spreadsheet.

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.

Happy spread-sheeting!