Payroll Spreadsheet Project (Formulas & Reference Cells)

OVERVIEW

Last week 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 (harvey.scribner@techfreire.org). 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.

PROJECT DELIVERABLES

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

Student Payroll Project Google Document Directions Worksheet (Click Here)

(❗️) Student Payroll Project Spreadsheet (Click Here)

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.

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.

(❗️)GMAIL ASSESSMENT ACTIVITY
Go to your GMAIL and click COMPOSE. Send an email to Mr. Scribner (harvey.scribner@techfriere.org) with the following information: 

Answer the following questions in an email to Mr. S:

(harvey.scribner@techfreire.org) 
You may copy/paste the questions into the email.

1.  Who made the most overtime money?

2.  Who made the least amount of money?

3.  What was the total amount of FICA money paid for everyone?

4.  How does Sesame Street Inc. make money?  What do they sell?

TO:  harvey.scribner@techfreire.org

SUBJECT:  Payroll Spreadsheet Project

Body of Message:  Answer All Questions Listed Above (Copy/Paste Questions into Gmail)

R.A.C.E.S. Method R - Repeat the Question, A - Answer the Question, 

C - Cite Evidence, E - Examples / Explanation, S - Summarize your Thoughts

STEP BY STEP
1: Sign into your Tech Freire 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-7)

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. 

WARNING: 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 harvey.scribner@techfreire.org

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 THOROUGHLY!

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.

ACADEMIC STANDARDS

Common Core Math Students consider the available tools when solving mathematical problems and working with/understanding data sets.

PA SAS Digital Literacy Use Technology to enhance effective communication. Use technology to enter and manipulate data and text. Apply basic mathematical operations to solve problems.

CCSS.ELA-LITERACY.RST.6-8.2 Determine the central ideas or conclusions of a text; provide an accurate summary of the text distinct from prior knowledge or opinions.

CCSS.ELA-LITERACY.RST.6-8.3 Follow precisely a multistep procedure when carrying out experiments, taking measurements, or performing technical tasks.

CCSS.ELA-LITERACY.RST.6-8.4 Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 6-8 texts and topics.

CCSS.ELA-LITERACY.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).

CCSS.ELA-LITERACY.RST.6-8.9 Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.