SAH-LMS-CB-QuizQuestionAnswer-View Quick Start Guides

Contains

Only quiz related fields.

Folder	Fields	Note
LMS Course	Course ID Course Name Course Code Course SIS Source ID Course Workflow State
LMS Assignment	Assignment ID
LMS Dates
	Quiz Due At	Day/Time when the quiz is due.
	Quiz Updated At	Timestamp of the last time the quiz was updated
	Quiz Unlock At	Timestamp for when the quiz is unlocked or visible to the user
	Quiz Lock At	Timestamp for when the quiz is locked
	Quiz Hide Correct Answers At Quiz Show Correct Answers At	Day/Time when the correct answers would be shown / hidden.
	Quiz Published At
	Quiz Deleted At
	Course Created At	Timestamp when the course object was created in Canvas
	Course Start At Course Conclude At	Timestamp for when the course starts/finishes
	Course Enrollment Term Date End Course Enrollment Term Date Start	Term end / start date
LMS Flags	Assignment All Day
LMS Measure


LMS Flag Measure
LMS Assignment



LMS UserLMS User
LMS UserLMS User
LMS Quiz	Quiz ID Quiz Name Quiz Description
	Quiz Course ID	Foreign key to the course the quiz belongs to.
	Assessment Question ID	Foreign key to the assessment question this record is associated with
	Quiz Answer Margin	(Used in 'numerical_question' with answer type 'exact_answer', set to 'NULL' otherwise) Margin of error allowed for a student's answer.
	Quiz Anonymous Submissions	Dictates whether students are allowed to submit the quiz anonymously. Possible values are 'allow_anonymous_submissions' and 'disallow_anonymous_submissions'. Defaults to 'disallow_anonymous_submissions'.
	Quiz Question Answer ID	Unique surrogate key for the quiz question answer. As with all surrogate keys in Canvas Data, there is no guarantee of stability. That said, this key is particularly unstable and will likely change from dump to dump even if there are no data change.
	Quiz Answer Blank ID	(Used in 'fill_in_multiple_blanks_question' and 'multiple_dropdowns_question', set to 'NULL' otherwise) Refers to the ID of the blank(s) in the question text.
	Quiz Quiz Type	Type of quiz. Possible values are: assignment graded_survey practice_quiz survey Defaults to 'NULL'
	Quiz Answer Margin	(Used in 'numerical_question' with answer type 'exact_answer', set to 'NULL' otherwise) Margin of error allowed for a student's answer.
	Quiz Browser Lockdown	Dictates whether the browser has locked-down when the quiz is being taken. Possible values are 'required' and 'not_required'. Defaults to 'not_required
	Quiz Browser Lockdown Monitor	Dictates whether a browser lockdown monitor is required. Possible values are 'required' and 'not_required'. Defaults to 'not_required'.
	Quiz Browser Lockdown For Displaying Results	Dictates whether the browser has to be locked-down to display the results. Is valid only if 'hide_results' is set to 'never' or 'until_after_last_attempt' (for the results to be displayed after the last attempt). Possible values are 'required' and 'not_required'. Defaults to 'not_required'.
	Quiz Go Back To Previous Question	Policy on going back to the previous question. Is valid only if 'display_questions' is set to 'one_at_a_time'. Possible values are 'allow_going_back' and 'disallow_going_back'. Defaults to 'allow_going_back'. Equivalent Canvas API field -> 'cant_go_back'.
	Quiz Matching Answer Incorrect Matches	(Used in 'matching_question', set to 'NULL' in others) List of distractors (incorrect answers), delimited by new lines, that will be seeded with all the 'answer_match_right' values.
	Quiz Question Incorrect Comments	Comments to be displayed if the student answers the question incorrectly.
	Quiz Question Regrade Option	Denotes if regrading is available for the question. Possible values are 'available' and 'unavailable' for question types 'multiple_answers_question', 'multiple_choice_question', 'true_false_question' and 'NULL' for others. Defaults to 'available' for the allowed question types and 'NULL' for the rest.
	Answer Weight	Integer value to determine correctness of the answer. Incorrect answers should be 0, correct answers should be non-negative.
	Quiz Show Correct Answers	Dictates whether correct answers are shown when are results are viewed. It's valid only if 'show_results' is set to 'always'. Possible values are 'always', 'never', 'only_once_after_last_attempt' and 'always_after_last_attempt' (Last two are only valid if 'dw_quiz_fact.allowed_attempts > 1') which have a behavior similar to 'show_results'. Defaults to 'always'. Equivalent Canvas API field -> 'show_correct_answers' combined with 'show_correct_answers_last_attempt'.
	Quiz Question Correct Comments	Comments to be displayed if the student answers the question correctly.
	Quiz Show Results	Dictates whether or not quiz results are shown to students. If set to 'always', students can see their results after any attempt and if set to 'never', students can never see their results. If 'dw_quiz_fact.allowed_attempts > 1' then when set to 'always_after_last_attempt', students can only see their results always, but only after their last attempt. Similarly, if set to 'only_once_after_last_attempt', then students can see their results only after their last attempt, that too only once. Possible values are 'always', 'never', 'always_after_last_attempt' and 'only_once_after_last_attempt'. Defaults to 'always'. Equivalent Canvas API field -> 'hide_results' combined with 'one_time_results'.
	Quiz Text After Answers	(Used in 'short_answer_question', also known as 'fill_in_the_blank'. Set to 'NULL' in others) Text following the missing word.
	Quiz Question Neutral Comments	Comments to be displayed regardless of how the student answers the question
	Quiz Scoring Policy	Scoring policy for a quiz that students can take multiple times. Is required and only valid if allowed_attempts > 1. Possible values are 'keep_highest', 'keep_latest' and 'keep_average'. Defaults to 'keep_highest'.
	Quiz Display Questions	Values: multiple_at_a_time one_at_a_time
	Quiz Submission Has Seen Results	Denotes whether the student has viewed their results to the quiz.
	Quiz State During Submission	There can be two types of quiz states during submission, 1. Quiz submission took place after the quiz was manually unlocked after being locked (but only for a particular student such that (s)he can take the quiz even if it's locked for everyone else). 2. Quiz submission was on-time (that is, when the quiz was never locked). So the two possible values are 'manually_unlocked' and 'never_locked'. Defaults to 'never_locked'.