This tutorial addresses how to find in-demand programs that colleges or universities should consider offering and to identify which occupations may have a “gap” in training demand. By first finding good jobs in your region based on growth and wages, we can then look for training opportunities for those jobs that aren’t being provided. In this example we’ll focus on training opportunities that a typical community college could provide.
- Click Research Occupations
- Click Occupation Table
- Under ‘Select Occupations’, choose All Available
- Under ‘Select a Region’, enter your county, state, or other region
- Click Custom Data Selection and select the following:
- Under ‘Jobs’, Start Year, End Year
- Under ‘Change’, Jobs Change, % Jobs Change
- Under ‘Openings’, Annual Openings
- Under ‘Earnings’, Avg. Hourly Earnings
- Under ‘Education’, Typical Entry Level Education, Regional Completions
- Click Select
- Click Run
- In the options bar on the left-hand side of the screen, under ‘Timeframe’, select the past 4-5 years. In this case we’ll do 2010-2014. Why aren’t you using projections here?
- Under ‘Class of Worker’, select Employees
- At the top of the table, click Filter
- Select 2010-2014% Change from the first menu
- Select greater than or equal to from the second
- Enter the growth % you’d like to filter for. We’ll do 5% here.
- Click +Add Filter
- Repeat the process to add the following filters:
- 2013 Avg Hourly Earnings >> greater than or equal to >> [a good wage for your region]
- Typical Entry Level Education >> greater than or equal to >> Some college, no degree
- Typical Entry Level Education >> less than or equal to >> Associate’s Degree
- Click Apply
Your list should be manageable at this point. The difference between the annual openings and the completions is the gap (Gap Analysis) between education and training in the region. Scan the list for occupations with more Annual Openings than Regional Completions. You’ve identified growing, high paying jobs in your region where the demand is surpassing the supply of trained workers from colleges. These represent areas of possible opportunity for more training options in the region. Now we’ll look at the programs that typically train for these jobs.
- From the Occupation Table, select an occupation with more openings than completions.
- In the menu above the table, click Jump To > Occupation Overview
- Scroll down to ‘Occupational Programs’ and click Jump to Full Report
The Occupational Programs report shows you how many different programs are in your region that train for this occupation, as well as which institution currently offers which program. Under ‘Programs by Institution’, check the award level being offered at each school. It may be the case that a program is offered at the associate’s level at a neighboring university, but your college is considering offering a quicker certificate program.
 Projections are based on historic trends carried forward. It’s perfectly acceptable to use projections in this scenario to look at the next 5-10 years, but the historic context is key to understanding why projections are up or down for a given occupation.