Curated OER
You Be The Judge: Olympics, Winter Sports, Figure Skating, Math, Statistics, Technology
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.
Curated OER
Bones and Math
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...
Curated OER
Space Presents Problems
Students 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.
Curated OER
Strength Building
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.
Curated OER
Destination Mars!
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...
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Learning and Population Information - Where I Live
Students 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. Students chart their results in an Excel document...
Curated OER
2D Kinematics w/ String Racers
Students calculate the speed of string racers. In this physics lesson plan, students measure the time in several trials and get the average. They graph their results using a spreadsheet.
Curated OER
Understanding Food Labels
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...
Curated OER
Body Length Experiment
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.
Curated OER
Composting
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Curated OER
Chart/Graph
Students create a class survey, place the data in a spreadsheet and graph the information.
Curated OER
Reaching the Solar System
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.
Curated OER
Who's Going to the Convention?
Students practice planning budgets as they create a budget for ten employees of a company to attend a professional convention. They use the Internet, and spreadsheet software to complete their assignment.
Curated OER
Oceanography-Related Careers: To Be or Not to Be. . .
High schoolers 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...
Curated OER
Introduction to Evaluating
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...
Curated OER
Peopling the New World -- An Archaeological Exercise in Excel
Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...
Curated OER
Power In The Wind
Students 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...
Curated OER
Pulse Rates
Students answer the question, "How will the intensity of exercise effect your heart rate?", using physical workouts and AppleWorks, or similar spreadsheet program. This instructional activity can conclude with the creation of a graph of...
Curated OER
The Price of War
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.
Curated OER
Graphing Pockets
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Curated OER
Fraction Strips on Excel
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...
Curated OER
"What's Your Job Worth"
Students locate salary information, compare the cost of living in various area, and create a salary chart.
Curated OER
Code Crackers
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.