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

Propaganda & Persuasive Techniques: Do You Buy It?

For Teachers 5th
Fifth graders investigate the basic persuasive techniques employed in advertising. They identify three examples of propaganda/persuasive techniques, complete an observation chart, take an advertising quiz, complete a spreadsheet that...
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
Curated OER

Healthy School Food

For Teachers 5th - 8th
Young scholars design a balanced school menu or a healthy snack vending machine. Students create a colorful wall display. Young scholars demonstrate about food groups on a spreadsheet. Students answer a survey on what foods to eat and why.
Lesson Plan
Curated OER

Teenage Stress

For Teachers 7th - 11th
Young scholars fill out a stress questionnaire. Students assess their stress levels over the last 12 months. Young scholars explain how it occurs and ways to dealing with it on a spreadsheet.
Lesson Plan
Curated OER

Coping With Exam Stress

For Teachers 6th - 12th
Students revise unique ways to study on a spreadsheet to display. Students share useful study skills with each other. Students solve problems for imaginary students. Students role play examples.
Lesson Plan
Curated OER

Giant Mystery

For Teachers 3rd
Third graders determine the relationship between hand size and body size using centimeters as the unit of measure, They use the relationship to find the size of a hypothetical giant. They graph the measurements using a spreadsheet program.
Lesson Plan
Curated OER

Is Global Warming Happening?

For Teachers 6th - 8th
Students investigate the probability of global warming and the effects of global warming on the environment. They conduct Internet research and collect data, transfer the data onto an Excel spreadsheet, and create a presentation that...
Lesson Plan
Curated OER

Quick Concept Demonstrations

For Teachers 6th - 8th
Students research the nervous system. Demonstrations on how to pick up keyed information in text is shown daily and weekly. Reviewed for content is Nerve Impulse, Polarization and Depolarization and perception. A spreadsheet will graph...
Lesson Plan
Curated OER

Code Crackers Math Game

For Teachers 6th - 8th
Students, through this math game, are provided with opportunities to work with math operations and simple algebraic equations. They create a spreadsheet-based "rule machine."
Lesson Plan
Curated OER

Author Study (Chris Van Allsburg)

For Teachers 3rd
Third graders study a list of books written and illustrated by the author. They examine facts about the author's life. They take a survey of Allsburg's books read by the students using the Excel spreadsheet.
Lesson Plan
Curated OER

Experiment on Measuring Reaction Rates

For Teachers 9th - 12th
High schoolers investigate the rate of a chemical reaction. In this rate of reactions lesson plan, students use an electronic balance to measure the change in mass of a chemical reaction between hydrochloric acid and calcium carbonate....

Other popular searches