Lesson Plan
Curated OER

Dough Lake Topology

For Teachers 9th - 12th
Young scholars practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Lesson Plan
Curated OER

Touring the Regions of the United States

For Teachers 5th
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Young scholars complete a survey and enter the responses in a spreadsheet. The spread sheet is used to create a bar graph. Students complete spreadsheets listing types of hazards in their community.
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

The Price of War

For Teachers 5th
Fifth graders, in groups, research major battles fought during the Civil War and complete an activity sheet. They choose one particular battle and create a timeline and graph using the statistics researched.
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

What Happens on Average

For Teachers 5th
Fifth graders are introduced to convergence of sequences based on averaging previous terms in the sequence. The power of the "fill-down" function in spreadsheets is exploited. By using various starting numbers, and inferring the limit,...
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Lesson Plan
Curated OER

Action Research for Students

For Teachers 3rd - 4th
Students conduct an Action Research project of their own to help them become better readers of informational text, study about the regions of the United States and analyze reading skills by utilizing spreadsheets.
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Students use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Geography Fieldwork River Study

For Teachers 8th
Eighth graders collect, record, and analyze data from a local river and input the data into the computer. They collect and record the information, discuss the data collected, and enter the data into a spreadsheet and charts to compare...
Lesson Plan
Curated OER

Unit 2: Lesson 7

For Teachers 6th - 8th
Students are introduced to spreadsheets. They conduct a survey of television viewing time of different shows based on different age categories. Students work in small groups. They collect, data and interpret the data from a survey.
Lesson Plan
Curated OER

Job Distribution After 1945

For Teachers 7th - 10th
Students research job distribution in the U.S. after 1945. They study a spreadsheet of employment data and identify changes in the distribution of jobs in America since World War II. They create pie charts reflecting the data of jobs...
Lesson Plan
Curated OER

Which Color Will You Pick?

For Teachers 5th - 6th
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

The People Behind the Numbers

For Teachers 10th
Tenth graders brainstorm potential definitions for "developed" and "developing" countries. They work in groups of four and research using Web sites listed to find information about their country then they create a spreadsheet which...
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Bubble Gum Chemistry

For Teachers 8th - 10th
Students explore the concept of graphing data. In this graphing data instructional activity, students determine the percentage of sugar in bubble gum. Students graph type of gum vs. sugar percentage. Students create a table of their data.
Lesson Plan
Curated OER

Following the Stock Market With a Palm

For Teachers 10th - 12th
Students research and explore the stock market. They research a three-year history of stocks, develop a group and individual spreadsheets, and follow their stocks and prices for a ten-day period, graphing the results.
Lesson Plan
Curated OER

Understanding Cloud Formation

For Teachers 3rd - 5th
Students read and relate the poem, "Clouds" by Aileen Fisher to a demonstration on cloud formation. They create clouds in jars using ice water and matches then discuss the ways clouds can be used to predict weather.
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

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.