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

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

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Lesson Plan
Curated OER

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
High schoolers explore the changes in sea ice over several years. In this life science instructional activity, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
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
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

Halloween Graphitti

For Teachers 5th - 7th
Students complete multi-curricular activities in a Halloween themed lesson. In this Halloween lesson, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf plot. Students find the diameter,...
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

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

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

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