4.00 Understand spreadsheets, charts, and graphs used in business.

4.01 Understand spreadsheets used in business.

4.02 Understand charts and graphs used in business.

**Please see your instructor for the user name and password to have access to all assignments and reviews.

Unit Outline & Vocabulary **

4.01 Outline Spreadsheets

I. Spreadsheets and Components of Spreadsheets (PDF File, 42 KB)

II. Formatting a Spreadsheet (PDF File, 40 KB)

III. Spreadsheet Operations and Functions (34 KB)

4.02 Outline Charts and Graphs (PDF File, 83 KB)

Class Notes & Essential Questions **

4.01 Spreadsheets

Essential Questions:

What is a spreadsheet and what is it used for?

• Slide Show 4.01(I) Anatomy of A Spreadsheet
  • 4.01 Anatomy of a Spreadsheet Graphic Organizer (PDF File, 14 KB)

What formatting options are used in spreadsheets and why?

What operations, formulas, and functions are commonly used in spreadsheets? Why?

What results are produced by the operations, formulas, and functions?

Formula and Basic Functions Notes (PDF File, 69 KB)

Overview of Advanced Functions (PDF File, 9 KB)

4.02 Charts and Graphs

Essential Questions:

What is the difference between a graph and a chart?

What is the purpose of a chart?

• Slideshow 4.02 Chart Components
  • 4.02 Chart Component Notes (PDF File, 30 KB)

Which charts are used commonly in business and why?

How is the type of chart determined?

• Slideshow 4.02 Types of Charts
  • 4.02 Types of Charts graphic organizer (PDF File, 10KB)

Activities **

4.01 Spreadsheets

Spreadsheet Components and Formatting Spreadsheets

• Fun with Basic Formulas and Functions (PDF File, 40 KB)
• Guided Practice: Spreadsheet Formatting (PDF File, 15 KB)
• Independent Practice: Spreadsheet Formatting (PDF File, 15 KB)
• Guided Practice Use Basic Formulas and Functions (PDF File, 55 KB)
• Guided Practice: More Formatting (PDF File, 17 KB)
• Independent Practice Use Basic Functions (PDF File, 37 KB)
• Spreadsheet Rubric (PDF File, 10 KB)

Spreadsheet Operations and Advanced Functions

• Guided Practice: Spreadsheet Operations (PDF File, 11.5 KB)
• Independent Practice: Spreadsheet Operations (PDF File, 13 KB)
• Guided Practice: Linking and Embedding (PDF File, 13 KB)
• Independent Practice: Linking and Embedding (PDF File, 7 KB)
• Practice with IF Statements (PDF File, 17 KB)
• Guided Practice: Use IF Statements (PDF File, 38 KB)
• Independent Practice: Use IF Statements (PDF File, 41 kB)
• Guided Practice: The Date Function (PDF File, 21 KB)
• Independent Practice: The Date Function (PDF File, 31 KB)
• Guided Practice: Understanding the LookUp Function (PDF File, 11 KB)
• Independent Practice: Understanding the Lookup Function (PDF File, 9 KB)
• Guided Practice: Create a List (PDF File, 43 KB)
• Independent Practice: Create a List (PDF File, 11 KB)
• Guided Practice: Use the Count Function (PDF File, 9 KB)
• Independent Practice: Use the Count Function (PDF File, 12 KB)
• 4.01 Objective Summary (PDF File, 11.2 KB) Or 4.01 Objective Summary
  

4.02 Charts and Graphs

• Name That Chart (PDF File, 25.4 KB)
• Guided Practice: Creating Charts (PDF File, 10KB)
• Independent Practice: Creating Charts (PDF File, 31 KB)
• Charts and Graphs Crossword Puzzle (PDF File, 27 KB)

Office 2007 Introductory Concepts and Techniques Microsoft Excel Project 1 "Creating a Worksheet and Embedded Chart" EX 2- EX 69.

Resources

Tutorials

Microsoft Training Excel Training
http://office.microsoft.com/en-us/training/CR100479681033.aspx

• Audio course: So that's how! Great Excel features
• Up to speed with Excel 2007
• Get to know Excel 2007: Create your first workbook
• Get to know Excel 2007: Enter formulas
• Charts I: How to create a chart in Excel 2007
• PivotTable I: Get started with PivotTable reports in Excel 2007

Quizzes

• Excel Quizzes from Microsoft

More Resources

• Excel Resources

Computer Applications I Glossary

• Computer Applications I Glossary

Learn it Online - Office2007

• Excel Chapters 1 - 3

Reveiw **