[ARCHIVED] Is there a way to query the score for each quiz question by each student?

[dus73]

I can get the final quiz score from quiz_submission_fact. But how to query the score for each individual quiz question?

[sam_mcknight · Accepted solution]

That data is not included natively in the Canvas Data product. There's a report in Canvas called Student Analysis. We use the REST API to download the quiz report and put the data into our own table. It has worked well for us.

[dus73]

It works! Thank you very much!