Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 9th - 12th
Students use the computer and S'COOL data for statistical analysis.
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Party Math

For Teachers 10th - 12th
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Mental Math

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

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
Curated OER

Calculator

For Teachers K - 4th
Students explore the calculator utility function on a Macintosh computer.  In this calculation lesson plan, students launch the calculator feature and complete a problem solving worksheet.
Interactive
Curated OER

Thanksgiving Internet Math Fun

For Students 4th - 6th
In this Thanksgiving Internet math fun worksheet, students interactively choose from 16 different activities with links to other websites, all with a Thanksgiving and math theme.
Lesson Plan
Curated OER

The Internet Pizza Server - Pizza Simulation

For Teachers 8th - 12th
Students simulate going to a pizza restaurant, ordering a pizza, and determining whether a small, medium, large, or family size pizza is a "better-buy." Students calculate the price/per/topping and determine whether this price is "fair"
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
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Lesson Plan
Curated OER

Podcasting Parabolas

For Teachers 8th - 12th
Students explore parabolas.  In this algebra and technology lesson, students construct the equation of a specific parabola, then take digital photos of real-life representations of these parabolas.  Students create a podcast...
Lesson Plan
Curated OER

Historical Mathematicians Project

For Teachers 5th - 12th
Students, in small groups, use the Internet and other traditional sources to research historically significant mathematicians, write a paper, and creatively present research in class.
Lesson Plan
Curated OER

Mathematics: Technology and Connections

For Teachers 6th
Sixth graders interpret and replicate patterns. For this patterns lesson, 6th graders are given an item with a definite pattern which they must replicate using a calculator or computer and then justify how they relate. Students...
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

Calculating Profits from Selling Virtual Lemonade

For Teachers 5th - 7th
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider weather...
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

Baseball Stats

For Teachers 6th - 8th
Students 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

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

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
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

Music Favorites and Place Value

For Teachers 4th
Fourth graders view CD ads and create a chart about an imaginary CD purchase.  In this CD lesson, 4th graders calculate various cost connected with the CD's at the regular price and on sale. Students write a paragraph about the...