Tag: coding

The Bit

The key to the digital age is also the key to learning algebra.

Despite what many of us may believe, our digital age did not began with the microprocessor, or the personal computer, or even the iPhone; it began with a single amazingly simple idea by a quiet man who few of us would today recognize. Claude Shannon grew up in Minnesota when radio was becoming the means of communication to all, broad cast. It was the age when sound was added to movies, when phonographs and records storing sound became a must in every home, when the first facsimile machines were used to transmit photographs and text, and when everyone could take their own pictures with the Kodak Brownie camera.

Each of these transforming inventions used a different analog means of storing or transmitting data. Analog data is continuous; on a graph it is a line, sometimes smooth, sometimes jagged. All of these inventions had to deal with the problem of noisy data and of separating the noise from the data. This was the problem Claude chose to work on. Before him the common way of dealing with noisy data was to turn up the volume. If the radio static was bad, make it louder. If the picture was muddy, increase its contrast. If the telephone call was hard to understand, yell.

To solve this problem of noisy data both in storage and in transmission, Claude came up with a truly brilliant, surprising, and original idea. Think about all data as digital. Think about it as being broken down into discrete bits, a collection of just 1’s and 0’s. No longer would data be stored or transmitted as a wave like the grooves in a phonograph record, a continuous quantity. In Claude’s new world it would be like atoms, discrete, separate, objects. Bits, the word he chose, came from binary digits; where his “atoms” took two and only two forms. It was transmitted in bits, stored in bits, and processed in the same bits. He then figured out how to find corrupted noisy data, how to minimize it, and how to replace it. When he died at the turn of this century, his vision for data was just becoming an overwhelming reality. Because today, we have the bandwidth, the storage, and the processing power to handle all data digitally, and the processes that make noise no longer a problem we concern ourselves with.

Isn’t it time our schools deal with its noise problem by becoming digital and focusing on discrete data? Today’s “analog” continuous variable algebra makes the concept of variable abstract and difficult for many students to understand. It requires students to learn a complex set of special cases to solve abstract equations. It turns algebra into collection of mechanical processes focused on cases that are easy to solve. What if we were to follow Claude Shannon’s lead and treat variables as discrete, digital quantities? Spreadsheets make this easy. Variables become concrete, easy to understand, iterate, build into functions, and use those functions to build models. They give us the means to focus on real, messy, interesting data to solve fascinating problems.

Try this new way of thinking for yourself. Go to our Tour to see apply the digital world to algebra. Try it with your students. Tell us what you think.

Art

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 bars, but all use the same format, letters for columns and numbers for rows with letters first and numbers second. We introduce this on the hundreds table which could be thought of as a miniature spreadsheet and use number lines to provide some additional feedback. Using addressing enables us to build rules as patterns and to put anything we want into cells to use those rules on. It is the great power of spreadsheets.

Enigma Machine

Spreadsheets are great for creating secret codes and for breaking them. During World War II the German military used a machine they called Enigma to send coded messages. In a box about the size of a typewriter, wheels with letters on them were spun around to encode or to decode a message. The story of the breaking of that code by Alan Turing and the British code breakers was made into the movie The Imitation Game. We have used spreadsheets with some of their built-in rules to let you set up your own enigma machine. There are many ways you can use a spreadsheet to generate or to crack codes. It is fun to see if you can make a code your friends can’t break.

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?

Number Series

Spreadsheets make it easy for us to explore patterns in the whole numbers. This Lab does that and helps you learn the basics of spreadsheets like cell addressing, copy and pasting, and making rules. It is designed for every learner including young students.