AP Microeconomics Teacher and Student Resources

beginning of content:
AP Digital Edge is a pilot pairing Advanced Placement Program® courses with software skills taught in career and professional education.

A collection of eight lesson plans, titled AP Microeconomics: Activities to Build Understanding Through Excel Applications (.pdf/10.1MB), is available to teachers participating in AP Digital Edge. This book and all its accompanying resources can be downloaded from this page.

Jump down to the separate lessons.

To see the Excel skills that are tested on the Microsoft® Office Specialist: Excel 2013 certification exam mapped against each AP Digital Edge lesson in which they're used, see the AP Microeconomics and Excel Curriculum Mapping chart below.

A table shows the 8 lessons in the AP Microeconomics Digital Edge resource mapped against 8 Excel skills measured on the MOS Excel 2013 certification exam. The Excel skills are Managing the Worksheet Environment, Formatting Cells and Worksheets, Creating Cell Data, Managing Worksheets and Workbooks, Applying Formulas and Functions, Presenting Data Visually, Sharing Worksheet Data with Other Users, and Analyzing and Organizing Data.

Click on the links below to see each lesson's description and to download the lesson plan, student handout, student Excel workbook, and teacher's Excel workbook key.

By analyzing and graphing data, students will evaluate the marketplace and the relationship of the consumer with price and quantity demanded. They will learn how to use Microsoft Excel to sum a series, multiply relevant data, and create a demand curve.

Lesson 1 Resources
Teacher Student

Download Lesson 1 teacher lesson plan (.pdf/923KB)

Download Lesson 1 student worksheet (.pdf/576KB)

Download Lesson 1 teacher Excel grading key (.xls/27KB)

Download Lesson 1 student Excel workbook (.xls/17KB)

Using a series of Microsoft Excel–based activities, students will explore how a per-unit tax affects the supply curve, calculate tax revenue, and determine if the tax burden falls mostly on buyers or sellers based on the elasticity of the demand curve.

Lesson 2 Resources
Teacher Student

Download Lesson 2 teacher lesson plan (.pdf/1.8MB)

Download Lesson 2 student worksheet (.pdf/609KB)

Download Lesson 2 teacher Excel grading key (.xls/30KB)

Download Lesson 2 student Excel workbook (.xls/18KB)

Using the tables and background information provided for a fictional company called Palm Beach Grocery, students will use a series of Microsoft Excel–based activities to understand how the tastes and preferences of consumers impact the choices they make and, ultimately, the demand curve.

Lesson 3 Resources
Teacher Student

Download Lesson 3 teacher lesson plan (.pdf/838KB)

Download Lesson 3 student worksheet (.pdf/394KB)

Download Lesson 3 teacher Excel grading key (.xls/23KB)

Download Lesson 3 student Excel workbook (.xls/16KB)

Using tables and background information provided for a fictional company called New York Tees, students will participate in a series of Microsoft Excel–based activities to understand the cost-benefit analysis an owner (producer) goes through when making shutdown decisions about his or her own business.

Lesson 4 Resources
Teacher Student

Download Lesson 4 teacher lesson plan (.pdf/1.1MB)

Download Lesson 4 student worksheet (.pdf/900KB)

Download Lesson 4 teacher Excel grading key (.xls/45KB)

Download Lesson 4 student Excel workbook (.xls/16KB)

Using data and charts, students will explore the profit-maximizing output for a single-price monopolist and a perfectly price-discriminating monopolist. They will use Microsoft Excel to fill in the demand and marginal revenue data and create a chart to analyze profit-maximizing decisions.

Lesson 5 Resources
Teacher Student

Download Lesson 5 teacher lesson plan (.pdf/992KB)

Download Lesson 5 student worksheet (.pdf/350KB)

Download Lesson 5 teacher Excel grading key (.xls/22KB)

Download Lesson 5 student Excel workbook (.xls/19KB)

This lesson will reinforce students' understanding of the hiring decisions made in perfectly competitive labor markets. The activities focus on factor markets and the role they play in the economy. Students will use Microsoft Excel to explore how factor markets can be used to allocate productive resources to firms and ensure those resources are used efficiently.

Lesson 6 Resources
Teacher Student

Download Lesson 6 teacher lesson plan (.pdf/975KB)

Download Lesson 6 student worksheet (.pdf/383KB)

Download Lesson 6 teacher Excel grading key (.xls/30KB)

Download Lesson 6 student Excel workbook (.xls/14KB)

By analyzing and presenting data, students will investigate a monopsonistic marketplace for labor. They will use Excel to examine data, create formulas to calculate the total and marginal cost of labor, create charts of the data, and apply conditional formatting.

Lesson 7 Resources
Teacher Student

Download Lesson 7 teacher lesson plan (.pdf/779KB)

Download Lesson 7 student worksheet (.pdf/285KB)

Download Lesson 7 teacher Excel grading key (.xls/25KB)

Download Lesson 7 student Excel workbook (.xls/17KB)

Students will learn how the government intervenes in the free marketplace to correct for externalities in an attempt to provide a more efficient outcome for society. Students will practice using Microsoft Excel to determine the free market equilibrium price and quantity for a good.

Lesson 8 Resources
Teacher Student

Download Lesson 8 teacher lesson plan (.pdf/995KB)

Download Lesson 8 student worksheet (.pdf/361KB)

Download Lesson 8 teacher Excel grading key (.xls/31KB)

Download Lesson 8 student Excel workbook (.xls/16KB)