xlsx, 116.37 KB
xlsx, 116.37 KB

This mark book is based on the new specification AQA GCSE English Literature (8702) qualification with the 2019 grade boundaries. In it, I have broken the qualification down so that there is a column for each question for you to input the marks to. The mark book will then automatically generate a fine grade for each section of the paper and a separate grade for each paper overall. The mark book will then generate an overall total and fine grade for the qualification as a whole (paper one and paper two).

In case you are unfamiliar with the term, a fine grade splits each grade (9-1) into three:
5a - The top end of a grade 5, almost working at a grade 6
5b - A secure grade 5
5c - The bottom end of a grade 5, almost slipping the grade 4 boundaries

The grade boundaries were calculated based on the August 2019 results from the 2019 GCSE exam series.

I have also included a row that works out the class average which is useful for comparing sets within the department, or for working out which question/section needs more work, or just to give the students a reference point for how well they did.

This can be used as an individual mark book or for the whole department, simply copy the ‘English Literature Mark Book’ tab to replicate the mark book and all of its formulas for each class in thee year group.

You can find a copy of my GCSE English Language mark book here: goo.gl/L98vmk

Please also take a look at my other resources.
Any feedback would be greatly appreciated.

Reviews

5

Something went wrong, please try again later.

sparkyboo

6 years ago
5

Very useful and takes the hassle out of formulas. Thank you.

gemmaec

7 years ago
5

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.