This is the transcript for the 'Gathering data with Google Forms' video
Speaker 1:
Are you keen to learn about your school community, find out what they think or what they do, and also get some data to help them take some action? Well, you could use a pen and paper and survey everyone, or you could use some groovy digital tools. So jump into your student portal, and from there we are going to explore one in G Suite. So click on G Suite. And from there, we're going to enter the world of forms. Here, you can see you have got loads of options. But today, we are going to go with the blank option so that you can explore starting from scratch.
Speaker 1:
Now, today, I want to learn about how people at my school get to school. So I am going to call it the School Transport, whoops, and spell it correctly, Transport Survey. There we go. Now, the first question that I am going to ask them is, I am going to ask, how do you get to school? And don't forget your question mark. And I am only going to give them four options because if I gave them an open-slater question where they could answer anything, it would be really hard for me to gather and interpret that data and put it into something like an infographic. But today, I am going to give them four options of bus, a car, walk, bike, and maybe a horse. There we go.
Speaker 1:
Now, I also want to see if I can inspire some change. I want to know what might encourage people at my school to perhaps use the bike. What would encourage you to cycle to school? And I am again going to give them options so I have got some great data to work with. So I am going to say a bike rack, maybe bike pads in the local area, what about a bike bus where everyone cycles together, or I could have maybe a shade sale to protect the bikes. There we go. That's all I need. That is going to give me some great information to put graphically and to think about what might help to take action.
Speaker 1:
Don't forget, go up and name your form. It does tend to happen automatically. And also, you have got lots of options up here. You might want to change the colour that you are using. So I am going to make mine into a blue colour. And then if you click on the eye, you can see what it looks like for people who are going to fill it in. Nice, simple, easy. We know they are going to fill it out nice and quickly.
Speaker 1:
So I am going to go back out of that one and I am back into my survey again. So I am ready to send. So, oh, before you do that, don't forget to check your settings. Inside your settings, you might need to un-click restricting to users within the New South Wales Department of Education if you are getting community members to go and fill out your form as well. But make sure you discuss that one with your teacher first.
Speaker 1:
So I have done that. I am going to click on save. And then I am going to click on send. Now, you can send to people specifically via email, but I like to click on the link button in the middle, shorten the URL, and then you can put this out in Teams, Google Classroom, send it to your teacher for them to distribute for you, or even write it down and get people to access it that way. So now, I am going to click on copy, and I am ready to go and collect some responses. I'll be back in a minute.
Speaker 1:
Now, I have passed out my link. People have completed my survey. I am ready to roll. So where do you find your responses? Well, you will notice I am still in my form and there is a number 13 that's popped up the top. Give it a click and you can find that I can visualise and see all the responses quickly and easily. And you can see that most people catch the bus and the bike rack looks like their method of choice to get them on their bikes. But did you know this is just summary? If I click up here on this button, I can open up a spreadsheet. And I am going to create a new one. And once I have done that, I can gain access to all the information. And I have got it to work with to create infographics, other resources and dive a little deeper into my data.
Speaker 1:
Are you keen to get working with your data? Well, the next step might be to explore Issue 6 of T4L Kids for some ideas to visualise this data and then take some action to get students on their bikes to school.
[End of transcript]