statcounter tracker
Creating surveys with the Excel Web App in Office 365 for education - Education - Site Home - MSDN Blogs
The Education Blog
Ray Fleming's take on what's interesting in Education IT in Australia

Creating surveys with the Excel Web App in Office 365 for education

Home      Content index      Case studies      Windows 8 Education Apps      RSS feed       About

Creating surveys with the Excel Web App in Office 365 for education

  • Comments 7

The free version of Office 365 for education includes web versions of the main Office software – Word, Excel and PowerPoint – in addition to the email, collaboration and communication capabilities included within the online Exchange, SharePoint and Lync services. Of course, that's great for editing and working on documents, spreadsheets and presentations, and the beauty of the web service is that we can keep updating them for you as we add new features – you don't have to take on the responsibility for updating software across a pile of machines.

You can see the new features being added in the future to Office 365 through the preview versions. And we've just released the preview for Office 365 Enterprise (which is the version that Office 365 for education is based on).

Here's an idea that you can use them for, that might save you bucket-loads of time.

Using the Excel Web App for surveys and questionnaires

Thanks to  my colleague James Marshall in the UK, there's a good explanation of how you can easily create online surveys and questionnaires, and get the answers into a neat Excel spreadsheet. It's great for a range of scenarios, like:

  • A lecturer wanting to get opinion and feedback about a lecture immediately after it finishes.
  • A group of students doing a data collection exercise with their classmates.
  • A senior leader wanting to get feedback from parents about a school event (i.e. sports day, school theatre production)
  • A teacher running a competition.

The beauty of forms in the new Excel Web App is that they can be shared in a few clicks, and accessed on a variety of devices, making it easy for users with laptops, tablet devices, smart phones or pretty much any device with a browser to contribute. And you can make them public, so you can use them for parental surveys etc

Here's a screenshot from a survey that James published as an example (you can try it out on this link:

Excel Web App Survey


Learn MoreYou can read James' post on how to create a survey in the Excel Web App over on his excellent UK Education Cloud Blog (plus loads of other useful Office 365 for education information)

  • I've been playing with surveys in the Excel Web App for a little while now but cannot seem to get the spreadsheet data to update when I modify the questions.  Any clues?  Am I doing something wrong or is this a known issue?

  • I want my users to send only one unique response to my survey and not fill it again and again. How can I do that?

  • I can I set up the form so that it forces the timestamp in another column when I few the spreadsheet? I need to know that time and date that submission came in.

  • hi. is there an option to create dependencies? Let's say I'd like my second question to show only if the answer to question one is "yes"?

  • Please can I add an image in the Excel survey?

  • How do I edit my questions if I already finished creating the survey?

  • Is there anyway to have the student select multiple answers for one question?

    Also, I am trying to save and it says an error has occurred. Any idea why?

Page 1 of 1 (7 items)
Leave a Comment
  • Please add 1 and 1 and type the answer here:
  • Post