Dynamic Class Planner

Presentation. Hello judges and fellow hackers, We are the hawker hackers and this is the first hackathon all of us have participated in. The topic we have chosen for our project is education and the problem we set out to solve is the dated and lacking class scheduling system when planning for classes each quarter prior to registration day. Prior to the date of registration, students are unable to add classes into the system’s schedule to properly plan for the classes they need to take for the quarter. (extra details if we need to present for 5 min presentation) To tackle this problem, we had an idea to create a dynamic weekly planner that allows users to add and remove classes they are interested in. Taking in data of available classes from the de anza class listing web page and ratings from rate my professor, users will be able to make informed decisions on which classes they may want to pick based on the difficulty ratings of each professor. To get the data, we used python with selenium on the rate my professor site to continuously click on the show more button to load all the professors’s data into the html, then used the beautiful soup library to scrape the data from the html elements of each site and imported them as a csv file. The file is then uploaded into sqlite for easier access of the data. Our website is put together with html and css for the front end and flask for the back end. On the website, students will first be greeted with a blank weekly planner. In the search bar below, students can search the classes they wish to take and pick from a selection of timings available for that quarter based on the data input into sqlite. Upon clicking the class code, its time slots will appear onto the calendar above, together with the rate my professor stats of each class. The user can then select which time slot is most suitable for their schedule and click it on the schedule to finalize their selection. Going into this hackathon, most of us didn't even know how to use python, html, css, sqlite. Although we were not able to completely flesh out a fully functioning app, i would like to thank everyone for this learning opportunity and the fun for the past 2 days.

Built With

• beautiful-soup
• bootstrap
• css
• flask
• html
• javascript
• jinja
• python
• selenium
• sqlite