Lesson Plan
Curated OER

Biodiversity on Ninepipe Reservoir

For Teachers 6th
Sixth graders complete a unit about the biodiversity at the Ninepipe National Wildlife Refuge. They view a video, conduct an interview with a tribal wildlife biologist and a federal wildlife biologist and compare the two, collect and...
Lesson Plan
Curated OER

Metric Conversion

For Teachers 5th
Fifth graders access prior knowledge to complete a do now using metric conversion. In this metric conversion lesson, 5th graders will respond to problems and analyze for a possible mnemonic device.
Lesson Plan
Curated OER

Stock and Inventory

For Teachers 5th - 8th
Young scholars create databases. In this spreadsheet lesson, students take stock of their toys and create databases. Young scholars consider good business practices as they listen to guest speaker discuss how to control inventory.
Lesson Plan
Curated OER

The Game of Business

For Teachers 9th - 12th
Students practice the economic concepts of scarcity and opportunity cost. They imagine creating their own businesses and brainstorm what they need to know in order to determine when the business is profitable.
Lesson Plan
Curated OER

Marine Protected Areas

For Teachers 11th - 12th
Learners design a research project about a Marine Protected Area they chose. In this marine biology lesson, students gather fish count and catch data then graph them. They create an information poster about their findings.
Lesson Plan
Curated OER

Gathering, Recording, and Presenting Data

For Teachers 6th
Sixth graders use the local newspaper to find and discuss examples of uses of statistics and the ways in which the information is presented. They create and represent their own set of data showing how students get to school each day.
Lesson Plan
Curated OER

Poe ... in the Real World?

For Teachers 11th
Eleventh graders work in groups to choose a project/presentation from a list of approved activities to develop. They select and use appropriate software for organizing and refining their product. Groups produce a short...
Lesson Plan
Curated OER

Compare 2-D Shapes

For Teachers 2nd
Second graders explore and analyze plane shapes. In this plane shapes lesson, 2nd graders evaluate shape attributes to classify shapes correctly. Students work in groups to create different shapes.
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

Unit 2: Lesson 7

For Teachers 6th - 8th
Middle schoolers are introduced to spreadsheets. They conduct a survey of television viewing time of different shows based on different age categories. Students work in small groups. They collect, data and interpret the data from a survey.
Lesson Plan
Curated OER

Virtual Vacation

For Teachers 6th - 8th
Students select a foreign city, research the city using the Internet, and plan an eleven-day vacation to that city. This lesson plan is ideal for a social studies classroom and includes ideas for using iMovie, Excel, and MS Works or...
Lesson Plan
Curated OER

Marsville

For Teachers 6th
Sixth graders use the Internet and other media to locate and collect information about Mars and build a database of information. They listen and participate in demonstrations presented by Eglin Air Force Base professionals. They then are...
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

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

Graphing Galore!

For Teachers K
Students practice sorting and counting different objects. Using this information, they create graphs on a worksheet given to them. They describe and analyze the results and discuss them as a class to end the lesson. They also complete...
Lesson Plan
Curated OER

Weather Or Not

For Teachers 3rd - 5th
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Lesson Plan
Curated OER

What Can Scatterplots Tell Us?

For Teachers 8th
Eighth graders use data from surveys conducted with parents, peers and themselves to create computer-generated scatterplots. They make inferences from their scatterplots.
Lesson Plan
Curated OER

Cars: Math, Research, Economics, Loans

For Teachers 11th - Higher Ed
Students investigate what the purchasing of a car entails. They explore car criteria and financing options.
Lesson Plan
Curated OER

Pulse Rates

For Teachers 3rd - 6th
Students answer the question, "How will the intensity of exercise effect your heart rate?", using physical workouts and AppleWorks, or similar spreadsheet program. This lesson can conclude with the creation of a graph of data collected.
Lesson Plan
Curated OER

Asthma "Outbreak" Exercise

For Teachers 8th - 12th
Students investigate numerical data on a possible asthma epidemic. Using statistical information, students graph and figure ratios of the epidemic. They evaluate the mortality rate from severe smog in the 1950's in London.
Lesson Plan
Curated OER

Pendulum Motion Experiments

For Teachers 9th - 12th
Students experiment with simple pendulums to determine the validity of an equation for all angles. Students discover the usefulnes and limitations of approximations in science. Using spreadhseets and a java applet, students observe the...
Lesson Plan
Curated OER

Artic/Antarctic Animals

For Teachers 4th
Fourth graders create an organized report which includes specific information about their assigned animal. They use the Alpha Smarts program and Microsoft Word to create their reports.
Lesson Plan
Curated OER

Fly Away With Averages

For Teachers 3rd - 5th
Learners study mean, median, and mode. They construct paper airplanes and test them to see how far they fly. They measure the distance and then find the averages of their throws. They use spreadsheet software to record the data in a...