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.
Get this resource as part of a bundle and save up to 38%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
BTEC Tech Award Complete Tracker Bundle (2022) | All 13 Subjects | Dashboard | PP & SEN Analytics | Excel
Every BTEC Tech Award (2022) subject in one purchase. Whether you're a Head of Department managing multiple vocational subjects, a resource manager buying for a whole school, or a MAT purchasing for multiple sites — this is the one bundle that covers everything. Nine exam subjects with C3 Target Marks. Four synoptic subjects with purpose-built task trackers. All pre-configured, all ready to use from day one. WHAT'S INCLUDED • 9 exam subject trackers: Animal Care, Child Development, Construction, Digital IT, Enterprise, Health and Fitness, Health and Social Care, Sport, Travel and Tourism • 4 synoptic subject trackers: Creative Media Production, Dance, Drama, Music Practice • Every tracker includes: Class Setup, Dashboard, C1/C2 Mark Sheets, Student Overview, C3 tabs, Concerns log, Resources • Exam subjects: C3 Target Marks sheet — exact raw mark needed per student for every grade • Synoptic subjects: C3 Synoptic Task Tracker with status, hours logged and predicted marks per task • Dashboard: PP, SEN, Boys and Girls breakdowns across C1, C2 and predicted C3 for every class • January 2026 Pearson grade boundaries built in across all 13 subjects • Enter students once in Class Setup — they flow to every sheet automatically • Supports up to 200 students per tracker, multiple classes per workbook Ideal for: Heads of Department, resource managers, curriculum leads, MATs purchasing for multiple schools. Individual value: £32.50 | Bundle price: £19.99 | Save £12.51 Individual subjects also available at £2.50 each. Subject bundles available at £3.99–£6.99
£19.99
Bundle
BTEC Tech Award Vocational Sciences Bundle (2022) | Animal Care, Child Development & Construction | Excel Trackers
Animal Care, Child Development and Construction are often delivered within the same vocational faculty. All three have a written C3 exam. Each tracker is pre-configured for its subject — component names, learning aims and grade boundaries all locked in and ready to use from day one. WHAT'S INCLUDED • Animal Care tracker (BAC) — C1/C2 mark sheets, mock, practice papers, C3 target marks • Child Development tracker (BCD) — C1/C2 mark sheets, mock, practice papers, C3 target marks • Construction tracker (BCB) — C1/C2 mark sheets, mock, practice papers, C3 target marks • All three include: Class Setup (enter students once), PP/SEN/gender dashboard, Student Overview, Concerns log, Resources tab • C3 Target Marks — exact raw mark each student needs to hit every grade from P1 to D2* • Dashboard shows Above/On/Below target for Total, PP, SEN, Boys and Girls per class • January 2026 Pearson grade boundaries built in across all three subjects Ideal for: Vocational faculties, teachers covering multiple applied science or care subjects. Individual value: £7.50 | Bundle price: £5.49 | Save £2.01 Also available individually at £2.50 per subject. Search 'BTEC Tech Award 2022 Tracker' on TES.
£5.49
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.50