Attendance Calculations in Wisenet are based on the minutes that a Learner has attended. Please note that only Status Attended or Absent will now be included in Attendance Calculations.
IMPORTANT NOTE:
Attendance is always calculated as at ‘today’s date’ – if you are behind in entering attendance data, this will affect the attendance percentage the system will report.
Quick Tip
Use Report #0430 – The Learner Attendance Summary Report which lists individual class attendance per Learner.
How Class Attendance % is calculated
| Class Attendance Calculation | |||||||
|---|---|---|---|---|---|---|---|
| Formula | Example | ||||||
| Note: It measures the percentage of minutes that the Learner attended for an individual class | |||||||
| Attendance Minutes / (divided by) Class Minutes | In the following example: - Alex has attended the entire class - Dave left early to attend a doctor's appointment - Mary arrived 30 minutes late and was 30 mins late from lunch | ||||||
| Start | End | Break (hrs) | Hours | Minutes | |||
| Class Schedule | 9:00 AM | 5:00 PM | 1 | 7 | 420 | ||
| Learner Attendance | Start | End | Break (hrs) | Hours | Minutes | % Attended | |
| Alex | 9:00 AM | 5:00 PM | 1 | 7 | 420 | 100% | |
| Dave | 9:00 AM | 3:00 PM | 1 | 5 | 300 | 71% | |
| Mary | 9:30 AM | 5:00 PM | 1.5 | 6 | 360 | 86% |
How Average Completion Attendance % is calculated
| Average Attendance Calculation | |||||||
|---|---|---|---|---|---|---|---|
| Formula | Example | ||||||
| Note: It measures the percentage of minutes that the Learner has attended for classes run to date within a single timetable | |||||||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | In the following example: - Alex has attended all classes on time - Dave has missed one class and left Class 1 early - Mary did not fully attend Class 1 and Class 4 and she did not turn up for other classes | ||||||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | Classes run to date | Start | Learner Attendance | ||||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | Class | Mins | Alex | Dave | Mary | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 1 | 420 | 420 | 300 | 375 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 2 | 420 | 420 | 420 | 0 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 3 | 420 | 420 | 420 | 0 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 4 | 420 | 420 | 420 | 300 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 5 | 420 | 420 | 0 | 0 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | Total | 2100 | 2100 | 1560 | 675 | ||
| Total Attendance Minutes / (divide by) Total Class Minutes where Status = Attended or Absent AND Class Start Date < (less than) Today's Date | 100% | 74% | 32% |
How Maximum Possible Average Attendance % is Calculated
| Maximum Possible Average Attendance Calculation | |||||||
|---|---|---|---|---|---|---|---|
| Formula | Example | ||||||
| Note: It measures the average attendance of the Learner if they attend 100% of the remaining classes within a single timetable | |||||||
| Total Attendance Minutes to Date + (plus) Max Possible Future Attendance Minutes / (divide by) Total Class Duration in Minutes X (multiply by) 100 | In the following examples: - Alex has attended all classes on time run to date - Dave left Class 1 early and did not attend Class 5 - Mary did not fully attend Class 1 and Class 4 and she did not turn up for other classes | ||||||
| All Scheduled Classes | Learner Attendance | ||||||
| Class | Mins | Alex | Dave | Mary | |||
| Classes run to date | 1 | 420 | 420 | 300 | 330 | ||
| 2 | 420 | 420 | 420 | 0 | |||
| 3 | 420 | 420 | 420 | 0 | |||
| 4 | 420 | 420 | 420 | 300 | |||
| 5 | 420 | 420 | 0 | 0 | |||
| Classes not yet run | 6 | 420 | 420 | 420 | 420 | ||
| 7 | 420 | 420 | 420 | 420 | |||
| 8 | 420 | 420 | 420 | 420 | |||
| 9 | 420 | 420 | 420 | 420 | |||
| 10 | 420 | 420 | 420 | 420 | |||
| Total | 4200 | 4200 | 3660 | 2730 | |||
| 100% | 87% | 65% |
Calculating attendance across multiple timetables
Wisenet has a special report designed for you to track attendance across multiple timetables. It is qReport 4018 see Attendance Reports and Rolls
This report treats all the class attendance details in all the timetables (based on the criteria that you have entered when running the report) as one big timetable for Average Attendance and Maximum Possible Attendance calculations.