Lesson Plan
Curated OER

Exploring the Beach

For Teachers 6th - 9th
Students explore the beach. In this marine habitat lesson, students inspect sand grains, design beach profiles, classify marine life, and examine natural beach habitats. Students use spreadsheets to record data from their activities at a...
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

How Much Is It?

For Teachers 6th - 8th
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
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

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Lesson Plan
Curated OER

Polygons and Plane Figures

For Teachers 4th - 6th
Students choose a polygon to define and describe, and use Power Point and the Internet to present their polygon.
Lesson Plan
Curated OER

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
Lesson Plan
Curated OER

A Cylinder Workshop

For Teachers 7th - 10th
Students work with given formulas to solve for specific variables. The calculation of the volume of a cylinder and the change in volume when there is a constant surface area is analyzed in this lesson.
Lesson Plan
Curated OER

Buying and Financing the Car of Your Dreams

For Teachers 8th
Eighth graders go to one of a number of web sites (provided by the teacher in a hotlist) to find a car they would like to buy if they were old enough. They would then be provided with the necessary information to compute monthly payments...
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
Students use research skills to solve a problem. They research information needed to plan a vacation. Students create a letter, a flyer, an itinerary, an activity list, cost spreadsheet, a reference page, table of contents and a title page.
Lesson Plan
Curated OER

A Christmas Project

For Teachers 7th
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Lesson Plan
Curated OER

Harry Potter Research Project

For Teachers 4th - 5th
Students work together to complete a research project on Harry Potter. They write a research question and develop a survey to give to their classmates. Using the results, they create a graph and draw conclusions about the data collected.
Lesson Plan
Curated OER

The Snack Bar

For Teachers 6th
Sixth graders complete a purchase order. In this ratios and patterns lesson, 6th graders work in groups to complete a purchase order for a grand opening of the school snack bar. Students use rations to figure out the need and quantity...
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

Our Favorites

For Teachers 6th - 7th
Pupils participate in and conduct a survey to determine various class favorites. They collect, organize and display their data, interpret the results, and complete a packet of worksheets to display the information.
Lesson Plan
Curated OER

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Lesson Plan
Curated OER

Scale Basketball

For Teachers 9th - 12th
Students understand that a spreadsheet can be used to find the best scale to use in a model. They place the distances of the planets of the solar system to the Sun in one column of the spreadsheet. Students try different scales so that...
Lesson Plan
Curated OER

What is for Sale and at What Price?

For Teachers 7th
Seventh graders will research information on products carried by a store (such as sporting goods, department, clothing, etc.) They will create purchase prices for the products they wish to carry. They also will decide what percentage...
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Lesson Plan
Curated OER

Survey Says...

For Teachers 3rd - 7th
Students practice taking surveys to answer different questions about radio.  In this communications lesson, students brainstorm to create questions they can ask strangers about how often they listen to their radio.  Students...
Lesson Plan
Curated OER

Box Folding: Predict, Analyze and Measure

For Teachers 10th - 11th
Students predict the shape of a geometric figure in 3D. In this geometry instructional activity, students construct 3D shapes to perfect their knowledge of measuring and predicting. This assignment is also available as an online...
Lesson Plan
Curated OER

Graphing Fun In Third Grade

For Teachers 3rd
Third graders display information in a graph, table, and chart. In this data lesson plan, 3rd graders look at graphs, tables, and charts, discuss their importance, and make their own.
Lesson Plan
Curated OER

Iterating the Function over Real Numbers

For Teachers 8th - 10th
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.