flickr photo shared by CraigMoulding under a Creative Commons ( BY-SA ) license Just two little functions in Google Sheets that came up as we tried to quickly pull comments from a blog for some other work. It was an odd scenario but the techniques should have other useful applications. IMPORTFEED The function below pulls […]
Read More… from Google Sheets Love – REGEXEXTRACT & IMPORTFEED
I thought I’d take a stab at using Google Script to capture Instagram data after being inspired by all the great Martin Hawksey has done with the TAGS Explorer. I’m doing something very similar and it turned out to be fairly straightforward to take the PHP I’d written previously and turn it into something that’d […]
Google sheets can do some neat tricks. Here’s how you can generate a chart of unique words submitted and their counts. The form for collecting a single word. Loading… The formula to paste in column C. All credit to this Stack Overflow post. =QUERY({B:B,B:B},”select Col1, count(Col2) where Col1 != ” group by Col1 label count(Col2) […]
creative commons licensed ( BY-NC-ND ) flickr photo shared by Bramus! We’re playing around with some online content for instructors to access on their own or to use as part of some guided online learning we’ll be doing. We started the building some elements around search because it is a place where most people are […]
I have to figure out a rather unpleasant and boring thing. I am, however, learning some fairly odd and interesting tricks as a result. This is one that might be useful to someone. Google Forms You can pre-fill Google form entries with a URL. That might be useful if you had 720 students in groups […]
Making shareable (Sharing with a single person or specific group but not with the world.) comments on public writing is a fairly awkward spaaaaaace right now. There are things like AnnotateIt and Awesome Screenshot and the annotations in Diigo. So I’m looking around for other free options and brain storming odd ideas and not find […]
I often want to know just a bit more about numbers I see in tables. As I was looking at some thing today, I stumbled on the Wikipedia page for “List of Most Viewed YouTube Videos“. After being more than a bit amazed at the utterly staggering numbers. I wanted to know what they translated […]
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 […]
Read More… from Citation Workflow – Diigo/Pinterest to Google SS
It seems like the widget that allowed you to embed Google Earth tours (with audio and motion) online isn’t working. We had at least one person in the county who wanted to be able to do this because they’d seen this Jimmy Buffet tour. Compared to teacher assessment and other bottomless problems this seemed pretty […]
Just a quick proof of concept for a session I’m doing at VSTE. I’m trying to show how you can use most things in all sorts of ways despite what they were intended to do. Apparently the example Google put out for this way back when actually used choose your own adventure to demo the […]
Read More… from Google Form as Choose Your Own Adventure Tool