Education template
Attendance tracker
Mark each student present, late or absent for every class date. Attendance rates per student and per session are calculated for you.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Attendance
73 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 338 filled cells in all.
Built in
- Conditional formatting
- Dropdowns
- Frozen headers
- 5 conditional format rules
- 1 validation rule
A look at the Attendance sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Attendance tracker | |||||||
| 2 | Pick P (present), L (late) or A (absent) in each cell. Rates below 85% are flagged. | |||||||
| 3 | Class | Intro to Statistics, Mon and Wed | ||||||
| 4 | ||||||||
| 5 | Student | Present | Late | Absent | Rate | 9/14 | 9/19 | |
| 6 | Aiden Rourke | 15 | 0 | 1 | 94% | P | P | |
| 7 | Bailey Sato | 15 | 1 | 0 | 100% | P | P | |
| 8 | Charlie Ndiaye | 15 | 0 | 1 | 94% | P | P | |
| 9 | Drew Halvorsen | 11 | 0 | 5 | 69% | A | P | |
| 10 | Ellis Moreno | 16 | 0 | 0 | 100% | P | P | |
| 11 | Frankie Osei | 13 | 1 | 2 | 88% | P | P | |
| 12 | Greer Lindgren | 15 | 0 | 1 | 94% | P | P | |
- attendance
- class
- school
- roll call
More education templates
EducationGrade bookWeighted grades for a whole class with letter grades, ranks and class statistics. Change the weights or the grading scale and every grade updates.
EducationClass scheduleA weekly class timetable with color coded courses and a course list with rooms and instructors. Sessions, hours and credits are counted for you.
EducationSurvey results summarySummarize course feedback survey responses with counts, percentages and charts. Paste new responses and the summary updates.
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
Start your attendance tracker now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.