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

Let's Go Camping

For Teachers 5th
Fifth graders plan a budget for a camping trip. They use a spreadsheet to organize the budget and word processing justification for their choices.
Lesson Plan
Curated OER

Have Fun With Technical Report Writing

For Teachers 9th - 12th
Students use Clarisworks Word Processing and Spreadsheet, Quick-Take Camera and Software, and produce a publishable technical paper.
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Middle schoolers solve word problems using a spreadsheet, strategies, and algebraic variables. They disuss the given problem, which can be printed, write the unknowns, and employ the strategies into a spreadsheet. Students then use...
Lesson Plan
Curated OER

Calculating Orbital Speeds

For Teachers 11th - 12th
Students are introduced to the regularities of planetary motion. They create a spreadsheet to calculate the speed of any orbiting body at apogee and perigee. Students then use the spreadsheet to compare the speeds of planets, moons,...
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Escape The Hangman

For Teachers 7th
Seventh graders investigate the concept of probability. They use the game of hangman to create engagement and context for conducting the lesson. They create a spreadsheet with data that is given. Students make predictions based on data.
Lesson Plan
Curated OER

Measuring "pHacts" about Acid Rain

For Teachers 6th
Sixth graders gather and graph information regarding the pH of rain. Working cooperatively with an internet partner, 6th graders gather and record information about the pH of the rain in their local area. They graph this information...
Lesson Plan
Curated OER

Keypals and You

For Teachers 6th - 12th
Students collect and compare data received from keypals. They use electronic mail to exchange information with keypals and rrite a paper comparing similarities and differences between themselves and their keypals. In addition, use a...
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

You Be The Judge: Olympics, Winter Sports, Figure Skating, Math, Statistics, Technology

For Teachers 6th - 8th
Middle schoolers design a score sheet for use when watching a figure skating performance. They use spreadsheet software and research information obtained on the Internet to create their score sheets.
Lesson Plan
Curated OER

Our Favorite Pet

For Teachers K
Students each have a turn, telling the class his or her favorite pet. The choices are cat, dog, fish or bird. Using the computer, the information from the tally be recorded on a spreadsheet and bar graph.
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.
Lesson Plan
Curated OER

The Derivation of (Pi)

For Teachers 7th
Seventh graders groups measure the diameter and circumference of each of the circular objects in the room. They record their results on their student worksheets and access a computer spreadsheet program to compile their results.
Lesson Plan
Curated OER

Careers

For Teachers 8th
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
Lesson Plan
Curated OER

Graph the Density of Fruit

For Teachers 5th
Fifth graders review the definition of mass and volume. They calculate and graph the density of various types of fruit while working in groups on a spreadsheet program. They look at how size of the fruit can be similar but the weight is...
Lesson Plan
Curated OER

Tallahassee Project

For Teachers 6th
Sixth graders gather information from technological sources such as TV, radio, and Internet as well as from newspapers and maps and produce a final printed report. They use the data to create a spreadsheet and read a Florida state...
Lesson Plan
Curated OER

Journaling Art

For Teachers 9th - 12th
Students write in daily journal. Using computers, students keep the journal in spreadsheet form. They research facts on given artists. At the end of the six-week term, students are tested over the artist.
Lesson Plan
Curated OER

Defining Moments-from the past with lessons for a post 9/11 world

For Teachers 9th - 12th
Students use the spreadsheet to determine policy options, establish criteria for the solution, weight the criteria in terms of importance and rate the options relative to each criterion to determine a solution to the problem. They...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Weather

For Teachers 3rd - 5th
Students collect daily weather types throughout the school year using a spreadsheet program and Meteorologist freeware in order to predict weather changes and compare seasons. An Appleworks worksheet is included.
Lesson Plan
Curated OER

Occupational Outlook

For Teachers 9th - 12th
High schoolers analyze collected data to determine the occupational outlook for a variety of careers. This social studies lesson for the high school classroom is ideal for student practice using spreadsheet software, internet access,...
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.

Other popular searches