Assessment and Data Tracker/Analysis Spreadsheet - A-Level

This spreadsheet is a time saving resource for class teachers, heads of department and school leaders.

Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice.

This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention.

Once set up using the how-to guide, class teachers simply need to enter assessment grades and the Excel sheet automatically calculates whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group.

Please note this version is to be used with A-Level classes.

Save for later
  • Guide-to-Assessment-and-Data-Tracker-V4.2.docx.pdf
  • Assessment-and-Data-Tracker-(A-Level)---Template.xlsx

About this resource


Created: Oct 9, 2019

pdf, 894 KB


xlsx, 574 KB


Report a problem

Get this resource as part of a bundle and save up to 25%

Tes Paid Licence

How can I re-use this?