/
SAH-LMS-SubmissionEvents-View Quick Start Guides

SAH-LMS-SubmissionEvents-View Quick Start Guides

General Information About SAH LMS:

  • All SAH Students are included, those who have not logged into the LMS will have null data in the LMS fields

  • CB means Canvas Batch and indicates data was aggregated by Canvas prior to being loaded into the SAH

  • Technical descriptions for the fields in Canvas LMS can be found here:  https://portal.inshosteddata.com/docs

Key Fields:

  • Role aka (User role, agent role, LMS role)

For more information about the fields in each view, please refer to this document: https://portal.inshosteddata.com/docs

Contains

  • SAH-Demographics-View: (Current Term & First Term)

  • SAH-StudentStatsPerTerm-View: (Per Term)

 

Folder

Fields

Note

Folder

Fields

Note

LMS Course

  • Course ID

  • Course Name

  • Course Code

 

LMS Assignment

  • Assignment ID

  • Assignment Title

 

Assignment Grading Type

Possible values:

  • gpa_scale

  • letter_grade

  • not_graded

  • pass_fail

  • percent

  • points

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.

  • Assignment Updated At

  • Quiz Updated At

  • Submission Updated At

  • Quiz Submission Updated At

Timestamp of the last time the assignment/quiz/submission was updated

  • Assignment Unlock At

  • Quiz Unlock At

Timestamp for when the assignment/quiz is unlocked or visible to the user

  • Assignment lock At

  • Quiz Lock At

Timestamp for when the assignment/quiz is locked

  • Quiz Submission Started At

  • Quiz Submission Finished At

Time at which the student submitted/started the quiz submission.

 

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 system

  • 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

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 Type

ContentDeveloper

LMS UserLMS User

User role

Give the possible roles for an enrolled user:

  • Content developer

  • Department-Admin

  • Faculty

  • Grader

  • Group Membership

  • Instructor

  • Learner

  • User

  • Observer

  • TA & Proctor

  • Teaching Assistant

User Unique Name

Active Directory User ID

LMS Quiz

 

 

  • Quiz ID

  • Quiz Name

  • Quiz Description

 

Quiz Type

assignment, graded_survey 

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'.

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