You can easily import scores into the gradebook from a tab-delimited or comma-separated-value (CSV) file.
Each row in an import file must include one or more score columns and one or more columns that uniquely identify the enrollment. Specify score values as points, percent, letter, or decimal (0-1) values. Uniquely identify the enrollment with the EnrollmentId column if possible; otherwise, include a combination of UserName, FirstName, LastName, etc., to uniquely identify the enrollment. You identify the item(s) to import scores for in the Import Scores screen, or you can identify them in a column header row by ID, name, or abbreviation. (See Column Headers below.)
You can import scores for all gradable items except for computer-graded items (assessment, homework, and custom activity or SCO) and rubric-graded assignments.
You can include a header row in your import file to define the meaning of each column in the import. These are possible column headers:
|First Name||Student first name|
|Last Name||Student last name|
|Username||Student user name|
|User ID||Student user ID|
|External ID||Student external ID (reference)|
|Enrollment ID||Student enrollment ID|
|[ItemId]||The ID of the item to score. Replace ItemId with the item's actual ID, and omit the brackets.|
|[ItemName]||The name of the item to score. Replace ItemName with the item's actual title, and omit the brackets.|
|[ItemAbbreviation]||The abbreviation of the item to score. Replace ItemAbbreviation with the item's abbreviation, and omit the brackets.|
Last Name,First Name,Assignment Garcia,David,92 Hall,Donald,80 Harris,Dorothy,93 Hernandez,Elizabeth,77 Jackson,Helen,95 Johnson,James,94 Jones,Jennifer,92 King,John,75 Lee,Joseph,80 Lewis,Karen,66
Click Import Scores on the gradebook.
Choose a tab-delimited or comma-separated-value file to import and press Continue. If the file contains a header row, check Header Row.
If the file had a Header Row, verify that all columns are defined correctly; otherwise, define the meaning of each column in the file. For the score column, you can specify what format the scores are in (points, percent, etc.) Click Import.
Review the results. Click Close when done.