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.

Share this project:

Updates