Course Offerings Index Report

Melody Quinn

August 15, 2022 15:37

Overview

You can access the Course Offerings Index report from the Schedule Refinement/Course Offerings folder in the Report App. The report offers a high-level view into course fill across various categories and provides different ways to splice data based on enrollment ratio and overloaded, underutilized, or balanced courses. Underlying course and section level details can be accessed through this report by using the “jump to” functionality in each widget. The filtering capability allows a user to look at this data by many different categories, all the way down to individual courses.

This report is refreshed alongside the client's import schedule. In this model, if census enrollment is configured, it will be used for enrollment calculations unless actual enrollment is higher than census. “Seats” values reflect section maximum enrollment values unless the “projected enrollment” alternative is configured.

Filters

Filters default to ‘all’ of that category unless otherwise noted.

Years (default: next year and past 5 years)	Course
Term (default: all terms occurring in the next year and past 5 years)	Subject
Campus	Division
College	Department
Fill Category

Fill Category Filter Definitions

Overloaded: Enrollment Ratio Greater than 95%
Underutilized: Enrollment Ratio less than 70%
Balanced: Enrollment Ratio greater than or equal to 70% and less than or equal to 95%
Undefined: Course seats are equal to zero

Color Coding

The colors on all widgets indicate fill rates that are consistent throughout the report and drill-ins.

Green = Balanced

Enrollment Ratio greater than or equal to 70% and less than 95%

Yellow = Underutilized

Enrollment Ratio less than 70%

Red = Overloaded

Enrollment Ratio greater than 95%

Enrollment Ratio By Year Widget

The Enrollment Ratio By Year widget is a stacked bar graph that shows enrollment ratio by year, with trendlines for the course and section count. With no filters applied, it will show all institutions' courses grouped by the year. The bar will show enrollment to max enrollment as a percentage of the total as indicated on the left side y-axis.

The widget is interactive and will filter the rest of the report to a particular year when selected. Likewise, this widget is affected by all other filters set in the report.

Colored Bar

At the bottom of the stacked bar chart is actual enrollment. With no filter, it will show all enrollment for all courses for the year on the x-axis. The color of the bar will indicate whether that year is overall underutilized, overloaded, or balanced.

Grey Bar

The top of the stacked bar chart shows how many seats are not filled by enrollment based on the maximum enrollments assigned to each course.

Orange Trend Line

The orange trend line shows the total number of courses offered per campus each year. Courses are counted by their distinct course campus offering. This is because a course may fall into two different fill categories depending on the campus where they are offered. Therefore, if BIOL 100 is offered on campus A and campus B, the course will be counted twice.

Blue Trend Line

The blue trend line shows the total number of sections offered per year.

Drill-in Capability

Right-click on a bar of the chart in order to “Jump To” the Enrollment Ratio by Term Drill-in. This action will open up a pop-up report that displays the Enrollment Ratio for the terms included in that bar. Enrollment Ratio is grouped by Term and by Part of Term. The pop-up report will inherit all filters previously selected on the main Course Offerings Index report. To reset filters, select the refresh icon at the upper left filters pane.

Left-click Menu

Select
- Right-click on the desired year. All the other widgets on the report will change to reflect the year only. The other bars on the Enrollment Ratio by Year widget will still be visible but underemphasized. The Year filter on the left will change to the year selected only.
- To clear out a Year Select:
  - Go to edit pencil on the left pane for the year filter.
  - Select all the years to get the widget back for the past five years change.
Jump to ‘Enrollment Ratio by Term’
- Clicking this option will open a pop-up window for the Enrollment Ratio by Term Drill-in.
- All filters selected on the Course Offering Index report will be inherited and applied to the pop-up report.
- To go back to Course Offering Index, click anywhere outside the pop-up window.

Course Breakdown Widget

The Course Breakdown widget is a pie chart that shows the percentage of courses that are underutilized, overloaded, balanced, and undefined.

Widget Interaction

Clicking any section of the pie will change all other widgets in the report to view only the courses that are categorized as the selected pie section*.

When one of the slices of the pie is chosen, it will slightly separate from the rest of the pie chart to indicate that that slice is selected.
To return to seeing all slices in the report, click the ‘clear selection’ icon on the heading of the widget or right-click and ‘unselect’.
*This selection will not filter the Term Details table widget, since this table already has columns to report on courses in each course fill category.

Drill In Capability

Right-click on any slice of the pie in order to “Jump To” the Course Details Drill-in.

Select/Unselect
- This will select or unselect the slice of the pie that was selected. All other widgets in the report will be affected by this action.
Jump to ‘Course Details’
- Clicking this option will open a pop-up window with the Course Details Drill-in.
- All filters selected on the Course Offering Index report will be inherited and be applied to the pop-up window.
- To go back to Course Offering Index, click anywhere outside the pop-up window.

The Standard Deviation of Seats widget is a bar chart that shows the standard deviation of seats offered to highlight large differences between categories. The visual defaults to campus, but can be changed to other category groups.

Enrollment Ratio By Campus Widget

The Enrollment Ratio By Campus widget is a horizontal bar chart that shows the enrollment ratio. By default, the chart is grouped by campus, but can be changed to other category groups by right-clicking on the bar:

Campus	Instructional Method
College	Meeting Type
Department	Part of Term
Subject Code

Drill-in Capability

Right-click on any bar on the chart in order to “Jump to” the Course Details Drill-in.
The category selected will filter the pop-up report to the selected category.
To refresh this filter selection, click the refresh button at the top left corner of the filter pane.

Categories: changing the category on this widget will not alter any other widget on the report, but will change the grouping mechanism of the enrollment ratio. Available categories.
To go back to default, click on the ‘clear selection’ icon on the heading of the widget.
Jump to ‘Course Details’
- Clicking this option will open a pop-up window with the Course Details Drill-in.
- All filters selected on the Course Offering Index report will be inherited and be applied to the pop-up window.
- To go back to Course Offering Index, click anywhere outside the pop-up window.

Term Details Table

The Term Details widget is a pivot table that shows term details and other aggregated data by term.