Are you an Office 365 school district? If so, then you may be missing out on some awesome uses of tools you have access to! In this MIE Classroom Spotlight, we focus on how to collect data using Excel Online.
"You can't do online surveys," said a colleague to me recently, much to my surprise, "in Office 365 like you can in GoogleForms." A newly minted Microsoft Innovative Educator, this didn't seem accurate, so some quick investigation revealed that you CAN create online surveys using Excel Online, which is a component of Office 365. If you are a Microsoft Innovative Educator (MIE), or your District uses Office 365, then you will want to explore this!
With Office 365 for staff and students, you and your students can use OneDrive.com and Excel Online to create an online survey with data being fed into an Excel spreadsheet automagically! Read on to see how!
Quick How-To: Create an Excel Online Survey
Step 1 - Go to OneDrive.com and select Excel Survey from the drop-down, as shown below:
Step 2 - Create the Survey and Add Questions
And, then you can SHARE SURVEY and CREATE LINK, which you can shorten to something manageable (like http://1drv.ms/1VWGCBE):
This is what that looks like:
Finally, you can see data online in your spreadsheet:
And, that's it! If you'd like to see a video of the process, you can watch this one.
Step 3 - Modify the Survey
If others need to be able to interact with the data, you can SHARE the Excel Online spreadsheet with them! If you need to modify the survey itself, that's pretty easy, too!