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?