Forms or Survey – that’s the question

feedbackA few years ago I wrote a post “What SharePoint can learn from SurveyMonkey” and it is now time to revisit.

With the introduction of Forms in Office365 I was curious how the various survey tools compare. As a SharePoint List can also be used to collect information, I have added that as well. It has some special characteristics that could make it a good choice in some scenarios.
I have some personal experience with Google Forms, and Forms is rumoured to be based on that, so I have added that to the mix as well.

So these are the 5 options compared:

  • Office365 Forms
  • SharePoint Survey
  • SharePoint List
  • SurveyMonkey (free version)
  • Google Forms

What did I do?

I have created a 10-question survey based on the 8 basic Q&A options of Forms.
Then I recreated the same survey in the other tools. In cases where there was not a straightforward solution, I tried to find a workaround.
I have not applied branching logic, as I already have a lot of information to share.

In a next post I will look at the general settings per survey. Can you change the colour scheme, can you add a logo, how do you start or stop a survey, etc.

Finally, and this will also be another post, I will compare the ways you can see and manage results. How are results displayed, can you export them to a spreadsheet, is there any way you can filter results or have different options to display them?

Questions and Answers

Forms has 8 Q and A types, but some of them can be used in different ways – e.g. a Choice question can be a one choice only (radio button) or a multiple choice (check boxes), and the Text can be a short text, a long text, and a number.

The Net Promoter Score has recently been added but I personally think it is superfluous (it can be replaced with a Rating scale) and also annoying to receive. However, there is something special about it which I will share later. 😉

Experience them yourself! (and help me)

Please check out and complete the surveys below, to have an idea of their look-and-feel. Please do not use real data, as I will use the inputs only for demonstrating how results will be displayed:

Forms

SurveyMonkey  (will close after 100 responses – limitation of the free version)

Google Forms

Results

I have captured the results in the picture below. You can also view/download this as Excel. You can use and edit it, but I would appreciate if you would mention my name if you share it outside of your organization.

Legend:

  • Green/Yes: Available by default, although it may have different names
  • Orange: Available with a workaround
  • Red/No: Not available
SurveyComparison-QandA
The results of the comparison of Question and Answers.

Conclusion

No two Survey tools are alike. Duh!

In general, the SharePoint options appear to be most different and the most limited, but they can be useful, especially when used within an organization, for which they have been developed:

  • They have more Q and A types (e.g. currency, People and Groups lookup, a lookup from an existing list, Managed Metadata) which may be needed now and then. The List also has Calculations and Site Columns to select from.
  • They can detect unique values, which is essential in case you are collecting unique numbers, such as machine, procedure or invoice numbers.

SurveyMonkey has a few annoying limitations in the free version, such as max. 10 questions, the lack of a “number” option or the absence of a description field for each question. But it also has some very nice things:

  • Add answer options in bulk to Choice questions – nice when you have many answer options
  • Display a large number of answer options in columns rather than a long list
  • Ask to “tick at least x options” in a multiple-choice question

There are some differences between Forms, SurveyMonkey and Google Forms. But in general, you can create decent survey questions with all of them.

What are your thoughts? Or do you prefer to wait until I have completed the comparison?

Image courtesy of Geralt on Pixabay.

Advertisements

Reaching beyond the usual suspects

IntranetNowBlogheaderOn October 5 I participated in IntranetNow in London. I presented there, and thought it would be nice to create a write-up in my blog, with some images from my presentation. If you prefer the PowerPoint variety, please check out my presentation on the IntranetNow SlideShare.

What brought this on?

Recently we introduced a new intranet (Publishing and team sites) to the organization.

Blog-changes
A overview of the old (left) and the new situation (right). Lots of changes!

We went from a SharePoint 2007 environment on-prem, to SharePoint Online in the cloud. That alone was a big change.

Our old platform was created 10 years before, when the organization was still very decentralized, and people could do on the platform whatever they wanted (which they did) as long as they did not break it (which they did…sometimes 🙂 ).
The new intranet is strictly governed, as there is now a strong central Security and Compliance team, strong Enterprise Architecture, many Governance Boards and Steering Committees and of course our new landlord Microsoft, and they all tell us what people can do and what not.

Additionally, we went from being one large company to two companies and we reorganized as well.

Challenges

We knew we were going to make a big change, so we secured the help of our “usual suspects”, a small group of people active on Yammer, and a small group of active content owners. They kindly agreed to be our Champions, helping us launch the new intranet to their circles of influence.

