Category: Google Sheets

#LAK13: Recipes in capturing and analyzing data – Twitter

I’m enrolled on the Learning Analytics and Knowledge (LAK13) which is an open online course introducing data and analytics in learning. As part of my personal assignment I thought it would be useful to share some of the data collection and analysis techniques I use for similar courses and take the opportunity to extend some of these. […]

5 Comments

Twitter Archiving Google Spreadsheet TAGS v5

For a couple of years I’ve been sharing a Google Sheet template for archiving searches from Twitter. In September 2012 Twitter announced the release of a new version of their API (the spreadsheet uses this to request data from Twitter). Around the same time Twitter also announced that the old version of their API would be switched off in March 2013. So here is a new version…

352 Comments

Registering blog addresses and generating a OPML file (Notes on FeedWordPress and MOOC-In-a-Box)

Last week I got a number of enquiries about using Google Forms. One of these was a question from Martin Weller (OU) who is in the process of setting up H817 which is an Open University open course (MOOC) on Openness in Education. He asked: how do I go from this [Google Form] to an […]

4 Comments

Analysing WordPress post velocity and momentum stats with Google Sheets (Spreadsheet)

Like other wordpress.com and self-hosted wordpress blogs using Jetpack I got my annual report. This left some questions about the posts made later in the year that hadn’t had time to collect views so I’ve created a Google Spreadsheet template which reveals some more answers.

2 Comments

Dashboarding activity on public JISCMail lists using Google Sheets (Spreadsheets)

I’ve written a very long blog post which I’ll publish soon on text-mining public JISCMail (Listerv) lists using OpenRefine. It concludes with displaying list activity, posts over time and individual activity. The technique I used isn’t straight forward but as the output might be of benefit to other people like Brian Kelly who reported the […]

3 Comments

TAGSExplorer now includes filterable/searchable archive

At IWMW12 I made a searchable/filterable version of TAGS Spreadsheets. This feature lets you use the Google Visualisation API to filter tweets stored in a Google Spreadsheet (more about TAGS). It has been available via a separate web interface for some time but I’ve never got around to publicizing it. As TAGSExplorer also uses the […]

The most comprehensive aggregation and visualisation of #jiscel12 tweets

It’s here folks. The most advanced aggregation and visualisation of tweets for the JISC Innovating e-Learning 2012 online conference taking place next week. Over two years ago I started developing a Google Spreadsheet to archive tweets and since not only have I been evolving the code I’ve been creating tools which use the spreadsheet as […]

8 Comments

Feeding Google Spreadsheets: Exercises in using importHTML, importFeed, importXML, importRange and importData (with some QUERY too)

In this post I work through some exercises in using the importHTML, importFeed, importXML, importRange and importData formula available in Google Sheets/Spreadsheet. As part of this I show how you can reshape data to make your own charts.

22 Comments

CFHE12 Week 2 Analysis: Data! Show me your data and I’ll show you mine

What data is available around CFHE12? In this post I look at data feeds available from CFHE12, see what we can get and suggest some alternative ways of getting the data and pulling it in to other services for analysis. Finally I highlight the issues with collecting participant feeds filtered by tag/category/label

One Comment

Converting blog post urls into MS Word documents using Google Apps Script #oerri

Outlining some Google Apps Script code I’ve written that takes some blog post urls and makes a downloadable html/.doc report

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