Lesson Plan
Curated OER

Watersheds:Stream Channels And Post-fire Stream Flows

For Teachers 5th - 8th
Students draw cross sections of a stream channel from field data. In the field, using a GPS, they determine the depth of a stream channel and use a spreadsheet to graph the stream channel.
Lesson Plan
Curated OER

The People Behind the Numbers

For Teachers 10th
Tenth graders brainstorm potential definitions for "developed" and "developing" countries. They work in groups of four and research using Web sites listed to find information about their country then they create a spreadsheet which...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Young scholars spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.
Lesson Plan
Curated OER

Sweet Car Dreams

For Teachers Higher Ed
Students rebuild two different makes of cars. They calculate the cost of rebuilding the car. They create a spreadsheet to track their progress and costs.
Lesson Plan
Curated OER

Destination Mars!

For Teachers 5th
Fifth graders view Mysteries of Earth & Mars Video on DVD and record thoughts in their online journal. They record data in a spreadsheet about each planet then form a theory of the best time to launch a space craft from Earth to land...
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Introduction to Evaluating

For Teachers 7th
Seventh graders are introduced to how to evaluate an electronic product. In groups, they grade the product on quality, materials and aesthetics. Using this information, they create a table of results along with a pictogram and...
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...
Lesson Plan
Curated OER

Power In The Wind

For Teachers 6th - 8th
Learners experiment designing graphs of selected readings from the Nebraska sites from the Power in the Wind study. They choose whether or not to put their data in a spreadsheet program to make a computer-generated graph or to complete...
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Pupils investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel and...
Lesson Plan
Curated OER

Technology Across the Curriculum

For Teachers K - 5th
Pupils take pictures of items they believe have at least one line of symmetry. They print their photos out in class and analyze the items they photographed. They continue by entering the names of their pictures into a spreadsheet. They...
Lesson Plan
Curated OER

2D Kinematics w/ String Racers

For Teachers 11th - 12th
Students calculate the speed of string racers. In this physics lesson, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Lesson Plan
Curated OER

Geographic Effects on Precipitation, Water Vapor and Temperature

For Teachers 9th - 12th
Students investigate the factors affecting climate using Live Access Server. In this geography lesson, students graph atmospheric data using Excel spreadsheet. They compare and contrast temperature, precipitation and water vapor of two...
Lesson Plan
Curated OER

Following the Stock Market With a Palm

For Teachers 10th - 12th
Students research and explore the stock market. They research a three-year history of stocks, develop a group and individual spreadsheets, and follow their stocks and prices for a ten-day period, graphing the results.
Lesson Plan
Curated OER

Running a Business

For Teachers 6th - 8th
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
Lesson Plan
Curated OER

Collecting Data on Running Speeds

For Teachers All
Students collect data on running speeds of various individuals in class to determine the average running speed for a distance of 20 meters.
Lesson Plan
Curated OER

Numbers, Patterns, and Algebraic Thinking

For Teachers 5th
Fifth graders use spreadsheets.
Lesson Plan
Curated OER

Ladybugs in the Garden

For Teachers 5th
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a instructional activity where they observed, examine, and...
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Introduction to Computing and Project Development

For Teachers 6th - 12th
Young scholars use a computer and math to complete a science project. They review a brief history of computers as well as information on different operating formats will be included. In addition, students complete an overview of the...
Lesson Plan
Curated OER

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Social Demographics and Election Statistics

For Teachers 9th - 12th
Students identify the type of data contained in a spreadsheet. They manipulate a spreadsheet of presidential election returns. Students develop the skills to use the Microsoft Excel program.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.

Other popular searches