However, many of them left the organization during the project, or moved to another job, due to the reorganizations. So we were left with an even smaller group of “usual suspects”.

We tried to make up for it by increasing the communications:

  • Yammer messages and YamJams
  • News articles and Newsletters
  • Webinars with demos and question time
  • Local sessions to inform people
  • Emails to site owners
  • Creating training

But well, you know how it goes:

  • People do not always read or act upon communications
  • People only learn when they have a need, so many people left the learning until they had their new intranet and their new site(s).

So despite our efforts, this is more or less how people reacted when they saw their new tools for the first time:

Chaos wallpaper2.png
Sadly I do not know the creator of this wonderful image, but I have used it anyway since it is the best I could find to depict the response of the audience…

People were confused, did not know where to find their content, how to manage their sites, how to navigate, etc.

Action needed!

Well, if you want to implement a new effective digital workplace, this may not be the best response. So we introduced a new role into the organization: the Adoption Consultant. It is their role to make sure that employees

  • know what the DW is,
  • can use it to their advantage
  • and like it, so they will promote it and help others use it

Within this organization, the DW consists of the Office 365 suite plus a few other tools available for all employees.

So we are currently embedding this process into the organization:

Blog-cycle
The Process
  • There is a UX manager who runs a survey with 1/12 of employees every month, asking for user feedback about all IT tools and services.
    There are other sources for feedback (Yammer, support tickets, etc.) but the survey is the most formal one.
  • He turns the responses into usable data and insights.
  • If something relates to the Digital Workplace, he asks the Adoption Consultants to help with it. They determine which remediation actions need to be taken.
    New functionality will also be handled by the Adoption Consultants, as some projects have the objective to “get the software installed on people’s machines” without thinking beyond that point…
    So they think about whether extensive communication and training sessions are needed, or if a link to the help materials of the vendor is sufficient, or anything in between.
  • By implementing those actions it is expected that the complaints and remarks about this topic will be reduced.

Yeah, interesting picture, but what does that mean in practice?

Users: “I can not find anything on the intranet”

UX Manager: “We have found that “I can not find anything on the intranet” is in the Top 3 of complaints for the past months. Adoption Consultants, would you please look into this”?

Adoption Consultants:  “What does it mean exactly, “I can not find information on the intranet”? Do people not know how to search? Are they looking for information that is not there? Do they not know how to navigate?”
* arrange interviews with a selection of complainers*

Adoption Consultant: After some discussions I think

  • We will need to create a campaign to inform people about the options available in Search.
  • We need to suggest to this department that they properly archive their outdated procedures and provide more meaningful and descriptive titles and tagging for their current content.
  • We need to discuss federating SharePoint Search, as some people appear to be looking for content which lives in our IT service system.

What else have we done so far?

  • We have given “Digital Workplace roadshows” in various locations across the world, explaining what the Digital Workplace is and how people can best use it. These have been received really well.
  • We have started a campaign about the different options of Search, update your profile, etc.
  • We manage a “Digital Workplace” group on Yammer as THE place for discussion. This is really well-used and popular.
  • We have created procedures to communicate consistently about projects that bring new functionality to the organization, using consistent channels (such as that Yammer group).
  • We are working with local focal points as they know more about their specific situation.

What are the results?

As we have only started this role last July, we have not accomplished a reduction in unfavourable feedback from the employee survey. But we have achieved a few things:

  1. Through the roadshows, we have met a number of new enthusiastic content owners, willing to help their circle of influence with the new Digital Workplace
  2. Interviews with colleagues who responded in the survey have revealed unexpected and useful feedback.

And that survey…we will do our best to improve the results over time!

My personal gems from IntranetNow

GemsOn October 5 I participated in IntranetNow, and a wonderful conference it was!

There were plenty of interesting and enjoyable presentations but below are the ones that resonated most with me:

1. An excellent Yammer use case

Baxter Willis of WM Reply shared a great Yammer use case from one of his clients, drinks business Diageo.
Apparently they have an archive of all bottle types, advertising materials, recipes etc. Nobody was really aware of that department, until recently. They are digitizing their content and the archivist posts something interesting on Yammer every day, e.g.
“Did you know that Pimm’s has been associated with Wimbledon from the 1930’s?” accompanying a picture of a nice old newspaper ad proving her point.
This lady is now the toast of the company and her Yammer group is very popular.

