Canvas Data Release Notes (2018-12-11)

Document created by Emily Allen Employee on Nov 26, 2018Last modified by Emily Allen Employee on Nov 28, 2018
Version 3Show Document
  • View in full screen mode

In this Canvas Data release, the schema version has been updated to 4.1.0. Additionally, new tables with outcomes data have been added.

 

 

 

  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.

NameTypeDescription
idbigintUnique surrogate id for the learning outcome.
canvas_idbigintPrimary key to the learning_outcomes table in Canvas.
account_idbigintForeign key to the account associated with this outcome.
course_idbigintForeign key to the course associated with this outcome, if this outcome was created at the course level.
short_descriptionTitle of the outcome.
descriptiontextDescription of the outcome.
workflow_stateWorkflow status of the learning outcome. Possible values are ‘active’ and ‘deleted’. Defaults to ‘active’.
created_attimestampTime when the outcome was created.
updated_attimestampTime when the outcome was last updated.
display_nameOptional friendly name for reporting.
calculation_methodtextThe method used to calculate student score. Possible values are “decaying_average”, “highest”, “latest”, and “n_mastery”.
calculation_intintDefines 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.

NameTypeDescription
learning_outcome_idbigintForeign key to the learning outcome dimension.
account_idbigintForeign key to the account associated with this outcome, if this outcome was created at the account level.
course_idbigintForeign key to the course associated with this outcome, if this outcome was created at the course level.
enrollment_term_idbigintForeign key to the enrollment term of the course associated with this outcome, if this outcome was created at the course level.
mastery_pointsdoubleMinimum number of points required in order for the student to have achieved mastery.
points_possibledoubleMaximum number of points achievable for this outcome.

 

learning_outcome_rubric_criterion_dim

Contains dimensions for the criterion of a given outcome.

NameTypeDescription
idbigintUnique surrogate id for the rubric criterion.
learning_outcome_idbigintForeign key to the learning outcome dimension.
descriptiontextDescription of the rubric criterion.

 

learning_outcome_rubric_criterion_fact

Contains measures for the criterion of a given outcome.

NameTypeDescription
learning_outcome_rubric_criterion_idbigintForeign key to the learning outcome rubric criterion dimension.
learning_outcome_idbigintForeign key to the learning outcome dimension.
account_idbigintForeign key to the account associated with the criterion’s outcome, if the outcome was created at the account level.
course_idbigintForeign key to the course associated with the criterion’s outcome, if the criterion was created at the course level.
enrollment_term_idbigintForeign key to the enrollment term of the course associated with this outcome, if this outcome was created at the course level.
pointsdouble precisionPoints 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.

NameTypeDescription
idbigintUnique surrogate id for the learning outcome group.
canvas_idbigintPrimary key for this record in the Canvas learning_outcome_groups table.
account_idbigintForeign key to the account associated with this outcome group, if this account group was created at the account level.
course_idbigintForeign key to the course associated with this outcome group, if this outcome group was created at the course level.
titleTitle of the learning outcome group.
parent_group_idbigintID associated with the parent of this group. Refers to a learning_outcome_group record.
root_group_idbigintID associated with the root group in the group hierarchy. Refers to a learning_outcome_group record.
workflow_stateWorkflow status of the learning outcome. Possible values are ‘active’ and ‘deleted’. Defaults to ‘active’.
descriptiontextDescription of the learning outcome group.
created_attimestampTime when the group was created.
updated_attimestampTime when the group was last updated.
vendor_guidA 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.

NameTypeDescription
learning_outcome_group_idbigintForeign key to the learning outcome group dimension.
account_idbigintForeign key to the account associated with this outcome group, if this outcome group was created at the account level.
course_idbigintForeign key to the course associated with this outcome group, if this outcome group was created at the course level.
enrollment_term_idbigintForeign 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_idbigintID associated with the parent of this group. Refers to a learning_outcome_group record.
root_group_idbigintID 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.

NameTypeDescription
learning_outcome_idbigintForeign key to the learning outcome dimension.
learning_outcome_group_idbigintForeign key to the learning outcome group dimension.
account_idbigintForeign key to the account associated with this outcome group, if this outcome group was created at the account level.
course_idbigintForeign key to the course associated with this outcome group, if this outcome group was created at the course level.
enrollment_term_idbigintForeign 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.

