Ohio Workforce Supply-Demand Gap Analysis
  • Statewide Overview
  • Career Cluster Analysis
  • Cross-Cluster Analysis
  • Summary of Findings
  • Methodology

Methodology

Overview

Broadly speaking, the workforce supply and demand analysis follows this process:

  • Collect data on education (Supply)
  • Collect data on employment (Demand)
  • Make connections between the two (Crosswalk)
  • Compute the differences (Assessment)

The data sources for the first three elements are listed below, along with details on pre-processing, variable creation, imputation, and other considerations. We also will look at the metrics computed to assess supply-demand gaps.

Supply: Education

Data Sources

Institutions and graduates

U.S. Department of Education National Center for Education Statistics (NCES)

Graduate counts for Ohio’s higher education institutions come from NCES Integrated Postsecondary Education System (IPEDS) reporting1.

IPEDS Institutional Characteristics Directory
A listing of all higher education institutions in Ohio that report data to IPEDS. This includes categorical information on level of degrees offered (less than 2 years, 2 to 4 years, or 4 years or more), control (public, private non-profit, private for-profit), and participation in federal student financial aid programs (Title IV).
IPEDS Completions
Data on degree completions are compiled from the IPEDS Custom Data Files tool. In the current analysis, graduates from school years 2022 through 2024 are combined and averaged to produce an estimate of annual production. The resulting data provides completion counts for each available combination of institution, 6-digit Classification of Instructional Programs (CIP) code, and degree level.

Post-secondary employment outcomes (PSEO)

U.S. Census Bureau

To account for the possibility that graduates may not remain in Ohio for employment following graduation, we adjust graduate counts in the supply calculation based on U.S. Census PSEO Flows data (V4.12.0 2025Q2)2.

