Class Attendance Template
This new student attendance template combines multiple monthly student attendance forms into a single workbook, with a yearly summary sheet that provides a year-to-date total. I created this at the request of a school administrator who wanted a tool for tracking attendance for an entire school year. The yearly summary worksheet can be referenced via a "mail merge" to print student attendance reports. See below for instructions on how to do that.
Class Attendance Template
for Excel
Description
The attendance sheets have been updated to make it easier to add new students in the middle of the year and to make it possible to sort names alphabetically without messing everything up (if you do it right).
- The Student Name column now is divided into Student ID and Student Name.
- The YearToDate worksheet calculates totals for each student using lookup functions based on Student ID.
The only downside to the update is that the names and IDs must be entered manually into each worksheet, or by carefully Copying and using Paste Special > Values. This change was necessary to make it easier to add names in subsequent months and sort alphabetically.
Update 9/9/2020: Fixed bug that failed to report Tardies for September correctly.
