Text Options for the Visually Impaired Font Size: a- A+ Color: A A A Revert 
Close vision bar
Open vision bar
Lesson Plans

 

Class: IBA 2      Standard: G. ADVANCED MICROSOFT EXCEL            Date: March 25 – 29, 2019

Mon

Tues

Wed

Thurs

Fri

Standard

G 9, 17

G 9, 17

G 8. 22

G 20,

G.7, 35

Learning Objective

The student will be able to:

  • Filter records using AutoFilter
  •  Filter records using search criteria
  • Filter records with multiple criteria
  • Determine when to use And and OR logical conditions

The student will be able to:

  • Filter records using AutoFilter
  •  Filter records using search criteria
  • Filter records with multiple criteria

Determine when to use And and OR logical conditions

The student will be able to:

  • Use table references in a VLOOKUP formula
  • Find table information using VLOOKUP
  • Summarize table data using DSUM
  • Summarize table data using DCOUNT or DCOUNTA

The student will be able to:

  • Use data validation to restrict data entry to specified values
  • Insert table data using data validation
  • Summarize worksheet data using subtotals
  • Use outline symbols
  • Convert a table to a range

The student will be able to:

  • Use data validation to restrict data entry to specified values
  • Insert table data using data validation
  • Summarize worksheet data using subtotals
  • Use outline symbols
  • Convert a table to a range

APK

Review terms and concepts from previous lessons.

Review terms and concepts from previous lessons.

Review terms and concepts from previous lessons.

Review terms and concepts from previous lessons.

Review terms and concepts from previous lessons.

 I Do

Mini Lesson

Keyboarding

Keyboarding

Keyboarding

Keyboarding

Keyboarding

CFU

Questions and examples

Questions and examples

Questions and examples

Questions and examples

Questions and examples

We Do

Presentation: Filter a Table. Create a Custom Filter

Presentation: Filter a Table. Create a Custom Filter

Presentation: Look Up Values in a Table.  Summarize Table Data

Presentation: Validate Table Data.  Create Subtotals

Unit Review

CFU

Demonstration

Demonstration

Demonstration

Questions and Answer

Questions and Answer

You Do

Advance Microsoft Excel Lesson H

Advance Microsoft Excel Lesson H

Advance Microsoft Excel Concept Review

Advance Microsoft Excel Concept Review

IC # 4

Accom.

More time given on assignments and breaks allowed when necessary.

More time given on assignments and breaks allowed when necessary.

More time given on assignments and breaks allowed when necessary.

More time given on assignments and breaks allowed when necessary.

More time given on assignments and breaks allowed when necessary.