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

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.

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

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

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

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

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

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

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