Numeracy

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

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… Read more

Odd Times

How many of the products in a 12 by 12 times table are odd numbers? This is a question we rarely ask in paper-based math… Read more

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… Read more

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… Read more

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. Read more

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.… Read more

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… Read more

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… Read more

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… Read more

Shapes

Shapes introduces student to changing the colors in cells and to changing the shapes of cells by dragging the column or row separators in the… Read more

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… Read more

Subtraction Tables

What would a subtraction table look like? How would its pattern be different from an addition or multiplication table? Is subtraction commutative? Read more

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… Read more

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… Read more

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… Read more