1 of 32

1

How to Calculate a Gap Analysis? (DAY 2)

February 21, 2025

2 of 32

COE Bay Region Team

coe.baccc.net

2

3 of 32

Centers of Excellence (COE) for Labor Market Research

Serves 28 community colleges in the 12 county Bay Region with labor market information and workforce research

9 regional COEs across the state

Bay Region COE hosted at Cabrillo Community College

Bay Region COE: coe.baccc.net
Statewide COEs: coeccc.net

3

4 of 32

Labor Market Data 101: An Introductory Webinar Series for Community College Members

Session 1 – 2/7/25

How do TOP, CIP, and SOC Codes Connect Programs to Jobs?

Session 2 - 9/15/2021

Lorem ipsum dolor sit amet
Sed do eiusmod tempor incididunt ut labore

Session 2 – 2/21/25

Session 3 – 2/28/25

How to Calculate a Gap Analysis?

How to Read a Labor Market Information Report?

4

5 of 32

Today’s Agenda

Session 2 – 2/21/25

What do TOP, CIP, and SOC codes mean and what are they for?
What is the labor market demand?
What is the educational “supply?”
What is the Gap Analysis?

5

6 of 32

Let’s get to know each other

Zoom Survey Questions

Did you attend Day 1 (2/7) webinar?
Are you familiar with TOP, CIP, and SOC Codes?
How would you rate your experience with labor market data? Very experienced, Somewhat experienced, No experience
How would you rate your experience calculating the Gap Analysis?

Very experienced, Somewhat experienced, No experience

6

7 of 32

The Gap Analysis

Demand - Supply

Do we have enough students graduating with the certificates and degrees needed to meet the labor market demand?

Demand (SOC)-Supply (TOP & CIP)= “Undersupply” OR “Oversupply?”

# of Openings - # of Graduates=

Ideally it should be close to zero

7

8 of 32

What does TOP, CIP, and SOC Codes mean?

Taxonomy of Program (TOP) Codes are unique to California Community Colleges. They are utilized to report information on programs and courses with similar outcomes, to identify similar programs and their alignment with the labor market

Classifications of Instructional Programs (CIP) Codes are nationally utilized in higher education institutions to support and track fields of study and programs. facilitate the alignment of similar programs offered by 2- and 4-year postsecondary institutions with the needs of the labor market. There are more CIP Codes than TOP codes.

Standard Occupational Classification (SOC) Codes are used nationally to classify and categorize occupations by the U.S. Bureau of Labor Statistics (BLS) to provide framework for organizing and analyzing occupational data with various other datasets.

8

9 of 32

Demand: Industries & Occupations

9

Sector

Industries

Occupation

Data

Sector

Industries

Sector

Industries

Sector

Industries

Frameworks

CCCCO

CDE

NAICS

Framework

SOC

10 of 32

12 Sectors in California Community College

10

Agriculture, Water & Environmental Technologies

Global Trade

Business & Entrepreneurship

Energy, Construction & Utilities

Education & Human Development

Health

Life Sciences/Biotech

Retail, hospitality, and Tourism

Information & Communication Technologies (ICT)/ Digital Media

Advanced Manufacturing

Public Safety Career Cluster

Advanced Transportation & Logistics

11 of 32

Demand Data Includes (2023-2028):

Current
Projected

By Occupation

Current Demand:

Current employment
Current job openings

Projected Demand:

Projected change in openings

(new jobs + replacement openings)

Projected average annual openings
Projected growth in new jobs (% change)

11

12 of 32

SUPPLY

12

In labor market terms, this refers to the number of individuals - both qualified workers and trained students - who are available to fill job openings in the labor market.

How do we find “supply data” on the number of students at community colleges and other training providers who have completed programs (certificates and degrees) by region?

13 of 32

Demand and Supply Dashboard

Bit.ly/COE_DemandSupply

13

14 of 32

Example

Top Code 0614.60 – Computer Graphics and Digital Imagery Programs

Bit.ly/COE_DemandSupply

Demand and Supply by Bay Region or Subregion

