NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1044314
Record Type: Journal
Publication Date: 2013-Sep
Pages: 6
Abstractor: As Provided
Reference Count: 7
ISSN: ISSN-0002-7685
Integrating Math & Computer Skills in the Biology Classroom: An Example Using Spreadsheet Simulations to Teach Fundamental Sampling Concepts
Ray, Darrell L.
American Biology Teacher, v75 n7 p455-460 Sep 2013
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.
University of California Press. 2000 Center Street Suite 303, Berkeley, CA 94704. Tel: 510-643-7154; Fax: 510-642-9917; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Research
Education Level: Secondary Education; Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A