Lesson Plan
Curated OER

Personal / Group Magazine

For Teachers 6th
Sixth graders complete the magazine template in the Macmillan "Writer's Journal" available through the basic skills department using word processing, spreadsheet, graphic, and electronic resource (i.e.-Internet) skills
Lesson Plan
Curated OER

Body Proportion

For Teachers 4th
Fourth graders measure the height and arm span of various classmates. They use a spreadsheet to design a graph that shows the class measurements from tallest to shortest in metric and standard systems.
Lesson Plan
Curated OER

Supermarket Smarts

For Teachers 9th - 12th
Students examine how a consumer can make informed choices. They visit stores with a prepared shopping list, record the prices on a spreadsheet, create graphs, and create a Powerpoint presentation comparing the total cost of stores and a...
Lesson Plan
Curated OER

Education for Global Peace

For Teachers 7th - 8th
Students survey the class and graph the results. In this graphing and data collection lesson, students conduct a survey to see where their shirts were produced. Individuals use software to graph the results and create a written...
Lesson Plan
Curated OER

Eyes on the Estuaries

For Teachers 9th - 12th
Students study estuaries and compare several ones in the U.S. In this estuary instructional activity students interpret data and compare the distribution of different species. 
Lesson Plan
Curated OER

Predicting Monthly Precipitation

For Teachers 8th - 12th
Students should log onto, and collect data from, a specific site on the Internet. They average and compare the data using the Excel spreadsheet program, make predictions from their data, and determine the percent error of their predictions.
Lesson Plan
Curated OER

Paper Tower Challenge

For Teachers 2nd - 5th
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Young scholars collect and record the heights of other towers and use that data to create a spreadsheet.
Lesson Plan
Curated OER

Around and Around

For Teachers 6th - 8th
Students create a spreadsheet to record information about circular objects. They measure and record information from a variety of objects. Students calculate the ratio of the circumference to the diameter of each object. They find the...
Lesson Plan
Curated OER

Comparing Weather Conditions

For Teachers 4th - 5th
Young scholars conduct research on temperature, wind speed and weather conditions from a variety of areas. They organize their findings on worksheets and spreadsheets and discuss various examples of databases.
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

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Who's Going to the Convention?

For Teachers 9th - 12th
Students practice planning budgets as they create a budget for ten employees of a company to attend a professional convention. They use the Internet, and spreadsheet software to complete their assignment.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Students study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Students chart their results in an Excel document...
Lesson Plan
Curated OER

How to Make a Chili Dog

For Teachers 3rd - 6th
Students practice sequencing skills. They discuss what makes a hotdog and the proper sequence for performing the task. Using computer technology, students create a multimedia show that deomonstrates the basic directions for making a...
Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Young scholars create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family...
Lesson Plan
Curated OER

A RealSim Surface Look at Descriptive Statistics

For Teachers 5th - 12th
Learners explore the concepts of mean and variance. They observe properties of materials to their basic atomic or molecular structure. Students use spreadsheet software to record, tabulate and analyze collected information.
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

Investigating Properties of Water: Temperature

For Teachers 6th - 8th
Investigate how temperature affects the density of water and stratification that occurs in bodies of water when temperatures vary. Water of differing temperatures is given different colors to see the layers that form. The lesson is meant...
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, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
National Council of Teachers of Mathematics

National Debt and Wars

For Teachers 9th - 12th Standards
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Lesson Plan
Kenan Fellows

Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization

For Teachers 9th - 12th Standards
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
Lesson Plan
Curated OER

An Introduction to Functions

For Teachers 9th - 11th
Students investigate the growth and decay of an exponential function. In this algebra activity, students apply properties of exponent solve problems. They identify any patterns they see in the graphs.
Lesson Plan
Curated OER

Teaching About the Properties of Water

For Teachers 9th - 12th
Students use video, Internet research, graphs and tables, worksheets and hands-on experiments to investigate the properties of water in a lake environment. They work under direction or through an inquiry process.
Lesson Plan
Curated OER

Break Even Analysis and Budgeting

For Teachers 11th - Higher Ed
Young scholars analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.