Computers 2

Week 6 - April 16-20

MONDAY-

  • Bell Ringer: Lesson 5 Review - Open "Lesson 5 Review"
  • 5.5 Logical Functions "IF"
  • 5.6 Date and Time / Text Functions
  • Complete Step-by-Steps (5-5 to 5-6)
  • Complete Lesson 5 Questions, Project 5-1
Assign: Lesson 5 Questions + Project 5-1, Project 5-2

TUESDAY-

  • Bell Ringer: Open "Formula Practice" Review Lessons 4 & 5
  • Review: Logical & Financial Functions "IF" "AND" "OR" / "PMT" "PV" "FV"
  • Project 5-2
  • Project 5-3
  • Project 5-4
  • Grade Lesson 5 Questions & Project 5-1
Assign: Projects 5-2, 5-3, 5-4,

WEDNESDAY-

  • Go over Project 5-2
  • Lesson 5 Training
  • Create your own spreadsheet problem using Functions from Lesson 5 (10 functions - 2 from each group)
  • Project 5-5
  • Project 5-6

Assign: Project 5-6, TEST THURSDAY!

THURSDAY
  • Go over Projects 5-2 to 5-6
  • Flash Card Machine Term Review Lesson 5
  • Lessons 5 SAM & EXAM VIEW TEST

FRIDAY

  • Bell Ringer: Open Step-by-Step 6.1 to 6.4 (review)
  • Go over Lessons 5 Objective Test
  • Lesson 6 Notes: "Enhancing a Worksheet"
    • 6.1 Sorting Data
    • 6.2 Filtering Data
    • 6.3 Applying Conditional Formatting
    • 6.4 Hiding Columns & Rows
      • Complete Step-by-Steps 6.1 to 6.4
    • 6.5 to 6.7 Adding Shapes/Clip Art & Gaphics/Modifying
    • 6.8 Screen Captures
      • Complete Step-by-Steps 6.5 to 6.8