You can import grades directly into the gradebook. To do so, you must:
Download the current student roster.
Edit grades for import.
Create an Import Grades column in the gradebook.
Note: Teaching assistants must have permission to import student grades. Use the Preferences > Permissions page to control which functionality is available to teaching assistants.
Download the student roster
To download the student roster in the appropriate format for import:
Click Gradebook > Grades.
From the download options at the bottom of the Grades page, select to export the Student Roster as a csv file and click Download.
In the File Download dialog box, click to Save the file to your local machine. By default, this file is called StudentRoster.csv.
Edit grades for import
To edit the file for import:
Open the student roster .csv file you saved. You can open the .csv file in Microsoft®
Excel® or any text editor.
Edit the Userscore (score the student obtained on the activity) and Maxscore (maximum points available for the activity) for each student.
Important: Do not alter any values for UserId, LastName, or FirstName in the .csv file.
If you need to leave a student's Userscore or Maxscore column blank, you
can still import these values for other students. However, an error message appears when you import the file.
When you finish editing, save the file in .csv format.
Create an Import Grades column
To import the grades into your Gradebook > Grades page:
Click Gradebook > Grades.
Click the Create Column drop-down menu available in the top-right corner of the page.
Select Import grades.
Click Browse to locate the student roster .csv file you edited.
Enter a Column name and select the location in the gradebook where you want to insert the column.
Click OK.
The imported grades appear in the inserted column.