Project Details
Architecture Technology Corporation (ATC) ATC has a “cyber range” called CYRIN for training at testing. Currently, they have several testing modules, but they are looking to expand their training library. They offer a graphical exercise builder and a comprehensive monitoring system to track student progress. We are tasked with the objective of building an incident response exercise. The exercise environment will mimic a real business enterprise with servers, firewalls, and workstations (Linux or Windows). Our objective is to develop a training exercise where users will identify data stolen and how penetration was accomplished.

Project Details
Presently, when our troops are training in battlefield scenarios, there are limited options for how to simulate a dynamic battlefield. The options tend to be either physical war games or written scenarios. A far more flexible setup is required. This more flexible system is called CASPIAN, and will provide a mix of real time and simulated data to troops training in the field. The section of the system that this project will focus on is visualization of simulation and real time data on a map, along with additional analytics. By using the HLA implementation Portico and OpenMap, we will add a new federate to the existing system that will allow users to see simulated combatants, along with their actual up-to-date location.

Team:  Benjamin Mohan, Samantha Ingersoll, Tyler Tjosaas, and Jordan Hartman

Project Details
Aeritae Consulting wants us to implement a chatbot service that they will be able to use in assisting customers in troubleshooting issues. The chatbot will allow customers to have a conversation that will help to categorize the customer's issue and create an incident report. The report will be sent to a help desk and stored.

Team: Jesse Kunze, Andrew Zinke, Brian Engelbrecht, and Tiana Khamvongsa

Project Details
We will be developing a mobile iOS application capable of interfacing with Appareo’s Stratus 2 device. The application aims to display incoming information from the device on a moving map with an easy to view interface. This will make it easier for customers to interpret the data coming from the Stratus 2.

Project Details
Currently, Border States does not have a way of visualizing where their branch locations are in relation to customer locations, as well as viewing customer sales and other significant statistics. The goal of this project is to create a cloud-based application that acts like an interactive map that shows branch locations, customer locations and important statistics that BSE is interested in. Completing this project will allow BSE to strategically place new branches so it makes sense from a marketing and geographic standpoint. The application will provide insight as to whether there are any gaps in coverage across the U.S. The final delivery will be at the final presentation in early May.

Team: Christian Ames, Yuqian Li, Jesse Nolting, Austin Tadman

Project Details
The project is to create a web browser application for Managers and Administrators to administer tests for employees and applicants. This application will have a user dashboard and assessment page to see what tasks they might have and tests they might need to take. The test will be a 10 key assessment where the user will enter the integer, decimal, date, or mix of all. The users will be able to retake the test. The dashboard will show the prior tests and tests that were redone. The actual test will have a start button, a timer, and an entry field. Postgres will be used for the database and we will be hosting a server as well. We will use the Angular 2 framework that uses typescript, this will be the layer of interaction between the business and web client. The goal is to create a user-friendly web application.

Project Details
ControTech is seeking to develop an online portal for demonstration, review and updating of project plans in the Primavera P6 file format. The portal will be used to enable representatives to demonstrate Gantt charts to customers online and on a tablet device.

Project Details
Fjorge has need for a front end to their grand central database that has been developed from previous capstone projects, the system that collects data from programs used in their day to day operations and organizes it into a database. This data is used to generate reports about various details of their projects. Currently, they are generating these reports and presenting them to their customers manually. The purpose of this project is to continue developing a program to take the data from this grand central database and automatically generate reports and present them in an accurate and easily accessible format. Developing this program with automated reporting will allow for faster, more accurate and greater detailed analysis of statistics without taking unnecessary time to do so manually.

Team: Zachary Grosz, Aaron Beyer, Benjamin Reagan, and Tongxin Shi

Project Details
This project is to develop a prototype of a portal that the Kannegiesser company will provide for their customers. In this portal, customers will have an overview of their machines and will include features including a spare parts web-shop and a video-center. One of the features that this project will be focusing on is a maintenance cockpit, which will carry out maintenance activities and tasks on the customers machines. The maintenance cockpit will contain two views; a machine view, that displays all of a customer’s machines at all of their plants, and an order view, which shows the customer all of their orders.

Team: Connor Fradenburgh, Derek Boonstra, Victor Rauta, and Tanner Olason

Project Details
John Deere Power Electronic Solutions (John Deere) uses IBM’s InfoSphere DataStage software for all of its ETL (Extract, Transform, Load) needs. This product is due for an update, but the company’s current level of usage doesn’t justify the resources an update would take. John Deere is considering SQL Server Integration Services (SSIS) as the replacement product. The company has little experience with SSIS, so they would like our student team to explore the capabilities of the software and determine its viability as a replacement. In addition, the company is exploring options for hosting their replacement ETL tool on-premise. Their current setup uses virtual machines (VMs), but they are open to the idea of using Docker, a platform for hosting operating-system level virtualization, or containers. Time permitting, John Deere would like our student team to build two SSIS systems, one using VMs and one using Docker, and compare the two. John Deere would like the student team to first focus on building the SSIS system using VMs only, and if time is left over in the project, build the Docker version. --- The project will focus first on setting up an “ETL Lab”. An ETL Lab will host multiple databases and database servers in an attempt to simulate the different data sources that John Deere uses. Databases will be populated with mock data, either created by the student team or publicly available from a third-party, in a quantity similar to that of John Deere’s databases. The ETL Lab will also host the SSIS software itself. The ETL Lab setup and specifications will be documented and delivered in a final report. For the virtual machine option, the ETL Lab will be hosted on Microsoft Azure, a cloud computing platform. For the Docker option, a similar sort of ETL Lab would be set up using the Docker platform. Once an ETL Lab is set up, the focus of the project will shift to experimentation and demonstration. The student team will use SSIS to perform the wide range of functions required by John Deere and document pertinent observations. These observations will be compiled into a final report, which will be delivered to the company at the end of the project, along with the student team’s recommendations about SSIS. The student team will also demonstrate the working SSIS system to the company. If the Docker system is completed, the same experimentation and demonstration will be performed with it as well. The results of the project will have a real impact on the company. The student team’s work and recommendation will weigh heavily into the company’s decision for a replacement product, and this product will set the course of the company’s ETL technology for the next 5 - 10 years.

