Sesame Street Payroll 2016-2017

Yesterday you created TIMECARDS.  Today you will we will walk through 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. For credit you must SHARE your PAYROLL SHEET with Mr. S (hscribner@ccs.us). When
complete, you should know how to enter data on a form, manipulate the
form to complete basic functions.  You will also know 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 (Click Link Below):

https://docs.google.com/document/d/1Un_BaJ_8pVRb6PkWkCXY89vfPUlq_SgXK5B0PaOTsl4/edit?usp=sharing



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 (Click Link Below for BLANK COPY):

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

https://docs.google.com/spreadsheets/d/14TXf0TwHXNYfZhWpFerTvTy-OOf9OIkKt5g9iCzkom4/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. 



STEP BY STEP:



1:  Sign into your CCS.US Google Account.  Click the link above to OPEN the "Payroll Project Google Spreadsheet"(PPGS), click FILE and MAKE A COPY and Rename it "Sesame Street Payroll (Your Last Name) P(period you attend my class 1-4) 



RENAME EXAMPLE:  Sesame Street Payroll Scribner P1



2.  Using the information on the "Payroll Project Word Worksheet" - Enter the header information correctly on the PPGS.  Make sure to enter the Company Name, Company Address, Phone / Fax, and Dates Covered.



3.  Enter all of the individual information for each Employee.  This includes entering the Employee Name, ID#, Hourly Rate, Hours Worked, and Overtime Hours.



4.  Using the formulas located ON THE SPREADSHEET, create formulas in each box to calculate the GROSS PAY.  Create formulas to calculate the amount of FICA, Fed. Tax, and State Tax.  Finally, create a formula to calculate each employee's NET PAY. 



Note:  you must change the percentages to decimals and type them directly into each formula, or reference them in each formula.  We have not discussed CONSTANT REFERENCES yet, so be careful the formulas do not change if you reference your cells incorrectly.



5.  Repeat STEP 4 for each employee.  Check your work against the examples below.  Other than the DATES COVERED, the totals should be the same.  DO NOT JUST HAND TYPE THE FIGURES BELOW.  YOU MUST USE FORMULAS IN EACH CELL TO ACHIEVE THE CORRECT FIGURES AND TOTALS.  When you have finished the worksheet should now be "automated", and you can SHARE it with me for credit at hscribner@ccs.us.



Thank you for your perseverance and good attitudes!



- Mr. S

ACADEMIC/LEARNING OBJECTIVE

Students will learn to use electronic spreadsheets for basic calculations, data storage and evaluation, and other tasks.  Students will complete basic spreadsheet tasks, simple functions, and basic formatting.  Students will be able to create, work with, collaborate on and share spreadsheets for classwork and basic applications

STUDENTS MUST START BY READING ALL DIRECTIONS ON CLASS WEBSITE!

Students will view instructional videos in class, followed by practical lessons.  Students will create, work with, store, and collaborate on basic spreadsheets using Google Sheets.  Students will be introduced to basic math, functions, formatting and organizational features of the spreadsheets.  Students will prepare to complete a basic QUIZ at the end of the lesson next week!

READ ALL DIRECTIONS CAREFULLY!

THANK YOU FOR YOUR ATTENTION AND POSITIVE ATTITUDE TODAY!

Standards Covered In This Class  

PA 3.7.7 & 11 Section C / ISTE 2011

CSTA Tied With Common Core ELA/Math rev. 2011

 Posted by



Harvey Scribner