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...
Lesson Plan
Curated OER

Using Database to Organize Information

For Teachers 5th
Fifth graders collect information about an assigned topic. They organize data by using a database.
Lesson Plan
Curated OER

Native American Unit: Using One Computer to Record Data

For Teachers Higher Ed
Students explore methods to manage a classroom with one computer. Prospective teachers observe a video of students collecting information on Native American tribes. They discuss the use of white boards and electronically recording...
Lesson Plan
Curated OER

States with Attitude, Latitude and Longitude Dude

For Teachers 6th
Sixth graders identify states whose boundaries are formed by lines of latitude and longitude or natural borders such as rivers. They trace a map of the U.S., and fill in borders, rivers and lines of latitude and longitude.
Lesson Plan
Curated OER

The Golden Door: U.S. Immigration Through Ellis Island

For Teachers 5th - 6th
Students complete a unit covering various aspects of immigration to the United States through Ellis Island. They plan a fictional trip to America, entering at Ellis Island. and actually visit Ellis Island and the Statue of Liberty.
Lesson Plan
Curated OER

Traveling Across America

For Teachers 8th - 12th
Students plan a trip to a state capital of their choice with a budget of $2,000. The budgets include site seeing, lodging, food and all necessary expenses. Students keep a daily journal and maintain their budget.
Lesson Plan
Curated OER

Classifying Organisms within Kingdoms

For Teachers 9th - 12th
Students examine animal kingdom classifications. They discuss how animals are placed into kingdom classifications and compare similarities and differences of animals within a kingdom.
Lesson Plan
Curated OER

Book Report Database and Author E-mail Project

For Teachers 2nd - 3rd
Students read a number of books by a given author and input information into a database. They e-mail information about their favorite author to other students. They focus on story elements and ask questions or make suggestions for future...
Lesson Plan
Curated OER

Saving An Endangered Species

For Teachers 2nd
Second graders work in groups in order to look at specific internet sites for animal adoption and sponsorship. They select an endangered species, determine needed funds, develop, advertise, and carry out a fund-raising plan.
Lesson Plan
Curated OER

Advertising

For Teachers 6th - 8th
Learners listen to a guest speaker about the different types of advertising. Using research materials, they discover the laws about copyrighting material. They visit foreign websites to view their advertising and discuss how it is...
Lesson Plan
Curated OER

Checking County Numbers

For Teachers 4th - 8th
Learners 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

You Be The Judge: Olympics, Winter Sports, Figure Skating, Math, Statistics, Technology

For Teachers 6th - 8th
Middle schoolers design a score sheet for use when watching a figure skating performance. They use spreadsheet software and research information obtained on the Internet to create their score sheets.
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

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Lesson Plan
Curated OER

Highs and Lows

For Teachers 3rd - 4th
Students use email to chart weather patterns and then graph their findings. In this weather patterns lesson, students chart their weather for a week at the school. Students then use email to find temperatures at a variety of locations....