Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

World Population Activity II: Excel

For Teachers 11th - Higher Ed
Students import UNEP World population data/projections from either the World Population Prospects: The 2002 Revision Population Database - UN Population Division or a text file. They graph this data by itself, and then along with...
Lesson Plan
Curated OER

What's My Pattern?

For Teachers 7th - 8th
Students recognize, describe and extend patterns in three activities. They organize data, find patterns and describe the rule for the pattern as well as use the graphing calculator to graph the data to make and test predictions. In the...
Activity
PBL Pathways

Students and Teachers

For Students 10th - Higher Ed Standards
Predict the future of education through a mathematical analysis. Using a project-based learning strategy, classes examine the pattern of student-to-teacher ratios over a period of years. Provided with the relevant data, learners create a...
Lesson Plan
Curated OER

The "U's" Have IT!

For Teachers 10th - 12th
Young scholars explore the maximum and minimum values of parabola. In this exponential equations lesson, students use graphing calculators or TI Interactive Software to calculate values of parabola and graph x-intercepts of parabola.
Unit Plan
Radford University

Sleep and Teen Obesity: Is there a Correlation?

For Students 10th - 12th Standards
Does the number of calories you eat affect the total time you sleep? Young mathematicians tackle this question by collecting their own data and making comparisons between others in the class through building scatter plots and regression...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend...
Lesson Plan
Curated OER

Graphing Weather

For Teachers 2nd - 3rd
Students make a graph. In this weather lesson, students fill in a KWL chart about different types of weather. Students watch a PowerPoint presentation about weather and natural disasters and where these types of weather are common....
Lesson Plan
Curated OER

Graphing Pockets

For Teachers 2nd
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Lesson Plan
Curated OER

Line Graphs

For Teachers 7th
Seventh graders create a line graph and identify when to use line graphs. In this line graphs instructional activity, 7th graders analyze the average temperatures of various cities. Students graph the data they collected.
Lesson Plan
Curated OER

Name Count and Graph

For Teachers 6th - 8th
Students find the frequency of a name in selected states by using the Internet. They input data into a spread sheet. They create a graph that illustrates the gathered information.
Activity
PBL Pathways

College Costs

For Students 10th - Higher Ed Standards
Predict the year that college costs will double in your state using linear modeling. The first part of this two-part project based learning activity asks young mathematicians to use data from the College Board. They graph the data,...
Lesson Plan
Virginia Department of Education

Algebra Tiles and Solving Equations

For Teachers 6th - 9th Standards
Young mathematicians solve linear equations by drawing models of algebra tiles using colored pencils. To finish, they solve the same equations algebraically and check their answers using a graphing calculator.
Lesson Plan
Curated OER

The Race of Baseball All-Stars

For Teachers 7th - 9th
Collect and analyze data. Pupils graph their data and model with it to solve real life problems. They use logic and deductive reasoning to draw conclusions.
Lesson Plan
Curated OER

BUS: Farming: It's A Fact (Ag)

For Teachers 9th - 12th
Students create two different types of graphs from the information in the "Farm Facts" booklet (i.e., bar graph, pie chart, etc.). They calculate where your food dollars are spent (on and off farm).
Lesson Plan
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Lesson Plan
Curated OER

Thanksgiving Dinner

For Teachers 4th - 6th
Pupils plan a traditional Thanksgiving dinner. In this Thanksgiving lesson plan, students compare and contrast the first Thanksgiving to Thanksgiving celebrations today. Pupils plan a traditional Thanksgiving dinner and research the...
Lesson Plan
Curated OER

Graphing Population Around the World

For Teachers 9th - 12th
Students define specific vocabulary necessary for understanding population data. They collect, analyze, and interpret specific data. They utilize computer programs in order to create graphs of collected data.
Lesson Plan
Curated OER

Candy is Dandy

For Teachers 6th - 9th
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Lesson Plan
Curated OER

How do We Treat Our Environment?

For Teachers 7th
Seventh graders explore the concept of collecting data. In this data collection instructional activity, 7th graders survey others about their environmental habits. Students graph their data.
Lesson Plan
Curated OER

Bias in Statistics

For Teachers 7th - 8th
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Lesson Plan
Curated OER

Immigration and Citizenship

For Teachers 5th - 9th
Students make graphs showing Canada's immigration patterns over time. Then students play the role of an immigrant seeking citizenship and perform a mock citizenship ceremony.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Students participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.