Introduction
The Learner's Progress dashboard and Excel report provides data on the training progress of a specific learner.
In this guide, we will describe how this progress is calculated and explain how to understand the data shown by the dashboard and the Excel report.
What does the Learner's Progress dashboard and report show?
The Learner's Progress dashboard and the Excel report present information based on all data available for the learner. This means that data for all training the learner has been enrolled in is displayed.
In the table below, you can find explanations of how to read and understand the information about the learner’s progress in the dashboard and the Excel report, the data they present and calculations behind each bit of information.
NOTE
- Some calculations require more details to fully understand, and you may find a link in the Explanation column to an elaboration.
- The items in the table are numbered (see the left column) and marked with the same number in the Learner’s Progress examples shown above.
- The graphical diagrams on top of the dashboard view (items 1-7) sum up information from the list below and the Excel report.
- The information in the dashboard list and the Excel report are based on the same data, but there may be differences in what is shown and how it is presented, and in some cases labels.
- A number from the table can refer to both and item in the dashboard view and in the Excel report. In that case in the Explanation column you will see the number for the Excel report.
Course Progress Dashboard and Report |
In |
Calculation- what is counted or displayed |
Explanation- limitations or important things to be aware of |
1. Total Trainings Enrolled |
Diagram |
Number of the trainings (courses and training plans) that learner is currently enrolled |
The imported training and deleted trainings that the learner was enroll in are counted here as well. |
2. Total Trainings Completed
|
Diagram |
Number of the trainings that learner has ever completed |
The trainings that were retaken and those that were completed but cancelled (unenrolled) will be counted here. The imported external trainings or completed trainings that were deleted will not be counted here. |
3. Total CEUs |
Diagram |
Total number of CEUs that the learner has received for the completed trainings |
CEUs counted here include earning credits for all trainings the user has completed (even for deleted, imported, and cancelled trainings). Once the learner retakes the training, the CEUs will not be counted here. |
4. Average Score |
Diagram |
Average score for all trainings |
If there are not any training that have score, this value will be 0. |
5. Completed |
Diagram |
Number of trainings that have been completed by learner (deleted, cancelled, imported, but not retaken) |
The number that is shown in the Completed field is equal to those on the grid view. For the Instructor-Led Training this status means that learner’s registered attendance matches attendance required for the course completion. |
6. In Progress |
Diagram |
Number of trainings that have been started but not completed yet |
The number that is shown in the In Progress field is equal to that on the grid view. For the Instructor-Led Training, this status means that learner’s attendance has been registered. |
7. Not Started |
Diagram |
Number of trainings that have not been started yet |
The number that is shown in the Not Started field is equal to that on the grid view. |
8. Overdue |
Diagram |
Number of trainings that have not been completed up to the Due Date |
The number that is shown in the Overdue field is equal to that on the grid view. The deleted, cancelled trainings that have the overdue status are also counted here. |
9. Name (Course Title) |
Dashboard Excel report |
The title of the course |
On the dashboard list, the row with the title can be clicked to expand details about the progress on the different elements in the course (№ 25 in the Excel report). |
10. Is Enrolled |
Dashboard, Excel report |
Whether the learner is enrolled in the training |
No is displayed when learner has been unenrolled from the training or has an enrollment request for the training (№ 29 in the Excel report). |
11. Status
|
Dashboard, Excel report
|
The completion status (Not Started, In Progress, or Completed) |
The detailed information on each learning item of the course is collapsed. Once you click expand button next to the title of the course, you will see the learning items’ statuses (№ 32 in the Excel report). |
12. CEUs |
Dashboard, Excel report |
Number of CEUs earned or set manually |
If there are any CEUs that are set for the course, this field will be empty (№ 31 in the Excel report). |
13. Progress |
Dashboard, Excel report |
Learner’s progress |
The calculation of progress depends on the course and enrollment type (№ 30 in the Excel report). 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 but the course completion is not, the progress will be recalculated. 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. |
14. Score |
Dashboard, Excel report |
Learner’s average score of the training as well as of learning items. |
The calculation of score for the learning items depends on their type. If the completion of the learning item is set manually, the score will be 100%. The score for the training is equal to the average score of the learning items that are added to the training and have score. |
15. Completed |
Dashboard, Excel report |
The date the learner has completed the course (№ 35 in the Excel report). |
|
16. Certificate |
Dashboard, Excel report |
Learner’s certificate |
It is shown when user has a certificate (№ 37 in the Excel report). |
17. Learner Name |
Excel report |
The name of the learner. |
|
18 - 24 |
Excel report |
The learner’s additional information: Email, Department, Job Title, Manager, Office, City, Country |
|
25. Course Title |
Excel report |
The title of the course (see № 9). |
|
26. Course Type |
Excel report |
The type of the course. |
It can be either e-learning or the Instructor-Led Training. |
27. Category |
Excel report |
The category that was specified for the course |
|
28. Course ID |
Excel report |
The ID of the Course if it was set |
|
29. Overdue Status |
Excel report |
Whether the learner completed the course on time or after the due date (overdue) |
|
30. Due Date |
Excel report |
The date when the learner must complete the course by |
The due date depends on the selected Due Date option for the training. If number of days after enrollment is set, the due date that is shown in the report will depend on the enrollment date for each learner. If you set Fixed Date, the due date will be the same for all users. |
31. Time Completed |
Excel report |
Course completion time |
Shown for completed courses only. |
37. Certificate |
Excel report |
Learner’s certificate |
It is shown when user has a certificate. |
38. Certificate Expiry Date |
Excel report |
The date when certificate will expire |
|
39. Certificate Expired |
Excel report |
Whether the certificate expired |
If expired, it will be marked with: Yes. |
How learning items score is calculated
The calculation of score for the learning items depends on their type:
- 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.
Calculation of progress
Calculation 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 5 learning items and only 3 of them are set as requited 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% | 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 3) that are set as required. So, we have: (100%+50%+0%)/3 = 50%.
Calculation for the Instructor-Led Training
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.
NOTE: 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.
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 for a course without learning items
Enrollment Type | Single session type | All sessions 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 the Instructor-Led Training, 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%.
Comments
Article is closed for comments.