Lesson Plan
Curated OER

Make Your Health Count

For Teachers 4th - 6th
Students write down the meals they have eaten in the past few days and then research the calorie and fat content of at least 5 of the food items. They create a poster with the information they found and then put that information into a...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Young scholars create arrays using Microsoft Excel. For this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Lesson Plan
Curated OER

Political Issues Survey

For Teachers 5th
Fifth graders develop and conduct a survey regarding issues in a current political campaign. They distribute and collect the surveys, input the data using a spreadsheet program, and compare/contrast the recorded results.
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Moving On Up!

For Teachers 7th - 9th
Students complete a game-like simulation to determine a career and salary. In groups, they collect information and decide what is the "best" city in which to live. They create a monthly budget for their "best" city based on salary from...
Lesson Plan
Curated OER

The Effects of Light Intensity and Wavelength on the Rate of Photosynthesis

For Teachers 9th - 12th
Learners use an on line website to simulate the effects of light intensity and wavelength on photosynthesis. In this photosynthesis lesson plan, students determine how wavelength of light and intensity of light affect the rate at which...
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 10th - 12th Standards
Learners find common ratios of geometric sequences on a spreadsheet. Using this data, they create scatter plots of the sequences to determine how each curve is related to the value of the common ratio. They will consider whether series...
Lesson Plan
Curated OER

What's Our Department Budget?

For Teachers 9th - 12th
Analyze the influence of culture, media, technology, and other factors on health and examine a hospital budget. Learners will create a budget for a hospital taking in account factors such as staff and departmental needs and necessary...
Lesson Plan
Curated OER

Data Analysis: Infiltration Rate and Composition of Concrete

For Teachers 9th - 11th
Students collect and graph data. In this statistics lesson, students analyze data using a spreadsheet program. They display their data effectively and analyze it.
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

Propaganda & Persuasive Techniques: Do You Buy It?

For Teachers 5th
Fifth graders investigate the basic persuasive techniques employed in advertising. They identify three examples of propaganda/persuasive techniques, complete an observation chart, take an advertising quiz, complete a spreadsheet that...
Lesson Plan
Curated OER

Math Lesson: What Do You Want to Know? - Country Statistics

For Teachers 9th - 12th
High schoolers are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing...
Lesson Plan
Curated OER

Understanding Presidential History

For Teachers 4th - 5th
Students research to find the qualifications necessary to be President of the U.S. In this presidential qualification lesson, students research their family roots to see if they could qualify to be President. Students create a graph to...
Lesson Plan
Curated OER

Arctic/Antarctic Animals

For Teachers 4th
Fourth graders explore animals of the Arctic and Antarctic and then create a report. They become aware of the great diversity among animals.
Lesson Plan
Curated OER

Remembering Our Veterans

For Teachers 8th
Eighth graders research a variety of military statistics while using the theme of Remebering Our Veterans. They use data management to plan and create a PowerPoint presentation with their findings. They incorporate different types of...
Lesson Plan
Curated OER

Let's Measure

For Teachers 2nd - 5th
Students learn how to measure length using inch units.  In this measurement activity, students use two different units of measure to measure the length of a Leopard Shark and then use pattern blocks to measure its length. ...
Lesson Plan
Curated OER

Running a Business

For Teachers 6th - 8th
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

How to Buy a Computer

For Teachers 9th - 12th
High schoolers investigate the purchase of a specific computer hardware with specific components without going over a budget. The use of computer catalogues, tables, and spreadsheets support the search.
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.