Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 4: t-Test

For Students 9th - 12th
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Lesson Plan
Curated OER

Raising Plants

For Teachers 2nd - 6th
Students investigate the life cycle of plants by growing their own in class.  In this botany lesson, students practice using plant vocabulary while they grow their own Wisconsin Fast Plants.  Students collaboratively build a...
Lesson Plan
Alabama Learning Exchange

Comparing Fuel Economy

For Teachers 4th - 7th Standards
Compute fuel economy and gas mileage. Why? So you can teach rates and ratios, of course! Middle schoolers calculate the rate of miles per gallon for various vehicles. They research each vehicle, its mileage per gallon, and cost per...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Baseball Stats

For Teachers 6th - 8th
Learners explore data sheets and statistics in baseball. They use baseball data available on the Internet to develop an understanding of the different ways in which data can be analyzed.
Lesson Plan
Curated OER

Show Me The Money

For Teachers 3rd
Third graders explore the value of U.S. money. In this money lesson, 3rd graders print out pictures of money from the Internet and create play money. The students will play a game in which they display the amount of money called out by...
Lesson Plan
Curated OER

Numeracy

For Teachers K
Students review numbers, number systems and the number operations through the use of online webpages.
Lesson Plan
Curated OER

Paws in Jobland Number Crunch

For Teachers 3rd - 5th
Learners analyze real life jobs that involve math. They discuss jobs where math is used, and explore how math is important in many areas and research some of these jobs in the book "Paws in Jobland." They complete a worksheet with four...
Lesson Plan
Curated OER

Mental Math

For Teachers 1st - 3rd
Students participate in an online computation game. In this computation lesson, students practice simple computations and use an internet site to review addition and subtraction facts.
Lesson Plan
Curated OER

Store Wide Sale

For Teachers 5th - 8th
Students practice figuring percentages by solving written shopping problems.  In this consumer math instructional activity, students read several scenarios dealing with items on sale and must figure out the new price.  Students...
Lesson Plan
Curated OER

Comparing Distances

For Teachers 3rd - 5th
Students practice estimating distances by analyzing a map. In this length measurement lesson, students view a map with a distance key and use their measurement skills to estimate the distance between two cities. Students utilize an...
Lesson Plan
Curated OER

Computer Accuracy

For Teachers 6th - 8th
Students work together on computers to practice measuring for navigation. They discover that errors in their calculations can lead them in the wrong direction. They examine the need of computers by engineers.
Lesson Plan
Curated OER

Cloud Database

For Teachers 7th - 9th
Students research information on the types of clouds. They create a database and use a formula. They create various reports and access electronic information to obtain accurate pressure and temperature readings from the National Weather...
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

The Origins of Business

For Teachers 9th - 12th
Learners explore the world of inventions by utilizing Google Earth. In this global geography lesson, students research inventions such as the ball point pen, computer, telephone and typewriter. Learners use the Google Earth software to...
Lesson Plan
Curated OER

The Ultimate Classroom: R & D

For Teachers 7th - 9th
Redecorate a classroom on a budget. Middle schoolers rebuild a classroom after a disaster. They conduct Internet research to determine construction supplies needed and the most cost effective way to reach the predetermined results. They...
Lesson Plan
Curated OER

Probability and Geometry

For Teachers 4th - 5th
Students examine the relationship between probability and geometry to solve problems. In this geometry and probability instructional activity, students investigate the effect of changing percentages on a spinner to the probability of...