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

  • Using AI to Break Down Head Count

    New Microsoft® Power BI Visual Dynamically Analyzes Categorical Data Like fashion goes in and out of style, so do visual ways of exploring data. Several decades ago I worked with a visual called the Decomposition Tree from an upstart company Proclarity from Boise, Idaho to analyze multi-dimensional data. That company…

  • 12 Colleges with Sustained Enrollment Growth

      According to data collected from the Integrated Postsecondary Education Data System (IPEDS), 60.6% of colleges experienced flat or declining enrollment growth while only 39.4% experienced increasing enrollment growth from 2013-2014. This is also very consistent with statistics from 2012-2013.   College enrollment growth may be hard to sustain and…

  • Student Financial Aid up 6.2%

    Postsecondary institutions gave over $17 billion in financial aid in 2015. This represented a 3% increase from 2014. However, the number of student receiving the financial aid declined 3% so the average financial aid per student when looked at over the entire postsecondary landscape actually increased 6%. We used data…

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

  • Is the Federal Work Study Program Working?

    Over 4,000 institutions participate in the Federal Work Study Program. This program provides funds for part-time employment to help needy students finance the costs of postsecondary education. For the fiscal year ending June, 2016, $1.16 billion was paid to students under this program. This was roughly the same as the…