University Enrollment Management System DEMO (SQL, AWS, Python Flask, CSS, HTML) Aaron Guo

● AI Chatbot System: Based on Google Gemini, a Python library and an API key later, “Ask George” allows both students and applicants to the university to ask basic questions, such as how can a user register for a course, why isn’t a student able to register for a course (could be for a variety of reasons such as lack of Form 1 submission or lack of prerequisites) or how to move the process of application along. Additional features such as future courses a student can take depending on courses that they’ve already taken is also an additional query. -Aaron
● Email Recommendations: Upon request by a student/applicant, an email will be sent to an end user where they can submit a submission for the student’s
recommendation letter that will be included in the application of a student in the system. - Aaron
● Darkmode: On the Applicant Side, Light/Dark Mode exists with a single click on the top right corner. - Aaron

● PDF Download of Transcripts and Review Forms: For Students and the CAC, they are both able to download files directly to their computer with a single click. Students can download their transcript and CAC can download Review Forms. - Aaron
● Course Catalog: When students need to add courses to their Form 1, they can choose to either enter the course details manually, or choose from a list of all courses in the catalog. When selecting a course, checks to see if the prerequisites
are met or if the course has already been taken are run. If both checks pass, the course is added and the Form 1 table is updated. - Faris
● Gmail Recommendation Letters: Applicants can send up to 3 recommendation letters and they will be emailed to the email they choose, that recommender can fill out the letter with the link. - Aaron