Lesson Plan : Using pivot tables in Excel 2010

Teacher Name:
 Anderson D'Souza
Grade:
 College/University
Subject:
 Interdisciplinary

Topic:
 Using pivot tables in Excel 2010
Content:
 Introduction to Pivot Tables concept Create a pivot table Implement slicers Create pivot charts use getpivotdata formula
Goals:
 Guide the user to first create a pivot table using a sample data set. Users will then be directed to format the pivot table and finally manipulate the pivot table.
Objectives:
 Students will follow along with the demonstration and be able to perform tasks independently within the allotted 45 minutes.
Materials:
 Computer with Excel 2010 installed.
Introduction:
 
Development:
 
Practice:
 
Accommodations:
 
Checking For Understanding:
 
Closure:
 
Evaluation:
 Students will be tasked with solving problems sets individually.
Teacher Reflections:
 Address any outstanding questions or provide further insight.

Create New Lesson Plan Lesson Plan Center