Physical Sciences and Mathematics Commons^™

Using Spreadsheets In Geoscience Education: Survey And Annotated Bibliography Of Articles In The Journal Of Geoscience Education Through 2003, Beth Fratesi, H. L. Vacher

School of Geosciences Faculty and Staff Publications

Thirty-eight papers published in the Journal of Geoscience Education ( JGE) from 1989 through 2003 explicitly use or recommend the use of spreadsheets as part of classroom or field exercises, projects, or entire courses. Many of the papers include the spreadsheets, and some include the equations. The papers demonstrate how spreadsheets allow students to explore a subject through problem-oriented, interactive, and quantitative exercises. We provide an annotated bibliography and classify the 38 JGE papers by spreadsheet use, mathematics skill area, and geologic subdiscipline. Our discussion of five selected articles — abundance of elements in the Earth’s crust; directional properties of …