Brightspace Data Sets for Grades

Brightspace Data Sets for Grades include:

These data sets have a dependency on Grades. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.

Entity Relationship Diagram

To show the relationships between entities used to create Brightspace Data Sets for Grades, click the following thumbnail image:

Entity Relationship Diagram for Grades

 

Brightspace Data Set: Grade Objects

About

Returns a list of the grade objects created for your org units.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

 

Grade Objects Data set is returning NULL grade scheme value when grade item is set to use default scheme. This is intended. When the value is NULL it means that it is using the default scheme.

 

Returned Fields

 

Version History

Field

Description

Type

Column Size

Key

1.0

GradeObjectId

Unique grade object identifier

int

4

PK

1.0

OrgUnitId

Unique org unit identifier.

Field can be null.

int

4

FK

1.0

ParentGradeObjectId

Parent grade object identifier.

Field can be null.

int

4

FK

5.7 / 6.0 - Changed Column Size

Name

Grade object name

nvarchar

128

 

1.0

TypeName

Grade object type name.

Field can be null.

varchar

50

 

5.7 / 6.0 - Changed Column Size

CategoryName

Grade object category name.

Field can be null.

nvarchar

128

 

1.0

StartDate

Start date for the grade object (UTC).

Field can be null.

datetime2

8

 

1.0

EndDate

End date for the grade object (UTC).

Field can be null.

datetime2

8

 

1.0

IsAutoPointed

Indicates if the object is automatically pointed. If this contains a value, the object automatically has points assigned; if it is set to 0, then the grade object must manually have points assigned.

bit

1

 

1.0

IsFormula

Is a formula associated with the grade object

bit

1

 

1.0

IsBonus

Is bonus grade

bit

1

 

4.8 / 5.2 - Updated column size

MaxPoints

Maximum points achievable in this grade

decimal

19, 9

 

1.0

CanExceedMaxGrade

Can user get more than maximum points

bit

1

 

1.0

ExcludeFromFinalGradeCalc

Is grade excluded from final grade calculation

bit

1

 

3.2 - Updated description

GradeSchemeId

Unique grade scheme identifier. This column returns a null result when the grade item is set to use default scheme. This is intended.

Field can be null.

bigint

8

 

4.8 / 5.2 - Updated column size

Weight

Weight associated with the grade.

Field can be null.

decimal

19, 9

 

1.0

NumLowestGradesToDrop

Drop number of lowest grades from the calculated grade

int

4

 

1.0

NumHighestGradesToDrop

Drop number of highest grades from the calculated grade

int

4

 

5.7 / 6.0 - Changed Column Size

WeightDistributionType

Grade weight distribution within category.

Field can be null.

varchar

8

 

1.0 CreatedDate

Date the grade was created (UTC).

Field can be null.

datetime2 8  
5.7 / 6.0 - Changed Column Size

ToolName

Tool associated with the object.

Field can be null.

nvarchar

50

 

1.0

AssociatedToolItemId

Unique activity ID associated with the grade object: Dropbox ID, Quiz ID, Discussion ID.

Field can be null.

bigint

8

 

1.1 LastModified Last time the grade was modified (UTC). datetime2 8  
5.7 / 6.0 - Changed Column Size ShortName

The item or category short name as per the corresponding field in Brightspace Learning Environment.

Field can be null.

nvarchar 128  
6.11 - Updated description GradeObjectTypeId

ID of the grade object type.

Possible values:

  • Numeric = 1

  • Pass/Fail = 2

  • Select box = 3

  • Text = 4

  • Calculated = 5

  • Formula = 6

  • Final Calculated = 7

  • Final Adjusted = 8

  • Category = 9

int 4  
1.1 SortOrder Specified sort order of grade objects int 4  
1.10 IsDeleted

Indicates if the grade object is deleted.

Field can be null.

bit 1  
1.10 DeletedDate

Date the grade object was soft deleted.

Field can be null.

datetime2 8  
5.7 / 6.0 - Changed Type and Column Size DeletedByUserId

ID of the user who deleted the grade object.

Field can be null.

int 4 FK
5.5 ResultId

Unique release condition result identifier.

Field can be null.

int 4 FK

 

Brightspace Data Set: Grade Objects Log

About

Returns a log of all changes to grades for each applicable user in the organization.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

 

Returned Fields

 

Version History

Field

Description

Type

Column Size

Key

5.7 / 6.0 - Changed Type and Column Size

LogId

Unique grade object log identifier.

bigint

8

PK

5.7 / 6.0 - Changed Column Size

Name

Name of the action.

Field can be null.

nvarchar

50

 

3.7 / 4.2

GradeObjectId

Grade object identifier.

int

4

FK

3.7 / 4.2 UserId Unique identifier of the user who completed the action. int 4

FK

