Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Fantasy Basketball

For Teachers 6th - 8th
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Mean, Median, Mode and Range

For Teachers 4th
Fourth graders investigate when to find the mean, median, mode and range.  In this statistical concepts lesson, 4th graders collect data, make observations and graph the data. Students verify their work on the computer.
Lesson Plan
Curated OER

Hunter Fred's Quest for Dinner

For Teachers 9th - 12th Standards
Learners solve problems using trigonometric functions, specifically a problem about a tree stand. Pupils try to maximize the distance of hunting sight given certain restrictions. They use the Pythagorean Theorem, sine, cosine, and...
Lesson Plan
Curated OER

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Lesson Plan
Curated OER

Giving'Em The Business

For Teachers 1st - 2nd
Students work in groups of 4-5 to form a business, create, market & sell their product, and track their expenses and profits. They experience the roles of producer, distributor, and consumer of goods. They collect, organize and...
Lesson Plan
1
1
Curated OER

Properties of Logarithms

For Teachers 9th - 12th Standards
Learners investigate properties of logarithmic function as they add, subtract and multiply logarithms. They graph and analyze the graph for exponential equivalency.
Lesson Plan
Curated OER

Rise Over Run

For Teachers 9th - 12th
Students define the slope of the line, find the slope between any two points on the line, and allow them to name other areas where the slope is used. They explain why the slope is defined as the rise over the run.
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Middle schoolers collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and...
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

First Class First? Using Data to Explore the Tragedy of the Titanic

For Teachers 9th - 12th
Students analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Lesson Plan
Curated OER

It's Your Life

For Teachers 6th - 7th
Students make a multiple line graph showing income levels for each education level for the past 8 years and the number of people for each ethnic group and gender is compared within each education level.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

Baseball Relationships - Using Scatter Plots

For Teachers 6th - 10th
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Lesson Plan
Curated OER

Fire Safety Survey

For Teachers 3rd - 6th
Students collect data regarding fire safety and create a graph. Working in small groups, they administer a survey to family and friends regarding their attitudes toward fire safety. After data has been gathered, students graph their...
Lesson Plan
Curated OER

Pythagorean Theorem Spreadsheet

For Teachers 6th - 8th
Studetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Young scholars work individual...
Lesson Plan
Curated OER

Interpreting Data and Statistics using Graphs

For Teachers 7th
Seventh graders interpret data. In this lesson on types of graphs, 7th graders construct, interpret, and analyze different graphs. This lesson includes worksheets and resources.
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Learners calculate gas prices. In this transportation instructional activity, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices...
Lesson Plan
Curated OER

American History Through Architectural Masterpieces: Monticello

For Teachers 3rd - 5th
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
Lesson Plan
Curated OER

Million Dollar Project

For Teachers 5th
Each student is given the task of spending $1 million. The way students spend their money is dependent on a theme such as "creating a dream world," "taking a trip," or "doing something to better society." Each student researches,...