Lesson Plan
Curated OER

Skyscraper Capers

For Teachers 5th - 8th
Pupils discuss skyscrapers and listen as the teacher introduces the project. They use the Internet to perform research on one skyscraper. Students use information they gather to create a brochure of their building . They create an Excel...
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
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

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
Alabama Learning Exchange

What's Your Favorite Chocolate Bar?

For Teachers 5th - 6th Standards
Students complete a math survey. In this math graphs lesson, students complete a survey about their favorite candy bars. Students create different kinds of graphs using Microsoft Excel to show their results.
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology lesson, students investigate the water quality in their community and compare their findings to the water quality in other geographic...
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Alabama Learning Exchange

The State Capital of Stem and Leaf

For Teachers 5th - 10th Standards
Students explore the concept of stem and leaf plots.  For this stem and leaf plots lesson, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state.  Students compare...
Lesson Plan
Curated OER

A Hero Biography Project

For Teachers 4th
Fourth graders study historical significant people born in January and February and note their accomplishments. Using given websites, 4th graders collect biographical information and participate in activities about a specified hero. ...
Lesson Plan
Curated OER

Significant Science: Statistics for Planet Earth

For Teachers 9th
Ninth graders discover how statistics are used to interpret results of scientific experiments. Students write hypotheses and test the hypotheses by collecting data and organizing the data. Students graph their data to produce a visual....
Lesson Plan
1
1
Teach Engineering

Photosynthesis—Life's Primary Energy Source

For Teachers 6th - 8th
Wouldn't it be great if you could produce your own food? Scholars learn about the processes of photosynthesis and cellular respiration in plants. They consider how to use photosynthesis as a model of an efficient system and how to apply...
Lesson Plan
Curated OER

How Much is There to Eat?

For Teachers 9th - 12th
Students examine food production related to population density. In this interdisciplinary instructional activity, students gather data regarding food production in the American South and in India. Students follow the outlined steps to...
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

For Teachers 6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Lesson Plan
1
1
California Academy of Science

Optimal and Sustainable: Renewable Energy Revamp

For Teachers 6th - 10th Standards
More than 100 cities around the world have shifted from fossil fuels to renewable energy sources. Scholars investigate a city wanting to make this switch, but needs help determining how to make the shift. Groups consider all options,...
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Learners study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Learners chart their results in an Excel document...
Lesson Plan
Curated OER

Weather Or Not

For Teachers 3rd - 5th
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Lesson Plan
Curated OER

Build and Test

For Teachers 6th - 10th
Young scholars display what they have learned about bridges as they construct their bridge. They present their projects to the rest of the class. They compare and contrast the construction of the bridges.
Lesson Plan
Curated OER

Watt's Up with the Electricity Bill?

For Teachers 7th - 8th
Students study of how much electricity is used in their home and the actual cost for the electricity. They create a realistic conservation plan for their home focusing on the areas that tend to use a great deal of electricity....
Lesson Plan
Curated OER

Go Yankees!

For Teachers 5th - 8th
Students use the internet to research the New York Yankees baseball team. After gathering their information, they discuss the challenges faced by the team and how they were overcome. They end the instructional activity by examining the...
Lesson Plan
Curated OER

Forces on the Human Molecule

For Teachers 6th - 8th
Pupils conduct several simple lab activities to explore the five fundamental load types that can act on structures: tension, compression, shear, bending, and torsion. For this activity, students play the role of molecules in a beam...
Lesson Plan
Curated OER

Timeline - Curriculum Connections

For Teachers 6th - 8th
Pupils research a timetable for the building of the Tacoma Narrows Bridge. After the research is completed, students construct a graph and come up with different proposals for the building of the bridge.