Importing/Exporting Grades
You can enter grades in another application (Excel) and import them into Brightspace using a CSV, TSV or TXT file. New items can be created by adding columns to the import template. Grades can also be exported to other applications as a CSV or XLSX.
Related
Importing Grades
D2L and CPI strongly recommend instructors enter and manage grades within the Grades tool for the best experience. Only grades that have changed should be imported into the Gradebook. Grade items that have not been changed in the CSV files should have these columns deleted prior to upload. While new items can be added via the CSV upload, it is strongly recommended to only create new grade items within the Grades tool. This page covers how to prepare your file for upload and upload your grades.
Warnings
Below are various warnings that could lead to errors or other issues when making use of the import/export tools in Grades.
Column order matters, as does header text and formatting. The order should be: OrgDefinedID, Username, grade items, End-of-Line Indicator.
Importing grades does require that the Username and OrgDefineId columns be present, even if they are blank.
When importing grades into an already existing grade item, the column with the grades in them must be titled “<Grade item name> Points Grade”. This lets Brightspace know that there are grades being added.
Our experience is that certain characters cannot be part of column names. Illegal characters include : % & # * ? < > | \ " '
It’s easy to introduce phantom characters into the headers, such as start-of-sentence-width-spaces. Brightspace’s import template even includes these, they need to be removed before importing or errors will occur.
Preparing your file for upload
The file to be uploaded must be a CSV, TXT, or TSV file type. It is recommended to use CSV files.
While Brightspace offers an example document to use as a structure for import, CPI instead recommends exporting from Grades to retrieve all of the student information (names, org defined ID, etc.) instead of having to enter it manually.
There are two different options for importing grades. The first option, which is strongly recommended by CPI, begins by creating the grade items in Grades before beginning the import process. The second option involves creating the grade items using the Brightspace import template provided, but comes with more potential for errors.
Option 1 - Creating Grade Items in Advance
Option 2 - Creating Grade Items from the CSV file
Exporting Grades
Grades can be exported to CSV or XLSX file formats. These file types are compatible with Microsoft Excel and MacOS Numbers. D2L strongly encourages creating grade items and entering grades directly in Brightspace for the most compatible and reliable experience. Grades can be exported for all users in a course, or by groups. Follow the instructions outlined below:
Go to Grades tool homepage.
Select Export.
Specify the desired export details and formatting, including what users to export grades for - this can be All users or by Groups.
The Key Field is the left most column and how users will be sorted by.
The Sort by tab specifies how user information is organized in columns from left to right.
Select the grade items to be exported at the bottom of the page (note: all items are selected by default).
Choose Export to CSV or Export to Excel.
Once the file is prepared click Download.
The file can now be opened with programs that support the CSV file type or Excel.
For further assistance please contact edtech@brocku.ca.
FAQ
Q | A |
---|---|
Can I import grades after making changes to a grades export file? | Yes - if saved and uploaded as a CSV |
Can I import excel (XLSX) files? | No - unless saved as a CSV |
Can I add new students with an import? | No |
Please contact CPI at edtech@brocku.ca with any questions or comments about the contents of this site.