5th Annual AITP
National Collegiate Conference
Webmaster Contest using FrontPage ’2000
CONTEST
PROBLEM SPECIFICATION
Progressive Solutions is an IT consulting firm specializing
in Web-based solutions to classic business problems. Your team has been assigned the task to develop an Intranet
web site that allows the current customer to give appropriate access to employee
vacation and payroll data. Access
to the data is directed by the security level of the employee position:
| CFO – |
Full Access (CFO applies Position and Merit data to the employee data as evaluations and position changes occur). |
| Payroll Supervisor – | Full Access to all except Position and Merit, which is limited to read only (makes Current Salary entries for all employees). |
| Payroll Data Entry – |
Access to All except Salary, Position and Merit data, which is limited to read only (creates employee entries and retrieves employee entries for data modification). |
| Employee – | ID Number update access to all BIO data, i.e. Address Change, and all other data limited to read only. An employee is only allowed to see their own data and does not have create privileges. |
An Employee must complete a form to request vacation
indicating desired beginning and ending dates.
Once complete the form is “Submitted” and the Bonus pay is calculated
** and the vacation request is validated (an employee must complete 6 months of
service before taking a vacation). A
printable response is returned to the employee indicating approval status, Bonus
pay amount and remaining vacation status. Bonus pay is calculated based on Years of Service from
employee Start Date.
The Payroll Data Entry Operator needs a form to create new employees and modify data for existing employees. The form needs to generate an Employee Number and collect Employee First Name, Employee Last Name, Employ Address, Employee City, Employee State (from list box), Employee Postal Code, Start-Date, Federal Tax-Code (from a list box), Insurance Code, FICA and State Tax-Code (from a list box).
The Payroll supervisor
requires a form to enter Current Salary information for new employees and update
existing employees as needed. The
supervisor also requires a form to request a vacation/bonus status report for an
individual employee’s or for all scheduled employees.
(note: a database indicator is turned on when an employee is scheduled
for vacation)
The CFO needs a form to enter Position Code (selected from a list box) and Last Merit Code (selected from a list box) for all new employees and to update existing employees as needed. The CFO requires the ability to request an employee status report per employee ID or by selected criteria.
** Bonus Pay
Table
1-5 years of service
: 2% of Current Salary
6-10 years of service
: 3% of Current Salary
11-15 years of service : 4% of
Current Salary
16-20 years of service : 5% of
Current Salary
21-25 years of service : 6% of
Current Salary
26-29 years of service : 7% of
Current Salary
30+ years of service
: 10% of Current Salary
Judging:
The contest judges will evaluate each team’s result according to the following framework:
|
Functionality |
40% |
|
Ease of Use |
30% |
|
Overall Appearance |
20% |
|
Ease of Maintenance |
10% |
In the event of a tie in ranking, the time of submission of the team’s URL will be used as a tie-breaker (earliest team wins). Please note that your web site and source code should not contain any information that identifies your team except your Team Number.