Brightspace Data Sets for Quizzes

Brightspace Data Sets for Quizzes include:

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:

Entity Relationship Diagram for Quizzes

 

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. 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.

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

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

 

4.8 / 5.2 - Updated column size

Score

Score for the attempt. Field can be null.

Numeric

19, 9

 

1.0

IsGraded

If a quiz has been graded

Boolean

1

 

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. Field can be null.

nvarchar

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

 

4.8 / 5.2 - Updated column size

Weight

Weight associated with the answer

Numeric

19, 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

 

4.8 / 5.2 - Updated column size

Weight

Weight associated with answer. Field can be null.

Numeric

19, 9

 

1.0

Answer

Answer text. Field can be null.

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.

nvarchar

512

 

1.1 - Added

ObjectId Unique identifier of the answer BigInteger 8 PK

 

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

PK

1.0 - update to key

QuestionId

Unique question identifier. Field can be null.

BigInteger

8

PK

1.0 - update to key

QuestionVersionId

Unique question version identifier. Field can be null.

BigInteger

8

PK

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

 

4.8 / 5.2 - Updated column size

Score

Score the user received for the answer. Field can be null.

Numeric

19, 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. Field can be null. BigInteger 8 FK
4.10 / 5.4 ObjectId Unique global identifier of the question object. BigInteger 8 FK

 

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. Field can be null.

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. 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  

4.8 / 5.2 - Updated column size

QuizScoreDenominator Denominator for the quiz score Numeric 19, 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  

4.8 / 5.2 - Updated column size

QuestionPoints Can be Null Numeric 19, 9  
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. 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. Field can be null.

BigInteger

8