Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Is That Your Final Answer?

For Teachers 7th - 9th
This unit on integers includes a pre-test, a post-test, four spreadsheets, and links to an interactive web-site to support the learning of integer operations. Access to computers and the Internet are imperative to this unit. The lessons...
Lesson Plan
Curated OER

Drawing One and Two Playing Cards With Replacement

For Teachers 6th - 9th
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
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

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. For this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Lesson Plan
EngageNY

Credit Cards

For Teachers 10th - 12th Standards
Teach adolescents to use credit responsibly. The 32nd installment of a 35-part module covers how to calculate credit card payments using a geometric series. It teaches terminology and concepts necessary to understand credit card debt.
Lesson Plan
Bowland

Outbreak: Infection Detection

For Teachers 6th - 9th
Explore the mathematics of infection outbreaks with activities that ask learners to use coordinate grids to locate infected patients. They calculate amounts of ingredients for antidotes and determine which groups of people should be...
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

Pollution Assessment: Is Wood Lake a Good Lake?

For Teachers 7th - 8th
Students become aware of pollution in Richfield Minnesota's Wood Lake, identify sources of pollution in Wood Lake, learn to use variables, equations, spreadsheets and modeling software, and generate solutions for the problem.
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Alabama Learning Exchange

Watch That Plant Grow

For Teachers 6th - 8th
Middle schoolers examine the growth of marigolds in a greenhouse environment. They chart data in spreadsheets showing plant growth over time and under a number of conditions. They record measures of plant height and greenhouse temperature.
Lesson Plan
Curated OER

Function Graphing--ID: 8252

For Teachers 9th
Those graphing calculators can be tricky; good thing Texas Instruments has devised a lesson on how to use their TI-Nspire calculator to graph functions. Kids investigate functional notation as they graph ordered pairs in the form (a,...
Lesson Plan
1
1
Texas Instruments

Is It or Isn't It Proportional

For Teachers 6th - 12th Standards
How can you tell if number relationships are proportional? Mathematicians investigate proportional relationships. They compare and contrast functions and graphs to determine the characteristics of proportional relationships, as well as...
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

Putting Your Money to Work

For Teachers 9th - 11th
Students create a collect data on expenses. In this algebra lesson, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson.
Lesson Plan
Curated OER

Linear Regression (and Best Fit)

For Teachers 9th - 12th
Students explore notions of relationships between two variables. They use discussion, games, worksheets, spreadsheets to consider relationships such as: height vs. shoe size, cricket chirping vs. temperature.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Unit Plan
Intel

Pedal Power

For Students 8th - 12th Standards
Show your classes the importance of mathematics in something as simple as bicycle design. The final lesson in the six-part STEM series has each group research a different aspect of the bicycle. Learners use mathematical formulas, linear...
Lesson Plan
EngageNY

Normal Distributions (part 2)

For Students 10th - 12th Standards
From z-scores to probability. Learners put together the concepts from the previous lessons to determine the probability of a given range of outcomes. They make predictions and interpret them in the context of the problem.
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
Statistics Education Web

Walk the Line

For Students 9th - 12th Standards
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Activity
Education Development Center

Interpreting Statistical Measures—Class Scores

For Students 9th - 12th Standards
Explore the effect of outliers through an analysis of mean, median, and standard deviation. Your classes examine and compare these measures for two groups. They must make sense of a group that has a higher mean but lower median compared...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Learners investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 6th
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.