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.
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:
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: http://aka.ms/vumdyw)
You 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"?