Learn@UW - Saving Quiz Statistics and Reports

You can save the statistics for a quiz that has been taken by students as a .csv file that can be opened with Microsoft Excel and other spreadsheet applications. You can also save a Report for a quiz as .csv file. The information provided by statistics and reports is somewhat similar.

Quiz Statistics
Quiz Reports


Quiz Statistics

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

  • User Statistics - includes students' quiz scores.
  • Question Statistics - includes average scores by question.
  • Question Details - includes number of times various responses were made for the questions.

Follow the procedure below to export statistics for a quiz:

  1. Go to the Quiz tool.

  2. Select Statistics from the drop-down by the quiz name.

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

    • User Stats - for user statistics
    • Question Stats - for question statistics.
    • Question Details - for question details.
    • Export Statistics

  4. The results will be displayed. Press the Export to CSV File button near the top.

  5. When the file is ready to be downloaded, you will have the option to save the file.

Note: The exported file may contain sensitive information such as private student information. Store the file in a secure, password-protected location.


Quiz Reports

You can save any of the following types of reports that have been created for a quiz:

  • 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.

Follow the procedure below to export a report for a quiz:

  1. Go to the Quiz tool.

  2. Select Reports from the drop-down by the quiz name.

    Quiz Reports
  3. A list of available reports your role has access to view will be displayed. Select the link for the report you wish to export.
    Pick report
  4. Optionally, choose the earliest and latest dates to specify a time period for including attempts in the report. If the report has too much data to export it all at once, try exporting it in portions by date ranges.

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

    Report Example

  6. Press Generate CSV Report.

  7. When the file is ready to be downloaded, you will have the option to save the file.

  8. Press Done when finished.

Note: The exported file may contain sensitive information such as private student information. Store the file in a secure, password-protected location.




Keywords:brightspace learn@uw learnuw d2l desire2learn export save quiz statistics report   Doc ID:37363
Owner:Susan D.Group:Learn@UW Utility
Created:2014-02-07 09:54 CDTUpdated:2015-06-04 11:48 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Learn@UW Madison, Learn@UW Utility
Feedback:  0   0