Import Final Report Card Grades

Import from Canvas to ProgressBook with NO manual typing.

Created by Scott Aten, October 15, 2021

At the beginning of the school year you were given the choice of using the sync option to bring grades to ProgressBook or doing not syncing and manually type in the final grade on the report card at the end of the nine weeks. What I didn't say at the time was that I was hoping to find a way to bring in the final grades to ProgressBook WITHOUT manually typing in all the final grades. Good New! There is a way and this blog post will describe how to do it.

ONLY APPLILES TO STAFF THAT ARE NOT SYNCING GRADES
So if you are doing the daily or weekly sync of each assignment into ProgressBook from Canvas, you can stop reading because this post does not apply to you. For the rest of you here we go...

BASIC STEPS

Download your grades from Canvas as a spreadsheet
Make a few edits to the spreadsheet to get it ready
Create an assignment in ProgressBook and copy that assignment to all the classes you teach.
Import Spreadsheet (final grade) into the assignment in ProgressBook
At report card time click "check/equals" and you are done with report cards

Now that you have the basic idea of what we are going to do, you are ready to look at the actual directions. I have created both a written step-by-step document that tells you exactly what to do as well as a video of me doing all the steps that you can watch.

[Written Step-By-Step Directions]

Video Demonstration

That is all you need to do. Follow these steps and your Canvas Final Grade will match perfectly to your ProgressBook Report Card grade.

Please keep in mind if you ever need to schedule me for a 1-1 help session, these can be scheduled using this link.

[Green Technology Training Center]

[Click here to go to the YouTube Channel]

For more helpful information and the archive of previous posts, look for items in the menu to the left.