Category: Google

Using Google Spreadsheets as a data source to analyse extended Twitter conversations in NodeXL (and Gephi)

Having experimented with the Twitter API for a couple of years I’m familiar with a number of the limitations, particularly when it comes to the Twitter Search API. The biggest being the maximum number of tweets (1,500) and timeframe (last 7 days) you can extract in one go. This means that whilst tools like NodeXL’s* […]

6 Comments

Using the Viralheat Sentiment API and a Google Spreadsheet of conference tweets to find out how that keynote went down

Did you tune into into Donald Clark’s “Don’t Lecture Me!” keynote at ALT-C 2010 or were you at Joe Dale’s FOTE10 presentation? These presentations have two things in common, both Donald and Joe posted their reflections of a ‘hostile’ twitter backchannel (see Tweckled at ALT! and Facing the backchannel at FOTE10) and I provided a […]

14 Comments

Embedding .mp3 audio files into Google Sites

I was preparing this for someone else but thought I’d share here. Here’s how to embed a .mp3 audio file in Google Sites. On the page you want to embed audio enter edit mode and move the cursor to where you want the audio player to appear. Then from the Insert menu, at the very […]

10 Comments

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL

Moving away from social networks I wanted to discover how Brian Kelly’s UK Web Focus, Tony Hirst’s OUseful.info and my MASHe are linked together. I chose Brian’s and Tony’s blogs for this because they have highlighted my work in the past so I know I’ll get some data. The main reason for this exercise was […]

One Comment

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. I said: The advantage of NodeXL, particularly for graphing Twitter communities, is it has built-in features for grabbing the data for you. Not only that […]

3 Comments

Some Google webinars exploring Google Apps Script in Education

If your interested in learning more about Google Apps Script in Education Google are doing some webinars as part of their Google Apps for Education series. Here are a copy of the dates/times that were emailed to me (seminar are usually delivered in the afternoon American time so if it’s past your bedtime you might […]

My #eas11 world premier: Creating personalised Google Documents from Form submissions (and some other things)

Tomorrow (Friday 26th August) for my eAssessment Scotland 2011 workshop I’ll be doing a world premier extending the form submit sheet split example to let tutors create individual student Documents from submitted data (e.g. taking a sheet like this and at a click of a button produce this document. Update: Still some refinement in the […]

One Comment

And the most engaging OUseful.info post is…

This one Data Scraping Wikipedia with Google Spreadsheets … If you want to know how I arrived at this conclusion it’s mostly the same process as And the most engaging JISC Project is…, but as well as getting social bookmark/share counts I’m also counting the number of post comments (an important part of engagement). Here’s […]

And the most engaging JISC Project is…

[flickr]4814995807[/flickr] Recently I posted a Google Spreadsheet of all the live JISC funded project websites from the last 3 years. Not too long before that I also posted Google Spreadsheets as a lean mean social bookmark/share counting machine, which used Google Apps Script to query different social network providers for share/like counts for a specified […]

2 Comments

Open data equals open scrutiny but doesn’t always equal all of the answer

[flickr]64284665[/flickr] Last week I got frustrated at not being able to find some JISC funded project outputs, which was  a little annoying. This led to a small exploration around JISC’s Programme Information Management System (PIMS). The system was originally only available to JISC executive staff but made available to all sometime last year and used […]

4 Comments
« Previous Page — Next Page »
css.php