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 address axes. Students can use spreadsheets as drawing tools and can create some wonderful pictures with them. Spreadsheets can thus be tools for visualizing mathematics as well as adding the arts to technology and math.
Category: Labs
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 times table by playing with these rectangles whose sides are the factor of the products.
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 imagine. Students learn in this spreadsheet to enter numbers, to compare compact and expanded forms of those symbols and to add units to any number. Students who like to explore further can extend the place values from 3 digits to more and learn the trick that lets them include any kind of text with numbers they can change.
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 generate and experiment with negative numbers by subtracting below 0. As you build numberlines on spreadsheets you are building them in your mind. And by thinking of numberlines in terms of rules you are getting ready for algebra.
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 with lights in the ceiling, all on and each controlled by its own chain. A long line of people (as many as there are lights) walk down the hallway. The first one pulls every chain, the second one every other chain, the 3rd pulls every 3rd chain and so on. When all the people have walked down the hallway, what lights, if any, will still be lit? What more can you learn from this puzzle about multiplication?