xlsx, 25.02 KB
xlsx, 25.02 KB

Designed on Microsoft excel, this tracking document will help you keep track of the progress of your KS4 students, with specific columns for each of the questions on the exam paper. The sheet will auto calculate INDIVIDUAL GRADES FOR EACH QUESTION, total marks on the paper as well as total overall marks, which then feed into an overall grade based on the boundaries released by AQA this week (Aug 2017). Furthermore, to account to boundary movement next year, I have added a buffer column which shows you the grade that would be achieved should the boundary increase by 10% on this year’s grade. All you need to do is add the pupil information and the marks they have achieved for each question and the rest is done for you. For each question there is also an intervention column so you can easily add information as to what intervention has been given to underachieving pupils for certain questions.
The literature version of this sheet has too been added in my shop.
THE LINK TO THE 2018 VERSION OF THIS IS BELOW:

https://www.tes.com/teaching-resource/gcse-english-language-aqa-9-1-data-tracking-sheet-june-2018-official-grade-boundaries-excel-11962733

Reviews

4.5

Something went wrong, please try again later.

ARTY FARTY

6 years ago
4

Did exactly what I expected and saved me lots of time attempting to create something similar.

morganc2

7 years ago
5

This is amazing; it'll save me hours of my life and make filling in progress reports a piece of cake. Thank you!

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.