1.)The students should access the Occupational Outlook Handbook index page.
(Occupational Outlook Handbook
)This website is an index page of occupations.
2.)Students should search the website to find information on the nature of the two careers that they have chosen to research. They will need to select the earnings tab to find income information.
3.)In the earnings section students will find wages for career they have selected. The goal of this lesson is to find gross and net incomes for a specific career. Each job might display the earning in a different format. To make sure that everyone is on the same track, tell students that they will be finding a weekly pay schedule based on hours per week. If they find the salary in yearly or monthly amounts, show them how to convert these figures to weekly amounts. Once they have the weekly amounts, they will need to divide them by 40 to get the amount per hour. Make sure students understand that the salaries given are averages for the profession and are not going to be exact.
4.)Have the students open the spreadsheet program. Have them enter the following headings for the given cells:
A1: Weekly Income for a(n) _______,
A3: Hours Worked,
B3: Hourly Pay,
C3: Gross Pay,
F3: State Tax, and
G3: Net Pay.
Have them double click the bar between each column (located above row one) to automatically align the column spacing. Then, highlight cells 3A through 4G and select the center tab from the menu bar.
5.)Have the students center the title, "Weekly Income for a(n) _______," in A1 across the spreadsheet. If using Excel, have them highlight cells A1 through G1, and then select the "merge and center" icon.
6.)Instruct students to make each category bold by highlighting cells A3 through G3 and selecting the "bold" icon.
7.)The students need to enter the information they found in the Occupational Outlook Handbook into the spreadsheet. The hours worked will be 40 and the hourly pay will be the amount that they found on the website. Input the hours worked into A4 and the hourly pay into B4.
8.)In cell C4, have students enter the formula to multiply A4 by B4 (=A4*B4) in order to find gross pay.
9.)Write the amount of each tax on the board for the students. For the purpose of this exercise, use the following fictional percentages or the teacher might research to find the exact percentages for each tax. (10% for the Federal Withholding Tax (FWT), 3% for the Social Security Tax (FICA), and 5.5% for the State Tax can be used.)
10.)Have students convert the percentages to decimals.
11.)In cell D4, the students are to enter the formula to multiply the gross pay(C4) by the percent of the FICA ( 0.03)(=C4*0.03). In cell E4, have the students enter the formula to multiply the gross pay (C4) by the percent of the FWT(0.1)(=C4*0.10). In cell F4, have the students enter the formula to multiply the gross pay(C4) by the percent of State Tax(0.055)(=C4*0.055).
12.)In cell G4, have students enter the formula to subtract each tax from the gross pay (C4) to find the net pay. (=C4-D4-E4-F4)
13.)Tell students to format the cells which represent currency. They should highlight the cells (B4-G4), then select "cells" from the "Format" menu. Select the number tab and choose currency.
14.)To enter information for the second career choice, have students highlight cells A1 through G4, then select copy.
Next, highlight cells A9 through 12G, then select paste. Students may then change the heading in cell A9 and the hourly pay in cell 12B to correspond with the second career choice. The gross pay, taxes withheld, and net pay should all change to reflect the new hourly wage.
15.)Ask each student to type his name, date, period, etc. into specified cells below the data. They will then save the file with their name as the title as followed by "paycheck." Have students print their spreadsheets.