Lesson Plan
Curated OER

Running On Empty

For Teachers 11th - 12th
Learners 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

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

M & Ms in a Bag

For Teachers 3rd - 5th
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Problem Solving with Batting Averages

For Teachers 5th
Fifth graders use data from an Excel document to analyze and predict trends in batting averages.
Lesson Plan
Curated OER

Designing Another Juilliard

For Teachers 8th - 12th
Students investigate the vision and history of the Juilliard School. They develop a personal mission statement, watch a video, conduct Internet research, and create a PowerPoint presentation about a fictional school that also promotes...
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

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Lesson Plan
Curated OER

Using Best Newspaper Writing in a Journalism Class

For Teachers 9th - 12th
Students explore the genre of journalism. In this journalism instructional activity, students examine newspaper articles and identify reporting techniques. Students collaborate to identify excellent pieces of newspaper writing.
Lesson Plan
Curated OER

BIOASSESSMENT OF STREAMS

For Teachers 8th - 11th
Young scholars work as a team to gather organisms from a stream to evaluate if the water quality is excellent, good, or fair to poor.
Lesson Plan
Curated OER

The Sun's habitable Zone

For Teachers 9th - 12th
Students explore the average surface temperature of planets. They use the Planet Temperature Calculator to find the average temperature. Students explore how the distance from the sun affects the Earth's average surface temperature. They...
Lesson Plan
Curated OER

Classroom Singing

For Teachers 9th - 12th
Students sing a song performing rhythms accurately with a steady beat, pitches accurately with excellent intonation, and a clear, focused tone in this music lesson for the high school Choir class. The lesson includes grading rubric.
Lesson Plan
Curated OER

Alzheimer's Disease

For Teachers 9th - 12th
Investigate Alzheimer's disease. Conduct research using a variety of resources, obtain information, and input the data into a Microsoft Excel spreadsheet. Identify trends in the data and categorize them for an audience.
Lesson Plan
Curated OER

Ice Melting Investigation

For Teachers 7th - 9th
Students conduct an ice melting investigation in which they observe and measure the melting of two ice spheres. They develop a hypothesis as to which sphere will melt the fastest, collect data every ten minutes, and graph the data using...
Lesson Plan
Curated OER

Impact Craters and Water on Mars

For Teachers Higher Ed
Students explore for water on Mars using impact crater morphology. During this lab, students: investigate how to use the equation writing and graphing capabilities in Microsoft Excel, then develop and apply an impact crater...
Lesson Plan
Curated OER

Create and Analyze Rectangular Patterns

For Teachers 6th - 8th
Learners explore the concept of geometric patterns. For this geometric pattern lesson, students use Microsoft Excel to explore geometric patterns. Learners analyze growth rates of pattern growth. Students create their own patterns...
Lesson Plan
Curated OER

Graph Related Linear Inequalities

For Teachers 9th - 12th
Learners explore the concept of linear inequalities. In this linear inequality lesson, students graph linear inequalities using Microsoft Excel.
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
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

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
Lesson Plan
Curated OER

Musical Math Challenge

For Teachers 4th
Fourth graders engage in a lesson in which problem solving is set to music - like musical chairs. They listen to classical music to set a thought-provoking atmosphere. This is also an excellent method of reinforcement or review.
Lesson Plan
Curated OER

Dynamic River Model

For Teachers 5th - 8th
Students develop the concepts of flood stage, levees, floodplain, and the dynamics of river flooding. They construct river models and test various flow rates and volumes. This instructional activity has an excellent experiment for...
Lesson Plan
Curated OER

Where Will You Go?

For Teachers 5th
Fifth graders participate in a WebQuest in which they calculate mileage and cost per person for a trip to an amusement park. They explore various websites, and produce an Excel spreadsheet.

Other popular searches