Student Course Metrics
The mart_student_activity_score.student_course_metrics mart aggregates data about a student’s performance and activities in a course on a weekly basis.
BQ Prod Dataset Locations
mart_student_activity_score
Interactive Mart Dependency Diagram
The following visualization shows the construction of this data mart defined in the UDP marts repository. More information on the repository and diagram can be found on this marts page.
Schema
mart/student_activity_score/student_course_metrics
Field name | Type | Description |
---|---|---|
university_id | STRING | The SIS ID of the student. |
global_user_id | INTEGER | The UDP ID of the student. |
canvas_user_id | STRING | The Canvas ID of the student. |
term_name | STRING | The academic term the student is enrolled in, i.e. Fall 2020. |
session_name | STRING | The academic session the student is enrolled in. |
week_number | INTEGER | The week of the academic session, term, or course. |
campus_name | STRING | The campus of the student for the given academic term. |
academic_program | STRING | The academic program the student is enrolled in for the given academic term. |
course_code | STRING | The SIS ID of the course offering. |
course_global_id | INTEGER | The UDP ID of the course offering. |
course_canvas_id | STRING | The Canvas ID of the course offering. |
navigation_time | FLOAT | The amount of time the student spent in Canvas for the given week in the course. |
num_sessions | INTEGER | The number of Canvas sessions of the student for the given week in the course. |
assignments_due | INTEGER | The number of assignments due in the course for the given week. |
submissions | INTEGER | The number of assignments submitted by the student for the given week in the course. |
Assignments Due
The number of assignments due in a course offering for a given week is defined in the mart_helper.context__student_activity_score__assignments table. The week_number of an assignment is determined based on the difference in weeks between the due date of the assignment and the start date of the academic session. If the start date of the academic session is null, the start date of the academic term is used. If the start date of the academic term is null, the start date of the course offering is used. The student activity score only includes published assignments with due dates and non-zero points possible.
Submissions
The number of assignments submitted by a student in a course offering for a given week is defined in the mart_helper.context__student_activity_score__submissions table. The week_number of a submission is also defined as the difference in weeks between the due date of the assignment and the start date of the academic session, academic term, or course offering. We only count submissions for published assignments with due dates, non-zero points possible, and allowed submission types of 'on_paper', 'Assignments', 'not_graded', 'none', ' ', or 'external_tool'.
Navigation time and Number of Sessions
The amount of time spent and number of sessions in the learning environment for a student in a course is defined in the mart_helper.event__student_activity_score__navigation_time table. The week_number of an event is defined as the difference in weeks between the event time and the start date of the academic session, academic term, or course. The navigation_time for a given week in a course for a student is the amount of time spent in the learning environment for the prior two weeks. The num_sessions is the number of sessions for the prior two weeks. We define the two week range for a week based on the latest event time for the given week in the course. Periods of inactivity, 25 minutes or more between two consecutive events, are removed from our aggregations.
Last updated