✅Attendance Tracker
Record daily attendance using simple codes: P = Present, A = Absent, L = Late, E = Excused. The sheet automatically calculates totals and attendance percentage per student.
Why Teachers Need It
Manual attendance counting is tedious and error-prone. This tracker automates the counting so you can see at a glance which students are falling below attendance thresholds.
Key Benefits
- Enter a single letter (P, A, L, E) per student per day — takes under 2 minutes
- Total Present, Absent, Late, Excused auto-calculated per student
- Attendance % calculated automatically — no manual math
- Dates in row headers can be customized to match your class schedule
How It Works
- 1Student names pull automatically from the Masterlist via Student ID lookup.
- 2Enter dates in the header row (row 4) to match your actual class days.
- 3Type P, A, L, or E in each cell for each student each day.
- 4Counting formulas (COUNTIF) tally each code type automatically.
- 5Attendance % = Total Present / Total Recorded.
Example Workflow
“After two weeks of class, you open the tracker and see that STU-005 has an attendance rate of 68%. The sheet shows 4 absences and 2 lates out of 15 sessions. You flag this student for follow-up.”
Pro Tips for Teachers
- •Replace the Day 1, Day 2 headers with actual dates for accurate records
- •Use data validation dropdowns for attendance codes to prevent typos
- •Check attendance % weekly to catch patterns early
Frequently Asked Questions
Can I track multiple classes?
This version tracks one class per sheet. Duplicate the Attendance Tracker sheet for additional classes.
What if I make a mistake entering a code?
Simply overwrite the cell with the correct code. All totals recalculate automatically.
Related Navigation
Explore the full parent spreadsheet system or browse other teaching resources and interactive tools.