Sesame Street Payroll Project (400 pts)

Today we will walk through creating a TIMECARD and POSTING IT to PAYROLL
SHEETS on GOOGLE DRIVE.  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. 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://drive.google.com/file/d/0BzY9jTFcLEUWUkhYSk5TT0NjMFk/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:


GOOGLE SPREADSHEET BLANK TIMESHEET LINK:

(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdDUyajRIY1gxLXpwSE5ZeXRLMEdmTUE&usp=sharing



MS EXCEL PAYROLL TIMESHEET LINK:

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



Finally,  Use the form below (Make a Copy to add it to your Google Drive) 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.  When complete, simply share your work with Mr. S for comments/grading.





Payroll Project Google Spreadsheet (Blank):

(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdEVWLTlSTFR3bVp1RmV2d0h1YWtXZVE&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