Lesson Plan
Curated OER

Calculating Orbital Speeds

For Teachers 11th - 12th
Students are introduced to the regularities of planetary motion. They create a spreadsheet to calculate the speed of any orbiting body at apogee and perigee. Students then use the spreadsheet to compare the speeds of planets, moons,...
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...
Lesson Plan
Curated OER

Which Color Will You Pick?

For Teachers 5th - 6th
Learners create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Lesson Plan
Curated OER

The People Behind the Numbers

For Teachers 10th
Tenth graders brainstorm potential definitions for "developed" and "developing" countries. They work in groups of four and research using Web sites listed to find information about their country then they create a spreadsheet which...
Lesson Plan
Curated OER

Escape Velocity

For Teachers 6th
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Lesson Plan
Curated OER

Light and Elements

For Teachers 9th - Higher Ed
Here is a full-fledged investigation of light waves, the electromagnetic spectrum, and element spectra. Physicists research a scientist that contributed to our understanding of the behavior of light. They take notes on your lecture, and...
Assessment
Inside Mathematics

Rugs

For Teachers 8th Standards
The class braids irrational numbers, Pythagoras, and perimeter together. The mini-assessment requires scholars to use irrational numbers and the Pythagorean Theorem to find perimeters of rugs. The rugs are rectangular, triangular,...
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

European Vacation

For Teachers 9th
Ninth graders work in groups of two or three to plan a trip through Europe. They present a storyboard for approval, outlining their graphics and display pages. They present their trip to the class using PowerPoint. This is displayed...
Lesson Plan
Curated OER

Kindergarten Class Favorites

For Teachers K
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
Lesson Plan
Curated OER

Put Your Heart Into It

For Teachers 1st
First graders sort Valentine candies according to kind. Data is inserted into a spreadsheet and displayed in various graphic formats.
Lesson Plan
Curated OER

Paper Tower Challenge

For Teachers 2nd - 5th
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Students collect and record the heights of other towers and use that data to create a spreadsheet.
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Ladybugs in the Garden

For Teachers 5th
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a instructional activity where they observed, examine, and...
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Learners create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.
Lesson Plan
Curated OER

Careers

For Teachers 8th
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
Lesson Plan
Curated OER

Tallahassee Project

For Teachers 6th
Sixth graders gather information from technological sources such as TV, radio, and Internet as well as from newspapers and maps and produce a final printed report. They use the data to create a spreadsheet and read a Florida state...
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Pupils investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel and...
Lesson Plan
Curated OER

Butterflies in the Garden

For Teachers 4th - 6th
Young scholars estimate the population of a butterfly ecosystem and create a chart and graph based on information they find.
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
Lesson Plan
Curated OER

Menu Math

For Teachers 5th - 6th
Students follow the food pyramid to create a daily food budget. They research food prices online or in newspapers. They graph the amount of each food group included in their menus. They can also create a weekly food menu based on a fixed...
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

Thank You... Thomas Edison!

For Teachers 2nd - 3rd
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.