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.


Post a Comment

Popular posts from this blog

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 for the 60 min…

Teacher Professional Development and Microsoft OneNote

During the first three weeks of July, I have the amazing opportunity to work at the Park City Mathematics Institute.  It is, without exaggeration, the best professional development opportunity for teachers of mathematics.  Participants spend three weeks thinking deeply about mathematics and mathematics education.

There are three main aspects of PCMI:

learning mathematicsreflection on practice (RoP)becoming a resource to others.I'm part of the team for RoP and in charge of the third aspect, in which participants consider a gap in professional development back at their home districts and work in small groups to help fill that hole by developing a rich PD seminar on that topic.

It is not easy to develop professional development.  Teachers who haven't written PD have to patiently learn how to write (essentially) lesson plans for someone else.

This year, I used Microsoft OneNote to facilitate the process.  We have a central OneNote Notebook through which I lay out the daily schedule…

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 refreshing…