Importing letter grades into gradebook

I hope someone could help me with suggestion on how to import letter grades from A to F into the grade book. I do not want the grade book to assign letter grades. Instead, I would like it to display the letter grades in a column/assignment that I entered in Excel. When I upload the *.cvs file, new columns/assignments with numbers get displayed, but not column/assignment with the letter grades. I tried to edit the Assignment/column and used different Assignment options such as Percentage, Complete/Incomplete, Points, Letter Scale, with to no avail, I get dashes displayed. I like to give grades for groups of assignments during the course and with larger classes it gets very tedious to enter grades by hand. Thanks so much!

Find more posts tagged with

Canvas

Accepted answers

All comments

SusanNiemeyer

The bottom line is this: grading in Canvas is based on numbers. You need to assign points for grades. That allows Canvas to calculate grades based on percentages.

Therefore, you need to set up a point system to correspond to your letter grades. For example:

10 points = A+

9 points = A

8 points = B

7 points = C

6 points = D

0-5 points = F

Also, why are you putting grades into an Excel file and then transferring them over? It's really easy to enter grades into Canvas directly. You're creating a lot of extra work for yourself.

ArunasJuska

Thanks so much for a reply, I appreciate it very much. I am aware of how to set grading scale in Canvas, but this is not what I am asking about. My question is could I import into grade book an assignment/column that has text in each of its cells say Good, Excellent, Bad, etc.? Again, many thanks for suggestions.

P.S. I do grades in Excel so I could differentiate assignments missed from assignments on which students got 0s, which have different weights assigned after missing 3, 5 or more assignments.

PeterDesnoyers

If you don't understand why someone would upload from a spreadsheet, please try calculating "drop lowest two homework grades" in Canvas, or "higher grade on the final exam will replace midterm grade". Never mind the endless and error-prone clicking and typing necessary to enter grades into Canvas...

It looks like the only way to do it is to convert your letter grades into fake numeric grades - e.g. a spreadsheet column like this:

=IFS(A1="A",95,A1="A-",91,A1="B+",89,A1="B",85,A1="B-",81,A1="C+",79,A1="C",75,A1="C-",71,A1="D+",69,A1="D",65,A1="D-",61,TRUE,50)

Unanswered Questions

Change Order of Account Menu Items
I'm an Admin in Canvas, and I'd like to know if it's possible to change the order of items in the Account menu. Now, we have: -ePortfolio (Legacy) -Shared Items -Portfolio We'd like to have Portfolio above ePortfolio (Legacy), to encourage people to use that, but I can't find a way to do it.
Monitoring API Activity (in test)
We are testing a third party integration from our college's ERP provider. We have connected it to our test environment. It seems to have very few features and options. So, just wondering if there is a way to monitor API calls. I was able to use the DAPClient in Python to download canvas_logs in our production environment.…
Rubric no longer collapses
Previously on the built-in rubrics, vertical view, the rubric items were collapsed. You could expand them to see details of each point value. Now they are expanded by default and I see no way to collapse them. When a teacher is grading 20 of the same assignment, he or she knows what each point value entails. By having them…
Feature Request: Export a list of students who have (or have not) submitted an assignment/quiz
As "Ideas" section is gone (at least for now), I'm posting a feature request here. Mobile app shows a list of students who have submitted or not submitted a quiz/assignment. Would be good to have this in web version as well as way to export csv.
About ne upcoming Portfolio feature
Could you please clarify about the URL structure for the new Canvas Portfolio feature after the retirement of the ePortfolios on June 30, 2026?