Intro+to+Excel

=** Introduction to Excel **=

**ASSIGNMENTS**

Link to Excel Projects - Progress Sheet


 * #1 || # Download this Excel workbook and save it in your class folder:
 * 1) [[file:Excel Assignments I.xlsx]]
 * 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. for each additional spreadsheet || **Cases and Places** - EX 79- EX 80 Your Choice ||  || http://www.bls.gov/ooh/ For each display the following data for each career: Display a bar chart of this information. Display a bar chart of only the mediam annual wage for all careers.
 * 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:**[[file:Make It Right 1-1 Book Sales.xlsx]]
 * 4) COPY AND PASTE this spreadsheet onto your new spreadsheet: Directions on HOW TO:
 * 5) Copy this spreadsheet by RIGHT-CLICKING on the cell above row 1 and select COPY
 * 6) Go to the Excel Assignments I workbook and your new Book Sales blank spreadsheet and RIGHT-CLICK the cell above row 1 and PASTE.
 * 7) 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**
 * 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:
 * the lowest 10%'s annual wage
 * the median annual wage
 * the top 10%'s annual wage