OBJECTIVE
Students will learn how to record employee earnings and deductions in a payroll register and employee earnings record.
EXCEL SKILLSMove and copy worksheet, enter formulas using relative and absolute cell references, format cells, AutoSum, format painter, auto fit column width and row height, insert columns, insert various functions, merge cells, insert text box, apply borders, wrap text, save file.
|
MATH SKILLS Basic operations with whole numbers and decimals, estimation, rounding, converting percentages to decimals. Creating formulas.
|
Do Now: Look through the pay stub below and answer the questions under the image.
Activity 1: Before we work on a payroll register lets review some math concepts. Look at the Deductions shown below highlighted in Yellow. Using the data given to you tell me the PERCENTAGE of the deduction.
Activity 2: Download the following File and submit once you have completed the activities.
COMPLETE ALL 7 ACTIVITIES!!!!
payroll_register_part_i.xlsx | |
File Size: | 56 kb |
File Type: | xlsx |
payroll_register_part_ii.xlsx | |
File Size: | 26 kb |
File Type: | xlsx |