The Online Teacher Resource

Email Newsletter

Lesson Plan : Formula Auditing and Scenarios

Teacher Name:
 Sahil VIj
Grade:
 Grade 9-10
Subject:
 Other

Topic:
 Using Formula Auditing and Scenarios in Excel
Content:
 Create mark sheets, Financial Summary budgets, Using formulas and Scenario manager to track records.
Goals:
 Proper use of formula auditing and Scenario tools in excel to create files with better understanding.
Objectives:
 Exploring Formula Auditing tab, using Trace Precedents, Trace Dependents and show formula tools. Using error checking tool to resolve and fix formula errors,
Materials:
 Microsoft Excel
Introduction:
 Creating a Excel sheet and using formulas to experiment formula auditing on that sheet, Using Scenario manager to track changes in the values.
Development:
 Starting up with adding simple formulas in the mark sheet such as Sum, Average and IF statements, Running error checking tool, Using Scenario Manager.
Practice:
 Creating an excel file and linking two sheets used for Formula Auditing and Scenarios respectively. Explore the error check and evaluate formula utility.
Accommodations:
 Using Excel to explore formula auditing, Research online to clear the concept.
Checking For Understanding:
 Practice use of formulas and Scenarios in excel file, Take online tests.
Closure:
 Students learn the proper use of Formula Auditing and Scenarios.
Evaluation:
 Create an excel file using formula auditing and scenarios and review it with professor to check progress.
Teacher Reflections:
 

Create New Lesson Plan Lesson Plan Center