Curated OER
Using Spreadsheets and Graphs
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...
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Learners, 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.
EngageNY
Credit Cards
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.
Curated OER
Creating Climographs
Learners use satellite data to compare precipitation and surface temperatures on different islands. In this satellite lesson plan students create graphs and explain the differences between weather and climate.
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Learners use NASA satellite data to compare water vapor over the United States. In this data analysis activity students use an Excel spreadsheet to map their data.
Curated OER
Million Dollar House
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Curated OER
Spreadsheets in Science
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...
Curated OER
Calculating & Graphing Using a Spreadsheet
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Curated OER
Fast Food Survey Using Bar Graphs
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.
Curated OER
Interpreting Data and Statistics using Graphs
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.
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Learners 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 examine any...
Curated OER
Louisville's Best Field Day Park
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra activity, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Exploring the Beach
Young scholars explore the beach. In this marine habitat lesson, students inspect sand grains, design beach profiles, classify marine life, and examine natural beach habitats. Young scholars use spreadsheets to record data from their...
Intel
Pedal Power
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...
Curated OER
Probability Using M & M's
Students develop an understanding of probability by sorting bags of M & M's by color and recording the results in percents. The data is entered onto a spreasdsheet and graphed.
Curated OER
Is That Your Final Answer?
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...
Curated OER
Iterating the Function over Real Numbers
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.
Curated OER
Iterating Linear Functions
Students use a spreadsheet to investigate data. In this algebra lesson plan, students collect and graph data on a coordinate plane. They explain properties of a linear equation both algebraically and orally.
Curated OER
What's Your Line?
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
Curated OER
Function Graphing--ID: 8252
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,...
Curated OER
Irish Eyes: Taking a Look at Local Landscape
Direct your class’s attention to the elements that make their community unique. After examining sample travel brochures, groups select something from their community to use as the subject, and then research, create, and publish a...
Statistics Education Web
Walk the Line
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...
Curated OER
E-mailing the Chamber of Commerce
Encourage effective internet research and e-mail correspondence as scholars investigate a US capital city they've never visited to find pertinent and relevant information. They begin by picking a city, then visit that city's chamber of...