Tuesday, October 11, 2016

Spreadsheets Day III - Personal Timecard

Today you will be using Google Sheets to complete a basic timecard.  Millions of people complete these weekly to report the time they spend at their jobs.  Most of these timecards are used to calculate the paycheck that is sent to the home for the work they do.  It is critical that you learn the basics of how this document works, and how to calculate basic taxes and deductions.

PAYROLL TIMESHEET LINK:

Google Drive Spreadsheet:
https://docs.google.com/spreadsheets/d/1aMU_xQllDqqzcFWPa-ZohK0zgclox-gXVD1L4NSoYpo/edit?usp=sharing

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

Today you will be working on Google SpreadSHEETS 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 October 16th, 2016   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 (hscribner@ccs.us).  

 You must also PRINT A COPY of your Timecard, Sign it and Date it, and turn it in for credit.


 Step By Step Instructions:

1.  Make sure you fill out the top of the form completely.  In the real world you would make sure your name, address, phone number and other information are correct.

 2.  Change the WEEK ENDING date to the Sunday at the end of this work week.  Make sure, at other employers, you are following the prescribed work week. (Does it start or stop on a specific day)  Make sure you are reporting hours for the correct days and times.  This is a LEGAL Document.and must be correct prior to you signing it.

 3.  Using the specific example (based on the initial of your last name) and enter the RATE OF PAY in the correct box at the bottom of the sheet.  Make sure to enter formulas to make the Overtime, Sick, and Vacation times work automatically.

4.  Once your Rate Of Pay entries are correct, Enter the appropriate times for each day into the cells that correspond with when you worked Regular Hours, Overtime Hours, Sick Hours, or Vacation Hours according to your example.

 5.  Double Check your entries.

 6.  Enter each of the rates of tax accord ng to the example.  You must change the percentage rates into decimal point values to use them in the equations.  Make sure the entries are correct.  Below the tax rates enter an equation that multiplies the total amount of pay by the tax rate (decimal) and you will get the amount of the specific deduction for each item.  You will see that these totals are deducted from your total pay and the amount of your check for the week appears at the bottom.

 7.  When it is complete, PRINT a copy of your timecard,  Write your (cursive) SIGNATURE accross the appropriate line and print the date in the box provided.  Turn it in for credit.  You must also SHARE your online document as well with Mr. S at hscribner@ccs.us.

Good Luck!!

- 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 at

UN Global Sustainability Goals Project Map

Word Counter For Text

This free script provided by JavaScript Kit

Integrity (13 Characteristics)

13 Characteristics of People Who Have Integrity

1. They Value Other People's Time: They value their own time so they also value the time of other people. They know you have plenty of other places you need to be and won’t hold you up. If you spend time with them, it is likely they will thank you for that as well.

2. They Give Credit Where It Is Due: They do not take credit for things they did not do. They will always credit those who deserve it. If you help this person with a project he or she will likely mention your name so you can take credit for your work.

3. They Are Authentic: They are their truest forms. You won’t catch them in a lie or being fake.

4. They Are Always Honest: They are honest people that feel no need to lie as it is important for them to get to where they need to get in life honestly.

5. They Never Take Advantage Of Others: They are not the kind of people who will take advantage of someone else. They love to build people up and help them get where they need to be. Taking too much from someone else will never be an issue with someone who has a lot of integrity.

6. The Do Not Argue Over Disagreements: They will talk through things in a civil manner or not talk at all. You cannot and will not force this person into arguing over something completely ridiculous. I find this to be a very respectable trait.

7. They Give Most People The Benefit Of The Doubt: They try to see the good in everyone. I think this is because they feel like maybe there are more people in this world that also have integrity. That being said, if you take advantage of them too much they will get rid of you.

8. They Know When Something Is Bothering Someone: They have a great intuition that lets them know when something is going on. If someone is down in the dumps they will notice. Chances are they will actually do what they can to cheer you up.

9. They Believe In Others: They accept your word as truth until it is dis-proven. That being said, they do not take lying well. And once you lie to them, it is unlikely that they will ever take your word again.

10. They Apologize First: If they have done something wrong they will come to you and apologize. This is just how they are. They own up to their mistake and try to make things right.

11. They Are Humble: They do not quite know their own worth. While they are very important and do so much good they don’t quite see it. You should remind them of it.

12. They Do Good When They Can: They are always helping other people. They love to know that they have improved someone’s life. It gives their lives meaning.

13. They Are Always Kind To Those Who Need It: Giving kindness can go a long way. When someone looks like they need a little pick me up these people deliver. They can brighten up almost anyone’s day.

If you are someone who has true integrity, thank you for being who you are and thank you for all that you do. You really do actually make a difference in society, please keep up the good work. If you feel no one else is proud of you, know that I am.

Total Pageviews