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

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Learners explore energy by conducting an in class experiment. In this climate change instructional activity, students conduct a water vapor experiment in a soda bottle. Learners utilize graphs and charts to analyze the results of the...
Lesson Plan
Curated OER

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Lesson Plan
Curated OER

Unit 2: Lesson 7

For Teachers 6th - 8th
Pupils 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

Graphing Favorite Holidays

For Teachers 1st - 3rd
Students create spreadsheets and bar graphs based on results of survey of favorite holidays.
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
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

Macbeth Madness

For Teachers 10th - Higher Ed
Pupils research Macbeth online and complete computer and graphing activities for the play. In this Macbeth activities lesson plan, students research Macbeth and bookmark the URL's. Pupils complete activities for the topic on spreadsheets...
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

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

Crispy Cookie Class Fundraiser

For Teachers 7th
Seventh graders see the relationship of math and the real world application by manufacturing a product for making a profit. They create a food product from a recipe, record their sales and analyze and report their gross profit.
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Who is Coming to Our House?

For Teachers 9th - 12th
High schoolers 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...
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...
Lesson Plan
Curated OER

Researching a Scientist/Inventor

For Teachers 4th - 6th
Students research scientists and inventors. They research their figure and write notes on a Fact Card template, biographical information regarding their figure, their occupation and achievements. After citing their information and...
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

Tell Me a Story

For Teachers 10th
Tenth graders read short story, "The Storyteller" by Saki, and expand on concept of stories for students by reading and evaluating several popular students's stories as well as writing their own original students's stories.