23/SP CIS 260 Final Projects

Ozark Mule Days

Initial Project Presentation Final Project Presentation

The Ozark Mule Project seeks to allow users from all over Missouri and the surrounding states to schedule for the 200 events that take place during the Ozark Mule Days mule show. Users will be prompted for which event they wish to enter, as well as their name, number, and the name of their mule. After doing so they will be given a contestant number in order to enter the competition. Contestant information will then be stored in a database using an ID so the information can easily be queried.  

Additionally, the reservation of a camping spot and utilities will be done with an area map where users will click on individual campsites to reserve them and choose which utilities they want. Data related to the campsites will also be stored within the database and will be related to the users specifically using their ID. On that note, the addition of a calendar that shares a similar function may also be implemented, as well. ​ 

Admins will be allowed to create and remove events as well as query the database for information. The prospect of doing online merchandise sales as well as AdSense is not off the table but requires further deliberation. Along those lines, users/companies will be able to apply for a sponsor banner on the website. All transactions will be done through Square. 

Harvest Church Website and Membership Database 

Initial Project Presentation Final Project Presentation

Team Members:

Aveline McEntire: Computer Science 

Mikey Saucedo: Computer Science 

Emmaleigh Stone: Computer Information Science 

Brett Wolfangel: Computer Information Science 

The Harvest Church in Aurora, Missouri needs a new website to advertise their church, inform their congregation on ongoing ministries and upcoming events, and allow online giving. They would also like to have a members database that collects information from a submission form on the website. 

The website will be split into four large categories: Home, About Harvest, Ministries, and Getting Involved. The Home category will be one webpage containing a video and link to YouTube to watch messages, a calendar with upcoming events, and two submission forms (prayer request and asking the pastor a question). The About Harvest category will be split into four different webpages: History, Statement of Faith, Vision, and Leadership. The Ministries category will be split into 10+ webpages: kids (Nursery, Sprouts, and Roots), youth, young adults, men, women, seniors, addiction and recovery (Hands and Sober Living House as separate pages), food pantry, Harvest Christian Academy, etc. The Get Involved category will be split into three webpages: giving (interface for Tithely), becoming a member (which links back to the database), and joining a ministry team (which also links back to the database). 

The membership database will include a member table, a ministries table, and an individual table for each ministry. It will also include queries (pre-created searches for members in the database) for all ministries, birthdays, and specific personal information. The database will be connected to the website and collect data from the membership form to load into the pre-created tables.  

System for Digitized Forms for SWI Industrial Solutions 

Initial Project Presentation Final Project Presentation

Team Members:

Landen Brewer: Computer Science 

Garrett Vonbecker: Computer Science 

Samuel Horton: Computer Science 

Our project is to set up a system to store and access digital forms for SWI Industrial Solutions. This system will consist of a database, an API, and a website. Various features, such as the ability to either download these forms or print them out, will be implemented. The system will provide benefits like tools to sort and filter through digital forms and create summaries of them. This system will help connect the various SWI locations and make workflow more efficient. 

Work will begin with designing our database and helping SWI with finding hosting for the database, API, and client-side. Once hosting has been established, we can set up the database. After work on the database has been finished, or after a testing database has been set up, work on the API will begin. The API will supply private endpoints to connect the website to the database. After some work on the API has gotten started, work on both the web design and code for the client-side can begin. 

The site will feature 3 main pages – a page to verify users (restrict the system to only intended employees), a page to send forms to the database, and another page to view and interact with forms in the database. The website will be designed with both desktop and mobile users in mind. Code for the website will provide various features to aid with the submission of forms (validation, auto-fill, etc.), various features to assist with the viewing of and interacting with forms (sorting, filtering, editing, downloading/printing, summarizing, etc.). 

XFit Gyms

Initial Project Presentation Final Project Presentation

Us 5 along with Jason, Jon, and David are building and designing a Mobile Application for XFIT Gyms. We are building on the different screens and features already made from the website. This Mobile App is for Apple or Android and it’ll have the ability for our members or staff of the gym to sign in/sign up to an account to use for the gym. There will be different account types based on the user’s association with the gym.  

In our app we want to include embed links of YouTube for features such as the WOTD (Workout of the Day), and other workout explanations. And with those links, we want to include a place for comments so we have that feel of a social media app. Along with comments, we want there to be a way to contact a personal trainer if need be. With our users we want to let them log their workouts and other essential things they would need to have stored, into our app. Lastly, of our main features we want there to be Spotify integration as music is vital to the gym. Gym Playlist, Personal Playlist, or Playlist by the Workout.  

We don’t want to be like the other gym apps out there, but we want to find what the other gym apps are lacking and double it in our app, further increasing our efficiency. With that being said, we also wanted to add a couple of additional, Secondary Features: Google/FitBit integration so our members of the gym can sign in using their Google Accounts rather than a XFIT Account, if need be. We will include a section that states clearly we don’t store unneeded personal data or information. The biggest almost main feature we want to add is the ability to push notifications to our users. 

Great Escape Game

Initial Project Presentation Final Project Presentation

Team Members:

Cara Jones: Computer Science 

Phoenix Norvell: Computer Information Science 

Evan Schwartz: Computer Science 

Don Denley: Computer Information Science 

Great Escape is going to be a scavenger hunt type of game. Once you create an account you can make or join games. The games you make you may save as templates to use in the future for new games. The games you join you can find again under the manage tab. Not only will you be able to make and join games you may also have multiple games going or leave a game before its over.  

So how do you play, you ask? The host, the user who created the game, makes a list of items to find. Once the game is started the players can click on a list item and capture a photo to send to the host. The host will either accept or deny the image as well as be able to send a comment to the player. Who ever finds all the items first is the winner and then the game is complete. The host can also kick players and pause games. Ultimately this application will be for promoting mental health through games and social interactions.  

Rocket League Dynamic Overlay

Initial Project Presentation Final Project Presentation

Team Members:

Arabella McEntire (Computer Science)

Ethan Ahlstrand (Computer Information Science)

Sam Ramirez (Computer Science)

Our team is developing a dynamic overlay for the video game “Rocket League” to be used on the OTC Esports Twitch channel. A dynamic overlay is updated in real time using information from the game that is sent through a relay server to a javascript page using websockets, and interpreted by an HTML and CSS page. While many streamers have to edit theiroverlay page in OBS in real time (which distracts from the stream and often isn’t possiblemid-game) or settle for a plain static overlay, this dynamic overlay updates using in-game eventsin milliseconds without any direction needed from the streamer.

We also plan to create a control panel that allows the client to control the dynamicoverlay project in a user-friendly way. This control panel will be hosted by OTC Esports on a livewebsite, and enable the client to easily connect Rocket League to the overlay and use it in OBS. The control panel will also provide a way for the client to upload team logo files (since theprogram cannot find images through a search engine dynamically) and adjust things like teamnames, player focus, and best of series information.

If feasible within the time of the project, we also plan to create a hype chamber in UnrealEngine for the car models to automatically be plugged into at the end of Rocket League tournaments. Additionally, we want to create a social media graphics package for the OTCEsports program. Including panels, scenes, and overlays for other games in the Esportsprogram that prioritizes maintaining the brand package and providing uniformity. In addition, wewill also create graphics for the Twitter, Instagram, and Twitch channel that maintain that brandstandard across platforms for a clean, professional look.