5.7 / 6.0 - Changed Column Size

GradeSymbolString

Value of the grade.

Field can be null.

nvarchar

50

 

4.8 / 5.2 - Updated column size

PointsDenominator

Total number of points possible.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

PointsNumerator

Number of points received by user.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

WeightedDenominator

Total number of points possible after weight is applied.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

WeightedNumerator

Number of points received after weight is applied.

Field can be null.

decimal 19, 9  
3.7 / 4.2 Modified Date and time the action was made. datetime2 8  
3.7 / 4.2 ModifiedBy

User who modified the grade object.

Field can be null if done automatically.

int 4  

Brightspace Data Set: Grade Results

About

Returns data from the newest grade objects first.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

 

Version History

Field

Description

Type

Column Size

Key
1.0

GradeObjectId

Unique grade object identifier

int

4

PK, FK

1.0

OrgUnitId

Unique org unit identifier

int

4

PK, FK

1.0

UserId

Unique user identifier

int

4

PK, FK

4.8 / 5.2 - Updated column size

PointsNumerator

Number of points received by user.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

PointsDenominator

Total number of points possible.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

WeightedNumerator

Number of points received after weight is applied.

Field can be null.

decimal

19, 9

 

4.8 / 5.2 - Updated column size

WeightedDenominator

Total number of points possible after weight is applied.

Field can be null.

decimal

19, 9

 

1.0

IsReleased

Is grade released.

Field can be null.

bit

1

 

1.0

IsDropped

Is score dropped from final grade

bit

1

 

1.0

LastModified

Last time score was modified (UTC).

Field can be null.

datetime2

8

 

5.7 / 6.0 - Changed Type and Column Size

LastModifiedBy

User ID of user who last modified the grade object.

Field can be null.

int

4

FK

1.0

Comments

Comments.

Field can be null.

nvarchar

1000

 

1.0

PrivateComments

Private comments.

Field can be null.

nvarchar

1000

 

1.1 IsExempt

Is exempt.

Field can be null.

bit 1  
1.6 GradeText

Field can be null.

nvarchar 50  
3.2 GradeReleasedDate

Date when the grade was released to the learner (UTC).

Field can be null.

datetime2

8

 
3.2 Version

Indicates the version of the grade result.

Field can be null.

bigint

8  

 

Brightspace Data Set: Grade Schemes

About

Returns data about created grade schemes.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

 

Version History

Field

Description

Type

Column Size

Key
1.4 - Added Primary Key designation GradeSchemeId Unique grade scheme identifier. bigint 8 PK
1.0 OrgUnitId

Unique org unit identifier.

Field can be null.

int 4 FK
5.7 / 6.0 - Changed Column Size SchemeName Grade scheme name nvarchar 128  
1.4 GradeSchemeRangeId Unique grade scheme range identifier bigint 8 PK
1.10 IsDeleted

Indicates that the grade scheme is deleted.

Field can be null.

bit 1  
1.10 DeletedDate

Date when the scheme was deleted (UTC).

Field can be null.

datetime2 8  
5.7 / 6.0 Version Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. bigint 8  

 

Brightspace Data Set: Grade Book Settings

About

Returns all the grade book settings for your org units.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.0

OrgUnitId

Unique org unit identifier

int

4

PK,

FK

2.5 / 3.0 - Removed FK

GradeSchemeId

Unique grade scheme identifier

bigint

8

PK

5.7 / 6.0 - Changed Column Size

GradingSystem

Type of grading system setup for the course

varchar

8

 

5.7 / 6.0 - Changed Column Size

UngradedItems

Drop ungraded items/Treat them as 0

varchar

25

 

1.0

IsAdjustedFinalGradeReleased

Is final adjusted grade released to user.

Field can be null.

bit

1

 

1.0

IsCalculatedFinalGradeReleased

Is calculated adjusted grade released to user.

Field can be null.

bit

1

 

6.7 LastModified

Date gradebook settings were last modified (UTC).

Field can be null.

datetime2 8  

Brightspace Data Set: Grade Scheme Ranges

About

Describes the ranges used in grade schemes in the organization.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

5.7 / 6.0

GradeSchemeRangeId

Unique grade scheme range identifier.

bigint

8

PK, FK

5.7 / 6.0

GradeSchemeId

Unique grade scheme identifier.

bigint

8

PK, FK

5.7 / 6.0

SymbolString

The name of the range.

nvarchar

100

 

5.7 / 6.0

AssignedValue

The value assigned to the grade scheme range.

Field can be null.

decimal

19, 9

 

5.7 / 6.0

RangeStart

The starting value (in percent) of the grade scheme.

decimal

19, 9

 

5.7 / 6.0

IsDeleted

Indicates that the grade scheme is deleted

bit

1

 

5.7 / 6.0 Version Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. bigint 8