You can enter grades in another application and import them into Brightspace using a CSV, TSV or TXT file. You can also create new grade items through an import file by adding a column to the file. Any grades you import for discussion grade items and assignment grade items are also synchronized back to Discussions and Assignments as published feedback.
The import file must follow a standard format; use the Grades sample import file as a reference point. D2L recommends that you set up your grade book in Brightspace even if you want to enter grades in a CSV, TSV, or TXT file.
Note the following:
- If you enter a grade value that is greater than the value for the grade item, the grade is capped at the value unless you selected the Can Exceed option when setting up the grade item.
- Do not import other options, such as a user’s first name, email, or weighted grade.
- To improve performance when importing grades for large classes, only import grade items that have changed and import by group or section when possible.
Field
|
Description
|
Example
|
| OrgDefinedID |
A unique number for identifying a user in Brightspace.
You must provide a Username or Org Defined ID (or both). |
20067930 |
| Username |
A unique name for identifying a user in Brightspace.
You must provide a Username or Org Defined ID (or both). |
Frank.Catcher |
| Points Grade |
Numeric and Pass/Fail grade items should be labeled the grade item name followed by “Points Grade”.
Users’ grades should be the Points Grade they received.
E.g., 44 points out of a possible 50 points. |
44 |
| Grade Symbol |
Select box grade items should be labeled the grade item name followed by “Grade Symbol”.
Users’ grades should be a pre-existing grade scheme symbol.
E.g., “Very Good”, “Merit”, or “3.5”. |
Very Good |
| Text Grade |
Text grade items should be labeled the grade item name followed by “Text Grade”.
Users’ grades can be any text value. Text grade items do not count towards users’ final grades. |
Perfect Attendance! |
| Adjusted Final Grade Numerator |
The total points a user achieved in a course. You can enter a user’s percentage grade (without the % sign) if you enter the denominator as 100.
E.g., 84 points out of 100 points or 230 points out of 285 points. |
84 |
| Adjusted Final Grade Denominator |
The total possible points available in a course. Enter 100 if you want to record users’ percentage grades.
E.g., _ / 100 points available or _ / 285 points available. |
100 |
| End-of-Line Indicator | Line-Leading Character |
The last column must be labeled “End-of-Line Indicator” so the system knows when the next set of data begins.
The end of each users’ line should be indicated with the pound key “#”.
When exporting a CSV file in Excel, the pound key "#" appears as a line-leading character.
|
# |