Degrees, Jobs, and Crosswalks

My daughter has a Bachelor’s Degree in Fine Arts with a concentration in Cartooning and Illustration. Today, she is a quality assurance manager for a software company. I am very glad that her career has morphed into a burgeoning field because it was very clear to me that it would be very hard to get a job in her chosen field.

 

Program development requires a knowledge of the jobs that employ them. A “crosswalk” attempts to match up one type of database element to another. That is not always easy because jobs can deploy multiple degrees. A degree can result in multiple jobs and a single job can come from multiple degrees. In database terminology, it is what we call a many to many relationship.

 

We have deployed a crosswalk in Public Insight that matches up jobs by Standard Occupational Classification (SOC) to degrees awarded by Classification of Instructional Programs (CIP). To find which jobs are moving which degrees, we created a treemap visualization in Tableau Public , which you can access by clicking HERE. The degrees awarded need to be looked at proportionately and a treemap is perfect for this. You can select the individual job codes by six digit SOC code and see proportionate degrees to other SOC codes. For example, we plotted all managerial jobs which begin with SOC code 11 and find Industrial Management jobs are almost three times more relevant in degrees awarded than Computer and Information System Managers. To interact with the Tableau visualization, click HERE.

 

 

 

Share This Story

Similar Posts

  • The Race for Nurses

    There is a race that is brewing between millenials who are becoming registered nurses and the hiring that has started at U.S. hospitals. A Health Affairs study concluded that Millennials are becoming registered nurses at nearly twice the rate of baby boomers, but that still won’t necessarily prevent a nursing shortage…

  • What the Ascension – Presence Merger Reveals

    This week, Ascension Health acquired Presence Health, combining the largest Catholic-sponsored healthcare system in Illinois with the nation’s largest Catholic health system, the companies announced Tuesday. The acquisition is subject to regulatory approvals. The deal underscores a continued trend towards market consolidation.    It seems Ascension, at 141 hospitals, acquiring an…

  • Outpatient Medicare Hospital Costs up 13%

    The 2016 outpatient procedure data shows overall hospital volume up 11% from 2015. Using data from the Outpatient Procedure Analysis Interactive, we also found that the volume times the average full cost (weighted average cost) on a procedure basis has increased 13.3%. We ran the numbers several ways – first…

  • Regional Disparities in Health Insurance

    We all know that health insurance is a moving target. According to the most recent ACS survey data, the national uninsurance rate declined from 13.0% to 11.7% in 2016. Public insurance coverages increased slightly more than private coverages (increases of .9% and .6%) respectively. This change was short-lived as Gallup…

  • Friendly Skies Just Got Friendlier

    Airlines have taken it on the chin in recent months for bad customer service. This despite the fact that overall customer service rankings of the airline industry are up. Flight attendants received nearly a 14% bump in pay based on a comparison of mean wage data from the 2016 Occupational…

  • Hot Growth Industries

    The building boom is officially back after a long hiatus. The number of construction employees increased 5% in 2016 according to the most recent County Business Patterns released by the U.S. Census.  The sector however with the most number of new establishments is the Information sector (NAICS 51) which increased 5%….