Speaker 1: Hi everyone, welcome back. My name is John with Education Solutions Online and in today's video I would like to show, mainly this is for my students, how to create a Google Form and collect survey data. So you'll send out your survey and you'll collect your data for your primary research papers, but this could also be applicable to some teachers who want to use this as well. So let's go ahead and get started with this video and I will show you exactly how you can create your your Google Form and then send it out and then I'll show you exactly what it looks like when you start to collect your data. So what you'll do first is you'll log into your Gmail account, you'll open up Google Drive, and then you'll come over here to where it says new and there we go. So we'll bring this up and you see where it says Google Forms. You'll click right here and you'll create a new Google Form. So I've got one that I've already set up and what I like to do is I like to have my students put in their student number and then their name, John Doe, Jane Doe, whoever that is, and then they'll put this up here so that I've got this listed in the very top as well and then down in the description. This is where you would put the description of your survey or your study. Okay, so the very first one here that you will do and I'm going off of what is in the textbook that I use and in the textbook from National Geographic. Currently, I'm using one of the basic steps to writing research papers and I think it might be a little bit outdated because it just says male, female, and prefer not to say. So I actually included some some of the other genders that are that are listed. I apologize if I'm leaving anybody out. I don't intend to do that. But if you set up your your first part where it says to which gender do you most identify? Someone can choose the the gender that they most identify with. Next up here, so what we can see this is well, let me go through the the list of the questions here first, the school or the university name, the year in school, and then we've got some sample questions here that I should get into later. Now the first part here, so with this one here, we can see once we add in a new question, and you can find this right here where it says add question. So if you were to add this one in, this will pop up here and you'll get, let me show you real quick. So you'll get this one. This is what it looks like right here. It's a blank question and then with this drop-down menu right here, you can choose from a short answer paragraph, multiple-choice checkbox, drop-down file upload, linear scale or Likert scale, multiple-choice grid, checkbox, date, and time. So you have a lot of different choices here. Now this is what it looks like when it's blank. I'm going to delete that part here. And what I chose with this first one is a multiple-choice question. So someone would come in here, they would choose what gender they identify with, and then I've got with this one here, this is a short answer. Okay, so they'll type in the the university name, the one down here, this is a drop-down. So I'm just showing you some of the different choices you have for your questions that you can create. So the year in school, I put this as a drop-down and I'll show you what it looks like when I preview it. And then in this part with the next one here, so I added a new question and then it says do you agree with people? This is an example question that I got from one of my students here. Do you agree that people should be required to wear seatbelts while driving or riding in a car? And so this one is a Likert scale. And what I prefer to do is do a one through six. And this makes someone have to kind of sway towards either they strongly disagree or they strongly agree. They'll have to go to one side or the other here. Whereas if you do a one through five, someone can choose a three right down the middle and kind of give the yeah, I don't really care. So I prefer to get this one in my Likert scale here. So that's why I chose one through six. Now in this part here, if you look at this, let me click on this here. So this is my linear scale, I should say. I typed in my question and then you can choose the numbers between one and six. I think you can actually do a zero as well. But I chose one to six and I put in strongly disagree would be one and strongly disagree is one and strongly agree is six right there. So that's why I set up my linear scale. Now moving along here, I've got my... This is a checkbox style. Let me show you here. So we got checkboxes. So this is referring to a cell phone. I had another student do a research project about cell phone use. And then what features are most important to you when you purchase a new phone? Check all that apply. This means that it's not just a multiple-choice question, but people can choose every one of these if it applies to them. Okay, and then finally I set up in this one here. This is a paragraph. So this is like an open-ended question. So they can type as long as they want with this one. They can type an essay if they want to. It's a long answer text right here and this is allowing you to collect your qualitative data. Okay, so I've set up all my questions. Again, you come over here to where it says add question, and that's where you can add in your new questions for your survey. So let's have a look at the preview. Now we can come over here to our preview. This is what it looks like when you send it out. So if you were to put this one in, let's say they choose not listed, their university name, the University of let's say Illinois. Alright, and then let's say they're a senior, fourth year. Okay, do you agree? Let's say that they, well, they don't really disagree. Well, they sort of disagree. Okay, and then all the features that apply. So they can choose multiple ones. Let's say other as well. Oh, okay. So if they choose other, they can they can type in a description here. And then finally, this is where you can type your long answer. Okay, and this is for the qualitative research. Okay, so once you get to the end, and the person filling out the survey, they would submit that. Okay, and then we can come over here, and I filled out a couple other ones, and you can see the responses now. So with this one here, we can see a pie chart. So if we come back to our questions, a question that is a multiple choice will give you a pie chart that looks like this. Okay, this one was a fill in the blank. This was a short answer right here. So you've just got your answers here. Year in school, I believe this one is a drop-down. Let me check on that. Year in school, that is, yes, that's a drop-down. Okay, so that's going to give you a pie chart. Now with this one here, do you agree that people should be required to wear seat belts? This is my linear scale or my Likert scale right here. So this one is going to give you a bar chart right here. Now with the multiple check boxes, right here, what features? Check all that apply. Features of a new phone, check all that apply. This one is going to give you, we've got a bar chart right here. Okay, so and then the final one was a, this was a long answer. So this is where the respondents, I said that they can type as long as they want. This is if you're collecting qualitative data. So this is what you would do. It's a little bit more difficult, unless if you have some software to do sentiment analysis. I think it's good to put this into your survey, but I would stick to, if possible, at least for my students now, I would stick to these multiple choice, drop-down, linear scales, Likert scales here, and then also the check box. Now it doesn't hurt to put these in with the open-ended questions if you want to collect some qualitative data. But this is how you've got your, this is how you can get your information here. And let's say, for instance, if you want to put this one in, let's say that this was, if you agree or disagree, this is our Likert scale. Now look at this one here. If you come to your response, and you've got this form, comes up here, it says copy the chart. So you can copy this chart. It'll say it's copied a clipboard, and then you can go and do a control, I'm sorry, right, or you can right-click on this on your, on your Word doc or on your Google doc. You can right-click on it, and you can paste it into your Word doc or your Google doc, however you're writing your paper. Now that will give you, that will allow you to paste that into your paper, but you have to make sure that it remains APA compliant with APA 7th right here. So a very good website that you can use is called the OWL Purdue. It's the Online Writing Lab from Purdue University, and this will show you exactly how you can set up your charts. So you will have to do a little bit of editing with this. If you take it from your, let's see, if you take it from here, and you copy this, it's going to bring up this information with the question, and you'll see like three responses. So you may have to do a little bit of editing with that when you paste it in just to make sure that it's APA 7th compliant here. Now one other thing that you can do once you have all of your responses come through, you can see this green button right here, this this green box with a white cross here. It says view responses and sheets. If you click here, this will open up your spreadsheet here that has all of your responses. So if you have anything that has to do with, if we come back here, let's say for example, this is a good one. If we got our qualitative research question down here at the bottom, this will come through at the very end here. So do you think this, yeah, so here it is. Please explain in detail. So this is where your respondents will come through. Now you can take these responses here, and that's where you can, if you know how to, you can run sentiment analysis, or you can actually just read through all of the responses and decide if it's positive or negative and get a feel for what your responses are. So that's another really good way to to be able to take all of your survey data and really put it to use in your primary research papers. So that's really important here. If you ever have a question about it, you can ask your teacher, or you can just refer to the Purdue OWL, the Online Writing Lab. So it's a very good website to use. I highly recommend it. What else do we have here? Oh, when you get ready to send this out, you can see this big purple button right here. It says send. You would click on this one right here, and then what you're going to do is you'll find a link, and you'll shorten the link, and you'll click on copy right there. So once you have that copied, you can set it up for your teacher to email it to all of the students. You can send this out via your LMS. You can send it out any way you like here. Just make sure that you can get people to respond to your questionnaire, your survey right here. So this is a very quick, brief way to create your Google Forms. I hope that this was helpful. If it was, I really do appreciate you watching, and I look forward to seeing you in some of the next videos. Thanks a lot, and as always, adios.