I don't use a point total and would like to eliminate it from my gradebook. My grades are weighted - 3 quizzes worth 50%, 3 practical exams worth 30%, a final worth 20%, and an end of course presentation worth 10%.
In Blackboard I was able to calculate these grades from within the website. Can I do the calculation in an excel spreadsheet and import it in a CSV file?
How do I delete the totals column that showed up? I don't use it and it is misleading to the students/has no relevance for my courses.
Lastly, again in Blackboard, I was able to upload my grades, review them, then publish them when I was ready. From what I have seen, it looks like the grades are published as soon as I upload the CSV file. Unpublishing them deletes them completely and I had to reupload them.
Thank you.
Hi Daniel, welcome to the Canvas Community. I know what you are describing in Bb with creating your own computed column to weight your groups. It's true that the Canvas Gradebook doesn't let you create your own computer columns like that, but with your example the Canvas gradebook will do all of that with just a few changes to the settings. Assignment groups can be weighted, so you just need to create Assignment groups for each of your weighting categories, turn on weighting and set the percentages. I've created a video showing the set up process
VidGrid - Weighted Gradebook for Canvas Community .
As for the total column, it actually displays as a Percentage by default, not points. In fact if you turn on weighting it only can be a percentage. I don't show it in the video but in your course settings under Course Details and More Options, there is a place to hide the totals; but please watch the video first to see how it displays for students. I think you might like it with the percentage and even letter grade displayed.
Lastly, there is a way to import grades from a .csv file. But only assignment grades. I use that feature to import exam grades for large classes that take exams using scantron sheets. I'm hoping with the explanation above you'll find you don't need to do that.
Below are some guide pages which also might be useful.
How do I add an assignment group in a course?
How do I weight the final course grade based on assignment groups?
How do I add a grading scheme to an assignment?
How do I use the Assignments Index Page?
How do I move or reorder an assignment group?
How do I hide totals in my students' grade summaries?
Rick