Unizin Product Documentation
ProductsSupport and TrainingPolicies
  • Unizin Product Documentation
  • Products
    • Content
      • Unizin Engage
        • eReader User Guide
          • Notes, Highlights, and Citations
          • Appearance Settings
          • Download for Offline
          • eReader Layout
          • Keyboard Shortcuts
          • Navigating Your eBook
          • Print
          • Text to Speech
          • Copy and Paste
          • Creating Flashcards
          • Collaboration and Note Sharing
          • Pearson Titles
        • Institution Support
          • Disabled Student Services / Alt-Format
            • Best Practices for Republishing Course Content
            • Disabled Student Services
            • Requesting eTextbook Files for Accessibility Purposes
            • WCAG 2.0 AA evaluation for Engage
            • WCAG 2.0 AA evaluation for EPUB for Engage
          • Institution's Support Responsibilities
        • Caliper 1.1 sensor
        • Release Notes
          • 2.28.22
          • 2019-09-17
          • 2019-05-29
          • 2.26.8
          • 2.26.0
          • 2.25.0
          • 2.22.0
          • 2.21.6
          • 2.21.5
          • 2.20.8
          • 2.20.5
          • 2.20.3
          • 2.19.1
          • 2.18.0
          • 2.17.0
          • 2.14.0
          • 2.12.0
          • 2.11.0
          • 2.9.0
          • 2.8.3
          • 2016-03-17
          • 2016-02-11
          • 2016-01-28
        • Using Analytics (New)
      • Unizin Order Tool
        • Overview of the User Interface
        • Key Concepts
          • Profiles
          • Ordering periods
          • Coordinator permissions
          • Program administrator permissions
        • Courses & Ordering
          • Course filtering
          • Place an order
          • Add sections to a placed order
          • Edit a placed order
          • Cancel an order
          • Reordering
        • Order History
          • Instructor Order History
          • Coordinator and Program Administrator Order History
          • Order Activity
        • Student Choice
          • Student Choice (Program Administrators)
          • Student Choice (Students)
        • Entitlements
          • Entitlements (Program Administrators)
          • Entitlements (Students)
        • Catalog Tool
        • Schedule of Classes
        • Content Request Tool
        • Order Tool Dashboard
        • Vendor Sandbox Tenant
        • Institution Support
        • Implementation
          • SIS Data Integration
            • 1.0 - SIS Integration
            • 2.0 - SIS Integration
          • SSO integration
          • UI customizations
          • Order Feed
            • 1.0 - Order Feed
            • 2.0 - Order Feed
            • 3.0 - Order Feed
          • Publisher report
          • Final declined offers feed
          • Institutional (SIS) Catalog Import
          • Student Price
          • Historical Entitlements Import
        • Release Notes
          • Order Tool Bug Fixes and Enhancements
          • Order Tool Bug Fixes
          • Order Tool Accessibility Improvements
          • Order Feed Improvements
          • Content Request Form Update and Minor Bug Fix
          • Flat Markup Fee Update
          • Ordering Email Receipt Update & Minor Bug Fix
          • Bug Fix for Public Catalog Feature
          • Catalog Search Enhancements
          • Reordering Reminder Email Notifications
          • UX Improvements & Minor Bug Fixes
          • Historical Entitlements Import
          • Student Prices
          • Reordering Feature
          • Email Enhancements
          • Ordering Enhancements
          • Bug Fix for the Institutional Catalog Import
          • Bug Fix for the Final Declined Offers Feed (FDOF)
          • Order Activity Feature and Other Enhancements
          • Bug Fixes for Order History and Report an Issue Features
          • Public catalog feature
          • Minor Bug Fixes for Ordering and Student Choice
          • Entitlements Production Release, Bug fixes, and Minor updates
          • Minor Updates and Bug Fixes for Ordering Workflows
          • Catalog Search Optimization
          • Student Choice
          • Archive Terms Feature and Integration Improvements
          • Introduces the Program Administrator role, Catalog Tool, and Schedule
          • User interface updates and improvements
          • Order feed improvements
          • Order history, UI enhancements
          • Email notification upgrades, UI improvements
          • Order feed changes
          • New features for Course coordinators and upgrades to the UI
          • Changes to the Term, Course, and Section models; introduces a Session
          • Bug fixes, import improvements, and validation improvements
          • Tracking Order History
          • Publisher Reporting
          • Fixes the order feed, automates SIS data importing, and automates the generation of order feed repor
    • Data & Analytics
      • Unizin Data Platform
        • Key concepts
          • Platform overview
          • Data categories
          • Data models
          • Loading schemas
          • Keymap
        • Unizin Common Data Model
          • Academic structures (ERD)
          • Learners (ERD)
          • Course structures (ERD)
          • Course resources (ERD)
          • Learner activities (ERD)
          • Quizzes (ERD)
          • Social (ERD)
          • Course outcomes (ERD)
        • System overview
          • Context data pipeline
            • Context data ingress
            • Batch-ingest application
            • Batch-ingest db server
            • Context store
          • Event data pipeline
            • UDP Caliper endpoint
            • Approval process for implementing Caliper compliant tools
            • UDP Event enricher
            • Event store
        • Data stores
          • Data lake
            • UDP Context store
            • UDP Event store
              • Accessing the Event store
              • Expanded table
                • Expanded table: Canvas edApp mapping
            • Synthetic Data [beta]
              • Viewing Synthetic Data datasets within the BigQuery UI
              • Query Synthetic Data via client libraries
          • Data marts
            • UDP Distributions
            • Interaction sessions
            • Learning Environment Organization
            • File Interaction
            • Last Activity
            • Long Inactivity
            • Course Status
            • Daily Course Grade Record
            • LTI Tool Use
            • LMS Tool Use
            • Tool Usage Metrics
            • Links
            • Taskforce
              • Level 1 Aggregated
              • Level 2 Aggregated
              • Level 2 Course Weekly Distribution Summary
              • Student Term Profile
              • Course Profile
            • Student Activity Score
              • Student Course Metrics
              • Student Course Section Metrics
              • Final
              • Course Final
              • Course Section Final
        • Data integrations
          • Context data integration
            • Loading schema
            • Keymap support
            • Manifest file
            • File requirements
            • Integration mechanics
          • Event data integration
          • SIS data integration
          • LMS data integration
            • Instructure Canvas
        • Release Notes
          • UDP Marts Release Notes
            • 1.0.83
            • 1.0.80
            • 1.0.79
            • 1.0.78
            • 1.0.77
            • 1.0.72
            • 1.0.67
            • 1.0.58
            • 1.0.51
            • 1.0.44
            • 1.0.42
            • 1.0.32
            • 1.0.31
            • 1.0.0
            • Level 2 Taskforce data marts now available
          • 2.0.167
          • 2.0.152
          • 2.0.138
          • 2.0.137
          • 2.0.113
          • 2.0.112
          • 2.0.111
          • 2.0.110
          • 2.0.99
          • 2.0.98
          • 2.0.83
          • 2.0.80
          • 2.0.71
          • 2.0.66
          • 2.0.59
          • 2.0.58
          • 2.0.53
          • 2.0.47
          • 2.0.25
        • Miscellaneous
          • Canvas Data additions, ~Fall 2021
          • Canvas Live Events: from SQS to HTTPS
          • Canvas New Analytics vs. UDP
          • Course Section Enrollment Role Status Mappings
          • Migrating from UDW to UDP
      • Unizin Data Warehouse
        • Implementation Guide
        • Scope of Services
        • Access Provisioning
        • Access Revocation
        • Connecting to the UDW
      • Raw Canvas Data 2
        • Flat Files
        • BigQuery Datasets
    • Hosted Services
      • My Learning Analytics
        • Install MyLA via LTI 1.3
        • Custom configure MyLA
  • Support and Training
    • Professional Development
      • Stepping Stones: A Faculty Development Curriculum for Learning Analytics Use
      • Structured Conversations initiative
    • UDP Self-paced Training
    • Resources Site Broken Links
    • Status Pages
  • Policies
    • General policies
      • Sponsor Teams
      • Browser Support Policy
      • Opt-Out & Invoicing Policy (Order Tool)
    • Support Policy
      • Unizin Engage - SP
      • Unizin Order Tool - SP
      • Unizin Data Platform - SP
      • Unizin Data Warehouse - SP
      • Unizin Data Analysis - SP
      • Pressbooks Hosting - SP
    • Privacy Policy
      • Unizin Engage - PP
      • Unizin Order Tool - PP
      • Unizin Data Platform - PP
      • RStudio service - PP
    • End User License Agreements
      • Unizin Engage - EULA
      • Unizin Order Tool - EULA
    • Terms of Use
      • Unizin Data Platform - ToU
    • Incident Reports
