I am attempting to export a gradesheet for a class to Excel and retain the percentages showing in Canvas. The percentages originally showed as points in Canvas; I selected to view them as percentages. Can I keep the percentages on export? Thanks.
Hi @mabaryj
Not sure exactly why you didn't just download and test this yourself, but if you have your Canvas Gradebook set to display totals as percentages, those percentages will also display in the export file.
Just tested this in a live classroom, and it worked as expected.
Kelley
This thread has had a long life. Most posts do not explicitly say why the percentage display in the CSV export would be useful (or how it would be used). One stated goal is to calculate totals to double check Canvas's total. I am writing share observations that may be helpful to anyone thinking about calculating totals to double check Canvas's total.
Giving different possible point values to assignments in the same group gives them different relative weight. Canvas totals scored assignments (unscored assignments are left out) by adding up the points earned across assignments as the numerator and adding up the points possible across assignments as the denominator, which may not yield the same result as first converting them to percentages does.
Suppose that a student earns 0/1 (0%) for Homework #1 and 4/5 (80%) for Homework #2. When these are the only scored assignments in an assignment group for Homework, Canvas calculates its percentage subtotal as 66.67% (4 points earned (0+4) / 6 points possible (1+5), rounded). Treating the Homework subtotal as the average of the percentages would yield 40%, which would also treat the two assignments as having equal weight despite having different possible points. Working only with the percentages of specific assignments can produce different results than Canvas's calculations, and this is because working only with percentages disregards the relative weighting made possible by different possible point values.
If you think of each assignment's score as a percentage so that each assignment in a group has the same weight as all the others, then you should set points possible at 100 for every assignment (this takes extra care with classic quizzes, since all questions points possible must add up to 100). This is best implemented when a course begins. I admit it isn't much help after the grading is done. (Enabling weighted assignment groups helps to handle the relative weighting of different types of assignments. )
Getting percentages for assignment columns in the CSV export is not an option. One might regard this as a useful limitation when one's goal is to double check Canvas's total, because Canvas calculates totals using points in the way described above (regardless of assignments' Display Grade As setting).
(I am a Community Coach, not an Instructure employee.)
Download the gradebook and open in excel. I have quizzes set for different numbers of points too.
The only way I have found to get percentages for quizzes is to insert a blank column next to a quiz, then use a formula to calculate a percentage for the first student,then copy this cell and paste into the rest of the column. When I copy this new column into excel the values appear as numbers.
Example: student scores 15/23 for a quiz. The number 15 appears in cell D3. In the blank cell E3 input =D3*100/23 then return. 65.2 appears in E3. Copy E3, then click on F3, holding the shift to highlight the rest of the column, then return. I bold this column to make it stick out.
It may seem like a pain but it goes pretty fast.
The solution offered does not work. May 8, 2023. The rest of the discussion thread on this post does not help either. Thank you.
So EXCITED to reply to this!! I was having the SAME problem. Then I noticed if the original assignment settings have "Display Grade as a Percentage" chosen then the Excel file shows the percentage grade and not the points! Hope this makes sense. 🙂
I have not be able to export individual graded items as percentages instead of raw scores. They will display as percentages, but not export as that. Instead, any export is in raw scores for individual grades. I have tried editing the assignment settings to "Display Grade as a Percentage" but still get raw scores for individual assignments. Has anyone be able to export individual assignments as percentages successfully?
We are working on a project to import grades from Canvas into Banner. During the testing phase we discovered a few students who show the correct grade in the gradebook but when we pull Canvas Data the grade is different. When we go to the gradebook and export grades we get the same incorrect grade as Canvas Data. When we…
Hello, I am using a course outcome as a rubric for a written assignment. I would like to be able to add a description under scoring criteria that helps define what the assignment should include in order to "Exceed Expectations" for example. Rubrics are used by students to help guide their responses and they should have an…
Hi everyone… Has anyone else run into issues with SAML authentication not working, but only on their beta instance? Our production and test sites are fine, but we manage a number of different Canvas instances and every one of them that uses SAML authentication (with either Okta or Microsoft Entra) has not worked for a…
ETA: never mind! I had done my "testing" in the wrong quiz, which was a Classic Quiz quiz. I just tried again in the correct (migrated) new quiz, and I see now that the "file upload" question type DOES show the image in SG! — I rarely use Canvas quizzes, but am teaching a new asynch class this semester. I want students to…
In the "How do I use the Learning Mastery Gradebook" page, under "Student scores" (https://community.instructure.com/en/kb/articles/660932-how-do-i-use-the-learning-mastery-gradebook-to-view-outcome-results-in-a-course#view-student-scores), the displayed gradebook shows a little colorful square and also points for each…
