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

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

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

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

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

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.

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

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 […]

Generating an OPML RSS bundle from a page of links using Google Spreadsheets

A post demonstrating how you can generate a OPML RSS bundle from a webpage containing a list of blog urls

Google Docs defaults to searching for Creative Commons licensed images. Great, but could they do better?

A feature of Google Docs I wasn’t aware of, that the Insert Image Search automatically filters for Creative Commons released pictures

Revisiting: Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline

Another look at feeding the Timeline tool developed by Verite using media extract from tweets by Topsy. This time the spreadsheet template is designed to be more flexible so that anyone can use it.

Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline (my contribution to @Arras95) #arras95

Update: New version of this spreadsheet template here There’s a new kid on the block if you are considering an open source timeline tools. For a long time the Simile Exhibit Timeline tool has been the tool of choice appearing in places like Freebase.com (click on Timeline in this page to see a history of […]

Notes on extracting the JISC CETIS twitter follower network

As recently mentioned on Sheila’s work blog the way the @jisccetis twitter account is evolving. Up until recently this account was used as a broadcast channel, pushing out latest news to followers and not following back. This was balanced by members of staff having personal twitter accounts, engaging with the community. As with any community […]

Turning Google+ Search results into a RSS feed (for Google Reader)

In Using Google Reader to create a searchable archive of Twitter mentions Alan Cann commented: Subscribing to RSS feeds in Google Reader is my bog standard way of archiving Twitter feeds. Now to figure out how to get an RSS feed from a Google+ hashtag… Lets look at how it might be possible. So there’s […]

Next Page »
css.php