LIS - studying

Use Excel to Model COVID-19

Clock Icon

35 mins read

  • Tags:
  • #Free tool

  • #STEM

  • #Quantitative method

  • #Real-world problem

  • #Video

  • #Article

  • #COVID 19

Create your own spreadsheet model of the COVID-19 virus spread

๐Ÿ’ก Video 1: spreadsheet disease spread:ย Watch the video below which introduces the spreadsheet model. This type of model is known as a cellular automaton (or CA), which can be used to simulate many complex systems in biology, chemistry, and of course epidemiology (and more). See this link for more on spreadsheet cellular automata.

๐Ÿ’ก Video 2: probabilistic model: Identify areas of improvement – how could you add more realism? This will inevitably involve interdisciplinary thinking. Suggested considerations: think about what a ‘real’ social group looks like, how people really behave (before and during the virus spread), and how the virus itself behaves once a person is infected. (Use relevant real data if required.) The video below๐Ÿ‘‡ shows how to incorporate probability into the model.


๐Ÿ’ก Video 3: reproduction number R: The initial value of R is commonly called R0 (“R nought”). Read this article from Plus Magazine; it is highly accessible and also includes a useful discussion about ‘herd immunity’.

“Simple Cellular Automata on a Spreadsheet”, Chris Hand, 2005.


Notify of
Inline Feedbacks
View all comments