Curated OER
Using a Spreadsheet to Solve Gas Law Problems
Students use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. Students compute volume, temperature, or pressure according to the...
Curated OER
Spreadsheet formulas
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...
Alabama Learning Exchange
Find a Pattern Using Children's Literature
Sixth graders listen to Demi's, On Grain of Rice: A Mathematical Folktale. They use the problem solving strategy of finding a pattern to determine the number of rice Rani will receive after 30 days. They create a spreadsheet which...
Curated OER
Introductory Excel Lesson involving Problem Solving
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
Curated OER
T-Shirt Lettering
Students determine the cost of a t-shirt using a variety of mathematical operations to solve problems. Then they use a spreadsheet to calculate the cost of lettering a t-shirt and display this information in a graph.
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Concord Consortium
Boards III
Learn to visualize mathematical patterns as a folded pattern. Beginning with a visual display, the task encourages pupils to view sequences as a folded table. The pattern of the table then becomes a formula in a spreadsheet that...
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
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
Alabama Learning Exchange
How Big Can a Bee Be?
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Creating a Spreadsheet
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson, 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
Using a Spreadsheet
Students create a spreadsheet to analyze data. In this technology activity, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Curated OER
The Corner Problem
Students explore the concept of the corner problem. In this corner problem lesson, students use the TI-NSpire to determine the maximum length a rod can be and still pass horizontally around a corner. Students use similar triangles to...
Curated OER
Pancake Breakfast Plans
In this pancake breakfast planning worksheet, 5th graders solve and complete 9 different problems that include completing a chart for a pancake breakfast. First, they set up a spreadsheet to help them plan the event. Then, students...
Curated OER
The Apple Orchard Problem
Students explore various approaches to solving a problem of maximizing the total production of apples in an orchard. For this apple orchard lesson, students collect data in order to solve the apple orchard problem presented. Students...
Curated OER
Sales Spreadsheet
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
A Problem in Satellite Synchrony
In this satellite synchrony worksheet, students use a spreadsheet or Least Common Multiples to solve 4 problems related to the satellite orbits, orbital periods and their synchronicity. Students determine when the satellites launched in...
Curated OER
Three Squirrels and a Pile of Nuts
Learners solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Virtual Field Trip
Are we there yet? Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
Curated OER
Problem Solving with Batting Averages
Fifth graders use data from an Excel document to analyze and predict trends in batting averages.
Curated OER
The Big Hand Challenge
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.