Brightspace Data Sets for Questions do not depend on specific tools being turned on.
Are you looking for further information about Quiz and Survey Questions? Refer to this helpful blog post on Enhancements to Quiz and Survey Data in Brightspace in Brightspace Community.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Questions. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Question Library
The Question Library Brightspace Data Set details all the questions that have been created in the organization. This includes quiz questions that are not currently used in a quiz.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 3.6 / 4.0 |
QuestionId
|
Unique question identifier
|
bigint
|
8
|
PK |
| 6.11 - Updated description |
QuestionVersionId
|
Unique question version identifier.
Each time you edit a quiz, survey, or self-assessment question, a new version of that question is created, indicated by the QuestionVersionID field.
|
bigint
|
8
|
PK |
| 6.11 - Updated description |
IsAutoGraded |
Indicates if the question is automatically graded.
|
bit
|
1
|
|
| 5.7 / 6.0 - Removed FK |
TemplateTypeId |
Unique identifier of the template used to create this question.
Field can be null.
|
int |
4 |
|
| 5.7 / 6.0 - Updated column size |
QuestionType |
Type of question.
Field can be null.
|
varchar
|
28
|
|
| 5.7 / 6.0 - Updated column size |
Name |
Question name.
Field can be null.
|
nvarchar
|
256
|
|
| 6.11 - Updated description |
Question |
Body of the question.
Field can be null.
|
nvarchar
|
1000
|
|
| 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
|
1000
|
|
| 3.6 / 4.0 |
AnswerKey |
Answer key for the question. This only applies to Written Response Questions.
Field can be null.
|
nvarchar
|
1000
|
|
| 5.7 / 6.0 - Field |
CreationDate |
Date the question was created (UTC)
|
datetime2
|
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. |
bigint |
8 |
|
| 5.8 / 6.1 |
AllowsAttachments |
Indicates if attachments are allowed in this question. Field can be null. |
bit |
1 |
|
| 9.9 |
AIUtilization |
Indicates whether D2L Lumi (Brightspace AI) capabilities were used and the level of AI involvement. Possible values:
0 - No AI capabilities were involved.
1 - Generated by AI and reviewed by a human.
2 - Generated by AI and edited by a human.
3 - Assisted or uplifted by AI.
|
int |
4 |
|
Question Relationships
The Question Relationships Brightspace Data Set details which quizzes, sections, question pools, surveys, or self-assessments the questions in Question Library have been added to.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 7.5 - Updated key |
CollectionId |
Unique question collection identifier
|
bigint
|
8
|
|
| 7.5 - Updated key |
QuestionId
|
Unique question identifier.
Field can be null.
|
bigint |
8
|
FK |
| 7.6 -Updated key |
QuestionVersionId
|
Unique question version identifier.
Each time you edit a quiz, survey, or self-assessment question, a new version of that question is created, indicated by the QuestionVersionID field.
Field can be null.
|
bigint |
8
|
UC, FK |
| 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.
|
bigint |
8
|
|
| 3.6 / 4.0 |
SectionId |
Unique section identifier.
Field can be null.
|
bigint |
8
|
|
| 3.6 / 4.0 |
IsQuestionPool |
Indicates if the question pool is a random section. |
bit
|
1
|
|
| 3.6 / 4.0 |
CreationDate |
Date the question was created (UTC) |
datetime2
|
8
|
|
| 6.11 - Updated description |
CreatedBy |
Id of the user who created the quiz, section, question pool, survey, or self-assessment.
Field can be null.
|
bigint
|
8
|
|
| 6.11 - Updated description |
LastModified |
Date when the quiz, section, question pool, survey, or self-assessment was last modified (UTC). |
datetime2
|
8
|
|
| 6.11 - Updated description |
LastModifiedBy |
Id of the user who last modified the quiz, section, question pool, survey, or self-assessment.
Field can be null.
|
bigint
|
8
|
|
|
4.8 / 5.2 - Updated column size
|
Points |
Possible points for the question.
Field can be null.
|
decimal
|
19, 9
|
|
| 3.6 / 4.0 |
Difficulty |
Difficulty level assigned to the question.
Field can be null.
|
int
|
4
|
|
| 6.11 - Updated description |
IsBonus |
Indicates if the question is a bonus question.
Field can be null.
|
bit
|
1
|
|
| 6.11 - Updated description |
IsMandatory |
Indicates if the question is mandatory.
Field can be null.
|
bit
|
1
|
|
| 6.11 - Updated description |
IsDeleted |
Indicates if the question is deleted. |
bit
|
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.
|
bigint
|
8
|
|
| 7.6 -Updated key |
ObjectId |
Unique identifier of the question. |
bigint |
8 |
UC |