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

  • A Look at the New Education Outcome Measures Data

    The new IPEDS Outcome Measures (OM) survey is the first stab at going outside of the traditional first-time, full-time reporting. We took a birds-eye view of this data across the landscape of reporting institutions using a new Graduation Rates Interactive.  A total of 3,838 institutions reported data under the OM…

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

  • Distance Education Rebounds

    Distance Education is now 12.3% of all programs and up 7.6% in 2018 Social distancing, at least for now, is the new normal and along with it comes distance education. Each year we look at what the data is telling us for distance education programs. Last year, I suggested that…

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

  • Is There an Oasis in the New Food Data?

    The recently released updated Food Environment Atlas data by the USDA give us a real glimpse into the progress that we as a nation are making on combating food deserts. The USDA defines food deserts as lack of access to a healthy food retail outlet (a supermarket or large grocery store)…