# 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](https://hawksey.info/blog/2010/06/using-google-spreadsheet-to-automatically-monitor-twitter/) to archive tweets and since not only have I been evolving the code I’ve been creating tools which use the spreadsheet as a data source. It’s pleasing to see these tools being used for a wide range of projects from [citizen journalism](http://www.vikalpa.org/?p=13043), to a long list of academics, students and community groups, and even [TV broadcasters](https://hawksey.info/blog/2012/01/twitter-archive-tagsv3/comment-page-2/#comment-65898).

I’ve been a little remise in posting some of the latest developments and I’ll have to cover those soon. For now here’s your [\#jiscel12 Twitter basecamp](https://docs.google.com/spreadsheet/pub?key=0AqGkLMU9sHmLdEwybjliY0d0T0RTZEFxNHBpbGJZSmc&gid=116).

## Overview of features

 [![#jiscel12 Twitter basecamp](https://hawksey.info/wp-content/uploads/2012/11/image6.png "#jiscel12 Twitter basecamp")](https://docs.google.com/spreadsheet/pub?key=0AqGkLMU9sHmLdEwybjliY0d0T0RTZEFxNHBpbGJZSmc&gid=116)

Whilst I probably just looks like another spreadsheet you should explore:

### A. The ability to easily filter archive by person

[![The ability to easily filter archive by person](https://hawksey.info/wp-content/uploads/2012/11/image7.png "The ability to easily filter archive by person")](http://hawksey.info/tagsexplorer/arc.html?key=tL2n9bcGtODSdAq4pilbYJg&screenname=loumcgill) 
\[Still need to document\]

### B. The TAGSExplorer conversation overview

[![TAGSExplorer conversation overview](https://hawksey.info/wp-content/uploads/2012/11/image8.png "TAGSExplorer conversation overview")](http://hawksey.info/tagsexplorer/?key=0AqGkLMU9sHmLdEwybjliY0d0T0RTZEFxNHBpbGJZSmc&sheet=oaw&mentions=true&retweets=true) 
\[[TAGSExplorer: Interactively visualising Twitter conversations archived from a Google Spreadsheet](https://hawksey.info/blog/2011/10/tagsexplorer-intro/)\]

### C. The entire searchable/filterable archive

[![entire searchable/filterable archive](https://hawksey.info/wp-content/uploads/2012/11/image9.png "entire searchable/filterable archive")](http://hawksey.info/tagsexplorer/arc.html?key=tL2n9bcGtODSdAq4pilbYJg) 
\[Still need to document\]

### D. The question and answer filter

[![question and answer filter](https://hawksey.info/wp-content/uploads/2012/11/image10.png "question and answer filter")](http://hawksey.info/labs/tweetQ.html?url=https://script.google.com/macros/s/AKfycbz43CMjZloY7N-g_T0RCcLqt3lnei1rrgSJUlhf17CZWcOdxnqV/exec&title=%23jiscel12) 
\[[Any Questions? Filtering a Twitter hashtag community for questions and responses](https://hawksey.info/blog/2012/10/filtering-a-twitter-hashtag-for-community-questions-and-responses-situational-awareness/)\]

### Dashboard

[![image](https://hawksey.info/wp-content/uploads/2012/11/image11.png "image")](https://docs.google.com/spreadsheet/pub?key=0AqGkLMU9sHmLdEwybjliY0d0T0RTZEFxNHBpbGJZSmc&gid=117)\[Contains a number of summaries – I find ‘most RTs in last 24hrs’ one of the most useful (how this works also need documenting\]

Currently these are automatically updating every hour, but I’ll probably crank up the frequency next week. Your thought on these always gratefully received ;)