Curated OER
Creating Climographs
Students use satellite data to compare precipitation and surface temperatures on different islands. In this satellite lesson students create graphs and explain the differences between weather and climate.
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Curated OER
Dental Detectives
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; 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
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Curated OER
Spreadsheets in Science
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Curated OER
It's 'ELEMENT' ary
Students, using a Web site about the periodic table of elements, create spreadsheets representing elements and their properties. They also create graphs that compare the physical properties of the elements.
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Curated OER
Temperature High and Lows
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
Curated OER
Birds, Fractions and Percentages
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
Howard Hughes Medical Institute
Scientific Inquiry Using WildCam Gorongosa
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
Curated OER
How Does Cell Size And Shape Affect Transport of Materials
Tenth graders explore concepts of surface area, volume, and ratios, create spreadsheets to aid organization of data collected and provide graphing capabilities, and use NIH Imaging to enable calculations of microscopic organisms.
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Curated OER
What Colors Are Your Skittles?
Students record the numbers of each color in their own Skittles. They compare their results with their partner. Students create a spreadsheet to chart the different colors found in a package of Skittles. They create a PowerPoint...
Curated OER
Graphs and Spreadsheets
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Curated OER
A Self Directed Inquiry into the Identification of Unknowns
Learners gain experience in designing an experiment and use logic in selecting specific tests for unknowns. Students recognize the use of spreadsheets in helping one to make clear comparisons.
Curated OER
Math: The Bone connection
Young scholars examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating...
Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
Pumped Up Gas Prices
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Curated OER
Ecological Footprint
Eighth graders discover their own ecological footprint and create a plan for reducing this figure. They extend this to the school and community to see how they are doing on this scale. They discuss the concept of the ecological...
Curated OER
Polluting the Environment
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Curated OER
Publisher Brochures
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Curated OER
Modeling Mitosis and Meiosis
Students construct and manipulate models of mitosis and meiosis and compare/contrast them. They create the models using index cards and yarn, interpret diagrams and photographs, and summarize written descriptions.