How to translate text using browser tools
1 October 2017 Using Spreadsheets to Simulate an Evolving Population
Ryan E. Langendorf, Paul K. Strode
Author Affiliations +
Abstract

Biology teachers inevitably struggle with how best to teach evolution. Students arrive in their classrooms with preconceptions, many of which are overwhelmingly skeptical, and science teachers are increasingly being pressured to adhere to an arbitrary degree of objectivity that makes discussing scientific worldviews challenging. These challenges have resulted in evolution being taught largely as a series of explanations for questions arising from observations of the living world. In so doing, students may not have a chance to grapple with the worldview that produced those explanations, or develop a more mechanistic intuition for inheritance and change in the world they see around themselves. Here we put forth all the tools necessary for a class to build a simulation of an evolving population experiencing natural selection from scratch in a Google Docs spreadsheet. Not only will this activity help students experiment with the natural world more mechanistically, but it will also allow them to learn as actual evolutionary biologists do.

© 2017 National Association of Biology Teachers. All rights reserved. Please direct all requests for permission to photocopy or reproduce article content through the University of California Press's Reprints and Permissions web page, www.ucpress.edu/journals.php?p=reprints.
Ryan E. Langendorf and Paul K. Strode "Using Spreadsheets to Simulate an Evolving Population," The American Biology Teacher 79(8), 635-643, (1 October 2017). https://doi.org/10.1525/abt.2017.79.8.635
Published: 1 October 2017
JOURNAL ARTICLE
9 PAGES

This article is only available to subscribers.
It is not available for individual sale.
+ SAVE TO MY LIBRARY

KEYWORDS
allele frequency
evolution
metacognition
NATURAL SELECTION
nature of science
probability
simulation
RIGHTS & PERMISSIONS
Get copyright permission
Back to Top