Lesson Plan
Curated OER

Arizona Grown Specialty Crop Lesson Plan: Where Do They Go?

For Teachers 10th - 12th
Young scholars explore biotic and abiotic factors in landscape design. In this landscaping lesson, students create 3-dimensional models that represent landscape designs taking into consideration climate and planting requirements.
Lesson Plan
Curated OER

Weather Watchers

For Teachers 1st - 3rd
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.
Lesson Plan
Curated OER

DOWNHILL DISCOVERIES

For Teachers 5th - 8th
Students studykinetic energy, friction, drag and acceleration by relating it to the Winter Olympics.  In this physical properties lesson plan students create tracks and determine how the course conditions affect bobsled, luge...
Lesson Plan
Curated OER

It Ain't Easy Being Green!

For Teachers 1st - 3rd
Students explore the needs of plants. In this science lesson, students plant seeds and place one in a sunny spot and the other in a dark area. Students observe what happens.
Lesson Plan
Curated OER

How Many M&M's

For Teachers 4th - 6th
Students explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Students use the chart wizard to create a graph.
Lesson Plan
Curated OER

Canada and the Second World War

For Teachers 8th
This lesson is designed to introduce students to Canada's role in World War II and the impact it had on Canadian society. It allows the opportunity to improve their research skills by selecting various pieces of information from a...
Lesson Plan
Curated OER

Eerie Indiana!

For Teachers 11th
Eleventh graders research the population for ten cities in their state, in this example, Indiana, using census information. They design a spreadsheet using the data and create a bar graph with the data. They complete follow up questions.
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
High schoolers demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Integrating Math and Sports Project

For Teachers 5th - 6th
Students work in pairs to choose a set data from one of the sports websites for their chosen sports. They find the mean, median, mode, and range of their data set. Students create a graph on Microsoft Excel and write several...
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Lesson Plan
Curated OER

The Great Turkey Walk

For Teachers 4th - 6th
Students formulate questions that can be addressed with data and collect, organize, and display relevant data to answer them. They wcreate bar graphs and pie graphs
Lesson Plan
Curated OER

Dough Lake Topology

For Teachers 9th - 12th
Students practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Lesson Plan
Curated OER

Has Change Been Good for Texas?

For Teachers 4th
Fourth graders identify the events and inventions that have caused a change in the state of Texas. Using the internet, they research the year these took place and create a timeline. They identify the positive or negative impact of each...
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

Fractions Decimals and Percents

For Teachers 7th
Seventh graders use Microsoft Excel to examine fractions, percents and decimals. Using the data, they draw fractions and use graphs to discover all three are the same only represented in a different way. They use the internet to complete...
Lesson Plan
Curated OER

Area graphics for 7th graders

For Teachers 6th - 7th
Young scholars randomly select dimensions for three geometric shapes (square, right triangle and circle). From the graphs they compare and contrast the graphical results of each shape.
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Lesson Plan
Curated OER

Pi Digit Distribution

For Teachers 11th - Higher Ed
Students study graphing skills and compare and contrast data sets. They compute pi through the first 50-100 digits and create a bar graph showing the frequencies of specific digits.
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Curated OER

Tracking Ozone

For Teachers 5th - 7th
Students track an ozone event in Groton, CT. They compare weather changes and the subsequent ozone levels. Also, they make comparisons and determinations about ozone levels.
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.
Lesson Plan
Curated OER

Aksing Questions -- What is Fame?

For Teachers 6th - 8th
Students distribute copies of a survey to the local community about famous women. They gather the data and present it in a clear way. They examine the community's view on different issues.
Lesson Plan
Curated OER

Weights and Measures

For Teachers 6th - 8th
Students master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.
Lesson Plan
Curated OER

Virtual Vacation

For Teachers 6th - 8th
Students select a foreign city, research the city using the Internet, and plan an eleven-day vacation to that city. This lesson plan is ideal for a social studies classroom and includes ideas for using iMovie, Excel, and MS Works or...