I like this because it is another easy way to share knowledge, which would otherwise be hidden in the archive. Posting it on Yammer costs nothing more than 5 or 10 mins a day. It helps the Marketing and Social Media people in their current work by giving them new insights to the company and its history.

The new Smirnoff label is now based on earlier labels throughout time, and this is also caused by this work!

2. How to get feedback from your employees

Emma Morrison and Usman Hasan of Hyde discussed the their intranet redesign, based on feedback sessions with their employees.

What I liked about this is that they used a simple but effective approach of lunch sessions, and shared their learnings.

The “let them rant” or “whine and dine” idea resonated with me, as I have also found that sometimes people just want to vent, sometimes not about the intranet itself, but about related things.
In my situation I have heard from several annoyed people who had been handed over a team site due to reorganizations – either because they had a new role and the team site came with it, or because the previous owner had moved on. Someone else’s team site can be quite hard to handle as the setup and especially the permissions are not always documented or intuitive.
I have learned that the best way to help them is to go through their site together, trying to make sense of it (looking at site contents, checking permissions), rather than trying to defend something or taking it personally. 🙂

3. Improving an intranet with no budget

Janet White shared her approach to improve an intranet with very simple means and no budget. Anyone who can get good results with creativity and elbow grease, rather than money, is my hero!

Using simple tools like card sorting, tree testing and talking to users helped her to improve the navigation of the intranet (better labels and better structure) and some of the content.

Note

I have linked to the Slideshare versions of the presentations as I expect the information on the IntranetNow website will be replaced next year.

Image courtesy of Aasimshaz

400 Intranet promotion videos!

400VideosIt has been some time since I reached this milestone but I am only mentioning it now as I wanted a new place to store them before I started celebrating. The platform I used (Scoop.it) changed their plans and let me choose between a maximum of 50 items for free, or pay 15-18 dollars a month for an unlimited number of items, which I think is rather steep for a hobby.

New location!

So, after some searching and testing, and a lot of copy work from my husband I now present you with my new video collection:

https://list.ly/list/27Yb

Or:

http://ellenvanaken.video

What’s different?

  • List.ly is much faster to load 🙂
  • List.ly numbers the videos from the top. Numbers per video will change as I add new items
  • List.ly appears to allow a limited number of tags
  • Tags on List.ly are not sorted alphabetically, but on frequency of use
Video-ListlyHome
You will see the Filter options just on top of the list. 

I am leaving my old collection where it is but it will no longer be updated.

Ghosts

Of course we have weeded out all videos that were deleted from their original location. However, some deleted videos can still be played on Scoop.it. Spooky! I have added the entries to the new location and I am working on a way to make them playable in the new location.

What else?

  • I am still working on a nice hyperbolic title and description as that apparently increases the rank of my list 🙂
  • I also need a better banner.

Now Go!

I have added a number of new videos and will continue to do so over the next days – if you see this one below you will have seen the new ones.

Go check out the new location!

Last item on Scoopit
This video is where “the old collection” starts. 

 

SharePoint Holmes and the Gone Gallery

800px-Northwestern_High_School_Student_Art_GalleryWhile all consultants are writing about Modern Sites, Hub Sites and Communication sites, I am quite certain that a lot of us practitioners are still working with the Classic sites. Looking at “my own” environment this will not change overnight.

(One of the joys of being a practitioner is that you can watch an intranet grow old…and not always gracefully 🙂 )

So here’s another case of Classic SharePoint Investigation.

The case

“I can only add app parts to the page,” the user said. “I am the owner of the site and I would like to add Summary Links, but I can only see the web parts for the document libraries and lists in my site.”

And indeed, when I looked at her page in Edit mode, it looked like this:

SH-GG-WebParts
Although the user had selected the Web Part Gallery, she only saw the App Parts.

 

SH-GG-AppParts
This is what she saw when she selected the App Parts – exactly the same!

 

The investigation

  1. The site permissions were OK – she indeed had the correct permissions to manage the site.
  2. I checked the permissions for the Pages library and Pages – all were inheriting from the parent so that was not the issue.
  3. I logged in as admin (that account has Administrator permissions on all site collections in the tenant) and I saw all web parts. So it looked like another permissions issue.

    SH-GG-CorrectWP
    Same page, different user: I could see the web parts
  4. I asked the owner to which business she belonged. That was Business B. This gave me the clue that I needed.
  5. I checked the site collection – this was a site collection for Business A.
  6. So I checked her permissions on the site collection level – none, as only employees of Business A had access.
  7. To confirm, I checked her permissions for the Web Part Gallery.  Bingo!

