Category: Google Sheets

Exploring Google Analytics event tracking to validate MCQs with options for advanced cohort analysis

An exploration of Google Analytics as a way for collecting and analysing responses to multiple choice questions. This post highlight the new advanced segmentation within Google Analytics and addresses how data can distributed and analysed in separate tools

2 Comments

Google Spreadsheet: How to compare two strings and highlight the differences

How to compare two strings character by character in Google Spreadsheets using Google Apps Script or built-in Google Sheet formula

One Comment

How to open a Google Spreadsheet at a specific row for editing

This was the question that came in over the wire this morning. The solution … switch to Google Sheets List view

5 Comments

Using Google Spreadsheets as a Google Analytics Data Bridge

Access control to Google Analytics data is very coarse. Via the web interface you can have full access or none at all. Given the growing interest in data driven decision making at all levels of the institution I thought it would be beneficial to demonstrate how Google Spreadsheets and Google Apps Script could be used to selectively distribute Google Analytics data. This solution was developed for my session at the Institutional Web Managers Workshop 2013 (IWMW13) which I talk about in more detail at the end of this post.

6 Comments

Punchcard charts in Google Sheets/Spreadsheets (querying Google’s plan to drop gadgets)

Quick look at generating a punchart chart in Google Spreadsheets. The data shaping is straight forward but limited chart options give questionable results

One Comment

#ocTEL Using Google Spreadsheets for a basic analytic to find your fledgling bloggers

One of the nice things about open courses like ocTEL is whilst having your own blogging space wasn’t a mandatory requirement we were aware that a number of participants had setup one up anyway. Conscious that activities like blogging can be very lonely and also aware that this is often a critical moment in motivating […]

2 Comments

Sankey your Google Spreadsheet Data #d3js

“Sankey diagrams are a specific type of flow diagram, in which the width of the arrows is shown proportionally to the flow quantity.” In this post I introduce a basic wrapper to render data from a Google Spreadsheet with a d3js generated sankey diagram

One Comment

#LAK13: Recipes in capturing and analyzing data – Google Groups Dashboard using Yahoo Pipes (no code)

As part of LAK13 I’ve highlighted a couple of ways to extract data from Canvas. Prompted by a question by On and my colleague Sheila MacNeill I wanted to show you a way of getting feed data into a spreadsheet without using any code. The solution is to use Yahoo Pipes, but as this post will highlight this isn’t entirely straight forward and you need to be aware of several tricks to get the job done.

4 Comments

#LAK13: Recipes in capturing and analyzing data – Using SNA on Canvas Discussions with NodeXL (for when it’s not a SNAPP)

In this post I’ll cover three main areas: a very quick introduction into techniques/opportunities for analysing threaded networks using SNA; how I retrieved data from the Canvas platform for the #LAK13 discussions; and finally some analysis using the NodeXL add-on for Microsoft Excel (Windows).

4 Comments

#LAK13: Recipes in capturing and analyzing data – Canvas Network Discussion Activity Data

For this post I want to start looking at what’s available around the Canvas Network platform which is being used to host Learning Analytics and Knowledge (LAK13). Ignoring the official API for now I’ve had a quick look at what you can do with the Discussions atom feed.

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