MONDAY-
- Bell Ringer: Review Lesson 11 Notes
- Lesson 11 Projects
- Intro to Charts
- Types of Charts
- Building Charts
- Selecting Data to Include in a Chart 365
Moving a Chart 367
Choosing the Right Chart for Your Data 369
Using Recommended Charts 371
Creating a Bar Chart 374
- Formatting a Chart with a Quick Style or Layout 376
- Formatting the Parts of a Chart Manually 379
- Modifying a Chart 386
Assign: Gather Data for Top 10 Chart
TUESDAY
- Bell Ringer: Review Protecting/Sharing a Workbook/Worksheet
- Review Creating Column Charts
- Discuss "Design" & "Format" Chart Tabs
- Using New Quick Analysis Tools 395
Adding a Chart or Sparklines 395
Working with Totals 397
Applying Conditional Formatting 398
Creating PivotTables and PivotCharts 399
Creating a Basic PivotTable 399
Adding a PivotChart 402
- Lesson 12 Projects 12-1, 12-2, 12-3, 12-4,
Assignment: Con't Lesson 12 Projects 12-1 to 12-3
- Bell Ringer: Review Types of Charts (Exit-Ticket)-Describe the 3 types of charts and what type of data each is used for.
- Fix "BAD" Chart File
- Creating PivotTables and PivotCharts 399
- Bell Ringer: Con't Work on Lesson 12 Projects 12-4, 12-5, 12-6
THURSDAY