Spreadsheets: Advanced Functions, Graphs and Charts

1-Identify Common Charts Used in Business

Power Point:  1.04-Six Common Chart Used in Business

Guided Practice:

• Scatter Chart-Doctor and Principal Office Pulse Rate
• Pie Chart and Exploded-Student Eye Color
• Line Chart-5th Grade Visitor to HGMS
• Column Chart and Stacked Bar-Snacks By Grade Level

 
Independent Practice:  Chart Practice Workbook

• Pie Chart and Exploded Pie-FBLA Grade Levels
• Line Chart-FBLA Membership
• Column Chart and Stacked Bar-FBLA OFFICERS VOTES

2-Components of a Graph and Charts/Used in Business

Power Point:  1.02 and 1.03 Components of SS-Chart & Graphs Used in Business

Guided Practice:

• Label Chart Components
• Chart and Graph Vocabulary Crossword Puzzle
• Matching Handout

​

Independent Practice:

3- Spreadsheets: Understand Advanced Functions

Power Point:  1.01 Understand Advanced Spreadsheet Functions

Quia: C: SS Advanced Functions and Purposes

Videos:  Functions

Class Activities:

• Guided Practice:  
•  Power Point Assignment
•  Independent Practice
•  Assessment