Course Section Final
Last updated
Last updated
The mart_student_activity_score.course_section_final mart presents the final student activity score for a student in a course section for a given week in the term.
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.
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.
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.
course_has_10_or_more_students
BOOLEAN
Flag indicating if at least 10 students are enrolled in the course section
student_activity_score
FLOAT
The student activity score for the student in the course section for the given week.
student_activity_score_z
FLOAT
The z-score of the student activity score for the student in the course section for the given week.
student_activity_score_octile
FLOAT
The octile of the student's average student activity z-score in comparison to the average student activity score for the course section.
student_activity_score_cumulative
FLOAT
The student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
student_activity_score_z_cumulative
FLOAT
The z-score of the student activity score for the student in the course for the given week using cumulative assignment and submission metrics.
student_activity_score_octile_cumlative
FLOAT
The octile of the student's average student activity z-score in comparison to the average student activity score for the course using cumulative assignment and submission metrics.
The student activity score defines a "score" for a student's activity in a course's learning environment. The score is calculated using the formula:
5*[submissions/assignments_due]+2*[navigation_time]+[num_sessions]
The metrics in brackets are z-scores. The z-score for a student is computed for a week in the course.
The student_activity_score_octile is the percentile of a student's activity z-score compared to other students in the course section for the given week. The octile of the student's activity score is computed using the PERCENTILE_CONT function in BigQuery.
Originally, the Student Activity Score from IU was only computed on courses with 10 or more students enrolled. We have expanded our definition to include all courses, regardless of enrollment. However, the course_has_10_or_more_students flag can be leveraged to recreate the 10 or more student criteria from IU.
1 = course offering has at least 10 students enrolled
0 = course offering has fewer than 10 students enrolled
