Final

The mart_student_activity_score.final mart presents the final student activity score for a student in an academic term for a given week in the term.

• BQ Prod Dataset Locations

• Interactive Mart Dependency Diagram

• Schema

• Student Activity Score

• Average Student Activity Score

• Student Activity Score Octile

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

Schema

mart/student_activity_score/final

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.
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.
week_number	INTEGER	The week of the academic term.
week_start_date	DATE	The start date of the week of the academic term.
week_end_date	DATE	The end date of the week of the academic term.
avg_student_activity_score	FLOAT	The average student activity z-score for the given week in the academic term.
avg_student_activity_score_cumulative	FLOAT	The average student activity z-score for the given week in the academic term using cumulative assignment and submission metrics.
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 a cohort of students based on their academic program.
student_activity_score_octile_cumulative	FLOAT	The octile of the student's average student activity z-score in comparison to the average student activity score for a cohort of students based on their academic program. Based on cumulative assignment and submission metrics

Student Activity Score

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.

Average Student Activity Score

The average_student_activity_score field is the average student activity z-score across all courses a student is enrolled in for a given week in an academic term.

Student Activity Score Octile

The student_activity_score_octile is the percentile of a student's activity z-score compared to other students. Students are cohorted based on their academic program for the given academic term. The octile of the student's activity score is computed using the PERCENTILE_CONT function in BigQuery.

10 or More Students Criteria

Originally, the Student Activity Score from IU was only computed on courses with 10 or more students enrolled. The definition of the final table here has this filter enforced. The course_final and course_section_final tables do not have this filter enforced. Instead, these tables have a field called course_has 10_or_more_students as a flag to include or exclude course(s) to align with IU's original definitions. Please see the documentation pages for course_final and course_section_final for more information on this flag.