Lesson Plan
Curated OER

How Would You Spend a Million Dollars?

For Teachers 5th - 8th
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
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

Putting Your Money to Work

For Teachers 9th - 11th
Students create a collect data on expenses. In this algebra lesson plan, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson plan.
Lesson Plan
Curated OER

Box-and-Whisker Plots

For Teachers 9th - 12th
Students explore nutritional information for several fast food hamburgers using statistical applications. In this statistics lesson, students analyze calories, fat, and sodium content of various fast food restaurants. Students also...
Lesson Plan
Curated OER

Holiday Cards using Publisher

For Teachers 2nd - 6th
Learners create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Learners organize, design, and edit their card.
Lesson Plan
Curated OER

Indegenous Cultures Magazine in Publisher

For Teachers 4th
Fourth graders use Publisher to create their own magazine. In this online magazine lesson, 4th graders follow the instructions to create a magazine using text, pictures, and colors within the Publisher system.
Lesson Plan
Curated OER

I'm in the Money - Practical Money Skills

For Teachers 3rd - 6th
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
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

Holiday Flier in Publisher

For Teachers 2nd - 5th
Students use Publisher in this lesson to make a holiday flier. For this technology lesson, students create a holiday flier. Students choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash drive or...
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

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.