Instructional Measures: Data and ProjectionsMaury PearlAssoc. Dean, Institutional Research & PlanningLos Angeles Mission College

Overview of Data SystemData files used: D9500 (schedule of classes)Standard Course Hours (Course_Subject)Census FTES and Enrollment (CEN_RDB)Instructor Load (CSUBJ.DBF from Sched4)Pay Rate (salary distribution mtempsdx.dat)Reference file (database corrections)

Overview of Data System (cont’d)

Uses a SAS (Statistical Analysis System) computer program to:

Identify combined classes

Identify coding problems (regular, hourly)

Join/Match data files

Perform calculations

Generate reports (handout)

FTEF / Cost Calculation

Calculates FTEF based on standard course hours and discipline teaching load.

Allocates FTEF across combined sections.

Incorporates coding corrections.

Calculates instructional cost using instructor specific pay rates, applying pay rate formulas for hourly (pay by class) and regular faculty.

FTES Calculation

Uses attendance accounting data (CEN_RDB) to obtain FTES for each section.

Converts FTES to WSCH Equivalent (WSCH Equiv = FTES x 525) / TLM, where TLM is the term length multiplier (e.g., 16.5).

Projected FTES

Based on instructional measures from data system.

Projection method focuses on fill rate concept: percentage of seats filled at census (census enrollment divided by class limit).

Projected Enrollment = Seats x Average Fill Rate.

Fill rate is calculated at section level. Then aggregated to discipline level over two semesters to get average fill rate by discipline.

FTES Projection (cont’d)

Projected Enrollment converted to FTES using formulas based on accounting method (for DSCH and WSCH). PA uses modified formula or projects from prior year FTES.Projection Method Accounts for:

Differential of section offerings (seats) by discipline

Differential fill rates (average class size) by discipline

Optimization of Projected Schedule

Schedule can be optimized by establishing targets for average class size (WSCH/FTEF)

Target FTEF = (Projected WSCH Equiv) / (Target WSCH/FTEF)

This is the FTEF that, for the projected WSCH Equiv, would attain the target WSCH/FTEF ratio.

Target fill rate is similar to target average class size (and target WSCH/FTEF).

Using historical data, compare target FTEF to actual FTEF, to determine changes in FTEF and instructional cost.