Adding
Adding to 10 is but on example of a large number of spreadsheets that could be developed to practice addition. We give students two number… Continue
Adding Machine
Multiplication is often thought of as repeated addition. By building a times table by using a repeated addition rule you will have a fun practice… Continue
Addition Patterns
Now that students can build addition tables, they should look for the patterns in them. We introduce them to a variety of things they might… Continue
Addition Table
From here on students can go in most any order they choose. They can start with addition or with multiplication. They should imagine themselves on… Continue
Addressing
We have been using cell addresses informally until now, but now we can be more formal and explicit. Different spreadsheets have different types of address… Continue
Associativity
Parentheses are not only important in paper math, they are critical in spreadsheets. To make sure that terms are handled properly by spreadsheets, we have… Continue
Battleship
Spreadsheets can be a great place for you to build your own games. Ryan has built one of his early favorites, Battleship, where you learn… Continue
Build a House
Spreadsheets with their natural grid make a great, though not entirely flexible, platform for architectural design and for working with shapes. Build a house introduces… Continue
Build a Times Table
Students are tasked to build a times table in just two steps. They have to learn to use absolute as well as relative addressing to… Continue
Common Denominators
We can use these proportions to compare two ratios with different denominators by finding a denominator that their proportions have in common. Thus the common… Continue
Commutativity
The symmetry of the multiplication table around the square numbers diagonal we call commutativity or the commutative property. It means that in a 12 by… Continue
Counting By
Counting-By introduces multiplication. Counting-by or skip-counting is, we believe, the best way to help students build their multiplication facts, and though they will live in… Continue
Decimal Division
Decimal Division is one of a series of Labs to help you understand and learn to use decimals. I think you will find it fun… Continue
Decimal Multiplication
Decimal Multiplication is one of a series of Labs to help you understand and learn to use decimals. I think you will find it fun… Continue
Decimal Subtraction
Decimal subtraction is one of a series of Labs to help you understand and learn to use decimals. I think you will find it fun… Continue
Distributivity
The distributive property turns out to be central to a surprising variety of important mathematics. One of the most valuable is to use it to… Continue
Division and Ratio
We can make a division table just like we made a multiplication table. Division is surprisingly our most important operation in terms of most of… Continue
Drawing Triangles
Though spreadsheets lets you put geometric shapes on the screen, those shapes are not connected with the cells and cannot be changed by using different… Continue
Enigma Machine
Spreadsheets are great for creating secret codes and for breaking them. During World War II the German military used a machine they called Enigma to… Continue
Factor Pairs
Multiplying creates products, factoring separates a product into the numbers that make it up. We thus start with the table and then look at the… Continue
Factor Table
Spreadsheets always automatically perform the operations you ask them to do. But sometimes we want to see the process. We can make spreadsheets show us… Continue
Graphing
Graphs as we know them were first invented by Galileo. They are powerful images of functions. I will introduce you to graphs by letting you… Continue
How Many Times
How many of the numbers from 1 to 100 are in the times table? All, Most, Less than half? I think you will find in… Continue
Hundreds Table Patterns
We introduce students to more complex patterns and rules in hundreds tables. In particular, we have students look at diagonal patterns and develop rules to… Continue
Introducing Subtraction
What if you built a rule that would enable you to count backwards? How would it be the opposite of addition? What would happen if… Continue
Lights Out
This is one of those math puzzles that come up in contests but which turn out to be quite interesting mathematically. Imagine a long hallway… Continue
Magic Rectangle
Multiplication tables have some wonderful and quite surprising patterns. This is one of them. Draw any rectangle in a multiplication table and you will find… Continue
Make a Hundreds Table
This is the graduation exercise for the basic use of spreadsheets. We combine rules and addressing to have students build their own hundreds table in… Continue
Making Fractions
Spreadsheet math generally focuses on ratio and proportion to develop the concept of fraction. But fractions is such a big problem in today’s curriculum that… Continue
More Number Lines
We use rules to build new numberlines. For example we can start in the middle and go both forward or backward using adding and subtracting rules. You can even… Continue
Motion Problems
George is in New York and Martha is in Washington. They leave at the same time and follow the same road to meet each other… Continue
Multiplying Integers
We have made a big deal of the times table and of other tables.Now we extend the times table to negative numbers and thus to… Continue
Number Lines
Number Lines introduce students to functional thinking and the use of formulas in spreadsheets. For younger students we call these formulas “rules” and ask students… Continue
Number Patterns
Use numberlines and spreadsheet rules to explore the amazing patterns we find in our whole numbers. Did you know that you can get the odd… Continue
Number Series
Spreadsheets make it easy for us to explore patterns in the whole numbers. This Lab does that and helps you learn the basics of spreadsheets… Continue
Pennies to Heaven
Pennies to Heaven is a Fermi Problem, basically a “headmath” experiment. Fermi Problems, originally developed by Enrico Fermi, one of the greatest experimental and theoretical… Continue
Place Value
Our number system inherited from India and from the Medieval Arab world enables us to use just 10 symbols to write any number we can… Continue
Place Value: Decimals
We take our place value generator to decimals to help students see the simplicity of the place value pattern going right as well as left. Continue
Place Value: Thousands
We extend the place value generator to 100’s of thousands to show you how the pattern of 1’s, 10’s, 100’s, continues to 1,000’s, 10,000’s, 100,000’s.… Continue
Prime Numbers
The prime numbers are among the most fascinating objects in all of mathematics. While we can generate them, we do not know or understand their… Continue
Products as Areas
Using the times table, students can see that products are always rectangles, and that they represent the area of that rectangle. They should explore the… Continue
Rows and Columns
We use the hundreds table to introduce rows and columns and focus students on seeing the patterns in these tables. Again and again we go… Continue
Square Numbers
The square numbers form an interesting pattern on the times (multiplication) table. They run along a diagonal from 1 to the top right of the… Continue
Subtraction Tables
What would a subtraction table look like? How would its pattern be different from an addition or multiplication table? Is subtraction commutative? Continue
Sudoku Challenge
Have you ever played Sudoku? It is fun and challenging. You have to find the numbers from 1 to 9 in each cell so that… Continue
Syracuse Problem
I built a Lab for you to play with the Syracuse Problem and to learn to use spreadsheets to play with like problems in fun… Continue
Triangular Numbers
1, 3, 6, 10… are called the triangular numbers because they can be stacked up to form a triangle. They are very interesting numbers, and… Continue