xlsx, 20.53 KB
xlsx, 20.53 KB
This tracker allows you to include the students names and as you enter the marks for the NEA 1 and NEA 2, it will add the two marks together and an indication to the grade (1-9) it could be. Grade boundaries are adjustable. Also I have included a feature that if you put a sub mark for example in the NEA 1 research and gave it a mark of 7 - then the cell would change to red to indicate it is outside the mark limit. I have also added two mock sections that works out the average of the two mocks and the 9-1 grade. Then the final section at the end adds up the NEA1 and NEA2 together with the average mock points to give a predication 9-1 and total score. Boundaries can be edited.

Review

5

Something went wrong, please try again later.

Babycakes77

7 years ago
5

Just what I was looking for, so helpful for my Y11 group and the fact that I am rubbish with EXCEL! Thanks again!

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.