Last Activity

The mart_course_offering.last_activity mart includes information about the latest activities of students in a course offering. The mart_course_section.last_activity mart also includes this information, but at the course section level.

BQ Prod Dataset Location

mart_course_offering

mart_course_section

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.

mart_course_offering.last_activity

Schema

Mart/Course_offering/last_activity

Type
Description

udp_course_offering_id

INTEGER

The UDP ID of the Course offering.

lms_course_offering_id

STRING

The LMS ID of the Course offering.

udp_person_id

INTEGER

The UDP ID of the person.

lms_person_id

STRING

The LMS ID of the person.

academic_organization_array

ARRAY<STRING>

Array of string values for the academic organization(s)

academic_organization_display

STRING

The name of the academic organization(s) as a string with comma separation.

academic_term_name

STRING

The name of the academic term, i.e. Fall 2020.

academic_term_start_date

DATE

The start date for the academic term.

course_offering_title

STRING

The title of the Course offering, i.e. Linear Algebra.

course_offering_start_date

DATE

The start date of the Course offering.

instructor_display

STRING

An array of all the instructors' names for a Course offering written as a string.

instructor_name_array

ARRAY<STRING>

An array of all instructors’ names for a Course offering.

instructor_email_address_array

ARRAY<STRING>

An array of all instructors' emails for a Course offering

instructor_email_address_display

STRING

An array of all instructors' emails for a Course offering written as a string.

person_name

STRING

The name of the person.

last_activity

DATETIME

The time of the person’s last activity in the Course offering.

last_navigation_activity

DATETIME

The time of the person’s last navigation activity in the Course offering.

last_media_activity

DATETIME

The time of the person’s last media activity in the Course offering.

last_grade_activity

DATETIME

The time of the person’s last grade activity in the Course offering.

last_assessment_activity

DATETIME

The time of the person’s last assessment activity in the Course offering.

last_assignment_activity

DATETIME

The time of the person’s last assignment activity in the Course offering.

num_events

INTEGER

The number of events for the person in the Course offering.

num_navigation_events

INTEGER

The number of navigation events for the person in the Course offering.

num_media_events

INTEGER

The number of media events for the person in the Course offering.

num_grade_events

INTEGER

The number of grade events for the person in the Course offering.

num_assessment_events

INTEGER

The number of assessment events for the person in the Course offering.

num_assignment_events

INTEGER

The number of assignment events for the person in the Course offering.

Mart/Course_section/last_activity

The course section mart includes all the fields found in the course offering mart, as well as six more fields, which are presented in the table below.

Field Name
Type
Description

udp_course_section_id

INTEGER

The UDP ID of the Course section.

lms_course_section_id

STRING

The LMS ID of the Course section.

sis_course_section_id

STRING

The SIS ID of the Course section.

course_offering_subject

STRING

The subject of the Course offering, i.e. MATH.

course_offering_number

STRING

The number of the Course offering, i.e. 310.

course_offering_code

STRING

The code of the Course offering, i.e. MATH 310.

Fields

last_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp, regardless of event type. This signifies the latest activity of any type for a student in a course.

last_navigation_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp where the event type = ‘NavigationEvent’

last_media_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp where the event type = ‘MediaEvent’

last_grade_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp where the event type = ‘GradeEvent’

last_assessment_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp where the event type = ‘AssessmentEvent’

last_assignment_activity

This field is derived from the UDP event store. Per person, per course we pull the most recent event timestamp where the event type = ‘AssignableEvent’

num_events

Per person, per course, this field gives the total number of events that have occurred to date.

num_navigation_events

Per person, per course, this field gives the total number of events that have occurred to date where the event type = ‘NavigationEvent’

num_media_events

Per person, per course, this field gives the total number of events that have occurred to date where the event type = ‘MediaEvent’

num_grade_events

Per person, per course, this field gives the total number of events that have occurred to date where the event type = ‘GradeEvent’

num_assessment_events

Per person, per course, this field gives the total number of events that have occurred to date where the event type = ‘AssessmentEvent’

num_assignment_events

Per person, per course, this field gives the total number of events that have occurred to date where the event type = ‘AssignableEvent’

Tableau Template Workbook

As a starting point for visualization for this data mart, Unizin has created a Tableau template workbook available for download here:

Last Activity and Long Inactivity Dashboard Tableau Workbook File

Connecting to Data

The default data connection in the workbook is to Unizin's synthetic data. After downloading the workbook, the first step will be to transfer the connection to your own production UDP data. Here is a guide document to help with this process; Tableau also has a published doc for replacing data sources. For any issues connecting to source data, please contact [email protected].

Tableau Dashboard Filters

The following fields are used as filters in the Tableau Workbook:

  • Academic Organization - The academic department name

  • Instructor Display - The list of names of the course's instructors.

  • Course Offering Title - The title of the course offering.

  • UDP Course Offering ID - The UDP ID of the course offering.

  • Academic Term - The academic term of the course; the default selection is the current term.

These filters are in scope for all visuals in the dashboard.

Tableau Visualizations

Metric Cards
Metric Cards

These metric cards highlights key student activity metrics. They include the total number of enrolled, active, and inactive students. The metric cards also define the average number of days and hours students spent in the course, as well as the average number of inactive days. These metrics help assess overall student engagement in courses across the institution.

Last Activity Timeline

This heatmap shows when students are most active throughout the week, with color intensity representing the number of distinct last activity records. Darker shades indicate higher engagement levels, helping to pinpoint peak hours of student activity and identify times with lower participation.

Daily Activity Timeline

The days percent activity chart shows the percentage of total last activity recorded on each day of the week. This helps identify which days students are most and least active, offering a clear view of weekly engagement trends.

Last Activity at Different Times

The Last Activity at Different Times chart displays the number of distinct last activity events across different hours of the day. This helps identifying peak times of student engagement as well as hours with minimal activity, supporting better planning for course interactions and support availability.

Most Common Day and Hour

Most common day/hour for the last activity table lists the most frequent combinations of day and hour when students were last active. This makes it easy to spot the most popular times for student engagement

Last Activity Table

NOTE: For production use, please make sure it's appropriate for users to have visibility into student names. If names are too sensitive, please drop this column from the visual before sharing to users.

Last Activity table provides detailed student-level data, including academic organization display, course offering ID, student name and ID, last activity timestamp, total number of activity events, and the number of assignment-related events. If offers a comprehensive view of individual engagement and helps track student participation in course activities.

Last updated