Student Course Metrics
Last updated
Last updated
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.
mart_student_activity_score
The following visualization shows the construction of this data mart defined in the repository. More information on the repository and diagram can be found on .
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.
week_start_date
DATE
The start date of the week of the academic session, term, or course.
week_end_date
DATE
The end date of 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_cumulative
INTEGER
The number of assignments due in the course from the first day of the term to the current week, inclusive.
submissions_cumulative
INTEGER
The number of assignments submitted by the student from the first day of the term to the current week, inclusive.
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.
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'.
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.
