D2L - Saving Quiz Statistics (User Stats, Question Stats, Question Details) (UW-Madison)


UW-Madison is adopting Canvas as the single, centrally supported learning management system, and discontinuing support for Desire2Learn (D2L) and Moodle. Access to D2L and Moodle will permanently end June 1, 2018. For information about retaining materials from D2L or Moodle, please refer to this document.

Quiz statistics are exported from D2L in the form of a .CSV file, which can be opened and modified using Microsoft Excel, OpenOffice and a number of other spreadsheet applications. Note: some kinds of information in regards to quiz responses can be obtained from either the 'Stats' page for each quiz, or in the 'Reports' area for each quiz.

  1. Login to D2L and access your course. Click Quizzes from the dropdown menu found by clicking the arrow next to Assignments Quizzes.png.

  2. Click the arrow next to the name of the quiz you wish to export data from and chose Statistics.


  3. Select the tab corresponding to the kind of information you wish to export.


    1. 'User Stats' displays summary information on how well each student in your course performed. Report data includes point score, percentage, class average, and standard deviation.

    2. 'Question Stats' displays summary average score information for the questions used in a quiz. Report data includes Question type and text, the various answers of the question, difficulty, average response value, number of points, percentage and class average. It also includes the standard deviation, discrimination index, and point biserial correlation coefficients (descriptions of what each of these statistics describes can be seen below).

      • Standard deviation: the standard deviation indicates how much scores vary from the average, ranging from 0% to 100%. A high standard deviation indicates that scores are spread out from the average, whereas a low standard deviation indicates that scores are close to the average.

      • Discrimination index: the discrimination index indicates how well a question differentiates between high and low performers. It can range from -100% to 100%, with high values indicating a “good” question, and low values indicating a “bad” question.

      • Point biserial correlation coefficients: the point biserial correlation coefficient is an analysis only applied to multiple choice and true/false question types that have only one answer with weight 100%, and all others with weight 0%. Similarly to the discrimination index, the point biserial correlation coefficient relates individuals’ quiz scores to whether or not they got a question correct. It ranges from -1.00 to 1.00, with high values indicating a “good” question, and low values indicating a “bad” question.

    3. 'Question Details' report data shows the same information as 'Question Stats' and also displays the number of responses and statistics for all possible quiz answers. You will have the option to choose a date range to export. When specifying a start and end date, data for attempts within that range will be exported to .CSV.

  4. Select the 'Export to CSV' button.


    A window will open indicating that D2L is working to gather the information. When complete, the window will close and you will be prompted to save the .CSV file.


Keywords:learn@uw learnuw d2l desire2learn save saving quiz statistics user stats question details   Doc ID:9531
Owner:Learn@UW Madison .Group:Learn@UW Madison
Created:2009-04-07 19:00 CDTUpdated:2017-12-01 12:21 CDT
Sites:DoIT Help Desk, Learn@UW Madison, Learn@UW Utility
Feedback:  1   1