Import and Export Grades

How do I export grades from Gradebook?

Exporting the gradebook is an ideal solution for instructors who wish to use a spreadsheet application to track and grade students. It is recommended instructors use the gradebook export as a spreadsheet template in order to easily upload it back to the gradebook.

  1. Click Import/Export.

    Click Import/Export.
  2. Click Export Gradebook if you wish to have the gradebook downloaded as an exported file. The columns included in the exported file are Student ID, Student Name, Student Number, and the scores and comments for all gradebook items.

    Select Advanced

Custom Export

The custom export option allows you to choose the columns included in the exported file.

Note: Customized exports can only be imported back into the system if Student ID and Student Name are retained in the first and second columns and all other formatting conventions are followed.

  1. Click the Custom Export link.

    Click Custom Export.
  2. Select the items you would like to include in your export.

    Note: The default options for Custom Export are the standard export. The Custom Gradebook will download as a .csv file.

    • Student ID: This is the student's Western username or external email address for non-Western users.
    • Student Name: This is the full name of the student with the last name first then the first name after it.
    • Student Number: This is the unique number associated with each student's Western identity.
    • Last Log Date: This shows the date and time of when the last change was made to a student's grades.
    • Gradebook Item Scores: This is the score that the student received on the Gradebook Item.
    • Gradebook Item Comments: This is the comment that the student received for a specific Gradebook Item.
    • Course Grade: This is the overall grade that the student has in the course.
    • Grade Override: This shows the student's new course grade after it has been overridden.
    • Final Grades: This is the final grade that would be submitted to the Registrar.

    Using the dropdown menu, you can select whether you would like the exported file to include only a certain section/group or all students.

    Click Download Gradebook.
  3. Click the Download Custom Export button.

    Click Download Gradebook.

How do I import grades into Gradebook?

  1. Click the Import/Export tab.

    Click Import/Export.
  2. Click the Choose File button to browse for and select your import file.

    Note: The import file must be in a specific format in order to import correctly. It should be a .csv, .xls, or .xlsx file and contain the appropriate student and grade data. If there are issues importing a .xls or .xlsx file, try saving it to a .csv file before uploading. DPC files can be imported as well to upload grades from a scantron. For more information, see Scantron Services.

    Click Browse.
  3. Click the Continue button.

    Click Import Spreadsheet.
  4. A summary of changes will be previewed for you. Select each item you would like to create or update. Then, click the Next button to continue with the import. If you notice any errors, click the Back button to restart the import process.

    Select the items to be imported.
  5. Creating new items. (Optional)

    If your import includes a new gradebook item, you will be prompted to edit the item options for each new item. Select the desired options and click the Next back to continue.

    New item options.
  6. Click the Finish button.

    Click Finish.
  7. You should receive a confirmation message on the import screen once your spreadsheet has been imported successfully.

    Import confirmation.