Lesson Topic:

Pivot Tables (utilizing Microsoft Excel)

Lesson Description:

Students will learn data analysis through filtering and sorting information in a Microsoft Excel database. 

Learning Goals/Outcomes:

Students will analyze spreadsheet data using pivot tables as a Microsoft Excel spreadsheet tool. 

Nebraska Standards:

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

Teacher Planning:

Equipment/Materials/Software Needed:

Computer with Microsoft Excel (or similar Excel data).

Time Required for Lesson:

2 days - one day for data research, one day for spreadsheet analysis. 

Diagram/Setup:NA

Technology Use:

Software:

Microsoft Excel (or similar)

Hardware:

Standard computer or laptop with Internet access. 

Instructional Plan:

Anticipatory Set/Pre-Activity:

Introduce needs for pivot table data. 

Benefits/Explanation/Real-World Connection:

Utilize market research data to assist in pivot table sorting. 

Activities (i.e. instructions, warm-up, lesson, cool-down):

Closure:

Assessment :

(Formative/Summative)

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. 

Supplemental Information:

Modifications: NA

Safety Precautions: NA

Comments (adaptations for various grades/ages, teaching styles, etc.): NA

Resources:

https://tlr.nielsen.com/tlr/public/market.do?method=loadAllMarket

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.