Canvas Data Release Notes (2018-12-11)
In this Canvas Data release, the schema version has been updated to 4.1.0. Additionally, new tables with outcomes data have been added.
- AddedTables
- learning_outcome_dim
- learning_outcome_fact
- learning_outcome_rubric_criterion_dim
- learning_outcome_rubric_criterion_fact
- learning_outcome_group_dim
- learning_outcome_group_fact
- learning_outcome_group_association_fact
- learning_outcome_result_dim
- learning_outcome_result_fact
- learning_outcome_question_result_dim
- learning_outcome_question_result_fact
Added Tables |
learning_outcome_dim
Learning outcomes are measurable statements that express student knowledge or student skill. This table contains the dimensions for learning outcomes.
Name | Type | Description |
---|---|---|
id | bigint | Unique surrogate id for the learning outcome. |
canvas_id | bigint | Primary key to the learning_outcomes table in Canvas. |
account_id | bigint | Foreign key to the account associated with this outcome. |
course_id | bigint | Foreign key to the course associated with this outcome, if this outcome was created at the course level. |
short_description | Title of the outcome. | |
description | text | Description of the outcome. |
workflow_state | Workflow status of the learning outcome. Possible values are ‘active’ and ‘deleted’. Defaults to ‘active’. | |
created_at | timestamp | Time when the outcome was created. |
updated_at | timestamp | Time when the outcome was last updated. |
display_name | Optional friendly name for reporting. | |
calculation_method | text | The method used to calculate student score. Possible values are “decaying_average”, “highest”, “latest”, and “n_mastery”. |
calculation_int | int | Defines the variable used by the calculation_method. Included only if calculation_method uses it. |
learning_outcome_fact
Learning outcomes are measurable statements that express student knowledge or a student skill. This table contains measures for learning outcomes.
Name | Type | Description |
---|---|---|
learning_outcome_id | bigint | Foreign key to the learning outcome dimension. |
account_id | bigint | Foreign key to the account associated with this outcome, if this outcome was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome, if this outcome was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with this outcome, if this outcome was created at the course level. |
mastery_points | double | Minimum number of points required in order for the student to have achieved mastery. |
points_possible | double | Maximum number of points achievable for this outcome. |
learning_outcome_rubric_criterion_dim
Contains dimensions for the criterion of a given outcome.
Name | Type | Description |
---|---|---|
id | bigint | Unique surrogate id for the rubric criterion. |
learning_outcome_id | bigint | Foreign key to the learning outcome dimension. |
description | text | Description of the rubric criterion. |
learning_outcome_rubric_criterion_fact
Contains measures for the criterion of a given outcome.
Name | Type | Description |
---|---|---|
learning_outcome_rubric_criterion_id | bigint | Foreign key to the learning outcome rubric criterion dimension. |
learning_outcome_id | bigint | Foreign key to the learning outcome dimension. |
account_id | bigint | Foreign key to the account associated with the criterion’s outcome, if the outcome was created at the account level. |
course_id | bigint | Foreign key to the course associated with the criterion’s outcome, if the criterion was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with this outcome, if this outcome was created at the course level. |
points | double precision | Points associated with the rubric criterion. |
learning_outcome_group_dim
Learning outcome groups organize outcomes hierarchically within a context, such as an account, course or the global context. This table contains dimensions for learning outcome groups.
Name | Type | Description |
---|---|---|
id | bigint | Unique surrogate id for the learning outcome group. |
canvas_id | bigint | Primary key for this record in the Canvas learning_outcome_groups table. |
account_id | bigint | Foreign key to the account associated with this outcome group, if this account group was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome group, if this outcome group was created at the course level. |
title | Title of the learning outcome group. | |
parent_group_id | bigint | ID associated with the parent of this group. Refers to a learning_outcome_group record. |
root_group_id | bigint | ID associated with the root group in the group hierarchy. Refers to a learning_outcome_group record. |
workflow_state | Workflow status of the learning outcome. Possible values are ‘active’ and ‘deleted’. Defaults to ‘active’. | |
description | text | Description of the learning outcome group. |
created_at | timestamp | Time when the group was created. |
updated_at | timestamp | Time when the group was last updated. |
vendor_guid | A custom GUID for the learning standard. |
learning_outcome_group_fact
Learning outcome groups organize outcomes hierarchically within a context, such as an account, course or the global context. This table contains measures for learning outcome groups.
Name | Type | Description |
---|---|---|
learning_outcome_group_id | bigint | Foreign key to the learning outcome group dimension. |
account_id | bigint | Foreign key to the account associated with this outcome group, if this outcome group was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome group, if this outcome group was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with this outcome group, if this outcome group was created at the course level. |
parent_group_id | bigint | ID associated with the parent of this group. Refers to a learning_outcome_group record. |
root_group_id | bigint | ID associated with the root group in the group hierarchy. Refers to a learning_outcome_group record. |
learning_outcome_group_association_fact
An association table to represent the many-to-many relationship between learning outcomes and learning outcome groups.
Name | Type | Description |
---|---|---|
learning_outcome_id | bigint | Foreign key to the learning outcome dimension. |
learning_outcome_group_id | bigint | Foreign key to the learning outcome group dimension. |
account_id | bigint | Foreign key to the account associated with this outcome group, if this outcome group was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome group, if this outcome group was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with this outcome group, if this outcome group was created at the course level. |
learning_outcome_result_dim
Learning outcome results are a student’s mastery score on a given outcome. This table contains dimensions for learning outcome results.
Name | Type | Description |
---|---|---|
id | bigint | Unique surrogate key for the learning outcome result. |
canvas_id | bigint | Primary key for this record in the Canvas learning_outcome_results table. |
account_id | bigint | Foreign key to the account associated with this outcome result, if this outcome result was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome result, if this outcome result was created at the course level. |
assignment_id | bigint | Foreign key to the assignment associated with this outcome result, if this result was associated with an assignment. |
quiz_id | bigint | Foreign key to the quiz associated with this outcome result, if this result was associated with a quiz. |
learning_outcome_id | bigint | Foreign key to the learning outcome this result is associated with. |
user_id | bigint | ID of the student who made the submission. Foreign key to the user dimension table. |
created_at | timestamp | Time when the result was created. |
updated_at | timestamp | Time when the result was last updated. |
assessed_at | timestamp | Time when the result was assessed. |
submitted_at | timestamp | Time when the submission was submitted. |
hide_points | boolean | Boolean indicating if outcome result points should be hidden in the Learning Mastery Gradebook and reports. If enabled, replace points with the description of the highest scoring outcome criterion rating. |
hidden | boolean | Boolean indicating if outcome result should be hidden from the Learning Mastery Gradebook and reports. |
learning_outcome_result_fact
Learning outcome results are a student’s mastery score on a given outcome. This table contains measures for learning outcome results.
Name | Type | Description |
---|---|---|
learning_outcome_result_id | bigint | Foreign key to the learning outcome result dimension. |
account_id | bigint | Foreign key to the account associated with this outcome result, if this outcome result was created at the account level. |
course_id | bigint | Foreign key to the course associated with this outcome result, if this outcome result was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with this outcome group, if this outcome group was created at the course level. |
assignment_id | bigint | Foreign key to the assignment associated with this outcome result, if this result was associated with an assignment. |
quiz_id | bigint | Foreign key to the quiz associated with this outcome result, if this result was associated with a quiz. |
learning_outcome_id | bigint | Foreign key to the learning outcome this result is associated with. |
user_id | bigint | ID of the student who made the submission. Foreign key to the user dimension table. |
mastery | boolean | Boolean indicating whether user achieved mastery. |
score | double precision | The student's score. |
attempts | int | The total number of attempts, or submissions. |
possible | double precision | Total number of points possible. |
original_score | double precision | Score on the first attempt. |
original_possible | double precision | Possible points on the first attempt. |
original_mastery | boolean | Boolean indicating whether user achieved mastery. |
percent | double precision | Percent of maximum points possible for an outcome, scaled to reflect any custom mastery levels that differ from the learning outcome. |
learning_outcome_question_result_dim
Attributes for the results of answered questions which have been associated with a learning outcome.
Name | Type | Description |
---|---|---|
id | bigint | Unique surrogate key for the question result. |
learning_outcome_result_id | bigint | Foreign key to the learning outcome result. |
learning_outcome_id | bigint | Foreign key to the learning outcome this record is associated with. |
assessment_question_id | bigint | Foreign key to the assessment question this record is associated with (assessment_questions to be included in a future release). |
title | text | Title of the question result. |
created_at | timestamp | Time when question was created. |
updated_at | timestamp | Time when question was updated. |
assessed_at | timestamp | Time when answer was assessed. |
submitted_at | timestamp | Time when answer was submitted. |
learning_outcome_question_result_fact
Facts for the results of answered questions which have been associated with a learning outcome.
Name | Type | Description |
---|---|---|
learning_outcome_question_result_id | bigint | Foreign key to the learning outcome question result. |
learning_outcome_result_id | bigint | Foreign key to the learning outcome result. |
learning_outcome_id | bigint | Foreign key to the learning outcome this record is associated with. |
assessment_question_id | bigint | Foreign key to the assessment question this record is associated with (assessment_questions to be included in a future release). |
user_id | bigint | Foreign key to the user dim. Refers to the user associated with this result. |
account_id | bigint | Foreign key to the account associated with the outcome which this result belongs to, if the outcome was created at the account level. |
course_id | bigint | Foreign key to the course associated with the outcome which this result belongs to, if the outcome was created at the course level. |
enrollment_term_id | bigint | Foreign key to the enrollment term of the course associated with the outcome which this result belongs to, if the outcome was created at the course level. |
assignment_id | bigint | Foreign key to the assignment associated with the outcome result, if the result was associated with an assignment. |
quiz_id | bigint | Foreign key to the quiz associated with the outcome result, if the result was associated with a quiz. |
mastery | boolean | Boolean indicating whether user achieved mastery for this question. |
score | double precision | The student's score on the question. |
attempts | int | The total number of attempts, or submissions. |
possible | double precision | Total number of points possible. |
original_score | double precision | Score on the first attempt. |
original_possible | double precision | Possible points on the first attempt. |
original_mastery | boolean | Boolean indicating whether user achieved mastery. |
percent | double precision | Score's percent of maximum points possible for an outcome, scaled to reflect any custom mastery levels that differ from the learning outcome. |