Lesson Plan
Curated OER

TV Viewing

For Teachers 7th - 8th
Students test a hypothesis to see if there is a direct correlation between number of hours of TV viewing and academic grade. They collect and compile data to enter on a spreadsheet and create a word processing document supporting their...
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Learners use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
Lesson Plan
Curated OER

Measuring Mania

For Teachers 6th - 8th
Students rotate through stations in the classroom, completing different types of measurements. These measurements are placed into a spreadsheet, and a scatter plot is generated. They type an explanation of their results in correlation...
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

Toy Planet

For Teachers 4th - 6th
Students design a toy store, supply it with merchandise (on paper) and create advertisements. They also manage the store's debits and credits by using a spreadsheet. They consider how to promote the sale of their merchandise.
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

Spyglass Transform

For Teachers 6th - 11th
Students transfer information previously saved in a spreadsheet to Spyglass Transform. They visualize the data and explain what it means
Lesson Plan
Curated OER

Our Favorite Pet

For Teachers K
Students each have a turn, telling the class his or her favorite pet. The choices are cat, dog, fish or bird. Using the computer, the information from the tally be recorded on a spreadsheet and bar graph.
Lesson Plan
Curated OER

Newspaper

For Teachers 8th
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Strength Building

For Teachers 5th
Fifth graders go to each of the 3 stations testing their maximum strength and then make a spreadsheet and how to work with excel. Students create and finish their spread sheet on how they did on day 1.
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Middle schoolers use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Understanding Food Labels

For Teachers 3rd - 5th
Students determine the number of calories, serving size, and vitamins and minerals in different food products and use this information to create a formula determining the number of calories per serving size and the daily percentages of...
Lesson Plan
Curated OER

Body Length Experiment

For Teachers 3rd - 5th
Students measure the lengths of their bodies and various body parts to determine the relationship (or lack of one) between body part length and the length of the entire body. A spreadsheet program is suggested for data collection.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Learners study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Learners chart their results in an Excel document...
Lesson Plan
Curated OER

2D Kinematics w/ String Racers

For Teachers 11th - 12th
Students calculate the speed of string racers. In this physics lesson, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Lesson Plan
Curated OER

Destination Mars!

For Teachers 5th
Fifth graders view Mysteries of Earth & Mars Video on DVD and record thoughts in their online journal. They record data in a spreadsheet about each planet then form a theory of the best time to launch a space craft from Earth to land...
Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.
Lesson Plan
Curated OER

Reaching the Solar System

For Teachers 3rd - 5th
Students sing the Rap of the Solar System, view pictures of the planets, and calculate their weights and ages on all the planets and the sun. They create a presentation comparing themselves with a planet or object in the solar system.
Lesson Plan
Curated OER

Oceanography-Related Careers: To Be or Not to Be. . .

For Teachers 9th - 12th
Young scholars investigate various careers in the field of oceanography. They conduct Internet research, record data on a spreadsheet, write a justification to explain why someone should accept a position found online, and write a...
Lesson Plan
Curated OER

Introduction to Evaluating

For Teachers 7th
Seventh graders are introduced to how to evaluate an electronic product. In groups, they grade the product on quality, materials and aesthetics. Using this information, they create a table of results along with a pictogram and...
Lesson Plan
Curated OER

Power In The Wind

For Teachers 6th - 8th
Learners experiment designing graphs of selected readings from the Nebraska sites from the Power in the Wind study. They choose whether or not to put their data in a spreadsheet program to make a computer-generated graph or to complete...
Lesson Plan
Curated OER

"What's Your Job Worth"

For Teachers 11th - 12th
Young scholars locate salary information, compare the cost of living in various area, and create a salary chart.
Lesson Plan
Curated OER

The Price of War

For Teachers 5th
Fifth graders, in groups, research major battles fought during the Civil War and complete an activity sheet. They choose one particular battle and create a timeline and graph using the statistics researched.