Home » Spreadsheets

Spreadsheets

Hundreds table with numbers one to hundred.

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

Multiplication table with highlighted numbers.

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

Graph with data table and scatter plot.

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

Grid with arithmetic input and output examples.

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

Hundreds table from 1 to 100.

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 sequences in horizontal rows, various increments.

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

Hundreds table with highlighted numbers in color.

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

Mathematical concept with colorful grid patterns.

What is x?

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