All information on Blogging to use this tag.


In the original JISC OER Rapid Innovation call one of the stipulations due to the size and durations of grants is that the main reporting process is blog-based. Amber Thomas, who is the JISC Programme Manager for this strand and a keen blogger herself, has been a long supporter of projects adopting open practices, blogging progress as they go. Brian Kelly (UKOLN) has also an interest in this area with a some posts including Beyond Blogging as an Open Practice, What About Associated Open Usage Data?

For the OERRI projects the proposal discussed at the start-up meeting was that projects adopt a taxonomy of tags to indicate keys posts (e.g. project plan, aims, outputs, nutshell etc.). For the final report projects would then compile all posts with specific tags and submit as a ms-word or pdf.

There are a number of advantages of this approach one of them, for people like me anyway, is it exposes machine readable data that can be used in a number of ways. 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 OERRI projects the same technique could be used in other scenarios, such as, as a way to track student blogs. As part of this solution I’ll highlight some of the issues/affordances of different blogging platforms and introduce some future work to combine post content using a template structure.

OERRI Project Post Directory
Screenshot of OERRI post dashboard

The OERRI Project Post Directory

If you are not interested in how this spreadsheet was made and just  want to grab a copy to use with your own set of projects/class blogs then just:

*** open the OERRI Project Post Directory ***
File > Make a copy if you want your own editable version

The link to the document above is the one I’ll be developing throughout the programme so feel free to bookmark the link to keep track of what the projects are doing.

The way the spreadsheet is structured is the tags/categories the script uses to filter posts is in cells D2:L2 and urls are constructed from the values in columns O-Q. The basic technique being used here is building urls that look for specific posts and returning links (made pretty with some conditional formatting).

Blogging platforms used in OERRI

So how do we build a url to look for specific posts? With this technique it comes down to whether the blogging platform supports tag/category filtering so lets first look at the platforms being used in OERRI projects.

chart1This chart (right) breaks down the blogging platforms. You’ll see the most (12 of 15) are using WordPress in two flavours, ‘shared’, indicating that the blog is also a personal or team blog containing other posts not related to OERRI and ‘dedicated’, setup entirely for the project.

The 3 other platforms are 2 MEDEV blogs and the OUs project on Cloudworks. I’m not familiar with the MEDEV platform and only know a bit about cloudworks so for now I’m going to ignore these and concentrate on the WordPress blogs.

WordPress and Tag/Category Filtering

One of the benefits of WordPress is you can can an RSS feed for almost everything by adding /feed/ or ?feed=rss2 to urls (other platforms also support this, I a vague recollection of doing something similar in blogger(?)). For example, if you want a feed of all my Google Apps posts you can use

Even better is you can combine tags/categories with a ‘+’ operator so if you want a feed of all my Google Apps posts that are also categorised with Twitter you can use

So to get the Bebop ‘nutshell’ categorised post as a RSS item we can use:

Looking at one of the shared wordpress blogs to get the ‘nutshell’ from RedFeather you can use:

Using Google Spreadsheet importFeed formula to get a post url

The ‘import’ functions in Google Spreadsheet must be my favourites and I know lots of social media professionals who use them to pull data into a spreadsheet and produce reports for clients from the data. With importFeed we can go and see if a blog post under a certain category exists and then return something back, in this case the post link. For my first iteration of this spreadsheet I used the formula below:

importFeed formula

This works well but one of the drawback of importFeed is we can only have a maximum of 50 of them in one spreadsheet. With 15 projects and 9 tag/categories the maths doesn’t add up.

To get around this I switched to Google Apps Script (macros for Google Spreadsheets I write a lot about). This doesn’t have an importFeed function built-in but I can do a UrlFetch and Xml parse. Here’s the code which does this (included in the template):

Note this code also uses the Cache Service to improve performance and make sure I don’t go over my UrlFetch quota.

We can call this function like other spreadsheet formula using ‘=fetchUrlfromRSS(aUrl)’.

Trouble at the tagging mill

So we have a problem getting data from none WordPress blogs, which I’m quietly ignoring for now, the next problem is people not tagging/categorising posts correctly. For example, I can see Access to Math have 10 post including a ‘nutshell’ but none of these are tagged. From a machine side there’s not much I can do about this but at least from the dashboard I can spot something isn’t right.

Tags for a template

I’m sure once projects are politely reminded to tag posts they’ll oblige. One incentive might be to say if posts are tagged correctly then the code above could be easily added to to not just pull post links but the full post text which could then be used to generate the projects final submission.


So stay tuned to the OERRI Project Post Directory spreadsheet to see if I can incorporate MEDEV and Cloudworks feeds, and also if I can create a template for final posts. Given Brian’s post on usage data mentioned at the beginning should I also be tracking post activity data on social networks or is that a false metric?

I’m sure there was something else but it has entirely slipped my mind …

BTW here’s the OPML file for the RSS feeds of the blogs that are live (also visible here as a Google Reader bundle) logo have put together a list of the 100 Must-Read Blog Posts on the Future of Learning:

With a struggling economy and a president with a keen eye on education, it will be interesting to see what happens to the future of learning with such opposing forces. Plenty of experts and lay-people alike have kicked around their ideas through their blogs. This collection offers 100 of these blog posts speculating on the future of learning.

Posts are categorised by:

  • online learning
  • technology
  • social connections
  • the future of educators and the classroom
  • about and from the students
  • libraries and learning
  • green education
  • vision
  • policy
  • education funding


Click here for the 100 Must-Read Blog Posts on the Future of Learning

The Times Higher Education (THE) has published an article reporting the rise of blogging by UK academics. The article focuses on the issues of academic freedom, highlighting several cases where staff have been asked to remove their sites from institutional servers or remove references to their employers.

There are some very interesting examples of how blogs are being used including the work of Cameron Neylon who "says he is the only academic in the UK keeping a full online laboratory notebook ... from the weight of his chemicals to the results of his experiments". Visit Cameron's Sortase Cloning blog here.

The THE article also includes a selection of the most popular UK academic blogs. The article in full is available here.

This post comes via Seb Schmoller's Fortnightly Mailing. Seb highlights a post detailing the processes a small company uses to overcome 'inbox overload' and effectively manage projects using wikis, blogs and instant messaging. You can read the full post by Anand Rajaraman here.

Does your service/department use blogs or wikis? If you do and your blog/wiki is publicly accessible we would like to hear about it. You can use this contact form to provide details.

Image: Light Load by triplefivedrew from Flickr used under Creative Commons

If you are interested in micoblogging services like Twitter you may be interested in Edmodo. Edmodo described themselves as:

a private microblogging platform that teachers and students can use to send notes, links, files, alerts, assignments, and events to each other. Teachers also have the ability to mark any post from their classes as public to share with the outside world. You can also create private groups for you and your colleagues to collaborate. It's free & simple to use!

Visit for more information