RASCI Template
September 21, 2021
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
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
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 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.
[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
Read More »
Communication Plan Template
September 14, 2021
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
Team Charter Template
September 7, 2021
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
Check Register Template
August 31, 2021
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.
Employee Training Tracker
August 24, 2021
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
Bi-Weekly Budget Tool
August 17, 2021
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,
