# Level 2 Aggregated

* [Taskforce vs. Taskforce Rolling](#taskforce-vs.-taskforce-rolling)
* [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. The *mart\_taskforce\_rolling.level2\_aggregated* mart aggregates this data for a rolling 7-day window. This table exists alongside *mart\_taskforce.level2\_course\_weekly\_distribution\_summary.*

## **BQ Prod Dataset Locations**

* mart\_taskforce
* mart\_taskforce\_rolling

## Taskforce vs. Taskforce Rolling

Both the *taskforce* and *taskforce\_rolling* mart compare a student's performance and activities in a course to the average student for a 7-day time window. The primary difference is whether the 7-day time window is static or moving. 

The *taskforce* mart defines static weeks in a term, every week starting on Sunday and ending on Saturday. The weeks are calculated based on the start date of the academic session, term, or course.  Each week in the term will have a fixed start and end date based on the session/term/course start date. 

The *taskforce\_rolling* mart, on the other hand, defines rolling weeks by defining a 7-day time window for each day in a term. The time window includes the day in the term and the 6 previous days. The only instances when the time window is shorter is when the day in the term is still within 6 days of the first day in the term, since the earliest possible start date is the first day in the term. It won't be until the 7th day in the term that there is a rolling 7-day window that can be defined. From that day on, all of the days will have a rolling 7-day window defined, until the final day in the term.  

As the *taskforce\_rolling* mart has more records per enrollment than the *taskforce* mart, we have decided to include data from fewer terms in the *taskforce\_rolling* mart. The *taskforce\_rolling* mart includes Spring 2026 data onwards, while the *taskforce* mart starts in Spring 2021. 

In this documentation, any reference to week will refer to the static week for the *taskforce* mart and the rolling 7-day time window for the *taskforce\_rolling* mart. 

## 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.](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts.md)

{% 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="/files/mL9vxGp4knTQOZzOQYVg" 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>

### **mart/taskforce\_rolling/level2\_aggregated** <a href="#taskforcemartlevel1aggregated-fieldstructureandsubcategories" id="taskforcemartlevel1aggregated-fieldstructureandsubcategories"></a>

The *taskforce\_rolling* schema is the same as the *taskforce* schema, except that the static week definitions are replaced with rolling week definitions. `week_in_term` refers to the static week in term for both marts.&#x20;

| Field             | Data Type | Description                                            |
| ----------------- | --------- | ------------------------------------------------------ |
| week\_in\_term    | INT64     | The week of the academic term.                         |
| week\_start\_date | DATE      | The start date of the rolling 7-day window, inclusive. |
| week\_end\_date   | DATE      | The end date of the rolling 7-day window, inclusive.   |

## 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="/files/6bvSnACudTKhQAyBDBMn" 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*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#taskforcemartlevel1aggregated-sessionswith10-20-and30minutecutoffs)

Please visit our [separate interaction session mart documentation page here](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/interaction-sessions.md) 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.*](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-1-aggregated.md#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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/taskforce/level-2-aggregated.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.