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

Implementing Collision Prevention for Objects in a JavaScript Plugin

A local organization offers different facilities for rent to the public for special occasions, like wedding receptions and business-related events. Previous students created a JavaScript plugin that allows users to create custom-made floorplans online. This is done by a “drag-n-drop” menu, in which users can arrange tables and chairs on a floorplan of their choice to meet the needs of their special event. Also, previous work on this plugin included creating “non-drop zones,” which prevents users from dropping objects on walls and fireplaces. However, there was nothing to prevent the furniture from colliding and overlapping.

After researching and testing, the solution to this problem was JQuery’s UI Draggable Collision (UIDC) plugin. Over 4500 lines of code were reviewed and dissected, and the UIDC solution was successfully implemented in the code. Now, objects in the floorplan are prevented from colliding. A second task was to insert newly-designed images into the code of the plugin, which was also accomplished.

Project Student: Thomas Wilson

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

Security Analyst

This project incorporates many facets of security for computer systems and the network they are on. The client wanted the possible vulnerabilities and threats to their network and systems documented. If any are found, the job is to find solutions to mitigate and or remove those possible problems.

Many security tools such as OpenVAS and GRR Rapid Response were used in the vulnerability finding process. Using these tools among others gives a nice basis to find, document, and find solutions to, any possible problems that may arise.

Along with the implementation of theses programs, setting up and installing servers and the troubleshooting also goes along with the project.

Project Student: Ryan Stav

Movie Database on SQL Server

The project consists of creating a movie and TV show database for students to use in a database course. Scraper.io was used to retrieve data from IMDB for the sample data. Python was then used to clean the data, sort it, and split it up. Excel was used to store the data for easy formatting and modification, before exporting it as a csv file for importation into the SQL tables.

Project Student: Blake Neu

iTALC Deployment

The purpose of this project was to implement iTALC on a pair of labs’ workstations.  The problem was that professors needed a presentation tool to control what can be done on each lab computer.  Each lab computer, and both instructor stations, were set up with the iTALC software.  Now professors can view a live feed of all students’ lab computers, control what students can see during a presentation, and prevent cheating during testing.

Project Student:  Jamey Owens

GAG Bootloader Solution

A lab’s workstations needed to be able to use wake-on-LAN and remote tools, but were not able to load after reboot using their prior bootloader.  Previously, the lab workstation would be prompted with a nag screen making each workstation inaccessible until a button was physically pressed.  GAG bootloader can now be used to boot into the multiple operating systems that are used on each lab workstation, with a graphical interface that allows for wake-on-LAN and remote services.

Project Student: Jamey Owens