# Course Final
The *mart\_student\_activity\_score.course\_final* mart presents the final student activity score for a student in a course for a given week in the term.
* [BQ Prod Dataset Locations](#user-content-bq-prod-dataset-locations-1)
* [Interactive Mart Dependency Diagram](#interactive-mart-dependency-diagram)
* [Schema](#user-content-schema-1-1)
* [Student Activity Score](#user-content-student-activity-score-1)
* [Student Activity Score Octile](#user-content-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](https://gitlab.com/unizin-community/unizin-data-platform/marts) repository. More information on the repository and diagram can be found on [this marts page](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts).
{% hint style="info" %}
[Click here to open the interactive chart.](https://assets.public.unizin.org/udp-marts/mart/mart__student_activity_score__course_final.svg)
{% endhint %}
mart_student_activity_score.course_final
### Schema
#### **mart/student\_activity\_score/course\_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*. |
| 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. |
| 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 whether a course has at least 10 enrolled students. |
| student\_activity\_score | FLOAT | The student activity score for the student in the course for the given week. |
| student\_activity\_score\_z | FLOAT | The z-score of the student activity score for the student in the course 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. |
| 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. |
### 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.
### Student Activity Score Octile
The *student\_activity\_score\_octile* is the percentile of a student's activity z-score compared to other students in the course for the given week. 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. 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
