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.