BTEC Tech Award Dance (2022) | Complete Grade Tracker

The most complete BTEC Tech Award Dance tracker on TES. Enter students once in Class Setup — names,
targets and class info flow automatically to every sheet. Includes a purpose-built synoptic task tracker
designed specifically for Dance’s set task C3, with status, hours logged and predicted marks per task.
Dashboard shows PP, SEN and gender breakdowns across C1, C2 and predicted C3 at a glance.
WHAT’S INCLUDED
• Getting Started guide with live setup checklist
• Class Dashboard — C1, C2, Predicted C3 and Predicted Overall per class
— Breakdown by Total, PP, SEN, Boys and Girls (count + %)
• Class Setup — enter students once, they appear everywhere
• C1 and C2 Mark Sheets — raw mark to UMS to grade, auto on/off target
• C3a Learning Aim Timeline — dates and completion status
• C3b Learning Aim Tests — % grading with flexible max marks
• C3c Synoptic Task Tracker — purpose-built (see below)
• Concerns and Interventions log — filterable by class
• Resources tab — Pearson links for boundaries, calculator and spec
• January 2026 Pearson grade boundaries built in
C3 SYNOPTIC TASK TRACKER
Dance’s C3 is a Pearson-set synoptic task, not a written exam. Task names are pre-populated from the
Pearson specification — rename them in amber cells to match your specific brief each series. Per student,
per task: status dropdown, hours logged and predicted mark. Predicted UMS scales automatically to 120
UMS maximum.
• Task A: Research and planning — interpret the brief
• Task B: Develop and apply dance skills in response to the brief
• Task C: Evaluate own contribution to the performance
TECHNICAL
• Excel .xlsx — compatible with Excel 2016 and later
• Pre-configured for Dance — subject locked, no setup needed
• January 2026 Pearson grade boundaries built in — update amber cells each series
• Supports up to 200 students across multiple classes
• File: BTEC_Tech_Award_2022_Dance_Tracker.xlsx
• Requires Microsoft Excel — Google Sheets not supported
Also available for all 13 BTEC Tech Award (2022) subjects — search ‘BTEC Tech Award 2022 Tracker’ on TES.