Generate content package reports

Introduction

In this article, you'll find information about how to generate course reports relating to content packages, and how to download and read them, via the Reports page.

The Content package reports are available from two areas of the Learn365 Admin Center. The configuration of the reports differs slightly depending on where you open them, and the report outputs are similar. For information about how to generate these report via the Training Management page (where they are called course reports), see this article.

 

Generate content package reports

Required role: catalog admin.

1. Go to the Learn365 Admin Center > Reports. The Reports page opens.

2. Select Download reports > Content package. The Content package reports panel opens.

3. From the opened Content package reports panel, set the relevant values in the fields to build your report.

4. In the Search courses section, select the courses for which you want to run the report. Select All courses or specific courses. What you choose here will determine whether you can select an item from the Select scope drop-down list.

5. In the Group by section, select the value by which you want to group the information in the report: Learner or Content package. The value you select here will determine the values available in the Select scope drop-down list.

 

 

• Learner. This report tracks how learners have performed with content packages for the selected courses. It also tracks general information about learners' attempts to complete the content packages. The report output will be grouped by learner.
• Content package. This report tracks general information about content package completion and the number of attempts it took learners to complete them for the selected courses. The report output will be grouped by content package.

6. In the Include users section, select one of the following: Active, Inactive, or All. The value selected here determines the learners who will be available from the Select scope drop-down list, when Learner is selected in the Group by field.

• Active. This is the default value. The report will include content package completion information for learners whose accounts are currently active in Microsoft Entra ID (Azure Active Directory) and who have ever been enrolled in this course. In this case, only active users will be available from the Select scope drop-down list.
• Inactive. The report will include content package completion information for learners whose accounts were disabled or deleted in Microsoft Entra ID (Azure Active Directory) and who have ever been enrolled in this course. In this case, only inactive users will be available from the Select scope drop-down list.
• All. The report will include content package completion information for both active and inactive learners. In this case, both active and inactive learners of this course will be available from the Select scope drop-down list.

7. In the Include enrollments section, select one of the following: Active, Cancelled, or All.

• Active. This is the default value. The report will include the selected learners who have active current enrollments in this course.
• Cancelled. The report will include the selected learners whose enrollments in this course were cancelled by a catalog or course admin, or by themselves.
• All. The report will include both Active and Cancelled enrollments of the selected learners.

8. In the Select scope section, select the relevant value.

The values selected in the Search courses, Group by, and Include users sections determine the items available in the Select scope drop-down list. The values will be either a list of learners or content packages.

• If you select All courses or multiple courses from the Search courses drop-down list, the Select scope section becomes inactive.
• If you select an individual course and choose to Group by learner, the Select scope drop-down list enables you to select All learners who are defined in the Include users section or a specific learner.
• If you select an individual course and choose to Group by content package, the Select scope drop-down list enables you to select All content packages in the course or a specific one.

9. To generate a report that will include information about learners' attempts made within a date range, set the relevant Start date and End date. If you leave these fields blank, the report will include course information from the date they were published up to and including the date the report is generated.

10. When you're ready, select Export to Excel to generate the report.

When the report is generated, it will be downloaded to your device as an Excel file and will be available under Notifications (the bell icon). The report will display information in the language defined for the catalog via the Locale setting in the Learn365 Admin Center > Catalog settings > LMS Configuration > Regional settings. For more information, see this article.

 

Explanation of the Content package report grouped by learner

 

The Content package report grouped by learner includes the following columns:

• Course site. Shows the course that contains the content package. The course title is an active link, which redirects you to the course home page.
• Learner’s name. Displays the name of the user.
• Email, Department, Office, City, Country. Displays additional information about users, if this is available.
• Number of training items. The number of content packages in the course.
• Learning item name. The name of the content package.
• Completion status. The completion percentage of the content packages for each learner. For individual content packages, the Status of the current attempt is specified. Where learners took several attempts to complete the content package, only the progress for the last one is displayed. The statuses are:
  • Passed. The learner has passed the content package.
  • Not started. The learner hasn't started the content package yet. 
  • In progress. The learner has started content package but hasn't finished it yet.
  • Completed. The learner has completed the content package.
  • Failed. The learner has failed the current attempt but has more attempts available to complete it.
  • Out of attempts. The learner hasn't passed the content package and has no more attempts left.
  • Locked. The content package has prerequisites and can't be started by the learner.

• Date completed. The date on which the learner completed this content package. Select the cell to see the time it was completed.
• Passed. The percentage of content packages in the course that the learner has passed. For individual content packages, this shows whether learners have passed them.
• Score. The learner's average percentage score for all content packages in the course. For individual content packages, the learner's percentage score is displayed. This information is displayed only if the score is provided by the content package.
• Average time spent. Displays the average time that the learner took to complete the content packages in the course. For individual content packages, it displays the average time learners spent on their attempts to complete them.

The Average time spent for an attempt is calculated in the following way:

If the current attempt to complete the content package isn't completed, time is calculated from the moment the learner started the content package until the moment they closed the Learn365 player. If the learner resumes an incomplete attempt in the Learn365 player, the time tracking will resume as well until they close the Learn365 player again or complete the attempt. If the learner starts a content package, then breaks for a while without closing the Learn365 player, the time counter will continue.

As a result, the completed attempt will show the time spent by the learner to complete the attempt from the moment an attempt was first started until it was completed.

• Attempts. The total number of attempts that the learner took to complete the content packages in the course. For individual content packages, it displays the number of attempts each learner took to complete them.
• Time zone. Displays UTC+00:00, regardless of any other time zone settings.

 

 

Explanation of the Content package report grouped by content package

 

The Content package report grouped by content package includes the following columns:

• Course site. Shows the course that contains the content package. The course title is an active link, which redirects you to the course home page.
• Learning item name. The name of the content package.
• Upload date. The date the content package was uploaded. Select the cell to see the time it was uploaded.
• Learner’s Name. Displays the name of the user.
• Email, Department, Office, City, Country. Displays additional information about users, if this is available.
• Status. The completion percentage of the content packages for each learner. Where learners took several attempts to complete the content package, only the progress for the last one is displayed. The statuses are: 
  • Passed. The learner has passed the content package.
  • Not started. The learner hasn't started the content package yet. 
  • In progress. The learner has started the content package but not finished it yet.
  • Completed. The learner has completed the content package.
  • Failed. The learner has failed the current attempt but has more attempts available to complete it.
  • Out of attempts. The learner hasn't passed the content package and has no more attempts left.
  • Locked. There are prerequisites that prevent learners from starting the content package.
• Number of learners. Shows the number of learners on which the report is built.
• Passed. For individual learners, this shows whether they have passed the content package.
• Number of attempts. Shows the number of learner attempts for this content package. For individual learners, it displays the number of attempts they took to complete the content package.
• Average time spent. Displays the average time learners took to complete the content package. For individual learners, it displays the average time the learner spent on their attempts to complete this content package.

The time spent on an attempt is calculated in the following way:

If the current attempt to complete the content package isn't completed, time is calculated from the moment the learner started the content package until the moment they closed the Learn365 player. If the learner resumes an incomplete attempt in the Learn365 player, the time tracking will resume as well until they close the Learn365 player again or complete the attempt. If the learner starts a content package, then breaks for a while without closing the Learn365 player, the time counter will continue.

As a result, the completed attempt will show the time spent by the learner to complete the attempt from the moment an attempt was first started until it was completed

• Score. For individual learners, their percentage score for the content package is displayed, if the score is provided by the content package.
• Date completed. The date on which learners completed this content package. Select the cell to see the time it was completed.
• Time zone. Displays UTC+00:00, regardless of any other time zone settings.