UniversityAdvisor

Home
Faculty Log-In
Faculty Sign-Up

UniversityAdvisor is a seamless AI chat service that enables more streamlined academic advising scheduling. Cut problems with bulky university academic advising systems with this universal solution.

Students and faculties have moved indoors due to the COVID19 pandemic, creating a sudden situation that nobody expected. Caught unprepared, a lot of things that used to be done in person had to become online. Some works, but some becomes more complicated. One of which is making advising appointments. Because of this, we were inspired to create UniversityAdvising. UniversityAdvising is a chatbot that streamlines this process so that students can get connected to advisors as soon as possible.

What it does

Students can chat with UniversityAdvising to find appointment times with a particular adviser/faculty. UniversityAdvising will then post the appointment into a database which can then be sent as confirmation emails for the student and adviser/faculty.

How I built it

The technologies used to create UniversityAdvising are: Python (Flask) as the back-end, SQLAlchemy, PostgreSQL to implement database, Boostrap as front end, and DialogFlow for the chatbot

Challenges I ran into

It has been a challenge especially because it is some of the group member's first time developing in Python, but we were able to learn and tackle new problems. It was also the team's first time interacting with Google Cloud's DialogFlow, but the intuitive documentations and resources were able to help us in implementing our ideas.

Accomplishments that I'm proud of

We are proud of being able to create a product that will help students and faculties. We are also proud of the fact that we are able to create UniversityAdvising even though it is the team's first experience with DialogFlow and Python for some members.

What I learned

We have learned the importance of communications. By talking early on, we were able to clear up any miscommunications and have a clear goal of what we are doing. We also gained experience in implementing Google Cloud API.

What's next for test

Future functionalities may be:

Helping students with general questions
Help students add a class/waitlist
Use Google Translate for International Students
Implementing Voice Dictation for the Vision-Impaired

Built With

Submitted to

Hack'20

Created by

I designed a robust database schema using relational DB knowledge I learned in school, and wrote most of DB access code for backend.

Marco Xu
I work on developing the Dialogflow and helping to develop the APIs although this was my first time developing using Python.

yohanes koeswono
I worked on the backend. This is my first time developing with Python (Flask), but I was able to be fairly involved in creating APIs and setting up the DB connection. I also took on a managing role, designing a big part of the project and prompting progress updates from everyone on the team.

Reinard Gabriel
I worked on developing the dialogflow and integrating using the webhooks

Jonathan Novecio
I worked on the main dialogflow conversational algorithm and the frontend UI

Rohan Katakam
AI Engineering