Info. Tech Apps. II

Week 4

November 13-17

  

MONDAY-

  • Bell Ringer: Complete Lesson 7 & 8 Projects
  • Complete Lesson 7 & 8 Projects
Assign: Lesson 7 & 8 Projects

TUESDAY-

  • Bell Ringer: Review Lesson 8 Notes
  • Check Lesson 8 Projects 8-1, 8-2
  • G-Metrix Excel Lessons 1-7 Review
  • Intro to Lesson 9
    • Importing Data 237
      Opening Non-Native Files Directly in Excel 237
      Getting External Data 240
      Appending Data to a Worksheet 241
    • Ensuring Your Data’s Integrity 243
      • Complete Step-by-Steps 237-247
Assign: G-Metrix Review Lessons 1-7, Complete Step-by-Steps 237-247

WEDNESDAY-

  • Bell Ringer: Check work on Lesson 8 Projects
  • Review Lesson 9
    • Importing Data 237
      Opening Non-Native Files Directly in Excel 237
      Getting External Data 240
      Appending Data to a Worksheet 241
    • Ensuring Your Data’s Integrity 243
  • Con't Lesson 9 Notes
    • Sorting Data 248
    • Filtering Data 251
    • Outlining and Subtotaling data 255-260
      • Complete Step-by-Steps 248-260
Assign: Lesson 9 Step-by-Steps 248-260

THURSDAY-

    • Setting Up Data in a Table Format 261
    • Adding and Removing Rows or Columns in a Table 267
    • Saving Work with Macros 270
    • Complete Lesson 9 Step-by-Steps 260-270
Assign: Lesson 9 Projects 9-1, 9-2, 9-3,

FRIDAY-

  • Bell Ringer: Lesson 9 Review -
  • Review Lesson 9 Notes
  • Lesson 9 Projects 9-1, 9-2, 9-3, 9-4

Assign: Lesson 9 Projects 9-4, 9-5, 9-6,