Export All Quiz Answers from All Students as a CSV or EXCEL spreadsheet or XML data structure

[RichardGolden]

We are developing new psychometric methods for student response data analysis. Is there a way to export the  individual responses of all students to all questions for a quiz such as a CSV or EXCEL or XML data structure. It is important that the data file contains the responses of individual students to individual questions. Although I could find a method for exporting the response data from 1 student to all questions in a quiz to a data file, we do not want to repeat this process 50 times for a class of 50 students and then merge the resulting data files.  

[Ron_Bowman · Accepted solution]

@RichardGolden 

Yes for classic quizzes.  Click on your quiz.  Click on Quiz Statistics.  Click on student analysis - you will get a csv file to download that has each students answer to the questions.

For new quizzes, I do not know because I have not started using them yet

[MMat]

Whoever marked this solved needs to remove and put partially solved. New quizzes is supposed to be where Canvas is moving, so how do you do this with new quizzes is the question.   New Quizzes is not setup the same way as classic quizzes and does not have the same quiz statistics csv function

[mprogers]

It's been over a year ... any progress on this?

[JohnMancinelli]

For New Quiz formats, here is what I've learned:

1. There is no way to download the student response data.  Discouraging.  I wasted time using the tool, in my case, without the ability to analyze the data.