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 the fewest steps. There are many ways of doing this and students can be as creative and exploratory as they want. Nor should they feel limited to tables that start at 1 and go to 100. These rules, these patterns should enable them to start anywhere and build any size table they can imagine. We strongly encourage students to stretch their minds here and to think outside of this box.
Category: Numbersense
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 to build a variety of number lines using rules. For example they can build a whole number line by creating a rule that adds 1 to the number in the previous cell (=J9+1) and then copy that rule across the numberline cells. They build numberlines with only odd numbers, even numbers, and starting with different numbers. We encourage them to explore a variety of rules to make different numberlines.
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 that all of the numbers appear only once in every row, column, and grid square. Ryan added a sweet wrinkle to the traditional Sudoku game, he gives you the sums so that you not only get to practice addition, you can get some hints about the numbers you should input. Can you use our template to create your own Sudoku challenge?
Subtraction Tables
What would a subtraction table look like? How would its pattern be different from an addition or multiplication table? Is subtraction commutative?
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 and interesting ways. The Syracuse Problem is a simple one. Pick a number, any whole number. If it is even divide it by 2, if it is odd multiply it by 3 and add 1. If you keep doing this to each number in turn you will get the same sequence no matter what number you first pick. It is wild and totally not intuitive. You will also learn to use formulas to test whether numbers are even or odd, and even more importantly to use if…then rules. And you will learn about convergent number patterns.
I read about this problem in a most wonderful book, The Birth of a Theorem by Cedric Villani. I don’t think I have ever read a book that I understood less of and yet enjoyed as much. Villani is a Fields Medalist. For those of you who may not know, the Fields Medal is in essence the Nobel Prize of mathematics. In the book Villani tells the story of the development of the theorem that won him the Medal. I find his description of mathematics invention fascinating, for despite its esoteric nature it is the same as invention in all disciplines. As part of his story he tells about one of John Nash’s great discoveries, yes the John Nash of an Elegant Mind. And he describes a fascinating mathematical pattern that has thus far eluded explanation.
I quote from the book because Villani not only describes the problem beautifully, but he helps us all see what mathematics and mathematics invention is like.
The Syracuse problem (also known as the Collatz conjecture or the 3n+1 problem) is one of the most famous unsolved enigmas of all time. Paul Erdos himself is on record as saying that mathematics is not yet ready to confront such monsters.
Enter the expression “3n+1” in an Internet search engine and follow the thread back to the abominable problem and its result, as simple and insistent as the refrain of a pop song:
Take any whole number you like, say 38.
The number is even. Divide it by 2 and you get 19.
The last number is odd. Multiplying by 3 and adding 1 you get 19*3+1=58.
This last number is even. Divide it by 2….
And so on. You go on from one number to the next by means of a simple rule: each time you encounter an even number, divide by 2; each time you encounter an odd number, multiply by 3 and add 1.
Starting from 38, as in the example above, you get the following sequence: 19, 58, 29, 88, 44, 22, 11, 34, 17, 52, 26, 13, 40, 20, 13, 40, 20, 10, 5, 16, 8, 4, 2, 1, 4, 2, 1, 4, 2, 1…
Once you arrive at 1, in other words, you know what comes next: 4, 2, 1, 4, 2, 1, 4, 2, 1, 4, 2, 1…ad calculam aeternam.
Every single time this calculation has been performed in the course of human history, it has ended up as 4, 2, 1… Does that mean it will always turn out thus, no matter which number is chosen as the point of departure?
Since there are infinitely many integers, obviously it’s impossible to try all of them. With all the pocket calculators, desktop calculators, computers, and supercomputers at our disposal today, it has been possible to try billions and billions of them, and every single last one has wound up leading back to the implacably repeating 4, 2, 1 pattern.
Mathematics is democratic, of course, and anyone is free to try to show that this sequence embodies a general rule. Everyone believes the rule to be true, but since no one knows how to prove it, it remains a conjecture. Whoever succeeds in confirming or disconfirming this conjecture will be proclaimed a hero.
I am certainly not among those who will try. Apart from the fact that it seems to be phenomenally difficult, it isn’t the sort of problem that suits the way my mind works. My brain isn’t used to thinking about such things.
Cedric Villani, Birth of a Theorem, p.173