xlsx, 139.32 KB
xlsx, 139.32 KB
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

Get this resource as part of a bundle and save up to 56%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.