Tip o’ the Week #225 – Surveys R Us

clip_image002

Have you noticed an increase in online surveys asking if you have a few minutes to complete them, when you visit web sites? Do you duck & dive when walking along the street and are confronted by a just-a-little-too-friendly student in high-vis and brandishing a clipboard?

clip_image003

Surveys are undoubtedly useful to the people collecting the information (as long as they screen out the loonies) though there’s always the possibility that the people who bother to fill in surveys might not always be the typical user – who has a spare 5 minutes in their day to tell some website what they think?

All that said, there are many tools that can be of use if you’re the surveyor and you want to ask people their opinion. In SharePoint Online (see here for a tutorial) it’s really easy to create surveys that contain structured and unstructured questions, even branching logic (eg. If you answer “No” to one question, jump to the next relevant one rather than asking you further questions about the thing you didn’t do).

Thanks to Phil Cross for pointing out that there has been a super-simple solution available for more than a year, courtesy of SkyOneDriveExcel Surveys. Ready for your Mum and Auntie to use, it’s a really simple way of asking a few questions and collating the responses you get – here’s an example survey.

It looks nice, but there are few fancy features like branching, however it’s really easy to set up a survey and it’s on OneDrive, so anyone can fill it in.

clip_image005

One thing to note, though – the originator doesn’t get any more information than what’s entered in the actual survey, so you might want to add questions about who the respondent is, what date it is etc. Answers are retrieved in a straightforward Excel table, and can use Excel functionality to filter and analyse – if you think you’re going to get enough replies that you’ll need to do that.

Still, Excel Surveys are easy to initiate, simple to complete and can be filled in by anyone who can access OneDrive.

Leave a Reply

Your email address will not be published. Required fields are marked *