BTEC Tech Award Construction (2022) | Complete Grade Tracker

DESCRIPTION
The most complete BTEC Tech Award Construction tracker on TES. Enter students once in Class Setup —
names, targets and class info flow automatically to every sheet. Unique C3 Target Marks sheet calculates the
exact raw mark each student needs in the C3 exam to hit every grade from P1 to D2*. Dashboard shows PP,
SEN and gender breakdowns across C1, C2 and Mock C3 at a glance.
WHAT’S INCLUDED
• Getting Started guide with live setup checklist
• Class Dashboard — C1, C2, Mock 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
• C3 Target Marks — exact raw mark each student needs for every grade
• C3a Learning Aim Timeline — dates and completion status
• C3b Learning Aim Tests — % grading with flexible max marks
• C3c Mock Exam — combined course grade vs target
• C3d Practice Papers — up to 3 papers with full course grade trajectory
• Concerns and Interventions log — filterable by class
• Resources tab — Pearson links for boundaries, calculator and spec
• January 2026 Pearson grade boundaries built in
C3 TARGET MARKS — KEY FEATURE
Based on each student’s actual C1 and C2 UMS, the tracker calculates the minimum C3 raw mark needed to
achieve every grade from P1 to D2*. No manual calculation. Instant answers for every student.
TECHNICAL
• Excel .xlsx — compatible with Excel 2016 and later
• Pre-configured for Construction — 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_Construction_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.