Contains
- Only quiz related fields.
...
| Folder | Fields | Note | ||||
|---|---|---|---|---|---|---|
| LMS Course |
| |||||
| LMS Assignment | Assignment ID | |||||
| LMS Dates | ||||||
Quiz Submission Due At | Time at which the quiz submission will be overdue, and will be flagged as a late submission. | Quiz Due At | Day/Time when the quiz is due. | Event Date | ||
Assignment Due At | Timestamp for when the assignment is due | |||||
| Assignment All Day Date | The date version of the Assignment due date if the "Assignment All Day" flag is true. | |||||
| Submission Graded At | Timestamp of when the submission was graded. | |||||
Quiz SubmissionUpdated At | Timestamp of the last time the assignment/ quiz /submission was updated | |||||
Quiz Unlock At | Timestamp for when the assignment/ quiz is unlocked or visible to the user | |||||
Quiz Lock At | Timestamp for when the assignment/ quiz is locked | |||||
Time at which the student submitted/started the quiz submission.
| Day/Time when the correct answers would be shown / hidden. | |||||
| Assignment Created At | Timestamp of the first time the assignment was entered into the system | |||||
| User Created At | Timestamp when the user was created in the Canvas systemQuiz Published At | |||||
| Quiz Deleted At | ||||||
Course Created At | Timestamp when the course object was created in Canvas | |||||
| Timestamp for when the course starts/finishes | |||||
| Term end / start date | |||||
| LMS Flags | Assignment All Day | |||||
| LMS Measure | Submission Score | Numeric grade given to the submission | ||||
| Published Submission Score | Valid only for a graded submission. It reflects the numerical value of the actual score. Referring to our previous example for 'submission_dim.published_grade', let's take two submissions, one for an assignment with a scoring method of 'points' and the other for an assignment with a scoring method of 'letter grade'. If the published grade is '4' out of '5' and 'B' for them, respectively, then they should both have a score of '4' out of '5'. And their 'published_score' values will be identical, '4.0'. Defaults to 'NULL'. | |||||
| Submission Comments Count | Reflects the total number of comments on the submission by anyone/everyone, excluding comments that are flagged as 'hidden'. | |||||
| LMS Flag Measure | Submission What If Score | Valid only if the student ever entered a 'What If' score for an assignment in the Canvas UI. Only the most recent score entered by the student is stored here. Any time a new score is entered, the existing one is overwritten. Defaults to 'NULL'. | ||||
| LMS Assignment | Assignment Title | Title of the assignment | ||||
| Assignment ID | Unique surrogate ID for the assignment. | |||||
| Assignment Course ID | Foreign key to the course associated with this assignment | |||||
| Assignment | Grading TypeContentDeveloper | |||||
| LMS UserLMS User | User role | Give the possible roles for an enrolled user:
| ||||
| User Unique Name | Active Directory User ID | |||||
| LMS Quiz |
| |||||
| 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:
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:
| |||||
| 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'. | LMS Grades | Grade State | Denotes the current state of the grade. Possible values are 'auto_graded', 'human_graded' and 'not_graded'. | Grader Unique Name | Active Directory User ID of the grader |