Exporting gradebook

I thought it would be interesting to export the Gradebook using the Canvas REST API.

I did a test with the following very simple gradebook:

One runs the program export_gradebook.py Download export_gradebook.py

 giving it the number of the course (in this case 11). This produces a spreadsheet (gradebook-11.xlsx Download gradebook-11.xlsx

) with a number of sheets, including Gradebook:

While it does not have the nice header of the Gradebook with the number of possible points and it does not include the all of the scores (such as the 90 points out of 100 for PROJ1). It basically shows that one can get the data. Note that one has to look for the entries from the Gradebook History where the two datetime stamps('current_graded_at' and 'graded_at') for a given assignment are equal. I believe that these additional values could be added as a companion column with the same name as the assignment, but with "_score" added to it.

 A version of the program (export-gradebook-with-score.py Download export-gradebook-with-score.py

) that adds a _score set of columns and adds a row with a user id of -2 and the maximum scores for each of the columns which have a potential score of more than 0. This produces a new spreadsheet (gradebook-11-1.xlsx Download gradebook-11-1.xlsx

).