Introduction
The Course/Training Plan Progress dashboard and Excel report provides data on the progress for a specific course or training plan.
In this guide, we will describe how this progress is calculated and explain how you can understand the data shown by the dashboard and the Excel report.
How to understand the course/training plan progress view and report
The course/training plan progress dashboard view and the course/training plan progress Excel report present information based on currently enrolled learners.
In the table below, you can find explanations of how to read the dashboard view and Excel report, understand the information they present, and the calculations behind.
|
|
|
Course Progress View & Report |
In |
Calculation - what is counted/ displayed |
Explanation - limitations or things to be aware of |
|
1. Total current Learners Enrolled
|
Diagram |
Number of learners currently enrolled in the course. |
Learners who have pending requests will not be displayed here even if they have completed the Course before. |
|
2. Total Learners who have completed the course
|
Diagram |
Number of learners who have completed the course. |
Once a learner completes the Course and is unenrolled from it, they will be counted here. |
|
3. Average Course Rating |
Diagram |
Average of all ratings received |
If the rating was hidden via selected “Course – Manage Rating – Hidden”, it will not be counted in the average. |
|
4. Completed |
Diagram |
Number of enrolled learners who have completed the course |
For Classroom or Webinar courses this status means that learner’s registered attendance matches attendance required for the course completion. |
|
5. In Progress |
Diagram |
Number of enrolled learners who have started the course but not completed it yet |
For Classroom or Webinar courses without learning items this status means that Learner’s attendance has been registered. |
|
6. Not Started |
Diagram |
Number of enrolled learners who have not started the course. |
|
|
7. Overdue |
Diagram |
Number of enrolled learners who have overdue courses |
Once the due date passed and the learner has not completed the course, they will be counted here. Once the due date passed and the learner completes or is unenrolled from the course, they will not be counted here. |
|
8. Name (Learner’s name in the Excel file) |
Dashboard list, Excel report |
The learner’s name |
On the dashboard list the row with the name can be clicked to expand details about the learner’s progress on the different elements in the course. |
|
9. Status (Completion Status in the Excel file) |
Dashboard list, Excel report
|
The learner’s completion status (Not Started, In progress, or Completed) |
The detailed information on each learning item of the course is collapsed. Once you click the expand button next to the Learner’s name, you will see the following learning items’ statuses: Started, In Progress, Failed, and Completed. |
|
10. CEUs |
Dashboard list, Excel report |
Number of CEUs earned for the course completion |
If there are not any CEUs set for the course, this field will be empty. |
|
11. Progress |
Dashboard list, Excel report |
Learner’s progress |
The calculation of progress depends on the course and enrollment type. For detailed information on calculations of progress, follow these links: Remember if you set the course completion manually, Progress and Score values will automatically be saved as they were before the manual completion. If the completion of the learning items is set manually, the score will be 100%. The detailed information on the progress of each learning item is collapsed by default. Once you click the expand button next to the Learner’s name, you will see the progress per each item. |
|
12. Score |
Dashboard list, Excel report |
Learner’s average score of the learning items |
The calculation depends on the learning item. Quiz’s score is calculated as a percentage of earned score for the last attempt by learner. For example, maximum number of points is 200, learner has earned 100 points, the score will be calculated as 100/200 * 100% is 50%. Content Package’s score is calculated in accordance with the scale set in the content package. For example, if scale is absent, score will be 0% for the last learner’s attempt. Assignment’s score is calculated as a percentage of the received Grade to the maximum Grade. Learning Module, Attendance, and External App do not have score. This field is empty and if these items are set as required for the course completion, they are not calculated in the average score. If the completion of the learning item is set manually, the score will be 10 %. |
|
13. Completed |
Dashboard list, Excel report |
The date the learner has completed the course. |
|
|
14. Certificate |
Dashboard list, Excel report |
Learner’s certificate |
It is shown only when user has a certificate for this training. |
|
15. Course Name |
Excel report |
The name of the course. |
|
|
16. Category |
Excel report |
The category that was specified for the course. |
|
|
17. Course Type |
Excel report |
The type of the course. |
It could be either e-learning, Classroom & Blended Training or Webinar courses |
|
18. Course ID |
Excel report |
The ID of the Course if it was set. |
|
|
19. Course Duration |
Excel report |
The duration of the course if it was specified. |
|
|
20. Enrollment Flow |
Excel report |
Specifies how the approval of enrolments works for the course. |
The process can be either Automatic, Line Manager or Administrator Approval |
|
21-25. Email, Department, Office, City, Country |
Excel report |
The learner’s additional information. |
|
|
26. Overdue Status |
Excel report |
Whether the learner completed the course on time or after the due date (overdue). |
|
|
27. Due Date |
Excel report |
The date when enrolled learners must complete the course. |
This is shown only for e-learning courses and training plans. The due date can be different for different learners. It depends on the selected Date Type option for the course. If you choose Relative Date and select the number of days after enrollment, the due date that is shown in the report will depend on the enrollment date for each learner. If you choose Fixed Date, the due date will be the same for all users. |
|
28. Time Completed |
Excel report |
Time when the learner completes the course |
It is shown for completed courses only. |
|
29. Certificate Expiry Date |
Excel report |
The date when learner’s certificate will expire. |
|
|
30. Certificate Expired |
Excel report |
Whether the certificate has expired |
If so, it is marked with: Yes. |
How progress is calculated
Calculation of progress for an e-learning course with learning items
Example: A learner starts a course with 5 learning items set as required for the course completion:
|
Learning Items |
Progress in Learning Item |
Set to Course Completion |
|
Item 1 (contains only documents) |
100% |
Yes |
|
Item 2 (contains 3 documents and 1 Quiz) |
50% |
Yes |
|
Item 3 (is a SCORM Package) |
0% |
Yes |
|
Item 4 (is a Quiz) |
0% |
Yes |
|
Item 5 (contains a SCORM package, documents, and a Quiz) |
20% |
Yes |
The result will be the following:
The progress for the completed items divided by the number of learning items (in this case 5) that are set as required. So, we have:
(100%+50%+0%+0%+20%)/5 = 34 %.
OR
Example: A learner starts a course with five learning items and only three of them are set as required for the course completion:
| Learning items |
Progress with learning item |
Set as required for course completion |
| Item 1 (contains only documents) |
100% |
Yes |
| Item 2 (contains three documents and one Quiz) |
50% |
Yes |
| Item 3 (is a SCORM Package) |
0% |
Yes |
| Item 4 (is a Quiz) |
0% |
No |
| Item 5 (contains a SCORM package, documents, and a Quiz) |
20% |
No |
The result will be the following:
The progress for the completed items divided by the number of learning items (in this case three) that are set as required. So, we have:
(100%+50%+0%)/3 = 50 %.
Calculation of progress for classroom and webinar courses
This is displayed as relative to % selected for the course completion.
If required attendance is not set for the course, progress is displayed as % of registered learner’s attendance for this course session.
If required attendance is not set for the course and Enroll user into all course session enrollment types is selected, progress is calculated as an average % of set attendance from all course sessions.
IMPORTANT: You can specify the attendance percentage to set course completion while creating or editing course. It can be registered 25% attendance, registered 50% attendance, registered 75% attendance, or registered 100% attendance. Course is completed if learner’s percentage of attendance is equal to or more than it was set in Course Completion and learner has passed all necessary learning items correctly or Course Administrator has manually set completion in the Gradebook or directly via Course Progress. |
Example: If there is a course that has Enroll user into a single course session enrollment type and minimum attendance percentage for the course completion is set:
| Required attendance |
Learner’s attendance |
Attendance progress |
| Registered 50% Attendance |
50 - 100% |
100% |
| Registered 50% Attendance |
25% |
50% |
| Registered 50% Attendance | Absent (Informed) is counted as 1% |
2% |
Calculation of progress for a course without learning items
|
Enrollment Type |
Single session type |
All session type |
|
Learner’s attendance is not set |
No progress |
No progress |
| Learner’s attendance is less than passing attendance (passing attendance is 50%, learner’s attendance is 25%) | Course progress is 50%.100 * learner’s attendance / passing attendance is (100*25)/50). | Learner’s attendance is calculated as an average for all sessions. Course progress is 50%.100 * learner’s attendance / passing attendance is (100*25)/50. |
| Learner’s attendance is equal to or more than passing attendance (passing attendance is 50%, learner’s attendance is 50%/75%/100%) | Course progress is 100%. | Learner’s attendance is calculated as an average for all sessions. Course progress is 100%. |
If tools (e.g. SCORM or Quiz) are provided for Classroom or Webinar courses, learning items that are set as required for the course completion are calculated in the course progress as well.
Example: Learner’s attendance is not set (passing attendance is 50%) and learner’s attempt for learning item is 100%, then course progress is 50%.
Calculation of progress for learning items
-
-
Learning Module’s progress is calculated as a percentage of passed steps among all steps included into it. For example, there are 4 items in the Learning Module, learner has passed 2 of them, and their progress will be 50%.
-
Quiz’s progress is calculated as a percentage of earned score regarding the passing score. For example, passing score is 80% and maximum number of points is 200, that means that learner have to earn 160 points to complete the Quiz, and if they earn 120 points, their progress will be calculated as 120/160 * 100% is 75%.
-
Content Package’s progress is calculated as a progress set in the content package or as a percentage of passed SCO regarding all SCO.
-
-
Assignment’s progress will be calculated as a percentage of earned grade regarding the percentage required for the completion. For example, learner’s grade for the assignment is 79% and percentage required for the completion is 80%, learner’s progress will be set to 99%).
-
External App’s progress can be 0% when it has Not Started status or 100% when it has Completed status.
-
Comments
Article is closed for comments.