Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
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

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Macbeth Madness

For Teachers 10th - Higher Ed
Students research Macbeth online and complete computer and graphing activities for the play. In this Macbeth activities lesson, students research Macbeth and bookmark the URL's. Students complete activities for the topic on spreadsheets...
Lesson Plan
Curated OER

The Seasonal Round and The Cycle of Life

For Teachers 4th
Fourth graders are introduced to the concept of the seasonal round and how folklife traditions vary from season to season. They begin charting dates of personal interest on seasonal round calendars by starting with birthdays. Students...
Lesson Plan
Curated OER

Fabulous Fossils

For Teachers 7th
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Lesson Plan
Curated OER

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
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

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

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

Thank You... Thomas Edison!

For Teachers 2nd - 3rd
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.
Lesson Plan
Curated OER

Energy Efficient Home Design

For Teachers 9th - 12th
Students investigate the applications of energy efficient homes. They conduct Internet research, complete a worksheet, evaluate the energy efficiency of a home design, and complete a research report on energy efficient homes.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

Career Exploration

For Teachers 7th - 8th
Students complete a unit about career choices. They conduct research on a selected career that interests them, conduct an interview, explore various websites, create a five-page HyperStudio stack, and write ten checks that relate to...
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

Exploring our Community

For Teachers 4th - 8th
Students research Los Angeles and its surrounding communities. They create digital presentations of the information they have gathered by answering the question included in the lesson.
Lesson Plan
Curated OER

Who is Coming to Our House?

For Teachers 9th - 12th
Pupils examine waves of immigration that affected the development of the United States, appreciate variety of countries of origin of immigrants, analyze immigration data, discern patterns in data and communicate finding to classmates,...
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

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

The President's Cabinet

For Teachers 8th
Eighth graders obtain information about the President's Cabinet by using a template, and exploring the bookmarked Internet sites.
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

The Media and You

For Teachers 7th
Seventh graders discuss the main purposes of media. Using various advertisements, they identify the method used by the advertisers in each example. They use these methods to create and sell their own product to the class. They use the...