RPG New Dashboard Release: Time Schedule Course Enrollment Trends and Details

October 7, 2022

The Enterprise Reporting and Analytics team with the collaboration of the Report Prioritization Group released the newest addition to the BI Portal: Time Schedule Course Enrollment Trends

What is the Time Schedule?

The UW Time Schedule application lists credit classes offered at the University of Washington. The UW Time Schedule is updated daily and includes the following information and more:

  • Status of courses
  • Times, days, or locations of courses
  • Instructors for all courses
  • Section types (Lecture; Lab; Quiz; etc.)
  • Learning types (Hybrid; All On-Line; No On-Line Learning)

The Enterprise Data Warehouse (EDW) imports data from the UW Time Schedule system into the [UWSDBDataStore] database. From here the data is used to support the Time Schedule Information report, Time Schedule Enrollment by Day and Time dashboard, and this most recent dashboard, Time Schedule Course Enrollment Trends, on the BI Portal. All data is refreshed daily.

How-To:

First, use the Select Measure: filter to choose a statistic that you want to analyze:

When selecting  data in any of the multi-select filters, select a value(s) of your choice and click the Apply button to execute the filter:

For additional information visit the Interpretation tab for the Time Schedule Course Enrollment Trends dashboard.

Optimization hint: To improve page load time, pre-select the lower level filters (Campus, College, Department, etc.) first before selecting the (All) value under the Year Quarter filter.

Users and Use Cases:

The primary users of  Time Schedule data  are  the Registrar’s Office, Time Schedule “Constructors,” the academic advising community, Program Coordinators, and department administrators working on faculties’ tenure reviews. The Time Schedule dashboards facilitate answering many  business questions. Following are real business questions from our data user community:

Student Enrollment / Credit Hours:

  1. For any course section, what do the current student enrollment / student credit hours counts look like for x number of years?
  2. For any course section, what do the census enrollment / student credit hours counts look like for x number of years?

Course:

  1. For any course section, can you display its School / Department / Curriculum (Responsible Curriculum Dept.) / Course Title / Course Section and Course Credits data elements?
  2. What is the section type for a given course section e.g. ‘Lecture” , “Independent Study” etc.?
  3. Is the course section instruction delivered on-line? If so, does it belong to one of the categories such as: ‘All Online’, ‘Hybrid’, ‘Enhanced’, ‘No Online Learning’?
  4. Is the course section instruction delivered as distant learning? If so, does it belong to one of the categories such as: ‘Pre-Recorded (not Internet courses)’, ‘Correspondence (Print)’, ‘Internet’ ,’Interactive Television Technologies (not Internet courses) ‘, ‘Broadcast (not Internet courses)’ , ‘No Distance Learning’?
  5. Is there a course fee required for a given course section, and what type it is?
  6. What is a course’s enrollment status? Is it ‘Open, ‘Closed, ‘Withdrawn’, ‘Suspended’?

Space:

  1. For any course section, what is its time schedule limit estimated enrollment?
  2. For any course section, what is its space availability (the difference between joint enrollment limit and current enrollment)?
  3. For any course section, what is its space availability (ratio: current enrollment / joint enrollment limit)?
  4. What is the unmet course section request, meaning, how many students are denied registration entry into the course section due to space availability or for any other reason?

Instruction Time:

  1. When does a course section occur during a week (for instance: ‘Monday’, ‘Wednesday’)?
  2. At what time does a course section start and end, and at what location?

Questions?

If you have questions about the meaning of any of the business terms in these questions, or other business terms, you can explore these terms and get more information in Knowledge Navigator.

As always, if you have any questions, please write to help@uw.edu with  “BI Portal: Time Schedule Trends and Details Dashboards” in the subject line.

Thank you

Thank you to all those with the ERA team and the RPG who made this release possible. In particular, the following UAT (user acceptance testing) users from the RPG contributed their valuable feedback and Time Schedule expertise.

  • Nell Gross – Geography department academic adviser
  • Joe Kobayashi – Marine Biology department academic adviser
  • Dori Bloom – analyst in the College of Arts and Sciences, Dean: Business Office
  • Matt Winslow – Sr. Associate Registrar in the University Registrar Office