Curated OER
Carbon Dating
Simulate C-14 decay using M&M and Reese's Pieces candies. In this scatter-plot instructional activity, students perform an experiment to simulate the half life of C-14. Information is plotted on a scatter-plot. Students answer four...
Curated OER
Back-To-School Shopping
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
Curated OER
ICT Activity 17
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Curated OER
Skittles Candy Count
Young scholars study how to use formulas, edit the spreadsheet, and create and edit charts. They add data to a spreadsheet, format it, add a chart and format it. They count the number of each color of Skittles and record it onto their...
Curated OER
Looking at Circumference
Middle schoolers understand where the number for pi comes from. They understand and use the formula for circumference. Students measure the circles given out and the diameters of those circles and record the results on their worksheet.
Vertex42
Birthday Calendar
This is a neat document that will make remembering the birthdays of your class members a piece of cake!
Curated OER
Houses and Cars and Loans
Students create a spreadsheet to track their spending. In this algebra lesson, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and house.
Curated OER
Bones and Math
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Curated OER
Discovering Pi
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.
Agile Mind
Isabella’s Credit Card
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Curated OER
Graphing Data from the Chemistry Laboratory
Learners graph and analyze data using a spreadsheet.
Curated OER
How Would You Spend a Million Dollars?
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
Curated OER
Made Round To Go Round
In this instructional activity students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference...
Curated OER
Word Processing
Students insert and delete columns and rows, change lines, borders, and fill in styles, as well as change cells, rows, columns, and table formatting. Then, students calsulate sums for rows and columns and enter their formulas in order...
Curated OER
Using Computers for Statistical Analysis of Weather
Students use temperature, cloud cover and other weather data from the S'COOL website to statistically analyze weather around the country. They use computers to calculate and graph standard deviations, means and modes of the weather...
Curated OER
Introduction to Limits
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Curated OER
Moving Day!
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Curated OER
Heartbeat Project
Students enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
Curated OER
Law of Large Numbers - Hospital
Students explore concepts of probability and independent events. They develop a formula for deviation percentage.
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Building My Dream House
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up to...
Curated OER
Number and Algebra: Again and Again
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
Curated OER
Code Crackers
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.