Understanding the Course/Training Plan Progress dashboard and report

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.

 

How to read the table: Some calculations require more details to fully understand. In the table, we have added the Explanation column to elaborate on the calculations in these cases. The items in the table are numbered (see left column) and marked with the same number in the training progress examples shown above (based on an example of a course report, the same logic is applied to the training plan reports). The graphical diagrams at 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 is based on the same data, but there may be differences in what is shown and how it is presented, and, in some cases, in the labels.  A number from the table can refer to both an item in the dashboard view and in the Excel report. The identical columns have a number on the dashboard and no number in the Excel report. In the table below, they are mentioned in brackets under the related number.

 

 

 

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 ever completed the course.	Once a learner completes the course and is unenrolled from it, they will be counted here. Once a learner retakes the course, the learner will not be counted again, meaning that the total number will not change, unless new learners complete the course.
3. Average Course Rating	Diagram	Average of all ratings received.	If the rating was hidden via selected Course > Manage Rating > Hide Rating, it will not be counted in the average.
4. Completed	Diagram	Number of the currently enrolled learners who have completed the course.	For the Instructor-Led Training, 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 the Instructor-Led Training 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 and percentage of enrolled learners who have overdue courses/training plans.	Once the due date has passed, and the learner has not completed the course/training plan, they will be counted here. Once the due date has 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: E-learning course with learning items Instructor-Led Training Course without learning items Learning items If you set the course completion manually, the 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. Once you click the expand button next to the learner’s name, you will see the progress of each item.
12. Score	Dashboard list, Excel report	Learner’s average score of the learning items.	The calculation depends on the learning item. Quiz 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 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 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 (Date Completed in the Excel file)	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 or  Instructor-Led Training.
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.	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 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 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.

 

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 (for example, SCORM or Quiz) are provided for the Instructor-Led Training, learning items 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 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 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 progress is calculated as a progress set in the content package or as a percentage of passed SCO regarding all SCO.

• Assignment 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 progress can be 0% when it has the Not Started status or 100% when it has the Completed status.