Help
Import Scores

You can easily import scores into the gradebook from a tab-delimited or comma-separated-value (CSV) file.

Requirements

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.

Header Row

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:

Column HeaderDescription
First NameStudent first name
Last NameStudent last name
UsernameStudent user name
User IDStudent user ID
External IDStudent external ID (reference)
Enrollment IDStudent 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.
Example
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
Steps
1.

Click Import Scores on the gradebook.

2.

Choose a tab-delimited or comma-separated-value file to import and press Continue. If the file contains a header row, check Header Row.

3.

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.

4.

Review the results. Click Close when done.