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 an “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 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, 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.

 

numbers.png

 

mceclip1.png

 

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 – Hidden”, it will not be counted in the average.

4. Completed

Diagram

Number of the currently 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 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 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
(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, 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.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

Article is closed for comments.