Google Apps Script – Page 15

Dev8Ed: Slides and video of short version of hacking stuff together with Google Spreadsheets

June 5, 2012

Last week was the latest event as part of DevCSI, Dev8Ed. As part of the event I put my name forward for a session on ‘hacking stuff together with Google Spreadsheets’. The session appeared to go down well as I was asked to repeat on the second day and along with Alex Bilbie’s HTML5/CSS3 session […]

2 Comments

Using Google Apps Script to Fast Track Student Feedback: Behind the code

June 5, 2012

Here is some text I prepared for a possible Google Apps Developer blog guest post. It doesn’t look like it’s going to get published so rather than letting it go to waste I thought I’d publish here

One Comment

Hacking stuff together with Google Spreadsheets: Fast Tracking Student Feedback System

May 25, 2012

In this example Google Apps Script is used to create a custom user interface that can be used in Google Spreadsheets, allowing tutors to enter feedback and grades based on individual assessment criteria pulled from a central data source (another Google Spreadsheet). The system then generates personalised feedback forms (Google Documents) based on the data and distributes them to students

5 Comments

Using Google Spreadsheets to dashboard project/course blog feeds #oerri

May 17, 2012

In this post I’ll show I’ve create a quick dashboard in Google Spreadsheets which takes a list of blog RSS feeds and filters for specific tags/categories. Whilst demonstrated this with the JISC OERRI projects the same technique could be used in other scenarios, such as, as a way to track student blogs.

6 Comments

Visual Analytics: Comparison of @SCOREProject and @UKOER (and template for making your own)

May 10, 2012

Lou McGill from the JISC/HEA OER Programme Synthesis and Evaluation team recently contacted me as part of the OER Review asking if there was a way to analyse and visualise the Twitter followers of @SCOREProject and @ukoer. Having recently extracted data for the @jisccetis network of accounts I knew it was easy to get the […]

5 Comments

Automatic translation of TAGS Twitter archives using Google Apps Script ‘Language’ services

March 24, 2012

A flare went up from Hamburg this morning from Tony Hirst who is at the Daten, Recherchen, Geschichten (2012) conference (#drg12) in Hamburg: Anyone know of twitter streaming search clients that run all tweets through language translation? — Tony Hirst (@psychemedia) March 24, 2012 Translating tweets is something I’ve dabbled with before as part of […]

4 Comments

Fast-tracking feedback: Google Apps Script user interface training material [Release 2]

March 18, 2012

Note: This is a personal post made outwith my current employment at JISC CETIS Back in May 2011 Tony Hirst looked at the Visual UI Editor For Google Apps Script and commented that he thought before long I would have posted something about it. Well almost a year later here’s what I’ve got for you. […]

3 Comments

Using Google Spreadsheets to combine Twitter and Google Analytics data to find your top content distributors

March 6, 2012

When you share a link on Twitter there are a number of services, like bit.ly, which allow you to track the impact of the url in terms of the number of clicks it attracts from other users. At the same time there are a number of ways to monitor people sharing links to your site, […]

21 Comments

Dev8D Introduction to Google Apps Script Session: This is what you’ll be making (well the start of)

February 15, 2012

Today at Dev8D from 3-4pm participants of my introduction to Google Apps Script workshop will be making the beginnings of a PostRank style social engagement tracker (example report embedded below). I’ll be releasing slides and code after the session (Slides here and full code here).