My projects
These are all the projects that I have worked on throughout college and in free time.
Click here to view my Github to look at my projects in detail!
B104 Python Project
This was my first-ever project in college. It involved analyzing the YRBS survey results, selecting two survey topics, and comparing them using analytical solutions in Excel and Python. I collaborated on this project with a classmate, and we explored the correlation between the weight of teens and their daily screen time. We then created a Python script to process the data and generate graphs to visualize the findings.
B145 Java Video Game
During my first semester of sophomore year, I took my first Java programming class. The project involved creating a 2D short video game based on a painting from a specific art era. The goal of the game was to demonstrate the skills acquired throughout the semester. Additionally, the game was designed to facilitate tangential learning, allowing players to learn while playing.
I developed a memory game featuring cards inspired by the painting Corridor in the Asylum by Vincent van Gogh. There was also a competition for the best game overall, and I won second place!
B320 Database Project
During the second semester of my sophomore year, I took my first SQL class. This class focused on the basics of querying data. The project involved creating an Entity-Relationship Diagram (ERD) for the entire course catalog and course offerings for Spring 2024. The next steps included implementing this data design in SQL Server Management Studio (SSMS), inserting the data, cleaning the data to remove outdated or null values, mocking up student schedules, and querying the data to calculate instructors' averages and students' grades.
B409 Agile Game Design
During my first semester of junior year in college, I took a Unity gaming class where we were tasked with creating a game as an agile development team. We developed a game from scratch and brought it to a viable product through scrum meetings, Kanban boards, and hours of collaboration. Our team consisted of two programmers and two artists. The game we created is a first-person horror game called The Hidden Truth.
Won the award for the best overall presentation with this game!
Presented this for scholarship and research day and won a certificate of excellence in the innovation/application category.
B321 Database Application
During my first semester of junior year in college, this class continued the material from B320, expanding into topics such as Stored Procedures, Views, Functions, and Triggers. We also began working with front-end applications and connecting them to a backend. Using Visual Studio, we developed a front-end Windows Forms application, while SQL Server Management Studio (SSMS) handled the backend programmatic logic and scripts.
As part of a team of three, we created an application similar to Calendly or other appointment management tools. The front-end application interacted with stored procedures to manage appointments, including creating, deleting, and updating them.
B470 Fullstack Web Application Project
The second semester of my junior year. Me and 4 other classmates created a full-stack web app using PostgreSQL, Eclipse, and Visual Studio Code. After building a guided demo, My team developed a soundboard web app, with audio files stored in Google Cloud and linked through the database.
The project followed Agile methodologies, including user stories, Scrum meetings, and sprint retrospectives. It provided hands-on experience with frontend-backend integration, cloud storage, and collaborative software development.
We got 1st place in the best overall presentation and project for our class!
Links to the App!
PS! Run the backend first and wait a couple of minutes.
It needs to wake up after not being used for 15 minutes
Backend: https://echodeck-backend-470sp25-team3.onrender.com/
Frontend: https://echodeck.netlify.app/