GCSE PE - Assessment / Progress Tracker

This is an excel spreadsheet which I have developed to monitor progress of the GCSE PE cohort & also speed up a lot of data analysis work!

Spreadsheet includes:

• Overview tab which demonstrates progress over time & performance in all 6 assessments.
• Individual assessment tabs to show marks scored in each question.
• Staff need to update the tracker by inputting individual question marks into the correct assessment tab - the total score, % and WAG are automatically generated, as well as the overview tab at the front. Each question is RAG rated to show which questions need to be revised!

PPT instructions file included.

Includes 6 end of topic assessments & mark schemes. *Note that the tracker is set up to be used alongside these assessments - using different assessments will require the exam tabs to be amended.