Review grade averages by marker in a large subject

[John_Gaspar]

Hello. I'm looking for a solution or advice for the following scenario:

The Canvas course has 1900 students. They are in 46 tutorial sections, and there are 18 tutors, with each taking 2 to 4 tutorials.

I want to be able to review how tutors are marking on a regular basis to spot outliers or other problems. None of my usual processes scale up to such large numbers without creating a lot of extra work.

Gradebook preset filters only allow me to save one section per filter so I'd have to set these up every time I wanted to review grades.

Gradebook export has the same problem as using filters; the set-up time each time.

Gradebook history allows me to filter by tutor and assessment but the table can't be exported and there are too many students to easily scan.

New Analytics course grade would be great as it includes averages per assignment but I can only compare 2 sections at a time (why?). Downloading teh csv didn't help as tutorial information is missing.

Has anyone a clever way to get this information quickly and easily?

[Gabriel33]

So each tutor is a single section? Sections are columns in the gradebook csv export.

Unless I'm missing something, you could make a pivot table in Excel (or your preferred spreadsheet editor) to aggregate the students by section and calculate the average grade for each assignment.

[John_Gaspar]

@Gabriel33 each tutor has between 2 and 4 tutorials / sections so it's not an easy one to one relationship. When I download gradebook Sections is one column so grouping students is easy, but managing by tutor is less so. I could create a summary tab with formulae pointing to another tab where the gradebook data could be copied each time but I was hoping for a more elegant solution.

[Gabriel33]

I see, you could mix the pivot table with an XLOOKUP to match the section with the grader, but if you have to do it very often, that can be tiring.

Have you worked with the Canvas API before? That allows you to get the full gradebook history (I think you'd want the grade change log, which can be queried by grader, instead of the gradebook history endpoint). More work to set up, but then can be called more easily (and elegantly) each time.