MS Excel Payroll Project (30/3-4)

Today we will walk through creating a TIMECARD and POSTING to PAYROLL SHEETS in MS EXCEL.  You will be required to follow along in class.  At the appropriate time you will complete the work on your own over the next two days and show Mr. S in class.  If you require more than one class to complete the worksheets below, you must save the work to your flash drive as an (xls) file to continue working on it tomorrow.  When complete, you should know how to enter data on a form, manipulate the form to complete basic functions and how to automate the form by copying functions and formulas to additional cells.

Start by reviewing the following sheet of instructions either online or use the copy at your desk:

Payroll Project WORD Worksheet:
https://docs.google.com/file/d/0BzY9jTFcLEUWMWl2RkNmSFp3cTg/edit?usp=sharing

Second, choose one character from Sesame Street to create a TIMECARD for.  Make sure that you evenly space out the character's hours evenly over the work week as if they had worked for a real company you operate.  Use the following link to download a blank form and adjust the figures to be accurate for your character:

PAYROLL TIMESHEET LINK:
https://docs.google.com/file/d/0BzY9jTFcLEUWYVMxdnZpLVQtbmc/edit?usp=sharing

Finally,  Use the form below (download and open with MS Excel) to create a PAYROLL SHEET for the whole company of characters.  We will work on this in class.  Pay attention and follow along and you will be able to complete the work with little effort.  Call Mr. S over to review and grade your work when finished.

Payroll Project EXCEL Worksheet (Blank):
https://docs.google.com/file/d/0BzY9jTFcLEUWWGJzZGVvRWNEVjQ/edit?usp=sharing

See examples of blank and finished payroll sheets below.  Numbers in the active worksheet must be formulas, not just numbers entered alone.  The worksheet must be "automated" for credit.  Good Luck.

- Mr. S