[ARCHIVED] Downloading rubric scores

[lmayers]

I am writing a report for accreditation purposes. yeah.  The KPI requires documentation from Canvas rubrics.  (80% of students will receive a "satisfactory" on assignment x in course y.)    Is it possible to download in a spreadsheet all of the students' rubric scores from a particular assignment?  

[James · Accepted solution]

 @lmayers  

I think you're talking about something like this (initial post and follow-up are the two criteria in my rubric).

If so, this functionality does not exist within that core Canvas product.

It is possible to download the rubrics through the API and create a spreadsheet. I wrote a script to do this before the Fall 2019 term, but never finished it to a point it was ready for publication. It's functional for what you're asking about, just not where I wanted it to be before I released it.

[mweilan]

Is this script ready by chance?  It would save me a TON of time.  Thank you

[BradMoser]

@James did you ever complete your rubric downloader? 

[James]

@BradMoser 

Strangely, I was blowing it up and putting it back together over last week. Maybe it wasn't strange since I had seen several requests about it here in the Community and I thought that I should go ahead and release what I have (something is better than nothing -- although I've seen other people release some code as well). The original one that I wrote in August 2019 is functional. The one that is blown up is not. I've eliminated all of the complaints that my code checker throws at me, so now it says there are no problems -- other than the fact it doesn't return any useful information. Part of the problem with not finishing things is that by the time you come back to it, you forgot what you did.

While I was working on that, I noticed some other API calls that were not originally available that may be useful, perhaps even getting student peer rubrics (I haven't explored enough to make sure).

One thing I wanted to do (that never made it into the original) was download the rubric so that it would work with the rubric importer. But I think I'm going to have to break the rubric importer (or at least release a new version while keeping the old one out there) to make that happen.

[BradMoser]

Well, this is exciting to hear that you haven't decommissioned it or just stopped developing it altogether. I support you in this effort. I think there is some great value that doesn't currently exist in Canvas that would make it so teachers could better use data collected from rubrics. Thanks for sharing and making the effort. 

[rhil]

I would love to see your code when that is possible.

[kendall_hunter]

@James not sure if you are willing to share your progress on this rubric script, but if you are I would love to try to complete it. I have started using Rubrics extensively and I teach programming to engineers. I don't know userscript but I do know MATLAB, C, and python (among others) and given what I need to do now with Rubrics and how I envision using them in the future, I'd prefer to write the code and generate a lasting solution.

If not no worries... I am reviewing some of your existing scripts seeing if there is a good jumping off point to start my own development...

[James]

@kendall_hunter 

It's mainly functional and would meet the needs of most people the way it is. The thing keeping me from publishing it was tied to my Rubric Importer script. I wanted to create a sheet that would export the rubric in a way that you could then make changes and import it back. The issue was that my importer script was written before there were long descriptions (as opposed to just titles) and I need to modify it to include those. When I last looked at it, that was going to be a breaking functionality with the existing importer as I needed to reorder the columns and put the numbers first rather than last.

The one I have creates an Excel file rather than a CSV file. That way it can have multiple types of items in it. There's a raw sheet with just the data, a summary page (like a pivot table), it can add calculations but you have to open it in Excel to actually find the numbers. The exporting of the rubric itself was the last of the major things I wanted to do.

[kendall_hunter]

@James OK. Well, for now, I read up on the API, used it to download json file of a whole assignment at a time (including rubric info), and am using the python json library to interpret/convert the file into CSV. ROTFL!!! Haven't made it clean yet (everything is IDs rather than human readable stuff) but it works for me... Should save countless hours of having to enter the stuff by hand UGH!

Thanks for all your development here. I have come to rely on the sort-rubric userscript.

[lacatin]

Where (how) do you get to the API to get to the rubric data? I don't mind figuring out the scripts to download it, but I don't know how to access it in order to do the download. 

[Ron_Bowman]

@lacatin -

Here is the information I have.  First, here are two links that contain information regarding api's that you may find helpful.  

How do I manage API access tokens as an admin   - I believe this talks about how to generate tokens

This is the API directory - shows all of the api calls, names information, etc

To help you more, here is the link to UC-boulders canvas userscript page that lists a few canvancements.  One of those is export rubrics - it only does scores and not the comments.

If you decide to work with this information and create your own that also obtains the comments that would be great.

I hope this information helps

[smitra]

Worked for me. Thank you so much!

Simanta

[joel_taylor]

@James, would I be able to get a copy of the script as it is now? You mentioned that you were trying to improve it to work better with the import script, but I only have a use for the exporter script anyway.

[James]

@joel_taylor 

I sent you a link. I think some other people have come along and provided more complete solutions since I started writing mine, but it will give you a place to start.

[TiffanyJackson1]

I found a YouTube video for those of us who are not administrators:

https://youtu.be/NFKJAS8oZRo?si=DZggLbXYLg70CBw1

[TiffanyJackson1]

Have you checked out the Insights eLumen product?  It is supposed to be able to do this in conjunction with Outcomes.

[Lauren_A]

I still have instructors asking for this functionality. Would be great if we could look into this!