Brightspace Data Sets for Quizzes
Brightspace Data Sets for Quizzes include:
- Quiz Attempts Log
- Quiz Attempts
- Quiz Question Answer Options
- Quiz Question Answers
- Quiz Questions
- Quiz User Answer Responses
- Quiz User Answers
- Quiz Objects
- Quiz Survey Sections
These data sets have a dependency on Quizzes. 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 Quizzes, click the following thumbnail image:
Brightspace Data Set: Quiz Attempts Log
About
Returns details on the events that occur during a quiz attempt. This data set includes completed quiz attempts and in-progress quiz attempts.
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.1 | LogId | Unique log identifier |
BigInteger |
8 |
PK |
| 3.6/4.1 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
FK |
| 3.6/4.1 |
EventTypeId |
Unique event type identifier |
Integer |
8 |
|
| 3.6/4.1 |
Name |
Name of the event. |
nvarchar |
512 |
|
| 3.6/4.1 | Description | Description of the event. Field can be null. |
nvarchar |
512 |
|
| 3.6/4.1 |
EventTime |
Event occurred time (UTC). |
DateTime |
8 |
|
| 3.6/4.1 | IPAddress | IPAddress at which the event occurred. Field can be null. | varchar | 15 |
|
Brightspace Data Set: Quiz Attempts
About
Returns details for each user quiz attempt for all your org units. This data set includes completed quiz attempts and in-progress quiz attempts.
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 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuizId |
Unique quiz identifier |
BigInteger |
8 |
|
| 1.0 |
UserId |
Unique user identifier |
Integer |
8 |
FK |
| 1.0 |
OrgUnitId |
Unique org unit identifier |
Integer |
8 |
FK |
| 1.0 |
QuizName |
Quiz name |
nvarchar |
512 |
|
| 1.0 |
AttemptNumber |
Attempt number for the quiz |
Integer |
4 |
|
| 1.0 |
TimeStarted |
Quiz attempt start time (UTC). |
DateTime |
8 |
|
| 1.0 |
TimeCompleted |
Quiz attempt complete time (UTC). Field can be null. |
DateTime |
8 |
|
| 1.0 |
Score |
Score for the attempt. Field can be null. |
Numeric |
4 |
|
| 1.0 |
PossibleScore |
Total possible score for the attempt |
Numeric |
9 |
|
| 1.0 |
IsGraded |
If a quiz has been graded |
Boolean |
1 |
|
| 1.0 |
GradeItemId |
Unique grade identifier. Field can be null. |
BigInteger |
8 |
FK |
| 1.10 | OldAttemptNumber | Number of previous times a learner has attempted the quiz. Field can be null | Integer | 4 | |
| 1.10 | IsDeleted | Indicates that the quiz attempt is deleted | Boolean | 1 |
Brightspace Data Set: Quiz Question Answer Options
About
Returns possible options for a given quiz answer. For example, in a multi select question type, it displays the options the users can choose from. Rows in the data set are filtered out if they are associated with deleted quiz attempts.
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 |
AnswerId |
Unique answer Identifier |
BigInteger |
8 |
PK |
| 1.0 |
AnswerText |
User answer |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
Weight |
Weight associated with the answer |
Numeric |
9 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.2 - Added | QuizObjectId | Unique quiz object identifier | BigInteger | 8 | |
| 1.2 - Added | AnswerOptionId | Unique answer option identifier | BigInteger | 8 | PK |
Brightspace Data Set: Quiz Question Answers
About
Returns possible answers for a given quiz question. Rows in the data set are filtered out if they are associated with deleted quiz attempts.
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 |
AnswerId |
Unique answer identifier |
BigInteger |
8 |
PK |
|
1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
|
1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
|
1.0 |
SortOrder |
Order in which the quiz answers are displayed or correct answer order for ordering questions |
Integer |
4 |
|
|
1.0 |
IsCorrect |
Is answer correct. Field can be null. |
Boolean |
1 |
|
|
1.0 |
Weight |
Weight associated with answer. Field can be null. |
Numeric |
9 |
|
|
1.0 |
Answer |
Answer text |
nvarchar |
Unbounded field |
|
|
1.0 |
Comment |
Instructor comment on the answer. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
|
1.0 |
Description |
System description for the type of answer expected. Field can be null. |
nvarchar |
512 |
|
|
1.1 - Added |
ObjectId | Unique identifier of the answer | BigInteger | 8 | PK |
Brightspace Data Set: Quiz Questions
About
Returns a list of all answered quiz questions. Random quiz questions are not fully supported. Random quiz questions appear in this data set in QuestionId and QuestionVersionId as 0, and the Question and Name appear blank. Depending on your use case, you can filter out these rows by QuestionType = "Random Question"
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 |
| 2.5/3.0 - Removed FK |
QuizId |
Unique quiz identifier |
BigInteger |
8 |
|
| 1.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 |
|
| 1.0 |
CreatedDate |
Date the question was created (UTC) |
DateTime |
8 |
|
| 1.0 |
Difficulty |
Difficulty level assigned to the question. Field can be null. |
Integer |
4 |
|
| 1.0 |
IsBonus |
Quiz question is a bonus question. Field can be null. |
Boolean |
1 |
|
| 1.0 |
IsMandatory |
Quiz question is mandatory. Field can be null. |
Boolean |
1 |
|
| 1.0 |
IsAutoGraded |
Quiz question is automatically graded. |
Boolean |
1 |
|
| 1.0 |
SectionName |
Section name. Field can be null. |
nvarchar |
512 |
|
| 1.0 |
LastModified |
Last time the question was modified (UTC). |
DateTime |
8 |
|
| 1.0 |
Points |
Possible points for the question. Field can be null. |
Numeric |
9 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.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 |
| 1.0 |
QuestionType |
Type of question |
nvarchar |
512 |
|
| 1.0 |
Name |
Question name |
nvarchar |
512 |
|
| 1.0 |
Question |
Quiz question |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L Customer Support. |
|
| 1.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. |
|
| 1.0 |
AnswerKey |
Answer key for the question. This only applies to Written Response Questions. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L Customer Support. |
|
| 1.3 | ObjectId | Unique quiz question ID | BigInteger | 8 | PK |
| 2.0 - Added | IsDeleted | Indicates that the quiz question is deleted | Boolean | 1 |
Brightspace Data Set: Quiz User Answer Responses
About
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).
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 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
PK |
| 1.0 |
AttemptNumber |
Attempt number associated with the AttemptId |
Integer |
4 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.0 |
AnswerId |
Unique answer identifier |
BigInteger |
8 |
PK |
| 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. |
Integer |
4 |
|
| 1.0 |
IsCorrect |
Is user response correct |
Boolean |
1 |
|
| 1.0 |
UserSelection |
Option the user chose for the question. Field can be null. |
BigInteger |
8 |
|
| 1.0 |
UserAnswer |
User answer. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L Customer Support. |
|
Brightspace Data Set: Quiz User Answers
About
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).
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
|
Field |
Description |
Type |
Column Size |
Key |
| 1.0 - update to key |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
FK |
| 1.0 - update to key |
QuestionId |
Unique question identifier |
BigInteger |
8 |
FK |
| 1.0 - update to key |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
FK |
| 1.0 |
TimeCompleted |
Date/time a section or question pool (random section) was completed (UTC). Field can be null. |
DateTime |
8 |
|
| 1.0 |
QuestionNumber |
Question number in the quiz. Field can be null. |
Integer |
4 |
|
| 1.0 |
Comment |
Feedback left by instructor. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 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). |
Integer |
4 |
|
| 1.0 |
Score |
Score the user received for the answer. Field can be null. |
Numeric |
9 |
|
| 1.0 |
Page |
Page the question appeared on when the user took the quiz |
Integer |
4 |
|
| 3.6 / 4.1 | SectionId | Unique section identifier. | BigInteger | 8 |
Brightspace Data Set: Quiz Objects
About
The Quiz Object data set returns information about the settings and properties of 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 |
| 1.7 - Initial release | QuizId | Unique quiz identifier | BigInteger | 8 | PK |
| 1.7 | QuizName | Quiz name | nvarchar | 512 | |
| 1.7 | QuizDescription | Description of the Quiz |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. | |
| 1.7 | QuizCategory | Category assigned to the quiz | nvarchar | 256 | |
| 1.7 | IsActive | Indicates if the quiz is active | Boolean | 1 | |
| 1.7 | OrgUnitId | Org unit identifier associated with the quiz object | BigInteger | 8 | PK |
| 1.7 | StartDate | First time the quiz is visible. Field can be null. | DateTime | 8 | |
| 1.7 | EndDate | Last date the quiz is visible. Field can be null. | DateTime | 8 | |
| 1.7 | DueDate | Date the quiz is due (UTC). Field can be null. | DateTime | 8 | |
| 1.7 | CreationDate | Date the quiz was created (UTC). | DateTime | 8 | |
| 1.7 | CreatedBy | Id of the user who created the quiz. Field can be null. | BigInteger | 8 | |
| 1.7 | LastModified | Date when the quiz was last modified (UTC). | DateTime | 8 | |
| 1.7 | LastModifiedBy | Id of the user who last modified the quiz. Field can be null. | BigInteger | 8 | |
| 1.7 | GradeObjectId | Grade object identifier associated with the quiz. Field can be null. | BigInteger | 8 | |
| 1.7 | OverallScoreCalculation | Quiz score calculation method. Types include: Highest Attempt, Lowest Attempt, Average of all attempts, First Attempt, and Last Attempt. | nvarchar | 256 | |
| 1.7 | QuizScoreDenominator | Denominator for the quiz score | Numeric | 9 | |
| 1.7 | HasPassword | Is a password required to access this quiz? | Boolean | 1 | |
| 1.7 | IPRestricted | Is this quiz available to only certain IP Addresses? | Boolean | 1 | |
| 1.7 | TimeLimit | Does this quiz have a time limit? | Integer | 4 | |
| 1.7 | TimeLimitEnforced | Is the time limit assigned to this quiz enforced? | Boolean | 1 | |
| 1.7 |
TimeLimitExceededBehavior
|
Are learners taking this quiz permitted to exceed the time limit? Field can be null. |
Integer | 4 | |
| 1.7 | TimeLimitGracePeriod | Is there a grace period at the end of the time limit on this quiz. Field can be null | Integer | 4 | |
| 1.7 | AttemptsAllowed | Number of times learners are permitted to attempt the quiz. Field can be null. | Integer | 4 | |
| 1.7 | PreventMovingBackwards | Indicates if learners are permitted to move to previous pages in the quiz. | Boolean | 1 | |
| 1.7 | AllowHints | Indicates that there are hints allowed for the quiz | Boolean | 1 | |
| 1.7 | DisableRightClick | Indicates that the right mouse click is turned off | Boolean | 1 | |
| 1.7 | NotificationEmail | Indicates that there is a notification email for this quiz. Field can be null. | nvarchar | 2048 | |
| 1.7 | DisablePagerAccess | Indicates that learners cannot access the pager functionality | Boolean | 1 | |
| 1.7 | DisplayInCalendar | The quiz is not turned on in the calendar | Boolean | 1 | |
| 1.7 | ShowClock | Indicates whether there is a quiz clock visible while learners are taking the quiz. | Boolean | 1 | |
| 2.2 - Added | SortOrder | Display sort order used for the content objects | Integer | 4 | |
| 2.2 - Added | IsAttemptRldb | Indicates that a quiz was attempted using Respondus. | Boolean | 1 | |
| 2.2 - Added | IsSubviewRldb | Indicates that a portion of the quiz was attempted using Respondus | Boolean | 1 |
Brightspace Data Set: Quiz Survey Sections
About
The Quiz Survey Sections data set returns information about all the sections and question pools that have been created in quizzes 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 |
| 3.4 | CollectionId | Unique question collection identifier | BigInteger | 8 | FK |
| 3.4 | SectionId | Unique section identifier. | BigInteger | 8 | PK |
| 3.4 | Name | Can be Null. | Nvarchar | 512 | |
| 3.4 | NameIsDisplayed | Indicates if the section name is hidden or shown. | Boolean | 1 | |
| 3.4 | IsQuestionPool | Indicates if the question pool is a random section. | Boolean | 1 | |
| 3.4 | SectionText | Can be Null | Nvarchar | Truncated to 1000 characters. To change the default value, contact D2L. | |
| 3.4 | SectionTextIsHTML | Indicates if the section text is HTML or plain text. | Boolean | 1 | |
| 3.4 | IsSectionTextHidden | Indicates if the section text is hidden or shown. Values are 0 for hidden, and 1 for shown. | Boolean | 1 | |
| 3.4 | QuestionPoints | Can be Null | Numeric | 10 total number of digits before and after the decimal point (inclusive of the decimal point) | |
| 3.4 | NumQuestions | Indicates the number of questions in the quiz section. | Integer | 4 | |
| 3.4 | NumChoices | Indicates the number of choices in the question pool from which the quiz can be created. | Integer | 4 | |
| 3.4 | Shuffle | Indicates that the quiz questions in the pool are shuffled. | Boolean | 1 | |
| 3.4 | CreationDate | Date the quiz was created (UTC). | DateTime | 8 | |
| 3.4 | CreatedBy | Id of the user who created the quiz. Field can be null. | BigInteger | 8 | |
| 3.4 | LastModified | Date when the quiz was last modified (UTC). | DateTime | 8 | |
| 3.4 | LastModifiedBy | Id of the user who last modified the quiz. Field can be null. | BigInteger | 8 | |
| 3.4 | IsDeleted | Indicates that the quiz question is deleted | Boolean | 1 | |
| 4.0/3.6 | Version | Indicates the version of the question. This column supports the Question Pools information in the Assessment Quality Dashboard |
BigInteger |
8 |