fbpx

Attendance Spreadsheet

attendance spreadsheet

               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[1] [2] [3]. 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.

Join thousands who have taken the next step in improving operational efficiency and insight analytics with GPetrium solutions.

100 +
and counting

If you would like to see other free solutions created by GPetrium, click here.

How to use the Attendance Tracker

               To begin using the monthly attendance tracker, fill out the top segment:

  • Teacher – The name of the person keeping track of attendance. It is possible to change the word teacher to coordinator, manager or others.
  • Class – Segment expected to be tracked. It can be changed to office, event or something else.
  • Year/month – A drop-down list containing Month-Year. It is important to choose a period so that the solution can determine the number of days in the month and the day of the week.

               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:

  • P – Present
  • A – Accepted Absence
  • U – Unaccepted Absence
  • L – Late
attendance spreadsheet filling out PAUL

Color Identification

               To facilitate visual cues regarding accepted absences, unaccepted absences and late attendance, the attendance spreadsheet will automatically highlight the acronym:

  • P – Blank
  • A – Gray
  • U – Light Red
  • L – Light Yellow

Total Monthly Attendance

               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.

attendance tracking totals

Attendance to Print

               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.

attendance tracking printing

[1] 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

[2] Jennjou Chen & Tsui-Fang Lin (2008) Class Attendance and Exam Performance: A Randomized Experiment, The Journal of Economic Education, 39:3, 213-227, DOI: 10.3200/JECE.39.3.213-227

[3]  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

Our Latest Posts

RASCI Template

RASCI Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                The RASCI matrix is a visual business tool used to define the connection between members and their

Read More »

Communication Plan Template

Communication Plan Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Communication helps instill important information between different parties, helping to build relations, drive collaboration and much

Read More »

Team Charter Template

Team Charter Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Team charters can help teams, projects and organizations build the rules of engagement and roadmap needed

Read More »

Check Register Template

Check Register Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Financial transactions have existed throughout history, helping buyers and sellers exchange goods based on their needs.

Read More »

Employee Training Tracker

Employee Training Tracker Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                Training is a great way to learn or hone the skills relevant to one’s professional career

Read More »

Bi-Weekly Budget Tool

Bi-Weekly Budget Tool Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp                There are many cases where employees or contractors are paid bi-weekly for their effort. To some,

Read More »
Receive a monthly newsletter with updates, insights and solutions from GPetrium!