Class attendance can be an important metric used by educators, parents and students. In fact, some studies have shown that there is a positive relationship between class attendance and grade  . To others, attendance helps to manage an organization engages with its stakeholders. It is now easier to track attendance with the Attendance Spreadsheet in excel.
To begin using the monthly attendance tracker, fill out the top segment:
Once the top portion is stipulated, it is now important to add the list of all attendees, including their unique ID. An attendee ID can be determined by their e-mail address, telephone # or by their student id. It is possible to add up to 100 attendees.
Now that all the preparations have been completed, it is time to start tracking attendees. To do that, go to the relevant day of the week and go over each attendee’s name and check their attendance based on the P.A.U.L method:
To facilitate visual cues regarding accepted absences, unaccepted absences and late attendance, the attendance spreadsheet will automatically highlight the acronym:
As the month goes by it is possible to begin seeing a trend in attendance rates per attendee by looking at the color identification and the total P.A.U.L. The total P.A.U.L, is available on the further right side of the school attendance spreadsheet.
In some instances, a printed copy of the attendance spreadsheet is required. To do that, either press CTRL+P or go to File -> Print. Don’t forget to determine the number of pages required to ensure office supplies are not wasted.
 Credé M, Roch SG, Kieszczynka UM. Class Attendance in College: A Meta-Analytic Review of the Relationship of Class Attendance With Grades and Student Characteristics. Review of Educational Research. 2010;80(2):272-295. doi:10.3102/0034654310362998
 Karnik A, Kishore P, Meraj M. Examining the linkage between class attendance at university and academic performance in an International Branch Campus setting. Research in Comparative and International Education. 2020;15(4):371-390. doi:10.1177/1745499920958855