Lesson Plan
Curated OER

Measuring Rainfall and Relationships Between pH, Alkalinity and Suspended Solids in the Pago River

For Teachers 11th
Eleventh graders test the pH and alkalinity of Pago River. In this ecology lesson, 11th graders collect data and use spreadsheet to graph results. They analyze and share their findings with the class.
Lesson Plan
Curated OER

Global Warming Statistics

For Teachers 7th - 12th
Students research real-time and historic temperature data of U.S. and world locations, and analyze the data using mean, median, and mode averages. They graph the data and draw conclusions by analyzing the data. A spreadsheet is used to...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
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.
Lesson Plan
Curated OER

Dinosaur Scavenger Hunt

For Teachers 2nd - 4th
Students conduct research on dinosaurs and graph the information gathered using a spreadsheet program. In pairs they complete an Internet scavenger hunt, and record five facts about dinosaurs in their science journal.
Lesson Plan
Curated OER

Political Issues Survey

For Teachers 5th
Fifth graders develop and conduct a survey regarding issues in a current political campaign. They distribute and collect the surveys, input the data using a spreadsheet program, and compare/contrast the recorded results.
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Middle schoolers collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and...
Lesson Plan
Curated OER

Fruit Loop Graphing

For Teachers 5th
Fifth graders interpret data and create graphs. Given Fruit Loops, they sort and classify according to color. Using spreadsheet technology, 5th graders record their data and create bar and circle graphs. Students analyze data and...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Triangle Midsegment

For Teachers 9th - 12th Standards
Learn how to calculate the length and midsegments of triangles. Students differentiate between similar and congruent triangles. They create a spreadsheet with their findings.
Lesson Plan
Curated OER

Graphing the Past Using Today's Technology

For Teachers 8th
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
Lesson Plan
Curated OER

Download and Analyze

For Teachers 3rd - 9th
Students download information from a NASA website into a database. They transfer it to a spreadsheet by completing the information and analyze the information. They determine temperature averages, mode, and graph the results. They write...
Lesson Plan
Curated OER

What's Our Department Budget?

For Teachers 9th - 12th
Analyze the influence of culture, media, technology, and other factors on health and examine a hospital budget. Learners will create a budget for a hospital taking in account factors such as staff and departmental needs and necessary...
Lesson Plan
Curated OER

How Much Does That Car Cost?

For Teachers 8th - 12th
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...
Lesson Plan
Curated OER

Supply and Demand

For Teachers 9th - 12th
Students define economic terms, list three conditions that must be present in order for demand to exist, define law of supply and demand, differentiate between buyer's and seller's markets, examine concept of elasticity, view tutorial on...
Lesson Plan
Curated OER

Bingo!

For Teachers 1st
First graders practice and reinforce phonics and/or math skills by creating Bingo! game using computer spreadsheet. Students incorporate phonics or math skills class has been practicing onto Bingo! cards, which can be printed and made...
Lesson Plan
Curated OER

Backyard Birds: Who's Who Out There?

For Teachers 3rd - 4th
Young scholars practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects...
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Why Would I Owe My Soul to the Company Store?

For Teachers 6th
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics instructional activity, 6th graders determine what a miner's income was minus his expenses...
Lesson Plan
Curated OER

Data Analysis: Infiltration Rate and Composition of Concrete

For Teachers 9th - 11th
Students collect and graph data. In this statistics instructional activity, students analyze data using a spreadsheet program. They display their data effectively and analyze it.
Lesson Plan
Curated OER

Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School

For Teachers 4th - 9th
Students study practical data analysis within the constraints of the scientific method.  In this data lesson students collect and enter data into a computer spreadsheet then create graphs.
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 10th - 12th Standards
Learners find common ratios of geometric sequences on a spreadsheet. Using this data, they create scatter plots of the sequences to determine how each curve is related to the value of the common ratio. They will consider whether series...
Lesson Plan
Curated OER

The Effects of Light Intensity and Wavelength on the Rate of Photosynthesis

For Teachers 9th - 12th
Students use an on line website to simulate the effects of light intensity and wavelength on photosynthesis. In this photosynthesis lesson plan, students determine how wavelength of light and intensity of light affect the rate at which...
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...

Other popular searches