[ARCHIVED] Download rubric comments in speed grader

[kevinn]

I use the rubric feature to mark my assignments in speed grader, is there any way the the comments against each criterion along with the rubric can be downloaded in the feedback comments? 

[Steve_Watts · Accepted solution]

Hi  @kevinn 

I don't believe this is possible from within Canvas itself, but if you have a bit of programming skill you could write some code using the Canvas API that pulls out all the submissions for a specific assignment then for each submission in the data that's returned you could see information including rubric comments, and display this in a table, spreadsheet etc.

Take a look at this recent post where another community member was asking about exporting assignment submissions and feedback. The aim here wasn't exactly the same as what you want - he was after text comments added in the SpeedGrader rather than rubric comments - but the method I described in my answer is similar to what would be used to get the rubric comments. The link I gave to the API documentation will also be relevant if you decide to try this for yourself.Export assignment comments for course‌

It might look a little complicated so if programming isn't your speciality you could ask your local Canvas administrator or another technical support colleague for assistance.

[amberckerr · Accepted solution]

I cannot believe that this STILL isn't a feature on Canvas! It's unbelievably awkward.  I make extensive use of rubrics for grading everything from simple homeworks to long essays. It's really frustrating not to be able to download the comments, and I imagine it's very frustrating for the students too. Right now I'm documenting a plagiarism case, and the inability to download and save my comments on a student's paper is just... ridiculous. I have to take screenshots of the content within the webpage. What the heck, guys?!

[Steve_Watts · Accepted solution]

Hi  @kevinn 

I don't believe this is possible from within Canvas itself, but if you have a bit of programming skill you could write some code using the Canvas API that pulls out all the submissions for a specific assignment then for each submission in the data that's returned you could see information including rubric comments, and display this in a table, spreadsheet etc.

Take a look at this recent post where another community member was asking about exporting assignment submissions and feedback. The aim here wasn't exactly the same as what you want - he was after text comments added in the SpeedGrader rather than rubric comments - but the method I described in my answer is similar to what would be used to get the rubric comments. The link I gave to the API documentation will also be relevant if you decide to try this for yourself.Export assignment comments for course‌

It might look a little complicated so if programming isn't your speciality you could ask your local Canvas administrator or another technical support colleague for assistance.

[jwadec]

@Steve_Watts Do you still have this code somewhere. The page you linked to is no longer available. I think it was referencing the old community when it was on JIVE.

[Steve_Watts]

Hi @jwadec 
I'm not sure if this is the same post I was linking to but it looks relevant: https://community.canvaslms.com/t5/Question-Forum/Export-assignment-comments-for-course/m-p/176454

[scombs426]

This is so incredibly frustrating when you're following a thread and there's a link that no longer works because documents were moved.  There should be something to fix these broken links.  This happens to me at least once or twice a week now. 

Your link leads to a 'page not found'

I know this was posted in 2018 but I think still relevant? there's no way to download rubric comments?

[Chris_Hofer]

@scombs426 ...

The link that @Steve_Watts included right above your reply is the current (corrected) link that you'll need to use.

Solved: Export assignment comments for course - Instructure Community (canvaslms.com)

Back in the Summer of 2020, the Canvas Community website changed platforms.  Unfortunately, not all of the links re-directed to the current site that we are all using now.  So, that's why sometimes you'll find links that go to "page not found" or similar types of errors.  The good news is that if you know the page name (most of the time you can get an idea of what the page name is by looking at the old URL), you can input that page name directly into any of the search boxes at the top of pages here in the Community.  Many times, you'll be able to find the new location of the page you were looking for...which is how I assume Steve got the corrected link (that's how I did, anyway).

Hope this helps a bit!

[amberckerr · Accepted solution]

I cannot believe that this STILL isn't a feature on Canvas! It's unbelievably awkward.  I make extensive use of rubrics for grading everything from simple homeworks to long essays. It's really frustrating not to be able to download the comments, and I imagine it's very frustrating for the students too. Right now I'm documenting a plagiarism case, and the inability to download and save my comments on a student's paper is just... ridiculous. I have to take screenshots of the content within the webpage. What the heck, guys?!

[lenz · Accepted solution]

@amberckerr   You wrote this comment such a long time ago that you've probably figured out how to manage the problem, but I'm sending this along just in case.

