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

  • Distance Learning Growth Continues

    In one of my favorite videos of my kid’s era, Grover from Sesame Street taught us the difference between near and far. I don’t think Grover had in mind today’s high tech tools and social media interaction when he taught us this principle. Distance Education continues to be a hot…

  • Powerball and Endowment Wealth per Student

    Large dollars tend to attract many of us. That is why the Powerball attracted so many people at the tidy sum of 1.3 billion. Yet the larger the number, the more people participate. Someone had the brilliant idea of distributing Powerball winnings to everyone in the country thinking it would…

  • COVID-19 Dashboard with NYT Data

    Analyze COVID-19 Cases by National, State and County Level It is important for today’s business leaders to consider the impact of COVID-19 when making decisions and allocating resources. The accuracy of COVID-19 data reported by news sources and online publications goes beyond the numbers themselves, the interpretation of the statistics…

  • Maternal Care and Rural Counties

    An interesting study published in the September issue of Health Affairs found that 9 percent of rural counties experienced the loss of all hospital obstetric services in the period 2004–14. In addition, another 45 percent of rural US counties had no hospital obstetric services at all during the study period. We…

  • How Healthy Are U.S. Hospitals?

    If we said that 20% of any industry was at financial risk, we would all be up in arms. However, a recent Morgan Stanley report citing that statistic was met with some degree of yawning. The report cites that 450 hospitals are at risk of closure and another 600 are…