Home/Spreadsheets/Special Ed & Teachers/School Attendance Tracker for 500 Students
School Attendance Tracker for 500 Students
A school attendance tracker for up to 500 students with an absence log built in: tick who is here each day, log why the others were not, and attendance percentages, absence counts and per-student reports fill themselves in. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Up to 500 students and a full school year, one tick box per school day, grouped by week
- JUMP TO lands on this week, and an ALL PRESENT row marks the whole day so you only tick the exceptions
- Absence Entry: date, student, type (Sick, Excused, Unexcused, Tardy, Other), reason and note, with a NOT LOGGED YET list
- Attendance Report and Absence Report per student, with monthly tables and the most recent absences
- Holidays, breaks and days outside your dates are never counted, and percentages count only school days up to today
- Opens in Excel
Instant digital download · one-time purchase · no subscription
What it does
- Up to 500 students and a full school year, one tick box per school day, grouped by week
- JUMP TO lands on this week, and an ALL PRESENT row marks the whole day so you only tick the exceptions
- Absence Entry: date, student, type (Sick, Excused, Unexcused, Tardy, Other), reason and note, with a NOT LOGGED YET list
- Attendance Report and Absence Report per student, with monthly tables and the most recent absences
- Holidays, breaks and days outside your dates are never counted, and percentages count only school days up to today
- Three files: the tracker with the absence log, a Filled Example with 500 sample students, and a tick-only register
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Student Attendance
- Absence Entry
- Attendance Report
Works in
- Microsoft Excel for Microsoft 365 (Windows, Mac or Excel for the web); the tick boxes are Excel's own in-cell checkboxes
- Not for Excel 2021 or older, Google Sheets, Numbers or LibreOffice
- No macros, no add-ins
Honest scope
This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district documentation system — those stay your professional judgement.
Others in Special Ed & Teachers
- MTSS and RTI Small Group SchedulerAn MTSS and RTI small group scheduler: place students into tiered intervention blocks…$9.99View →
- School Nurse Health ManagerA school nurse health manager that keeps immunisations, screenings, health plans and…$13.99View →
- IEP Due Date Compliance CalendarEvery statutory clock on your caseload in one place — consent, evaluation, annual…$16.00View →
- IEP Goal TrackerAn IEP goal tracker for special education data collection and progress monitoring: one…$19.99View →
