Looking for online teaching materials? Materials to help your students understand Covid-19? I've tried to address these needs by writing a Covid-19 educational module. The core of the module is an implementation of a Covid-19 model I created in an Excel spreadsheet. Minimal math background is required because of the way it is structured. The top sheet of the workbook is the MUI (model-user interface). Parameter cells are highlighted in yellow and output cells are highlighted in blue. The only other thing on the top sheet is a pair of graphs. Like a function in a real computer program, the calculation sheets receive inputs copied from the top sheet and then return results to cells in the top sheet. The module comes with a large set of pre-designed experiments, each with questions students are to address using the results of the experiment.
You can find the module at http://www.math.unl.edu and I've posted a YouTube video at https://www.youtube.com/watch?v=ovImgF5HB7E&t=3s.
The model itself is a modified version of the SEIR DE model, with the infective class divided into asymptomatic, symptomatic, and hospitalized. The input parameters include a social distancing parameter and a testing rate parameter, along with parameters needed to represent the disease.
Glenn Ledder @ on
Looking for online teaching materials? Materials to help your students understand Covid-19? I've tried to address these needs by writing a Covid-19 educational module. The core of the module is an implementation of a Covid-19 model I created in an Excel spreadsheet. Minimal math background is required because of the way it is structured. The top sheet of the workbook is the MUI (model-user interface). Parameter cells are highlighted in yellow and output cells are highlighted in blue. The only other thing on the top sheet is a pair of graphs. Like a function in a real computer program, the calculation sheets receive inputs copied from the top sheet and then return results to cells in the top sheet. The module comes with a large set of pre-designed experiments, each with questions students are to address using the results of the experiment.
You can find the module at http://www.math.unl.edu and I've posted a YouTube video at https://www.youtube.com/watch?v=ovImgF5HB7E&t=3s.
The model itself is a modified version of the SEIR DE model, with the infective class divided into asymptomatic, symptomatic, and hospitalized. The input parameters include a social distancing parameter and a testing rate parameter, along with parameters needed to represent the disease.
Cancel Report abuse
Glenn Ledder @ on
Correction. The web page is https://www.math.unl.edu/covid-module.
Reply Report abuse