Friday 4 September 2015

The office digital maturity check-list

So a couple of days ago we found out that patients at a NHS HIV clinic in Dean Street London had details of their attendance widely broadcast because someone used cc rather than bcc in an email to patients www.bbc.co.uk/news/uk-34135866

The commentary rather misses the point - nobody should be using the bcc option for a mass email whatever the case. It is idle, incorrect and just like this is error prone. What it really highlights is that nobody has taught the staff at the clinic to use the basic features of MS Office - in this case email mail merge. All over the NHS and more widely I find staff at all levels using what are now commonplace office tools without the basic training to get the most out of them. This leads to errors and a significant loss of productivity. 

So here is my own basic office digital maturity check list (or pet-hate list) - what are yours?:

You are in an office and all you can hear is the ping of the notifications of incoming emails and people's eyes sliding to the screen while you are talking to them. Because they have not been taught how to switch off notifications and how to change scheduling of send and receive. I suggest twice a day - programme time in diary to do review and action mail twice a day. Otherwise switch it off. It will transform your productivity. 

You get sent a beautifully colourful spreadsheet but you are unable to analyse or manipulate the data or use it for a mail merge. That is because nobody has been taught to use the basic 'Table' (used to be called a 'List' in older versions) functionality of Excel to capture data fields and records in simple databases which you can then use Pivot Tables to analyse or just filter it for simple analysis. Oh - and you can use it as a mail merge database source. So something that is taking someone hours can be done in minutes.

You get  sent a PowerPoint presentation which needs to have the font colour changed to suit the projector and lighting in the meeting room but you have to change the font on each slide in turn (and there are 40 slides!). That is because nobody has been taught how to use and apply Masters and Layouts. Just choose any slide and select Reset and see what happens. Or modify the Master slide font colour and see what happens to the whole presentation (usually very little). 

You get a Word document that needs to have the font and headings restyled to meet a house style but need to go through it line by line to do so. And it is impossible to generate a Table of Contents. So this person has not been taught how to apply styles consistently across a document or indeed how to modify them if necessary.

You sit in a meeting and the action list is laboriously recorded for the minutes which are published a week later and only then do people remember the actions required. Alternatively they are captured and allocated there and then as they emerge by the Chair or project lead as delegated Outlook tasks   So people leave the room with a trackable task list they can integrate into their workflow. (I might be hoping for too much here I know).

Your inbox is flooded with large attachments and you completely lose track of the email trail of comments, revisions and versions. Because this organisation is not using a document sharing tool and if it is you and other key stakeholders cannot access the document to view and contribute. Indeed if they are using 'shared drives' then it is likely that different offices cannot see the same documents. How about using Box!

And as for project collaboration...only one person can see the project as a whole and that is the project manager on his version of MS Project who prints off Gantt Chart art once a month. Because this is not an organisation that believes in project collaboration, transparency and agility and has blocked access to any of the project collaboration tools widely available in the 'cloud' so teams cannot experiment and evaluate for themselves.

Oh - and they still have XP on the desktops and non-HTML5 browsers!

Nobody can learn about any of this or how to do any of this because access to Youtube is blocked. You can learn to do all of this in short-order because you are not alone. There are 1000s of useful, short 'how-to' and intro videos on the web about how to do these simple things. 




Monday 8 June 2015

Email bloody email - oh how I laughed (and now regret it)

Oh how I felt superior and laughed when, as an early email adopter (compuserve - remember that?), I was told that a colleague was getting his emails printed out and brought to him in a file twice a day. What a dinosaur! How wrong I was…bloody email!

How very prescient he was even if he did not know it. The younger amongst you may not know that Royal Mail used to deliver twice a day. The mail arrived, was opened by your secretary, sorted and then provided in an incoming mail folder to you at about 1000  and 1430 each day. Another folder might have come in alongside it with any internal memos.

Each document had an action and distribution box stamped on it or stapled to it. If the letter had a reference then it came attached to the relevant file if it was available. Junk was sorted into a separate file which you could glance at if you had the time - or dump it in the bin.

So at 1000 and 1430 (after your lunch which was not at your desk) you sat down with a coffee and biscuit (which normally came with the correspondence) and worked your way through the mail and internal memos. 

