Last week I spoke to 70 members of local women’s group about how they could potentially use iPhone’s and iPad’s in useful ways in their lives as retirees. As I made a list of apps and use cases for my presentation I thought about how much I’d miss my iPhone if I were forced to give it up, and remembered a story that my father used to tell about a Yankee Clock Peddler. The story goes like this…
The Yankee Clock Peddler and his travelling companion start out on a sales tip in a rural area, and they stop for the night at a farmer’s house. In the morning before leaving to make sales call in neighbouring communities, the clock peddler asks the farmer if he’d store a clock for him for a couple of weeks, and that he’ll pick the clock up on his way back home. The farmer agreed to this, so the Peddler wound up the clock and placed it on the farmer’s wall before leaving (the farmer does not yet own a clock). When out of ear shot, the traveling companion asks the clock peddler why he left the clock at the house. Didn’t he want to sell the clock on the trip? To this the Yankee Clock Peddler replied, “don’t worry, by the time I come back in a couple of weeks, the clock will be sold… the farmer will happily buy it from me.”
The moral of the story is: “We can do without any article of luxury we have never had, but when once obtained, it is not in human nature to surrender it voluntarily.”
I’m often asked by people who have just purchased a new iPhone or iPad what apps they should get for their new device. Right now this is what I’m recommending:
Kindle & iBooks – The Kindle and iBooks readers are the only apps you’ll probably need for reading books, and PDF files that people email to you. Both Do are excellent eBook readers, but books typically cost less in the Kindle store. On the other hand, I’ve found it much easier to get PDF files into the iBooks reader, so you’ll want to have both installed on your device. Don’t waste your time on the Kobo reader.
Zite & Flipboard - Zite is a free personalized magazine for your iPad that automatically learns what you like and gets smarter every time you use it. Flipboard on the other hand had a little bit slicker interface than Zite, but it does not learn your likes and dislikes as you read over time, but stick with the sites and categories you’ve chosen to read. I’d try both out to see which you like better.
Facebook & Path - Almost everyone is on Facebook now, and if you are, you should install the Facebook app. The user experience using the app is much more responsive and polished than the mobile web browser interface. You might also want to try out Path. Path allows you to post through to Facebook if you choose, or limit your posts to other Path users. If you try it, I suspect you’ll like it.
Evernote - An excellent tool for capturing, syncing data between your desktop and cell phone. I love the ability it gives me to take a picture of a white board, and then later do a key word search on the text that Evernote has OCR’ed for me. I like to call it my “external brain”.
Why would someone use an web based word processor for a school paper instead of Microsoft Word? Here are three reasons:
When collaborating with classmates on a group project, do you get tired of trying to figure out which of the versions that have been emailed to you is the most current?
Do you get discouraged when you are faced with the task of merging edits from 2 or more students into a single document near the end of the group project?
Do some of your edits get lost in the group collaboration email shuffle?
If you’ve said yes to any one of the questions above, then you should take a serious look at using either Google Docs or Microsoft Word Web App for your next group project. That said, here are a few things to keep in mind as you being to collaboratively create and edit documents on the web:
While the look and feel of Microsoft Word Web App is very similar to the desktop version of Word, you cannot add or edit footnotes, end notes, or tables of contents in the online version of Word. You can connect to the file from your desktop version of Word to add and edit those elements in your group document however (on a Mac you’ll need Mac Office 2011 to do this).
Google Docs supports foot notes, end notes and tables of contents in the web browser, but the editing interface is not as rich as the desktop version of Word. For some people this is not a problem. For others it is a show stopper. You can decide for yourself.
In any case, if you need to collaborate on a document, don’t just reflexively email it to your collaborator, instead think about writing it in Google Docs and sending them a link and leave the email document shuffle behind.
Spreadsheet of Data + Google Docs Pivot Tables = Reporting Jedi Master
Pivot tables are the quickest and easiest way to get useful information out of spreadsheets of data… especially large spreadsheets of data. Google Docs makes using pivot tables quite easy if you’re familiar with spreadsheets. Let’s say you have a spreadsheet of conference attendees with contact information along with the sessions they registered for, and the date that they registered. Using a pivot table you could quickly find out if there is a correlation between the people who registered for the “how to get organized” workshop, and how early people registered.
You could also quickly determine how many people attending the conference are out of Province (or State). I’ve just scratched the surface; it’s truly amazing the information you can glean for playing around with a pivot table and a data set. I first used pivot tables over 10 years ago while working at at Westech Building Products, a manufacturing company, and they were invaluable when analyzing production and sales data.
Take a look at the following 1.5 minute video for an excellent overview. Happy spreadsheeting!
How to sync and edit documents from my desktop computer on my iPad is a question that I’ve had ever since I purchased my iPad in April of 2010. The good new is that I finally have a good answer, and ironically the apps that facilitate the editing and syncing are ones that I’ve used for years now, one of which has just recently come to the iPad and iPhone… or at least recently came to my attention. Here’s the equation:
Dropbox + Documents To Go = iPad Document Nirvana!
Here is what you need to turn your iPad into a document editing & syncing machine:
Step 1: If you don’t have a free Dropbox account already, then now is your excuse to finally download and install it on your desktop computer(s). Dropbox is a cloud service that synchronizes files between your computers, and keeps them up to date. It runs on Mac’s, Windows & Linux. For example, I have dropbox running on my Mac laptop and Windows desktop computer. So when I save a file to my Dropbox folder on my desktop computer, that file gets save to my account on the dropbox server on the internet. The next time I turn on my laptop, it checks to see if any files have changed, and then if they have, download the changed files to my laptop. It is a wonderful service if you use more than one computer (or computer & iPad/iPhone). The use of Dropbox is free for up to 2GB of data, and then $10 per month (for $99 per year) for 50GB of data. I personally subscribe to the 50GB plan because I store all my family photos there along with all my documents, but I digress.
Step 2: Install the free Dropbox app on your iPad (or iPhone, or Blackberry, or Android phone if you have one) via the Apple App store. Enter the same user name and password that you setup your Dro
pbox account with on your desktop computer.
Step 3: Again via the Apple App store, and install Documents To Go Premium – Office Suite. Make sure you get the “Premium” version for $16.99, as the basic version does not sync files with Dropbox (or Google Docs). Once you’ve installed the app, press the “Online” button on the bottom nav bar, and then the app will ask you what type of account you want to synchronize with. Select Dropbox, enter your account information, and you set.
That’s it! You’ve now turned your iPad into a legitimate business machine so that you can word process & spreadsheet on the go, and sync everything back to your desktop computer. Enjoy!
Do YouTube and Facebook distract students? Of course they do! On the other hand, can YouTube and Facebook help students with their school work? Until recently I wasn’t sure, but after my partner’s experience with a professor who wasn’t a good teacher, and seeing how YouTube and Facebook saved her and her classmates from poor grades, I’m convinced that these “digital distractions” can be, if used intelligently, excellent Learning Tools.
Being the father of two teenagers, the husband of a partner that has recently gone back to college, and Systems Administrator at a University Law Library, I have a front row seat on how technology is used and abused in the service of homework, research and education in general. When my partner found herself in a college class teaching challenged professor, I was amazed at how she, along with her classmates, used technology to compensate for the poor classroom instruction. Her learning process for each class was as follows: Read the rest of this entry »
Can iPhones and iPod Touches be more than just a distraction for students, but actually help you with your home work and research? Below are some apps that can help turn your mobile device into a tool for better grades. I’ll start off with some serious apps, and move to a handful of less serious tools that show the potential of mobile apps in the future. Read the rest of this entry »
It is one thing to talk about collaborative document editing, and quite another to see it in action. I use this feature every other week to organize rides to away games for my son’s soccer team. Anyone on the team who needs a ride goes to the online spreadsheet I’ve setup, and signs up for a ride. A simple time saving device.
A colleague of mine asked me yesterday what tools I’d recommend for a group of a dozen or so scholars spread around the world to collaborate on a scholarly project. The good news is that there are lots of good tools available for people to use. The bad news is that there are lots of good tools to choose from. Depending on your group’s particular requirements and preferences, you may choose a different tool set than your colleagues down the hall.
That said, here are my primary and secondary recommendations for collaborative tools, along with some rational for my selections: Read the rest of this entry »
Google just released it’s own URL shortener to compete with Bit.ly. Goo.gl has most of the features that Bit.ly brings to the table, but has a couple of extra features that I am very interested in.
Along with creating very compact URL’s, Goo.gl also generates a QR code for every URL that you shorten. If you see a Goo.gl URL you want a QR code for, all you need to do is to add a “.qr” to the end of the URL, like magic a QR code will appear. If you are creating QR Code for a large number of web pages, this is going to be a real time saver.
With Google putting it’s weight behind it’s own URL shortener, I have a lot more confidence that it is going to be around 2 or 3 years from now.
Last week I spoke to 70 members of local women’s group about how they could potentially use iPhone’s and iPad’s in useful ways in their lives as retirees. As I made a list of apps and use cases for my presentation I thought about how much I’d miss my iPhone if I were forced to give it up, and remembered a story that my father used to tell about a Yankee Clock Peddler. The story goes like this…
Pivot tables are the quickest and easiest way to get useful information out of spreadsheets of data… especially large spreadsheets of data. 
Step 2: Install the free 
