Free template
Class attendance sheet template
An editable Excel attendance sheet for one class: one row per enrolled student, one column per class date and four statuses. Totals per student and per date update automatically, and the period summary uses the same denominator for the attendance rate and the no-show rate.
Updated . No signup needed. All example records are invented.
What's inside
- Instructions with definitions for present, absent, late and excused
- A filled example: an invented Tuesday guitar class, 6 students and 4 dates
- A blank sheet for 30 students and 16 class dates; status cells only accept the four statuses
- Per-student totals, per-date totals and a period summary with attendance and no-show rates
The worked summary in the example sheet
Six invented students, four Tuesday classes: 24 recorded statuses. Two absences were excused under the school's notice policy, so they are removed from the expected count.
| Measure | Calculation | Result |
|---|---|---|
| Recorded statuses | 6 students × 4 dates | 24 |
| Present / late / excused / absent | Counted from the sheet | 16 / 2 / 2 / 4 |
| Expected attendances | 24 recorded − 2 excused | 22 |
| Attended | 16 present + 2 late | 18 |
| Attendance rate | 18 ÷ 22 | 81.8% |
| No-show rate | 4 absent without notice ÷ 22 | 18.2% |
These are invented records for a worked calculation, not a benchmark or a typical rate.
How to use it
- Decide what each status means. Late counts as attended. Excused means the school accepted notice under its policy. Absent means no accepted notice. Write these down before counting anything.
- Record every enrolled student on every class date. Leave a cell blank only if the student was not enrolled on that date. Blank cells are not counted.
- Correct mistakes in place and note why. Change the status and record who corrected it and why in your staff notes, so a later review can trust the figures.
- Compare like with like. Compare periods with similar classes, holidays and definitions. A change in rate alone does not show what caused it.
Limits to know
- This is not a makeup-entitlement ledger. Record a makeup as an attendance in the class the student attended and keep the original status.
- Do not write health details or other sensitive reasons for absence in the sheet.
- It does not send reminders or absence messages. Families are contacted through your normal process.