Course to Career Pathfinder

Many university students enroll in degrees yet don't know which career paths align with what they study. App brings a clear understanding of what courses match careers that are posted on websites.

Comment

Inspiration

I am a young African girl who grew up with awareness that I could make impact in my socety. However the envronment I grew up in did not support me in acknowledgng what unveristy course I was tuned into . In high school we would rarely get career sessons and if we got them they were so shallow and my fellow students did not take it seriously. Upon graduating I got a chance to be mentored by my mother's colleague who went through all courses offered by the Kenyan government whch aligned wth my grades. I felt quite relieved and got a chance to do Economics. While at it, I enrolled at a software engneering bootcamp with an enthusiasm for doing a short tech course. The combinaton of tech and economics helped me build a variety of applications based on sustainable development goals. A few years later I realised other tech paths related to economics whch include data analytics. This got me wonderng what if I would have known earlier what would have been different, maybe I would have a job right now. So this app creates awareness to freshman students seeking internshps and high school students choosing courses and unversities.

What it does

The app helps students discover which tech careers align with their university courses. Here's how it works:

Main Features:

  • Browse all available university courses organized by department
  • Click any course to see which tech careers it prepares students for
  • Each career shows a relevance score (1-10) indicating how well that course trains for the role
  • View career details including job description, required skills, salary range, and notes on how the course relates

Example: If a student takes "CS401: Machine Learning," they'd see it's highly relevant (score 10/10) for careers like Machine Learning Engineer and Data Scientist, with notes explaining why and what skills they'll gain.

It's designed to help students make informed decisions about their course selections based on their career interests in tech.

How we built it

Backend (Database):

Created 3 tables in Bolt Database: courses, careers, and course_career_mappings The mappings table connects courses to careers with a relevance score (1-10) and notes Added security policies so anyone can view the data Populated with sample data: 10 courses and 10 tech careers with their connections

Frontend (React):

Built as a two-column layout using React hooks (useState, useEffect) Left side fetches and displays all courses from the database, grouped by department When you click a course, it queries the mappings table to find related careers Right side displays the matching careers sorted by relevance score Used TypeScript types generated from the database schema for type safety

Accomplishments that I am proud of

I am proud of what I have built and I know it will benefit students and help bridge the gap between uncertainty and knowing what career paths tgey should be setting goals for.

What I learned

I learnt that AI is a fast tool for software engineers who need to build apps faster and generate ideas

Share this project:

Updates