Info. Tech Apps. II

Week 7 - December 4-8

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

WEDNESDAY

  • 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

  • Bell Ringer: Lesson 12 Project Check
  • Top 10 Charts
  • Creating PivotTables and PivotCharts 399
    • Complete Step-by-Steps Pages 399-404
  • Lesson 13 Preview "Adding Pictures & Shapes to a Worksheet"

FRIDAY

  • Bell Ringer: Top 10 Chart - Share
  • Lesson 13 Notes
    • Adding Shapes, Lines, Text Boxes, and WordArt 416
    • Deleting, Copying, And Moving graphics 423
    • Formatting Graphics 426
    • Adding Graphic Enhancements Using Picture Tools 430
    13 Projects 13-2, 13-3, 13-5,
  • Kahoot Review Lessons 10-13

MONDAY

  • Bell Ringer: Project Check Lesson 13
  • CB #3 Exam
  • G-Metrix - Core Training 1

Assignment:

TUESDAY

  • Bell Ringer: Go over Circling Back 3 Unit Exam
  • G-Metrix - Complete Core Training 1
  • G-Metrix - Complete Core Training 2

Assignment: G-Metrix

WEDNESDAY

  • Bell Ringer: Con't Core Training 2
  • G-Metrix Review Excel Core Training #3

Assignment:Excel Core Training #3