Lesson Plan
Curated OER

Analyzing Discrete and Continuous Data in a Spreadsheet

For Teachers 6th - 12th Standards
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Activity
1
1
Agile Mind

Isabella’s Credit Card

For Teachers 8th - 12th Standards
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Lesson Plan
Bowland

Speed Cameras

For Teachers 6th - 9th
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Lesson Plan
Curated OER

Lesson Plan Outline for Rainbow Science

For Students 7th - 12th Standards
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Lesson Plan
NOAA

Biological Oceanographic Investigations – Signals from the Deep

For Teachers 9th - 12th Standards
The Deepwater Horizon oil spill directly impacted an area of the Gulf of Mexico the size of Oklahoma. A marine biology lesson looks at the impact of an oil spill on the deeper parts of the ocean. Scholars download actual data collected...
Unit Plan
Radford University

Fibonacci is All Around

For Teachers 9th - 12th Standards
One ratio to rule them all. Young mathematicians investigate the Fibonacci sequence and the Golden Ratio. To begin the first lesson, they use a spreadsheet to see how the Fibonacci sequence gives the Golden Ratio. The second lesson...
Unit Plan
Radford University

Real World Data

For Teachers 9th - 12th Standards
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
Unit Plan
Radford University

Being Green – Minimizing the Surface Area of a Soda Can

For Teachers 9th - 12th Standards
Save the world by designing a new soda can! Learners first measure the dimensions of a typical soda can and calculate its surface area and volume. They then use spreadsheet software to minimize the surface area for the volume, thus...
Lesson Plan
Curated OER

Zebra Mussel Population Simulation

For Teachers 9th - 12th
Young scholars are taught how to format and enter data into an Excel spreadsheet. They make a graph, and interpret graphed data. Students discuss the possible impacts of zebra mussels on the Hudson river. They graph zebra mussel data.
Lesson Plan
Curated OER

Water Chestnut Graphing Activity

For Teachers 9th - 12th
Pupils are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Pupils report and...
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

Society, Cyberspace and the Future

For Teachers 6th - 7th
Students locate information on the rapid growth of world population and consumption needs through the use of Internet, Cd-ROMs, laser dics and other media. They use spreadsheet to present data gathered on world population growth between...
Lesson Plan
Space Awareness

Navigation in the Ancient Mediterranean and Beyond

For Teachers 9th - 11th Standards
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
Activity
Howard Hughes Medical Institute

Measuring Biodiversity in Gorongosa

For Teachers 9th - 12th
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Lesson Plan
Texas Education Agency (TEA)

Advanced Technical Skills in Business

For Teachers 11th - 12th Standards
Scholars put their technical skills to the test as they practice writing a business letter, creating charts and spreadsheets, and designing a flyer. Additionally, pupils create a PowerPoint presentation about a professional topic of...
Lesson Plan
Curated OER

BRIDGING THE GENERATION GAP

For Teachers 9th - 12th
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Lesson Plan
Alabama Learning Exchange

Who Sank the Boat?

For Teachers 5th
Fifth graders experiment with student-made aluminum boats to test for buoyancy. They design a boat and determine how many marbles it takes to sink it while recording their data in a spreadsheet. They design a graph using the data and...
Lesson Plan
1
1
Chicago Botanic Garden

Micro-GEEBITT Climate Activity

For Teachers 5th - 6th Standards
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Lesson Plan
Curated OER

Thanksgiving Feast

For Teachers 7th - 9th
Use the Tool Factory Workshop to have your class create a list of people to invite to their Thanksgiving Feast.They will take pictures related to the fall season and create invitations using Tool Factory Database. Students make a grocery...
Lesson Plan
Curated OER

What's Your Line?

For Teachers 5th
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
Assessment
Houghton Mifflin Harcourt

Simple and Compound Interest

For Students 7th - 12th Standards
Your learners will get lots of practice calculating simple and compound interest by the end of this lesson. Simple explanations and examples lead learners through the concepts and steps of calculating simple and compound interest...

Other popular searches