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

Secure Cloud Infrastructure

The purpose of our project is to configure a secure cloud server to operate using OpenStack Juno on Ubuntu. We have four nodes that will operate together at the end of the project. When everything is complete you will be able to launch multiple instances and expand your network rapidly while managing your resources efficiently. You will also be able to monitor traffic, detect and prevent internet intruders.

Project Students: Nichole McFarland, Justin Salyer, Khalid Alsufayan

Onsite Networking

Living Lab onsite networking for non-profit organizations that have come for tech support and network support in there small business areas. We are currently working on repairing a network for a non-profit organization and we will be on backing up a whole system for another.

After a long semester of hard work the projects for the selected clients are complete and their networks are running optimally for their needs. There are no longer any infections and they are secured for the reminder of the year.

Students: John Stipe and Alec Hawes

Reflexion Application Project

Our client would like to develop a mobile application that the instructor can track their students. They would like the students to be able to: post their location, submit their assignments, use different media to submit their assignments (picture, video, voice), be able to send a notification to the instructor if they need assistance, and be able to clock their time on the assignment site. They would like the instructor to be able to: create assignments, deadlines, and quizzes; be able to track their students location, be able to assign grades through the application as it is also interfaces with a Learning Management System (such as Canvas), and be able to notify students via notifications as well.

Project Students: Darius Mpinga, Ronny Ovando, Amadou Traore

Point-Of-Sale Database

The project goal is to troubleshoot a POS (Point Of Sale) Database. There are some problems with queries about returned damaged equipment. The return table is only showing POS data and not return data.  Also, returned items field tickets show up in the database, but are not showing up in field ticket items. This database uses Microsoft SQL Server on backend and Microsoft Access on the front-end.

Project Student: Khurram Khan

SalaryCalc Application

This application is intended to calculate an employee’s salary based on their job codes or title. The user is to select their title or job code, and the application will prompt with more options that the application will use to make the necessary calculations for the associates’ salary.

Project Student: Bonani Ndabambi

Ticket System

The client requested a database for the purpose of tracking service tickets and their status. The database is designed to store data on projects and provide easy viewing for their current status. Through trial and error, I discovered that the uniteAll command would not permit the user to edit any entries in the queries, so a solution needed to be constructed. Two separate views were constructed in order to meet these requirements.

Project Student: Khurram Khan