To upload grades from Excel to the Gradebook follow the Steps below.
Select Grades>Gradebook to access the gradebook.
In the Gradebook view click on any cell to view the Gradebook tools .
The Upload Grades icon can be selected to upload grades from Excel to the Gradebook.
Note: There is no direct method of uploading the entire gradebook since grades are tied to assignments. Therefore in order to upload grades you must download the Assignment Template to upload grades first. Please continue reading for more information.
After selecting Upload Grades you will get the following screen.
In order to upload grades to the gradebook you will have to first select an Assignment category from the drop-down menu and then download the template. When you have the template open you can attach your grades and save it locally on your drive. Once this has been completed you will be able to browse for the CSV file and use the Upload function to upload your grades.
Once you upload your grades using the template you will see an image similar to the one below.
The green-shaded portion shows accepted grades and the red-shaded portion are non-excepted grades.
Note: You will have to do this for every assignment.