Theme 3: Teaching Economics Using Excel

We are running a virtual symposium on online teaching and learning over a series of Mondays in June, with the final theme in September. 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.

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

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 (video from 5:08):

Wendy Carlin (video from 18:59):

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: (video from 1:06:42)

Tim Burnett (video from 1:15:20):

Eileen Tipoe (video from 1:21:53):

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: