Cruising the Climate with Spreadsheets: Making Worldwide Weather and Climate Comparisons Using Graphs and Spreadsheets

By Krall, Rebecca McNall | Science and Children, April-May 2010 | Go to article overview

Cruising the Climate with Spreadsheets: Making Worldwide Weather and Climate Comparisons Using Graphs and Spreadsheets


Krall, Rebecca McNall, Science and Children


[ILLUSTRATION OMITTED]

Collecting and recording weather data is a wonderful activity for teaching elementary children about changes in weather patterns within their local area. Weather data collected over extended periods provides opportunities for students to identify patterns in their local weather, which can lead to discoveries about the local climate. In addition, they can learn to construct and interpret line graphs from data they collect. Making comparisons beyond the local area requires additional data sources--readily available on the internet. I have found electronic spreadsheets and online weather databases excellent tools for making real-world comparisons of local, national, and global climate trends.

I use the following activities with my elementary science methods students to bridge our study of weather and the seasons. Climatic patterns that emerge through these activities initiate aha moments for some students and elicit questions about what causes the seasons for others. The activities help familiarize students with electronic spreadsheets and how to use authentic data sets available from the internet to answer authentic scientific questions. These activities address important standards-based concepts in science, mathematics, and geography, and are appropriate for grades 4-6.

Spreadsheets: Scientific Tools

Scientists rely on analytic computer tools such as electronic spreadsheets and other data analysis software to organize, analyze, and share their findings with peers. These programs provide a way to easily transform large data sets into graphical representations, which scientists use to identify patterns in their data. Children also can use electronic spreadsheets for similar purposes, and should do so, according to the National Educational Technology Standards for Students (ISTE 2007).

Graphing is an important process skill that many elementary students often struggle to learn. Constructing a good graph and interpreting patterns identified in a graph require different skills. Many students become so focused on how to construct a good graph that they overlook the purposes for making it. Flick and Bell (2000) recommend using the unique features of educational technologies to make abstract concepts more apparent to students or to engage them in authentic scientific investigations. Electronic spreadsheets can do just that. These tools offer opportunities for students to organize and analyze data, identify patterns within their data, and develop professional-looking graphs. Thus, electronic spreadsheets can be used to focus students' attention on identifying patterns in their data rather than how to make a good graph.

Activity Preparation

Before beginning the activities, it is important that students have collected weather data, constructed paper-and-pencil graphs of their data, and interpreted their data using the graphs. Students should collect several months of weather data to identify changes in their local climate (e.g., collecting daily temperature).

Recording several weeks of weather data in an electronic data table is a great way to introduce students to electronic spreadsheets (e.g., Excel, Apple, Open Office, or similar program; see Figure 1 for a list of tutorials and some spreadsheet tips) and help them identify emerging patterns in their data. The activities in this article were conducted using Excel.

If your students (or you) are not familiar with electronic spreadsheets, the M&M activity developed at Oregon State University (see Internet Resources) is a great way to familiarize them with these tools. The M&M activity challenges students to determine the average number of each color of candies in a bag of M&Ms. In doing so, they construct a rough draft of a spreadsheet using note cards, and then transfer the data into an electronic spreadsheet.

Figure 1.
List of free online spreadsheet
tutorials and spreadsheet hints/tips. 

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Notes
Cite this article

Cited article

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)

1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

Cruising the Climate with Spreadsheets: Making Worldwide Weather and Climate Comparisons Using Graphs and Spreadsheets
Settings

Settings

Typeface
Text size Smaller Larger
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Style
Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.