Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Lesson Plan
Curated OER

Skittle it Up

For Teachers 6th - 8th
Students make a graph. In this graphing and Excel instructional activity, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a...
Lesson Plan
Curated OER

Bias in Statistics

For Teachers 7th - 8th
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Lesson Plan
Curated OER

Fairy Tales

For Teachers 6th
Sixth graders explore the elements of fairy tales. In this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
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.  In 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

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Electric Field Mapping / Equipotential Lines

For Teachers Higher Ed
Students determine the equipotential lines surrounding a charged object. In this physics lesson, students draw lines to identify areas. They relate the spacing of the field lines to the strength of the charge.
Lesson Plan
Curated OER

Family Vacation

For Teachers 5th - 6th
Students use math to plan a trip by houseboat down the Mississippi River. They research and obtain information on the Mississippi River and its surroundings and use multiple graphs to represent their data.
Lesson Plan
Curated OER

The Great Chile Challenge

For Teachers 5th
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...
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

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 is ideal for a social studies classroom and includes ideas for using iMovie, Excel, and MS Works or AppleWorks.
Lesson Plan
Curated OER

Geographic Effects on Precipitation, Water Vapor and Temperature

For Teachers 9th - 12th
Students investigate the factors affecting climate using Live Access Server. In this geography lesson, students graph atmospheric data using Excel spreadsheet. They compare and contrast temperature, precipitation and water vapor of two...
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...