In between you normally had a pile of files in your in-tray (you had marked them with a bring forward (b/f) date which your secretary had put in her diary. You worked through them until the in-tray was empty and the out-tray ready to be emptied when the mail came in. A nice immediately visible workload measure.

Days had a rhythm to them. A colleague who was head down in a pile of files was probably not going to be keen on being disturbed. On the other hand if the in-tray was empty and the out-tray stacked then that was normally a good indicator that there was space for a chat.


So how about just doing your emails twice a day? Book an hour in your diary twice a day to ‘do the mail’. Switch off automatic send/receive, push email and any desktop email notifications. 

Go on - get some proper work done.

Friday 22 May 2015

Meetings, bloody meetings

Have a look at your diary for the next 4 weeks. Do a little exercise for yourself.

For each meeting in there check how you really feel about it. Which of them can you honestly say you are looking forward to with pleasure and/or anticipation because they are going to really add value to your role, are really interesting, really well run or just going to be good fun?

What proportion of all of them does that constitute? What does that really say about you? Just why are you letting this happen?

Let's bust a widespread misconception here - that diaries are for scheduling meetings. Wrong, wrong, completely bloody wrong! 

They are for scheduling work. Stuff that is going to add value. 

Look again at your diary. Just where are the entries in your diary which set aside time for you to do real work on something that matters? You might need some others to help you with your work so you might invite them to contribute. But that is not the same as a meeting.

Bet that most of you do your work in the slivers of time between meetings. Or when you should be resting or spending time with your families or on the things that make you a more interesting person.

So take a stand and fill your diary with useful stuff and let the meetings happen in the gaps. You might suddenly find that it is the meetings that take the hit and not the work. And then you will have to prioritise the meetings and not the useful stuff. That is a better way around. Try asking the person organising the meeting - 'why should I come to this meeting?' Or indeed asking yourself that question if you are organising it!

But then my guess is that most of you who read this will sigh, recognise it but do absolutely nothing about it and head off to your next 'heart-sink' meeting and do your emails during it.

Prove me wrong - please.

Friday 30 January 2015

Raising your sights - imagining digital futures for the NHS


Updated 21 July 2015:

So the NHS has hired Martha Lane-Fox 'to boost patients use of digital technologies'. Might I humbly suggest that she also think about boosting NHS staff's use of digital technologies as well! The NHS is incubating a culture of low expectations and self-limiting assumptions about the possibilities of digital technologies whatever the central rhetoric and the proclamations of the proportionately very small and incestuous group of  NHS 'twitterati'. 

The NHS has always been safely far enough behind the digital curve to avoid early adopter risks but given the pace of digital development has fallen even further behind what is possible. For example a significant proportion of the NHS is still using XP desktops and non-HTML5 compliant browser which severely limits access to modern digital tools on the web.

Out of date desktop software combined with restrictive security policies prevent access to, and experimentation with, tools that are increasingly pervasive within the private sector such as web-conferencing, project collaboration tools and communication tools such as Slack. The ability to use technology to work collaboratively and agilely across organisational boundaries (and to engage patients and service users) is almost non-existent. Email is still seen as the default collaboration tool! 

The result is that NHS staff have insufficient grounded experience of what is possible to be able to imagine or articulate an ambitious vision of what the digital future could look like. Staff have also grown increasingly resigned to the limitations and constraints of local IT infrastructure to the extent that they are governed by self-limiting assumptions about what is possible. The contrast with how they experience technology in their private lives simply amplifies this dissonance.


-------------------------------------------------------
The original post

I have just come off a Skype call with some folks from a NHS Strategic Clinical Network. By their nature these are widely geographically dispersed set of participants who are often under a lot of time pressure and whose ability to get together in one place is limited.

We were talking about ways they could improve collaboration using some of the tools that are becoming more familiar to the private sector but less so to the NHS. I thought I might summarise the discussion here - both as a note for their benefit but also for anyone else who might be thinking about exploring similar opportunities.

The first thing is to get out and experiment with what is out there. Actually really I mean play. Until you and some like-minded adventurers actually get hands-on with some of this stuff then you will not know what is possible and from there be able to be more articulate and demanding about what you need to do your job better. 

If you want a diagram then here is one. If we simply project forward from past (usually poor) experience in the NHS then our aim is going to be low and we are going to miss a lot of opportunities. If we can provide some new insights and experiences we might be able to lift our sights and imagine different futures.





So what can you do...? Lets be honest about this - if you go to your IT department first you are likely to be told 'All too difficult' (ATD). Its the easiest answer in a risk averse system still locked onto XP desktops and/or out of date browsers. You are going to need to do your homework first - and you may need to go into 'insurgent mode' to do so...

  • Find a small group of like minded adventurers, friends, colleagues. People with a spirit of inquiry. People who relate to words and terms like  'discover', 'explore', 'play', 'experiment', 'disruptive', 'there must be a better way', 'insurgent'. These words also allow failure as a learning opportunity as well as successes.
  • Be prepared to go 'off-grid' for a while. Use mobile devices (iPads and iPhones) which do not have as many access or browser restrictions. 
  • Try and get a modern browser on your laptop or desktop (if you are locked to IE7 will they let you have the latest version of Chrome?)
  • Or be prepared to test if at home on your own PC or laptop over a cup of coffee one evening.
  • Find people (like me) who are down this path, are passionate about opening up new horizons for people and ask for some pointers (but you are going to have to Skype me or ask me for a Google Hangout to do it - regard it as your first challenge). Put out an all-points call on Twitter or other Social Media channels. You might find others who want to experiment with you.
  • Be prepared to change the way you work in order to test the potential of these technologies - a simple example is to start using shared and delegated task lists to track progress. This can be quite a leap - most people and organisations do not use the core task functionality of Outlook for example. So during a workshop or meeting try and log and allocate actions as they arise direct to your collaboration tool.


Some basic tips that might help:

  • HTML5: An internet browser standard. Almost all modern cloud based collaboration tools need a compatible browser to work if on a PC/Laptop. So you need IE 9 or above or current versions of Chrome or Firefox or Safari. Mobile devices should be fine. Do not take no for an answer from your Trust IT department - I bet they have it on their desktops!
  • Connectivity: almost all this stuff works well off a normal broadband line or 3G/4G. But if you are using Skype, Hangouts or any other stuff the requires you to stream 'up' as well as down then remember that many connections have slower upload speeds than download. Check your connection speeds up and down using Broadband Speed Checker
  • Access: If at work or connected through a work VPN then check the access restrictions. Can you access streaming media such as YouTube, TED or Vimeo - there are lots of useful help videos on the web? People like you explaining useful stuff. All the stuff you are going to test has useful help videos. Learn from them. How can you share and learn if your Trust actively prevents it? Does your Trust prevent access to anything that looks like a File Sharing site - which usually covers all Project and Document collaboration tools on the web?
  • Always debrief - if you are going to test something then always take time afterwards for a shared learning session. What worked for you might not have worked for someone else.
  • Online: Get everyone who are experimenters onto Skype or even better onto Google+ so you can use Hangouts. Its a great way to collaborate on-line face to face - and you can even broadcast workshops and seminars live through Hangouts Live. A Google+ account is really useful. You can sign up for an account using your current email address - you do not need a gmail address.
  • Twitter: Get everyone on Twitter and choose a hashtag - build a wider community around your experiments.
  • Choose the platform to support the community. Choose one simple collaboration tool to hold you together as experimenters while you experiment with other tools. Maybe a free Basecamp trial or Asana.
  • Sharepoint warning: If someone mentions Sharepoint then reach for the baseball bat....or run a mile! Don't even go there...
  • Email: Is not a collaboration tool. Why make your lives worse by adding to the email pile while you are working on this together?
  • Agile: You might want to explore different ways of working on projects and how these tools can support more effective project delivery. An example is Agile - additional posts on my blog cover how Agile can be translated from the software environment to change projects.
Here is some stuff you might like to start with (links to Basecamp and Asana above):
  • Trello - a simple visual way of organising a project
  • Realtime Board - an online whiteboard for real time collaboration. Virtual post-it notes, draw, comment
  • Mindmeister - collaborative mindmapping
  • Google Hangouts - voice and video calls for team collaboration