[ARCHIVED] Active Courses report?

[abunag]

Hi All,

Anyone running reporting on which courses are being used?  Currently we send all courses from SIS to Banner, so we end up with a lot of unused classes.  However, we're trying to get more information than just if a course is published or not.  In a perfect world, my institution would like a report that identifies courses that are published, and have either a syllabus or uploaded files.  I can get the published courses by getting a full list of courses and removing the ones that show on the unpublished report, and Instructure has a report for Syllabus available for purchase, but I'm stuck on trying to check if there's any files uploaded in a course.

Anyone tried anything like this?  Any existing reports that I'm missing?

Thanks for any help.

[kbickell]

You an run a Course Storage report that will show the "sum of all files" but unfortunately it doesn't show any more detail than that. Would love a more detailed report for reason you noted above.

[dgrobani]

If anyone at your institution has experience writing programs that interact with the Canvas API, the published status of a course is available via the workflow_state attribute of the Course object, info on files uploaded to a course is available from the List files endpoint, and syllabus info is available from the Get a single course endpoint using the include[]=syllabus_body request parameter.

[shane_ohara]

I just wrapped up a project for our Associate Director that looked at tools usage for active courses in the past year. I used Canvas Data to query for assignment and quiz submissions between specified dates. If I am not mistaken, you could use CD (specifically file_dim and file_fact) to hone in on file uploads. This is where I would start.

Shane

[maguire]

I made a simple program to get information about all of the courses and accounts at my institution as a spreadsheet. You can find details and access to the code at Courses and accounts: Chip sandbox