Automate Community-Based Mentorship Matching for Youth Education
Austin Aspires will bring together community resources and families to challenge all learners to seek excellence and equip them to achieve results through shared community vision, evidence-based decision making, collaborative action, and investment and sustainability. Their mentorship program seeks to positively impact the lives of young people by providing adult support and learning opportunities that promote character development and life-enhancing values through meaningful connections.
Project at a Glance:
Team:
Full-Stack Developer
Hours Engaged:
20
Skills & Stack:
Airtable, JavaScript
Problem
Austin Aspires provides youth development and educational services, including tutoring and mentorship programs. When community members and youth participants register for these programs, the organization matches mentees to mentors. Historically, this manual process was time-intensive and taxing on their small team, requiring them to orchestrate registrations across paper forms, Google Forms, and spreadsheets.Â
Solution
Prometheus paired Austin Aspires with a developer to streamline this matching process and centralize program registration. Our matched talent developed an Airtable database with relational tables storing data for program registration, mentees, and mentors.
The talent built out registration forms that populate these tables in Airtable automatically, and built out an algorithm in JavaScript using this information to identify and recommend the best mentor matches for each mentee. These recommendations automatically update with each registration form submission. They also configured email notifications automation so that program participants would receive emails containing details about status updates and next steps.
“Our experience working with Prometheus was educational, supportive, and easy….The support we received allowed us to manage a platform quicker, more efficiently, and as a whole organization." - Jessica (Parent Engagement & Mentorship Coordinator, Austin Aspires)