NOTE: The system exports the statistics only from the tab you are currently viewing.
To export quiz statistics:
-
Follow steps 1-5 above to access your Quiz Statistics page.
-
Select one of the three tabs (User Stats, Question Stats, or Question Details) at the top of the Quiz Statistics page.
-
Select Export to CSV or Export to Excel.

You will now be able to open the exported excel or .csv file on your computer. Where you access the downloaded file is dependent on your Operating System and browser.
Data exported for Question Details
|
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 are 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 are 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.
|
Quiz Statistics Key Terms
Standard deviation (SD): How much variation there was in the scores for this question or a measure of the spread of scores about the mean and hence the extent to which the question might discriminate. If F is very high or very low it is impossible for the spread to be large. Note however that a good SD does not automatically ensure good discrimination.
Discrimination index: This is the correlation between the weighted scores on the question and those on the rest of the test. It indicates how effective the question is at sorting out able students from those who are less able (students who score highly on this question are the same students who score highly on the whole quiz).
Point Biserial: Point Biserial calculates any possible correlation between the question score and the total quiz score. It measures the strength of the correlation between the two values, and shows either a positive or a negative relationship ranging from -1.00-+1.00.
Still Need Help?
To explore guides created by D2L, visit the Brightspace Help Site. Note that you will need to create an account to access content within the Brightspace Community.
Ask CIT! Email us or submit a request and we'll be happy to assist you.