Using spreadsheets to teach aspects of biology involving mathematical models.

SIMULATION methods & models; POPULATION genetics; HEREDITY; HEAT equation; COMPREHENSION; LIZARDS

Some aspects of biology, for example the Hardy-Weinberg simulation of population genetics or modelling heat flow in lizards, have an undeniable mathematical basis. Students can find the level of mathematical skill required to deal with such concepts to be an insurmountable hurdle to understanding. If not used effectively, spreadsheet models designed to help to overcome such mathematical difficulties present a further hurdle in terms of IT skills. This paper describes examples of how spreadsheet simulations can be designed to reduce the problem of the IT interface obscuring real subject teaching. Two sets of questions designed to help students to meet learning outcomes associated with the Hardy-Weinberg model and with thermoregulation in lizards are presented together with suggested answers. This approach has been successfully used on an introductory genetics course and a control systems course within a Biosciences degree at Canterbury Christ Church University College. [ABSTRACT FROM AUTHOR]

Copyright of Journal of Biological Education (Society of Biology) is the property of Society of Biology and its content may not be copied or emailed to multiple sites or posted to a listserv without the copyright holder's express written permission. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)