what was the answers of quizes of each student .

integracion_can
Community Explorer

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?