Editable Colour-Coded Attendance Tracker

Attendance tracking that color-codes and calculates itself - so you can spot at-risk students in seconds, not spreadsheets.
Enter each student’s weekly attendance percentage and this fully editable tracker does the rest: individual and whole-class averages calculate automatically, while every result is color-coded so at-risk attendance patterns jump out at a glance - no manual formatting, no separate calculator, no missed warning signs.
What’s included:

• Two full tracker tabs - Semester 1 and Semester 2 - so this one resource covers your entire school year
• Space for thirty students across ten weeks per semester
• Automatic color-coding: g instantly flags students who need a conversation or intervention
• Built-in formulas calculate individual student averages and whole-class averages automatically - always accurate, always up to date
• Data validation prevents typos
• Locked formulas and headers protect your data - only student names and attendance cells are editable, so nothing gets accidentally overwritten
• Print-ready formatting - fits neatly on one landscape page per semester, with headers that repeat automatically
• Step-by-step Instructions tab included, with a dedicated Google Sheets printing tip - no spreadsheet experience needed

Perfect for:
Primary and secondary classroom teachers, form/homeroom teachers, and coordinators who need a fast, reliable, low-maintenance way to track and report on attendance across the year.
Format: Excel. Also opens in Google Sheets, with formulas and color-coding working correctly - print layout doesn’t carry over automatically, but the Instructions tab includes a quick two-step fix (set orientation to Landscape, scale to “Fit to width”) so it prints cleanly either way.
A note on editing: This resource is protected to keep the formulas and formatting intact, but it’s fully customizable - add your class name, adjust student numbers, and it’s ready to go in minutes.
If this tracker saves you time, I’d love a review - it helps other teachers find it and helps me keep making resources like this one.