The Online Teacher Resource

Email Newsletter

Lesson Plan : Creating Pivot Table

Teacher Name:
 Sharon Scollard
Grade:
 College/University
Subject:
 Other

Topic:
 Creating simple pivot table from MS Excel datasheet
Content:
 Data summarization, Data visualization, performing calculation on data.
Goals:
 To summarize the data information in cross tabular format.
Objectives:
 To open MS Excel datasheet and create pivot table for desired fields.
Materials:
 Microsoft Excel 2007 or later version.
Introduction:
 Summarization of numerical data fields found on datasheet with pivot table utility.
Development:
 Arranges fields on rows and columns and creates the pivot table data visualization on cross tabular format.
Practice:
 Categorizing fields
Accommodations:
 
Checking For Understanding:
 
Closure:
 Pivot table utility provides better data summarization with data processing ability enables to create data models based on their numerical statistics.
Evaluation:
 
Teacher Reflections:
 

Create New Lesson Plan Lesson Plan Center