Friday, 14 March, 2014

Add-ons for Google Docs and Sheets

Google has snuck out some rather cool new functionality to its cloud based productivity suite Google Drive.

Called add-ons, you can now use them to add extra functionality to your Google Docs and Spreadsheets experience.

Here’s a video explaining it all:

[youtube http://www.youtube.com/watch?v=lZqX6ocwHWU]

So what are these add-ons and what do they do?

Lucky for us that Lifehacker has produced a list of the best ones. They include:

  • HelloFax, which lets you fax a Google Doc without leaving the app
  • Mapping sheets lets you take a spreadsheet full of address information and put it all on a Google Map
  • UberConference – lets you set up and run a conference call from within your Google Doc. Great for collaborating across distances
  • Track Changes – gives you reviewing tools a bit more like those you are used to in Word

These are just some of those currently available – it will be interesting to see what will come in time as developers get to work.

#Add-ons for Google Docs and Sheets

Five for Friday – 14 March 2014

linksFive for Friday is WorkSmart’s weekly roundup of interesting stuff from the week’s reading.

  1. About change, defaults and disruption – “large organisations are racing against start-ups to stay relevant”. Great stuff from Anne McCrossan
  2. Creating a minimum viable product using WordPress – Chris Lema on using WordPress to throw together prototype services
  3. 5 More Unexpected Ways to Work Smarter, Not Harder – useful ideas. Thanks to Dan Slee for the link.
  4. Is it time to quit your job and launch that new start up? – nice video from Bethnal Green Ventures via the Nominet Trust
  5. Forrester argues piecemeal digital transformation won’t work – interesting research. Lovely quote: “Dabbling with digital isn’t the route to success”.
Did you know that WorkSmart has a Pinterest board where loads of cool stuff is shared?
#Five for Friday – 14 March 2014

Tame your Twitter stream

tame-itNot sure how I had never come across this before, but Tame is super useful!

You set up an account as with all these services, and then connect to your Twitter account. Tame then goes away and comes back with a dashboard style view, in three columns.

The columns display the most popular links being shared by the people you follow, the most popular hashtags being used, and the most popular accounts being mentioned.

It’s a simple idea, but for those moments when you don’t have time for much more than a quick glance at Twitter, it gives you a fast summary of what’s popular in your stream – which might be all you need.

Here’s a video to show how it works:

#Tame your Twitter stream

Wednesday, 12 March, 2014

WIN! ‘The Myth of Innovation’ by Scott Berkun

photoThe Myth of Innovation by Scott Berkun is a great read on the topic of technology and innovation. It’s little Ruth’s favourite bedtime read!

From the blurb:

This updated paperback edition of the classic bestseller, takes you on a hilarious, fast-paced ride through the history of ideas. You’ll learn to transcend the false stories that deceive many business experts, scientists, and much of pop culture, with history based lessons on how to invent, create and deliver on your own ideas. You’ll have fun while you learn:

  • Where ideas come from
  • The true history of history
  • Why most people don’t like ideas
  • How great managers make ideas thrive
  • The importance of problem finding
  • The simple plan (new for paperback)

Since its initial publication, this classic bestseller has been discussed on NPR, MSNBC, CNBC, and at Yale University, MIT, Carnegie Mellon University, Microsoft, Apple, Intel, Google, Amazon.com, and other major media, corporations, and universities. It has changed the way thousands of leaders and creators understand the world.

Find out more about it on the book’s Amazon page.

I’ve a copy of the new paperback version of the book to give away. All you have to do is sign up to become a member of WorkSmart – which is free – and on Friday 21st March I will draw someone at random to send the book to.

Don’t worry if you have already signed up, as all members will be involved in the draw.

#WIN! ‘The Myth of Innovation’ by Scott Berkun

Tuesday, 11 March, 2014

Capsule – the acceptable and useful face of CRM

capsulecrm‘CRM’ or customer relationship management is one of those IT phrases that can put the fear of God into people, and with good reason.

There aren’t many people who have managed to avoid the organisational carnage that attempts to deploy CRM can cause. Careers have been left in ruins, consultants missing in action, businesses killed along the way.

But it really doesn’t have to be that way! In fact, using a small scale, lightweight CRM have been incredibly helpful in getting all manner of projects done.

My favourite is CapsuleCRM. It enables you to very simply keep contact records and assign various bits of information to them. It also helps you keep a database of the emails you send them, and helps you to organise your workload by attaching tasks to people.

You can also create cases, where tasks, people, notes and files can all be held together in one place. These can be used as a case management system relating to an organisation or person you are working with, or can even be used as a rudimentary but effective internal project management tool.

Finally, there is a free app that you can use on your smartphone so your contacts, notes and tasks are never far away.

Of course this is a CRM so there are some sales pipeline features in there as well. They may not be of use to you. But that’s ok – either don’t use them at all, or think up some other way that those features might be helpful to you.

With pretty much any project where you need to keep a track of people and your interactions with them, having a lightweight database like CapsuleCRM around can be super helpful. CapsuleCRM has a free tier, so you don’t even need to pay for it, or it’s just £8 per month per user if you want to unlock extra storage and so on.

#Capsule – the acceptable and useful face of CRM

Monday, 10 March, 2014

Putting together an online course

notetakingAs part of the membership perks of WorkSmart (not got your membership yet? Sign up here!) I am putting together a free online course on digital personal productivity.

Something to look forward to then, but also an opportunity for me to share what I’ve learned when putting it all together.

Here are the steps I found myself going through.

1. Choose your software

I was driven in this regard by the fact that the WorkSmart site runs on WordPress, and I really wanted to make sure my online learning courses tie in with the membership system on the site.

So I had a few WP based options to go for, and in the end chose WP-Courseware. I was heavily influenced in this decision by this excellent walk through post from Chris Lema – who is a great blogger to follow if you’re interested in WordPress and online learning.

2. Pick your topic

Choosing the topic for an online course is pretty important, because not every subject maps all that well to the online learning environment.

You also need to consider the level at which you are pitching the course, which again will determine whether or not putting in online will work effectively.

I find online courses – at least those of the type I am planning – work best for introductory level topics. Often more in depth learning requires some kind of interaction with the learner to find out exactly what they need, which often can be bespoke to a particular project they are working on or an issue they are encountering.

3. Write your outline

Outlining is a great discipline for planning any kind of project, but for putting together a course which has a hierarchy of content, it’s absolutely vital.

An outline is a document that is broken down into hierarchies. You can make one very simply with a bulleted list in a Word processor, with each level of the hierarchy being indented appropriately in the list.

However, a proper outlining application is better because it will allow you to drag and drop items into the right order. It facilitates the process of bashing in ideas and then sorting them into a proper order.

WP-Courseware splits a course into modules and units, so with my outliner I can easily have a document where each module contains units, all indented in an appropriate way. To help me identify what’s what, I tend to preface each item in a list with what it is, in squared brackets, such as [Module] or [Unit] to make it dead easy to see where something fits.

I use OmniOutliner, a desktop application for the Mac. However, Fargo is free and web based – and also excellent, so is a good place to start.

4. Create the content

Creating content for a learning course in WP-Courseware is dead straightforward – you just populate what looks very much like a WordPress page. So it’s dead easy to slot in text, images, video and other embeddable media.

Whether writing blog posts or putting together courses, I always like to write my content in an application other than WordPress. It makes me feel a little less hurried, for some reason.

One thing my course won’t include is any traditional e-learning modules. This is largely because they can be time consuming, and costly to create and often require the use of dedicated software that right now I don’t have access too.

I’ll be sticking with text, images and video mostly, with perhaps the odd embedded presentation thanks to Slideshare.

5. Plan your tests and quizzes

Have a good think about the types of assessment you want to do. Again, a lot of direction here will come from how much involvement you want on a day to day basis.

You can have assignments and so on that learners submit, and you can review. However, given that this is a free course and I hope that lots of people will take it, I’d rather any assessment is done by the users themselves.

So I will be using quizzes at various points in the course, to help learners check that they have got the important information from each unit. I write the questions and the multiple choice answers down, and check them with someone else to ensure they make sense and aren’t too patronising.

6. Put it all in place in a safe environment

Here’s one I wished I had thought of earlier! Rather than putting all this on a live site and developing in the open air, as it were, it’s far better to get your course created, filled up with content and tested in a safe environment.

In other words, duplicate your site and host it somewhere safe, either locally on your laptop or desktop machine, or on some hidden away web hosting that nobody will be able to access.

It’s always easier to make mistakes when nobody is looking and when your new course might not be one you want to be made available to the general public – see point 7 below – this is especially important!

I ended up using MAMP on my Mac to run a local version of my site that I could tinker around with to my heart’s content.

Then WP-Courseware makes it really simple for me to export my course from my local copy, and then import it into the live environment.

7. Decide how people will access – free / paid for etc

I want to boost the offering for my free membership level, so for this course I am happy to give it away free to members.

Membership on this site is handled by Paid Memberships Pro, which makes it incredibly easy to make certain pages and bits of content accessible to only members.

In the future, if I want to make some courses available for a fee, it will be easy enough to add another membership level which will handle all of this.

8. Make live

Once you know everything is working probably, set it live. Before you start promoting it though, it’s a good idea to use a test account to make sure everything is working on the live site as well as it did on your development version – just to iron out any final snags.

9. Promote!

My aim with this free-too-members course will be to increase the number of people signing up to WorkSmart, along with adding a bit of value for those who have already joined.

With this in mind, I really want to promote its existence, and so when the time comes I will be using social media, email newsletters and lots of other mediums to tell everyone about it and how they can access it.

10. Track performance

Finally, it’s important to track performance. Again, WP-Courseware does this for me, letting me know which users have started the course and how far they have got.

If most people are dropping out – particularly during a short course – it might be worth contacting them to find out why, and making some changes to the course.

#Putting together an online course

Creative facilitation

cfFacilitation is one of those odd skills, or activities, where it is very hard to define, but you tend to know when it is being done well, or indeed badly.

Viv McWaters and Johnnie Moore are two people who can definitely be described as great facilitators, and they have collected together their combined thinking and experience on the topic into a free e-book, Creative Facilitation.

Here’s a quick synopsis of each section of the book, from their website:

Part One: Why Facilitation?

We explore the impact of facilitation and facilitators on groups, the qualities that make for good facilitators and some of the underlying philosophy that underpins our approach.

Part Two: Workshop Basics

The foundations of facilitating workshops.

Part Three: Beyond the Basics

…is about providing an understanding of how to engage people and use different approaches.

Part Four: Creative Facilitation

…explores some of the knowledge and understanding that helps facilitators step into complex, and sometimes difficult, situations.

Part Five: Resources

…provides suggestions for developing your own “toolkit” with what you learn from experience as well as useful links, resources and other information.

To get Creative Facilitation for free, you just have to sign up to their email newsletter. It’s a great resource, and given that the emails tend to be very useful as well, it’s a bit of a win-win.

#Creative facilitation

Social tool implementation strategies: Part 1 – cobble free stuff

This is the first part in a series on different strategies for implementing social software within your organisation. They will be published every other Monday morning for the next few weeks. When they are all published, I will collect them all into an ebook which members will be able to download for free.

macbooktypingStrategy 1 – cobble free stuff

There are plenty of services out there that can be used for nothing, right now. For example:

Staff can sign up for these sites and make use of them to record and share knowledge, have conversations with colleagues and get all the advantages of social software without the need for paying for software or development.

As an organisation you could create a strategy which outlines which tools should be used for which task, and how everyone can share and connect on them. Perfect!

Well, kind of. Outsourcing your knowledge and collaboration activity in this way can work brilliantly, but it isn’t without its risks. For example, each service has its own username and password, creating an instant barrier to entry. Further, the services might not talk to each other very well, making it hard to link a conversation on one site with some resource uploaded to another.

What’s potentially worse is that all of these services are dependant on the fact that the companies that run them continue to do so.

Pros:

  • You can get started right away
  • No development requirements or deep IT involvement
  • Often these apps are the best of breed

Cons:

  • Lack of consistency of user interface may put off users
  • Your data will be stored on a multitude of third party servers
  • Limited functionality and support – not to mention adverts – with free versions

Have you tried the ‘cobbling free stuff’ strategy? How did it work for you? Let us know in the comments!

#Social tool implementation strategies: Part 1 – cobble free stuff

Friday, 7 March, 2014

Five for Friday – 7 March 2014

linksFive for Friday is WorkSmart’s weekly roundup of interesting stuff from the week’s reading.

  1. Attention, Please! PC Programs to Stave Off Distraction – can technology help you stop wasting time with technology?
  2. Oppia – a Google 20% project to “enable students to learn by doing online”
  3. The trajectory of ‘cultural change’ matters, as Microsoft demonstrates – even if you’re not interest in Microsoft itself, well worth a read for the culture change stuff
  4. Digital Analytics Fundamentals – a free online course on data stuff from Google
  5. The ART of Collaboration (reprise) – a great, very comprehensive post from Steve Dale on collaboration culture and technology.
Did you know that WorkSmart has a Pinterest board where loads of cool stuff is shared?
#Five for Friday – 7 March 2014

Simplifying complex work

Yves Morieux gives a really interesting TED talk here on how to reduce the complexity of modern day work.

He has six rules to help make this happen:

  1. Understand what your colleagues actually do.
  2. Remove rules: Reinforce the “integrators” Integrators are managers. Give them more power and interest to make others cooperate. Remove the layers so they can be closer to the action. Stop making more rules that reduce the discretionary power to managers.
  3. Increase the quantity of power so you can empower everybody to use their judgment and their intelligence. Move away from insulation and give more people the opportunity to take risks.
  4. Create feedback loops that expose people to the consequences of their actions
  5. Increase reciprocity by removing buffers that make individual employees self-sufficient.
  6. Reward those who cooperate and blame those who don’t cooperate. The CEO of The Lego Group, Jorgen Vig Knudstorp, has a great way to use it. He says, blame is not for failure; it is for failing to help or ask for help.
#Simplifying complex work

Thursday, 6 March, 2014

Connect with WorkSmart

wiresAs you would expect, WorkSmart is all over the internet!

The first thing to do is to join the site. Membership is free, and means you get the regular email newsletter. In the future it will also give you access to exclusive member resources – more on that soon. You can sign up here if you haven’t already.

Next, WorkSmart is of course on Twitter, where you can get alerted to new articles published on the blog, and to interesting links as we spot and curate them. Follow @worksmarthq now.

Are you a big Facebook user? It might be that the Facebook page is the best way to keep up to date, and to have your say on the articles and other content that are published there. Like WorkSmart on Facebook here.

How about Google+? I’m not convinced either, but there is a WorkSmart page there, which also has content posted up as it gets published on the blog. Follow WorkSmart on Google+ here.

Last but not least, WorkSmart currently has two (count ’em!) boards on Pinterest. One features all the posts that are published on the blog – so if you like to get your content in Pinterest, they are all there waiting for you. The other one is where content is curated from across the web, and is called Bookmarks.

So, you really have no excuse not to keep up to date with what is happening here! It will be great to see you on our various channels.

#Connect with WorkSmart

What’s on your tablet, Nick Jones?

NJ-headhsotNick Jones is Head of Digital and CSR at Visa Europe. Responsible for protecting and improving the reputation of Visa Europe across digital channels owned and earned.

Previously he worked in government at Number 10 and the Central Office of Information. You can find Nick on LinkedIn here.

Which tablet do you use most?

iPad mini

What do you use your tablet for most?

  • Email
  • Web browsing
  • Social networking
  • Note taking
  • Photography / video

What are your favourite apps?

What add ons do you use with your tablet?

Logitech Ultrathin keyboard case because the soft keyboard doesn’t allow easy tabbing when taking notes.

What does your tablet not do that you really wish it could?

Outlook integration so the work calendar and email were easily accessible. There is the Good app but not approved for work.

What’s on your tablet? is a regular series of posts about how WorkSmart readers use their tablets. You can take part too – just fill in the survey.
#What’s on your tablet, Nick Jones?

Wednesday, 5 March, 2014

Collaboration or cooperation?

coopStowe Boyd is a great writer on technology and the impact it has on organisational culture.

You can follow his blog here, which is updated several times a day with great titbits and articles.

He has written a post for the CMSWire website, entitled The Fall of Collaboration, The Rise of Cooperation which is a really interesting read.

In it he mentions a great quote from Marshall McLuhan: “Our Age of Anxiety is, in great part, the result of trying to do today’s jobs with yesterday’s tools!” – I can see myself repeating that in meetings in the future, for sure.

As we move into a new way of work — one based on more fluid and looser connections, grounded in freethinking, humanist and scientific approaches to the social contract — it’s becoming clear that the traditional model of “collaboration tools” is based around outmoded structures of control rather than the shape of our work today, or the nature of networked sociality. We need a different take on the tools we are using to get work done, one based on open cooperation at the core of our work instead of closed collaboration running alongside it.

His idea seems to be that the notion of collaboration has come to mean big, corporate platforms and processes. Cooperation on the other hand is more about individuals finding their own way to work together, using the most appropriate tools for the job.

Is this how you see things? Has the word collaboration become tainted by association?

#Collaboration or cooperation?

Tuesday, 4 March, 2014

Kahootz’s guide to a digital first culture

kahootzlogoKahootz is a cloud based project collaboration platform, which looks pretty good – and their blog is full of useful stuff.

Recently their CEO John Glover posted about “Creating a ‘Digital First’ culture in your public sector organisation“. In it he mentions four main points, which are well worth reflecting on.

1. Involve staff at the outset

While there are organisational purposes for going digital first, it’s staff who will make the change happen, so you need them to be onside.

2. Don’t assume management understand digital

Having management buy in is vital – but you need to make sure that it is at a deep level that demonstrates true understanding of the full potential of technology to transform working culture.

3. Start small – and give staff freedom to innovate

Taking an agile approach to implement a digital first strategy is most likely to succeed. Let staff try stuff out and see what works for them, rather than procuring a gigantic platform that you’ve no real idea will take off or not.

4. Be clear about what you want to achieve

You need to know why your doing what you’re doing. Unless you have specific objectives, how will you know if you are succeeding? Everyone needs to be pulling in the same direction, and to make that happen you need a shared vision across the organisation.

Some great advice there – would you add anything?

#Kahootz’s guide to a digital first culture

Monday, 3 March, 2014

Do you produce documents, or do you do work?

I really rather like this video interview with Rod Drury, CEO of the cloud accounting company Xero. I’ve been a happy Xero customer for a few years now – the system makes accounting comprehensible to the non-accountant, which is great!

In the interview, Rod talks about Xero’s switch from traditional Microsoft based systems to using Google’s offering, with all the social and collaborative stuff that entails. He describes how the availability of truly collaborative technology has helped to drive a culture change at Xero, around nimbleness and flexibility.

In one great line, Rod asks “do you produce documents, or do you do work?” – a question we’ve probably all asked ourselves at some point in our working lives.

Watch the interview below – or here’s a link – it’s well worth it.

[youtube http://www.youtube.com/watch?v=P-Vf9nA4YOQ]

#Do you produce documents, or do you do work?

WorkSmart!

worksmartJust to let Kind of Digital readers know about a new blog I’ve launched, called WorkSmart.

It’s all about how we work in organisations and will cover stuff like use of technology for personal productivity and better team working, and also other non-techy tools and tips and thoughts on organisational culture.

You can follow WorkSmart in a number of ways:

I’m also trying something a bit different with the site itself. I’m offering a free membership system on the blog, which gets you the email newsletter but also access to member only resources which I will be adding over time. If there’s demand I might also add some kind of community forum – but we’ll see.

In the meantime though, do check the blog out – there’s a few interesting posts up there already – and subscribe using whichever is your preferred method.

#WorkSmart!

Sunday, 2 March, 2014

The emergent task planner

etp
Photo credit: davidseah.com

I don’t know about you, but I love productivity hacks.

One of my favourite bloggers on this topic is David Seah, and as well as offering great insight via his blog, he also shares some beautifully designed templates and forms for helping to manage personal productivity.

One of his best is the emergent task planner. An A4 template that you use everyday to list the tasks you must complete that day, block out the time needed to do them, but also list those jobs that crop up during the day. It helps you juggle all these competing priorities and stay sane in the process.

You can download the emergent task planner as a PDF and print out a few to help you get started. There’s even some notes and guidance on how to best make use of it.

Do you have any favourite productivity hacks like this? Share them below in the comments!

#The emergent task planner

Friday, 28 February, 2014

“Technology at least as good as people have at home”

devicesA quick pointer to an interesting project in central government in the UK.

It’s looking at redefining the technology used by civil servants to get their jobs done.

There are a number of interesting issues around this agenda. The experience people have at home with software – particularly web based applications like Facebook, Amazon and so on – means that the systems they use at work are increasingly clunky and depressing.

As Stefan Czerniawski says in his blog post:

Traditional software is big and complicated, packed with features which most people don’t use most of the time. That has two consequences. The first is that they need training and support to be useful, the second is that it is difficult and expensive to change them. Modern software tends to be lighter, more focused, more flexible and more social. That makes it much easier to match the tool to the job.

It will be good to see what recommendations emerge from this project in the future.

#“Technology at least as good as people have at home”