SQL Reporting

This project was done for a not-for-profit organization.  They wanted to move their current database that is in FileMakerPro to Microsoft SQL Server.  They also wanted to know what applications they could use to write reports for the system.  The student recommended SQL Server Reporting Services (SSRS) because it was easy to use and free. …

Sarbanes–Oxley Reporting

This project was done for an outside company that the student was doing work for.  The company went public and needed to have controls implemented and an audit created to make sure procedures and policies were being followed.  The student designed and created reports using SQL Server Reporting Services (SSRS).  Also the student worked with…

System Network Administrator

This student had the opportunity to do an Internship at a nonprofit.  He worked 22 hours a week.  His responsibilities involved day to day network and server maintenance of internal and external enterprise level systems, firewall management, VMware virtual environment administration, system monitoring, and handling customer requests/issues.  Project Student: Eric Hartsock

Uninterruptible Power Supply Install

The students in charge of this project started by taking inventory of the existing Uninterruptible Power Supplies (UPS) and the device that is connected to them.  The goal of this project was to remove some existing UPSs and install new ones.  The students used four existing UPSs and added nine new UPSs to the server…

Laptop for Risk Assessment

The student that worked on this project prepared a Dell Inspiron 1420 for the risk assessment class.  The student first wiped the hard drive using DBAN.  Next, the student integrated data drives to the Windows XP CD and then installed Windows XP onto the laptop.  Finally the student navigated to dell.com to download the drivers,…

Inventory Server Room

The goal of this project was to sort through the old hardware located within the server room.  The student on this project tested old Dell and HP computers to determine their functionality. In order to complete this process the student booted from Ubuntu live CD and then tested if he could access the hard drive. …

Windows Server 2008 R2 Install

This task was to install the Windows Server 2008 R2 inside the VMware Workstation.  The student downloaded Windows Server 2008 R2 Standard, Enterprise, Datacenter, Web x64.  The next step was to create a new virtual machine and install the OS.  While the student was installing, VMware automatically picked which version to install which was the…

Oracle Database

The objective of this project was to prepare two computers for a university class.  One computer needed to have a patched version of Windows XP SP3 and Oracle 11g.  The other computer needed to have an unpatched Windows XP and Oracle 11g installed.  The student was provided a Dell OptiPlex GX280 and a Dell OptiPlex…

University Department Website

The objective of this project was to make updates and changes to the university department Website.  The major problems that needed changed were the purpose of the site caused confusion and needed to be more precise, the site had very little information for prospective students, businesses, and donors, and lastly the overall look of the…

MSD of Non-For-Profit

During the course of this project the students collected IT equipment from other buildings and transferred it to the new construction site.  A design also was made for some of the labs that will be within the new buildings.  During the design process, cable management was thoroughly thought over to ensure the best practice. When…