D2L Quizzes - Saving Quiz Statistics and Reports

Learn how to save the statistics and reports for quizzes and surveys as a CSV file.

Before you begin

Some of the information that can be exported is FERPA-protected. Save the information on university-owned computers and university services. For more information or for guidance, contact the 

Exporting quiz statistics

You can save the following for a quiz that has been taken by student:

  • User Statistics - CSV files contain performance data by user, including: the user’s Org Defined ID, username, first name, last name, quiz score, the value the quiz was graded out of, the user’s score as a percentage, and the class average.
  • Question Statistics - CSV files contain data about the average score on questions by points and percentage. The question title, text, bonus status, and difficulty level are included in the CSV file.
  • Question Details - CSV files contain detailed information about each question in the quiz, including a list of all of the answers provided for each quiz attempt, how many users chose each possible answer, the total number of responses, and the average score on the question. The question title, text, bonus status, and difficulty level are included in the CSV file.

Steps

  1. Go to the Quiz tool.
  2. Click the triangle (chevron). Select Statistics.

    Quiz Statistics

  3. Select the tabbed page for the statistic you wish to export:

    Export Statistics

    • User Stats - for user statistics
    • Question Stats - for question statistics.
    • Question Details - for question details.
  4. The results appear on the screen. Click the Export to CSV File button.
  5. A new window will open temporarily. As soon as the CSV file is ready, you will be prompted to save the file, or your browser will automatically download it.

What is exported?

Description of Exported Data by Question Type
Question Type What is exported
Multiple Choice All of the possible answers and the number of responses for each answer.
True or False All of the possible answers and the number of responses for each answer.
Long Answer All of the responses provided listed on separate rows.
Short Answer The correct answer for each blank and an additional row for all other answers, and the number of responses for the correct answer versus other answers.
Multi-Short Answer The correct answers for each blank and an additional row for all other answers, and the number of responses for the correct answer versus other answers.
Fill in the Blanks The correct answers and an additional row for other answers, and the number of responses for the correct answer versus other answers.
Multi-Select All of the possible answers and the number of responses for each answer.
Matching All of the possible matches and the number of responses for each match.
Ordering All of the answers in the order match and the number of responses for each match.
Arithmetic Questions broken down by results and units. Also lists which users had both results and units correct, only results correct, only units correct, and neither correct.
Significant Figures Questions broken down by results and units. Also lists which users had both results and units correct, both results and units correct as well as significant figures, only results correct, only results and significant figures correct, only units correct, and neither results or units correct.

Exporting quiz reports

The following reports are available:

  • Question Statistics - includes average scores by question.
  • Question Details - includes number of times various responses were made for the questions.
  • User Statistics - includes students' quiz scores.
  • Attempt Details - includes questions, responses, and scores for each question of every quiz attempt.
  • User Attempts - includes quiz scores, start times, and completion times of every quiz attempt.

Steps

  1. Go to the Quiz tool.
  2. Click the triangle (chevron). Select Reports.

    Quiz Reports

  3. A list of available reports appears. Select the link for the report you wish to export.

    Pick report

  4. Choose the earliest and latest dates to specify a time period for including attempts in the report (optional). If the report has too much data to export it all at once, try exporting it in portions by date ranges.

    Export report

  5. Click the Generate HTML Report button to preview the results on your computer, and then press Go Back to Generate Report when ready.

    Report Example

  6. Click the Generate CSV Report button.
  7. A new window will appear temporarily. Your browser will either download the file automatically, or will prompt you to save the file.
  8. Click the Done button to finish.

What is exported?

Description of exported data by report type
Report Type What is exported?
Question Statistics The average score on questions by points and percentage.Unlike a report created using the Questions Stats tab on the Quiz Stats page, you can choose to exclude the class average, score distribution, bonus questions, or the Out Of value.
Question Details All of the answers provided for each quiz attempt, how many users chose each possible answer, the total number of responses, and the average score on each question.Unlike a report created using the Question Details tab on the Quiz Stats page, you can choose to exclude the level of difficulty, text responses, or bonus questions. You can also choose to include private comments added to the report.
Users Statistics The class average, score distribution, and the grade of each user.Unlike a report created using the User Stats tab on the Quiz Stats page, you can choose to exclude the class average, score distribution, or Org Defined ID.
Attempt Details The Org Defined ID, username, first name, and last name of each user. Detailed information about each question. The users’ responses for each question organized by attempt, including how long each attempt took.The ability to set a start or end date for which attempts to include.
User Attempts The Org Defined ID, username, first name, and last name of each user. The users’ score for each question in points and percentage organized by attempt, including how long each attempt took.The ability to set a start or end date for which attempts to include.



Keywords:d2l d2l@uwm brightspace learn@uw learnuw d2l desire2learn export save quiz statistics report   Doc ID:71923
Owner:David D.Group:UW-Milwaukee Center for Excellence in Teaching and Learning
Created:2017-03-21 11:28 CSTUpdated:2017-03-21 14:51 CST
Sites:UW-Milwaukee Center for Excellence in Teaching and Learning
Feedback:  0   0