+
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Students create graphs using collected data. In this algebra lesson, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
+
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
+
Lesson Plan
Curated OER

Are You My Little Peanut?

For Teachers 4th
Fourth graders explore the mass and length of peanuts by pretending to parent a peanut. In this mode, median and range lesson students graph their measurements and then use them to find the mode, median and range. Students discuss peanut...
+
Lesson Plan
Curated OER

The Candy Color Caper

For Teachers 4th - 8th
Students explore the concept of probability. They calculate the probability of an event happening and graph their results. Students determine the probability of winning a sweepstakes. They construct a bar graph to represent all the...
+
Lesson Plan
Curated OER

Learning Inference

For Teachers 6th - 8th
Making inferences can be a tricky proposition for middle schoolers. In the activity presented here, pupils practice the skill of drawing a conclusion and making a judgment - which are what making an inference is all about! There are five...
+
Lesson Plan
National Research Center for Career and Technical Education

Depreciation (Double Declining)

For Teachers 9th - 12th
Have you ever been told that your new car begins to lose its value as soon as you drive it off the lot? Aspiring accountants take on the concepts of depreciation and book value through an easy-to-deliver career and technology lesson. The...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
+
Lesson Plan
Curated OER

Divisibility Rules

For Teachers 8th
Eighth graders explore Excel and discover rules of divisibility for the numbers 2, 3, 4, 5, 6, 9, and 10; students examine multiples of 2 using pencil/ paper, then create a chart in Excel that will allow them to more easily see patterns...
+
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
+
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
+
Lesson Plan
Curated OER

Virtual Field Trip: Lodging and Meals

For Teachers 5th - 7th
Students calculate the costs for lodging and meals for a virtual field trip. They calculate the number of nights lodging needed for road and city travel and the number of meals needed, the costs for each, and input the data using...
+
Lesson Plan
Curated OER

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
+
Lesson Plan
Curated OER

Great Online Art Sites

For Teachers K - 8th
Students complete an online study of art websites. In this art and technology lesson, students explore the links and try the activities to learn about art online.
+
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
+
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
+
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology lesson plan, students investigate the water quality in their community and compare their findings to the water quality in other geographic...
+
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

The Survey Says

For Teachers 8th - 12th
Students 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, the...
+
Lesson Plan
Curated OER

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
+
Lesson Plan
Curated OER

An Introduction to Public Key Cryptography

For Teachers 8th - 10th
Students secure information online using cryptography. In this algebra lesson, students use RSA technology to encrypt information on the internet. They use modular reduction of natural numbers to understand prime number theory.
+
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
+
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Students explore spreadsheet software.  In this personal finance and computer technology lesson plan, students develop a vacation spreadsheet on the computer.  Students represent hotel, food, transportation, and entertainment...
+
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
+
Lesson Plan
Curated OER

Law of Large Numbers - Hospital

For Teachers 7th - 9th
Young scholars explore concepts of probability and independent events. They develop a formula for deviation percentage.