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.

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.

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

Related Data Sets

As the Entity Relationship Diagram illustrates, the Brightspace Data Sets for Quizzes have relationships with other data sets that are not described on this page. These related data sets include:

 

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

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

 

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

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 complete 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  
5.11 / 6.4 IsRetakeIncorrectOnly Indicates if the quiz allows Retake Incorrect Only. 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  

 

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

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

 

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

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

 

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

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  

 

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

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

 

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

TimeLimitExceededBehavior

 

Are learners taking this quiz permitted to exceed the time limit.

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  
1.7 DisableRightClick Indicates that the right mouse click is turned off. 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
5.11 / 6.4 IsRetakeIncorrectOnly Indicates if this attempt only includes questions that were incorrect on a previous attempt. bit 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 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