Team: Derek Evanson, Jack Morgan, and Ryan Nelson

Project Details
Microsoft in Fargo has a significant amount of resources allocated to Research and Development. In the never-ending (as it seems) technologically advancing society that we live in it is always vital to try and stay ahead of the curve. The proposed project can be viewed as a trial project to see how Blockchain technology can be integrated using the Internet of Things concept in order to monitor assets, like vehicles performing various tasks, using a mobile application. By tracking the asset’s behavior in real time, future clients can optimize their product in a secure manner, thanks to the blockchain technology, without having to be stationary; allowing for a broader clientele. Microsoft is experimenting with blockchain and possible applications due to their Dynamics 365 for Finance and Operations ERP product. In perhaps an initial planning phase of a long term move they have decided to experiment with blockchain technology to see if they could possibly integrate their currently centralized ERP with a distributed trust model.

Team: Akhil Venkataraju, Allan Pirillis, Ben Weller, Eric Van Asperen, and Zachary D'Ambrosio

Project Details
The Music Composition Version Control Software will allow composers of music track and view changes they make to their compositions.

Project Details
Currently, Next Resources does not have an electronic, user friendly way to communicate to its crew members what assets need to be where, or how to transport them. We will create a database to maintain and update current asset locations. Our goal is to have SMS messages sent to each crew member, providing a link to their next day’s shift’s details. Shift details will include locations, who they’re working working with, shift length, and who the dispatcher is. The details for shifts will be decided by dispatchers.

Team: Austin Tauer, Alexis Saari, and Ryley Banick

Project Details
The desired result of the project is to allow Noridian to send surveys based on claims processed through a mobile app and capture the results onto a database along with patient information. The mobile app will run on both Android and IOS devices using SQL.

Team: Barret Davis, Cody Kuntz, Jordan Rothstein, and Ayushi Saxena

Project Details
Currently, the OmniByte rTown product is controlled completely by a community administrator. This project will add the capability for businesses to submit information about specials and deals to the community administrator for approval that, when approved, will be available to users of the mobile application. Having this capability will help more equally balance the workload of generating information between community administrators and businesses; allow businesses to better draw in customers, hence promoting economic advancement locally; and further satisfy mobile application users with the increased ease and convenience made available by the technology. By adding the results of this project to its current content in a subsequent rTown release, OmniByte will be able to provide existing customers with a requested update and will have additional features to market to potential customers, which could amplify the use and desired effect of rTown. The final delivery of this project will occur in early May at the final presentation.

Team: Colin Geray, Dalton Roll, Emma Schreifels, and Jay Lohse

Project Details
Currently, Orbital ATK has done research into building a sensor network based based of IOT concepts. This project aims to develop firmware for the nodes of this network. It also aims to develop a simulation environment to test this firmware. By using simulation, we hope to build a self-organizing and self-healing network that is easy to deploy. The final delivery will be at the final presentation in early May..

Team: Tyler Gaffaney, Justin Spanier, and Justin McLain

Project Details
Pedigree provides a sensor and service to their customers to view different statistics about vehicles and other devices on their OneView software. Currently this software has about a minute delay on data collection. We would like to provide a Bluetooth application that will allow real time collection and viewing of the statistics provided by the sensor. We will provide an android app that will be able to be used in the field for quick and useful real time analysis. The final delivery will be at the final presentation in early May.

Team: Adam Beyer, Thomas Kistler, Kevin Fagan, and Bryce Suchy

Project Details
We are going to create a web based application that has a responsive design, to host a database of 360 reviews.

Team: Alex Brown, Nick Carpenter, Juan Panora, and Quinn Murphy

Project Details
Rockwell Collins would like a versatile tool that can take compressed tarballs as input from either a local directory or anonymous FTP. The input will be pre-recorded flight data composed of various fields. The application will be able to parse files and using a combination of GUI tools and user defined filters be able to present the information in an easily readable manner. The application will be capable of filtering data based on user criteria from a list of fields.

Team: Mitchell Kollodge, Jordan Goetze, Lance Willet, and Clay Moody

Project Details
The Eiffel framework enables technology agnostic enterprise scale continuous integration and delivery with maintained scalability, flexibility and traceability. Eiffel is based on the concept of decentralized real time messaging, both to drive the continuous integration and delivery system and to document it. This project aims to build a plugin for the Eiffel framework to interface with Atlassian JIRA. The final delivery will be at the final presentation in early May.

Team: Jaden Young, Brandon Rudisel, Brett Knecht, and Brendan Curran

Project Details
Currently, UGPTI has an old Visual Basic application made in 2003 that no longer functions. This applications purpose is to calculate the expenses involved in purchasing and using a transportation truck, in order to compare to the cost of contracting out transportation to another company. However, due to this applications age, it is unlikely to function on modern systems. This project exists to take this application, update it and improve the UI, as the old UI is very outdated. Final delivery due at the final presentation in May.