Pivot Tables (utilizing Microsoft Excel)
Students will learn data analysis through filtering and sorting information in a Microsoft Excel database.
Students will analyze spreadsheet data using pivot tables as a Microsoft Excel spreadsheet tool.
CIS HS 4a 4.a
CIS HS 4a 4.c
CIS HS 4a.7.c
BMM HS 4.9.b
BMM HS 4.9.c
BMM HS 4.15.a
Computer with Microsoft Excel (or similar Excel data).
Time Required for Lesson:
2 days - one day for data research, one day for spreadsheet analysis.
Microsoft Excel (or similar)
Standard computer or laptop with Internet access.
Introduce needs for pivot table data.
Utilize market research data to assist in pivot table sorting.
Activities (i.e. instructions, warm-up, lesson, cool-down):
Formative: Review student research information near the end of first day.
Summative: Summarize sorted market research by having students verbally or in writing, explain their sorted data.
Safety Precautions: NA
Comments (adaptations for various grades/ages, teaching styles, etc.): NA
Select radio market data from 3-5 markets (cities).
Have students export the data into an Excel spreadsheet, labeling the content by market/city.
Create pivot tables that summarize data from specific radio markets.
Ask students questions and have them synthesize what companies could best advertise their products om a specific radio station, based on marketshare. Students could also explain why one market would be more appropriate for certain products than others and identify potential advertisers, based on local radio station format listenership.