[ARCHIVED] How do I get gradebook activity from Canvas Data?

[mbeccaria]

I want to show how many grades were entered into the gradebook by course - but the tables provided in Canvas Data don't make it obvious how to do this.

Any ideas?

Thanks,

Mike

[stimme]

Hi Mike,

If you're looking at a high level just to see total grades in courses, you could focus on the course_score_fact table. If you're looking for detail at the level of each student's grade on each assignment in courses, focus on the submission_fact table. If you're trying to revise database queries, feel free to share what you've got so far.