Inspiration
Every year, Student Affairs receives about 250 applications for the Marianopolis First-Year Mentorship program. This program involves returning students (mentors) being matched with new students (mentees) to help new students with the transition from High School to Cégep.
Our goal is to build a program which helps mentees to find the best-matched mentors and develop stronger bonds among Students!
What it does
It reads the given dataset of Excel and will output the Teacher ID in a way in which the first one will be the best matched and the last is the least matched.
How we built it
We used the library "openpyxl" to help us read the Excel file. After, we try to build a website which does a similar job. The mentor and mentee will be directed into different surveys and answer questions. After answering the question, it will output the best-matched mentors.
Challenges we ran into
We encountered multiple issues, such as website creation, making the user input data, and the module which tracks course time. We later encountered an error that forced us to use Google Sheets API, which we could not access due to technical issues. This problem prevents us from seeing the combined code and visualization. That is the reason we also included the program which directly reads an Excel and outputs the best matched mentors.
Accomplishments that we're proud of
This is our first hackathon as beginners. The project is built from scratch with little or no mentor help. We learned a lot of new things and features Python provides. We had great ideas but time and resources kept our progression slow.
What we learned
We learned HTML format, how to use Flask from Python, how to read Excel, and how to link everything together.
What's next for Mentorship Registration
Creation of a timetable for each user and direct messaging between mentor and mentee.
Log in or sign up for Devpost to join the conversation.