# Level 2 Aggregated

* [Interactive Mart Dependency Diagram](#taskforcemartlevel2aggregated-interactivemartdependencydiagram)
* [Schema](#taskforcemartlevel2aggregated-schema)
* [Field Structure and Subcategories](#taskforcemartlevel2aggregated-fieldstructureandsubcategories)
  * [Dependencies](#taskforcemartlevel2aggregated-dependencies)
  * [Assignment Weight Groupings](#taskforcemartlevel2aggregated-assignmentweightgroupings)
  * [Z-Score Fields](#taskforcemartlevel2aggregated-z-scorefields)
* [Assignments](#taskforcemartlevel2aggregated-assignments)
  * [Number of Submissions](#taskforcemartlevel2aggregated-numberofsubmissions)
  * [Number of Assignments](#taskforcemartlevel2aggregated-numberofassignments)
  * [Number of Missing Submissions](#taskforcemartlevel2aggregated-numberofmissingsubmissions)
  * [Number of Late Submissions](#taskforcemartlevel2aggregated-numberoflatesubmissions)
  * [Average Time Buffer in Hours](#taskforcemartlevel2aggregated-averagetimebufferinhours)
  * [Average Published Score Percentage](#taskforcemartlevel2aggregated-averagepublishedscorepercentage)
* [Discussions](#taskforcemartlevel2aggregated-discussions)
  * [Discussion Entry Counts](#taskforcemartlevel2aggregated-discussionentrycounts)
  * [Discussion Counts](#taskforcemartlevel2aggregated-discussioncounts)
  * [Total Discussion Counts](#taskforcemartlevel2aggregated-totaldiscussioncounts)
  * [Average Discussion Entry Length](#taskforcemartlevel2aggregated-averagediscussionentrylength)
* [Learning Environment Activity](#taskforcemartlevel2aggregated-learningenvironmentactivity)
  * [View Days](#taskforcemartlevel2aggregated-viewdays)
  * [Sessions with 10, 20, and 30 Minute Cutoffs](#taskforcemartlevel2aggregated-sessionswith10-20-and30minutecutoffs)
  * [Tool Launches](#taskforcemartlevel2aggregated-toollaunches)
  * [File Views](#taskforcemartlevel2aggregated-fileviews)

The *mart\_taskforce.level2\_aggregated* mart aggregates data about a student’s performance and activities in a course on a weekly basis relative to average course and peer behaviors. This table exists alongside *mart\_taskforce.level2\_course\_weekly\_distribution\_summary*

## **BQ Prod Dataset Locations**

* mart\_taskforce

## Interactive Mart Dependency Diagram <a href="#taskforcemartlevel2aggregated-interactivemartdependencydiagram" id="taskforcemartlevel2aggregated-interactivemartdependencydiagram"></a>

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__taskforce__level2_aggregated.svg)
{% endhint %}

<div data-full-width="true"><figure><img src="https://3709019308-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKYwtHNGgdPXS3PWAlZUr%2Fuploads%2Fgit-blob-3f5e4ca3043ae2783bd70c695615e70dcd08bc0c%2Flevel2_aggregated.png?alt=media" alt=""><figcaption><p>mart_taskforce.level2_aggregated</p></figcaption></figure></div>

## Schema <a href="#taskforcemartlevel2aggregated-schema" id="taskforcemartlevel2aggregated-schema"></a>

### **mart/taskforce/level2\_aggregated**

<table data-full-width="true"><thead><tr><th width="402.33333333333337">Field Name</th><th width="177"></th><th></th></tr></thead><tbody><tr><td>udp_person_id</td><td>INTEGER</td><td>The UDP ID of the student.</td></tr><tr><td>lms_person_id</td><td>STRING</td><td>The LMS ID of the student.</td></tr><tr><td>udp_course_offering_id</td><td>INTEGER</td><td>The UDP ID of the course offering.</td></tr><tr><td>lms_course_offering_id</td><td>STRING</td><td>The LMS ID of the course offering.</td></tr><tr><td>week_in_term</td><td>INTEGER</td><td>The week of the academic term.</td></tr><tr><td>week_start_date</td><td>DATE</td><td>The start date of the week of the academic term.</td></tr><tr><td>week_end_date</td><td>DATE</td><td>The end date of the week of the academic term.</td></tr><tr><td>num_tiny_submissions_z</td><td>FLOAT</td><td>Z-score for the number of submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>num_small_submissions_z</td><td>FLOAT</td><td>Z-score for the number of submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>num_medium_submissions_z</td><td>FLOAT</td><td>Z-score for the number of submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>num_large_submissions_z</td><td>FLOAT</td><td>Z-score for the number of submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>num_major_submissions_z</td><td>FLOAT</td><td>Z-score for the number of submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>num_unweighted_submissions_z</td><td>FLOAT</td><td>Z-score for the number of unweighted submissions.</td></tr><tr><td>num_weighted_submissions_z</td><td>FLOAT</td><td>Z-score for the number of weighted submissions.</td></tr><tr><td>num_submissions_without_due_date_z</td><td>FLOAT</td><td>Z-score for the number of submissions without due dates.</td></tr><tr><td>num_submissions_with_due_date_z</td><td>FLOAT</td><td>Z-score for the number of submissions with due dates.</td></tr><tr><td>num_submissions_z</td><td>FLOAT</td><td>Z-score for the total number of submissions.</td></tr><tr><td>num_tiny_assignments_z</td><td>FLOAT</td><td>Z-score for the number of assignments classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>num_small_assignments_z</td><td>FLOAT</td><td>Z-score for the number of assignments classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>num_medium_assignments_z</td><td>FLOAT</td><td>Z-score for the number of assignments classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>num_large_assignments_z</td><td>FLOAT</td><td>Z-score for the number of assignments classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>num_major_assignments_z</td><td>FLOAT</td><td>Z-score for the number of assignments classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>num_unweighted_assignments_z</td><td>FLOAT</td><td>Z-score for the number of unweighted assignments.</td></tr><tr><td>num_weighted_assignments_z</td><td>FLOAT</td><td>Z-score for the number of weighted assignments.</td></tr><tr><td>num_assignments_without_due_date_z</td><td>FLOAT</td><td>Z-score for the number of assignments without due dates.</td></tr><tr><td>num_assignments_with_due_date_z</td><td>FLOAT</td><td>Z-score for the number of assignments with due dates.</td></tr><tr><td>num_assignments_z</td><td>FLOAT</td><td>Z-score for the total number of assignments.</td></tr><tr><td>num_tiny_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of missing submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>num_small_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of missing submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>num_medium_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of missing submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>num_large_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of missing submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>num_major_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of missing submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>num_unweighted_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of unweighted missing submissions.</td></tr><tr><td>num_weighted_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the number of weighted missing submissions.</td></tr><tr><td>num_missing_submissions_z</td><td>FLOAT</td><td>Z-score for the total number of missing submissions.</td></tr><tr><td>num_tiny_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of late submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>num_small_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of late submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>num_medium_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of late submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>num_large_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of late submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>num_major_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of late submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>num_unweighted_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of unweighted late submissions.</td></tr><tr><td>num_weighted_late_submissions_z</td><td>FLOAT</td><td>Z-score for the number of weighted late submissions.</td></tr><tr><td>num_late_submissions_z</td><td>FLOAT</td><td>Z-score for the total number of late submissions.</td></tr><tr><td>avg_time_buffer_hrs_tiny_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>avg_time_buffer_hrs_small_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>avg_time_buffer_hrs_medium_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>avg_time_buffer_hrs_large_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>avg_time_buffer_hrs_major_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>avg_time_buffer_hrs_unweighted_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for unweighted submissions.</td></tr><tr><td>avg_time_buffer_hrs_weighted_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for weighted submissions.</td></tr><tr><td>avg_time_buffer_hrs_z</td><td>FLOAT</td><td>Z-score for the average submission time buffer in hours for all submissions.</td></tr><tr><td>avg_published_score_pct_tiny_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions classified as ‘tiny’, or making up a tiny percentage of the student’s final grade.</td></tr><tr><td>avg_published_score_pct_small_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions classified as ‘small’, or making up a small percentage of the student’s final grade.</td></tr><tr><td>avg_published_score_pct_medium_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions classified as ‘medium’, or making up a medium percentage of the student’s final grade.</td></tr><tr><td>avg_published_score_pct_large_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions classified as ‘large’, or making up a large percentage of the student’s final grade.</td></tr><tr><td>avg_published_score_pct_major_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions classified as ‘major’, or making up a major percentage of the student’s final grade.</td></tr><tr><td>avg_score_pct_unweighted_z</td><td>FLOAT</td><td>Z-score for the average score percentage for unweighted submissions.</td></tr><tr><td>avg_published_score_pct_weighted_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for weighted submissions.</td></tr><tr><td>avg_published_score_pct_without_due_date_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions without due dates.</td></tr><tr><td>avg_published_score_pct_with_due_date_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for submissions with due dates</td></tr><tr><td>avg_published_score_z</td><td>FLOAT</td><td>Z-score for the average published score percentage for all submissions.</td></tr><tr><td>avg_published_score_pct_tiny_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions classified as ‘tiny’ </td></tr><tr><td>avg_published_score_pct_small_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions classified as ‘small’ </td></tr><tr><td>avg_published_score_pct_medium_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions classified as ‘medium’ </td></tr><tr><td>avg_published_score_pct_large_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions classified as ‘large’ </td></tr><tr><td>avg_published_score_pct_major_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions classified as ‘major’ </td></tr><tr><td>avg_published_score_pct_without_due_date_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions without a due date</td></tr><tr><td>avg_published_score_pct_with_due_date_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions with a due date.</td></tr><tr><td>avg_published_score_pct_unweighted_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions without a weight</td></tr><tr><td>avg_published_score_pct_weighted_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage for submissions with a non-zero weight</td></tr><tr><td>avg_published_score_cumulative_z</td><td>FLOAT</td><td>Z-score for the cumulative average published score percentage  </td></tr><tr><td>discussion_entry_count_z</td><td>FLOAT</td><td>Z-score for the number of discussion entries posted by the student.</td></tr><tr><td>discussion_post_count_z</td><td>FLOAT</td><td>Z-score for the number of discussion posts posted by the student.</td></tr><tr><td>discussion_reply_count_z</td><td>FLOAT</td><td>Z-score for the number of discussion replies posted by the student.</td></tr><tr><td>discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of discussions interacted with by the student.</td></tr><tr><td>assignment_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of discussions associated with an assignment interacted with by the student.</td></tr><tr><td>threaded_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of threaded discussions interacted with by the student.</td></tr><tr><td>side_comment_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of side comment discussions interacted with by the student.</td></tr><tr><td>total_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of discussions available in the course offering.</td></tr><tr><td>total_assignment_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of discussions associated with assignments available in the course offering.</td></tr><tr><td>total_threaded_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of threaded discussions available in the course offering.</td></tr><tr><td>total_side_comment_discussion_count_z</td><td>FLOAT</td><td>Z-score for the total number of side comment discussions available in the course offering.</td></tr><tr><td>avg_discussion_entry_length_z</td><td>FLOAT</td><td>Z-score for the average length of the student’s discussion entries.</td></tr><tr><td>avg_discussion_post_length_z</td><td>FLOAT</td><td>Z-score for the average length of the student’s discussion posts.</td></tr><tr><td>avg_discussion_reply_length_z</td><td>FLOAT</td><td>Z-score for the average length of the student’s discussion replies.</td></tr><tr><td>view_days_z</td><td>FLOAT</td><td>Z-score for the number of view days in the LMS.</td></tr><tr><td>num_sessions_10min_z</td><td>FLOAT</td><td>Z-score for the number of sessions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>total_time_seconds_10min_z</td><td>FLOAT</td><td>Z-score for the total time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>total_actions_10min_z</td><td>FLOAT</td><td>Z-score for the total number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_time_seconds_10min_z</td><td>FLOAT</td><td>Z-score for the average amount of time spent in the LMS in seconds, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>avg_actions_10min_z</td><td>FLOAT</td><td>Z-score for the average number of actions in the LMS, with a 10 minute cutoff when calculating sessions.</td></tr><tr><td>num_sessions_20min_z</td><td>FLOAT</td><td>Z-score for the number of sessions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>total_time_seconds_20min_z</td><td>FLOAT</td><td>Z-score for the total time spent in the LMS in seconds, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>total_actions_20min_z</td><td>FLOAT</td><td>Z-score for the total number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>avg_time_seconds_20min_z</td><td>FLOAT</td><td>Z-score for the average amount of time spent in the LMS in seconds, with a 20 minute time cutoff when calculating sessions.</td></tr><tr><td>avg_actions_20min_z</td><td>FLOAT</td><td>Z-score for the average number of actions in the LMS, with a 20 minute cutoff when calculating sessions.</td></tr><tr><td>num_sessions_30min_z</td><td>FLOAT</td><td>Z-score for the number of sessions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>total_time_seconds_30min_z</td><td>FLOAT</td><td>Z-score for the total time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>total_actions_30min_z</td><td>FLOAT</td><td>Z-score for the total number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_time_seconds_30min_z</td><td>FLOAT</td><td>Z-score for the average amount of time spent in the LMS in seconds, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>avg_actions_30min_z</td><td>FLOAT</td><td>Z-score for the average number of actions in the LMS, with a 30 minute cutoff when calculating sessions.</td></tr><tr><td>num_tool_launches_z</td><td>FLOAT</td><td>Z-score for the total number of LTI tool launches.</td></tr><tr><td>num_tools_launched_z</td><td>FLOAT</td><td>Z-score for the total number of LTI tools launched.</td></tr><tr><td>file_views_z</td><td>FLOAT</td><td>Z-score for the number of file views.</td></tr><tr><td>num_files_viewed_z</td><td>FLOAT</td><td>Z-score for the number of files viewed.</td></tr><tr><td>course_tools_launched</td><td>ARRAY&#x3C;STRING></td><td>Array of tool names launched by the person in the course for the week</td></tr><tr><td>course_tools_not_launched</td><td>ARRAY&#x3C;STRING></td><td>Array of tool names not launched by the person in the course for the week</td></tr><tr><td>course_files_viewed</td><td>ARRAY&#x3C;INTEGER></td><td>Array of file IDs accessed by the person in the course for the week</td></tr><tr><td>course_files_not_viewed</td><td>ARRAY&#x3C;INTEGER></td><td>Array of file IDs not accessed by the person in the course for the week</td></tr></tbody></table>

## Field Structure and Subcategories <a href="#taskforcemartlevel2aggregated-fieldstructureandsubcategories" id="taskforcemartlevel2aggregated-fieldstructureandsubcategories"></a>

This level 2 table has many fields, so we’ve grouped them together in the following subcategories

* Assignments
  * Submissions
  * Assignments
  * Missing Assignments
  * Late Submissions
  * Submission Time Buffer
  * Published Scores
* Discussions
  * Discussion Threads
  * Discussion Entries
* Learning Environment Activity
  * View days
  * Sessions
  * Tool Launches
  * File Views

#### Dependencies <a href="#taskforcemartlevel2aggregated-dependencies" id="taskforcemartlevel2aggregated-dependencies"></a>

The only dependency for this mart is the *mart\_taskforce*.*level1\_aggregated*. All calculations and fields are based on that mart, and there are no direct dependencies to the UDP itself. As long as the *mart\_taskforce.level1\_aggregated* is successfully created, this mart can also be created.

#### Assignment Weight Groupings <a href="#taskforcemartlevel2aggregated-assignmentweightgroupings" id="taskforcemartlevel2aggregated-assignmentweightgroupings"></a>

Many fields have names that include *tiny*, *small*, *medium*, *large*, and *major*. These classifications are based on the *group\_weight* field in the ‘learner\_activity\_group’ entity. The cases are as follows:

* If the *group\_weight* is null or equal to 0%, the submission is ‘unweighted’.
* If the *group\_weight* is less than or equal to 2%, the submission is ‘tiny’.
* If the *group\_weight* is greater than 2% and less than or equal to 5%, the submission is ‘small’.
* If the *group\_weight* is greater than 5% and less than or equal to 10%, the submission is ‘medium’.
* If the *group\_weight* is greater than 10% and less than or equal to 25%, the submission is ‘large’.
* If the *group\_weight* is greater than 25%, the submission is ‘major’.
* If the *group\_weight* is not null and greater than 0%, the submission is 'weighted'.

These assignment weight groupings are consistent with the groupings for the Level 1 mart.

#### Z-Score Fields <a href="#taskforcemartlevel2aggregated-z-scorefields" id="taskforcemartlevel2aggregated-z-scorefields"></a>

The majority of the schema for *mart\_taskforce.level2\_aggregated* are z-score fields based on the distribution of corresponding fields per-course, per-week in *mart\_taskforce.level1\_aggregated*. The corresponding table *mart\_taskforce.level2\_course\_weekly\_distribution\_summary* surfaces the averages and standard deviations (per-course, per-week) needed to calculate the z-scores for this table. We use the standard normalization formula to compute the z-scores.

<figure><img src="https://3709019308-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKYwtHNGgdPXS3PWAlZUr%2Fuploads%2Fgit-blob-7f2663f714209736b761574e9d6a583296c3687c%2FScreenshot%202023-10-06%20at%204.58.59%E2%80%AFPM.png?alt=media" alt=""><figcaption></figcaption></figure>

### Assignments <a href="#taskforcemartlevel2aggregated-assignments" id="taskforcemartlevel2aggregated-assignments"></a>

#### Number of Submissions <a href="#taskforcemartlevel2aggregated-numberofsubmissions" id="taskforcemartlevel2aggregated-numberofsubmissions"></a>

**Fields**

* num\_tiny\_submissions\_z
* num\_small\_submissions\_z
* num\_medium\_submissions\_z
* num\_large\_submissions\_z
* num\_major\_submissions\_z
* num\_unweighted\_submissions\_z
* num\_weighted\_submissions\_z
* num\_submissions\_without\_due\_date\_z
* num\_submissions\_with\_due\_date\_z
* num\_submissions\_z

**Description**

These fields present the Z-scores for the number of submissions by a student in a course for each week in the term. More detailed descriptions of the original submission fields exist in the [documentation for *mart\_taskforce.level1\_aggregated*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-numberofsubmissions)*.*

#### Number of Assignments <a href="#taskforcemartlevel2aggregated-numberofassignments" id="taskforcemartlevel2aggregated-numberofassignments"></a>

**Fields**

* num\_tiny\_assignments\_z
* num\_small\_assignments\_z
* num\_medium\_assignments\_z
* num\_large\_assignments\_z
* num\_major\_assignments\_z
* num\_unweighted\_assignments\_z
* num\_weighted\_assignments\_z
* num\_assignments\_z\_without\_due\_date
* num\_assignments\_z\_with\_due\_date
* num\_assignments\_z

**Description**

These fields present Z-scores for the number of assignments for a student in a course for each week in the term. The more detailed descriptions of the original assignment fields can be found in the [documentation for *mart\_taskforce.level1\_aggregated*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-numberofassignments)*.*

#### Number of Missing Submissions <a href="#taskforcemartlevel2aggregated-numberofmissingsubmissions" id="taskforcemartlevel2aggregated-numberofmissingsubmissions"></a>

**Fields**

* num\_tiny\_missing\_submissions\_z
* num\_small\_missing\_submissions\_z
* num\_medium\_missing\_submissions\_z
* num\_large\_missing\_submissions\_z
* num\_major\_missing\_submissions\_z
* num\_unweighted\_missing\_submissions\_z
* num\_weighted\_missing\_submissions\_z
* num\_missing\_submissions\_z

**Description**

These fields present Z-scores for the number of missing student submissions in a course for each week in the term. The definitions of the original missing submissions fields exist in the [documentation for *mart\_taskforce.level1\_aggregated*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-numberofmissingsubmissions)*.*

#### Number of Late Submissions <a href="#taskforcemartlevel2aggregated-numberoflatesubmissions" id="taskforcemartlevel2aggregated-numberoflatesubmissions"></a>

**Fields**

* num\_tiny\_late\_submissions\_z
* num\_small\_late\_submissions\_z
* num\_medium\_late\_submissions\_z
* num\_large\_late\_submissions\_z
* num\_major\_late\_submissions\_z
* num\_unweighted\_late\_submissions\_z
* num\_weighted\_late\_submissions\_z
* num\_late\_submissions\_z

**Description**

These fields present the Z-scores for the number of late submissions by a student in a course for each week in the term. The definitions of the original late submissions fields exist in the [documentation for *mart\_taskforce.level1\_aggregated*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-numberoflatesubmissions)*.*

#### Average Time Buffer in Hours <a href="#taskforcemartlevel2aggregated-averagetimebufferinhours" id="taskforcemartlevel2aggregated-averagetimebufferinhours"></a>

**Fields**

* avg\_time\_buffer\_hrs\_tiny\_z
* avg\_time\_buffer\_hrs\_small\_z
* avg\_time\_buffer\_hrs\_medium\_z
* avg\_time\_buffer\_hrs\_large\_z
* avg\_time\_buffer\_hrs\_major\_z
* avg\_time\_buffer\_hrs\_unweighted\_z
* avg\_time\_buffer\_hrs\_weighted\_z
* avg\_time\_buffer\_hrs\_z

**Description**

These fields present the Z-scores for the average time buffer in hours for submissions by a student in a course for each week in the term. The definitions of the original time buffer fields exist in the [documentation for *mart\_taskforce.level1\_aggregated*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-averagetimebufferinhours)*.*

#### Average Published Score Percentage <a href="#taskforcemartlevel2aggregated-averagepublishedscorepercentage" id="taskforcemartlevel2aggregated-averagepublishedscorepercentage"></a>

**Fields**

* avg\_published\_score\_pct\_tiny\_z
* avg\_published\_score\_pct\_small\_z
* avg\_published\_score\_pct\_medium\_z
* avg\_published\_score\_pct\_large\_z
* avg\_published\_score\_pct\_major\_z
* avg\_score\_pct\_unweighted\_z
* avg\_published\_score\_pct\_weighted\_z
* avg\_published\_score\_pct\_without\_due\_date\_z
* avg\_published\_score\_pct\_with\_due\_date\_z
* avg\_published\_score\_z
* avg\_published\_score\_pct\_tiny\_cumulative\_z
* avg\_published\_score\_pct\_small\_cumulative\_z
* avg\_published\_score\_pct\_medium\_cumulative\_z
* avg\_published\_score\_pct\_large\_cumulative\_z
* avg\_published\_score\_pct\_major\_cumulative\_z
* avg\_score\_pct\_unweighted\_cumulative\_z
* avg\_published\_score\_pct\_weighted\_cumulative\_z
* avg\_published\_score\_pct\_without\_due\_date\_cumulative\_z
* avg\_published\_score\_pct\_with\_due\_date\_cumulative\_z
* avg\_published\_score\_cumulative\_z

**Description**

These fields show the Z-scores for the average published score percentage of submissions by a student in a course for each week in the term. The description of the average published score fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-averagepublishedscorepercentage)

### Discussions <a href="#taskforcemartlevel2aggregated-discussions" id="taskforcemartlevel2aggregated-discussions"></a>

#### Discussion Entry Counts <a href="#taskforcemartlevel2aggregated-discussionentrycounts" id="taskforcemartlevel2aggregated-discussionentrycounts"></a>

**Fields**

* discussion\_entry\_count \_z
* discussion\_post\_count\_z
* discussion\_reply\_count\_z

**Description**

These fields present the Z-scores for the number of discussion entries posted by a student in a course for each week in the term. The definitions of the original discussion entry count fields exist in the d[ocumentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-discussionentrycounts)

#### Discussion Counts <a href="#taskforcemartlevel2aggregated-discussioncounts" id="taskforcemartlevel2aggregated-discussioncounts"></a>

**Fields**

* discussion\_count\_z
* assignment\_discussion\_count\_z
* threaded\_discussion\_count\_z
* side\_comment\_discussion\_count\_z

**Description**

These fields present the Z-scores for the number of discussions a student has interacted with in a course for each week in the term. The discussion count fields used to compute these Z-scores are defined in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-discussioncounts)

#### Total Discussion Counts <a href="#taskforcemartlevel2aggregated-totaldiscussioncounts" id="taskforcemartlevel2aggregated-totaldiscussioncounts"></a>

**Fields**

* total\_discussion\_count\_z
* total\_assignment\_discussion\_count\_z
* total\_threaded\_discussion\_count\_z
* total\_side\_comment\_discussion\_count\_z

**Description**

These fields present the Z-scores for the total number of discussions in a course for a given week in the term. The definitions of the original total discussion count fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-totaldiscussioncounts)

#### Average Discussion Entry Length <a href="#taskforcemartlevel2aggregated-averagediscussionentrylength" id="taskforcemartlevel2aggregated-averagediscussionentrylength"></a>

**Fields**

* avg\_discussion\_entry\_length\_z
* avg\_discussion\_post\_length\_z
* avg\_discussion\_reply\_length\_z

**Description**

These fields present the Z-scores for the average length of the discussion entry messages for a student in a course for a given week in the term. More detailed descriptions of the average discussion entry lengths can be found in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-averagediscussionentrylength)

### Learning Environment Activity <a href="#taskforcemartlevel2aggregated-learningenvironmentactivity" id="taskforcemartlevel2aggregated-learningenvironmentactivity"></a>

#### View Days <a href="#taskforcemartlevel2aggregated-viewdays" id="taskforcemartlevel2aggregated-viewdays"></a>

**Fields**

* view\_days

**Description**

The *view\_days* field shows the Z-score for the number of days a student viewed the learning environment for a course in a given week. The definition of the view days field exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-viewdays)

#### Sessions with 10, 20, and 30 Minute Cutoffs <a href="#taskforcemartlevel2aggregated-sessionswith10-20-and30minutecutoffs" id="taskforcemartlevel2aggregated-sessionswith10-20-and30minutecutoffs"></a>

**Fields**

* num\_sessions\_10min\_z
* total\_time\_seconds\_10min\_z
* total\_actions\_10min\_z
* avg\_time\_seconds\_10min\_z
* avg\_actions\_10min\_z
* num\_sessions\_20min\_z
* total\_time\_seconds\_20min\_z
* total\_actions\_20min\_z
* avg\_time\_seconds\_20min\_z
* avg\_actions\_20min\_z
* num\_sessions\_30min\_z
* total\_time\_seconds\_30min\_z
* total\_actions\_30min\_z
* avg\_time\_seconds\_30min\_z
* avg\_actions\_30min\_z

**Description**

For this mart, we define sessions using three different time cutoffs: 10 minutes, 20 minutes, and 30 minutes. We define the time spent in a session by adding up the duration of events in the session. These fields present the Z-scores for the number of sessions, total time spent, total number of actions, average time spent, and average number of actions for all three time cutoffs for a student in a course for a given week in the term. The definitions of the base session, time, and action fields exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-sessionswith10-20-and30minutecutoffs)

Please visit our [separate interaction session mart documentation page here](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/interaction-sessions) for a visual example and more information about interaction sessions too.

#### Tool Launches <a href="#taskforcemartlevel2aggregated-toollaunches" id="taskforcemartlevel2aggregated-toollaunches"></a>

**Fields**

* num\_tool\_launches\_z
* num\_tools\_launched\_z
* course\_tools\_launched
* course\_tools\_not\_launched

**Description**

These fields focus on the LTI tools launched by a student in the learning environment of a course for each week in the term. More detailed definitions of LTI launches exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/level-1-aggregated#taskforcemartlevel1aggregated-toollaunches)

The course\_tools\_launched and course\_tools\_not\_launched are unique to this table. Both of these fields are of type ARRAY\<STRING>. The course\_tools\_launched array field is a concatenated list of all launch app names seen for the course, week pair for a student. The course\_tools\_not\_launched array field is inferred based on all the launch app names launched for the course for that week across all students. The results in the course\_tools\_not\_launched field are the launch app names that at least one other student in the class launched but the student in scope for the row did not launch.

#### File Views <a href="#taskforcemartlevel2aggregated-fileviews" id="taskforcemartlevel2aggregated-fileviews"></a>

**Fields**

* file\_views\_z
* num\_files\_viewed\_z
* course\_files\_viewed
* course\_files\_not\_viewed

**Description**

These fields focus on the files viewed by a student in the learning environment of a course for each week in the term. More detailed definitions of files and file views exist in the [documentation for *mart\_taskforce.level1\_aggregated.*](#taskforcemartlevel2aggregated-fileviews)

The course\_files\_viewed and course\_files\_not\_viewed are unique to this table. Both of these fields are of type ARRAY\<INTEGER>. The course\_files\_launched array field is a concatenated list of all file IDs seen for the course and week pair for a student. The course\_files\_not\_viewed array field is inferred based on all the file IDs viewed for the course and week across all students. The results in the course\_files\_not\_viewed field are the file IDs that at least one other student in the class viewed but the student in scope for the row did not view.