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

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 Stoichiometry Behind Pollution

For Teachers 9th - 12th
High schoolers research car emissions of various cars and find the toxins emitted.  In this stoichiometry activity, students calculate the relationship between reactants and products in a chemical reaction. High schoolers collect...
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

Smarty Pants

For Teachers 3rd - 4th
Students graph the colour distribution found in a packet of Skittle lollies, M&M's, Smarties or similar sweets. Results are compared and recorded against the results of other class members.
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

Labeling the World

For Teachers 6th
Sixth graders conduct research on the countries found on the labels on their clothing. They locate the countries on a map, research the labor practices on countries that export clothing to the U.S., and create a graph using the information.
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

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

Book: Latinos Today: Facts and Figures

For Teachers 8th - 10th
Students, after reading Chapter 1 in the book, "Latinos Today: Facts and Figures," identify and characterize the four main ethnic/racial groups in America. They calculate and design a bar graph showing their populations by their...
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

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
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

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

The Survey Says

For Teachers 8th - 12th
Learners experience the development of statistical data. In groups, they construct a survey questionnaire for a target audience. Students produce the questionnaire, distribute it, collect it, and tabulate the data. Using EXCEL, the...
Lesson Plan
Curated OER

Food Groups in our Lunch

For Teachers 3rd - 5th
Young scholars make a graph. In this food groups and graphing lesson, students pack a sack lunch and then work in groups to tally the number of foods from each food group that they have. Young scholars use the data collected to create a...
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

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

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
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

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

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...

Other popular searches