A spreadsheet I have been working on to track scores and show progress after end of topic tests and mock exams. I have also included a required practical tracking sheet.
In the main spreadsheet, raw end of topic test scores are entered to generate a gcse grade. The look up tables that calculate these grades are editable and in a separate tab on the spreadsheet, they happen to be set up to fit our in house tests that are all standardised out of 25 marks, but can be altered with ease by editing the raw score values. There is also space to record mock scores for biol chem and physics too. These have thier own look up table to add scores into once we know more on boundaries this summer, (the current figures used are purely to test the spreadhseet works).
The main spreadhseet on the second tab can be copied and pasted into numerous extra tabs, depending on the number of your classes.
Conditional formatting has been used so that once a classes target grades are added to the sheet, progress in relation to target can be colour coded.
I haven’t used this live with classes yet, and intend to make a Y11 version and a purely triple version.
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.
£3.00