Term-over-Term Analysis: Catching Recurring Seat Problems

Term-over-term enrollment analysis is the practice of comparing section-level enrollment data across multiple academic terms to identify recurring patterns of seat inefficiency, such as persistent underfill, repeated waitlist pressure, or chronic section imbalance within multi-section courses. It transforms enrollment analysis from a reactive snapshot into a predictive tool for registrar and academic operations teams.

The most expensive seat problems are not the ones that happen once. They are the ones that happen every term, in the same departments, in the same courses, following the same patterns. Single-term analysis cannot see them.

Why Single-Term Snapshots Fall Short

A single-term enrollment report answers a useful but limited question: what does enrollment look like right now? It can identify underfilled sections, flag waitlist pressure, and surface room-capacity mismatches. These are valuable findings. But they lack context.

When a registrar analyst flags a section of Introduction to Psychology running at 38% utilization, the natural question is: is this new? If that section has run at 35-40% utilization for the last four terms, the problem is structural. It will not fix itself. It requires a different conversation than a section that dipped to 38% for the first time after three terms at 85%.

Single-term analysis treats both situations identically. Term-over-term analysis separates the noise from the signal.

The Cost of Recurring Problems

Institutions running 1,500-3,000 sections per term typically have 8-15% of sections chronically underfilled across multiple terms. These are not random fluctuations. They represent structural overcapacity: too many sections offered for actual demand, term after term.

A mid-size institution with 2,000 sections and 12% chronic underfill is carrying roughly 240 sections that consistently run below viable enrollment. At an average instructional cost of $4,000-6,000 per section, that is $960,000-1,440,000 per year in instructional resources allocated to sections that predictably underperform. Not all of these can or should be cut, but without multi-term visibility, the institution cannot even identify them.

What Recurring Patterns Look Like

Term-over-term analysis reveals several distinct pattern types, each requiring a different response.

Persistent Underfill

A section or course that runs below 50% capacity for three or more consecutive terms. This is the clearest signal that section offerings exceed demand. Common in departments that have not adjusted section counts to reflect enrollment trends from five or ten years ago.

Persistent Imbalance

A multi-section course where one section consistently fills to capacity while another consistently runs at 40-50%. This pattern suggests a scheduling or instructor preference effect rather than a demand problem. The total demand exists, but it is not distributed across sections. Term-over-term data makes this visible by showing that the imbalance is not a one-term anomaly.

Seasonal Waitlist Pressure

Some courses show waitlist pressure only in specific terms, typically fall for freshman-heavy courses or spring for courses that serve as prerequisites for summer internships. Single-term analysis flags the waitlist but does not reveal the seasonal pattern. Multi-term analysis shows that the institution needs additional capacity in specific terms, not across the board.

Gradual Enrollment Decline

A course that drops from 90% utilization to 82% to 74% to 65% over four terms is on a trajectory that single-term analysis might miss until it becomes severe. Term-over-term trend lines catch the decline early enough to intervene, whether through section consolidation, marketing, or curriculum review.

From Reactive to Proactive

The operational difference between single-term and multi-term analysis is the difference between reacting to problems after they occur and anticipating them before the next term's schedule is built.

Reactive: The Single-Term Cycle

1. Term begins. Enrollment data becomes available.
2. Registrar analyst pulls a snapshot and identifies underfilled sections.
3. Analyst reports findings to deans and department chairs.
4. Departments explain or defend current offerings.
5. Some adjustments are made for the next term, but without trend data, the same problems recur.
6. Repeat.

Proactive: The Multi-Term Cycle

1. Before the next term's schedule is built, the registrar team reviews multi-term enrollment trends.
2. Courses and sections with recurring underfill, imbalance, or waitlist pressure are flagged.
3. The conversation with departments starts from evidence: "This section has run below 45% for four consecutive terms."
4. Section planning for the upcoming term incorporates historical patterns.
5. Recurring problems are addressed before they consume resources again.

The proactive cycle does not require more data. It requires the same data organized across time rather than within a single term.

What Data You Need to Start

Term-over-term analysis does not require a massive data infrastructure investment. It requires:

Minimum: Two Terms of Section-Level Data

With two terms, you can identify sections whose performance repeated or diverged. This is enough to start separating one-time anomalies from emerging patterns.

Recommended: Four to Six Terms

Four to six terms (two to three academic years) provides enough data to identify seasonal patterns and confirm that recurring problems are genuinely structural. This is the sweet spot for most institutions beginning multi-term analysis.

Data Fields Required

Each term's data should include, at minimum:

• Course and section identifiers
• Enrollment count
• Section capacity
• Waitlist count (if available)
• Department or college
• Term identifier

If room capacity data is available, it adds a useful diagnostic layer but is not required for core term-over-term enrollment analysis.

Data Consistency

The primary challenge in multi-term analysis is not volume but consistency. Course identifiers, department names, and capacity definitions need to be comparable across terms. If your SIS changed course numbering systems or reorganized departments between terms, that mapping needs to be resolved before meaningful comparison is possible.

Structured import pipelines that normalize column mappings across terms solve this problem once rather than requiring manual alignment for each analysis cycle.

Getting Institutional Buy-In

The most effective way to demonstrate the value of term-over-term analysis is to run it once and present the results. Pull three to four terms of enrollment data, identify the courses and departments with recurring underfill, and calculate the total seat-hours allocated to consistently underperforming sections.

The number is almost always larger than leadership expects. When a provost sees that 200+ sections have run below 50% utilization for three consecutive terms and can attach a dollar figure to that pattern, the conversation shifts from "do we need this analysis?" to "why are we just now seeing this?"

Frequently Asked Questions

How many terms of data do we need before term-over-term analysis is reliable?

Two terms allow basic comparison, but four to six terms provide the reliability needed to distinguish structural patterns from normal fluctuation. With fewer than four terms, you risk flagging temporary dips as recurring problems. Most institutions find that three academic years of data strikes the right balance between depth and manageability.

Should we compare fall-to-fall and spring-to-spring, or sequential terms?

Both, for different purposes. Fall-to-fall and spring-to-spring comparisons control for seasonal enrollment variation and are best for identifying structural trends. Sequential term comparisons (fall to spring to summer) reveal seasonal patterns and help with term-specific section planning. Start with like-term comparisons, then layer in sequential analysis as your team becomes comfortable with the data.

What do we do when we find a course that has been underfilled for multiple terms?

The finding itself is the start of a conversation, not an automatic decision. Persistent underfill may indicate that a course needs fewer sections, a different time slot, or a curriculum review. In some cases, small sections are intentionally maintained for pedagogical reasons. The value of the analysis is surfacing the pattern so that the decision is conscious and informed rather than invisible and repeated by default.