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

Remind 101 - Send Assignments and Documents Straight to Students & Parents' Phones

Remind 101 Update - Now you can send attachments! 
www.remind101.com

I previously posted about Remind 101 as a safe, simple, free way to text your students and their parents.  The service recently added the ability to send attachments via text.  

You can send:

• Homework assignments
• Photos of the white board
• Fun classroom pictures
• Class handouts
• Field trip forms and permission slips
• Add an idea in the comments below... 

You can learn more about Remind 101in my previous post, learn about sending attachments on the Remind 101 blog, or visit Remind101.com to start exploring.

Don’t miss a pick:

Get Nicks Picks for Educational Technology delivered by email, like my Facebook Fan Page, follow Nick on Twitter, or subscribe to the RSS Feed.

MS Excel Personal Timesheet Project (200 pts)

ALL:

JOURNAL ENTRY:  After viewing the following articles and charts, what does the term POVERTY mean?  Find your block on the first link and find out about how many families in your area are living below the Federal Poverty level listed in the second chart listed.  Write 4-5 sentences reflecting on your thoughts about this reality!
Please review this article for your Journal Entry:  Philadelphia Poverty Figures (Click Link)
Federal Averages For Annual Income (Poverty Level) (Click Here For Article)


PAYROLL TIMESHEET LINK:

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

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

Today you will be working on Microsoft Excel and creating a time-card for yourself.  Please read the corresponding story to the number you are given in class to fill out your time-card for the week ending on April 14th, 2014.  We will complete the Example together in class.

Example Employee:  Rate per hour is $10.55.  Monday was a vacation day for eight hours. On Tuesday you worked for eight regular hours and added two hours of overtime.  On Wednesday and Thursday you worked eight hours, and Friday you worked for seven hours until you felt sick at your stomach.  You logged an hour of sick time.  You went in Saturday to make up for the time lost and added one hour of regular time and three hours of overtime.

Here are your scenarios:


Anyone with a last name that starts with A - H will be Employee #1, I - P will be Employee #2, and Q -Z will be Employee #3.  Please use the following scenarios to fill out your timecards.

Employee #1:  You make $20.25 an hour.  You felt sick on Monday and called out sick for eight hours.  You were feeling so much better the next day that you worked eight hours and then an extra three hours overtime to make up for your absence.  On Wednesday you could not be stopped again and put in an eight hour day and one hour of overtime.  Thursday you only were able to work seven hours, and Friday you worked eight hours and an extra hour of "flex" time at the normal rate to make up for Thursday.

Employee #2:  You make $14.50 an hour.  You arrived for work on Monday ready to go.  You put in eight hours and two hours of overtime.  On Tuesday you took a vacation day for eight hours of pay.  Wednesday and Thursday were regular days of eight hours each, and Friday you arrived late after two hours of sick time.  You finished the day strong and added six hours of regular time and an additional four hours of overtime.  Saturday you added four more overtime hours as well.

Employee #3:  You make $13.25 an hour.  On Monday you worked eight regular hours and four hours of overtime.  You took Tuesday as a personal day and clocked eight hours of vacation time.  On Wednesday you worked eight hours of regular time and added an additional two hours of overtime.  Thursday you were not feeling well and used eight hours of sick time.  Friday and Saturday you worked full eight hour days and logged an additional two hours of overtime.

Overtime for everyone is time and a half so multiply your hourly rate by 1.5 and you will have the overtime rate.  Sick time and Vacation Time are the same rate as your regular rate.

Take a look at your TOTAL PAY in the bottom right hand corner.  In your email  figure out what that number would be if you took out the following deductions:

• Local Tax:  4.33%
• State Tax:  3.07%
• Federal Tax:  15%
• Social Security:  6.5%
• Medical Coverage:  1.4%
• Retirement / 401K:  2%

Once you complete your time-card, SHARE it with me (hscribnercaa@gmail.com).  You must also go to the back of the room and PRINT A COPY of your Timecard, Sign it and Date it, and turn it in for credit.

Good Luck!!

- Mr. S