beginning of content:

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.

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.

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

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

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

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

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

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

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.

Teacher Student