Year: 2012

Converting blog post urls into MS Word documents using Google Apps Script #oerri

Outlining some Google Apps Script code I’ve written that takes some blog post urls and makes a downloadable html/.doc report

5 Comments

Experiment with interactive wordcloud of #smwgla Twitter community profile descriptions (making a JSON query on Google Spreadsheet data)

I should say this post contains a lot of technical information, doesn’t give much background and is mainly for my hard-core followers This is a very lose sketch of an experiment I might refine which uses Jason Davies wordcloud script (add-on for d3.js) as a way to filter data hosted in a Google Spreadsheet. I […]

Reshaping importHTML data in Google Spreadsheet using QUERY and TRANSPOSE formula

importHTML is a fantastic formula you can use in Google Spreadsheets, but did you know you can combine with QUERY and TRANSPOSE for more selective data import. Here’s how

4 Comments

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo

I came, I saw, I failed. This was a potentially promising hack that didn’t work out. Hopefully you’ll get as much benefit from failure, as from success. Today I can across oomfo (from the same makers as FusionCharts): oomfo is a plug-in for Microsoft PowerPoint that brings all the awesomeness of FusionCharts Suite XT to […]

6 Comments

‘Activity’ in the Twitter backchannel at #altc2012 day 1

The graph on the right is taken from a paper mentioned in Eric Mazur’s keynote from the first day of the ALT* Conference 2012. The paper, A Wearable Sensor for Unobtrusive, Long-Term Assessment of Electrodermal Activity (Poh, Swenson & Picard, 2010), reports the study of an experimental wristband which can record brain activity. Mazur used […]

5 Comments

IFTTT: IF I do THAT on {insert social network/rss feed/other} THEN add row to Google Spreadsheet

IFTTT is a web service that lets you do some basic plumbing between web services. Here’s a quick recipe for backing up RSS feeds to a Google Spreadsheet

3 Comments

Notes on Jorum’s 2012 Summer of Enhancements: SEO and OER #ukoer

Jorum (an OER repository) are undertaking a ‘summer of enhancements’. Having just contributed a chapter on OER Search Engine Optimisation (SEO) and Discoverability I have a look at part of this work through that lense.

3 Comments

Notes from the Twitter backchannel at eAssessment Scotland 2012 #eas12

On Friday (31st August) I was at eAssessment Scotland 2012. In a continuation of my analysis of threaded discussion in a event backchannel I have a quick look at eas12 and reveal a different pattern of communication which shows that the audience was in broadcast mode.

9 Comments

Google App Script: Scheduling timed triggers

I noticed a couple of search referrals around scheduling timed triggers in Google Apps Script so here is what I know and how to do it. Within Google Apps Script you can create basic time-based triggers (poor mans cron) to run functions on specific date/time intervals. Using the ‘Current Script’s triggers’ dialog (accessed from Script […]

2 Comments

What I’ve starred this month: August 28, 2012

Here's some posts which have caught my attention this month: Open Research Data Processes: KMi Crunch – Hosted RStudio Analytics Environment « OUseful.Info, the blog… – August 23, 2012 Monitoring Penguin Updates with Google Analytics – August 23, 2012 othervoices » Blog Archive » The Role of Libraries and Information Professionals in OER Initiatives – […]

« Previous Page — Next Page »
css.php