The solution

As we are divesting Business B, we have removed all permissions of the Business B people from all site collections of Business A, and vice versa. This means that the Galleries in the Business A site collections are not accessible to employees of Business B. It is an exceptional case that a Business B owner is an owner of a Business A site, but there was a reason for that.

Fortunately the Web Part Gallery had unique permissions, so I added her to the Gallery and then she could do what she needed to do. I did not have to worry about maintenance as her account will be removed in a few months automatically as the system separation takes place. (I may write about that later.)
Frankly, I do not know which permissions a Web Part Gallery should have by default, as I have seen both “inherited” and “unique” while checking some site collections.

This case is probably not very common, but if you ever get incidents where people can not see the web parts when editing a page, please check permissions of the Web Part Gallery at the site collection level. I remember once accidentally removing all permissions at site collection level, and after I had added the groups back, several Galleries were inaccessible as due to unique permissions the groups had not been added back automatically…

About SharePoint Holmes:
Part of my role is solving user issues. Sometimes they are so common that I have a standard response, but sometimes I need to do some sleuthing to understand and solve it.
As many of my readers are in a similar position, I thought I’d introduce SharePoint Holmes, SharePoint investigator, who will go through a few cases while working out loud.

Photo courtesy of Maryland Pride on Wikimedia.

The new SharePoint app for iOS

spapp (2)I am not the most frequent user of the SharePoint app for iOS. Nonetheless, I am currently test-driving the new SharePoint app.
I saw the request for testers for the new app mentioned on Twitter a few weeks ago, emailed my interest, and last week I was invited to download it.

Getting started

I downloaded the app via Test Flight and replaced my current app with the new one, which was pretty seamless without another sign-in.
If you are curious…the SharePoint app in the regular App store is still the current one.

The current app has 5 navigation items; the new one has 3.
The items “Links”, “Sites” and “Persons” have been incorporated into a new item called “Find” which is an overview of your content and activity.

So, let’s discuss those 3 new items, shall we? Unfortunately everything is in Dutch and I have not found a way to change the language in the app, but I will explain.

 

Find

This is the landing page and it is an overview of content, sites, persons etc.

IMG_0119
New app: An overview of content on the page and 3 navigation items at the bottom.

The chapters are:

  • Search – for the search box
  • Quick access – these are recently visited items
  • Frequently visited sites – clicking on “More sites” shows you all sites in Card setup – unlike the current app which shows only an icon
  • Persons that you work with – which makes it painfully clear I am all alone in my tenant 🙂
  • Recent documents – documents I have recently created or modified
  • Links (not shown here, you need to scroll down) – which merely links to my no-longer-supported external website and my main team site. I do not see much added value in this chapter in my tenant, but I think this should be comparable to the Featured Links on the SharePoint landing page in the browser.

The new Sites page (with tabs on top: Frequent sites, Followed sites, Suggested sites) displays cards, just like the browser:

20180728_111726662_iOS.png
Sites are shown as cards, just like in the browser.

The old Sites page (with tabs Frequent sites and Followed sites) looks rather dull in comparison:

IMG_0370
The current app displays sites just with the icon. Look at the bottom for the old navigation menu with 5 items.

 

News

IMG_0117
News landing page

The News overview comes from the Modern pages and is taken from the SharePoint landing page.

App-NewsinBrowser
This is News as I see it on the SharePoint page in the browser.

If you open a News item in the app, you will see this:

IMG_0118
News item. You can like, comment, share and bookmark

This is the same as the News page in the current app.

I expected to be able to swipe or scroll through all News items, but you can only view the next item when you click the back arrow and go back to the News landing page.

Me

The third navigation item is Me

IMG_0121.PNG

This has two tabs:

  • Recent – content I have recently viewed, created or modified)
  • Saved – everything I have bookmarked.

From this page I can go to My Profile, which shows some more recent files and emails

InkedIMG_0123_LI

There is also a Gear Wheel at the Me-page which leads to personal and app settings.

IMG_0124

Sites

Of course I am very interested to know what is behind the Site cards. So I opened the Summary Links site:

20180728_142846132_iOS

