Lesson Plan
Curated OER

What's Your Line?

For Teachers 5th
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
Lesson Plan
Curated OER

Million Dollar Project

For Teachers 5th
Each student is given the task of spending $1 million. The way students spend their money is dependent on a theme such as "creating a dream world," "taking a trip," or "doing something to better society." Each student researches,...
Lesson Plan
Curated OER

Handy Reflections

For Teachers 6th - 12th Standards
Learners explore reflections on a coordinate plane in this lesson. They trace their hand on a grid, determine the coordinates of each point, and create a scatter plot of their points. Pupils use this information to investigate aspect...
Lesson Plan
Curated OER

Famous People

For Teachers 6th - 8th
Students create a database with information about famous people. They develop a custom word-processing template. They practice merging fields into their template.
Lesson Plan
Alabama Learning Exchange

Bloodstain Pattern Doesn't Lie......

For Teachers 9th - Higher Ed Standards
An interesting instructional activity on hypothesizing about the diameter of a drop of blood that is splattered. To test their theories, learners work in groups to make blood droplets splatter from different heights. They use graphed...
Lesson Plan
Curated OER

Supermarket Smarts

For Teachers 9th - 12th
Pupils examine how a consumer can make informed choices. They visit stores with a prepared shopping list, record the prices on a spreadsheet, create graphs, and create a Powerpoint presentation comparing the total cost of stores and a...
Lesson Plan
Curated OER

Planets of the Solar System

For Teachers 5th - 8th
Students use the internet to research the planets in the solar system. Using the information they collect, they design and create a webpage with the data. They present their material to the class and answer any questions presented to...
Lesson Plan
Curated OER

European Travelers

For Teachers 7th
Seventh graders explore the European travelers and culture. They create a travel brochure that presents a given European culture in an inviting format. Students analyze the cultures of various European countries and select one they would...
Lesson Plan
Curated OER

Charting Seasonal Changes

For Teachers 6th - 10th
Students research the Earth's patterns of rotation and revolution, create a chart and graph of these patterns and use them to explain the causes of night and day and summer and winter.
Lesson Plan
Curated OER

Candy Bar Survey

For Teachers 2nd
Second graders investigate the skill of graphing data by using candy bars to create context for the lesson. They use technology for graphing and organizing information like a spreadsheet. The lesson includes a resource link to aid in the...
Lesson Plan
Curated OER

Colonialism in Africa

For Teachers 11th - 12th
Students examine Africa from a regional perspective. They appreciate the historic and geographic relationships that unite and divide the regions of Africa. Students create a comprehensive document outlining problems in the assigned...
Lesson Plan
Curated OER

Pizza! Pizza!

For Teachers 3rd
Third graders tally, sort, and organize pizza orders from monthly school sales. They create an advertising campaign to promote the School Pizza Sale, record the data in graph form, compare and contrast the tallies throughout the year,...
Lesson Plan
Curated OER

Measuring Speed With iMovie

For Teachers 6th - 12th
Students record each other running, walking, throwing a ball, or doing a similar activity for a set distance. They import the video clips into iMovie. They compute how long it took in miles per hour.
Lesson Plan
Curated OER

Drink It Up???

For Teachers 6th - 8th
Students research and record facts about well, lake, and tap water. They increase their computer skills for research, creating a spreadsheet, and word processing.
Lesson Plan
Curated OER

The Election Connection

For Teachers 3rd - 5th
Learners participate in a mock election. In this election lesson, students vote online in a mock election, graph the results, and compare their results to the nationwide results.
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Of Tides and Time

For Teachers 6th - 8th
Students use the internet to research how the time of day affects the tides. They work together to develop a demonstration of the tide patterns for a month. They create a chart showing the relationship between tides and the phases of...
Lesson Plan
Curated OER

Fencing Your Backyard

For Teachers 8th - 10th
Students use geosketch ro create a fence. In this geometry lesson, students identify the amount of material and area needed to create a fence. They calculate the perimeter and surface area of their fence.
Lesson Plan
Curated OER

Favorite Farm Animals

For Teachers K
Pupils perform a study of farm animals and their babies. They compile a graph of their favorite farm animals. They utilize a spreadsheet worksheet which is imbedded in this plan.
Lesson Plan
Intel

What Does This Graph Tell You?

For Teachers 9th - 12th
Students choose natural phenomena to research. They design and conduct experiments or simulations. Students predict, gather, and analyze data. They graph the results using a spreadsheet software.
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Pupils create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Lesson Plan
Curated OER

Understanding Tone

For Teachers 8th
Eighth graders define tone and determine the tone of a particular passage making a web of tone words on Inspiration. They write a journal entry expressing how a piece of music makes them feel and create a PowerPoint to share.