What would you guess the absolute value of a polynomial function would look like? Try some here. I think you will be very surprised. Can you explain what you see?
Author: Ryan McQuade
Absolute Value Functions
The absolute value (ABS) function is the positive value of a number or quantity. Its graph has a very peculiar shape, a V. Since absolute values are always positive we can think of them as distances on a numberline.
Powers of Ten
Picturing exponential growth, powers of 10, can be hard for any of us to imagine. The spreadsheet has the flexibility to enable us to explore the powers of 10 and to get a visual image of them. We can see the difference in shape between odd and even powers, and get a sense of the speed of exponential growth. We use powers of ten to gain a sense not only of big numbers but of how big spreadsheets can be.
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 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.
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 do, and the Lab takes them through using them. We encourage students to work with just a row or a column rather than with the table as a whole because doing so makes it easier to see what is wrong or what does not follow the pattern. We believe students should learn to struggle to solve problems and that persistence, patience, and grit are important for all of us to have. We therefore do not want to tell students how to do something but rather to let them explore and try and keep at it until they get it. Spreadsheets with their openness and feedback provide a great opportunity for doing this in Labs like this. It is one of our favorites.