January 2012 – By @mhawksey

Integrating Google Spreadsheet/Apps Script with Google Refine to update existing spreadsheets

January 31, 2012

Working on some OER Visualisation Project work today I found I needed to get some additional information from an external web service for a Google Spreadsheet I was working on. I could have of course just used Google Apps Script, a native feature within Google Spreadsheets, to do a UrlFetch and get the information but […]

2 Comments

OER Visualisation Project: Visualising CaPRéT OER tracking data [day 32] #ukoer

January 30, 2012

In May 2009 JISC CETIS announced the winners of the OER Technical Mini-Projects. These projects were designed: to explore specific technical issues that have been identified by the community during CETIS events such as #cetisrow and #cetiswmd and which have arisen from the JISC / HEA OER Programmes JISC CETIS OER Technical Mini Projects Call […]

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

January 29, 2012

Here's some posts which have caught my attention this month: The Design Studio / Assessment and feedback – in the hands of the student – January 25, 2012 Convert a Bookmarklet to a Chrome Extension with a Few Clicks – January 24, 2012 Does Your Business Need Mobile Apps? Bizness Apps (& More) Give You […]

OER Visualisation Project: Timelines, timelines, timelines [day 30] #ukoer

January 25, 2012

Following on Day 20’s Maps, Maps, Maps, Maps the last couple of days I’ve been playing around with timelines. This was instigated by a CETIS PROD ‘sprint day’ on Friday where Sheila MacNeill, Wilbert Kraan, David Kernohan and I put our thinking caps on, cracked the knuckles and look at what we could do with […]

5 Comments

OER Visualisation Project: How is OER being socially shared – postscript [day 30] #ukoer

January 25, 2012

A quick postscript to day 24 of the OER Visualisation project where I looked at how individual Jorum UKOER resources were being, or as was the case, not being shared on social networking sites like Twitter, Facebook et al. I did a similar analysis on HumBox records and using my method it was a similar […]

2 Comments

Sending free SMS messages to students by mashing up Google Calendar notifications

January 22, 2012

Finding free ways to send and receive SMS messages is something I’ve covered before (Twitter Ye! Twitter Ye! Keep your students informed with free SMS text message broadcasts! and Free SMS voting using intelliSoftware SMS Gateway service). Browsing the Google Apps Script site I saw there is a new tutorial by Romain Vialard which lets […]

3 Comments

A way to archive and display Twitter hashtag chats

January 19, 2012

It’s interesting to watch the popularity of Twitter hashtag chat communities (like #uklibchat) grow. It’s also interesting to the number of different ways these chats are recorded from dumping/exporting a Twitter Search into a word or pdf doc to using tools like Storify to capture the highlights. If you organise or are thinking of organising […]

7 Comments

OER Visualisation Project: How is OER being shared – Quick look at Jorum and #ukoer Twitter archive [day 24]

January 17, 2012

This might be slightly off-topic for the OER Visualisation project, but I followed an idea, did – what I think are – some interesting things with an archive of tweets and thought I would share. This line of thought was triggered by a tweet from Terry McAndrew in which he asked: @mhawksey Have you a […]