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
){kind=link}
0 Comments