A Clearer Google Docs Revision History View
It’s a bit awkward to see who did what in a Google Doc via the version history. That’s something faculty often want to do.
The easiest path I found was to name the oldest and newest versions. Then click to show only named versions. That does it pretty well. The video above shows it with more detail.
Talking to Bud the other day he mentioned that generating the citation page for his digital stories was something of a pain. I’ve thought about it a bit since then and decided to try to simplify a workflow for this. Odd thing I learned – – CHAR(10) is the official way to get line breaks in Google Spreadsheet formulas. Flickr to Diigo to Google Spreadsheets Initially, I looked at the Flickr galleries because that’s the option that Bud normally uses. I saw that the gallery was in a standard HTML list format and I had some hope. Google spreadsheets lets you pull lists and tables like these in via the IMPORTHTML function. Martin Hawksey has some good instructions and examples over here. So that failed but I could import just about every other list on the page. So, I decided doing this through Diigo would make pretty decent sense for a number of people. Assuming you choose a unique tag for the images you plan to use- this example just uses “flickr”, I’d suggest something story/movie specific. So the basic Diigo URL you’d get is https://www.diigo.com/user/bionicteaching/flickr. Trying to make this really easy for people, I set up the first page to allow you to paste that URL in and our friendly formulas transform it into https://www.diigo.com/rss/user/bionicteaching/flickr. The example linked here […]
Google spreadsheets now lets you share editing by sending out a custom form. This is a huge deal. No, really. Huge. It solves so many problems I see happening all the time in schools. This is such a great way to get large amounts of information from all sorts of people of varying technical skill levels so you have it one place to manipulate. No need for the hassle of Adobe PDF and the complications of those forms or the need to create custom web forms of various types. It’s free and dead simple. I’m going to use it to collect testing information on programs for our upcoming Vista move. Previously, I was going to use cforms ii (awesome WordPress plug in by the way- especially if you need to fully customize the CSS- see an example I did for the NSDC here– it is real so don’t fill out fake info please). But there’s no real easy way to share that information. You could give people the password to the blog but that’s no always a good thing and the information that’s there is really just for looking at or exporting. I wanted something more dynamic. I think you could write some custom php pages and pull the info out but that’s a hassle and it takes time. I […]
Manuel, the young shrimp-picker, five years old, and a mountain of child-labor oyster shells behind him. He worked last year. Understands not a word of English. Dunbar, Lopez, Dukate Company. Location: Biloxi, Mississippi. (LOC) flickr photo by The Library of Congress shared with no copyright restriction (Flickr Commons) While I don’t want our five year olds being put to work, I can’t help but think we treat them terribly in the other direction. Anyway, on with the show/boring tutorial-ish thing . . . I had a site we used for the Great VCU Bike Race course that’s been sitting around. I knew it had lat/lng data for lots of urban bicycle related posts. My goal was to get it into Google Maps via the REST API. Get Custom Field in JSON By default you won’t see custom field data in your JSON endpoints. There are some plugins to make that happen but I wanted to take a stab at doing it myself. Given the documentation, it was pretty trivial.That means I didn’t white screen the test site or get critical errors on my first attempt. The code below in a plugin or the function.php file would make the lat_long custom field show up in the post JSON. Using this URL, I can get the 30 most recent posts.It’s important to […]