Skip to main content


Google Login and Single Sign-on to Google Services in Chrome in an AD environment

I've previously posted about the ability to manage Windows PCs in the Google Admin Console. However, what if you are still managing your PCs via local active directory, but use Google Workspace for most things? Well you can have your cake and eat it - you just need to use  Google Credential Provider for Windows  and do a few configurations. Step 1 - update your users on the Google Admin Console You need to add a custom attribute to all of your users (at least those who use PCs) on the Google Admin console to link them with their local AD account. So you need to create a custom attribute in the Google admin console and populate this with the AD windows user details: The custom attribute you need is Enhanced_desktop_security and the field is AD_account. Detailed instructions can be found here . You can auto populate this field using GADS (Google Apps Directory Sync) if you use this to auto provision your accounts in Google from AD. Alternatively, you can populate them in bulk with a
Recent posts

Using Classroom with Google Meet

Given the times and how often I'm asked about how Meet works with Classroom, I've done a quick tutorial. Please be aware that how things work, does depend on how the admin console is configured: For the demo: Meet is enabled for students as a service, but they cannot start video calls and all of the admin options are turned off for their OU. Some feature require Enterprise licenses.

Mobility Print Cloud a quick demo coming soon

Google Voice - it's rather cool

We have just started moving over to Google Voice in Trust schools. This is to replace the existing telephony systems. If you are a G Suite organisation, then its a really cool solution and works very well. If you didn't know, this is a cloud-based solution and you users can use their Voice number on any device, anywhere - not just the physical desk phone (entirely optional) sitting at school. You have integration with all of the other G Suite tools - especially Calendar and Meet. Basically read all about it here . I'm not going to duplicate the Google blurb - but go through a few things to be aware of. Cost Voice licences come in at around £8 per month. Each user who needs a Voice number needs one and every physical handset is associated with a user. Handsets - you have to use the Polycom handsets - VVX150's start at around £75. Remember you can use Voice on any internet-connected device - so these are strictly optional. You can see the full range of handsets here . Calls t

Linux Apps are actually rather good on ChromeOS now (assuming you have a decent Chromebook!)

Quick demo of the Linux Apps I use on ChromeOS. This was done on my HP X360 14 G1 - i3 with 8Gb RAM.

Voice Typing in any app

It's come to my attention in the last few days that not everybody necessarily knows that you can actually voice type in pretty much any app. Voice typing is natively supported in most operating systems now, including Windows 10 and Chrome OS. In Windows 10 you simply press the Windows key and H how to turn on voice typing. In Chrome OS you turn on the on-screen keyboard and click on the microphone button and you can type into any app be it an Android app, the web browser, or a chrome packaged app. A quick demonstration is in the video below. It makes putting comments on student work considerably quicker in something like Google Classroom. I've also just written this paragraph using the on-screen keyboard on a Chromebook.

Importing Data from Bromcom directly into a Google Sheet and updating it automatically

I support one school in the Trust that used Bromcom and was finding it a bit tricky to get the data directly into Sheets. However, I've sorted this now and thought this might prove useful to someone. Step 1 - The Bromcom Report Write your report (or pick an existing one). Click Run Report and then select “Live Data Feed”. Copy the URL it gives you. Step 2 - Your user name and password to access the report You need the site ID which is the username. You also need your “User Access Key”. To get this click top right and “My account” and you will see a box with this in. Make a note of these. Step 3 - Setup the Google Sheet Make a Google Sheet that is going to receive the data. Click on “Tools” then Script and paste in this code: function populateSheetWithCSV(sheet, csvUrl, user, pw) {   var resp = UrlFetchApp.fetch(csvUrl, {     headers: {       // use basic auth       'Authorization': 'Basic ' + Utilities.base64Encode(       user + &