BTEC L3 Tracker & Grade Projection Tool

BTEC Level 3 Tracker & Grade Projection Tool – automate grade tracking and monitor progress across your whole department.

Built for whole course and department use, it saves staff time and provides clear, up-to-date insight into both student and course progress to monitor achievement. From planning interventions to reporting on student progress, it offers a unified, reliable, and efficient system for your department. Alongside its department-wide overview, it gives teachers a powerful tool for tracking individual units with ease.

Key Features:

• Full Department Coverage – track every student on a course, from single awards (including AAQs) to double awards, with centralised records. (Triple awards can be added in consultation if needed.)
• Customisable for Your Course – automated features generate a unique tracker tailored to your department based on the units taught and their objectives/learning aims. Compatible with both exam and coursework units, factoring in guided learning hours.
• Automatic UMS Conversion – for examined units, simply enter the grade boundaries and the tracker will automatically convert raw marks into the correct UMS using BTEC’s official sliding scale system.
• Powerful Grade Projection Tool – calculates projected grades in real time based on current unit performance, with a ‘What If?’ function to explore potential student outcomes.
• Department-Level Overview – live, aggregated data for all units and classes in one place, with filters to view specific classes or course groups.
• Low-Maintenance Design – automation reduces repetitive admin, freeing up valuable teaching time and making tracking much easier.
• Teacher-Friendly Navigation – clear menus, consistent formatting, and protected cells to prevent accidental edits, with warnings issued where necessary.
• Detailed User Guide Included – step-by-step instructions for set-up, entering core data, adding students, using the grade projection tool, and navigating all automated features.
• Support & Maintenance Options – free support available for initial set-up if required. If further bespoke features are requested, or year-on-year support is needed, a maintenance package is available.

Perfect for:

• BTEC Level 3 coordinators
• Heads of Department seeking consistent, reliable tracking across multiple classes or courses (e.g., Single Sport and Double Sport)
• Teachers wanting to reduce admin time while maintaining accurate, up-to-date, and easy-to-track grade data

Licensing:
If you have purchased the tracker (e.g., via TES or another platform), you are permitted to use it for your department only. If wider use is needed across a trust or multiple campuses, please contact the author to discuss appropriate licensing.

This resource is produced in Google Sheets to take advantage of powerful automation features. A Microsoft Office version is planned for the future.