Display only letter grades in gradebook
In Canvas, the option to display letter grade displays a letter grade in addition to the points score.
Step 5 is a workaround to obfuscate the actual points scored.
To display letter grades in Canvas, you may do the following:
Create a new assignment in your course by clicking +Assignment.
Enter the total amount of points the assignment is worth. In this case, you can use a point system, upon 10.
For Display Grade as, choose Letter Grade from the dropdown menu.
Click View Grading Scheme. You can use the NUS default grading scheme or create a new grading scheme to reflect your scheme.
- When entering the marks for the assignment, you should enter a representative score upon 10, instead of the actual marks. You can derive the representative scores for your assignment using the instructions below.
Deriving a representative score
For the representative score, a particular point will match to a particular letter grade.
You can use this spreadsheet to calculate the representative score. The example worksheet shows an example based on an assignment worth 30 marks.
All who get A+ will have 10 points i.e. A+ (10) represents any score between 85% to 100% of the actual marks.
Using the example, any score between 26 and 30 marks will be represented with A+ (10), any score of 24 or 25 will be represented with A (8.5) and so on.
- Column A: Matriculation number. Enter the matriculation numbers. (You can export a list with matriculation numbers.)
- Column B: Actual marks. Enter the actual points scored by the students. You can store the actual marks in a separate no-submission assignment. Do not post the grades for this no-submission assignment.
- Column C: Full marks. Enter points that the assignment is worth until the last row of the marks.
- Column D: Percentage. Drag down the formula from the first row until the last row of the marks.Â
- Column E: Representative score. Drag down the formula from the first row until the last row of the marks. The values in this column are what you should release to students.
- Column F: Letter grade. This follows the NUS grading scheme found in Canvas. This column is not necessary, but it will help you to see the letter grade for each student. Drag down the formula from the first row until the last row of your data.