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
0 Comments