Student Course Section Metrics

The mart_student_activity_score.student_course_section_metrics mart aggregates data about a student’s performance and activities in a course section on a weekly basis.

• BQ Prod Dataset Locations

• Interactive Mart Dependency Diagram

• Schema

• Assignments Due

• Submissions

• Navigation time and Number of Sessions

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.

Click here to open the interactive chart.

mart_student_activity_score.student_course_section_metrics

Schema

mart/student_activity_score/student_course_section_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.
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.
course_section_code	STRING	The SIS ID of the course section.
course_section_global_id	INTEGER	The UDP ID of the course section.
course_section_canvas_id	STRING	The Canvas ID of the course section.
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.

Assignments Due

The number of assignments due in a course section 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 section 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 section 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, 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.