<% 7pchelp website introduction %>

In December 2001, I started working on the website for 7PCHelp department at the Northlake College, Irving, TX. This project required more than a few static webpages, so I eventually ended up developing a fairly complex web application. By the end of 2002, I completed the first stage of the project that fulfilled the initial requirements of the 7PCHelp department.

After I graduated from Northlake College in 2003, I added a few enhancements to the site. Currently, my good firend at 7PCHelp, Bryan Mullen, is maintaining and further developing the project.

<% Facts about project 7PCHelp %>

• Started in December 2001
• Completed in July 2002
• Utilizes ASP 3.0, VBScript, ADO 2.6, SQL, Access 2000 DBs, IIS 5.0, Dreamweaver MX
• An essential tool for 7PCHelp department
• An integrated administration section
• User-friendly GUI
• Media equipment reservation/scheduling system

<% Project Requirements %>

• Fool-proof, easy-to-use interfaces for media equipment reservation, PC, phone, and data-drop requests
• Ability to administer the database through the administrative interfaces
• Media equipment scheduling

<% Project Challanges %>

Implementing the scheduling functionality had some challanges:

• Ability to check either single-day requests or entire semester length requests.
• Ability to check selected weekdays and selected equipment. Equipment inventory is needed to become a part of the business logic.
• Ability to check time-frames for each individual days that equipment is going to be delivered. Also, the project required to have ability to detect any possible combinable requests within the time-frame, in order to fully utilize the equipment inventory.

<% Project 7PCHelp Final Release: August 2003%>

• Completed August 2003
• Reorganized website files for an easier management
• Upgraded entire website to HTML 4.0 and CSS implementations
• Added Room Management functionality
• Added LAN Support Request functionality
• Dynamic PDF form manipulation
• Eliminated Dreamweaver templates; instead implemented SSI extensively
• Made the Employees section dynamic