Lesson Plan
Curated OER

Excellent Eggs

For Teachers K - 1st
Students recognize the short vowel e in written and spoken language. Through matching activities, they discriminate the short vowel /e/ from other vowel phonemes. Students associate /e/ with its letter representation and identify the...
Lesson Plan
Curated OER

Sea Floor Spreading I

For Teachers 12th - Higher Ed
Students use Excel to explore the geodynamics Model equation for ocean depth around a sea-floor spreading center. They complete an introductory tutorial on Excel for students with no prior Excel experience.
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

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
Pupils 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
High schoolers explore the genre of journalism. In this journalism lesson plan, students examine newspaper articles and identify reporting techniques. High schoolers collaborate to identify excellent pieces of newspaper writing.
Lesson Plan
Curated OER

BIOASSESSMENT OF STREAMS

For Teachers 8th - 11th
Students 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
Middle schoolers explore the concept of geometric patterns. In this geometric pattern lesson, students use Microsoft Excel to explore geometric patterns. Middle schoolers analyze growth rates of pattern growth. Students create their...
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
Young scholars 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.

Other popular searches