2018 Workshop: Teaching Economics with Excel
This workshop was held from June 4 - 5, 2018 at Concordia University Irvine in Irvine, California. I would like to deeply thank Dr. George Wright and Melle Lou Del Rosario for their help in supporting and enabling this event. I also thank DePauw University and the Hewlett/Melon funds for financial support.
The original description and schedule are below, after a few comments from participants and photos.
Participants
First Name | Last Name | Institution |
Bill | Herrin | University of the Pacific |
Carolyn | Shiery | Concordia University |
Claudia | Araiza | Southern States University |
Don | Reddick | Kwantlen Polytechnic University |
Darla | Donaldson | California Baptist University |
Drew | Wolf | Concordia University |
Elisa | Queenan | Porterville College |
Eric | McDermott | University of Illinois at Urbana Champaign |
George | Wright | Concordia University |
Jennifer | Trudeau | Sacred Heart University |
Jorge | Vidal | University of Texas Rio Grande Valley |
Kim | Chatani | Concordia University |
Michael | Leonard | Kwantlen Polytechnic University |
Michael | Kinnen | Concordia University |
Michel B. | Kekerovic | Varsity Tutors |
Michelle | Amaral | University of the Pacific |
Mike | Kuehlwein | Pomona College |
Nicole | Waymire | Saddleback College |
Ramses | Armendariz | Monmouth College |
Richard | Ponarul | California State University, Chico |
Russ | Mangum | Concordia University |
Sierra | Moussatche | Saddleback College |
Stephen | Erfle | Dickinson College |
Susan | Russell | Saddleback College |
Susan | Elkinawy | Loyola Marymount University |
Selection of Comments and Feedback Quoted from Evaluations
"Excellent! I see why Bert is so popular with his students."
"I loved the FRED add-in. I feel much more confident with Excel."
"Awesome -- a lot to think about and incorporate into my lesson plans."
"I liked the FRED and demography presentations the most."
"Very well organizd and productive use of my time."
"Favorite was Solver and Comparative Statics -- so excited to use these going forward!"
"Delivery is phenomenal. Enthusiastic, fast-paced and yet repetitive on key topics . . . makes me want to lift the level/expectations for my students. They better watch out!!"
"So thrilled and excited to implement in my classes."
"I am absolutely amazed that we went through so many topics in so little time."
"Step by step handouts are a big help."
Photos
Photos courtesy of George Wright
Description
While the content of the typical undergraduate economics course has remained stable in recent decades, computers have become more powerful, easier to use, and as common as pencil and paper. In spite of these developments, teaching methods in the classroom remain virtually unchanged, with chalk-and-talk the dominant mode of delivery. This two-day professional development workshop will demonstrate how to utilize computer-based, active learning techniques to teach economics in a variety of subfields and at different levels, enabling participants to create new course materials and content.
The workshop is designed to provide both ready-to-go classroom material and tools that can be used to generate your own examples and content. You can test drive a single application and gradually expand your teaching repertoire. This is an ideal, low cost way to improve and re-energize a course you have taught many times or to create an entirely new course.
Individual lectures, lab modules, or entire courses can be reworked and enhanced, including flipping the classroom. Each day concludes with time for participants to explore workbooks and ideas on their own, with consultation if needed.
Target Audience: Economics and Business
Each year, I tweak the topics. Scroll down to see past workshops. This year, I am targeting microeconomics and managerial economics. The first day is devoted to basic tools (add-ins) and the second day focuses on micro and manageral topics. In addition to economists, professors in business schools, especially those who teach finance and quantitative courses, are especially welcome. Participants will gain a fresh look at how to teach and improve their course content, delivery, and effectiveness.
Bio
Dr. Barreto is interested in using computers (especially Microsoft Excel) to improve the teaching and learning of economics. He is the Q. G. Noblitt Professor of Economics and Management at DePauw University and has published papers and books on pedagogy, including (with Frank M. Howland) Introductory Econometrics using Monte Carlo Simulation with Microsoft Excel (Cambridge University Press, 2006), Intermediate Microeconomics with Microsoft Excel (Cambridge University Press, 2009) and Teaching Macroeconomics with Microsoft Excel (Cambridge Univeristy Press, 2016). He has been a Fulbright Scholar, won several teaching awards, and has presented the materials used in this workshop at many colleges and universities around the world.
Dates and Location
June 4 and 5, 2018 in the computer lab at Concordia University Irvine's Grimm Hall in Irvine, California.
If you prefer, guest wifi is available for your laptop (Windows with Excel, of course, or a Mac emulating Windows is required).
We will begin on Monday, June 4, 2018, at 8:30 AM and follow the schedule below.
Schedule
The first day will focus on general-purpose tools that can be applied to any course. We will begin with Excel's built-in numerical optimization add-in, Solver, and then learn how to use the Comparative Statics Wizard add-in. The MCSim add-in is a powerful, free tool that enables easy simulation and is ideal for statistics and econometrics courses. The FRED add-in offers instant access to the St. Louis Fed's FRED data resource directly from Excel. Finally, we will use Excel to create population pyramids for countries, with projections to 2050.
The second day is devoted to topics in Intermediate Microeconomics and Managerial Economics. We will work with pre-prepared Excel workbooks to show how to derive demand and supply curves and see a novel application of a cost minimization problem. The afternoon sessions will showcase how Excel can be used to teach optimal portfolio theory and solve an investment problem with native Excel NPV and IRR functions.
Costs and Funding
This workshop is made possible by generous support from DePauw University and Concordia University. There is a non-refundable $30 registration fee to attend. Participants are responsible for all lodging (see below) and transportation costs.
Questions and Registration
Email hbarreto@depauw.edu if you have questions or would like further information.
Space is limited to the first 24 who register. Participants will be accepted on a first-come-first-served basis and registration will close on May 30.
Register here: Teaching Economics with Excel Workshop Registration