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.
Note: As of the July 2023/20.23.7 release, the Grace Period and Allow the student to continue working, but automatically score the attempt as zero timing options are no longer available within the Quizzes tool. This affects the data within this data set in the following ways:
- Quiz attempts started before this release include the grace period minutes in the GracePeriod field, but quiz attempts started after this release will have NULL in the GracePeriod field.
- For an existing quiz that has the Allow the student to continue working, but automatically score the attempt as zero option selected, all attempts started before the July 2023/20.23.7 release return Allow the student to continue working, but automatically score the attempt as zero after an extended deadline in the GracePeriodExceededBehaviour field. After this release any new attempts return Automatically submit the quiz attempt.
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.
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.
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 |
|
| 6.11 |
GracePeriod |
Amount of time, in minutes, that a learner has to complete the quiz attempt in addition to the time limit. Based on when the learner begins the attempt, even if the instructor changes the quiz grace period later.
Field can be null.
|
int |
4 |
|
| 6.11 |
GracePeriodExceededBehaviour |
If the time limit is enforced for this attempt, indicates the desired behavior when the grace period is exceeded. Based on when the learner begins the attempt, even if the instructor changes the exceeded grace period behavior setting later.
Types can be:
-
Allow the student to continue working.
-
Prevent the student from making further changes.
-
Allow the student to continue working, but automatically score the attempt as zero after an extended deadline.
Field can be null.
|
nvarchar |
128 |
|
| 6.11 |
ExtendedDeadline |
The extended deadline learners are allowed beyond the grace period for this attempt, in minutes. Based on when the learner begins the attempt, even if the instructor changes the quiz's extended deadline later. Beyond this extended deadline, the learner's attempt is graded as 0.
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 and in-progress quiz 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.
Field can be null.
|
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
|
Event occurred time (UTC).
|
datetime2
|
8
|
|
| 3.6 / 4.1 |
IPAddress |
IPAddress at which the event occurred.
Field can be null.
|
varchar |
15 |
|
Quiz Objects
The Quiz Objects Brightspace Data Set returns information about the settings and properties of a quiz.
Note: As the July 2023/20.23.7 release, the Grace Period and Allow the student to continue working, but automatically score the attempt as zero timing options are no longer available within the Quizzes tool. This affects the data within this data set in the following ways:
- If a quiz object that was created or edited after this release has the TimeLimitExceededBehavior value of 1, that should be interpreted as a 2.
- All quiz objects created or edited after this release have the TimeLimitGracePeriod value of NULL.
- Quiz objects created before the July 2023/20.23.7 release continue to return their same values for both TimeLimitExceededBehavior and TimeLimitGracePeriod fields.
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 |
Category assigned to the quiz.
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 |
|
| 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 |
|
| 1.7 |
GradeObjectId |
Grade object identifier associated with the quiz.
Field can be null.
|
bigint |
8 |
|
| 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 |
Is a password required to access this quiz.
Field can be null.
|
bit |
1 |
|
| 1.7 |
IPRestricted |
Is this quiz available to only certain IP Addresses.
Field can be null.
|
bit |
1 |
|
| 1.7 |
TimeLimit |
Does this quiz have a time limit. |
int |
4 |
|
| 1.7 |
TimeLimitEnforced |
Is the time limit assigned to this quiz enforced. |
bit |
1 |
|
| 8.6 - Changed description |
TimeLimitExceededBehavior
|
Are learners taking this quiz permitted to exceed the time limit.
Possible values:
-
0 = Allow the student to continue working
-
1 = Allow the student to continue working, but automatically score the attempt as zero after an extended deadline
-
2 = Prevent the student from making further changes
Field can be null.
|
int |
4 |
|
| 1.7 |
TimeLimitGracePeriod |
Is there a grace period at the end of the time limit on this quiz.
Field can be null.
|
int |
4 |
|
| 1.7 |
AttemptsAllowed |
Number of times learners are permitted to attempt the quiz.
Field can be null.
|
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.
Field can be null.
|
nvarchar |
1000 |
|
| 1.7 |
DisablePagerAccess |
Indicates that learners cannot access the pager functionality |
bit |
1 |
|
| 1.7 |
DisplayInCalendar |
The quiz is not turned on in the calendar.
Field can be null.
|
bit |
1 |
|
| 1.7 |
ShowClock |
Indicates whether there is a quiz clock visible while learners are taking the quiz. |
bit |
1 |
|
| 2.2 |
IsAttemptRldb |
Indicates that a quiz was attempted using Respondus. |
bit |
1 |
|
| 2.2 |
IsSubviewRldb |
Indicates that a portion of the quiz was attempted using Respondus |
bit |
1 |
|
| 2.2 |
SortOrder |
Display sort order used for the content objects |
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 from the New Quiz Experience.
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 |
|
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. 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
|
|
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
|
|---|
| 3.4 |
CollectionId |
Unique question collection identifier |
bigint |
8 |
FK |
| 3.4 |
SectionId |
Unique section identifier. |
bigint |
8 |
PK |
| 5.7 / 6.0 - Changed Column Size |
Name |
Field can be null. |
nvarchar |
256 |
|
| 3.4 |
NameIsDisplayed |
Indicates if the section name is hidden or shown. |
bit |
1 |
|
| 3.4 |
IsQuestionPool |
Indicates if the question pool is a random section. |
bit |
1 |
|
| 3.4 |
SectionText |
Field can be null. |
nvarchar |
1000 |
|
| 3.4 |
SectionTextIsHTML |
Indicates if the section text is HTML or plain text. |
bit |
1 |
|
| 3.4 |
IsSectionTextHidden |
Indicates if the section text is hidden or shown. Values are 0 for hidden, and 1 for shown.
Field can be null.
|
bit |
1 |
|
|
4.8 / 5.2 - Updated column size
|
QuestionPoints |
Field can be null. |
decimal |
19, 9 |
|
| 3.4 |
NumQuestions |
Indicates the number of questions in the quiz section. |
int |
4 |
|
| 3.4 |
NumChoices |
Indicates the number of choices in the question pool from which the quiz can be created. |
int |
4 |
|
| 3.4 |
Shuffle |
Indicates that the quiz questions in the pool are shuffled. |
bit |
1 |
|
| 3.4 |
CreationDate |
Date the quiz was created (UTC). |
datetime2 |
8 |
|
| 6.7 - Updated key |
CreatedBy |
Id of the user who created the quiz.
Field can be null.
|
bigint |
8 |
FK |
| 3.4 |
LastModified |
Date when the quiz was last modified (UTC). |
datetime2 |
8 |
|
| 6.7 - Updated key |
LastModifiedBy |
Id of the user who last modified the quiz.
Field can be null.
|
bigint |
8 |
FK |
| 3.4 |
IsDeleted |
Indicates that the quiz question is deleted.
Field can be null.
|
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
|
|
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 data set and differential is limited to 3 years of data (all of the previous two calendar years and the current calendar year to date).
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
|
Option the user chose for the question.
Field can be null.
|
bigint
|
8
|
|
| 1.0 |
UserAnswer
|
User answer.
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 |
|
Quiz User Answers
The Quiz User Answers Brightspace Data Set returns data to describe the option a user chose or the answer a user provided for a question. Rows in the data set are filtered out if they are associated with deleted quiz questions. The Quiz User Answers data set is limited to 3 years of data (all of the previous two calendar years and the current calendar year to date).
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
|
| 1.0 |
TimeCompleted
|
Date/time a section or question pool (random section) was completed (UTC).
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 |