2017 Projects

Adventium

Project Details
The ARNIC schedule visualization program video will consist of us showing the reason why they wanted this program to be made. We will show the XML that they originally had to sort through. Then we will open our project and go through adding a schedule to the program. After this we will go through the visualization of the file and explain what is being shown from the file. This will be a good time to go through features of the program and get into what it can do. The filtering options will be gone through to show how they work. We will continue to explain why they need the program.


Botlink

Team:  Aaron Buchholz, Mark Swam, and Thomas Ames


Data61

Project Details
Our project focuses on manipulating various data sets without having to send the data over the internet to be processed. The way we achieved this was by writing a backend service that takes the data mappings from the data sets we want to manipulate along with the transformations we want to perform on the data sets. After our service receives all this data it generates a JavaScript file that is passed back to the front end where the front end uses it to perform the transformation on the data sets. This process allows us to achieve our goal of manipulating data sets without sending all the data over the internet and allows users to perform these manipulations from anywhere they have internet access.

Team: Tyler Losinski, Adam Hart, Mitchell Gerard, and Nicholas Feikema


Ericsson

Project Details
Ericsson is a global leader in delivering Information and Communication Technology (ICT) solutions. In fact, 40% of the world's mobile traffic is carried over Ericsson networks. This semester’s project for Ericsson was to develop a mobile application that can send an android ping to a database. Once that ping is in the server, our web interface that we created will communicate with the web server we setup to display real-time data circles that entail cellular network information.

Team: Isaiah Nicolai, Paul Kakoty, Gage Asskeggard, and Ben Hapip


FBS

Image Analysis

Project Details
FBS is a company that focuses on data in the real estate market. Currently, FBS has several photos stored in a database and our goal was to discover an efficient way to take the existing images and use image analyzing tools to collect tags defining each photo. These tags and their related information are then stored in a database allowing users to find images of what they desire by searching for the related tags. This video describes our solution and how it demonstrates the usefulness of image analyzing software in real estate.

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


Fjorge

Project Details
For our project, we worked with fjorge digital to build upon the Grand Central Database project started by last years Capstone team. We gather data from fjorge's most used programs and place it in the database, where it can then be accessed easier by the fjorge team. This saves fjorge time in collecting the data themselves, and allows them to project revenue and team availability, among other metrics. The video will describe the different systems we worked with, what they were used for, and how our project interacts with those systems.


Humach

Project Details
Humach provides a cloud-based platform for call center solutions. They also provide automation in technology. This feature is the main reason for our project. Our project is to incorporate Amazon Echo devices and Amazon Voice Service into Humach workflow. We are creating a home user application that contains a new skill set for the Amazon Echo Dot. It aims to have users prompt the Amazon Echo devices to retrieve call center statistics and relay back to the users as requested. (e.g. “Alexa, ask Humach how many calls are waiting?”). This would allow managers and supervisors to keep tabs on the status of their call centers without having the need to interact with a computer. The video walks through the process of configuring an Alexa skill on the Amazon developer portal. Then it demonstrates some of the functionalities of the skill. Lastly, the video shows the process of deploying the skill using Zappa which is a serverless python service framework.

Team: Mi Huynh, Chris Bigelow, Grant Moe, and Niharika Sngh


IBM


Integrity

Project Details
Integrity is a manufacturer of windows and doors headquartered in Fargo, North Dakota. Integrity is constantly developing new products, this is where our project comes in. When creating a new window or door there is extensive collaboration between the engineers in charge of design and manufacture and the software developers who support the manufacturing. Under the current system the engineers fill out pages and pages of excel documents which are converted by hand and then passed to the developers to manually input into the database. This process is extremely inefficient and takes about 8 weeks.

So for our capstone project Integrity tasked us with creating a new program that could integrate with their SCADA software and provide a way for engineers to enter their data and update the database without requiring any technical knowledge about databases or the structure of the database itself.

Team: Everett Kuntz, Erik LaVanier, Brandon Grindall, and Chengyao Tang


Intelligent InSites

Project Details
The purpose of this project is to allow hospitals and clinics to have the option of going keyboard free. Implementation of this would involve the use of the Microsoft Kinect as a gesture-capturing device. There is no current system in place for a hospital or clinic to go keyboard free and this project was aimed at the proof of concept. Our goal was to develop a prototype of a system utilizing the Kinect. This system works in conjunction with the current tracking system.

Team: Jestin Jacobs, Michael McCrory, Josh Mindermann, Erin Radtke, and Buster Schrader


Inwerken

Project Details
The Internet of Things is a technology that is being pioneered by many business and organizations. To understand the feasibility of this new field, Inwerken had tasked us to build a prototype workflow demonstrating the connection of external sensor data being parsed and sent to the cloud.

Our solution consisted of a provided gateway sensor device connecting to the HANA Cloud database through several pre-existing frameworks. Using the Node-RED JavaScript framework, which is a programming tool for connecting the Internet of things together, we are parsing different types of test data (like humidity and brightness), packaging it into a json string, and sending it to the HANA Cloud.