NameTypeDescription
idbigintUnique surrogate key for the learning outcome result.
canvas_idbigintPrimary key for this record in the Canvas learning_outcome_results table.
account_idbigintForeign key to the account associated with this outcome result, if this outcome result was created at the account level.
course_idbigintForeign key to the course associated with this outcome result, if this outcome result was created at the course level.
assignment_idbigintForeign key to the assignment associated with this outcome result, if this result was associated with an assignment.
quiz_idbigintForeign key to the quiz associated with this outcome result, if this result was associated with a quiz.
learning_outcome_idbigintForeign key to the learning outcome this result is associated with.
user_idbigintID of the student who made the submission. Foreign key to the user dimension table.
created_attimestampTime when the result was created.
updated_attimestampTime when the result was last updated.
assessed_attimestampTime when the result was assessed.
submitted_attimestampTime when the submission was submitted.
hide_pointsbooleanBoolean 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.
hiddenbooleanBoolean 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.

NameTypeDescription
learning_outcome_result_idbigintForeign key to the learning outcome result dimension.
account_idbigintForeign key to the account associated with this outcome result, if this outcome result was created at the account level.
course_idbigintForeign key to the course associated with this outcome result, if this outcome result was created at the course level.
enrollment_term_idbigintForeign key to the enrollment term of the course associated with this outcome group, if this outcome group was created at the course level.
assignment_idbigintForeign key to the assignment associated with this outcome result, if this result was associated with an assignment.
quiz_idbigintForeign key to the quiz associated with this outcome result, if this result was associated with a quiz.
learning_outcome_idbigintForeign key to the learning outcome this result is associated with.
user_idbigintID of the student who made the submission. Foreign key to the user dimension table.
masterybooleanBoolean indicating whether user achieved mastery.
scoredouble precisionThe student's score.
attemptsintThe total number of attempts, or submissions.
possibledouble precisionTotal number of points possible.
original_scoredouble precisionScore on the first attempt.
original_possibledouble precisionPossible points on the first attempt.
original_masterybooleanBoolean indicating whether user achieved mastery.
percentdouble precisionPercent 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.

NameTypeDescription
idbigintUnique surrogate key for the question result.
learning_outcome_result_idbigintForeign key to the learning outcome result.
learning_outcome_idbigintForeign key to the learning outcome this record is associated with.
assessment_question_idbigintForeign key to the assessment question this record is associated with (assessment_questions to be included in a future release).
titletextTitle of the question result.
created_attimestampTime when question was created.
updated_attimestampTime when question was updated.
assessed_attimestampTime when answer was assessed.
submitted_attimestampTime when answer was submitted.

 

learning_outcome_question_result_fact

Facts for the results of answered questions which have been associated with a learning outcome.

NameTypeDescription
learning_outcome_question_result_idbigintForeign key to the learning outcome question result.
learning_outcome_result_idbigintForeign key to the learning outcome result.
learning_outcome_idbigintForeign key to the learning outcome this record is associated with.
assessment_question_idbigintForeign key to the assessment question this record is associated with (assessment_questions to be included in a future release).
user_idbigintForeign key to the user dim. Refers to the user associated with this result.
account_idbigintForeign key to the account associated with the outcome which this result belongs to, if the outcome was created at the account level.
course_idbigintForeign key to the course associated with the outcome which this result belongs to, if the outcome was created at the course level.
enrollment_term_idbigintForeign 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_idbigintForeign key to the assignment associated with the outcome result, if the result was associated with an assignment.
quiz_idbigintForeign key to the quiz associated with the outcome result, if the result was associated with a quiz.
masterybooleanBoolean indicating whether user achieved mastery for this question.
scoredouble precisionThe student's score on the question.
attemptsintThe total number of attempts, or submissions.
possibledouble precisionTotal number of points possible.
original_scoredouble precisionScore on the first attempt.
original_possibledouble precisionPossible points on the first attempt.
original_masterybooleanBoolean indicating whether user achieved mastery.
percentdouble precisionScore's percent of maximum points possible for an outcome, scaled to reflect any custom mastery levels that differ from the learning outcome.
4 people found this helpful

Attachments

    Outcomes