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

  • March Madness and the Top Line

    Everyone has caught March Madness fever. The first two rounds of this landmark tournament sparked more double digit seed upsets than any other year. Yet as we sit here for the sweet 16, all of the number one seeds advanced. It is no surprise to anyone either that NCAA basketball…

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

  • The Debt Service Cost of PLUS Loans

    Last week, we observed that the PLUS loan program continues to escalate both in terms of dollars borrowed and in terms of recipients. Using the newly published Financial Aid Interactive, we projected the number of dollars borrowed by PLUS loan borrowers will increase 1.25 billion for the year ending June,…

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

  • Distance Education Programs Growth Up 18%

    After a few weeks break, we are back with this week’s edition of the Insight for Education blog. In my previous blog on distance enrollment, we cited that distance enrollment exclusive growth was up nearly 15% and more and more schools were offering distance education. In this analysis we wanted…

  • New Violence Against Women Data on Campuses

    A slug of new data has recently been released covering campus statistics on violence against women. This data was mandated by the Violence Against Women Reauthorization Act of 2013 (VAWA) and is added to numerous other statistics required under the Campus Crime Statistics Act, or Clery Act. College institutions must…