The HANA Cloud toolset allows us to receive this data through a Node-RED http post and populates a table within the Internet of Things Message Management Service. Once it is in the HANA Cloud, any other activated HANA services are allowed to access it. Using a UI5 application, we are able to display and manipulate this data, as well as communicate directly back to these sensors connected to the gateway device. This makes commands like manual LED changes possible, starting from the HANA Cloud front end all the way to the gateway device giving led change commands.

Team: Joseph Moses, Garrett Leatherman, Lucas Stein, and Sean Rider


John Deere

Project Details
John Deere is a manufacturer of numerous electronic devices that are used within their products. Each of these products has a team of engineers that are responsible for making sure that these products are manufactured using specific guidelines to ensure reliability on the production line. Our project was a transfer of the guideline information from a standalone Excel file to a SharePoint subsite.

Advantages:

  • Includes search functionality (Often Requested)
  • Saves disk space on user devices
  • Allows for real-time alerts for updates
  • Allows for selective permissions
  • Potential for image tagging for image searching

Team: Nate Wallestad, Rose Jackson, Chris Dahl, and Damon Hage


Microsoft

Employee Self Service App using Xamarin

Project Details
The problem we were tasked to solve by Microsoft revolves around the idea of employee retention. The cost of recruiting, training, and hiring new employees is high, especially if losses in time are considered, so being able to predict which employees are at risk of leaving can allow for targeted rerecruiting or earlier back-fills. To solve this issue, we used machine learning through Microsoft's Azure Machine Learning. To do this, we found employee data, which includes employee retention, and used it to find the best model for the particular problem. Various models were tested and the neural network provided the best accuracy.

Team: James Baboin, Sneha Subash, Bryant Feist, Kai Yao, and Nate Spanier


Mindroad

Storyteller: Story Management Tool

Project Details
The problem we solved for Mindroad was creating an electronic user story management tool that had automatic analysis. Our sponsor, Richard Falt, could not find a tool that allowed him to manage user stories in real time, with built in analysis for jargon terms and duplicate user stories. Our solution is Storyteller.

Using bleeding edge Google Chrome formatting, Google's Firebase, and Node.js, Storyteller is a powerful new user story management tool.

Storyteller Features

  • User Management
  • Storyboard management
  • Real-time collaboration
  • Automated and manual user story flagging
  • Export to CSV for convenience

Team: Tyler Johnson, Scott St. Amant, James Corcoran, Nate Diemer, and Nathan Raatz


NAU County

Project Details
We will be discussing the original problem QBE had. We would talk about why it was an issue and the solution they came up with. We would than discuss what we have done so far with the app and do a demo of what we have. We would than discuss where the app will go once it is out of our hands.

Team: Jaron Pollman, Kelsey Bedard, Daniel Anderson, and Joey Borowicz


Noridian

Project Details
Noridian is a health insurance company, specialized in lowering insurance cost for patients and making it easy for patients to have access to doctors.

Problem
Noridian is a health insurance company, that wants to help lower health costs and easy access for patients to doctors.

Solution

  • Telehealth
  • Web Application
  • Video/Text Chat
  • Notes
  • Medical Records

Pedigree

Project Details
Pedigree Technologies has been providing companies with asset tracking and fleet management services by way of their OneView platform. Monitoring devices installed in customer vehicles by Pedigree gather equipment/engine data and periodically send it to OneView servers for the customer to view. The purpose of our project is to develop a mobile app that pulls data directly from the monitoring device and displays it in real time. This app will enable equipment maintenance techs to use their phones or tablets to quickly and accurately diagnose problems with vehicles and equipment in the field.

Team: Joseph Mitchell, Weston McKenney, and Caleb Larsen


Sanford Health

Project Details
The project aims to improve Sanford Health’s monitoring phase. Sanford Health has over one hundred custom built applications that run across more than ten servers and the project aims to improve the monitoring of those applications via dashboard. The dashboard that the project aims to design and build will help Sanford identify the applications and their errors and exceptions as well as reduce the amount of time it takes to run usage reports all while monitoring the applications.

The dashboard allows users to add a new application and delete an application. When an application is added, the button is created which contains the application’s name. And when the button is clicked on, the data table which contains all of the application’s information regarding type of errors, host name, etc., appears on the screen. The data table can be filtered by a date range and it is also searchable. The buttons on the sidebar are organized by an error count and they are color coded as well.

The purpose of the project is to improve the overall flow of the applications by instantly knowing which applications have problems and fixing those problems when they arise, identifying errors and glitches that are found in the applications, understanding how the applications are behaving and being used and how much they are being used by various users, getting an idea on whether certain applications need upgrading based on usage or errors detected, and monitor trending issues in each of the applications. It currently takes the software development team at Sanford a considerable amount of time to run usage reports on each of their custom-built applications, so the purpose of the dashboard that we will create will help to reduce the time that it takes to run those usage reports and get results in a timely manner so that the overall monitoring and fixing of certain applications will go smoother and faster and just be overall more efficient.


Upper Great Plains Transportation Institute

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.

  


Valley Express

Project Details
Valley express receives thousands of emails an hour more than what can be dealt with manually. So, they use a system called Echo System that automatically goes through and finds possible truck and load offerings it was created to help with finding and matching loads to trucks. There was a previous dashboard built to display offering and match details, as well as Email summary details. These would all be used by dispatchers to have a clear view. We were tasked with creating a new and improved dashboard for dispatchers to use.

Top of page