ERIC Number: EJ1044314
Record Type: Journal
Publication Date: 2013-Sep
Abstractor: As Provided
Reference Count: 7
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.
Descriptors: Science Instruction, Mathematics Skills, Educational Technology, Spreadsheets, Computer Simulation, Scientific Concepts, Biology, Teaching Methods, Inquiry, Mathematical Models, Ecology, Computation, Sampling, Sample Size, Pretests Posttests, Questionnaires, Concept Formation, Secondary School Science, College Science, Data Analysis
University of California Press. 2000 Center Street Suite 303, Berkeley, CA 94704. Tel: 510-643-7154; Fax: 510-642-9917; e-mail: firstname.lastname@example.org; Web site: http://www.ucpressjournals.com/journal.php?j=abt
Publication Type: Journal Articles; Reports - Research
Education Level: Secondary Education; Higher Education; Postsecondary Education
Authoring Institution: N/A