Powered by GitBook
LogoLogo

Unizin Homepage

  • unizin.org

Data & Analytics

  • Unizin Data Platform
  • Unizin Data Warehouse

Content

  • Unizin Engage
  • Unizin Order Tool

Hosted Services

  • My Learning Analytics

Copyright © 2023, Unizin, Ltd.

On this page
  • BQ Prod Dataset Locations
  • Interactive Mart Dependency Diagram
  • Schema
  • Mart/Course_offering/status
  • Mart/Course_section/status
  • Fields
  • Tableau Template Workbook
  • Connecting to Data
  • Tableau Dashboard Filters
  • Tableau Visualizations
  1. Products
  2. Data & Analytics
  3. Unizin Data Platform
  4. Data stores
  5. Data marts

Course Status

PreviousLong InactivityNextDaily Course Grade Record

Last updated 9 days ago

The mart_course_offering.status mart includes information regarding the status of a Course offering in a learning environment. The mart_course_section.status mart does the same at the course section level.

BQ Prod Dataset Locations

mart_course_offering

mart_course_section

Interactive Mart Dependency Diagram

The following visualization shows the construction of this data mart defined in the repository. More information on the repository and diagram can be found on

Schema

Mart/Course_offering/status

Field Name
Type
Description

udp_course_offering_id

