**Math is beautiful!**

**If you don’t believe it, try our spreadsheet Labs. We have developed nearly 100 lessons on a variety of topics across all age levels to prove it. They are free. They run on your spreadsheet program. They enable you to learn math, “What if…” thinking, and to use spreadsheets like a pro.**

### Intro to Spreadsheets

- Number Lines introduce students to functional thinking and the use of formulas in spreadsheets. For younger students we call these…Read more
- We have been using cell addresses informally until now, but now we can be more formal and explicit. Different spreadsheets…Read more
- We use the hundreds table to introduce rows and columns and focus students on seeing the patterns in these tables.…Read more
- In introducing Spreadsheets we want you to learn to build a numberline by using a…Read more

### Arithmetic

- Number Lines introduce students to functional thinking and the use of formulas in spreadsheets. For younger students we call these…Read more
- Adding to 10 is but on example of a large number of spreadsheets that could be developed to practice addition.…Read more
- Now that students can build addition tables, they should look for the patterns in them. We introduce them to a…Read more
- From here on students can go in most any order they choose. They can start with addition or with multiplication.…Read more
- We have been using cell addresses informally until now, but now we can be more formal and explicit. Different spreadsheets…Read more
- Parentheses are not only important in math, they are critical in spreadsheets. To make sure that terms are handled properly…Read more
- Spreadsheets with their natural grid make a great, though not entirely flexible, platform for architectural design and for working with…Read more
- Students are tasked to build a times table in just two steps. They have to learn to use absolute as…Read more
- The symmetry of the multiplication table around the square numbers diagonal we call commutativity or the commutative property. It means…Read more
- Counting-By introduces multiplication. Counting-by or skip-counting is, we believe, the best way to help students build their multiplication facts, and…Read more
- The distributive property turns out to be central to a surprising variety of important mathematics. One of the most valuable…Read more
- Multiplying creates products, factoring separates a product into the numbers that make it up. We thus start with the table…Read more
- Spreadsheets always automatically perform the operations you ask them to do. But sometimes we want to see the process. We…Read more
- Working off of the rules for building a number line, students now have to develop more rules to turn…Read more
- We introduce students to more complex patterns and rules in hundreds tables. In particular, we have students look at diagonal…Read more
- This is one of those math puzzles that come up in contests here and there but which turns out to…Read more
- This is the graduation exercise for the basic use of spreadsheets. We combine rules and addressing to have students build…Read more
- We use rules to build new numberlines. For example we can start in the middle and go both forward or backward using adding…Read more
- How many of the products in a 12 by 12 times table are odd numbers? This is a question we…Read more
- Our number system inherited from India and from the Medieval Arab world enables us to use just 10 symbols to…Read more
- Using the times table students can see that products are always rectangles and that they represent the area of that…Read more
- We use the hundreds table to introduce rows and columns and focus students on seeing the patterns in these tables.…Read more
- Shapes introduces student to changing the colors in cells and to changing the shapes of cells by dragging the column…Read more
- Multiplication tables have some wonderful and quite surprising patterns. This is one of them. Draw any rectangle in a multiplication…Read more
- The square numbers form an interesting pattern on the times (multiplication) table. They run along a diagonal from 1 to…Read more
- We can make a division table just like we made a multiplication table. Spreadsheets will usually turn such tables into…Read more
- We think about ratio tables in terms of motion. Move up 2 and over 1, or move up 1 and…Read more
- We can use these proportions to compare two ratios with different denominators by finding a denominator that their proportions have…Read more
- Ratios can be written in a wide variety of different way: as fractions, as decimals, and as percents.,with a colon,…Read more
- Pennies to Heaven is a Fermi Problem, basically a “headmath” experiment. Fermi Problems, originally developed by Enrico Fermi, one of…Read more
- Fibonacci, the nickname given the great medieval mathematician Leonardo of Pisa is connected in most of our minds with the…Read more
- We take that great old problem of the inventor of chess and the ruler of India and use it to…Read more
- We take our place value generator to decimals to help students see the simplicity of the place value pattern going…Read more
- We extend the place value generator to 100’s of thousands to show you how the pattern of 1’s, 10’s, 100’s,…Read more
- There are a wide variety of financial literacy problems. This is the kind of problem that appears on many tests.…Read more
- Picturing exponential growth, powers of 10, can be hard for any of us to imagine. The spreadsheet has the flexibility to…Read more
- We have made a big deal of the times table and of other tables.Now we extend the times table to…Read more
- Spreadsheet math generally focuses on ratio and proportion to develop the concept of fraction. But fractions is such a big…Read more
- Manage a business. The Lemonade Stand has been a business simulation developed in many different versions. We believe this is the…Read more
- 1, 3, 6, 10... are called the triangular numbers because they can be stacked up to form a triangle. They…Read more
- In introducing Spreadsheets we want you to learn to build a numberline by using a…Read more

