Attendance is the most undervalued number in an online academy. Handled well, it's the earliest warning you'll get that a student is about to leave. Handled the usual way — a spreadsheet someone updates on Fridays — it's a week-old guess that tells you nothing in time to act. Here's how to make attendance record itself, and how to make it actually useful. Why the manual register fails A register kept by hand fails in three predictable ways. It's late, because nobody types it up during the lesson. It's incomplete, because someone forgets. And it's untrustworthy, because a number entered from memory is a number nobody can defend when a parent or a client asks. An attendance record you can't trust is worse than none — it lets you believe a problem isn't there. Capture it at the door, not from memory The fix is to stop recording attendance and start measuring it. When a student joins the live room, that join is the attendance event. No register, no re-typing, no Friday reconciliation. Attended, missed and excused are tracked per lesson, automatically. The record is complete because it's a by-product of the class, not a separate chore. It's defensible because it reflects what actually happened. Treat excused absences honestly Here's a detail most systems get wrong: they count an excused absence the same as a no-show. That quietly poisons your data. A student who was genuinely ill, and told you so, shouldn't drag down their own attendance rate as if they'd vanished. The correct behaviour is to record the excused absence but exclude it from the denominator when the rate is calculated. It's a small distinction that stops a healthy cohort from looking like it's disengaging — and stops you acting on a number that was never true. Turn attendance into a retention signal Once attendance is automatic and honest, it becomes a leading indicator instead of a historical one. Most churn is visible weeks in advance: attendance drifts from 100% to 60% over a month before the student finally disappears. Watch the trend per student, not just the latest lesson. Combine it with progress — lessons remaining, last activity — for a fuller picture. Reach out while the number is sliding, not after the student is gone. What to automate, in order If you're moving off a manual process, automate in this sequence: Join-based attendance, so the raw data is captured without effort. Excused handling, so the rate is honest. Reports that roll attendance up by class and period, ready to share. Alerts on your own habits — a weekly look at who's trending down. Attendance done properly isn't administrative box-ticking. It's the cheapest early-warning system a school has, and the only cost of running it is choosing a platform that records it for you.