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
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
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
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
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
A transparent proxy server was created and implemented. The purpose of the transparent proxy is to reduce bandwidth and increase download speed. A virtual machine utilizing pfSense (a Linux based firewall) with a Squid transparent proxy add-on was created to provide easier manageability. Reports can be generated to show details regarding web traffic as well. pfSense has additional features that can be utilized to consolidate various programs into one server with a web interface. These features include, but are not limited to, Wake-on-LAN, OpenVPN, and ClamAV anti-virus. Currently the proxy server is incomplete, as additional VLANs need to be added.
Project Student: Heather Bullard