BTEC Sport (2022 Spec) Student Tracker – Component Breakdown + Auto-Updating Overview (Excel)

A simple, classroom-ready BTEC Sport tracker (2022 specification) designed to help you monitor student progress across components and tasks in one place.

You only need to enter marks/notes into the task cells in the “Component Breakdown” section (scroll across the sheet to access the task columns). The Overview tab updates automatically, giving you an instant snapshot of progress and performance without extra admin.

Perfect for BTEC teachers, leads, and Quality Nominees who want a clear, consistent way to track completion, marks, and next steps across a class.

What’s Included

Excel tracker file (editable)

Component/task breakdown input area (enter data here)

Auto-updating overview/dashboard (updates automatically from your inputs)

How to Use (Quick Instructions)

Open the spreadsheet.

Go to the Component Breakdown area.

Scroll across to find the task columns.

Enter your data in the task cells only (marks, completion, notes—depending on your setup).

Check the Overview for an instant updated summary (no manual changes needed).

Best For

Tracking completion and attainment across BTEC Sport tasks

Spotting gaps, missing work, and intervention needs quickly

Keeping evidence tidy for standardisation / internal QA