Apple Tip: Slider Cell

Apple Tip: Slider Cell

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.

Click here to watch the podcast (3:36)


How-To Tech Tip: The Pleasantville Effect

This screencast will show you how to create a “Pleasantville Effect” (a.k.a. sin city effect) on an image. We will use the application Acorn that comes pre-installed as part of the MLTI image, although you can achieve the same effect using similar photo-editing software such as Adobe Photoshop.

Find additional video tutorials at:

Google Apps Tip – Historical Imagery

Historical Imagery – Using Google Earth to see change over time

Historical Imagery is a fantastic, yet often overlooked tool found in the free application Google Earth. This tool allows the user to view a location on the planet at different points in time thanks to Google periodically updating its maps with newer satellite images.

To use, find and turn on the Historical Imagery button in the menu bar. This will display a timeline bar with several white marks spaced along it. Each mark represents a different satellite image taken at certain times. To see this tool in action, check out the MLTI Minute video podcast, episode #187: “Using Historical Imagery.”


  • This could be a great tool to use with students to show the impact and change of the landscape over time as a result of human construction projects within the last 20 years or so.
  • I’ve included two screenshots below of our middle school to show how the landscape has changed since its construction.


Middle School of the Kennebunks in May of 2010 and in April of 1998:

MLTI Minute: Text Substitution

MLTI Minute Podcast

Episode 163: Text Substitution

This podcast will show you how you can program your own text substitution and apply it globally to most Apps. installed on your Apple computer. The example in the podcast shows how to program the Mac to convert “LOL” automatically to, “That was quite a humorous statement.

This is a 3 minute video podcast, with audio directions provided as a guide and screencasting to provide clear visuals of the setup and configuration process.


How-To Tech Tip: MLTI Minute Podcast

MLTI Minute Podcast – “It will only take about a minute”

MLTI Minute is a set of video tutorials created by the MLTI Project Team showcasing a variety of tools and features provided to every student and teacher in the MLTI 1-to-1 Laptop Program. Tutorial topics range from tips to customize apps. to making better use of the Mac operating system to hardware performance tricks, all taking about a minute to watch.

You can subscribe to the podcast several ways:

How-To Tech Tip: Skype Around the World

New post from Lawson Labs:

“In this short video tutorial, you will learn how to download and install Skype to your MLTI laptop using My Apps and then connect with other classrooms around the world using Skype in Education.”


Find additional video tutorials at: