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.
So the folks over at Google Blogoscoped had a great idea. Use Google trends as a writing prompt. For instance, if the top queries are … 1. subaru impreza 2. priyanka chopra 3. build a bear … and so on … … then your narrative may go like this, to quote from Simon’s try: I went out and bought a brand new Subaru Impreza last week, which was very scary as I have only just passed my test. I took Priyanka Chopra, the Indian film star, with me to keep an eye on me and exert a calming influence as I was pretty nervous because the Impreza is wild beast of car. “Let’s go build a bear”, I shrieked as we weaved through traffic, “an actual live bear that will do our bidding”. “Good idea,” agreed Priyanka, “This bear could drive us around too, anything would (and so on) … Morphs pretty well into a fun writing prompt that uses subjects that are, by definition, things people are interested in. Ways to take it to the next level- write the zeitgeist as a character or historical figure use the words to take the pass the sentence game to the next level see who can make the longest sensible sentence with the fewest additional words (not listed in the trends list) […]
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 […]
This script allows you to setup a Google Form that adds events to a calendar. It’s useful. You’d make your form first and calendar. Then you’d adjust it to reflect your particular column order and calendar ID. Finally, you’d add the script to your Google sheet (where the form submissions end up). [Edit] You’ll also want to set your script trigger to run on the submission of the form. While in script editor, you’ll see a little clock icon. Click it and add the trigger so that the function runs on form submission. That’s about it.