Ohio PSEO Flows
A subset of the Census PSEO Flows data for institutions in Ohio. It provides estimates of the rate of graduates found substantively employed in Ohio by institution, degree level, and broad subject area (2-digit Classification of Instructional Programs (CIP code).

Classification of Instructional Programs (CIP) Definitions

U.S. Dept. of Education National Center for Education Statistics

Education programs’ fields of study are defined by the NCES Classification of Instructional Programs (CIP) taxonomy (rev. 2020)3.

CIP Definitions
A searchable list that provides all 2-, 4-, and 6-digit CIP codes (representing broader to more specific academic subject areas, respectively) and their corresponding titles

Data Preparation

Degree completion counts

The IPEDS education data provides degree completion counts for each available combination of institution, 6-digit CIP code, and degree level. The completion counts are averaged from three years of data to produce estimates of annual higher education production.

Degree award levels from the IPEDS completions data is recoded to a smaller set of categories including “Certificate,” “Associate’s degree,” “Bachelor’s degree,” “Master’s degree,” and “Doctor’s or Professional.” The following table summarizes the mapping from IPEDS codes to the degree levels in this analysis.

IPEDS award level Remapped degree level
Certificates of less than 12 weeks Certificate
Certificates of at least 12 weeks but less than 1 year Certificate
Certificates of less than 1 year Certificate
Certificates of at least 1 but less than 2 years Certificate
Certificates of at least 2 but less than 4 years Certificate
Associate's degree Associate's degree
Bachelor's degree Bachelor's degree
Postbaccalaureate certificate Bachelor's degree
Master's degree Master's degree
Post-master's certificate Master's degree
Doctor's degree - research/scholarship Doctor's or Professional
Doctor's degree - professional practice Doctor's or Professional
Doctor's degree - other Doctor's or Professional
Table 1: IPEDS Degree Level Remapping

Aggregations are produced from this data for each of these factors, individually and in combination. Institutions can be aggregated by level (2 or 4 year), control (public or private), or aggregated out entirely for a statewide total. CIP codes can be aggregated to broader levels (2 and 4 digit) or also totaled overall, and degree levels can be aggregated out as well. Further combinations of these aggregations are produced as needed to address analysis objectives.

Adjusting for completers finding employment in Ohio

Because not all degree completers remain in Ohio or find substantive work one year after graduation, we cannot take the full count of completions as the workforce supply. To produce an estimated adjusted count of graduates expected to be found in the workforce in Ohio, we adjust these counts using the U.S. Census PSEO Flows data. This data provides a count of graduates by institution, degree level, and broad subject area, and the number of those graduates found substantively employed in Ohio one year post graduation. Aggregating this data in ways that parallel the aggregations from the IPEDS data, we compute an employed in state rate for each level of aggregation and adjust the degree completer counts accordingly.

Note

At the time of this analysis, the most recent graduation cohorts available from the PSEO Flows data was the classes of 2016 and 2019. In order to avoid the effects of the COVID-19 pandemic on the one-year workforce outcomes for the 2019 cohort, we construct our estimates based on the 2016 cohort. The assumption is that those outcomes are a better proxy for likely outcomes for graduates in the post-pandemic economy than those during the pandemic itself. Future iterations of this analysis will benefit from data generated fully in the post-pandemic era.

Imputations for PSEO Flows data

There are two forms of data imputation that we apply to the PSEO data. First, since the data is reported at the broad 2-digit CIP level, we cannot make more granular estimates at the 4- and 6-digit levels. Thus, the adjustments applied to counts at those finer levels are based on the rates at the broader 2-digit level.

Second, during the period this data was collected, not all institutions in Ohio were available. In particular, no data from private institutions in Ohio was available. The method to produce estimates for these institutions is as follows:

  • PSEO Flows data is matched to the IPEDS degree completions data to determine which institutions have IPEDS completions but not PSEO Flows data, and thus require imputed employed-in-state rates.

  • In these cases, we compute imputations based on the totals of data from comparable institutions. The available PSEO data is grouped by institution level, degree level, and 2-digit CIP code. For each grouping, we calculated the totals for degree completers and those found substantively employed in Ohio one year post graduation.

  • These degree completer counts are aggregated at the same levels as needed for adjustments to completer count data. These rates are then used as the imputed values for programs with matching institution level, degree level, and 2-digit CIP code.

Note

Because the PSEO Flows data for Ohio does not include private institutions, there is no utility in incorporating institution control type (“Public,” “Private not-for-profit,” and “Private for-profit”) into this imputation model. In future analyses, if the private institution data becomes available, this model may benefit from the addition of institution control type.

Demand: Occupations

Data Sources

Employment and employment projections

Ohio Department of Job and Family Services Bureau of Labor Market Information

Our source for these measures is the Ohio Bureau of Labor Market Information 2022-2032 Long-Term Employment Projections4.

Ohio LMI Employment Projections
Total current employment, annual openings (including growth and churn), and annual projected growth by occupation

Occupation wages

Ohio Department of Job and Family Services Bureau of Labor Market Information

To represent the economic value of growth for an occupation, we estimate the total earnings that the growth represents. This is computed by multiplying the quantity of growth by the average wages for that occupation, for which we use Ohio LMI Occupational Employment and Wage Statistics (OEWS) (2024)5.

Ohio LMI OEWS
Mean annual wages per occupation.

Required level of education

U.S. Department of Labor, Employment and Training Administration

Since occupation openings may seek graduates of varying degree levels, we estimate the distribution of typical required level of education per occupation using the O*NET Resource Center database Education, Training, and Experience file (v. 30.1, December 2025)6.

O*NET Education
For each occupation, proportions of that occupation expected to be supplied by each degree level.

Standard Occupational Classification (SOC) definitions

U.S. Bureau of Labor Statistics

Occupations are defined by the BLS Standard Occupational Classification (SOC) system (rev. 2018)7.

SOC Definitions
A searchable list that provides SOC codes at all aggregation levels (major, minor, broad, and detailed) and their corresponding titles, and at the detailed level, a full text description of the occupation

Data Preparation

Employment

There are three key metrics on the employment side of the data: current employment, annual growth, and annual openings. The Ohio LMI Employment Projections data provides all three of these measures for each occupation.

Required level of education

Because job openings for a given occupation title may require different education levels, we wish to account for these variations when connecting occupation data to education. While the LMI projections data does provide the typical entry level education for each occupation, this does not give a sense of how much each occupation might draw from other degree levels.

To offer a clearer picture of the relationships between each occupation and education, we disaggregate the data using the Education, Training, and Experience file from the O*NET Resource Center. This data divides each occupation into 12 different levels of education and assigns a percentage to each. We remap these education levels to align with the other data as follows:

O*NET degree level Remapped degree level
Less than a High School Diploma Other
High School Diploma - or the equivalent (for example, GED) Other
Some College Courses Other
Post-Secondary Certificate Certificate
Associate's Degree (or other 2-year degree) Associate's degree
Bachelor's Degree Bachelor's degree
Post-Baccalaureate Certificate Bachelor's degree
Master's Degree Master's degree
Post-Master's Certificate Master's degree
First Professional Degree Doctor's or Professional
Doctoral Degree Doctor's or Professional
Post-Doctoral Training Doctor's or Professional
Table 2: O*NET Degree Level Remapping

With this remapping, here’s an example of how the proportions are assigned to SOC code 19-1022, Microbiologists:

Degree level Proportion
Other 0.00
Certificate 0.00
Associate's degree 0.09
Bachelor's degree 0.72
Master's degree 0.14
Doctor's or Professional 0.05
Table 3: Distribution of Required Level of Education for SOC 19-1022: Microbiologists

In our model, we apply the proportions to estimate the demand at each degree level. Continuing with this example, if there are a projected 1,000 openings per year for microbiologists, then we allocate that demand to 9 associate’s degree recipients, 72 bachelor’s degrees, 14 master’s, and 5 doctor’s or professional.

Imputations for O*NET Education

Not all occupations are covered in the O*NET Education database, so to provide an estimated allocation of degrees for these occupations, we match the Ohio LMI typical education level required to other occupations in the O*NET data where that degree level has the highest proportion.

The Ohio LMI typical education level is recoded in a similar manner:

Ohio LMI typical education level required Remapped degree level
No formal educational credential Other
High school diploma or equivalent Other
Some college, no degree Other
Postsecondary non-degree award Certificate
Associate's degree Associate's degree
Bachelor's degree Bachelor's degree
Master's degree Master's degree
Doctoral or professional degree Doctor's or Professional
Table 4: Ohio LMI Degree Level Remapping

Occupation wages as economic impact

The Ohio LMI OEWS data provides both hourly and annual wages for each occupation at percentiles including the median, estimated entry-level, and experienced wages, along with the average wage for that occupation.

We use the annual variant of the average wage multiplied by the quantity of employment (whether that be total, growth, or openings, as needed) to create a representation of the total dollar value of that employment. This is not intended to convey estimated immediate effects resulting from changes in either the supply or demand side of employment, but rather a relative measure of economic impact.

Crosswalk: Linking Supply to Demand

Data Sources

Career Clusters

Advance CTE

The Advance CTE National Career Clusters Framework (rev. 2024)8 provides definitions of Career Clusters, Sub-Clusters, and CIP-SOC pairings. These definitions inform the connections between education and occupations within various sectors and industries.

Advance CTE Career Cluster Crosswalk
A complete listing of CIP-SOC pairings along with their corresponding Career Clusters and Sub-Clusters.

Note that by using the CIP-SOC pairings found in this framework we are deviating from a common practice of using the BLS/NCES CIP-SOC Crosswalk9. However, because we are making extensive use of the sector and industry clusters in the Advance CTE framework as units of analysis, it is logical to use the CIP-SOC connections that define those clusters to examine connections between education and employment.

Data Preparation

The Advance CTE framework allows for thematic aggregation of the data into Career Clusters and Sub-Clusters, each of which are defined by sets of pairings between CIPs (education programs) and SOCs (occupations). This framework is thus our key to making connections between supply and demand.

By linking the CIPs (education programs) to SOCs (occupations) , we have the information required to compute gaps between the two. By aggregating this information into Career Clusters, we arrive at a more cohesive picture of the workforce by sector.

We refer to the entire collection of CIP to SOC pairings in the framework as the CIP-SOC crosswalk.

Crosswalk weighting

Because a given CIP may map to multiple SOCs, and conversely a given SOC may map to multiple CIPs, it is important to distribute degree completions across occupations so as to avoid overlapping counts. We do so by producing a weighted CIP-SOC crosswalk, as follows.

We begin with the CIP-SOC crosswalk and join that with the current total employment counts for each occupation, already disaggregated by required level of education (thus each count is defined by 6-digit SOC code and degree level).

For each CIP code and degree level combination, we compute the proportion of total employment for the associated SOC codes, which we label the occupation rate. This becomes our weighting from CIP to SOC. Then, when computing the total supply for a given occupation and degree level, we apply those proportions to the graduate counts for each CIP/degree combination associated with the occupation before summing them.

Conversion rate

There are two important adjustments to degree completer counts when assessing supply for an occupation. One adjustment is for the amount of graduates who remain and find substantive employment in Ohio, the employed-in-state rate, and the other is the amount of those individuals who end up in a specific occupation, the occupation rate. When we combine these we get a measure of how many graduates from a given program end up in a given occupation, and we label this the conversion rate.

conversion rate = employed-in-state rate x occupation rate

This metric gives us a sense of how much changes in production for specific education programs might impact employment in related occupations. We include this measure at higher aggregation levels such as Career Clusters and Sub-Clusters.

Assessment: Measuring Supply-Demand Gaps

Gaps between supply and demand are evaluated based on the difference between openings and graduates, with the number of openings adjusted for the proportion of those openings expected to require some form of higher education, and the number of graduates adjusted by the conversion rate (the employed-in-state rate combined with the occupation rate between programs and occupations). These numbers are aggregated as needed to produce figures at a state level, and by career cluster and institution type.

Gaps are primarily a representation of the current difference between education and employment. To offer a complete picture of overall unmet demand, we combine the current annual gap with projected annual growth.

Footnotes

  1. https://nces.ed.gov/ipeds/↩︎

  2. https://lehd.ces.census.gov/data/pseo_experimental.html↩︎

  3. https://nces.ed.gov/ipeds/cipcode/↩︎

  4. https://ohiolmi.com/Home/Projections/ProjectionsHome↩︎

  5. https://ohiolmi.com/Home/DS_Results_OES↩︎

  6. https://www.onetcenter.org/dictionary/30.1/excel/education_training_experience.html Information from O*NET Resource Center by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license.↩︎

  7. https://www.bls.gov/soc/↩︎

  8. https://careertech.org/career-clusters/about-the-national-career-clusters-framework/↩︎

  9. https://nces.ed.gov/ipeds/cipcode/post3.aspx?y=56↩︎