OCR GCSE PE Interactive Data Tracking Assessment Spreadsheet

This interactive spreadsheet helps you to record all the progress of your students. Practical scores, theory unit tests and mock exam results as well as coursework. All the percentages are figured out for you and it will estimate what grade the student is likely to achieve. A fantastic resource for you as the teacher. You can keep on top of your class, whilst being data rich to inform your line manager, headteacher and parents. Intervention dropdown lists are included so you can prove what your strategies are and the impact they have had. The spreadsheet automatically colours in the cells in red, yellow or green to inform you of what needs to be improved.

A great resource to get the most out of your group and help you to keep checks on the student’s progress.

Instructions are attached as a separate document. Enjoy!!

Save for later
  • OCR-GCSE-PE-Tracking-Spreadsheet.xlsx
  • Instruction-for-GCSE-Data-Tracking-Spreadsheet.docx
  • OCR-screenshots-of-spreadsheet.pptx

About this resource


Created: Mar 8, 2019


xlsx, 99 KB



docx, 13 KB



pptx, 515 KB


Report a problem

Tes Paid Licence

How can I re-use this?