23/FA CIS 260 Final Projects

MSS Request

Team Members:

Tim McCully, Computer Information Science 
Joshua Larry, Computer Science 
Noah Callen, Computer Science 
Victoria Liford, Computer Information Science 

Initial Project Presentation Final Project Presentation

The MSS Request Project is being completed on behalf of Mazuma Credit Union. The goal of the program is to take a process that already exists within Mazuma and improve it by streamlining it through Microsoft Power Platform. Currently, when a research request is made at the company it is done through email. In this process, a front-line team member sends an email to the member support services department (MSS) and then MSS gathers the requested information. Receiving such requests through email poses the risk of the requests getting lost in inboxes or accidentally deleted from inboxes, in which case requests will go unanswered. Our team’s project aims to eliminate the chance of unanswered requests by creating a single repository for all requests through the Power Platform.  

The Power Platform process will have a Power App that acts as the intake used by the front-line team members. The request should include request category and request detail. Once created, the request will be sent to a queue found in Dynamics where a team member should be able to claim the ticket. Team members responsible for a ticket should also be able to set a priority level relating to the request. If time constraints permit, the project may also include displaying relevant data related to requests, such as which request types are most common or how many of a certain type of request were made within a certain period. Having a specified channel to send and receive requests should lighten the load of team members who receive requests due to the simplicity and accessibility of the repository. 

Donor and Prayer Management System

Team Members:

Chase Wilson – A.S. Computer Science 

Shane Parenteau – A.A.S. Computer Information Science 

Chris de Leon – A.S. Computer Science 

Initial Project Presentation Final Project Presentation

Our team is excited to create a comprehensive web application tailored to the specific needs of our client. The goal is for it to be designed to streamline the management of donor information, supporter data, and prayer requests. The platform will serve as a hub for efficient data handling, retrieval, and manipulation. These tools will empower our clients to foster stronger relationships with their constituents. 

As with several web applications, this system will be comprised of 3 parts: the front end, the back end, and a database. The front end will immediately greet users with a login screen. Once logged in, a user will be able to view and manipulate data in a decorated UI. It will be integral to the project that the front end is responsive. The back end will be created with Spring Boot, a Java framework. The back end will consist of three layers: the API layer that is responsible for creating, writing, editing, and deleting data, the service layer that is responsible for business logic that interprets data, and the data access layer which is the “key” to obtaining data. The database will store any donor/supporter-related information and prayer requests.  

Key features of this project will include functionality that supports multiple users with secure authentication, the ability to rapidly import and export data via CSV files, and the ability to add users. 

Bloir Family Farms Website and Inventory/Equipment Database 

Team Members:

Dalton Russell – Computer Information Science 

Jayden Reagan – Computer Information Science 

Lac Stoll – Computer Information Science 

Initial Project Presentation Final Project Presentation

The Bloir Family Farms Website and Inventory/Equipment Database goal is to develop a business management tool for a newly established family farm. This will provide a system to efficiently track inventory, customers, equipment, and equipment maintenance schedules. The project encompasses the development of a database to store business-related information and a user-friendly website to access the database. 

The database will serve as a repository for storing various types of data crucial to the farm’s operations. It will include sections for customer data, making the farm able to manage contact information, preferences, and purchase history effectively. The database will track product inventory, item details, and availability. It will also facilitate the management of potential inventory and items planted. Furthermore, the database will store equipment information. It will also incorporate a dedicated module for tracking equipment maintenance schedules, ensuring timely maintenance tasks, due dates, and completed maintenance records. 

The website component of the project will offer a user-friendly interface for accessing and interacting with the database. Users will be able to conveniently retrieve information, update customer data, and access equipment-related details. The website will serve as a central hub for farm personnel to efficiently manage and monitor inventory, customers, and equipment. Additionally, it will provide functionality to generate shipping labels for product shipments. Integration with shipping carriers will enable the retrieval of tracking numbers for orders, enhancing transparency and customer service. 

It is important to note that the project has defined certain out-of-scope elements. The website will not include direct product selling capabilities, as it is primarily focused on data management and tracking. Transactions and financial tracking related to product sales will not be covered in this project. Similarly, integrations with external sales platforms and financial management systems are beyond the scope, ensuring a clear focus on inventory, customers, and equipment tracking. 

Overall, the Bloir Family Farms Website and Inventory/Equipment Database project goal is to empower the family farm with an efficient business management tool. By providing a robust database and a user-friendly website, the project will streamline operations, enhance data visibility, and facilitate effective tracking of inventory, customers, and equipment maintenance schedules. 

B&K Fireplaces

Team Members:

Logan Wooldridge – Computer Information Science 

Ryley Green – Computer Information Science 

Kaleb Crume – Computer Science 

Elijah Briggs – Computer Information Science 

Initial Project Presentation Final Project Presentation

This project aims to create an enhanced website for the client, featuring a variety of improvements. The upgraded website will include, but not be limited to, the following elements: an enriched color palette, an interactive gallery enabling customers to explore potential fireplace options, a streamlined method for updating fireplace stock, robust sorting capabilities for available fireplaces, a user-friendly navigation bar, improved text formatting, and a dedicated contact page. Additionally, we are in the process of evaluating different inventory management system options, which will be finalized at a later stage. 

To accomplish these objectives, we will require specific resources throughout the project. Notably, having images of previously constructed fireplaces will be crucial for showcasing the client’s product and providing customers with an idea of the available options. Incorporating a logo into the website can capture the customers’ attention and create a favorable first impression. Additionally, we will need access to availability and stock information for the initial website and gallery setup, with the possibility of requiring further resources from the client later in the project. 

To execute this project, we will utilize a range of tools and strategies. First, we will undergo a layout design process to provide everyone with a visual concept of the website’s structure. During the website development phase, we will employ a plugin for seamless file synchronization among team members; however, if necessary, we will utilize GitHub as a platform for collaboration and version control. Finally, all communication, including meetings and updates, will be facilitated through Microsoft Teams.