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
- In your site's menubar, click
Gradebook
.
- Near the top, click
Upload/Import
.
- On the Upload/Import screen, click
Upload spreadsheet (csv
format) to Loading Dock
.
- To select a file for upload, click
Browse
. Find the file
on your computer, click its name, and then click Open
.
- In the field next to "Title", type a unique name to be displayed
in the Loading Dock.
- Click
Save
.
- 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
- On the Upload/Import screen, find your newly uploaded file in the
Loading Dock, and next to it, click
Import
.
- 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
.
- 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.
- To include this assignment when calculating the final grade, check
the appropriate box. You can change this option later, if
necessary.
- 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.
- 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".