### Algebra

- The distributive property turns out to be central to a surprising variety of important mathematics. One of the most valuable…Read more
- This is one of those math puzzles that come up in contests here and there but which turns out to…Read more
- Parentheses are very important in spreadsheets because like all programming, spreadsheet formulas have to be very specific. A big formula,…Read more
- Fibonacci, the nickname given the great medieval mathematician Leonardo of Pisa is connected in most of our minds with the…Read more
- Another famous pattern Pascal’s triangle is easy to construct and explore on spreadsheets. Create a formula for any cell that…Read more
- Most museums with math exhibits have a Pascal’s triangle made up of pegs with…Read more
- Spreadsheets offer us a nearly unlimited ability to develop and learn from case studies using real world data. We will…Read more
- We look at world population over the past 60+ years and ask whether the earth’s population is growing faster or…Read more
- Linear functions are the most important functions. They pervade our everyday lives and our work. Their graph is a line…Read more
- Typical algebra courses start with equations and solving equations and then move to graphing and functions. We start with functions…Read more
- We ask about the coefficients and how changing each one changes the graph of the parabola. Thus what does a…Read more
- Polynomials as a class of functions have some fascinating patterns. For example their shape changes dramatically based on whether their…Read more
- Polynomial functions are not limited to the highest term and while that term is most important in determining the shape…Read more
- Spreadsheets are not limited to algebraic functions, they can also display trigonometric functions. We are modeling the sine function, but…Read more
- We take that great old problem of the inventor of chess and the ruler of India and use it to…Read more
- The rule of 72 is an old banker’s rule of thumb to find out how long it will take to…Read more
- Spreadsheets make it very easy to switch axes and add graphs. They enable students to play with what may have…Read more
- One of the most powerful aspects of the mathematics of functions is our ability to treat them as abstract quantities…Read more
- Solving systems of equations sometimes called simultaneous equations with graphs is simply a matter of finding out where they intersect.…Read more
- We have made a big deal of the times table and of other tables.Now we extend the times table to…Read more
- 1, 3, 6, 10... are called the triangular numbers because they can be stacked up to form a triangle. They…Read more

### Geometry

- Spreadsheets with their natural grid make a great, though not entirely flexible, platform for architectural design and for working with…Read more
- Using the times table students can see that products are always rectangles and that they represent the area of that…Read more
- Shapes introduces student to changing the colors in cells and to changing the shapes of cells by dragging the column…Read more
- Parentheses are very important in spreadsheets because like all programming, spreadsheet formulas have to be very specific. A big formula,…Read more
- Fractals are a new 21st century mathematics. They are patterns that repeat themselves at various scales. This one is based…Read more
- Spreadsheets are not limited to algebraic functions, they can also display trigonometric functions. We are modeling the sine function, but…Read more
- Scatterplot graphs enable us to build shapes using spreadsheets and to practice transformational geometry. They are surprisingly flexible tools. And…Read more
- The usual way to make string diagrams using rubber bands or yarn on a board with nails does not allow…Read more
- Strings need not begin and end on axes that are at right angles to each other which we call Cartesian.…Read more
- Read more

### Probability / Statistics

- Another famous pattern Pascal’s triangle is easy to construct and explore on spreadsheets. Create a formula for any cell that…Read more
- Most museums with math exhibits have a Pascal’s triangle made up of pegs with…Read more
- That probability is multiplicative is not an easy concept for many of us. Using the spreadsheet with our ability to…Read more

### Math and Design

- This is one of those math puzzles that come up in contests here and there but which turns out to…Read more
- Multiplication tables have some wonderful and quite surprising patterns. This is one of them. Draw any rectangle in a multiplication…Read more
- Pennies to Heaven is a Fermi Problem, basically a “headmath” experiment. Fermi Problems, originally developed by Enrico Fermi, one of…Read more
- Fibonacci, the nickname given the great medieval mathematician Leonardo of Pisa is connected in most of our minds with the…Read more
- Another famous pattern Pascal’s triangle is easy to construct and explore on spreadsheets. Create a formula for any cell that…Read more
- Fractals are a new 21st century mathematics. They are patterns that repeat themselves at various scales. This one is based…Read more
- We take that great old problem of the inventor of chess and the ruler of India and use it to…Read more
- Scatterplot graphs enable us to build shapes using spreadsheets and to practice transformational geometry. They are surprisingly flexible tools. And…Read more
- The usual way to make string diagrams using rubber bands or yarn on a board with nails does not allow…Read more
- Strings need not begin and end on axes that are at right angles to each other which we call Cartesian.…Read more