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

  • What do Sierra Vista and Hinesville Have in Common?

    Sierra Vista, AZ and Hinesville, GA probably don’t seem to have much in common. One is in eastern Arizona and the other is in southeast Georgia. They are both very small cities with populations of around 40,000. What they have in common is a market concentration for computer occupations with…

  • Diving Deeper into Opioid Prescriber Data

    Last week we introduced the new CMS opioid data set and what it means. This data tries to initiate transparency around this hot topical area even though Part D Medicare claims may not be the best proxy of all opioid prescription activity. There are three elements to this data: Part…

  • On Faculty Compensation and Gender Disparity

    It will take many years for the faculty gender pay gap to close at the current rate of change. From 2014 to 2015, women received around half a percent higher pay increase from men over the various institutional sectors. There is still a 16% and 14% gender pay gap for full professors…

  • What are Five Star Hospitals?

    Consumer ratings are always controversial. You can always ask the wrong question or ask the right question the wrong way. In an attempt to shed transparency on our nation’s healthcare system, the Centers for Medicare and Medicaid Services (CMS) instituted the star ratings system. CMS’ star-rating system is meant to…

  • 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…

  • Violence Against Women Offenses Up 9.5%

    This is the third year that the Campus Safety and Security (CSS) data has released separate violence against women (VAW) offenses. This data captures three types of offenses; domestic violence, dating violence, and stalking and analyzes it for both on campus and off campus locations. Overall, there were 16,183 VAW…