Fall 2021

C.H.A.M.P

CoxHealth Ambulance Maintenance Program

 

Team Members:

Taylor Rollins – Computer Information Science

Michael Winchel – Computer Information Science

Carl Caldwell – Computer Information Science

Client:

CoxHealth EMS 

Project Information:

CHAMP is software that helps CoxHealth EMS track their ambulance maintenance. The application is accessible via a web browser with internet connection.

Crew members can login and submit maintenance requests. The user can enter a title and description used to describe issues they observe that require maintenance. The user can also assign a priority to the request; Minor, Major, and Critical. These will let the manager know how quickly the request needs to be completed. After the request is submitted, a manager will need to review the request. The manager user has the ability to edit the request. Once the request is reviewed, the manager can approve or reject the request. Once the request is completed, the manager user can enter additional details to the request, such as invoice number, cost, and the maintenance location.

 When an ambulance is approaching is next scheduled service date or mileage, it will be included in a notification email. This notification will also include any requests that have not been reviewed. By default, the notification email will be sent on Monday at 5AM, but the manager has the ability to change the date, time, and frequency of this notification. Unapproved requests and ambulances requiring maintenance are also available on the dashboard of CHAMP and is presented to the manager user upon login.

After an ambulance has received maintenance where no request has been submitted, the manager user can manually enter a maintenance record. This record will have a predefined maintenance type, such as oil change, tire change, brake repair, etc. The manager will have the ability to attach invoice numbers, cost, locations, and additional comments to the record.

AlphaMega

Team Members:

  • Nylah Tay Rogers, Associate of Applied Science in Computer Science
  • Hieu Dang, Associate of Applied Science in Computer Science
  • Brian Nelson, Associate of Applied Science in Computer Science

Client 

Trinh Nguyen, Co-Owner of AlphaMega Investment Company, for use by affiliated nail salons.

Project Information:

The client, AlphaMega, requires a web application through which their affiliated nail salons can store customers and technician information, schedule technician hours to provide services, display services offered, book customers to receive services, send an email and text reminders to customers concerning upcoming appointments, and to allow customers to post reviews of services. As this platform will be used by multiple nail salons, the application requires the ability for the frontend to be modular to suit the style, location information, and needs of a given salon. In addition, data concerning appointments, clients, and technicians need to be stored with retrieval upon request.

To meet these needs, our team designed a fully interactive calendar that changes availability depending upon the selected technician and their set schedule, with times available adjusting according to what outstanding appointments the technician has. A registration/login interface allows customers to securely sign up to ease the appointment process and allow the sending of text and email reminders, as well as allow staff and administrator registration, and a settings page allows the administrators to adjust homepage images and contact information. Registered customers can write reviews and submit images to a review page. Technicians have a personal page where they can display a biography and select images to display in a gallery. Each service has a page detailing the process and displaying a related gallery. Administrative pages allow the client to display and edit staff, administrator, customer, and appointment information, and a database to store all relevant information.

This functionality is provided to the client in an intuitive, easy-to-navigate website format thoroughly utilizing PHP, Javascript, HTML, and CSS. Data searching, retrieving, inserting, and editing is simplified for the client via a well-designed database, with virtually no direct database interaction necessary for the client.

AFT Kansas

Team Members:

  • Greg Vaggalis- CIS (Major)
  • Alexander Hansen CS (Major)
  • Giovanni Sanchez – Computer Science Major

Client:

AFT Kansas

 

Project Information:

Our client’s, AFT Kansas, are union representatives for teachers located in Topeka, Kansas and are part of a larger national AFT union. We met with Nate and Genea, who were initially interested in acquiring our help in order to better organize their efforts in visiting their clients. Another interest the organization had, was to better control the lists of their clients when they extract them from a larger national database. Our group was tasked with making these efforts as streamlined and as affordable for the non-profit, which as hard as a task as that was our group, we handle with many creative ideas and tackled through hard work.

Unfortunately, AFT Kansas could not host a server which made making a web-app through something like SpringMVC or another web-app framework, an unrealistic possibility for our group. We decided on building them a MySQL database on a local computer that would utilize a graphically user interface (GUI) made in Java, to help store and extract local client information needed to visit members. Our group also planned on making a website that could be hosted for free on a service like Netlify that would help the organization’s employees when visiting clients.

Our GUI would be able to query through the organization’s database and find clients to visit based on zip code, city, etc. Once a query is made, we can extract a .csv file which we could use in our website. Our website had two functions, 1. Take the .csv file made from the database and load it into a map; it could then be focused more based on location and made into another .csv file that could be passed to the employee and 2. Assist the employees with finding routes to clients and help them to find the closest door while being able to update .csv files and export them for data entry into the database.

CoxHealth EMS Tracker

Team Members:

  • Blake Ewalt – CIS
  • Kenneth Cottrell – CIS
  • Nathaniel Mills – CIS
  • Joshua Porter – CIS

 

Client:

CoxHealth EMS

 

Project Information:

The goal of our project was to make an inventory system for the ambulances at cox. Our client is Owen Aldridge, and he tracks assets on ambulances, and he wanted us to create a better way to keep track of the assets. We attempted to create a program that can track available assets. Track items by type and have alerts for items. As well, to be able to make reports on assets. The program should be able to log items in and out of service. Our program should work with existing cox servers and databases for logging in and out users. We used a python-based web stack for the web application. Used bootstrap for the design. We used a SQL database to store the data need to make a demo. Location tracking was out of the scope of the project and wasn’t attempted. Overall, we tried our best to get as many of the requirements completed.