This is the same as the current app. By default you see latest news and activity.
Clicking Home in the menu leads you to the Homepage as you see it in the browser, so the Homepage is not the first page you see when opening a site in the app. Weird…unless Microsoft thinks that the site Homepage is losing relevance – which would save site owners a lot of hassle in “designing a homepage”. (My Homepages are still Classic btw – does it make a difference if you use this with Modern Sites?)

Viewing documents in sites is easy, but you will need the OneDrive app.
If you want to edit a document, you will also need the Word, Excel and PowerPoint apps.

What do I think?

I like the fact that the app has become slightly more compact. That “Find” page is quite useful as it gives you a quick overview of relevant content. It is a mix of the Office365 landing page (which I would appreciate as my browser homepage any day) and the Delve “Me” page.

I would have liked to scroll or swipe through all News, to catch up with everything in one go. The home sofa is an excellent place to do that; I know from peers that making company news available “at home” has resulted in peak views in the evening as people  prefer, or have more time, to read news at home.
I can imagine that the News tab alone is enough reason why people would want to use the SharePoint app.

For the rest, I can imagine this is a useful app but I am a bit surprised that this needs to be tested. It does not differ that much from the current one. Are all Microsoft apps being tested this way? Or have I missed something in the functionality?

 

 

Using Yammer for a business process

YammerWe tend to think of Yammer as an optional communication and collaboration channel, where you can discuss topics and share information with and ask questions to all your colleagues, independent of where they are in the organization or on the globe.

But Yammer can also be used as part of a business process.

I recently talked to a Retail Sales organization that has been using Yammer for several years for a number of business processes.

1. Sharing information about customers.

A Yammer group has been created for each major customer.

Sales people visit shops, shop managers and customer head offices.
If they see empty shelves where their product should have been, incorrectly priced products, packaging with peeling labels, a nice display idea from a competitor, or anything else they find remarkable, they take a picture and upload that to the Yammer group with their comments.
This way they share it immediately with colleagues and the back-office, and the back-office can take instant action if necessary.
(For long-time readers, this is very similar to the process we had to facilitate with a Team Site as Yammer was at that time not an approved tool within that company)

YammerBus-Nicedisplay
Example of something interesting at the customer.

2. Flagging opportunities for improvement.

A dedicated Yammer group facilitates this process.
Whenever something could be done better, this is mentioned in this group, such as:
“I notice that the company flag at the Customer Center looks a bit worse for wear – can we have a new one?” or  “Can we please agree on a standard update interval for prices as I now have to find the latest prices in my own files rather than in the system?”
The Sales Managers discuss these suggestions and take the necessary action.

YammerBus-ImprovementsPost
Example of a potential improvement: reduce postage costs for samples

 

3.  Sharing winning strategies and achievements.

Another group has been created to share wins and winning strategies, as well as losses. Of course the Sales people are eager to share their wins, or show how they have added value or made a customer happy! Losses can also be a source for learning of course.
That information helps colleagues in two ways: they know what is happening with that customer, and they may learn different tactics to increase their negotiation repertoire.

YammerBus-Winexample
Example of win and interesting developments.

 

Not perfect

Is this perfect as a business system?
No. Yammer is not a CRM or Task Management system and conversations are easily lost without a process in place to capture and follow-up on them. Management and back office need to capture all posts manually and turn them into action lists and reports.
Posts are sometimes shared in the AllCompany group instead of in the group. (But you know you can move Yammer posts to different groups, right?)

YammerBus-Move conversation
In case you did not know – you can move conversations to a(nother) group!

 

But it works for them – the mobile Yammer app saves time for the Sales people, who are the face of the organization. They are on the road a lot and taking a picture with their phone and explaining in a few words at which branch of which customer they are and what they see, is quick, easy and useful.

As the Sales force does not often meet at the office, general improvements or the sharing of sales tactics might be forgotten without the Yammer group – but with the app they can share details immediately from any location.

Examples work!

The scenarios above may not work for you. But I have found that sharing examples help people to imagine what they can do with Yammer.

The other day I showed a rather skeptical audience these, and some other examples, of using Yammer. I also explained that, contrary to email chains, Yammer conversations are visible for people who get added to the group, e.g. new employees in the team.
All of a sudden one person said: “Aha! I am a Subject Matter Expert and I get a lot of emails from different people, asking me the same questions over and over again. If we use a Yammer group, we can share the questions and answers with everyone. That will save us all time. ”
We created that group there and then – it was also a good demo for the audience 🙂

Can you share some examples of how you have used Yammer for business processes?