Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Week 12

Week 13

Week 14

Week 15

Week 16

Week 17

Week 18

Final Exam

OBJECTIVES

Use formulas in creating Excel spreadsheets

TUESDAY

Use EXCEL to CREATE
PIE CHARTS

Use  EXCEL to CREATE
TIME BANK Spreadsheet
 

Use EXCEL to CREATE
Column Charts and Line Charts

WEDNESDAY

Part 1) Recreate the spreadsheet below. You can choose your own colors, but make sure you demonstrate knowledge of Word Wrapping, Borders and Cell Shading.

Part 2) For the Hourly Jobs, Calculate the areas that are shaded in light green so you can compare the different jobs. To convert hourly pay to Daily Pay, just multiply the Hourly Pay by 8. In other words, in cell D2, type =E2*8 then hit ENTER. In cell C2, type =D2*250
(We will assume that there are 250 work days in a year)

Part 3) Calculate the values that should go into the rest of the light green areas. You'll either have to multiply or divide to get the correct amount! (HINT: You will probably be using the
numbers 8 and 250 a lot in these calculations)

THURSDAY

Complete Tyson Payroll Spreadsheet.
Directions are in the spreadsheet in the grey box.
 

FRIDAY

Complete TYSON Payroll and
Job Wages and Salaries
Spreadsheet

jeremy.patty@pcls.net

440-392-5138