Getting New Quiz Responses from Canvas Data 2

[MikeBrinkman]

I have an instructor that created new quizzes for an entrance survey and an exit survey that gauges students' knowledge pre & post course.

I've downloaded our Canvas Data 2, and loaded it all into PowerBI.

I've looked at the schema online, but I'm having a difficult time figuring out what the related tables for this should be. I tried linking course -> assignment -> quiz, but that doesn't give any results. Does that refer to classic quizzes?

I also see an assessment questions, and assessment question banks, but no assessment results, etc.

[KeithSmith_au · Accepted solution]

The quizzes table in Canvas Data 2 is Classic Quizzes.

New Quiz data is not available in Canvas Data 2.  The best you would be able to get would be the assignment details, but not the actual quiz items, be it questions or responses.

[MikeBrinkman]

Thanks, good to know. I wonder how long it is going to take to get this data included? I thought I had previously seen that this was going to be done last summer. Right now I'm regretting that we chose new quizzes as the defacto method for quizzes.

[luisromo]

Hi there,

I hope you're doing well. I wanted to follow up to check if there are any updates regarding accessing quiz responses. I'm specifically looking for a way to retrieve responses for both Old Quizzes and New Quizzes. If a solution is available for either or both, I’d greatly appreciate it if you could share the details.

Thanks in advance for your help!

[stimme]

@luisromo , New Quizzes tables are not available in Canvas Data 2 yet. According to the roadmap on the New Quizzes Hub, those are expected in 2025 Q3 or Later. Later seems likely to me.

For Classic Quizzes, check out the canvas.quiz_submissions table's submission data field. It contains info about submissions in JSON object. That data refers to question_id values from the canvas.quiz_questions table.