Web Application for Hill’s Business Solutions
Caleb Stenberg: Computer Science
Issac Hill: Computer Information Science
Charles Laxa: Computer Information Science
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
This project will benefit our client by streamlining her bookkeeping. This software will automatically upload information from her clients into QuickBooks without her needing to do it manually, as she had previously done. It will help her to keep track of this information and being able to edit it quickly. It will enable the sharing of repetitive files and forms simpler than email, and employee to employer requests and approvals will be handled. In the future or as a stretch goal, this software may be improved with data analysis and mobile app integration.
This project will be created by the three of us in about three months. We will have a lot of interaction with our client, and the plan may be altered many times. We will have a fully working web-based program with three separate privileges for administrators, employers, and employees, as well as a custom on-site server to process and store data. All of this will be tested with unit tests, asserts or both. We will likely use Vue and Bootstrap for our front-end and SQL on a free local server management software for our back-end, because we have been taught with these during our time at OTC.
By focusing on the client’s specific issues and leveraging our team’s diverse skill set, this project aims to deliver an impactful, efficient, and user-friendly solution. Beyond the immediate benefits to our client, this project also serves as a valuable opportunity for us to learn key professional skills, including communication, teamwork, problem-solving, and full-cycle project development.
LeagueSpot Connection
Jordan Buck – Computer Science Major
Timoteo Jinks – Computer Science Major
Justin Derenski – Computer Science Major
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
Our client, the National Association of Collegiate Esports (NACE) hosts a website that holds information for college level competitve esports video games such as Rocket League, Super Smash Bros. Ultimate, Fortnite, League of Legends, Overwatch, and many more competitive scene video games. This site shows which schools are participating in play and what teams are up against each other that week. Currently NACE updates their site info manually and it is our job to help them automate this process to more efficiently update and add Data to their website.
– This project will consist of needing to build a Web App that will be used to talk to a Database (SupaBase) where we will be pushing data, mainly Season_IDs to this Database that will then use a API provided to us (LeagueSpot API) to then deliver data in the Database that our client’s (NACE) Home website will pull from to populate correct fields for new seasons going forward. This project will be building on a already exsisting program that will be provided by Dr. Ford. – This Web App will be user friendly, show what is currently is in the database to prevent the need of signing on to SupaBase, allow the user to add a new semester via Season_ID that the user will provide, the ability to remove a semester if needed to to by the ID in the database itself, be able to update standings for the Season weekly automatically via AWS Lambda, all the while having documentation self contained inside the Web app itself. The final product will be hosted online and accessible to the client via password protection.
Esports Login
Clay Enciu – Computer Science Major
Payton Price – Computer Science Major
Jacob Hartel – Computer Science Major
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
The Esports Login project has the goal of allowing the Esports room to manage itself much
better to not only earn more respect from other departments but also to give workers and
administrators an easier time with it. This login page will provide much more capability and
information than the current one and best of all will be more intuitive and less bothersome to
employees by first hitting the issue of poor color coding on the current page that can not be changed.
Second, this will allow features like monitoring how long people have been in the room like the hours
they have stayed for the day or the hours they have stayed for an entire week, see who has been banned,
find more information on visitors, see their main reason for visiting, and see room occupancy.
There have been issues from other departments on students using the Esports room too long
and the administrators not knowing how much each item is used leading to a huge fear of the Esports
room being counter productive, but with this new login the workers and administrators will have a
much easier time getting rid of these fears, seeing the use of items, and managing everyone inside. The
only downside this will have is the requirement for every visitor to sign up on their first visit unlike the
previous system but looking at the OTC Weight room we can see a similar system has had no
downsides so as a team we are fully confident this new system will only be a positive to the people using
the room and said system.
Customs By DM Online System Setup
Joshua Comer – Computer Information Science
Darian Hughes – Computer Information Science
Roberto Perez – Computer Information Science
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
The Customs by DM website will be a user-friendly platform for showcasing floral arrangements and making the ordering process simple for customers. The homepage will feature a welcoming banner, product categories, and an “About Us” section to share the business’s mission and values. Product pages will highlight arrangements with detailed descriptions, pricing, and customization options. Customers will be able to place orders, schedule pickups, and get order confirmations, while additional features like a contact form and testimonials will build trust and engagement.
The site will be built with a focus on responsiveness, security, and SEO optimization to ensure it works well on all devices and reaches the intended audience effectively, as well as a well-integrated database that stores user data for orders. Using calming colors, elegant fonts, and high-quality images will help reflect the florist’s style and create a welcoming atmosphere.
The project will be developed in phases, starting with planning and design, followed by building and testing, and ending with the site launch. Features like social media integration will help promote the business, and the plan also considers ongoing costs like hosting and maintenance to keep the site running smoothly for customers looking for flowers for special occasions or gifts.
MINKWIC Conference Tool
Maksim Leontiy – Computer Information Science Major
Gavin Allred – Computer Science Major
Peyton Greer- Compter Science Major
Randall Volkmar – Computer Science Major
James Ponder – Computer Science Major
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
This report examines the feasibility of designing and developing a new software solution for the MINKWIC conference that allows students, teachers, and professionals to register for the conference. The data gathered during registration will allow administrators to prepare each guest’s stay and assist conference staff in checking in conference goers and confirming their requested accommodation. Through research and analysis, we have discovered the impact on all users involved and intend on making the project a viable option for our client. Recommendations include the design and implementation of a standalone administration panel that allows the viewing and modification of necessary data, such as roommate requests or allergy information.
Altruistic Construction & Remodel Website
Dagan S. Fitzsimmons
• Computer Science
Sean Peters
• Computer Science
Joshua Conn
• Computer Science
Sacchyam Tamrakr
• Computer Science
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
Altruistic Construction and Remodel is a local business focused on rebuilding, restoring, and/or remodeling for clientele. They primarily focus on insurance claims to help restore residential buildings that have sustained damage due to fire, flooding, and other insurance claims. Altruistic Construction and Remodel needs a website to expand its clientele and easily market the business. However, because this business is just starting out, they haven’t had the opportunity to hire developers to make a website for them. They requested a website that provides a way for the business owner to not only advertise but also open a line of communication to their potential clientele.
Our team’s objective is to provide a website that not only opens a new line of communication but also gives Altruistic Construction and Remodel a way to show off completed projects. Beyond this, they may advertise to incoming clients about ongoing events in the business via a blog page. Along with this, they can provide their clientele with a way to get updated invoices. The design will allow the business owner to dynamically update the site’s blog page, service page, and offer clients free quotes based on forms filled out on the proposed website. The website will allow for the creation of accounts through third-party sign-in such as Google. The proposed website will be connected to a database that will house information such as blog updates, service updates, clientele names, emails, images, and other necessary data. The database will have an overlay site that will allow the business owner to make updates to the database with ease and use a third-party resource for login authentication.
J&R Heating and Air LLC Project
Ivan Saldana: Computer Science, May 2025 Graduation date
Nick Troyer: Computer Science, May 2025 Graduation date
Owen Pendergrass: Computer Science, May 2025 Graduation date
Gael Rueda: Computer Information Science, May 2025 Graduation date
| Initial Project Presentation | Final Project Presentation |
|---|---|
|
|
|
Building a website and mobile application for J & R Heating and Air, a business that specializes in HVAC services, is the main goal of our project. The objective is to provide a clear digital platform that improves the business’s online visibility and offers an effective method to handle client communications. The project will make it easier to track services, talk to customers, and schedule appointments.
The company’s website will feature an easy to use interface designed with Vue.js. Essential sites like Home Services, Service Areas, Contact Us, Gallery, and Pricing will be included, along with a way for customers to schedule appointments. Furthermore, a “Se Habla Español” section on the website will help with bilingual access, improving accessibility for a wide range of users.
Real-time updates on customer appointments, notifications, and service history will be made possible with the mobile application, which will serve as a management tool for the business owner. The application will enable better schedule management, client data tracking, and notifications thanks to its smooth interface with the website’s MySQL database and PHP-based backend.
This project will be worked on by a four person team that will handle database management, mobile app integration, front-end and back-end development. Important stages including planning, development, testing, and final deployment are included in the schedule, which runs from January 15 to May 9. J & R Heating and Air will have a effective system to improve customer service and simplify operations by the end of the project. This project showcases our ability to develop a fully integrated web and mobile application for real-world use.