Lesson Plan : Pivot Tables
Teacher Name: | Sam Scott |
Grade: | College/University |
Subject: | Other |
Topic: | Pivot Tables |
Content: | How to create Pivot Tables. |
Goals: | Learning how to create Pivot Tables, and also the importance of using these tables in daily business communication. |
Objectives: | Examining the use of each function of a pivot table. |
Materials: | - “Sample Prepared file for Lecture demo - employee database.xls” spreadsheet found in the COMP-10064 course content - Microsoft Excel 2013 |
Introduction: | - Introduce myself. - Introduce the topic "Pivot Tables" |
Development: | Remember Pivot Tables - allows you to organize raw data into specific, readable reports Fields - we can manipulate the pivot table by selecting specific fields and moving them to different “areas”. The fields in this specific example are: Name, Department, Wage, and Absences Areas Filters - used to filter the report based on the “field” that is placed here Columns - used to display the unique field values across the top of the report Rows - Used to display the unique field values sequentially down the first rows of the report Values - If the data in the field we choose is numeric, Excel will automatically calculate the total sum of the data. Remember that we can also calculate the average, maximum, or minimum - if the date in the field we choose is alphanumeric, Excel will display the total count of that field Pivot Tables - allows you to organize raw data into specific, readable reports Fields - we can manipulate the pivot table by selecting specific fields and moving them to different “areas”. The fields in this specific example are: Name, Department, Wage, and Absences Areas Filters - used to filter the report based on the “field” that is placed here Columns - used to display the unique field values across the top of the report Rows - Used to display the unique field values sequentially down the first rows of the report Values - If the data in the field we choose is numeric, Excel will automatically calculate the total sum of the data. Remember that we can also calculate the average, maximum, or minimum - if the date in the field we choose is alphanumeric, Excel will display the total count of that field |
Practice: | Demonstrate how to create a pivot table by moving specific "fields" to different "areas" |
Accommodations: | |
Checking For Understanding: | |
Closure: | |
Evaluation: | |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |