Author Archives: Livlab Student

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

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

Windows Server Updating Services (WSUS)

The project was to solve the issues a WSUS server had with client communication to workstations. The main issue was that the batch cloning of the workstations left them all with the same GUIDs. Following the fix, a single workstation connected to download the updates, and double checked that nothing broke, before sending the updates to the rest of the workstations. The server is now running normally, with no apparent issues.

Project Student:  Kinnon Roudebush

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

Build System Monitoring Solution

An educational entity requested a solution that is capable of auditing their workstations. Their primary goal is to monitor logins to ensure that workstations are not being accessed after open hours. The ideal solution would also generate and send emails as alerts.

Expanding on the original scope of the solution, LibreNMS was chosen for its capability to monitor events at a system level through syslogs as well as provide a centralized, web-accessible platform to analyze overall network traffic, addressing information, and system specifications. Batch scripts were written to automate the configuration of the workstations’ SNMP and syslogs. A combination of batch scripts and task scheduling were used to identify workstation logins at specific times.

Project Student:  Keith Cornell