+
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
High schoolers 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...
+
Lesson Plan
Curated OER

Caching in Pine's Treasures

For Teachers 6th - 12th
Students compile image information about the Junior High School using a digital camera. They survey the area making observations and recording them with the help of portable technology and transferring the data to a spreadsheet and...
+
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

Save Our Forests

For Teachers 5th
Fifth graders discuss the forest products industry and its affects upon their communities. They inventory the wood and paper products they consume and determine how it translates into the number of trees cut. Using a spreadsheet, they...
+
Lesson Plan
Curated OER

Have Fun With Technical Report Writing

For Teachers 9th - 12th
High schoolers use Clarisworks Word Processing and Spreadsheet, Quick-Take Camera and Software, and produce a publishable technical paper.
+
Lesson Plan
Curated OER

Checking County Numbers

For Teachers 4th - 8th
Students use their county's information page to gather information about their community. Using the information, they create graphs from the tables provided and interpret the data. They write a paragraph showing their interpretation of...
+
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
+
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
+
Lesson Plan
Curated OER

Which Color Will You Pick?

For Teachers 5th - 6th
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
+
Lesson Plan
Curated OER

Stock Reports

For Teachers 6th - Higher Ed
Students spend $10,000 by picking up to 3 stocks in which to invest. They monitor their progress for three weeks, and chart results in a spreadsheet template.
+
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
+
Lesson Plan
Curated OER

Thank You... Thomas Edison!

For Teachers 2nd - 3rd
Learners investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.
+
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Students spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.
+
Lesson Plan
Curated OER

Our Animal Friends

For Teachers 4th - 8th
Students use the internet to find information pertaining to the benefits of pets. They list their results on a database. They find and record data on the percent of households that own pets as well as the top six species of pets. Once...
+
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

Buying My First Car

For Teachers 5th - 12th
Students pretend they are about to buy their first new car. They must do all the calculations necessary to estimate the cost of purchasing the car. They see that the math they learn in school really does have real-life applications.
+
Lesson Plan
Curated OER

Learning About Graphics

For Teachers 4th - 6th
Students practice using and filling in a spreadsheet. They also create graphs and charts that coorespond with the data. This is a unit comprised of four lesson plans.
+
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

Small Business

For Teachers 6th - 12th
Students simulate owning and running a small business by playing Lemonade Stands. They play the game for three weeks, then work with a partner to produce a Power Point presentation which would be given to a Board of Directors showing...
+
Lesson Plan
Curated OER

Amphibian Spawns

For Teachers K
Students observe tadpoles as they gradually change into adults.  In this amphibian biology lesson, students watch tadpoles in a tank in the classroom, keep a daily record of what they observe, and chart the growth development of the...
+
Lesson Plan
Curated OER

Budget Making

For Teachers 9th - 11th
Students develop a budget for spending and saving. In this economics lesson, students create a budget based on personal, family and government income. They discuss jobs at home and allowances. They discuss how they manage their money...
+
Lesson Plan
Curated OER

How Do You Get to School?

For Teachers 3rd
Third graders talk about all the various ways they get to school. They make a list of all the bus numbers that the students use. They also list all the other methods of transportation used and solidify a hypothesis.
+
Lesson Plan
Curated OER

Using Fractions to Represent M&M Colors

For Teachers 9th - 11th
Young scholars investigate the concept of fraction and tangible application. In this algebra lesson, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the numerator and...
+
Lesson Plan
Curated OER

Catholic Schools in the Community

For Teachers 3rd - 4th
Students are provided with a multimedia Power Point presentation that explains the educational opportunities that are available at the St. Mary Catholic School. They are presented with all facts along with the community as a whole and...