RT Journal Article
SR Electronic
T1 Integrating Math & Computer Skills in the Biology Classroom
JF The American Biology Teacher
FD University of California Press
SP 455
OP 460
DO 10.1525/abt.2013.75.7.3
VO 75
IS 7
A1 ,
YR 2013
UL http://abt.ucpress.edu/content/75/7/455.abstract
AB Students often enter biology programs deficient in the math and computational skills that would enhance their attainment of a deeper understanding of the discipline. To address some of these concerns, I developed a series of spreadsheet simulation exercises that focus on some of the mathematical foundations of scientific inquiry and the benefits of mathematical modeling in understanding some of the fundamental concepts of ecology, including topics such as population growth, selection, competition, predation, and sustainability. In the example presented here, students collect data from a computer-generated study site and then use basic spreadsheet skills to calculate, graphically visualize, and compare sample means (Â± SE) to effectively discover why random and transect sampling are superior to biased sampling, and to explore the effects of sample size on the standard error of the mean. Pre- and post-exercise questionnaires suggest that spreadsheet models such as this one are effective in improving studentsâ€™ attainment of the target principles. Spreadsheet simulations can be used as a low-cost, easily accessible way to leverage technology to supplement lecture or laboratory content while fostering vital math and computer skills.