Attendance Tracker for Schools, Truancy Intervention Forms + Excel
A complete chronic absence and truancy toolkit for school admins, attendance teams, counselors, and social workers. It includes printable forms plus an Excel tracker that calculates attendance rates and assigns tiers for you.
**Printable PDF (7 forms + terms page, US Letter):**
- Attendance Watch List (24 students, rate %, tier)
- Monthly Attendance Grid (landscape, attendance codes)
- Attendance Intervention Plan (root causes, goal, supports, signatures)
- Parent Contact Log
- Attendance Conference Notes
- Tiered Intervention Menu (Tier 1 / 2 / 3 ideas, plus a blank chart for your district's thresholds)
- Intervention Progress Log
**Excel tracker (.xlsx):**
- Roster for up to 300 students
- Absence Log for up to 3,000 entries, with E/U/T/S code dropdowns
- Automatic excused, unexcused, suspension, tardy, and total counts
- Attendance rate %, Tier 1/2/3, and truancy and tardy flags, all color-coded
- Intervention Log with a count and last-intervention date for each student
- Dashboard: tier counts, chronic absence %, and Tier 2/3 students with no intervention yet
- Editable thresholds (defaults: Tier 2 below 90%, Tier 3 below 80%, truancy flag at 5 unexcused)
Every page is also included as its own PDF. Works in Excel and LibreOffice (Google Sheets supported). Follow FERPA and your state and district truancy procedures. Single-school license.