Integrating Math & Computer Skills in the Biology Classroom: An Example Using Spreadsheet Simulations to Teach Fundamental Sampling Concepts

Autor/in	Ray, Darrell L.
Titel	Integrating Math & Computer Skills in the Biology Classroom: An Example Using Spreadsheet Simulations to Teach Fundamental Sampling Concepts
Quelle	In: American Biology Teacher, 75 (2013) 7, S.455-460 (6 Seiten)Infoseite zur Zeitschrift PDF als Volltext Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	0002-7685
DOI	10.1525/abt.2013.75.7.3
Schlagwörter	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 + Suchen Sie Ihr Suchwort? Teaching of science; Science education; Natural sciences Lessons; Naturwissenschaftlicher Unterricht; Mathmatics achievement; Mathematics ability; Mathematische Kompetenz; Unterrichtsmedien; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Computergrafik; Computersimulation; Biologie; Teaching method; Lehrmethode; Unterrichtsmethode; Mathematical model; Mathematisches Modell; Ökologie; Fragebogen; Concept learning; Begriffsbildung; Auswertung
Abstract	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. (As Provided).
Anmerkungen	University of California Press. 2000 Center Street Suite 303, Berkeley, CA 94704. Tel: 510-643-7154; Fax: 510-642-9917; e-mail: customerservice@ucpressjournals.com; Web site: http://www.ucpressjournals.com/journal.php?j=abt
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2017/4/10