Ad - leaderboard

Wednesday, November 25, 2009

Things I have learned about Google Docs and DropBox

Ok, I think this is the cat's meow. But I'm running into trouble with a few Gotcha's while building a "cloud based" course management system.
  1. Hyperlinks in Spreadsheets. Outlines could be in Google Spreadsheets but links must occupy an entire cell and so it's not as pretty as in Google Doc.
  2. Inserting a Spreadsheet in a Site. Requires a set minimum length example 600 pixels. It seems to adjust anyway, regardless of the size of the spreadsheet.
  3. Tables in Docs. Column size is controlled in HTML only. So get it right before you paste.
    Can I adjust the size of individual columns and not the entire table?
    ... an article on how to insert a table into a Google Site and then remove the borders. This will require you to edit the HTML so if you don't feel you want to do that you will still have the borders. Source
    Google Sites - Advanced Tables (steegle.com)
  4. Attachments to Site. You can attach just about anything, but if you value your time and sanity, group your documents in compressed folders and upload them.
  5. Drop Box.
    Files and zip folders can have a public link, but not folders. Example:
    http://dl.dropbox.com/u/2245004/460-056__Fichiers%20de%20travail%20-%207811.zip
    Network drives cannot be used by dropbox directly.
  6. Drop Box. When working online 200KB ZIP folder takes about 30 seconds to download. Any given course can reach 5 to 10 MB. Then a quick unzip, then open in folder and copy to USB. Way too many steps unless you have no choice. Perhaps a local link and a web link would be more useful.