CD2: classic quizzes and scores

Question

I've run into a roadblock trying to associate scores w/ quizzes (classic)

From the scores tables, the only linkages are assignment_groups, enrollments, grading_periods.

However, assignment_groups are not individual assignments nor quizzes.

How do I get to a unique quiz's score then?

pgo586 · Answer

Hi, I just did a quick table search to see if one could get from a given quiz (taken by somebody) to a given score. Turns out there is a 'quiz_submissions' table, which happens to have a score field in it (and a user). I suspect this may be helpful.

IanGoh · Answer

Checking if I also need assignment_groups?

Hmm... don't think that will help because there's still only one score for the entire assignment group.