INTEGER

The UDP ID for the Course offering.

lms_course_offering_id

STRING

The LMS ID for the Course offering.

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.

academic_organization_array

ARRAY<STRING>

An array of the academic organization(s).

academic_organization_display

STRING

An array of the academic organization(s) written as a comma-separated string.

course_offering_title

STRING

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

course_offering_start_date

DATE

The start date for the Course offering.

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.

instructor_name_array

ARRAY<STRING>

An array of all the instructor’s names for the Course offering.

instructor_lms_id_array

ARRAY<STRING>

An array of all the instructor’s LMS IDs for the Course offering.

instructor_display

STRING

An array of all the instructor’s names for the Course offering written as a string.

instructor_email_address_array

ARRAY<STRING>

An array of all the instructor email addresses for the Course offering.

instructor_email_address_display

STRING

An array of all the instructor email addresses for the Course offering written as a comma-separated string.

status

STRING

The status of the Course offering.

reported_status

STRING

The reported status of the Course offering.

publish_time

DATETIME

The time the Course offering was published.

num_students

INTEGER

The number of students enrolled in the Course offering.

published_la

INTEGER

The number of published learner activities in the Course offering.

unpublished_la

INTEGER

The number of unpublished learner activities in the Course offering.

published_quiz

INTEGER

The number of published quizzes in the Course offering.

unpublished_quiz

INTEGER

The number of unpublished quizzes in the Course offering.

active_module

INTEGER

The number of active modules in the Course offering.

unpublished_module

INTEGER

The number of unpublished modules in the Course offering.

Mart/Course_section/status

The course section mart includes all the fields included in the course offering mart, in addition to the nine fields shown 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.

combined_section_basis

STRING

The primary basis for combining sections together if the Course section is combined with others. Common values for this field are CrossListed, MeetTogether, and UgGrad.

combined_section_id

STRING

The ID of the combined Course section if the Course section is combined with others.

delivery_mode

STRING

The delivery for the instruction given in the Course section, i.e. FaceToFace, Online, BlendedLearning.

is_combined_section_parent

INTEGER

A binary value (0 or 1) indicating whether the Course section in a group of combined Course sections is the Parent Course section. This is only meaningful if the course section is combined with other sections.

is_default

INTEGER

A binary value (0 or 1) indicating whether the Course section is the default Course section.

is_graded

INTEGER

A binary value (0 or 1) indicating whether the Course section is the graded Course section.

is_honors

INTEGER

A binary value (0 or 1) indicating whether the Course section is a Honors Course section.

Fields

status

The status field defines the status of the Course offering in the learning environment. The status of the Course offering is found by looking at events from the learning environment. Specifically, we look for an event where the status of the course was modified. For example, to define the status of a course in Canvas, we look for an event with a ‘Modified’ action and an object with a non-null workflow state. These aspects of an event tell us that the status was modified. By depending on events, we are able to have the most recently updated status for the course. The status field in this mart is defined as the workflow state of the object in the event. If this field is null for a course, we then will define the status from the le_status field in the course_offering table from the context store. Overall, the status field tells us the current state of the Course offering, specifically in relation to its availability for teaching and learning. Common values for this field are presented below.

  • Published - the course is published.

  • Unpublished - the course is not published.

  • Active - the course is published and currently active.

  • Completed - the course has concluded.

  • Created - the course has been created but not published.

  • Deleted - the course has been deleted.

  • Available - the course has been published and is not completed.

  • Claimed - the course has been undeleted and is not published

