1	Cooperative Education Recording Payroll Barbara A. Decker Tools & Concepts for Data Analysis Spring 2008
2	Target Audience Cooperative Education students Grade 12 Earn 15 credits for successfully completing course Working a minimum of 15 hours per week 550 hours over course of school year September - May
3	NJCCCS NJ CCCS 8.2 – Technological Literacy 8.2A1-3 8.2B1-6 8.2C1-3 http://education.state.nj.us/cccs/?_list_cpi;c=8;s=2;g=12
4	Purpose Record and track hours worked each week Record gross wages, deductions, and net wages weekly Determine what portion of wages is withheld for tax purposes Retain proof of wages
5	Objectives The student will: Provide proof of wages weekly or bi-weekly Record hours and wages in Excel spreadsheet Record gross wages, deductions, and net pay in separate spreadsheet
6	Objectives The student will: Graph information from each spreadsheet Determine if he/she is progressing toward year end goal of 550 hours in a timely manner
7	Timeline
8	Activities – Part 1 Create Excel spreadsheet to record: Hours worked Including monthly and year to date totals Gross wages Including monthly and year to date totals Graph hours worked Determine if student is on target for goal of 550 hours
9	Activities – Part II Create Excel spreadsheet to record: Gross wages Deductions Net pay Graph gross wages, deductions, and net pay Allows students to see where money is going
10	Recording Data
11	Recording Data
12	Uncle Sam’s Portion?
13	Recording Data
14	Assessment
15	Sources Microsoft Clip Art New Jersey core Curriculum Standards-Technological Literacy. Retrieved April 28, 2008, from New Jersey Core Curriculum Standards Web site: http://www.state.nj.us/education/cccs/http://education.state.nj.us/cccs/?_standard_matrix;c=8