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

Creating Climographs

For Teachers 6th - 8th
Students use satellite data to compare precipitation and surface temperatures on different islands.  In this satellite lesson plan students create graphs and explain the differences between weather and climate. 
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Lesson Plan
Curated OER

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Lesson Plan
Curated OER

Creating a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Lesson Plan
Curated OER

Million Dollar House

For Teachers 4th
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

E-mailing the Chamber of Commerce

For Teachers 9th - 12th
Encourage effective internet research and e-mail correspondence as scholars investigate a US capital city they've never visited to find pertinent and relevant information. They begin by picking a city, then visit that city's chamber of...
Lesson Plan
1
1
Curated OER

Irish Eyes: Taking a Look at Local Landscape

For Teachers 9th - 12th Standards
Direct your class’s attention to the elements that make their community unique. After examining sample travel brochures, groups select something from their community to use as the subject, and then research, create, and publish a...
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
Curated OER

How Does Cell Size And Shape Affect Transport of Materials

For Teachers 10th
Tenth graders explore concepts of surface area, volume, and ratios, create spreadsheets to aid organization of data collected and provide graphing capabilities, and use NIH Imaging to enable calculations of microscopic organisms.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Lesson Plan
Curated OER

Nascar Unit Activity 2

For Teachers 8th
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Lesson Plan
Curated OER

What Colors Are Your Skittles?

For Teachers 9th - 12th
Students record the numbers of each color in their own Skittles. They compare their results with their partner. Students create a spreadsheet to chart the different colors found in a package of Skittles. They create a PowerPoint...
Lesson Plan
Curated OER

Paper Tower Challenge

For Teachers 2nd - 5th
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Young scholars collect and record the heights of other towers and use that data to create a spreadsheet.
Lesson Plan
Curated OER

A Self Directed Inquiry into the Identification of Unknowns

For Teachers 9th - 12th
Learners gain experience in designing an experiment and use logic in selecting specific tests for unknowns. Students recognize the use of spreadsheets in helping one to make clear comparisons.
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Curated OER

Family Search We All Came To America

For Teachers 8th
Eighth graders participate in a computer based Family Search Unit. They use multimedia resources to research their country of origin, conduct interviews, and use software to produce narratives, databases, spreadsheets and graphs in this...