Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.
Lesson Plan
Curated OER

Entering Numbers 1 to 10, 1 to 20, 1 to 100

For Teachers K
Students enter numerals on spreadsheet and use template to record numerals.
Lesson Plan
Curated OER

Filling Out a Retrieval Chart

For Teachers 4th
Fourth graders generate a spreadsheet that includes research about coastal plants, wetland plants and animals and Hawaiian stream animals.
Lesson Plan
Curated OER

Which Color Will You Pick?

For Teachers 5th - 6th
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

Who's Going to the Convention?

For Teachers 9th - 12th
Learners practice planning budgets as they create a budget for ten employees of a company to attend a professional convention. They use the Internet, and spreadsheet software to complete their assignment.
Lesson Plan
Curated OER

Oceanography-Related Careers: To Be or Not to Be. . .

For Teachers 9th - 12th
Students investigate various careers in the field of oceanography. They conduct Internet research, record data on a spreadsheet, write a justification to explain why someone should accept a position found online, and write a letter to a...
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
Students 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
Students 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...
Lesson Plan
Curated OER

Technology Across the Curriculum

For Teachers K - 5th
Students 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

Geographic Effects on Precipitation, Water Vapor and Temperature

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

2D Kinematics w/ String Racers

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

Pulse Rates

For Teachers 3rd - 6th
Students answer the question, "How will the intensity of exercise effect your heart rate?", using physical workouts and AppleWorks, or similar spreadsheet program. This lesson can conclude with the creation of a graph of data collected.
Lesson Plan
Curated OER

Body Length Experiment

For Teachers 3rd - 5th
Students measure the lengths of their bodies and various body parts to determine the relationship (or lack of one) between body part length and the length of the entire body. A spreadsheet program is suggested for data collection.
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.

Other popular searches