Lesson Plan
Curated OER

Backyard Birds: Who's Who Out There?

For Teachers 3rd - 4th
Young scholars practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects...
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Why Would I Owe My Soul to the Company Store?

For Teachers 6th
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics instructional activity, 6th graders determine what a miner's income was minus his expenses...
Lesson Plan
Curated OER

Data Analysis: Infiltration Rate and Composition of Concrete

For Teachers 9th - 11th
Students collect and graph data. In this statistics instructional activity, students analyze data using a spreadsheet program. They display their data effectively and analyze it.
Lesson Plan
Curated OER

Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School

For Teachers 4th - 9th
Students study practical data analysis within the constraints of the scientific method.  In this data lesson students collect and enter data into a computer spreadsheet then create graphs.
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 10th - 12th Standards
Learners find common ratios of geometric sequences on a spreadsheet. Using this data, they create scatter plots of the sequences to determine how each curve is related to the value of the common ratio. They will consider whether series...
Lesson Plan
Curated OER

The Effects of Light Intensity and Wavelength on the Rate of Photosynthesis

For Teachers 9th - 12th
Students use an on line website to simulate the effects of light intensity and wavelength on photosynthesis. In this photosynthesis lesson plan, students determine how wavelength of light and intensity of light affect the rate at which...
Worksheet
Curated OER

A Problem in Satellite Synchrony

For Students 8th - 10th
In this satellite synchrony worksheet, students use a spreadsheet or Least Common Multiples to solve 4 problems related to the satellite orbits, orbital periods and their synchronicity. Students determine when the satellites launched in...
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

The Statistics of Shoes

For Teachers 7th - 10th
Young scholars open a blank spreadsheet and format it for a class survey about the number of shoes owned by the men and women in the class. They enter the data before finding the mean, median, mode, quartiles, variance, and the standard...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Lesson Plan
Curated OER

African Safari

For Teachers 5th - 7th
Students create an Excel spreadsheet that show a budget for a trip to Africa to see wildlife. In small groups, they complete internet research to determine the countries and sites to visit then calculate the costs involved for the trip....
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Lesson Plan
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Lesson Plan
Curated OER

Area, Surface Area and Volume of 3-D Shapes

For Teachers 7th - 10th
Math whizzes examine the relationship between area and volume and the relationship between a 3-D shape and its surface area. Following discussion and practice, pupils participate in a project in which they design packaging for a new...
Lesson Plan
Curated OER

Doughnuts to $ Database

For Teachers 5th
Fifth graders are selling Krispy Kreme doughnuts to raise money for their overnight camping trip. They use a database to set to keep track of and record additions to their daily sales. Students then follow the step by step directions to...
Lesson Plan
Curated OER

Bungee Jump Lab

For Teachers 10th - 12th
Student apply linear relationships to the real world. They use Ken and Barbie dolls and experiment to find the line of best fit. They collect data, analyze data, and make predictions from it. The young scholars also use Microsoft Power...
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
Curated OER

Home Sales Records

For Teachers 9th - 12th Standards
Teach your class how to calculate monthly payments on a home mortgage. In this percent activity, students calculate the monthly payment on a home mortgage, and compare different lengths of time and the interest rates for national median...
Lesson Plan
Curated OER

The Egg Drop

For Teachers 9th - 12th
Students design and create a container that allows a raw egg to drop from the second floor of a building without breaking. They develop and compute an invoice for project expenses using spreadsheet software. Students role-play a proposal...

Other popular searches