Theme 3: Teaching Economics Using Excel

We are running a virtual symposium on online teaching and learning over a series of Mondays in June. This is the third of four themes.

This session explored the significant and often unused potential of Excel in providing asynchronous resources for online economics teaching. The 22 June live session was in two parts:

  • the use of Excel as a simulation tool in teaching economic theory;
  • the benefits of using Excel to teach data-based subjects in comparison to more specialised tools such as Stata or R.

Part 1: Using Simulations in Excel in Teaching Economics

Presenters: Prof Wendy Carlin (UCL, The CORE Team); Dr Annika Johnson (Bristol), Prof Humberto Barreto (DePauw University);
Chairs: Prof Alvin Birdi (Bristol, EN), Dr Christian Spielman (Bristol, EN), Dr Stefania Paredes Fuentes (Warwick, EN)

Resources for this part:

Humberto Barreto:
Introductory video

Annika Johnson:

Wendy Carlin:

Part 2: Using Excel for Teaching Data-Based Subjects

Presenters: Dr Lory Barile (Warwick), Dr Tim Burnett (Warwick/Aston Business School), Dr Eileen Tipoe (Oxford)
Chairs: Prof Alvin Birdi (Bristol, EN), Dr Christian Spielman (Bristol, EN), Dr Stefania Paredes Fuentes (Warwick, EN)

Resources for this part:

Lory Barile:

Tim Burnett:

Eileen Tipoe:

For this session, we used a range of technologies/tools that you can be used in your own teaching.

Other material to read

The Economics Network website provides a wide range of resources you may find useful for teaching. We highlight a few here: