Click and Think, Not Chalk and Talk: An Interactive Spreadsheet Approach for Teaching Economics

17 Pages Posted: 28 Sep 2005

See all articles by Jeremy T. Schwartz

Jeremy T. Schwartz

Youngstown State University - Department of Accounting and Finance

Ronald F. McPherson

Longwood College

Raymond T. Brastow

Longwood College

Date Written: August 12, 2005

Abstract

We present spreadsheets as a tool for teaching economics. In particular, we focus on how a price searching firm chooses its profit maximizing quantity. We then extend the example to competitors in a two-firm market. Students can alter the demand and cost structure to see the impact on market clearing. A classroom experience using the spreadsheets is described. An easy-to-use template simplifies creation of additional spreadsheets customized to professor's needs. Alternately professor's can modify the existing spreadsheets. A website allows readers to download all of the spreadsheets discussed.

JEL Classification: A22

Suggested Citation

Schwartz, Jeremy T. and McPherson, Ronald F. and Brastow, Raymond T., Click and Think, Not Chalk and Talk: An Interactive Spreadsheet Approach for Teaching Economics (August 12, 2005). Available at SSRN: https://ssrn.com/abstract=805526 or http://dx.doi.org/10.2139/ssrn.805526

Jeremy T. Schwartz (Contact Author)

Youngstown State University - Department of Accounting and Finance ( email )

United States

Ronald F. McPherson

Longwood College ( email )

Farmville, VA
United States
434-395-2374 (Phone)
434-395-2203 (Fax)

Raymond T. Brastow

Longwood College ( email )

School of Business and Economics
Farmville, VA
United States
804-395-2370 (Phone)
804-395-2203 (Fax)

Here is the Coronavirus
related research on SSRN

Paper statistics

Downloads
150
Abstract Views
1,418
rank
213,557
PlumX Metrics