Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
Counting Coins
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis lesson students use an Excel spreadsheet to map their data.
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
Let's Keep Track of Grades
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Curated OER
Author Study (Chris Van Allsburg)
Third graders study a list of books written and illustrated by the author. They examine facts about the author's life. They take a survey of Allsburg's books read by the students using the Excel spreadsheet.
Curated OER
Which Amusement Park Would You Choose?
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Curated OER
Does Humidity Affect Cloud Formation?
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Curated OER
Analyzing Tree Rings to Determine Climate Change
Students examine how to locate and access data sets. For this climate change lesson students import data into Excel and graph it.
Curated OER
Think GREEN - Utilizing Renewable Solar Energy
Students use data to find the best renewable energy potential. In this solar energy lesson students import data into Excel and explain how solar energy is beneficial.
Curated OER
Build Your Dream Bedroom
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Curated OER
Bean Sprout
Student will track the growth of his/her bean sprout with sunlight and without sunlight over the course of 3 weeks. They will enter the results into an excel data base then graph the results of both variables to make the comparison.
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
It's In The Chocolate Chips
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Curated OER
How Much Does That Car Cost?
Students calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create a...
Curated OER
Bunny Cakes and Graphing
Third graders graph and analyze data relating to the book "Bunny Cakes" by Rosemary Wells. They listen to and discuss the book, vote on their favorite cake using Excel computer software, and discuss the results.
Curated OER
Who Am I Like?
Learners examine family structures. For this family structure lesson, students discover things about their own families and those of their classmates. They make a chart as they discuss nature versus nurture, complete a worksheet about...
Curated OER
Trends of Snow Cover and Temperature in Alaska
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Curated OER
Survival of the Fittest – Battling Beetles
Students explore natural selection. For this genetic adaptation lesson, students discover why certain traits continue and some traits disappear. Students discover how species evolve and change. Resources are provided.
Curated OER
Cell Size Changes
Students examine the behavior of living cells treated with different types of stimuli. They watch an online movie, examine wet mount slides under a microscope, take an online quiz, and analyze data.