Introduction to Excel


ASSIGNMENTS




Link to Excel Projects - Progress Sheet










































#1
  1. Download this Excel workbook and save it in your class folder:
  2. Complete the Vocabulary sheet
  3. Complete following sheet on fast food.
  4. Click on the Intro to Walk & Rock tab & complete
  5. Click on the Walk & Rock tab
  6. Follow the directions in red numbers on EX17 to complete the worksheet
  7. Your finished spreadsheet will look like EX 3
  8. Follow the instructions are on pages EX 17 - EX 54
Save as Walk & Rock
#2
Apply Your Knowledge
  1. In the Excel Assignments I workbook, modify the spreadsheet on the tab labelled: Bicycle Shop
  2. Follow instructions on pages EX 70 - 71 under APPLY YOUR KNOWLEDGE
  3. Make the spreadsheet look like the finished example on page EX71 (b) After
Apply 1-1 Bicycle Shop
#3
Extend Your Knowledge
  1. In the Excel Assignments I workbook, modify the spreadsheet on the tab labelled: Sheet 4
  2. Rename the tab Sheet 4 to: Pack Away (Right click on sheet tab to rename)
  3. Follow instructions on pages EX 72 - 73 EXTEND YOUR KNOWLEDGE
  4. Start with #1 under Formatting Cells and Inserting Multiple Charts
Extend 1-1 Pack-n-Away Shipping
#4
Make it Right

You will COPY & PASTE this worksheet into a new tab in the Excel Assignments I workbook.
  1. In the Excel Assignments I workbook, add a new sheet: click on the tab to the right of your last sheet (Pack Away) and you will see it appear.
  2. Right click on the new tab and rename it: Book Sales
  3. Download this spreadsheet:
  4. COPY AND PASTE this spreadsheet onto your new spreadsheet: Directions on HOW TO:
    1. Copy this spreadsheet by RIGHT-CLICKING on the cell above row 1 and select COPY
    2. Go to the Excel Assignments I workbook and your new Book Sales blank spreadsheet and RIGHT-CLICK the cell above row 1 and PASTE.
  5. Follow instructions on pages EX 73 - 74 under MAKE IT RIGHT
Make it Right 1-1 Book Sales
#5
In the Lab
  1. In the Excel Assignments I workbook, add a new sheet: click on the tab to the right of your last sheet
  2. Right click on the new tab and rename it: Kona Coffee
  3. Follow the instructions on pages EX 74 - EX 75 under IN THE LAB
You should have 5 tabs with 5 completed spreadsheet when you are done.
Kona's Expresso Coffee
5 Extra Credit---- Points
for each
additional spreadsheet
Cases and Places - EX 79- EX 80
Your Choice

Project: Create an excel spreadsheet displaying the annual salaries for eight careers of choice. Use the U.S. Bureau of Labor Statistics Occupational Handbook at this address:
http://www.bls.gov/ooh/
For each display the following data for each career:
  • the lowest 10%'s annual wage
  • the median annual wage
  • the top 10%'s annual wage
Display a bar chart of this information.
Display a bar chart of only the mediam annual wage for all careers.