Canvas Data 2 Gradebook activity

[WillGHampton]

Greetings,

I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not have assignments with gradebook entries or assignments are past their due date with no grade.

Checking the Canvas Data 2 schema, there does not seem to be a table for the gradebook directly. What tables, other than assignment_submissions, quiz_submissions and discussion_entries  could be useful to query to check for gradebook activity?

Thanks

Will Hampton

[Jeff_F]

Hello @WillGHampton - 

I see a few ways to identify courses where the Canvas Gradebook is not being used. The first that comes to mind is to list all assignments and include the assignment group they belong to. Look to see if the assignment group or assignment is set to 0 and what the submission type is.  Look for those submission types that do not call for something to be uploaded to or done in Canvas (i.e., not graded, none). Also look for courses that do not have any graded assignments.

Another method could be to use the Submissions table.  Explore the values to include/ exclude.  For example, a few days after after the due date you could exclude deleted and graded, etc. leaving only unsubmitted and perhaps 'null' as well.  

-----------

============

[WillGHampton]

This is a good solution when using submissions tables. I used a similar approach when looking for ungraded assignments by checking submissions for being graded in a timely manner. 

I have found that there is a gradebook table in the CD2 Schema, called Scores. I noted that there appears to be only one Scores table entry per course and student. I've got a dashboard that verifies if the updated date of the scores table is within a week or so. Can you think of drawbacks to this simplier approach?

[Jeff_F]

Yes, if we are reviewing the data after the course has completed, then a null course and other scores is an indicator that Canvas assignments are not being used.

And if we wanted to see this during a term, I'd be tempted to also use assignment_groups and the assignment tables as then we can see how many assignment groups exist, the group weight, and if assignments are available to the students. Then of course the submissions table can give us more details.