Uploading and 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. To view a list of permissions associated with a given role, see Permissions, roles, and tools. For a basic understanding of roles and permissions, see Permissions and Roles: Overview.

From within the Gradebook, you can upload .csv files containing columns of scores, and then import these as assignments. To upload and import scores to the Gradebook, follow these steps:

Uploading a file

Note: These instructions assume that you have a .csv file of scores stored on your local computer. The first column of your .csv file must contain individual usernames. The first row must contain headings for the columns.

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

  2. Click Upload/Import.

  3. Click Upload spreadsheet (csv format) to Loading Dock. You will then see a file selection form for uploading a .csv file to the Gradebook loading dock.

  4. Next to "Title", enter a unique name, which will be the name for the uploaded data file once it is in the loading dock.

  5. Next to "Choose a File", you may either type in a filename or click Browse to find and select the file you want to upload.

  6. Click Save to begin the upload. The Verify Upload screen will appear with a preview display of the file contents, allowing you to confirm that you chose the correct file. If you have the right file, click OK. If you need to select another file, click Back.

Importing a file

Once a file is uploaded to the Loading Dock, its contents become available to you for importing as new Gradebook assignments.

To import an uploaded file's contents as a new Gradebook assignment, follow these steps:

  1. On the Upload/Import screen, under "Loading Dock", find the appropriate .csv file, and then, next to that file, click Import.

  2. On the Import Preview screen, use the radio buttons to select the assignment scores you wish to import.

    Note: You can import only one set of assignment scores at a time.

  3. Click Import Selected.

  4. On the Import Assignment and Scores screen, fill in the following information:

    • Title: A title is required for all Gradebook assignments. The title can be up to 255 characters in length.
    • Assignment Point Value: You must assign a point value to all Gradebook assignments. Enter a value greater than zero. Decimals are permitted, but values are limited to two decimal places.
    • Due Date: You can optionally designate a due date for a Gradebook assignment. You can manually enter the due date (e.g., mm/dd/yy), or you can click the calendar icon to select a date from the pop-up calendar.

  5. To include this assignment when calculating the final grade, place a checkmark in the appropriate box. You can change this option later, if necessary.

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

  7. 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.