Phase Percentages Integration #633
Description
Currently, I have created a Google Sheets on the TA account that will track averages of past semesters and can track the percentages of each phase for the current semester.
The problem with this as Dr. Jensen would agree, is that it has a lot of toil. You must download the gradebook, put it into the google sheets tab, and replace all empty (or null) spaces with 0.
This isn't the worst in cases of toil, but if you need to update it every week, that toil adds up and could be automated, and potentially even stored directly on the autograder for reference instead of on a google slides.
I don't fully know what this will entail, but it probably would need a canvas API key to access the gradebook, download it as a csv, and potentially use some code to calculate the percentages and keep track of the amount of students at the beginning of class (after the add/drop deadline) to keep track of the amount of students that have dropped.
Reach out to me if you have questions on how the google sheets currently works. To make it more automated and have less toil (beyond just adding the gradebook), I had to use some fancy excel commands that I can explain if needed.