Report for Published Courses with at Least One Assignment

[jordanaclark]

I am a Canvas Admin trying to create a report of all published courses with at least one assignment for a given term. I've used the provisioning report to get all published courses, but I'm not seeing a way to check for at least one assignment. 

Any help is greatly appreciated!!

Jordan

[mzimmerman · Accepted solution]

Hi @jordanaclark 

There isn't really a report for just assignments, but you might look at the "Unused courses" report, which is "a report of all courses that have none of the following items: assignments, announcements, discussions, files, modules, pages, or quizzes."   It also shows whether the course is published.

To drill down and look specifically for assignments, you will need to do something like use the Assignments API to query for each course and see if there are any assignments listed for it https://canvas.instructure.com/doc/api/assignments.html#method.assignments_api.index 

[jordanaclark]

Much appreciated!