[ARCHIVED] what was the answers of quizes of each student .

[integracion_can]

I need to analyze the answers of each quiz from differents courses but I just get the submission of each one. I can't found the specific answer by student.

I am using canvas data

In the tables quiz_question_answer_fact, quiz_submission_historical_dim and , quiz_fact I get the questions, the answers and the weight  of the quiz but I need what was the selection of each student.

In the table quiz_submission_historical_fact I get the submit the time but I can't see the answers.

Somebody can help me?

[bneporadny]

Hi Usuario Integración,

I believe you need to get the answers out of the quiz_question_answer_dim table. 

[James]

Canvas Data does not contain the responses of individual students.

The quiz_question_answer_dim gives the possible responses and particulars about the available questions, but it is not tied to a particular quiz_submission.

To get that information reliably, you should use the Submissions API where you get submissions and include[]=submission_history. This adds in the responses of the students.

Another other way to get results is to go into the Quiz and generate the student analysis report, but it's not very usable for certain types of questions (say multiple choice questions where there are commas in the responses).

[integracion_can]

Thanks, I will try using Submissions API .