Brightspace Data Sets for Questions

Brightspace Data Sets for Questions include:

These data sets do not depend on specific tools being turned on.

Entity Relationship Diagram

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

 

Brightspace Data Set: Question Library

About

Returns details about all questions in the question library, regardless of whether or not it is currently used in a quiz.

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

3.6/4.0

QuestionId

Unique question identifier

BigInteger

8

PK
3.6/4.0

QuestionVersionId

Unique question version identifier.

Each time you edit a quiz question, a new version of that question is created, indicated by the QuestionVersionID field.

BigInteger

8

PK
3.6/4.0 IsAutoGraded

Quiz question is automatically graded.

Boolean

1

 
3.6/4.0 TemplateTypeId

Unique identifier of the template use to create this question. Field can be null.

Integer 4 FK
3.6/4.0 QuestionType

Type of question. Field can be null.

nvarchar

512

 
3.6/4.0 Name

Question name. Field can be null.

nvarchar

512

 
3.6/4.0 Question

Quiz question. Field can be null.

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L Customer Support.

 
3.6/4.0 Comment

Comment associated with the question. Field can be null.

When you add a question to a quiz, the Overall Question Feedback field provides feedback comments during the grading process. The information captured in this field is the Comment field.

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L Customer Support.

 
3.6/4.0 AnswerKey

Answer key for the question. This only applies to Written Response Questions.

Field can be null.

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L Customer Support.

 
3.6/4.0 CreatedDate

Date the question was created (UTC)

DateTime

8

 
3.6/4.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. DateTime 8  

 

Brightspace Data Set: Question Relationships

About

Returns a list of each question in question library mapped to the quiz, section, or question pool where the question has been added.

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

3.6/4.0 CollectionId

Unique question collection identifier

BigInteger

8

PK
3.6/4.0

QuestionId

Unique question identifier

BigInteger

8

PK
3.6/4.0

QuestionVersionId

Unique question version identifier.

Each time you edit a quiz question, a new version of that question is created, indicated by the QuestionVersionID field.

BigInteger

8

PK
3.6/4.0 Order

Order in which questions appear in the user interface. If the question is within a section, the Order field uses the section's order in the user interface.

BigInteger

8

 
3.6/4.0 SectionId Unique section identifier. Field can be null.

BigInteger

8

 
3.6/4.0 IsQuestionPool Indicates if the question pool is a random section.

Boolean

1

 
3.6/4.0 CreationDate Date the question was created (UTC)

DateTime

8

 
3.6/4.0 CreatedBy Id of the user who created the quiz. Field can be null.

BigInteger

8

 
3.6/4.0 LastModified Date when the quiz was last modified (UTC).

DateTime

8

 
3.6/4.0 LastModifiedBy Id of the user who last modified the quiz. Field can be null.

BigInteger

8

 

4.8 / 5.2 - Updated column size

Points

Possible points for the question. Field can be null.

Numeric

19, 9

 
3.6/4.0 Difficulty

Difficulty level assigned to the question. Field can be null.

Integer

4

 
3.6/4.0 IsBonus

Quiz question is a bonus question. Field can be null.

Boolean

1

 
3.6/4.0 IsMandatory

Quiz question is mandatory. Field can be null.

Boolean

1

 
3.6/4.0 IsDeleted Indicates that the quiz question is deleted. Field can be null.

Boolean

1

 
3.6/4.0 Version Indicates the version of the question. This column supports the Question Pools information in the Assessment Quality Dashboard. Field can be null.

BigInteger

8

 
3.9/4.4 ObjectId Unique identifier of the question. BigInteger 8 PK