High-Fidelity Prototype for Mobile Learning App

A professor at a large, urban university has requested an interactive learning tool through which instructors can assign students a series of experiences, each of which has associated tasks. Experiences will be scheduled by each student, completed in real-time, and may include a variety of questions and media submission types.

Previously, PHP code, database structure, and low-fidelity designs were created. This semester a high-fidelity, interactive prototype with the following criteria was completed:

  • Improved the user interface to increase mobile usability.
  • Modified formatting to match new designs from client.
  • Completed distinct functions for instructors and students.
  • Created a new structure for experiences, tasks, and deliverables.
  • Changed programming and database to display reminder text for experiences and tasks.

Project Student:  Heidi L. Davis

Budgeting Program for Local Science Institute

An application is needed for a local company that creates clinical trials and treatments using recent scientific discoveries. The company is funded by multiple state universities along with other private and public partnerships. Currently, this company uses Excel spreadsheets to track their budget and disbursement of funds.

The goal of this application is to give them a web based system to track the information they have each year. Previous work on this project has included building a database with Oracle and creating a front side user interface application on Microsoft Visual Studio utilizing ASP.NET MVC with AJAX and Razor views. All of the pages have been updated to include functional, interactive tables. Pages for calculation details showing how funds are disbursed for payments still need to be created, as well as a history page to allow the company to view past record updates.

Project Student: David Hahn

Inventory and Billing Software

An Indiana landscaping company wants a new system to store information on their inventory and billing. They have been using Excel spreadsheets to keep track of everything up to this point. This set up has been successfully replaced with a database using SQL Server. The front end was created in Microsoft Visual Studio with web forms. The web forms application has a good start, but still requires a login system, better control of the action buttons, and more CSS to give it the look the company would prefer. It also needs systems for notifications and reporting.

Project Student: David Hahn

Security Operations Center

The purpose of this project is to determine if a free, open-source program can function in the role of a Security Operations Center for a Fortune 500 Company.  This program is needed to analyze a network, or multiple networks, for a variety of threats.  It also needs to be able to display alerts from the threats on a centralized server.

Security Onion is the program currently being examined for this project.  It meets the necessary requirements, while also being a free, open-source solution.  The interfaces included in Security Onion can also display alerts in real-time.  Security Onion has been tested on VLANs and is able to collect data from multiple networks.  Security Onion’s Elsa program contains dashboards on web interfaces to visually show alerts and other types of information that has been collected.

Project Student: Michael Thomas

Database Management and Modification

The purpose of this project is to make necessary modifications to a database in order to handle the information of the current and new games in order to meet the client’s requirements. First it was necessary to create a new ER diagram to analyze, understand, and document the functions of the database. Following that, the PHP files that insert to and modify the database were analyzed and developed to improve communication between the game websites and the database.

Project Team Members: John Foust, Juancarlos Martinez

Local Not-For-Profit Logical Network Map

A local not-for-profit needed a Logical Map of their entire network, since the Physical was already completed. The logical network included the names of the desktop computers, as well as which network they were connected to. These were based on the IYG assets that were in an Excel document, then grouped based on different categories from a Word document. Some of the categories were: Operating System, Type of BIOS, Model Number, and IP address. Lucidchart was used to document the network based on this categorization of assets.

Project Team Members: Clay Hampton, Randall Huber

Virtual Lab Environments

This project provides university students access to virtual machines and environments for penetration testing, networking security, and forensics practice, as well as SQL databases. With a current total of five machines running virtualization software, our servers currently support 29 usable VMs. Our an application container server can accommodate an expanding number of SQL databases. It was created using commodity off-the-shelf hardware and open-source software.

Project Student:  Ivan Cardenas

Build WordPress Online Forms

A local non-profit organization website dedicated to finding foster homes and adoptive owners for dogs in the state of Indiana needs their adoption process updated. Currently the application process to adopt a dog is done via a pdf that has to be either scanned and emailed, or sent out by regular mail to the organization.

The goal of the project is to turn those pdf forms into actual online forms where the user can fill out and submit them on the same site, without having to physically send them or email them. The purpose is to create a better experience and facilitate the job of their personnel making it easier for them to track and file the applications.

WordPress is the content management system used for the site. To create the forms, a plugin called FormidablePro will be utilized, as it allows for the creation of easy forms that can integrate into a WordPress site with ease.

Project Student : Jorge Valdivieso

Compensation Calculator

This project is to design and implement a Compensation Calculator for a local government personnel website. The personnel department would like to add to their website a web application that will help a new or potential associate calculate the total amount of compensation to be received in their new position based off the current year’s benefit rates found on their website. The department currently uses an excel spreadsheet designed to use the posted salary amount, then gives an estimated total of compensation expected to be received as remuneration. A web application with a small database was designed and implemented, and still in the design stages.

Project Student: Bonani Ndabambi

 

Administrative Database

For this project, I created a back-end database for an administrative office within an educational institution. The client is currently storing all of their information in excel files, and needed a database in order to have a more professional representation of their data. I achieved this goal by designing the database using an ER diagram, and then implementing the design into tables using SQL Server.

Project Students: Kurt Pittman