The tracker every drama teacher inheriting messy records has wished for. Type student names, type task names, enter marks. The workbook does the rest.

What’s inside:
• About tab with full instructions.
• Setup tab where you enter class names once and they flow through every year.
• Five year tabs (Year 1 to Year 5). Each handles five classes of around twenty five students.
• Each year tab automatically tallies criterion coverage per student, calculates averages and flags any criterion assessed fewer than two times across the year.
• Summary tab pulling live coverage data from all five years for department reporting.
• Conditional formatting throughout: red for gaps, green for coverage met.

Native Excel format. Opens cleanly in Google Sheets (save a copy to your Drive).

Format: Excel workbook, 8 tabs.