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

  • Infection Procedures Top Inpatient Volume Growth

    While Medicare inpatient procedure volume has remained flat since 2013, infections are a significant area of high volume change. The treemap below from the Inpatient Procedure Analysis Interactive shows the inpatient volume growth by procedure with color coding by volume change from 2013-2015 using the Medicare Provider and Analysis Review…

  • Student Earnings Experience a Sluggish Recovery

    College students are earning 8% less in 2013 than in 2008 per the most recent data published by the US Department of Education College Scorecard database. Students earned $31,382 in 2013 compared to $34,119 in 2008. The earnings were ostensibly flat from 2012 earnings of $31,528.   The College Scorecard…

  • Income Inequality Marches On

    Welcome to 2018!  We are making some fundamental shifts to our Weekly Insights which I hope you will enjoy.  We are moving our content towards more video and free self-service analysis around our weekly topical theme. We welcome your feedback and your ideas.    Over 70% of population health is…

  • Are Outpatient Imaging Quality Measures Effective?

    CMS began developing measures evaluating imaging efficiency back in 2007. These performance measures have been distributed as part of Hospital Compare for the past four years. Lower percentages suggest more efficient use of medical imaging. The purpose of reporting these measures is to reduce unnecessary exposure to contrast materials and/or…

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