Generate quiz reports

Introduction

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

The Quiz 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 reports via the Training Management page (where they are called course reports), see this article.

 

Generate quiz reports

Required role: catalog admin.

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

2. Select Download reports > Quiz. The Quiz reports panel opens.

3. From the opened Quiz 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 Quiz. 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 quizzes for the selected courses. It also tracks general information about learners' attempts to complete the quizzes. The report output will be grouped by learner.
• Quiz. This report tracks general information about quiz completion and the number of attempts it took learners to complete them for the selected courses. The report output will be grouped by quiz.

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 quiz 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 quiz 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 quiz 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 quizzes.

• 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 quiz, the Select scope drop-down list enables you to select All quizzes 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 Quiz report grouped by learner

 

The Quiz report grouped by learner includes the following columns:

• Course site. Shows the course that contains the quiz. 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 quizzes in the course.
• Learning item name. The name of the quiz.
• Completion status. The completion percentage of the quiz for each learner. For individual learners, the Status of their current attempt is displayed. Where learners took several attempts to complete the quiz, only the progress for the last one is displayed. The statuses are:
  • Passed. The learner has passed the quiz.
  • Not started. The learner hasn't started the quiz yet. 
  • In progress. The learner has started quiz but hasn't finished it yet.
  • Completed. The learner has completed the quiz.
  • 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 quiz and has no more attempts left.
  • Locked. The learner can't start the quiz because they don't meet the prerequisites.
• Date completed. The date on which the learner completed this quiz. Select the cell to see the time it was completed.
• Passed. The percentage of quizzes in the course that the learner has passed. For individual quizzes, this shows whether the learners have passed them.
• Score. For individual quizzes, the learner's percentage score is displayed.
• Average time spent. Displays the average time that the learner took to complete the quizzes in the course. For individual quizzes, it displays the average time learners spent on their attempts to complete them.

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

If the current attempt to complete the quiz isn't completed, time is calculated from the moment the learner started the quiz 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 quiz, 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 quizzes in the course. For individual quizzes, 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 Quiz report grouped by quiz

 

The Quiz report grouped by quiz includes the following columns:

• Course site. Shows the course that contains the quiz. The course title is an active link, which redirects you to the course home page.
• Learning item name. The name of the quiz.
• Upload date. The date the quiz was uploaded. Select the cell to see the time it was uploaded.
• Learner’s name. Displays the name of the learner.
• Email, Department, Office, City, Country. Displays additional information about users, if this is available.
• Status. The completion status of the quizzes for each learner. Where learners took several attempts to complete the quiz, only the progress for the last one is displayed. The statuses are: 
  • Passed. The learner has passed the quiz.
  • Not started. The learner hasn't started the quiz yet. 
  • In progress. The learner has started the quiz but not finished it yet.
  • Completed. The learner has completed the quiz.
  • 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 quiz and has no more attempts left.
  • Locked. There are prerequisites that prevent learners from starting the quiz.
• 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 quiz.
• Number of attempts. Shows the number of learner attempts for this quiz. For individual learners, it displays the number of attempts they took to complete the quiz.
• Average time spent. Displays the average time learners took to complete the quiz. For individual learners, it displays the average time the learner spent on their attempts to complete this quiz.
• Score. For individual learners, their percentage score for the learning module is displayed.
• Date completed. The date on which learners completed the quiz. Select the cell to see the time it was completed.
• Time zone. Displays UTC+00:00, regardless of any other time zone settings.