Pulling Specific Data out of Analytics (Unused Gradebooks)

[cwarren5]

I am looking to see if anyone here has found a way to pull a report out of Canvas Analytics that would give me just a list of courses in [TERM] that aren't using or updating their gradebooks? 

[chriscas]

Hi @cwarren5,

I don't know of a simple single solution to this, and the question may actually be more complex than you realize at first...  You'd probably need to define exactly what you mean by aren't using or updating the gradebook...  Does that mean the grades area has to be visible to students?  Does it mean all assignments have to be listed in the gradebook?  Does it mean any weighing or other calculations need to be 100% accurate in Canvas?  How often does a gradebook need to be counted (once a week, once a month, etc)...  What you would need to do to find this data would depend on the answers to these (and possibly other) questions.  In some cases, it may not even be possible to assess things until final grades are due (for example, to check accuracy of the grades in Canvas, as there is no way to know whether things are correct without having something else to compare against).

If you can let us know some of the answers to things above, someone may be able to suggest some approaches you could take to get the data.

-Chris

[cwarren5]

Hello Chriscas, 

Yes, basically this was my thought too, but working with Admin can often be difficult as they do not understand the nuances of software. What may seem like an easy question to them "I.E. I want to know which instructors here are not putting their grades into their Canvas shells" is actually a very, very complex question. And this is what they want, they want to be able to get a list from our Canvas data so that they know who in the departments they need to go and pester to update their gradebook with grades. 

-C

[DavidSchlater]

One idea with Admin Analytics would be to filter for the given term and then go to the Courses tab. Click on the Grades bar graph to see and download a full list of all the courses that have at least one grade for one student. Next, go over to the far left to the bar that is the highest - probably Files. Download this sheet as well and using Excel remove all the courses in your Files download that are also in Grades. This should leave you with active courses using Files but not grades....not automatic, but it should work.