Skip to main content

Excel Surveys

One of the activities in Reflecting on Practice today involved developing question stems that would promote math talk.  We wanted a quick and easy way of collecting the sample question stems each participant had created -- a survey lets us distribute the typing and simplifies the redistribution for tomorrow's task.

In the past we would have used GoogleDocs because it puts the responses into a spreadsheet for easy analysis and distribution.  But, since we've been using Microsoft OneNote extensively, the majority of the participants have managed to get a Microsoft account and have started to use the OneDrive Web Apps for Word, Excel & PowerPoint.  Alongside the web-versions of the desktop apps, OneDrive offers the Excel Survey tool and already participants have been playing with the opportunities.

It's relatively easy to get started.  Click on the CREATE button in your OneDrive and you'll get the opportunity to create an online survey, with the entries going directly into an Excel spreadsheet.

Now, this is not a tremendously sophisticated survey tool with conditional branching but in an academic setting, it works very well for data collection.  You can grab numbers, text/paragraph, date/time, yes/no or multiple choice from participants -- and it all gets put into an Excel spreadsheet, with the column headings as your question -- and the Excel WebApp lets you filter your response on line.

After you create your survey you can create a link to send to your participants; again, I use bit.ly to provide a shortened, customized link that can then be shared with your participants.

You can also go in to the Excel WebApp and edit your survey in case you (as I did) made a spelling error on the survey or add another question.


Comments

Popular posts from this blog

So you want to hack your OneNote Class Notebook

Taking a brief break from my "Getting Started with OneNote Class Notebook" series (you can start that one here )... This is a little advanced so if you're not comfortable setting permissions inside of Office365 you may want to avoid this.  Or set up a Class Notebook to play with so that it doesn't affect any existing Class Notebooks.  Yeah, the latter is a good option. One of the great powers of OneNote is that you can do some really neat permissioning of the Section Tabs. When the Notebook is created, of course, it gives you an "open permissions" on the Collaboration Space and student-read-only on the Content Library.  And then each student space is wide open to each individual student. But we've found that occasionally you want to mix up the permissions a little.  For example, you could create a space in a student section for your private notes that the student couldn't see, or maybe you want a tab in the Collaboration Space that students cou

Desmos, OneNote & Replay

So using Desmos activities are a great way to encourage exploration and discussion in math class -- if you haven't tried them, I encourage it.  They're collected at  https://teacher.desmos.com/  But ... Desmos doesn't give you quite enough.  It doesn't have a way of capturing the work that the student does within their space, and it doesn't allow for annotation of class contributions as we come together to discuss.  Well, not surprisingly, OneNote comes to the rescue.  Using the Windows shortcut Windows-Shift-S it is really quick to snag the Desmos screen and pop it into a waiting OneNote page.  From there, we can grab our pen and (using wireless projection) talk about what all the different responses mean and where to go from there. (An aside : one of the nice features of Desmos activities are the way you can hit PAUSE and it will pause all the screens of the students working.  I always give them a heads up "10 seconds to pause..." and it's refr

Escape Room / BreakOut in OneNote

[[Part 2 of this article is here: Link] ] So when I was visiting  Anna in Edinburgh  during March Break, she showed me how she used Password-Protected OneNote sections within the OneNote ClassNotebook to help students check their work -- she set the password to the correct answer, so they knew they had it right when the Section opened up. I figured I could use this for Math Review, so I set aside a couple of hours (turned out to be 3 hours but a fair chunk of that was solution-time) the other night to put an Exam Review together for my Grade 10 Mathematics course.  I pulled together as many multiple choice questions and short answer questions on the topics as I could Google and tried to balance each Section with a mix of topics and then threw in a couple of pop-culture questions, too.  The students worked on the problems in each section and used the answers as passwords to unlock the next section until they got to the Prize section. Result?  Near total continual engagement