Weekly Meal Planner Template
May 18, 2021
Weekly Meal Planner Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp Weekly meal planning is the activity of determining most or all of the meals that
Attendance Spreadsheet
Share on facebook
Share on twitter
Share on linkedin
Share on email
Share on whatsapp
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 »
Master Grocery List
May 11, 2021
Master Grocery List Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp Every household is bound to have a list of groceries to buy every so often, ensuring
Vehicle Maintenance Log
May 4, 2021
Vehicle Maintenance Log Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp Every vehicle needs to go through maintenance throughout its lifecycle. It helps to lower the odds
Hourly Schedule Template
April 27, 2021
Hourly Schedule Template Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp There is a lot of work to be done, but only so many hours in the
Rental Applications Form
April 20, 2021
Rental Applications Form Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp Every prospect tenant and landlord face the need to get a better understanding of each other.
Attendance Spreadsheet
April 13, 2021
Attendance Spreadsheet Share on facebook Share on twitter Share on linkedin Share on email Share on whatsapp Class attendance can be an important metric used by educators, parents and students. In fact, some studies
