Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
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

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Lesson Plan
Curated OER

Technology that Makes Phonics Fun

For Teachers K - 3rd
Students discover the Internet by participating in on-line educational activities.  In this educational technology lesson, students utilize interactive story books, podcasts, and games to help expand an understanding of phonics....
Lesson Plan
Curated OER

Have I Been Hacked?

For Teachers 6th - 12th
Students investigate how effective SNEAK strategies are in detecting hackers. In this technology lesson, students explain the ethical issues about hacking. They graph and analyze their experimental results.
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I lesson, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the relation...
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
Lesson Plan
Curated OER

Get My Point!

For Teachers 3rd - 7th
Here is one of the better lessons I've come across on how to teach fractions and decimals. This instructional activity does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent...
Lesson Plan
Curated OER

Introduction Lesson to the Book Where the Red Fern Grows

For Teachers 4th - 6th
An excellent lesson plan on the classic book, Where the Red Fern Grows. Learners view the W. Wilson Rawls website and engage in a series of activities generated by the website. They write in their reflective journals, watch a video, and...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time...
Lesson Plan
Curated OER

Fitness plan: number 3

For Teachers 7th - 12th
Learners monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This lesson...
Lesson Plan
Curated OER

Rockin' Data

For Teachers 5th
Fifth graders are given the questions, "What type of music would you suggest the manager place in front of the store?". Students collect data by talking with 20 adults and create a bar graph on the computer to present the data.
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

Exploring Linear Equations And Scatter Plots - Chapter 5 Review

For Teachers 6th - 7th
Students complete rolling stocks experiment, and collect and enter data on the computer. They enter data on graphing calculators, complete scatter plot by hand with line of best fit, and discuss different graphing methods.
Lesson Plan
Curated OER

Cockroach Slope

For Teachers 10th - 11th
Students identify the slope of linear functions. In this slope lesson, students collect data and graph it. They write equations with no more than two variables and use technology to explain their data.
Lesson Plan
Curated OER

Shake, Rattle, and Roll: Mt. St. Helens - Lesson Plan 2

For Teachers 6th - 8th
Students compile information on volcanic activity at Mount St. Helens.  In this earth science lesson, students use the information they gathered on Mount St. Helens to answer questions and create charts in Excel.  Then students...
Lesson Plan
Curated OER

Enhancing Writing Through Technology

For Teachers 1st - 3rd
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
Lesson Plan
Curated OER

Fruitvale Extension

For Teachers 6th - 8th
Students determine sources and extent of ground water contaminate, apply mathematics to model in real world simulation, and use technology to present results.
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

Rain Gardens for Controlling Excess Runoff

For Teachers 6th - 9th
Students address the idea that human beings live within the world' ecosystems. They discuss how humans modify ecosystems as a result of population growth, technology, and consumption. Students discuss how the human destruction of...
Lesson Plan
Curated OER

Global Water Cycle & Heat Flow

For Teachers 8th - 9th
Students experiment to discover how different variables affect the water cycle. They do hat flow experiments and construct a computer heat flow model.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.