Printer-friendly version

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.

The Gradebook allows you to import grades for existing Gradebook items, as well as items that have not yet been created. To import grades and create a new Gradebook item follow the Importing Gradebook items from a Spreadsheet (top set of directions). To import grades for existing Gradebook items follow the second set of directions below, Importing Grades for Existing Gradebook items.

Importing Gradebook items from a spreadsheet

To import Gradebook items, 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 Import gradebook item from spreadsheet.
3. On the Import Gradebook Item screen, click Upload spreadsheet (csv format) to Loading Dock.
4. In the field next to "Title", type a unique name to be displayed in the Loading Dock.
5. To select a file for upload, click Browse. Find the file on your computer, click its name, and then click Open.
6. Click Save.
7. On the Verify Upload screen, review the number of items 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 a new Gradebook item. To import an uploaded file's contents as a new Gradebook item:

Importing a file from the Loading Dock

1. On the Import Gradebook Item 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 Gradebook item and corresponding scores you want to import. (You can select only one at a time.) Then click Import Selected.
3. On the Import Gradebook Item 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.
   • Gradebook Item Point Value: Enter a total point value for the Gradebook item. This must be greater than zero. Decimal values are permitted to two decimal places.
   • Due Date: In mm/dd/yy format, indicate the item's due date, or click the "calendar" icon
     

     to select a date using the pop-up calendar tool. This field is not required.

   • 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 field is not required.
4. To make this item's scores available to students, select the Release this Item to Students option. You can deselect this later, if necessary.
5. To include this item when calculating the course grade, select the Include this item in course grade calculations option. You can deselect this later, if necessary.
6. When you're finished, click Submit. You'll return to the Import Preview screen, where you'll see confirmation that your item was added. You can now select another item for import, or click the reset icon to the left of the page name to return to the main screen. You should see your imported item(s) listed under "Gradebook Items Summary".

Importing grades for existing Gradebook items

1. In your site's menubar, click Gradebook.
2.  
3. Near the top, click Import Grades.
4. Download the spreadsheet template by clicking Download Spreadsheet Template.
5. Edit the spreadsheet in your favorite spreadsheet application, such as Excel, and save it as a .csv file.
6. Import the spreadsheet by clicking Browse... and choosing the .csv file.
7. After selecting the file, click Import Spreadsheet.
8. The following page should show the imported grades. When you are finished, click OK.

Things to consider

• You cannot import grades for Gradebook items sent from the Assignment tool. To link an Assignment tool assignment with the Gradebook you must do this from within the Assignment tool itself.
• Grades imported using the Import Grades option will overwrite any pre-existing grades. Always be sure to use the spreadsheet template downloaded in step 3.