Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003
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...
Main Authors: | , |
---|---|
Format: | Article |
Language: | English |
Published: |
McMaster University
|
Series: | Spreadsheets in Education |
Online Access: | http://sie.scholasticahq.com/article/4522-using-spreadsheets-in-geoscience-education-survey-and-annotated-bibliography-of-articles-in-the-journal-of-geoscience-education-through-2003.pdf |
_version_ | 1797968415183339520 |
---|---|
author | Beth Fratesi H L Vacher |
author_facet | Beth Fratesi H L Vacher |
author_sort | Beth Fratesi |
collection | DOAJ |
description | 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 inclined strata; U-shaped valleys scoured by mountain glaciers; the Laplace Equation for groundwater flow; the location of our solar system within the Milky Way galaxy — demonstrates the huge breadth of topics in the earth science curriculum. The 38 papers collectively, and the five examples individually, make the point that spreadsheets developed for geoscience education can provide context for principles taught in courses of other disciplines, including mathematics. Our classification by mathematics skill area follows the content standards of the National Council of Teachers of Mathematics (USA) and may prove useful for educators seeking problems for skills-based assessment. |
first_indexed | 2024-04-11T02:46:32Z |
format | Article |
id | doaj.art-60ed014571a547a0aaeae4c3c5b8450c |
institution | Directory Open Access Journal |
issn | 1448-6156 |
language | English |
last_indexed | 2024-04-11T02:46:32Z |
publisher | McMaster University |
record_format | Article |
series | Spreadsheets in Education |
spelling | doaj.art-60ed014571a547a0aaeae4c3c5b8450c2023-01-02T17:50:27ZengMcMaster UniversitySpreadsheets in Education1448-6156Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003Beth FratesiH L VacherThirty-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 inclined strata; U-shaped valleys scoured by mountain glaciers; the Laplace Equation for groundwater flow; the location of our solar system within the Milky Way galaxy — demonstrates the huge breadth of topics in the earth science curriculum. The 38 papers collectively, and the five examples individually, make the point that spreadsheets developed for geoscience education can provide context for principles taught in courses of other disciplines, including mathematics. Our classification by mathematics skill area follows the content standards of the National Council of Teachers of Mathematics (USA) and may prove useful for educators seeking problems for skills-based assessment.http://sie.scholasticahq.com/article/4522-using-spreadsheets-in-geoscience-education-survey-and-annotated-bibliography-of-articles-in-the-journal-of-geoscience-education-through-2003.pdf |
spellingShingle | Beth Fratesi H L Vacher Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 Spreadsheets in Education |
title | Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 |
title_full | Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 |
title_fullStr | Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 |
title_full_unstemmed | Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 |
title_short | Using Spreadsheets in Geoscience Education: Survey and Annotated Bibliography of Articles in the Journal of Geoscience Education through 2003 |
title_sort | using spreadsheets in geoscience education survey and annotated bibliography of articles in the journal of geoscience education through 2003 |
url | http://sie.scholasticahq.com/article/4522-using-spreadsheets-in-geoscience-education-survey-and-annotated-bibliography-of-articles-in-the-journal-of-geoscience-education-through-2003.pdf |
work_keys_str_mv | AT bethfratesi usingspreadsheetsingeoscienceeducationsurveyandannotatedbibliographyofarticlesinthejournalofgeoscienceeducationthrough2003 AT hlvacher usingspreadsheetsingeoscienceeducationsurveyandannotatedbibliographyofarticlesinthejournalofgeoscienceeducationthrough2003 |