14

15 of 32

The Gap Analysis

15

Demand = Job Openings

Supply

= Workers

What is the Gap?

Supply- Number of Graduates
College Programs	# of Completers
TOP-Computer Graphics and Digital Imagery	69
CIP-Computer Graphics	162
	231

Example: TOP Code 0614.60 Computer Graphics Program

In the Bay Region, are we graduating enough students to meet the labor market demand?

16 of 32

The Gap Analysis

16

Demand = Job Openings

Supply

= Workers

What is the Gap?

Demand-Job Openings
Occupations	Avg. Annual Openings
Computer Program	490
Graphic Designers	800
Special Effects	320
	1610

Supply- Number of Graduates
College Programs	# of Completers
TOP-Computer Graphics and Digital Imagery	69
CIP-Computer Graphics	162
	231

Example: TOP Code 0614.60 Computer Graphics Program

In the Bay Region, are we graduating enough students to meet the labor market demand?

17 of 32

The Gap Analysis

17

Demand –Supply

1,610-231=1,379

What is the Gap?

Demand-Job Openings
Occupations	Avg. Annual Openings
Computer Program	490
Graphic Designers	800
Special Effects	320
	1610

Supply- Number of Graduates
College Programs	# of Completers
TOP-Computer Graphics and Digital Imagery	69
CIP-Computer Graphics	162
	231

Example: TOP Code 0614.60 Computer Graphics Program

In the Bay Region, are we graduating enough students to meet the labor market demand? ANSWER: No, we are not, there is an “undersupply”

18 of 32

Bit.ly/COE_DemandSupply

18

bit.ly/COE_DemandSupply

19 of 32

Bit.ly/COE_DemandSupply

19

bit.ly/COE_DemandSupply

20 of 32

20

Supply for Computer Graphics and Digital Imagery is 69 Community College Students

21 of 32

TOP-CIP Crosswalk

21

This depends on the details of your program. Is it focused on graphics, software, or media?

22 of 32

22

Supply for Computer Graphics consists of 162 students from other colleges.

23 of 32

The Total Supply

23

TOP Code 0614.60 – Computer Graphics and Digital Imagery Programs

CIP Code 11.0803 – Computer Graphics

69 Community College Students and 162 students from other colleges = Total 231

24 of 32

TOP-SOC Crosswalk

24

25 of 32

TOP-SOC Crosswalk

25

Select the occupations (SOC codes) that best align with your program. Based on your program, what occupations are your students most likely to pursue?

26 of 32

Demand Data

26

27 of 32

Demand Data

27

Demand 1,610 (or Number of Average Annual Job Openings)

28 of 32

The Gap Analysis

Demand – Supply

1,610-231=1,379

28

29 of 32

Activity:��Demand and Supply � �(10 minutes)

Bit.ly/COE_DemandSupply

Select one program
Identify the occupations related to that program
Calculate the gap analysis

Remember to focus on Bay Region or Subregion data, but it has to be the same for Demand and Supply data.

29

30 of 32

Gap Analysis- Self Reflection

Based on today’s training, please answer the following questions:

Are you able to find the supply for your given program?�Are you able to find the demand for the occupations related to your program?
How will you implement the "gap analysis” in your work?
What challenges do you anticipate in conducting gap analyses?

30

31 of 32

Acronym Dictionary

NAICS Codes: The North American Industry Classification System (NAICS) is the standard used by Federal statistical agencies in classifying establishments for the purpose of collecting, analyzing, and publishing statistical data related to the U.S. business economy.

CCCCO Industry Sectors: California Community Colleges have prioritized 12 industry sectors based on regional opportunities for high-growth, high-wage careers.

CDE Industry Sectors: The California Department of Education has prioritized 15 industry sectors with multiple career pathways in which to develop Programs of Study. School districts determine which sectors and careers can best serve students, industry and the local community.

31

32 of 32

2/24 Office Hour: 1 -2 pm

Gap Analysis�Join Zoom Meeting�https://cabrillo-edu.zoom.us/j/87458831754

32