Easy Calendar

Set up your calendar for all your classes in ONE PLACE!

Comment

Inspiration

Finding the zoom links for office hours and lecture hours of all your courses is such a hassle! Each course has their own website we need to navigate to. We decided create a resource where professors and TAs can upload their class/office hour times with zoom links into a centralized database. Students just need to select which courses they are in and a calendar will be created for them in one click.

What it does

As a professor or TA, you have to add your classes/office hours to the database. Create and log into your teacher account to do this.

As a student, create and log into your account then add the courses you are taking this semester. You can search for your courses in the search bar and it will give a dropdown list of the closest matches. Then, by a single click of the download calendar button, you get an ICS file that you can upload to any calendar app of your choosing.

How we built it

We wrote a database and log-in system using PHP and SQLite3.

As well, our website uses HTML and JavaScript to communicate with the database.

Challenges we ran into

Setting up the database and log in system was very time consuming due to the sheer amount of lines of code that had to be written. As well, the search bar algorithm for detecting the closest match had multiple bugs that we had to fix.

Another challenge we solved was the dropdown menu disappearing once we went to click on one of the options. Since the dropdown is only supposed to be visible when our cursor is in the search bar, once we click on one of the options in the dropdown menu, the dropdown would disappear and nothing would happen. We had to fix this by making the onclick across the entire body.

Accomplishments that we're proud of

Implementing a search bar with autofill, a reliable backend and login system are amazing achievements for us.

Another accomplishment was being able to create a database with logins and personalized profiles for each user. The professors can then update the database and it will be live for subsequent calendar download and course searches from students

What we learned

We learned a lot about databases in PHP with SQLite as backend as well as how to create a frontend in HTML, CSS, JS.

Also, we learned how to communicate between the frontend and the backend using POST requests and processing the textResponse received from the backend.

What's next for Easy Calendar

We are planning to add even more features including linking with Andrew ID login and improving the graphics/visuals of the website.

Share this project:

Updates