51ºÚÁÏ

This fully editable Excel spreadsheet is a complete grade tracking tool designed for the BTEC Tech Award in Sport (2022 specification). It helps you record marks, track student progress, calculate grades and plan interventions — all in one place.

The tracker covers all three components (1, 2 and 3) and automatically calculates total marks and final grades using official Pearson UMS (Uniform Mark Scale) boundaries. Just enter the assessment scores, and the spreadsheet does the rest — no manual calculation or extra tools needed.

It includes a detailed breakdown for Component 1 and Component 2, allowing you to enter task-by-task scores (e.g. 1A, 1B, 2A, etc.). The tracker shows both individual component grades and the overall qualification grade, giving you the full picture for each student.

A key feature is the built-in colour coding system, which gives instant visual insight:

Red = Below Level 2 Pass

Green = Level 2 Pass

Blue = Level 2 Merit

Purple = Level 2 Distinction or Distinction*

This makes it easy to identify students who are underperforming, on grade boundaries, or achieving strong results — ideal for interventions, data drops, and reports.

The Excel file is fully editable and works with both Microsoft Excel and Google Sheets. It can be adapted to suit your centre’s delivery model, assessment plans, and internal deadlines.

Perfect for BTEC PE teachers, curriculum leads, and heads of department who want a reliable and efficient way to monitor progress, support students, and stay Ofsted-ready.

Key Benefits:
Built in Excel – no formulas to write

Tracks Components 1, 2 and 3 with UMS grade conversion

Displays both individual component and final grades

Task-by-task breakdown for Component 1 and 2

Colour-coded performance overview

Ideal for feedback, progress meetings and moderation

Fully editable for your own centre’s use