How do I import final letter grades into Gradebook?
A spreadsheet can be used to import final letter grades into Gradebook.
The spreadsheet file must be in a specific format to import correctly. You can use a spreadsheet file exported from Gradebook as a template to include the appropriate columns where you can enter the final grades.
Go to Gradebook.
Select the Gradebook tool from the Tool Menu of your site.
Select the Import/Export tab.
Select Custom Export.
Select the Custom Export link to include final grade options in the spreadsheet.
Select Grading Schema(s) and Course Grade Override(s), and Download.
In the Custom Export window that pops up:
- Select the Grading Schema(s) and Course Grade Override(s) checkboxes.
- Select Download Custom Export.
Tip: Depending on how your students are registered for your course in SIS, you may need to enter grades for different students in different columns in the spreadsheet.
Examples:
- Undergraduate and graduate students are included in the same site.
- Some students in your course have opted for letter grades, while others have opted for credit/no credit grades.
Selecting the Grading Schema(s) option includes a column indicating the appropriate grade type for each student.
Save the file.
The prompts and steps for downloading the file will depend on your internet browser. Save the file to your computer.
Open the file in your preferred spreadsheet application.
The spreadsheet contains the student information (first two columns), a # Grading Schemas column, and a Grade Override(s) column for each grading schema used for class roster(s) added to the site (see the note below for more information on grading schemas). The # Grading Schemas column indicates the appropriate column where each of the students' grades should be entered and the type of grade needed.
Each Grade Override(s) column is identified with a caret (^) followed by a space and the corresponding grading schema. For example, in a course site that includes both undergraduate and graduate students, the spreadsheet will include two Grade Override(s) columns:
- ^ GRA-GRD - Graduate students
- ^ UG-GRD - Undergraduate students
Note: Grading schemas are the scales on which final grades are based. The most common grading schema is UG-GRD (undergraduate graded), which uses a letter grade scale of A-F.
The grading schema used for a student is defined by:
- The degree the student is pursuing, e.g., undergraduate (UG) or graduate (GRA),
- The SIS Grading Basis for the roster in which they enrolled, e.g., graded (GRD), audit (AUD), or credit/no credit (CNC).
Enter grades and save the spreadsheet.
Enter the letter grade for each student in the appropriate Grade Override(s) column.
In the example pictured above, Students Four and Five are graduate students, so their grades are entered in the ^ GRA-GRD column. Students One, Two, and Three are undergraduates, so their grades are entered under ^ UG-GRD.
Save any changes made to the spreadsheet, keeping the spreadsheet as a CSV file.
Import the spreadsheet.
On the Import/Export page:
- Select the Choose File button to browse for and select your import file.
- After locating and selecting your import file, select Continue.
Select the items to be imported.
You will be taken to the Course Grade Import Selection page, where you can choose which grade(s) to import.
- By default, Select all viable grades to import is selected.
- To import specific grades only, remove the checkmark(s) from any check box(es) for grade(s) you do not want to import.
- Select Next to continue with the import.
Select Finish.
A confirmation page will display a summary of the grades to import. Select Finish to confirm.
(If you notice any errors, select Back to return to the Course Grade Import Selection page.)
View imported grades.
- You will be returned to the Grades page with a confirmation message indicating your spreadsheet has been imported successfully.
- The newly uploaded grades will appear in the Course Grade column.
