Brightspace Data Sets for Quizzes have a dependency on the Quizzes tool. 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.
Refer to Enhancements to Quiz and Survey Data in Brightspace for more information about Quiz and Survey Questions.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Quizzes. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Related Data Sets
The Brightspace Data Sets for Quizzes have relationships with other data sets that are not described on this page, as illustrated by the Entity Relationship Diagram. These related data sets include:
Quiz Attempts
The Quiz Attempts Brightspace Data Set returns details for each user quiz attempt for all your org units. This data set includes completed quiz attempts and in-progress quiz attempts.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
AttemptId
|
Unique attempt identifier
|
bigint
|
8
|
PK
|
| 6.7 - Updated key |
QuizId
|
Unique quiz identifier
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
UserId
|
Unique user identifier
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
FK
|
| 1.0 |
AttemptNumber
|
Attempt number for the quiz
|
int
|
4
|
|
| 1.0 |
TimeStarted
|
Quiz attempt start time (UTC).
|
datetime2
|
8
|
|
| 1.0 |
TimeCompleted
|
Quiz attempt completion time (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 4.8 / 5.2 - Updated column size |
Score
|
Score for the attempt.
Field can be null.
|
decimal
|
19, 9
|
|
| 1.0 |
IsGraded
|
If a quiz has been graded
|
bit
|
1
|
|
| 1.10 |
OldAttemptNumber |
Number of previous times a learner has attempted the quiz.
Field can be null.
|
int |
4 |
|
| 1.10 |
IsDeleted |
Indicates that the quiz attempt is deleted.
Field can be null.
|
bit |
1 |
|
| 5.8 / 6.1 |
PossibleScore |
Indicates the total possible value of the quiz attempt. This should indicate what the quiz "out of" score is, even if the quiz total possible value changes after the attempt is made.
Field can be null.
|
decimal |
19, 9 |
|
| 8.10 - Updated description |
IsRetakeIncorrectOnly |
Indicates if this attempt only includes questions that were incorrect on a previous attempt.
|
bit |
1 |
|
| 6.11 |
DueDate |
Quiz attempt due date (UTC). Based on when the learner begins the attempt, even if the instructor changes the quiz due date later. This does not take any special access time limit into account.
Field can be null.
|
datetime2 |
8 |
|
| 6.11 |
TimeLimit |
Amount of time, in minutes, that a learner has to complete the quiz attempt. Based on when the learner begins the attempt, even if the instructor changes the quiz time limit later. This does not take any special access time limit into account.
Field can be null.
|
int |
4 |
|
| 6.11 |
TimeLimitEnforced |
Indicates whether the time limit on this quiz attempt is enforced. Based on when the learner begins the attempt, even if the instructor changes the time limit enforced setting later.
Field can be null.
|
bit |
1 |
|
| 9.0 - Changed Field name and Description |
TimeLimitExceededBehaviour |
If the time limit is enforced for this attempt, indicates the desired behavior when the time limit is exceeded.
Field can be null.
|
nvarchar |
128 |
|
| 9.0 |
IsSynchronous |
Indicates that a quiz attempt is synchronous. A synchronous quiz's timer starts on the start date. |
bit |
1 |
|
| 9.0 |
DeductionPercentage |
The percentage of a question's point value that is deducted from the quiz attempt score if the question is answered incorrectly. This value remains constant once the learner begins the attempt, even if the instructor changes the deduction percentage later.
Field can be null.
|
int |
4 |
|
Quiz Attempts Log
The Quiz Attempts Log Brightspace Data Set returns details on the events that occur during a quiz attempt. This data set includes completed quiz attempts, in-progress quiz attempts, and preview attempts. The IsDeleted value is always TRUE for preview attempts.
There is no explicit time cap placed on this data set. However, data is sorted from newest to oldest and older data will be dropped if the data set reaches the row limit.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 3.6 / 4.1 |
LogId |
Unique log identifier |
bigint
|
8
|
PK |
| 3.6 / 4.1 |
AttemptId
|
Unique attempt identifier
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
EventTypeId
|
Unique event type identifier
|
int
|
4
|
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Name of the event.
|
nvarchar
|
256
|
|
| 5.7 / 6.0 - Changed Column Size |
Description |
Description of the event.
Field can be null.
|
nvarchar
|
256
|
|
| 3.6 / 4.1 |
EventTime
|
Date and time the event occurred (UTC).
|
datetime2
|
8
|
|
| 3.6 / 4.1 |
IPAddress |
IPAddress at which the event occurred.
Field may be null for quiz submit events where the quiz was auto-submitted.
|
varchar |
15 |
|
| 9.14 |
UserId |
ID of the user who initiated the quiz attempt. |
int |
4 |
FK |
| 9.14 |
IsDeleted |
Indicates if the preview attempt has been deleted. |
bit |
1 |
|
Quiz Objects
The Quiz Objects Brightspace Data Set returns information about the settings and properties of a quiz.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.7 |
QuizId |
Unique quiz identifier |
bigint |
8 |
PK |
| 5.7 / 6.0 - Changed Column Size |
QuizName |
Quiz name |
nvarchar |
256 |
|
| 1.7 |
QuizDescription |
Description of the Quiz.
Field can be null.
|
nvarchar
|
1000 |
|
| 1.7 |
QuizCategory |
Name of category quiz is assigned to.
Field can be null.
|
nvarchar |
256 |
|
| 1.7 |
IsActive |
Indicates if the quiz is active |
bit |
1 |
|
| 6.7 - Updated key |
OrgUnitId |
Org unit identifier associated with the quiz object |
int |
4 |
FK |
| 1.7 |
StartDate |
First time the quiz is visible.
Field can be null.
|
datetime2 |
8 |
|
| 1.7 |
EndDate |
Last date the quiz is visible.
Field can be null.
|
datetime2 |
8 |
|
| 1.7 |
DueDate |
Date the quiz is due (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 1.7 |
CreationDate |
Date the quiz was created (UTC). |
datetime2 |
8 |
|
| 1.7 |
CreatedBy |
Id of the user who created the quiz.
Field can be null.
|
bigint |
8 |
FK |
| 1.7 |
LastModified |
Date when the quiz was last modified (UTC). |
datetime2 |
8 |
|
| 1.7 |
LastModifiedBy |
Id of the user who last modified the quiz.
Field can be null.
|
bigint |
8 |
FK |
| 1.7 |
GradeObjectId |
Grade object identifier associated with the quiz.
Field can be null.
|
bigint |
8 |
FK |
| 5.7 / 6.0 - Changed Column Size |
OverallScoreCalculation |
Quiz score calculation method. Types include: Highest Attempt, Lowest Attempt, Average of all attempts, First Attempt, and Last Attempt.
Field can be null.
|
varchar |
23 |
|
|
4.8 / 5.2 - Updated column size
|
QuizScoreDenominator |
Denominator for the quiz score |
decimal |
19, 9 |
|
| 1.7 |
HasPassword |
Indicates if a password is required to access this quiz.
Field can be null.
|
bit |
1 |
|
| 1.7 |
IPRestricted |
Indicates if this quiz is available only to certain IP Addresses.
Field can be null.
|
bit |
1 |
|
| 1.7 |
TimeLimit |
Time limit for the quiz in minutes. |
int |
4 |
|
| 1.7 |
TimeLimitEnforced |
Indicates if the time limit assigned to the quiz is enforced. |
bit |
1 |
|
| 1.7 |
AttemptsAllowed |
Number of times learners are permitted to attempt the quiz.
Null indicates unlimited attempts.
|
int |
4 |
|
| 1.7 |
PreventMovingBackwards |
Indicates if learners are permitted to move to previous pages in the quiz. |
bit |
1 |
|
| 1.7 |
AllowHints |
Indicates that there are hints allowed for the quiz. |
bit |
1 |
|
| 5.7 / 6.0 - Changed Column Size |
NotificationEmail |
Indicates that there is a notification email for this quiz if present.
Field can be null.
|
nvarchar |
1000 |
|
| 1.7 |
DisablePagerAccess |
Indicates that learners cannot access the pager functionality |
bit |
1 |
|
| 1.7 |
DisplayInCalendar |
Indicates if the quiz is displayed in the Calendar.
Field can be null.
|
bit |
1 |
|
| 2.2 |
IsAttemptRldb |
Indicates if Respondus LockDown Browser is required to attempt this quiz. |
bit |
1 |
|
| 2.2 |
IsSubviewRldb |
Indicates if Respondus LockDown Browser is required to see quiz results (submission view). |
bit |
1 |
|
| 2.2 |
SortOrder |
Display sort order for quizzes (when not alphabetical). |
int |
4 |
|
| 5.9 / 6.2 |
CategoryId |
Unique category identifier for the quiz.
Field can be null.
|
bigint |
8 |
|
| 5.9 / 6.2 |
ResultId |
Unique release condition result identifier.
Field can be null.
|
bigint |
8 |
FK |
| 8.10 - Updated description |
IsRetakeIncorrectOnly |
Indicates if the quiz allows Retake Incorrect Only.
|
bit |
1 |
|
| 7.14 / 8.0 - Updated field description |
PagingTypeId |
Exposes page break information.
Possible values:
-
NULL = Uses Classic Quiz Creation paging
-
0 = All questions on one page
-
1 = One question per page
-
2 = Page breaks after each section
-
3 = 5 questions per page
-
4 = 10 questions per page
Field can be null.
|
int |
4 |
|
| 9.0 |
IsSynchronous |
Indicates that a quiz is synchronous. A synchronous quiz's timer starts on the start date. |
bit |
1 |
|
| 9.0 |
DeductionPercentage |
The percentage of a question's point value that will be deducted from the quiz attempt score if the question is answered incorrectly.
Field can be null.
|
int |
4 |
|
| 9.16 / 10.0 |
AIStudySupport |
Indicates if D2L Lumi Study Support is enabled for the quiz. |
bit |
1 |
|
Quiz Question Answer Options
The Quiz Question Answer Options Brightspace Data Set returns possible options for a given quiz answer. Only includes answer options for these question types: Short Answer, Fill in the Blanks, and Multi-Short Answer. Rows in the data set are filtered out if they are associated with deleted quiz attempts.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
AnswerId
|
Unique answer Identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
AnswerText
|
User answer.
Field can be null.
|
nvarchar
|
1000
|
|
| 4.8 / 5.2 - Updated column size |
Weight
|
Weight associated with the answer
|
decimal
|
19, 9
|
|
| 1.0 |
QuestionId
|
Unique question identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
QuestionVersionId
|
Unique question version identifier
|
bigint
|
8
|
PK, FK
|
| 6.7 - Updated key |
QuizObjectId |
Unique quiz object identifier |
bigint |
8 |
PK, FK |
| 1.2 |
AnswerOptionId |
Unique answer option identifier |
bigint |
8 |
PK |
Quiz Question Answers
The Quiz Question Answers Brightspace Data Set returns possible answers for a given quiz question. This does not include questions in question pools.
|
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
|
1.0
|
AnswerId
|
Unique answer identifier
|
bigint
|
8
|
PK
|
|
1.0
|
QuestionId
|
Unique question identifier
|
bigint
|
8
|
PK, FK
|
|
1.0
|
QuestionVersionId
|
Unique question version identifier
|
bigint
|
8
|
PK, FK
|
|
1.0
|
SortOrder
|
Order in which the quiz answers are displayed or correct answer order for ordering questions.
|
int
|
4
|
|
|
1.0
|
IsCorrect
|
Is answer correct.
Field can be null.
|
bit
|
1
|
|
|
4.8 / 5.2 - Updated column size
|
Weight
|
Weight associated with answer.
Field can be null.
|
decimal
|
19, 9
|
|
|
5.7 / 6.0 - Changed Column Size
|
Answer
|
Answer text.
Field can be null.
|
nvarchar
|
1000
|
|
|
1.0
|
Comment
|
Instructor comment on the answer.
Field can be null.
|
nvarchar
|
1000
|
|
|
5.7 / 6.0 - Changed Column Size
|
Description
|
System description for the type of answer expected.
|
nvarchar
|
256
|
|
|
6.7 - Updated key
|
ObjectId |
Unique identifier of the answer |
bigint |
8 |
PK |
Quiz Survey Sections
The Quiz Survey Sections Brightspace Data Set returns information about all the sections and question pools that have been created in quizzes in the organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.7 / 5.1 - Updated description |
CollectionId |
Unique question collection identifier |
bigint |
8 |
FK |
| 3.4 |
SectionId |
Unique section identifier. |
bigint |
8 |
PK |
| 9.4 - Updated description |
Name |
Name of the section (title).
Field can be null.
|
nvarchar |
256 |
|
| 9.4 - Updated description |
NameIsDisplayed |
Indicates if the section name (title) is hidden or shown. Values are 0 for hidden, and 1 for shown. |
bit |
1 |
|
| 9.4 - Updated description |
IsQuestionPool |
Indicates if the section is a question pool. |
bit |
1 |
|
| 9.4 - Updated description |
SectionText |
Section text.
Field can be null.
|
nvarchar |
1000 |
|
| 3.4 |
SectionTextIsHTML |
Indicates if the section text is HTML or plain text. |
bit |
1 |
|
| 9.4 - Updated description |
IsSectionTextHidden |
Indicates if the section text is hidden or shown. Values are 0 for hidden, and 1 for shown.
|
bit |
1 |
|
|
9.4 - Updated description
|
QuestionPoints |
Number of points the section is worth when the section is a question pool. Sections that are not question pools will show as null.
Field can be null.
|
decimal |
19, 9 |
|
| 9.4 - Updated description |
NumQuestions |
Indicates the number of questions in the section if the section is a question pool. If the section is not a question pool, 0 is displayed. |
int |
4 |
|
| 9.4 - Updated description |
NumChoices |
Indicates the number of choices in the question pool (pool size). |
int |
4 |
|
| 9.4 - Updated description |
Shuffle |
Indicates that the questions in the section are shuffled. Not to be confused with a question pool; a shuffled section displays the questions shuffled randomly. |
bit |
1 |
|
| 9.4 - Updated description |
CreationDate |
Date the section was created (UTC). |
datetime2 |
8 |
|
| 9.4 - Updated description |
CreatedBy |
Id of the user who created the section.
Field can be null.
|
bigint |
8 |
FK |
| 9.4 - Updated description |
LastModified |
Date when the section was last modified (UTC). |
datetime2 |
8 |
|
| 9.4 - Updated description |
LastModifiedBy |
Id of the user who last modified the section. If questions are imported into the section, this will be null.
Field can be null.
|
bigint |
8 |
FK |
| 9.4 - Updated description |
IsDeleted |
Indicates that the section is deleted.
Field can be null.
|
bit |
1 |
|
| 9.4 - Updated description |
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.
Field can be null.
|
bigint
|
8
|
|
Quiz User Answer Responses
The Quiz User Answer Responses Brightspace Data Set returns details on how a user answered a specific quiz question. Data includes whether an answer is correct and details around the quiz score. Rows in the data set are filtered out if they are associated with deleted quiz questions. The Quiz User Answer Responses Brightspace Data Set contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
AttemptId
|
Unique attempt identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
AttemptNumber
|
Attempt number associated with the AttemptId
|
int
|
4
|
|
| 1.0 |
QuestionId
|
Unique question identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
QuestionVersionId
|
Unique question version identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
AnswerId
|
Unique answer identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
SortOrder
|
Order in which quiz question options appear to the user. For example, the order in which multi-select or true /false options appear. Some question types can be randomized, for example, multi-select.
|
int
|
4
|
|
| 1.0 |
IsCorrect
|
Is user response correct.
Field can be null.
|
bit
|
1
|
|
| 1.0 |
UserSelection
|
Indicates the option a user chose for a block question type (ie. True and False, Multiple Choice, Multi-Select).
Field can be null.
|
bigint
|
8
|
|
| 1.0 |
UserAnswer
|
Indicates the user answer for written question types (ie. Short Answer, Written Response).
Field can be null.
|
nvarchar
|
1000
|
|
| 5.8 / 6.1 |
FileSetId |
Indicates the auto generated file set ID of uploaded file(s).
Field can be null.
|
bigint |
8 |
|
| 9.10 |
LastModified |
Date and time when the question answer response was last modified (UTC). |
datetime2 |
8 |
|
| 9.10 |
IsDeleted |
Indicates if the question answer response is deleted.
Field can be null.
|
bit |
1 |
|
Quiz User Answers
The Quiz User Answers Brightspace Data Set returns data that describes the question and score the user received. Rows in the data set are filtered out if they are associated with deleted quiz questions. The Quiz User Answers Brightspace Data Set contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
AttemptId
|
Unique attempt identifier
|
bigint
|
8
|
PK, FK
|
| 6.7 - Updated description |
QuestionId
|
Unique question identifier.
|
bigint
|
8
|
FK
|
| 5.12 / 6.5 - Updated key |
QuestionVersionId
|
Unique question version identifier.
Field can be null.
|
bigint
|
8
|
FK
|
| 8.11 / 9.0 - Updated description |
TimeCompleted
|
Date/time when the question was completed (UTC). No data is provided for question pools or sections.
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
QuestionNumber
|
Question number in the quiz.
Field can be null.
|
int
|
4
|
|
| 1.0 |
Comment
|
Feedback left by instructor.
Field can be null.
|
nvarchar
|
1000
|
|
| 1.0 |
SortOrder
|
Order in which quiz questions appear in the user interface. This also accounts for the ordering of sections (question numbers are null for sections).
|
int
|
4
|
|
| 4.8 / 5.2 - Updated column size |
Score
|
Score the user received for the answer.
Field can be null.
|
decimal
|
19, 9
|
|
| 1.0 |
Page
|
Page the question appeared on when the user took the quiz
|
int
|
4
|
|
| 3.6 / 4.1 |
SectionId |
Unique section identifier.
Field can be null.
|
bigint |
8 |
FK |
| 6.7 - Updated key |
ObjectId |
Unique global identifier of the question object. |
bigint |
8 |
PK |
| 9.8 |
OutOf |
The denominator of the quiz score.
Field can be null.
|
decimal |
19, 9 |
|
| 9.8 |
TimeStarted |
Quiz attempt start date and time (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 9.8 |
IsBonus |
Indicates if the question is a bonus question.
Field can be null.
|
bit |
1 |
|
| 9.8 |
IsDeleted |
Indicates if the answer is deleted. |
bit |
1 |
|
| 9.8 |
LastModified |
Date and time when the question answer was last modified (UTC). |
datetime2 |
8 |
|
| 9.8 |
LastModifiedBy |
Id of the user or task who last modified the question. |
int |
4 |
FK |
| 9.8 |
QuizTimeCompleted |
Date and time a quiz attempt was completed (UTC). |
datetime2 |
8 |
|
