1 / 64

Roger Mourad Institutional Research Dept Washtenaw Community College

Use of Online Sources to Compare Supply of Graduates to Demand for Workers. MI-AIR November 7, 2013. Roger Mourad Institutional Research Dept Washtenaw Community College. I. Data Sources: some places you can go online II. Application of their use. I. Data Sources. I. Data Sources.

irina
Download Presentation

Roger Mourad Institutional Research Dept Washtenaw Community College

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Use of Online Sources to Compare Supply of Graduates to Demand for Workers MI-AIR November 7, 2013 Roger Mourad Institutional Research Dept Washtenaw Community College

  2. I. Data Sources: some places you can go online II. Application of their use

  3. I. Data Sources

  4. I. Data Sources O’Net, American Job Center 2. Dept of Technology, Management, and Budget, State of Michigan 3. Bureau of Labor Statistics, U.S. Dept of Labor 4. US Census Bureau, Quarterly Workforce Indicators 5. Labor Insight, Burning Glass 6. Michigan Community College Network (supply)

  5. 1. O-Net American Job Center • http://www.onetonline.org/find/ • to identify SOC code(s) related to an occupation • to research a variety of qualitative data related to an occupation

  6. http://www.onetonline.org/find/

  7. 2. DTMB Data Explorer • http://www.milmi.org/ • Economic Forecast Region (local level) • -Long term Occupational Projections

  8. Raw data file portion (need to request from DTMB)

  9. Projected Employed, local and SE MI

  10. 3. BLS Occupational Employment Statistics • http://www.bls.gov/ • semiannual mail and phone survey of employers conducted by state workforce agencies • covers all metropolitan and nonmetropolitan areas nationally, all industries, of varying sizes

  11. One Use of OES data: • represent change in employment over time in a given MSA region • although the survey is conducted every year, the values for a given year are a weighted average taking the two previous years into account • so best to use the data in 3 year increments • download raw data files

  12. Raw data file portion, Washtenaw County, Total Employment 2012

  13. Chart showing change in estimated #employed, 2006, 2009, 2012

  14. Another use of OES data: • to identify the industry employing the largest number of individuals in a given occupation nationally • use the percent of industry employment to estimate percentage of new hires locally (Census QWI data) • (Network Admin example)

  15. QWI : Industry Group Selection

  16. Industries employ network admin: Largest is Computer Systems Design and Related

  17. 4. US Census Bureau, Quarterly Workforce Indicators • http://ledextract.ces.census.gov/ • Data Extraction Tool • Estimated Number of New Hires (# of individuals who started a new job) and other employment indicators by metropolitan region (using actual UI record data) • New Hires = number of individuals who were reported to be employed in a quarter who were not employed by that same employer in any of the previous 4 quarters

  18. US Census Quarterly Workforce Indicators (QWI)

  19. QWI: geographical region selection

  20. QWI Industry Group selection page

  21. QWI Indicators selection page

  22. 5. Labor Insight Burning Glass • http://laborinsight.burning-glass.com/us/ • Job postings searchable by many dimensions • Occupation, education, location, time period, experience, among others

  23. Labor Insight Main Screen

  24. Sample Query results: Detroit-Warren-Livonia MSA

  25. Sample Query results: Auto Body, Auto Mechanic, Washtenaw County

  26. Employers with most postings, Auto Mech

  27. Skills in greatest demand in postings, Auto Body

  28. Distribution of experience requiremts in postings, Auto Body

  29. Educational requiremts in postings, Auto Body

  30. 6. Michigan Community College Network http://www.michigancc.net/ • number of awards by college and program

  31. MI CC Network, Search for Awards Main Screen

  32. Sample Results, Washtenaw CC Network Admin

  33. Link Programs to Occupations 1. Use federal crosswalk to match Classification of Instructional Programs (CIP) codes to BLS Standard Occupational Classification (SOC) codes http://www.bls.gov/soc/soccrosswalks.htm 2. Matched CIP codes to WCC program codes (WCC crosswalk)

  34. CIP to SOC crosswalk information and download http://nces.ed.gov/ipeds/cipcode/resources.aspx?y=55

  35. CIP to SOC crosswalk conversion file (portion)

  36. Computer Network Admin and Support CIP codes 11.0901 and 11.1002 SOC codes 15-1142 and 15-1152

  37. Example of CIP to SOC Matching CIP Computer Systems Networking and Telecommunications Computer and Information Systems Security/Info Assurance SOC Network and Computer Systems Administrators Network Systems and Data Communications Analysts WCC Computer Networking Academy (C) Computer Networking Operating Systems (C) Computer Networking (A) Foundations of Computer Security (C) Network Security (C) Computer Systems Security (A)

  38. Sample page from WCC report (created by WCC research dept using MS Access)

  39. II. Application

  40. II. Application Demand Supply Analysis Example : Computer Network Admin

  41. 1. Demand 2. Supply 3. Analysis/Assessment

More Related