Students’ age range: 18+
Topic: Digitizing Staff Attendance.
Description: Adult learners will be shown samples of the present system of recording and forwarding staff attendance information. They will be asked to identify some pros and cons of using the present system. Possible responses: It is time consuming to write up attendance information. It takes too long to have information forwarded. Evaluating staff attendance is difficult due to it being done manually.
Adult learners will be shown a sample excel attendance worksheet. The facilitator will model or demonstrate the use of the worksheet by:
1. Entering Staff information (Staff names and Form used)
2. Entering Holidays and other days
3. Entering the attendance for a few staff members
4. Showing learners the Absence Form automatically generated
Learners will be given a scenario to complete.
1. Enter the following attendance information in the worksheet provided. There are 10 staff members in total.
2. Print forms 1 -5.
3. Analyze the attendance for the month: What percent of staff was absent? What percentage of the staff was late?
Name Absent End Explanation
Jane Doe April 3, 2018 April 4, 2018 Called in
James Doe April 9, 2018 April 13, 2018 Medical Certificate
Jack Doe April 9, 2018 April 20, 2018 Vacation
Jack Doe April 24, 2018 April 25, 2018 Called in
Jane Doe April 23, 2018 April 25, 2018 Medical Certificate
Jill Doe April 27, 2018 April 30, 2018 Called in
Jake Doe April 27, 2018 April 30, 2018 Called in
4. Complete the attendance worksheet at your school for the month using the following instructions as your guide.
A. Type employees’ names (teachers and administrators) and the form name (Absence Form or Contract Workers Absence Form) in the tab labeled List of Employees. You may delete the sample list.
B. Record the absences of employees in the tab labeled Employee Leave Tracker. Type the employee's name, the first day of their absence, the last day of their absence and the type of leave. You can find a list of the Leave Types in tab 6. The number of days absent and the day the employee returned to work will be automatically calculated.
C. Print the Absence Form. Remember to change the School and Supervisor name. NB: Casual Leave and Vacations should be written on other designated forms.
D. You may print the Calendar View once per month for employees’ perusal and necessary action.