Technology 4 Learning logo

Technology 4 Learning

Technology 4 Learning

Telephone1300 32 32 32

Emailt4linnovations@det.nsw.edu.au

Transcript of the 'Gathering data with Microsoft Forms' video

This is the transcript for 'Gathering data with Microsoft Forms' video.

Speaker 1:
Are you keen to gather some data on your school community, find out what they think about a particular issue and have some intel to help you and them take some action? Well you could use a paper survey, but there are some great electronic tools that can help. So jump into your student portal, then click on Microsoft Office 365, and today I want you to look for the plus button in the top left-hand corner. Click on plus, and then forms, this is a great tool to gather data. So today I am going to find out what everyone eats for lunch. Lunch preferences. Okay, I am going to add a question, and if I use multiple choice questions, it's going to mean I have got some great data to work with. If I give everyone a chance to put whatever they want down, it's going to be hard for me to put into a graph. So I am only going to give them some limited options. My favourite lunch food is ... And it might be fruit, it might be a vegetable platter. Okay, I have got to make sure I spell vegetable correctly.

Speaker 1:
And then I am going to add another option and it might be some chips or maybe it's going to be a burger or maybe it will be a sandwich, all pretty good options aren't they? Here we go. All right. But I am on a little bit of a mission today and I want to see if I could encourage everyone to perhaps eat some more fruit and vegetables at lunchtime. So what I am going to do is I am going to add another choice and I am going to say, what would encourage you to eat more fruit? There we go, question mark. And you can see little design ideas and helpful hints coming up to the side. I have got this one for the moment, but you might like to explore those. So maybe there might be some recipe ideas that encourage people to do it. Maybe it needs to be a little bit cheaper, or maybe we need to have a smoothie maker at school. There we go. And maybe there is an ice machine. Okay, there we go, we'll put in all those options. Who knows what might be possible?

Speaker 1:
Okay, I am ready, I have got the questions that I want to pass out and get everyone to complete. So you will notice up here, I have got a share button, it's highlighted it for me. So I can click on share, and if you are actually asking members of the community that aren't your students in your class or teachers at your school you will need to click anyone can respond. And then try clicking the shorten your URL button, so you have got a nice short URL that you can simply copy. Now you can send that through Google Classroom, Microsoft Teams, or email it to your teacher and they can pass it out. Or you can even grab a QR code. Wow, isn't that groovy? And everyone knows how to use QR codes these days. So, now what you have got to do, go and share this form with everyone else and gather the data. And we'll be back in a moment to see what you can do with those responses.

Speaker 1:
So, you have sent out your form and people have responded, but where do you find out what they thought? Well, you will notice I am back in my form, and up the top I have got a tab called responses. And yep, I have received 11. All you need to do is click on that to find out what people thought. And you will see a great quick glance view of people's responses. If you want more detail, simply click on the open in Excel button, and you will notice it will download directly to your computer, and you can open up the spreadsheet. So you have got all the details of people's responses. Now you can use this information to create some great graphical representations of your data. Maybe it's going to be an infographic or perhaps a movie. All of it will help you take action. For more ideas, go and check out issue 6 of T4L Kids magazine, which will talk to you all about visualising your data.

[End of transcript]