As part of the State of Maine’s 1-to-1 laptop initiative (MLTI), the Project Office has enlisted a team of integrators to provide training and tips to teachers and students across the state to help them be more efficient users of their Apple laptops. Called MLTI Minute, these training podcasts cover topics across different applications, utilities, and web tools.
In a recent episode, MLTI Minute highlighted an interesting tool when working with a data table found within the application Numbers. Called Slider Cells, this tool essentially allows you to take a plain old data table and turn it into an interactive tool. In the podcast, they use the example of a data table made to calculate the interest payment on a principal loan. The podcast shows you how to activate the slider cell tool and configure it based on the type of data you are working with.
Curiosity got the better of me at this point, and I wanted to see if this new interactive tool would allow me to manipulate a chart/graph based on the data in the table. I created two charts to represent the changes made to the rate and the resulting interest amount. When I used the cell slider to manipulate the rate, both charts adjusted to reflect the changing data. I now had a truly interactive tool that I could control and change with the click of my mouse.