Importing scores into Gradebook

Note: To complete the procedures in this document, you must be assigned a role having the necessary permissions. To determine your role, follow the directions in Participant roles. For a basic understanding of roles and permissions, see Permissions and roles: Overview.

To import grades, you must first create a .csv spreadsheet file containing columns of point-based scores, and then upload it to the Gradebook Loading Dock. The first row of your spreadsheet must contain headings for the columns it contains. The first column must contain individuals' usernames.

Once you have your .csv file ready for upload, follow these steps:

Uploading a file to the Loading Dock

  1. In your site's menubar, click Gradebook.

  2. Near the top, click Upload/Import.

  3. On the Upload/Import screen, click Upload spreadsheet (csv format) to Loading Dock.

  4. To select a file for upload, click Browse. Find the file on your computer, click its name, and then click Open.

  5. In the field next to "Title", type a unique name to be displayed in the Loading Dock.

  6. Click Save.

  7. On the Verify Upload screen, review the number of assignments and students for your upload, and view a display of the file's contents. If the content is correct, click Ok. If you need to select another file, click Back.

Once a file is uploaded to the Loading Dock, its contents become available to import as new Gradebook assignments. To import an uploaded file's contents as a new Gradebook assignment, follow these steps:

Importing a file from the Loading Dock

  1. On the Upload/Import screen, find your newly uploaded file in the Loading Dock, and next to it, click Import.

  2. On the Import Preview screen, click the radio button to select the column that represents the assignment and corresponding scores you want to import. (You can select only one at a time.) Then click Import Selected.

  3. On the Import Assignment and Scores screen, enter the following information:

    • Title: The title you provided in the steps above is automatically filled in. If you didn't provide a title earlier, you must provide one here. The maximum length is 255 characters.
    • Assignment Point Value: Enter a total point value for the assignment. This must be greater than zero. Decimal values are permitted to two decimal places.
    • Due Date: In mm/dd/yy format, indicate the assignment's due date, or click the calendar icon to select a date using the pop-up calendar tool. This is not a required field.
    • Select a column to import comments: If a column in your file contains comments, use the drop-down list to select the appropriate column, and add the comments to the import. Comments will appear next to the grades in the Gradebook. This is not a required field.

  4. To include this assignment when calculating the final grade, check the appropriate box. You can change this option later, if necessary.

  5. To make this assignment's scores available to students, place a checkmark in the box next to Release assignment. You can change this option later, if necessary.

  6. When you're finished, click Submit. You'll return to the Import Preview screen, where you'll see confirmation that the assignment has been added. You can now select another assignment for import, or click the Reset button to return to the Gradebook Overview screen. You should see your imported assignment(s) listed under "Assignments".