Automatically pull an entire sheet of data between google spreadsheets

In November 2011, I wrote a blog post titled ‘How to automatically pull data between different Google Spreadsheets‘ – which was based on a feature called ‘ImportRange’. Although nearly 5 years old, this particular blog post is one of my most frequented and certainly the most commented on post that I have ever written.

I have recently been introduced to a new add on feature called ‘Import Sheet’ – which can be found at – and this does exactly what it says on the tin. It allows you to easily import (or export) a sheet from one file to another. So for example, I use google sheets to log the work that I do for each of my clients, with each client having a separate workbook (this means that I can share that workbook with them, without them seeing other contracts that I work on). I can then have a master dashboard, which imports copies of these sheets into a single location, and using simple functions such as the = function, I can then pull key data out of each of the sheets into my dashboard. Using Importsheet rather than the ImportRange feature is much easier, quicker and less likely to have problems.

The add on is a commercial tool, that does have a pricing plan, however the free version does what most people will want. Obviously I have no idea how the pricing plan may change in the future – they may choose to get rid, or reduce the functionality of the free version, so I wouldn’t suggest that people invest lots of time creating high stakes activity with this add on (unless they are prepared to pay in the future) – but certainly for the moment, this looks rather neat.

The importance of Leadership vs Management in FE when implementing #FELTAG

FELTAG (Further Education Learning Technology Action Group) has been around now for about three years, and in some areas there has been significant progress, in other areas the progress has been slower. One thing that has become apparent to me in my travels around the country and numerous organisations, is the ‘elephant in the room’ that is recognising the difference between leadership and management.

Leadership is about have vision, ideas and long term objectives; then inspiring people to follow those visions and ideas. A good leader will (usually) be an inspirational speaker/presenter, will be someone that is prepared to challenge the norm, and will seek new ways to achieve the goals they have set.

Management is about making sure that steps required to realise the vision and objectives are followed correctly. A good manager is someone that is organised, can break big problems down into more manageable steps, follows and applies protocols, and makes sure that things get done.

Image of a duck leading other ducks.

A leader, and many managers

So the skills and personality requirements of the two are completely different to each other – and herein lies the problem. Further Education in the UK is not very good at separating the two out. Quite often the principal (or equivalent) in an organisation, will be a ‘leader’ – but they will be supported by a SLT (Senior Leader Team) made up of managers. We then get managers making leadership decisions or leaders trying to manage projects – neither of which working well, due to the wrong personality types doing the wrong things. In larger organisations such as universities, or in the private sector – it is much clearer that some people are employed as leaders and some are employed as managers – but that clarity is lacked in FE, where the terms leadership and management are often used interchangeably to describe the same people.

From my perspective, I am often brought into organisations to run staff development in the area of blended learning. I always try to identify the organisations position, and then deliver a bespoke session based on this. Quite often the SLT has identified some totally arbitrary objective for all teaching teams e.g. they have to make 20% of their provision online. There is often no consideration of what that actually means, or why they are doing it, or what is in it for the teachers (or students). Sometimes it is obvious, that there isn’t a clear understanding of what the SLT want, which is problematic. In other situations, the SLT are clear what they want (or they think they are clear), but they haven’t articulated this down to the team leaders and teaching staff who have to implement this.

One of the things that I try to ascertain when working with clients, is ‘which model(s) of blended learning are you working towards?’, the response often being ‘blah blah 20% online blah blah’. There are many different models in which blended learning can be applied, and to be successful, the starting point for any organisation has to be identifying which model(s) are to be used for which situations (and a one size fits all/none approach isn’t a good model) – each subject area, and different courses within that subject area will have different ‘best’ models that they could use, but sadly I am often running training sessions for teachers, where they don’t know what model they are working towards, which makes the chances of success very remote.

And so back to the title of this post. I cannot pretend that I have a magic answer to this situation, but if there is a recognition that there is a difference between leadership and management – and the leaders do the leading and managers do the managing, then this is certainly a step forwards. From a blended learning perspective – the key is that the leaders have a clear long term vision for the organisation that they articulate well, and the managers have the autonomy and confidence to identify and implement the different models of blended learning in the teams that they support.

On the 6th December 2016, I am running a session titled ‘Effective development and management of blended learning‘ at EMFEC in Nottingham. A large part of the session will be looking at some of the different models of blended learning, and how the development of these can be strategically managed by an organisation.