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

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.

Find more posts tagged with

Canvas

Accepted answers

Ron_Bowman

@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

JohnMancinelli

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

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.

All comments

Ron_Bowman

@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:

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.

CraigJ

Still no solution for New Quiz?

adbouguen

Still no answer for your valid question? How can we use new quizzes if we cannot download data ?

Canvas is very slow at solving very basic issue like this one....

Unanswered Questions

Dropped Scores
I have Canvas set to drop the lowest quiz score, however, my students can only barely tell that the grade text is slightly grey when dropped. Can it have a tag like the "missing" and "exempt" ones in the student gradebook?
Batch edit assignment due dates by section
My Canvas shell has three different sections that all meet at different times throughout the week. I need to be able to batch edit assignment due dates by section, but right now Canvas can't filter by section for batch edit. My only option is now to manually (tediously) edit due dates for each assignment individually.
Change Group Assignments to NOT save if no groups are selected
Morning! One of the more frustrating aspects of Canvas are groups and the issues that show up when copying courses that have them. But now we have yet another issue. Most recently we have had instances where people mark an assignment/discussion as a group assignment but then do not link the discussion or assignment to any…
Has anyone experienced the "Empty Course" page for Speedgrader, when there actually are students assigned and active on the assignment?
So, we have encountered a few assignments where the Speedgrader presents the teacher with the "Empty Course" page, even though the course is not empty. I have discovered two New Quizzes in the same course where this has occurred, despite multiple students being assigned (at Module level, which passes the permission down to…
Problems with grading since update
A teacher has expressed concerns with the recent update. Exact concern is as follows: "My Canvas has been acting glitchy since the last "update." For instance, when I grade essays the highlight and cursor tools do not always work. I have to try highlighting several times,or come back later to finish. It's told me I "ran…