Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
Unit Plan
Curated OER

Deciphering Word Problems in Order to Write Equations

For Teachers 5th - 8th Standards
Help young mathematicians crack the code of word problems with this three-lesson series on problem solving. Walking students step-by-step through the process of identifying key information, creating algebraic equations, and finally...
Lesson Plan
Curated OER

Swinging Pendulum

For Teachers 6th - 8th
Learners engage in an activity which demonstrates how potential energy (PE) can be converted to kinetic energy (KE) and back again. Given a pendulum height, students calculate and predict how fast the pendulum will swing by understanding...
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Ancient Peoples of the Middle East

For Teachers Pre-K - 6th
This is an excellent multidisciplinary lesson designed by Scientific American. It provides three creative activities--designing a garden, studying hieroglyphics, and writing poetry--relevant to the ancient peoples of the Middle East....
Lesson Plan
Curated OER

The Survey Says

For Teachers 8th - 12th
Young scholars experience the development of statistical data. In groups, they construct a survey questionnaire for a target audience. Students produce the questionnaire, distribute it, collect it, and tabulate the data. Using EXCEL,...
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Lesson Plan
Curated OER

Law of Large Numbers - Hospital

For Teachers 7th - 9th
Students explore concepts of probability and independent events. They develop a formula for deviation percentage.
Lesson Plan
Curated OER

A Picture is Worth a Thousand Words

For Teachers 3rd - 6th
Pupils create various types of graphs. They go to suggested websites to collect data and create graphs to organize the data. Then they answer questions according to their graph.
Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Middle schoolers explore the concept of cell phone plans. In this cell phone plan lesson, students research the cost of cell phones. Middle schoolers compare various cell phone plans and decide on which phone plan is best for them.
Lesson Plan
Curated OER

Blast the Fats

For Teachers 3rd - 4th
Students examine the fats found in foods. In this nutrition lesson, students identify the types and amounts of fats found in foods as they research food labels and the Internet. Students classify the fats and record their data.
Lesson Plan
Curated OER

FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.

For Teachers 9th - 10th
Students learn that maintaining financial security takes a good math understanding. In this instructional activity, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house,...
Lesson Plan
Curated OER

Data, Data, Everywhere... and What Am I To Think?

For Teachers 9th - 10th
Students demonstrate good random sampling techniques for data collection, select and develop graphic presentations of data and analyze the data to solve a problem presented.
Lesson Plan
Curated OER

CSI Rhino

For Teachers 9th - 12th
Students study the rhinoceros and how the species has survived for so long.  In this rhino lesson students create graphs and research what is being done to protect the rhino.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
Curated OER

Linear and Exponential Growth

For Teachers 8th - 11th
Young scholars explore the concept of linear and exponential growth. In this linear and exponential growth lesson, students collect data about China's population. Young scholars model the data to determine if it is linear or exponential.
Lesson Plan
Curated OER

Halloween Graphitti

For Teachers 5th - 7th
Students complete multi-curricular activities in a Halloween themed instructional activity. In this Halloween instructional activity, students examine newspaper ads to find prices of pumpkins and use them to complete a stem and leaf...
Lesson Plan
Curated OER

Taxes: Where Does Your Money Go?

For Teachers 9th - 12th
Learners explore the concept of taxes. In this tax lesson, students investigate types of taxes and deductions taken out of a paycheck before they see it. Learners calculate the tax on a given dollar amount. Students discuss 401(k)s...
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.