Excel Programming Assignment
Purpose: This assignment is intended to let you demonstrate
your ability to create an application using Excel that incorporates
data collection, writing data to specific cells, and automating routine
processes. Your application will also make use of advanced Excel functions
to improve its function and/or appearance.
You work for a small sub-contracting firm with 12 employees
working two shifts. Your boss wants to create a simple means of entering
hours - regular and overtime - for each employee for a given week. She'd
like to see the outcome as a report showing the wages to be paid to
each employee for the week, plus the total hours worked and wages paid
for each shift. She's concerned about employee privacy and wants the
calulations to happen on a seperate sheet from the report. The report
may look like this:
The calculation page should include a list of employees,
the shift they work, and their hourly wage. When the employee turns
in their hours, your boss would enter the hours next to their name,
and the spreadsheet would calculate their pay based on 40 hours of regular
time plus time-and-a-half for hours over 40. It should also determine
the total hours worked and pay for employees in each shift. That page
might look like:
To make the process easier, your boss would like an input
form that will allow the user to select or enter an employee's name,
and the number of hours they worked. Clicking a button on the form would
write their information to the correct cells of the spreadsheet and
the total would recalculate
This project is worth 25 points. In order to earn 16 points,
you must create an Excel 2000 worksheet that includes:
In order to earn a score of 22 points (80 points) your project must also
include:
