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

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…

Five reasons to learn Math with OneNote

So, Alice Keeler - @alicekeeler- who is an amazing blogger and an incredible resource for those using Google products, posted 60 Ways Math Teachers can use Google Classroom last April.  It came across my desk the other day and, since school hadn't started yet, I thought it might be a good reflection for me on how one could do similar tasks with OneNote Class Notebook.

I went through the list and checked that I could accomplish them all with OneNote and re-wrote her post with those modifications ... but it was looking a little "plagiarism-y" so, just to check, I emailed Alice to see if she was okay with it.  She was not, but encouraged me to do my own brainstorming.
So... Math Teachers & OneNote (including OneNote Class Notebook).  My top five... 
1) The Under-valued value of scribbles & notation
If you really want to be "paperless" (and that should never be a goal - you want to be digital so that content is no-cost) in a mathematics classroom, it's n…