How to Measure User Experience Using Google Docs

When looking through Google Docs, teachers try to find out our students’—the end users—experience or  level of engagement. 

What are the constraints and how does it affect the end users? Watch this podcast to find out.

Video Highlights

0:00:01 What do you look for when measuring Google Docs usage?

Transcript: How to Measure User Experience Using Google Docs

Download PDF Transcript

Mike: All right. So, you’re measuring your Google Docs usage; maybe a drive if you’re using Office. You’ve got some reporting metrics around that for your Office 365. And you know, Blake, if you’re just looking at your own serviceI’m sure you’ve got somewe would be able to pull some metrics on that.

What do you start to look at next?

Blake: Well, I thinksort of, almost, before you, at the same time, you’re looking at Google Docsyou also want to be looking at what is the experience of the users. Like, one of the big problems of, you know, going to Google and cloud-hosted services is, that it does create a bit of a strain on your networking.

If you are starting to use YouTube a lot more, or, you know, collaborating on documents with the images in them and sharing stuff on drive and downloading and uploading, I mean, what’s that going to do? That’s going to hurt your Internet connection. And that’s one of the big complaints that we hear. You know, what about our Internet? You know, how is that going to cope? And that’s a very good question. How is that going to cope? So, we need to get some data around it. And we need to set a baseline and then figure out how it is coping. And, at the same time, we want to know that when we’re accessing Google, when we’re accessing your student-management systems, like compass or sector, if they’re cloud-hosted ones; they are operating at that relative speed as well.

So, what we do with a lot of schools is, helping them with their black box. I actually got a shell of one here. It’s a little box, like this, where we plug into the network port here, and basically it will sit on the network and do a probe on certain Internet services, depending on whatever was setup. For us, we look at Compass, we look at Google. We look at a whole range of services and then we sort of graph that out into a Google spreadsheet. I can show you what that looks like, to give us a better understanding of what the experience is like for a user on the network.

Because a lot of Internet monitoring graphs goes, “Oh, that’s fine, I can monitor our Internet. That’s easy.” You know, I’ll look at the graph on the router and it says, “We’re doing 18 megs a second. And we got a 100 meg Internet connection, so we’re fine. Well, the reality is that: That’s the amount of through-put you’re putting through the network. That’s not the experience that someone is having on the network.

So, one of the things we do with this box, this Intex box as we call it, one of the things we do with that is, put this box in the schools’ network and try and get out to those services at the very same time that everyone else is trying to get out to those services. And then we say, “Okay, now what’s really going on?” Are we seeing that there’s severely server problems before lunch? Or, you know, whenever I leave for the day, everything goes quick again? You know, if we’re seeing a load like that, then we want to start to address the Internet connection.

So, I’ll show you the graph of that now.

Mike: Yeah, that will be great.

Well, should mention we’ve done a little bit of work together on just trying to pull together ideas like this for schools. And, so, if this is of interest to you, I’m more than happy to help you out and get you a black box going in your school.

Or, we’re actually running some Google apps, Admin-consult training on the second of June. So, if you’d like to sit in with us for an hour and just work out how do you really use your Google Admin consult, then we’ll put the link to that in the show notes as well.

Blake: Yeah, cool.

So, this is the example of the Intex box. All it does is, it basically pumps a line into a spreadsheet. And we administer all these through another spreadsheet exactly how we set it up. But what it will do is put a line in here and test and test for office, schools, office 365. It tests that Compass login and then tests that upload. So, you know, we’ve got Chrome Books a lot. So, a lot of things are being uploaded as well as downloaded. So, we use a little service where we just push a little image up there and we see how long it takes to push up there.

So, what that does is then, you know, every 15 minutes it does it again and again and again. And you’ll notice every now and again, it will do it one after the other. You know, it will do it a minute later. The reason that happens, and we see that here, is rapidly went up. So, it went from 109 milliseconds to 2000. If that happens, it does a check straight away again to see if that was an anomaly or that was for real. So, it’s got a little bit of an arrow checking in there. And then what we do is, we just use Google Spreadsheets and we just work with it.

We can see during the holidays, we had a bit of network maintenance. So, it went offline. But if I just zoom in here, you can start to have a look at these services that we use at the school and how they operate throughout the term. So, this becomes very clear, down to the days the people are here and not here. You can see that’s a Saturday, Sunday—things are pretty quietand we start seeing these spikes and these losses and the speed go up. But this is actually really great, because now I can dive even deeper. I can pull that right in and have a look and say, “Well, you know what? You know, is the blue one all the way down here, like Google is causing us no problems. It’s basically flatlining it.

You know, 100 or 93 and other services, like Compass, when we use it throughout the day, are really slow. Like, that’s to load the entire page of Compass, after you’ve logged in. And that takes 15 seconds, so that’s something we need to take up with Compass. That’s not our Internet connection. If we see all those lines move at one timewhich I don’t think happens on our networking, reallybut if all those lines move up at the same time, and all the services get slow, then we know that’s an issue with us.

So, it kind of serves two purposes here: We can say “Well, this is going to address an issue with our Internet connection. We can see the data on that, but we can also see the data on the deals we might have signed with Compass or other service providers or Office 365 or Google Apps or whatever it is. And we can say, you know, this isn’t cutting it. Like, this is too slow and this is not our Internet, because everything else is operating at a perfect speed.”

So, yeah, that’s the basics of how we sort of look into that data.

Mike: Yeah. And why this is so important for schoolsjust to make it really plainis, that it comes back to that user confidence and experience that we started off talking about, right? So, quite often, people say, “We just need faster Internet. That’s going to make everything better.” But you can’t necessarily track that. And if you go and spend—let’s just say you spend an extra $5000 a year, or $10,000 a year, on Internet. How do you know that that’s actually changed anything at the call phase because the Internet wasn’t necessarily the issue?

So, it’s always good, before you go out and you start to spend large amounts of money, just put a relatively inexpensive box in your school. Start to get a baseline of data and then you can start to make targeted changes to your spending patterns and then you can track that change and see if you’re getting the bang for your bucks.

So, I’m really excited about this at the moment. Just even as just a normal classroom teacher, I can really see the value in that at the call phase. It’s not just something that the tech guys need to fix. But it’s something that actually impacts my teaching and learning experience in the classroom. So, I think it’s really cool.

Blake: And I think it’s all about being able to discern: You can actually discern if it’s the issue that you’re in or if it’s the other end. I mean, if people are saying to you, “The Internet is ridiculously slow. We need a new Internet connection.” and you put this in and you notice that the response time is fantastic and they’re really solid and they don’t move throughout the periods, they’re the same on the weekends they are during the day, then, you know, well, hang on. The issue is not the Internet; the issue is with maybe the Wi-Fi; the issue is with our network; the issue is somewhere else. So, you know, this is probably a less expensive way of diagnosing that problem than signing a contract for $10,000 to $30,000 for the Internet.

Mike: Yeah, absolutely.

Download PDF Transcript

baby and bathwater

The baby and the bathwater

When you see or read about something new being done in education, there is a tendency of getting excited and changing direction to explore a new pedagogy. There’s nothing wrong with changing direction, but it is good to be mindful of a couple of things.


It’s Not My Fault Pt 1

How many times have we heard our students protest, “It’s not my fault!” Our students make all kind of excuses but to be fair so do we.  One of the greatest excuses both teachers and students alike make is that It’s not my fault. I have returned home from 10 days touring New


Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...


Sign Up Now
To Get The Latest Updates


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: