Spreadsheets

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

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

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

Introducing Spreadsheets

In introducing Spreadsheets we want you to learn to build a numberline by using a rule (a formula). We begin with a simple rule that you can copy… 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

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

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

What is x?

What is “x”? Or how do we represent variables and functions on spreadsheets? Continue