BTEC Course Tracker (Pass/Fail Automated Excel Tool)

BTEC Course Tracker (Pass/Fail Automated Excel Tool)

This easy-to-use Excel tracker is designed to help BTEC teachers efficiently monitor student progress across multiple units and assessment criteria. The tool supports up to 10 students and 6 units, with automated calculations and clear visual organisation. ( can be edited to inlcude more)

Key Features:
• Automatic progress tracking – Calculates passes, fails, and completion percentages instantly.
• Unit-level monitoring – Each unit includes six horizontal assessment boxes (P1–P3, M1–M2, D1) with simple drop-down menus for “Pass” or “Fail.”
• Auto-grading – Overall unit results (Pass, Merit, Distinction, or Fail) are calculated automatically based on student performance.
• Criteria Summary tab – Records detailed assessment evidence, assessor names, and verification status for internal quality assurance.

• Teacher-friendly layout – Colour-coded, formatted, and ready to use — no setup required.
This resource saves valuable time for BTEC staff by providing a clear, centralised view of learner progress, ideal for unit tracking, assessment evidence management, and reporting.