The Online Teacher Resource

Email Newsletter

Lesson Plan : Formula Auditing and Scenarios

Teacher Name:
 David King
Grade:
 College/University
Subject:
 Other

Topic:
 Formula Auditing and Scenarios
Content:
 Formula Auditing, Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error Checking, Evaluate Formula Watch Window, Scenario Manager
Goals:
 To become sufficient in Formula Auditing and Scenarios in Microsoft Excel.
Objectives:
 To become sufficient in reproducing the capabilities using Formula Auditing and scenarios as described by this lecture. To become capable of identifying problem excel-cells. To become skilled in formulating a correct solution using the following functions.
Materials:
 
Introduction:
 What are Formula Auditing and Scenarios? An implementation in Microsoft Excel to help with existing sheets. Makes it easier to identify problems using graphics. Checks errors. Gives the opportunity to safely ask “What if…” and change values, keeping our existing cell-sheet intact.
Development:
 Demonstrate using accompanying Excel sheet.
Practice:
 Guide through Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error Checking, Evaluate Formula Watch Window, Scenario Manager functions.
Accommodations:
 For each topic, show Powerpoint slide, followed by its implementation in Excel.
Checking For Understanding:
 
Closure:
 Students should now know how to… Show Formulas Trace Precedents Trace Dependents Remove the arrows from either or both traces Error-Check Evaluate a Formula Use the Watch Window Use the Scenario Manager
Evaluation:
 
Teacher Reflections:
 

Create New Lesson Plan Lesson Plan Center