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...
Lesson Plan
Curated OER

Power Point -- Science Portfolio

For Teachers 3rd - 5th
Students are introduced to Microsoft PowerPoint. Using the internet, they research a topic of interest to them related to science. They create three slides and share them with the class. They also discover how to print the slides and...
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Asthma "Outbreak" Exercise

For Teachers 8th - 12th
Students investigate numerical data on a possible asthma epidemic. Using statistical information, students graph and figure ratios of the epidemic. They evaluate the mortality rate from severe smog in the 1950's in London.
Lesson Plan
Curated OER

Remembering Our Veterans Data Management Project

For Teachers 7th
Seventh graders utilize data collected from various sources based on Canadian military statistics to consolidate their understanding of data management. Students plan and create a PowerPoint presentation using this data including in...
Lesson Plan
Curated OER

2D Kinematics w/ String Racers

For Teachers 11th - 12th
Students calculate the speed of string racers. In this physics lesson, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Lesson Plan
Curated OER

Stock It To Me

For Teachers 6th - 8th
Learners investigate the stock market using stock market tables, charts, and graphs. They participate in a simulation of stock market investment over time. They read about the history of Wall Street and the Stock Market.
Lesson Plan
Curated OER

A Change of Climate

For Teachers 6th - 12th
Students research various sources to learn about global warming. They then create a multimedia presentation about global warming. They take a stance on the issue and present that as well.
Lesson Plan
Curated OER

Texas Weather Report

For Teachers 4th - 5th
Students use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...