Identify Courses with Classic Quizzes

[bweaver4]

I'm part of the support team at a small private college (around 1500 students) and we're working towards migrating all our courses' classic quizzes to new quizzes. I was curious if there was a way to quickly identify the specific course sections that are utilizing classic quizzes, so that we don't have to open each course and view their quizzes. I assume the easiest thing would be some kind of report on the front end, but if that kind of data is available in the tables we'd certainly be prepared to write SQL requests to pull it too.

[MikeBrinkman]

If you're using Canvas Data 2, you should just be able to create relationships between courses, assignments and quizzes. Courses key.id -> Assignments value.context_id, Assignments key.id -> Quizzes value.assignment_id. Any course that does not have classic quizzes would be excluded if you made a query that relies on these relationships.

[stimme]

@bweaver4 , I agree with @MikeBrinkman that Canvas Data 2 is a good place to get a complete list of classic quizzes. If you want to be sure to find ungraded surveys & practice quizzes, I'd recommend leaving the assignments table out of the join. A simple count of classic quizzes of all types per course could come from a query such as

SELECT c.id
, c.course_code
, c.name
, COUNT(q.id) AS classic_quiz_count
FROM canvas.courses c
JOIN canvas.quizzes q ON q.context_id = c.id
WHERE q.context_type = 'Course'
/* It should be safe to exclude deleted quizzes and courses */
AND q.workflow_state != 'deleted' 
AND c.workflow_state != 'deleted'
GROUP BY c.id
, c.course_code
, c.name
;

If you wanted to exclude classic quizzes that no student has seen AND have a front-end approach, I think you could use Admin Analytics. If you go to the Overview, confirm that filters include terms you want, click on the classic quizzes bar in the Interactions chart, you will be able to download a full list of courses where students have interacted with or viewed quizzes.

How do I view the Admin Analytics Overview Dashboard? 

[JimEgan]

Given the relationship that @MikeBrinkman provided in the post above yours, it seems that classic quizzes are not associated with an assignment.  Therefore wouldn't you have to include the expression "assignment_id is null" in your where clause to get just the classic quizzes?

Alternatively, if you add count(q.assignment_id) that would have implicitly counted just the new quizzes and you could subtract that from your total quiz count to get the number of classic quizzes.

I'm still coming up to speed on the difference between classic and new quizzes.  In another post I read that new quizzes aren't available in CD2 yet.  I'm not sure if that is the current status or not.

[KeithSmith_au]

Sorry, you have that backward.  What  @MikeBrinkman said was that not all classic quizzes are associated to assignments, not that none of them are.  Surveys and unmarked practice quizzes are not associated with assignments, but are still associated with courses.  Marked classic quizzes are most definitely associated with assignments.