reported_status

The reported_status field in this mart is similar to the status field, but more generalized for reporting purposes. The reported status prioritizes the statuses that users find most relevant. The reported_status field is defined by the status field. We define four values for the reported_status field:

  • Not Published

  • Published

  • Deleted

  • Completed

The status values that map to a ‘Not Published’ reported status are ‘Created’, ‘Claimed’, and ‘Unpublished’. The status values that map to a ‘Published’ reported status are ‘Available’, ‘Published’, and ‘Active’. The ‘Deleted’ status value maps to the ‘Deleted’ reported status value, and the ‘Completed’ status value maps to the ‘Completed’ reported status value.

publish_time

The publish_time field for this mart defines when the Course offering was published. This is achieved by looking through the events emitted in the course from the learning environment. Specifically, we look for the earliest event in which the status of the course was modified. If the learning environment being used is Canvas, we look for the earliest event with a ‘Modified’ action and a ‘published’ workflow state. This is a very similar process as how we define the status of a course, except in this case we look for the earliest event rather than the latest, and we only focus on events with ‘published’ workflow states.

num_students

The num_students field defines the number of enrolled students in the Course offering. This number is found from the course_section_enrollment table in UDP’s context store, which keeps track of enrollments in course sections. We count the number of enrollments with a role of ‘Student’ or ‘Observer’ and a role status that is not ‘Dropped’, ‘Withdrawn’, or ‘Not-enrolled’.

published_la

The published_la field in this mart is the number of published learner activities in the course offering. We use the learner_activity table from the context store to compute this field. Using this table, we count the number of learner activities in the course with a status of ‘published’.

unpublished_la

The unpublished_la field is the number of unpublished learner activities in the course offering. Again, we use the learner_activity table from the context store to compute this field. For this field, we count the number of learner activities with an ‘unpublished’ status.

published_quiz

The published_quiz field is the number of published quizzes in the course offering. To compute this field, we use the quiz table from the context store. Using this table, we count the number of quizzes in the course with a status of ‘published’.

unpublished_quiz

The unpublished_quiz field is the number of unpublished quizzes in the course offering. For this field, we use the quiz table in the context store to count the number of quizzes in the course with an ‘unpublished’ status.

active_module

The active_module field is the number of active modules in the course offering. Using the module table in the context store, we count the number of modules in a course with an ‘active’ status.

unpublished_module

The unpublished_module field is the number of unpublished modules in a course offering. We use the module table in the context store to count the number of modules in the course with an ‘unpublished’ status.

Tableau Template Workbook

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

Unizin does not provide active, production support for the visualizations, filters, and aggregations in the Tableau workbooks. They are intended to be used as-is, but modifications are welcome! However, we will provide support related to connecting to source data and any issues with the Bigquery -> Tableau workflow.

Once downloaded, ownership of the workbook is transferred to the user. Unizin does not host the workbook on a Tableau Server instance.

Connecting to Data

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

The metric card shows the number of published and unpublished courses. These metrics help track course setup status and ensure courses are ready for students before the term begins

These course content metrics displays counts of published and unpublished quizzes, published and unpublished learning activities, and active and unpublished modules. These numbers help monitor course content readiness and ensure key learning materials are available and organized for students.

The pie chart shows the percentage of courses that are published, unpublished or deleted. This gives a quick overview of overall course availability and helps identify areas that may need attention.

Course publication timeline chart shows when courses are published in relation to the term start date, focusing on a 30-day window before and after the term begins. It helps identify trends such as how early instructors tend to publish their courses, whether publishing peaks occur close to the start date, or if many courses are published after the term has already started. This insight supports planning and outreach efforts to encourage timely course readiness.

Course design table provides a detailed view of course readiness by showing important information such as the number of students enrolled, number of active modules, courses status (published or unpublished), and the exact date and time the course was published. It helps monitor course setup progress and supports timely intervention if needed.

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 to help with this process; Tableau also has a for replacing data sources. For any issues connecting to source data, please contact support@unizin.org.

Metric Cards
Course Availability Status
Course Publication Timeline
Course Design Statistics
guide document
published doc
UDP marts
this marts page.
Click here to open the interactive chart.
251KB
Course Readiness Dashboard.twb
Course Readiness Dashboard Tableau Template Workbook
mart_course_offering.status
Number of Published and Unpublished Quizzes Metric Cards
Number of Published and Unpublished Learning Activities Metric Cards
Number of Active and Unpublished Modules