ACQUIRING YOUR COMMENTS WRITTEN IN THE DOC VIEWER (ie ON YOUR STUDENT'S PAPER)

If you want the comments you wrote on your student's text, you can click on the Download as annotated PDF button, which is in the upper left hand corner.  You can open the PDF in WORD.  HOWEVER, (you knew that was coming) because it's CANVAS 🙄, when you open it in word it'll look like the comments aren't there.  (I'm exhausted just writing about this...)  They really ARE there though.  You have to RANDOMLY click around where you think you put them, they'll pop up!  The trick is to click in the right spot.  There's usually some kind of mark that'll give you a clue. 

If you think about how much your school/school district/university paid for this "LMS," and how much it sucks in some fairly critical ways, it'll make you crazy, so DON'T GO THERE.  If you haven't already figured something out,  hope this tip, helps.

(YES, CANVAS employees, I DID watch the Doc Viewer video.  It did not mention AT ALL the invisibility of the comments.  Perhaps those having Adobe see the comments easily.  That would be lovely to behold and lovely to mention on the video as well.)

ACQUIRING YOUR COMMENTS WRITTEN ON THE SPEEDGRADER RUBRIC

This may not be something your looking for, but because Speedgrader routinely eats the comments I have spent hour writing on my students' 10-page papers, I was desperate for a way to print these/save them to a file/SOMETHING.  Screenshots work, but you can't do anything with the text.  However, I have discovered a way to get the actually text WITH the criteria AND the points.  It's s simple but stupid process and yields you a stupid but usable product.

1. Open a new WORD doc.
2. Back in Speedgrader, expand the rubric part of the screen (ie make it really wide).
3. CTRL A  (Select all.)
4. CTRL C  (Copy.)
5. Go back to the blank WORD doc and DON'T DO WHAT YOU THINK YOU SHOULD DO

   

Instead, click on Paste > Paste Options Keep Text Only (T) (The button with the clipboard + A).

What you will get is straight text 🤦🏼‍♀️(yep, stupid), BUT if you look carefully, you’ll see

• the criteria,
• your comments, AND
• the points you gave for each item! 

It’s a symptom of CANVAS Learned Helplessness that I am so excited about this, but there it is.  You CAN (primitively) sort of 

save your work before Speedgrader decides you’re too close to finishing and trashes it.

NOTE:  You get the same what-we-used-to-call-ASCII version of your work if you click

Paste > Paste Special > Unformatted Text

                Or

Paste > Paste Special > Unformatted Unicode Text

Don’t click HTML Formatted Text.  You get only criteria and points – no comments.

I hope this helps a brother or sister educator out there.  If you have a better way (there MUST BE a better way), please share.  This problem of not being able to save, print, protect our work is kind of soul-crushing, and CANVAS/INSTRUCTURE seems unwilling/unable to master (or even understand) it.

Cheers!  🙋🏼‍♀️

,

[kete]

I really NEED to be able to download my criteria, comments and score that I give the students because we are working as a partner with another University and so I have to pass on all the assignments, exams and feedback for all the students that belong within this partnership for quality checks.  My current solution is just to take a screenshot but this is very antiquated way of doing things!  I hope Canvas comes up with a solution very soon!

[mkbascom]

The proposed work around isn't really a "solution"  Still unable to print or download rubric from Speedgrader. 

[ClarissiaTijeri]

CAN SOMEONE AT CANVAS, PLEASE MAKE IT POSSIBLE TO PRINT ASSIGNMENTS AND RUBRICS TOGETHER? I WANT THE ABILITY TO PRINT AND ADD THEM TO THEIR PORTFOLIOS, WITHOUT REWRITING THE RUBRICS SCORES ON A SEPARATE RUBRIC...FRUSTRATED TEACHER. 

[Chris_Hofer]

@ClarissiaTijeri ...

You might want to consider submitting a Feature Idea for this...so that others here in the Community website get a chance to evaluate your idea to see if it something they would also be interested in having as a part of the core Canvas product.  The Idea Conversations page is located here:

Idea Conversations - Instructure Community

And, you can learn more about how to create Feature Ideas by visiting the following Guides:

• How do idea conversations work in the Instructure Community?
• What is the feature development process for Instructure products?
• How do I create a new idea conversation in the Instructure Community?

Please let Community members know if you have any other questions about this process...thanks!

[nico_rasters]

If you don't want to mess around with the API and a script to parse the result you can also get the json data and feed it to PowerQuery (part of Excel).

Get the link to the assignment, then change "assignments/" into "gradebook/speed_grader.json?assignment_id=".

This will give you the raw json data.

E.g. https://canvas.maastrichtuniversity.nl/courses/7730/assignments/39675 becomes https://canvas.maastrichtuniversity.nl/courses/7730/gradebook/speed_grader.json?assignment_id=39675

Save this file as a json file. Open it with PowerQuery (or Power BI Desktop, it's free). Btw, you can use https://jsoneditoronline.org/# to view your json data.

The following script should do the trick:

let
Source = Json.Document(File.Contents("Whichever_folder_you_stored_the_file/speed_grader.json")),
#"Converted to Table" = Table.FromRecords({Source}),
#"Expanded turnitin_settings" = Table.ExpandRecordColumn(#"Converted to Table", "turnitin_settings", {"originality_report_visibility", "s_paper_check", "internet_check", "journal_check", "exclude_biblio", "exclude_quoted", "exclude_type", "exclude_value", "submit_papers_to"}, {"turnitin_settings.originality_report_visibility", "turnitin_settings.s_paper_check", "turnitin_settings.internet_check", "turnitin_settings.journal_check", "turnitin_settings.exclude_biblio", "turnitin_settings.exclude_quoted", "turnitin_settings.exclude_type", "turnitin_settings.exclude_value", "turnitin_settings.submit_papers_to"}),
#"Expanded integration_data" = Table.ExpandRecordColumn(#"Expanded turnitin_settings", "integration_data", {}, {}),
#"Expanded context" = Table.ExpandRecordColumn(#"Expanded integration_data", "context", {"id", "concluded", "rep_for_student", "students", "active_course_sections", "enrollments", "quiz"}, {"context.id", "context.concluded", "context.rep_for_student", "context.students", "context.active_course_sections", "context.enrollments", "context.quiz"}),
#"Expanded context.rep_for_student" = Table.ExpandRecordColumn(#"Expanded context", "context.rep_for_student", {}, {}),
#"Expanded rubric_association" = Table.ExpandRecordColumn(#"Expanded context.rep_for_student", "rubric_association", {"id", "rubric_id", "association_id", "association_type", "use_for_grading", "created_at", "updated_at", "title", "summary_data", "purpose", "url", "context_id", "context_type", "hide_score_total", "bookmarked", "context_code", "hide_points", "hide_outcome_results", "root_account_id", "workflow_state"}, {"rubric_association.id", "rubric_association.rubric_id", "rubric_association.association_id", "rubric_association.association_type", "rubric_association.use_for_grading", "rubric_association.created_at", "rubric_association.updated_at", "rubric_association.title", "rubric_association.summary_data", "rubric_association.purpose", "rubric_association.url", "rubric_association.context_id", "rubric_association.context_type", "rubric_association.hide_score_total", "rubric_association.bookmarked", "rubric_association.context_code", "rubric_association.hide_points", "rubric_association.hide_outcome_results", "rubric_association.root_account_id", "rubric_association.workflow_state"}),
#"Expanded context.students" = Table.ExpandListColumn(#"Expanded rubric_association", "context.students"),
#"Removed Other Columns" = Table.SelectColumns(#"Expanded context.students",{"context.students"}),
#"Expanded context.students1" = Table.ExpandRecordColumn(#"Removed Other Columns", "context.students", {"id", "name", "rubric_assessments"}, {"id", "name", "rubric_assessments"}),
#"Expanded rubric_assessments" = Table.ExpandListColumn(#"Expanded context.students1", "rubric_assessments"),
#"Expanded rubric_assessments1" = Table.ExpandRecordColumn(#"Expanded rubric_assessments", "rubric_assessments", {"data"}, {"data"}),
#"Expanded data" = Table.ExpandListColumn(#"Expanded rubric_assessments1", "data"),
#"Grouped Rows" = Table.Group(#"Expanded data", {"id"}, {{"Count", each _, type table [id=text, name=text, data=nullable record]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1)),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"id", "name", "data", "Index"}, {"id.1", "name", "data", "Index"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Expanded Custom",{"id.1", "name", "data", "Index"}),
#"Expanded data1" = Table.ExpandRecordColumn(#"Removed Other Columns1", "data", {"id", "points", "criterion_id", "learning_outcome_id", "description", "comments_enabled", "comments"}, {"data.id", "data.points", "data.criterion_id", "data.learning_outcome_id", "data.description", "data.comments_enabled", "data.comments"})
in
#"Expanded data1"

Any questions? Feel free to drop me an email at nico.rasters@maastrichtuniversity.nl

[lbilich]

I find it ridiculous this is not possible to download a rubric in Canvas. I am not a programmer 

Lisa

[Code-with-Ski]

For anyone that is interested, I built a couple features in my free Canvas LMS Mods (Basic) Chrome extension that help get rubric criteria score and comment data.  While it isn't directly in SpeedGrader, there are features to get the data for a single assignment or for all submissions.

• For single assignments: Export Assignment Submission Scores with Rubric Criteria Scores and Comments 
• For all submissions, use the Submission Details Report: Custom Course Reports 

[petern]

This extension is great!  Thank you

[Code-with-Ski]

You're welcome! I'm glad to hear you already enjoy it 😀