Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Students explore spreadsheet software.  In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer.  Students represent hotel, food, transportation, and entertainment costs...
Lesson Plan
Curated OER

Marine Protected Areas

For Teachers 11th - 12th
Learners design a research project about a Marine Protected Area they chose. In this marine biology lesson, students gather fish count and catch data then graph them. They create an information poster about their findings.
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

Candy is Dandy

For Teachers 6th - 9th
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Lesson Plan
Curated OER

Circuits

For Teachers 10th - 12th
Students draw a schematic diagram of parts needed to build an op-amp. In this physics lesson, students test the operation of their machine. They graph and analyze data using excel.
Lesson Plan
Curated OER

A Statistical Look at Jewish History.

For Teachers 8th
Eighth graders study the relationship between fractions, decimals and percentages by completing activities. In this research analysis lesson, 8th graders look at different websites to figure out Jewish populations in different situations.
Lesson Plan
Curated OER

A Cleaner Today for a Greener Tomorrow

For Teachers 6th - 8th
Pupils examine recycling efforts. In this environmental stewardship lesson, students trace recycling efforts and script a skit regarding incandescent light bulbs' effect on the environment.
Lesson Plan
Curated OER

Tracking Data Using Quickoffice on a Palm Handheld

For Teachers 6th
Sixth graders keep track of the amount of garbage they threw away over 3 days time. They graph and analyze data and participate in discussions. They draw conclusions based on their data.
Lesson Plan
Curated OER

Tiling a Patio

For Teachers 5th
Fifth graders practice, with spreadsheets, to demonstrate how to determine the number of tiles needed to create a patio. They use pictures and gathered data to determine a pattern that can be used to solve problems. Students create a...
Lesson Plan
Curated OER

Testing Battery Combinations

For Teachers 4th
Fourth graders examine the required combinations of plates and predict which combination will generate the most and least current and voltage. They use an ammeter and experiment with combinations of their own testing and record each...
Lesson Plan
Curated OER

Getting to Know the Thirteen Colonies

For Teachers 5th
Fifth graders analyze information about the thirteen colonies. Using the information, they can manipulate and identify a region in which the colony is located. As a class, they make generalizations about the various regions and time...
Lesson Plan
Curated OER

Archaeology Vocabulary Sampling

For Teachers 4th - 8th
Students predict how many words out of ten they accurately define. They match the definitions to the correct vocabulary words and make a bar graph showing how many definitions were matched to the correct words. The write their group...
Lesson Plan
Curated OER

Shinto, Japan's First Religion

For Teachers 9th - 10th
Learners participate in centers activities that enrich understanding of Japanese culture, history, geography, art, and religion.
Lesson Plan
Curated OER

Running On Empty

For Teachers 11th - 12th
Students research causes of rising gasoline prices. They collect data on fluctuating gasoline prices and analyze the data using Excel. They write comparative essays supporting their results and create PowerPoint presentations to present...
Lesson Plan
Curated OER

An Introduction to the Natural Logarithm (ln)

For Teachers 10th - 12th
Young scholars explore the dose response principle, an introduction to what the "natural log" (ln) is and how it behaves. They create and analyze a dose response graph.
Lesson Plan
Curated OER

The Distribution of Earthquakes

For Teachers 9th - 12th
Students determine the rate of seismicity by determining the frequency of aftershocks following a major earthquake. They incorporate the use of the Internet, Excel 2000, a map of their area with latitude and longitude markers, and paper...
Lesson Plan
Curated OER

Who is Coming to Our House?

For Teachers 9th - 12th
Young scholars examine waves of immigration that affected the development of the United States, appreciate variety of countries of origin of immigrants, analyze immigration data, discern patterns in data and communicate finding to...
Lesson Plan
Curated OER

Do Vampires Really Exist?

For Teachers 6th - 10th
Students identify and extend a number pattern into very large values. They create and interpret a graph based on their number patterns. Students compare a math model with real-world statistics about the existence of vampires.
Lesson Plan
Curated OER

Geometric Transformations

For Teachers 5th - 7th
Students solve problems involving transformations of geometric figures. They review graphing points in the coordinate plain, plot points and connect to create a triangle. Then, they reflect triangles over the x and y axis and use...
Lesson Plan
Curated OER

Charting Seasonal Changes

For Teachers 6th - 10th
Students research the Earth's patterns of rotation and revolution, create a chart and graph of these patterns and use them to explain the causes of night and day and summer and winter.
Lesson Plan
Curated OER

Buy Low, Sell High

For Teachers 7th - 10th
Learners investigate the stock market and investing in corporate stocks by creating an investment portfolio. They develop database worksheets that track their stock's performance over a specified period of time. Students use their...
Lesson Plan
Curated OER

Weather v. Climate

For Teachers 9th
Ninth graders discuss the differences between climate and weather as a class. Using data they collected, they create a graph of the data to share with the class over a specific time period. They compare and contrast this data with...
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra activity, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

Packing for a Transcontinental Expedition

For Teachers 6th - 10th
Young scholars investigate what kinds of supplies would be needed for a trans-continental expedition. They watch a video about the Lewis and Clark expedition, develop a list of supplies, create a graph, and compare/contrast their list...