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

  • Black Disparities in Premature Death

    County Health Rankings has always used Premature Death as a measure in deriving its ranking formula. Years of Potential Life Lost Before Age 75 (or YPLL) counts as 50% of the Health Outcomes score. Every death occurring before the age of 75 contributes to the total number of years of potential…

  • Death Rate Continues to Inch Up

    The mortality (or death) rate increased nominally from 2016 to 2017 going from 844 to 849 deaths per 100,000. This probably is not earthshaking news but based on the overall crude rate, it has actually been increasing since 2009 as noted by the following graph.   Advances in medical care…

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

  • FAFSA Application Volume Down 11%

    The FAFSA Application Volume declined nearly 11% for the application cycles from June 30, 2014 through June 30, 2017 based on data from Federal Student Aid and analyzed using the Financial Aid Interactive. FAFSA application cycles are based on an 18-month period for any one particular school year.  Note the…