I had a chance to do a quick workshop at Tim Horton’s the other day.
I ran into someone I used to work with and she showed me one of the summer projects that she was working on.
It was essentially to collect data from students and bring it into a spreadsheet for the students to analyse. That’s always a fun and very useful activity and can be used to address expectations from the mathematics (and other) curriculums.
The tool being used to collect the data was a Google Form and it worked nicely. The plan was to collect the data from there, export it in Excel format and then use Excel to work with the data, reformat it, draw some charts, reach some conclusions, etc.
I asked this question “I thought you were an Office 365 Board”.
I got this response “Yeah, but you can’t do forms with it”.
Me – “I’m pretty sure you can. Let’s take a look at your Excel Online.”
Now, creating a form isn’t as explicit as it is in Sheets but it’s right there in the middle of the ribbon of a new spreadsheet.
The term is “Survey” and it’s a clickable button.
And, you’re off.
You have all the functionality that you probably could use in a form or data collection tool. The response types include Text, Paragraph Text, Number, Date, Time, Yes/No, or your own Choice.
The button itself has the options for viewing, editing, deleting, and most importantly sharing when you’re done.
It’s equally as slick for creating, publishing, and sharing. The results are immediately gathered into an Excel Online spreadsheet which then can be shared, manipulated, filtered, etc. as you will.
The end result for the students will be exactly the same. But, by doing everything in one spot, it’s a bit less work for the teacher and you don’t need to have two different online accounts to pull it off.