Curated OER
Basic Excel
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. Students complete...
Curated OER
Money Math: Lessons for Life
Students develop a budget for a college student using all of the influences that the student would have. In this budgeting lesson plan, students use real life examples to create a budget spreadsheet. Students read and study sample...
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Curated OER
Let's Get Linear
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
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...
American Institutes for Research
Digital Smiles
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...
Curated OER
Dental Detectives
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Young scholars, 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.
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a very...
Curated OER
Birds, Fractions and Percentages
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Temperature High and Lows
Young scholars gather high and low temperature readings through email. In this temperature graphing activity, students use a spreadsheet to input data for a graph. young scholars interpret the graphs to compare and contrast the data from...
Federal Reserve Bank
Expense Tracking
Where does all your money go? Individuals keep a record of the money they spend over the course of 30 days. They then categorize where they are spending their money and write an essay detailing their findings.
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.
Bowland
Outbreak: Infection Detection
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...
Curated OER
What Color Are Your Skittles?
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
Curated OER
Pollution Assessment: Is Wood Lake a Good Lake?
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.
Curated OER
Baseball Statistics
Students read "Casey at the Bat" and then use individual player statistics (found through internet research)to determine if their players could be considered baseball "heroes". They must justify their choices for "hero" by creating...
Curated OER
Crispy Cookie Class Fundraiser
Seventh graders see the relationship of math and the real world application by manufacturing a product for making a profit. They create a food product from a recipe, record their sales and analyze and report their gross profit.
Curated OER
Shop 'Til You Drop
Students evaluate food prices. In this real world math lesson plan, students compare the cost of various grocery items to determine which is the best deal. They work in groups using grocery ads to decide how to get the most product for...
Curated OER
Polluting the Environment
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...
Curated OER
Income Levels & Social Class: Is It All About Cash?
Students graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.
Alabama Learning Exchange
Watch That Plant Grow
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.