Purdue University - Department of Computer Science - Importing Grades Skip to main content

Importing Grades to Brightspace

 

Brightspace Grade Import File Formatting
Brightspace grade imports require a specific file format and extension. First, ensure that the grade file is saved with the ".csv" extension. You can do so using the "File" -> "Save as" mechanism in editors such as Microsoft Excel. You may receive a warning when doing so, selecting "Yes" will allow you to edit the file. 

Next, each of the columns must include follow a specific naming convention. There are three types of columns available in the grade import file: 

  • Identifying information: These columns must appear first in the file. They can store student identifying information, either username or Org Defined ID. 
  • Grade information: Each of the grade columns should include the grade item name followed by the value type. For example, if the score is numeric, the value type is "Points Grade". A grade item named Test 1 would have the full column name of "Test 1 Points Grade". 
  • End-of-Line: The last column must be named "End-of-Line Indicator". This will be used by Brightspace to determine when to move to the next row. 
BrightspaceGradeImport1.PNG
You can include as many score columns as necessary. 

  

Brightspace Generating an Import File
Creating the Grade Items

Before generating the export files, create grade items for all the assignments that will be imported. This will simplify the import process and reduce the risk of errors. 

  • First, navigate to "Grades" -> "Manage Grades".
  • Select the "New" button. 
  • Name the Grade item for the assignment.
  • Set the Grade Item settings as appropriate, these options will depend on your specific gradebook configuration. 
  • Repeat this process for every grade item! 
BrightspaceCreateGradeItem.gif

After all the Grade Items have been created, navigate to "Grades" -> "Enter Grades". Select the "Export" button: 

  • Select the Key field you wish to use to identify students. Typically, "Username" is sufficient.
  • Select the "Points Grade" option under Grade Values. 
  • Select any other identifying information you'd like to have available for each student.
  • Lastly, select each of the grade items you need to import. 
BrightspaceGradeImport2.gif
Once the settings are configured as you need, select "Export to CSV". The column names may include additional information about the grade item, such as the maximum point value, as comments enclosed in angle brackets <>. You can leave these comments in or delete them, it will not affect the import. 
This process will generate a pre-formatted file ready for you to enter grades. 

 

Brightspace Uploading an Import File

Uploading the Grade File

Navigate to "Grades" -> "Enter Grades". Select the "Import" button: 

  • Upload the file with the grades in it. 
  • It will not be necessary to select the checkbox to create unrecognized grade items, as the column names should match up to existing items. If you created additional columns, you can check this box.
  • Select "Continue". 
  • The error list should be empty. See the next section on resolving potential errors if it is not.
  • The next page will list a preview of all the changes. If they appear correct, select "Import" to complete the process. 

 BrightspaceGradeImport3.gif

Verifying Results

On the review page, each of the grade items will be listed in a column with the before and after values in the following format: 

[Before] -> [After]

You can use this data to ensure the scores were matched to each individual student properly and were interpreted accurately. 

Resolving Errors

You may encounter an error when uploading the file:

BrightspaceGradeImport3.PNG

Typically, this will occur due to a file formatting issue. You can resolve it in the following ways: 

  • Verifying the columns are named appropriately. 
  • Verifying the End-of-Line Indicator column is the last column in the file. 
  • Verifying the data in the rows matches the column type.

The most common issue is an extra column in the file, after the End-of-Line Indicator. Spreadsheet editors may not display the column. To verify it does not exist, you can open the csv in a text editor such as notepad. If there is a comma following the End-of-Line Indicator, there is an additional column in the file. You can delete it in the spreadsheet editor or notepad. 

BrightspaceGradeImport4.PNG

Last Updated: Mar 12, 2021 2:20 PM

Department of Computer Science, 305 N. University Street, West Lafayette, IN 47907

Phone: (765) 494-6010 • Fax: (765) 494-0739

Copyright © 2020 Purdue University | An equal access/equal opportunity university | Copyright Complaints

Trouble with this page? Disability-related accessibility issue? Please contact the College of Science.