Google Sheets & Forms - Beginner | Moni | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Google Sheets & Forms - Beginner

teacher avatar Moni,

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

23 Lessons (1h 41m)
    • 1. Introduction

      2:17
    • 2. Create a form

      2:19
    • 3. Settings

      3:39
    • 4. GDPR

      9:36
    • 5. Purpose

      4:54
    • 6. Sections

      5:55
    • 7. Adding and editing questions

      1:23
    • 8. Titles

      1:06
    • 9. Compulsory questions

      2:25
    • 10. Answer validation

      8:48
    • 11. Add a ogical flow

      5:11
    • 12. Questions types

      5:11
    • 13. The Dichotomous questions

      3:28
    • 14. Multiple choice questions

      3:28
    • 15. Scale questions

      3:40
    • 16. Matrix questions

      7:31
    • 17. Ranking questions

      7:31
    • 18. Constant Sum Questions

      1:12
    • 19. Design

      4:49
    • 20. Save, print and collect answers

      5:06
    • 21. Visualising results

      1:40
    • 22. Collaboration

      4:21
    • 23. Other tips and tricks

      5:40
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

88

Students

--

Projects

About This Class

The most complete Google Sheets and Forms course. No prior knowledge required.

What you'll learn

  • Be able to create, edit, and share spreadsheets quickly and efficiently
  • Understand and add charts to spreadsheets
  • Understand how to work with and filter data
  • Gain a basic understanding of formulas and how to apply them
  • Create forms and surveys
  • Collect and analyze data from forms and surveys

Meet Your Teacher

Teacher Profile Image

Moni

Teacher

Heya,

I am A 

Forest lover‍ 

Self-taught artist ‍

Spreading the creativity love 

on Earth, Universe

See full profile

Class Ratings

Expectations Met?
    Exceeded!
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: as before. Any project you may have forcing raise applies the same concept. You need to have a plan, a framework in order to keep progressing. Great good design for the survey that will get you the results that you need in order to make a decision. The thing that I like to make before starting. Anything I need to do any kind of project, maybe surveyed or even designing you made for social media or planning an event, anything that any type of project that I may have. I have a workflow that I will use it each never time, and that sounds and looks something like you see in the in the current screen. It starts with setting those purposes. 20 Storming for ideas, collaborating with Carl eggs or potential customers or potential partners. Select I d. Evaluate Insulated best I years, then create a prototype, then tested to see maybe, for example, we're talking about surveys. Maybe a question is not so well understood by your respondents. This happens a lot to me, so I kind of tested with friends, family and potential clients, or the kind of off a sample off from the group of people you are going to send or you want to reach with. That's a very and then adjusts launches array Geathers over interpreted results and repeat that this this kind of framework applies to any type of project and the next less than we are going to actually go in more details about some stages of the process that may be very helpful when it comes to creating goods surveys. 2. Create a form: to get started with your first template survey. You can create a new form, either by going Teoh your drive section and tap on the and click on the new bottom. Select more and Google forms, or either you access you go to the forms section at Google, which is linked to this lesson and tap on the glass. Second, to start with you, Tim, continue survey. As you can see, you can also select a template toe start weight or you can't go without any template, and you will be your for afterward. As you can see in the first steps off building your survey, you cannot a title, and also this is optional. But I saw the recommended tea at the firm description where you can add some details regarding Oh, your survey. Thank you know, and also maybe depending on what you are trying to achieve, to add some instruction like that line until this form can be fill out. Or if you offering a word, what exactly do you offer? What are the condition and so on us and will thank you? It will do the trick on collecting more responses beside this basic setting off the four. We also have the general settings and we're going to approach this in several election lecture that will follow after this one on this general second that you're seeing will be going to approach on the next Lexan Lessner regarding the GDP are as well because we need Teoh do a storm. Additional comments on this topic, which is quite important since May last year, and she you should be very aware of the implications off this CPR. 3. Settings: so before going in more wrapped with creating question section editing, adjusting and beautiful occasion off the off the survey, we need to you address very important depowered questions that are related. Teoh. The next lesson. That would be how Teoh do the general setting. So if you tap on the settings icon on the right up off this queen, you will be prompted with a pop up where you can select if you want to collect email addresses. Also response receipts, which means the respondents will receive a copy off their responses. It can be sent by for all the time or only the user wants to receive a copy off his or her answers. Also, another another. Some things you can do is to limit There's answer to our response, which means that after the same user, the same person cannot response allowed to times multiple times a surveys, the only on time in that purpose, you need to ask users to sign in in their Google account. So Google knows they already replying to your Serey, and if they try to opening to fill out one more time, they won't be able with the same Google account off course. If they change a Google account, they can feel it out one more time or multiple times. Also, you can give the respondents option, Thio added. Their answers after day cemented history or not, depending on your goals and how many options you give to the users. And also, you can give them the option to see the results. Depending on the privacy of the survey, you may want days or not regarding presentation this address showing the Progress bar while a new user feels down the survey. And we are going to highlight this in the future lesson when we will add questions and progress with building this rate. Also, another option is to shuffle question order, which means to multiple users won't say the question in the same water, but will kind off free range randomly. The question. Also here you can time a text to to display to the to the user that feelings out. That's Robey. Thank you. And a confirmation that this survey is completed. Gonna quizzes section will address is not completely separate. Blessing. So I decided of general settings for surveyed on way wanted Teoh go through this in the beginning of the lesson because there are some points and I have a question that you should ask yourself before starting. And this is strongly related to the New Jersey PR policy that Waas launched and approved last year in my 4. GDPR: so going through. Some GBP are suggestion and details may take a couple of minutes. So you want to kind of keep the section for now and just continue with instruction. How to build a survey. Please feel free to do that, and if you want to find out more about it, be are come back later on. Thio Thio view this lesson. You know it and no doubt your mailbox knows it is well that GDP are is here. I am sure you had the read enough about definition and the impact of this. So now it's time to get into specifics. Off How to battle this based, unfortunately, is Judy PR is quite complicated, but for our luck, we way may not. I need to go in so much complexity Teoh to comply with with this. So when you're using Google forms, you are collecting and processing data. If that data can be used to identify on individual, it's wants to make a few small updates to your questions. So let's start with considerations to make before you create your your survey. First of all, when you are creating or updating your questions to comply with the PR it wants to consider what you won't be using data for. It is an entirely anonymous survey. It is for internal use is going to be assume your Google com to cuckold tribe or you two plan to transfer the states that to other acts as well. What are you going to do? A disease? What kind of data you collect from this? Customers are respondents. Do you have a good reason to collect? State? Are Why do you need it? How was the dates out saying, exactly, Did user give you their consent? Or did you plan to ask for the consent? How long will you retain it? And the question can go on and on and own body. That's the idea. So, for example, it is the total anonymous survey. But if you target internal department and in your question, you have questions regarding gender and age. And in that department you are where there is only, for example, a male with age between 40 and 45. That is a case where that individual can be identified based on the responses you will see in that surveys. So that is not GDP are compliant. Please remember that duty para applies also to the data collected from from your employees . So, for example, you cannot share the home address of a colleague with another colleague whom I want to send a birthday card, for example, unless that person expressed his wish off sharing his his data for launching years rates more important than ever to list what you plan to do with it. Each different aspect should be mentioned in your privacy policy and should be attached years rate. So even before you kind of designed the survey, I think that we will approach the next lesson you need. Teoh. Think what you how you are going Teoh. Use that data because even when you think off the question you're going to ask in your survey, you need to make sure you respect privacy laws. So let's see some quick things you can include to comply with George. It appear Perceval Add the short introduction into your survey and the purpose of this way also mentioned days in the previous lesson where I kind of highlighted that the forms and the description of the four is optional, but you need Teoh benefit and take used off that field in order, Thio added. Eight i and information that will help you, Judy pair compliant. And also make sure the user kind of understand what you try to achieve that 2nd 2nd of all , you need to lean to privacy statement so you can put that privacy statement into Google document or Aborigine on your website and pulling to that document to that webpage in this survey with all the necessary information. So the third thing will be Teoh. Add active off things in your form field. So, for example, you can add like I wanted Teoh receive marketing emails regarding new products. I confirm on up, I proved Teoh comfort me via email or anything you need to do in order to get back to your to your respondents. You need to ask them in advance. Teoh, approve that you can do that. Otherwise you can get into trouble if for respondent is aware off this ju DPR and the rights that he has and he kind of reports you so please be aware off all the wrist and last but not least, the far thing you can do with 14 can do is to provide additional information on why you need Teoh. You need this specific data or information from them. So, for example, if you are asking for the poor date, you could add something along that line as your date of birth. Help us provide special promotions, um purchased benefits during your party so this world changes can make a very big difference. So an important additional to do is updating your privacy policy. Please be aware this is not legal advice. In no way and advice mentioned in this lesson, it's more like a guideline to cover the basics. For legal advice, try to reach someone specialized in CPR as they wrap up four proof privacy policy. You should include who you are, what you are going to do with your respondents data who this collected data will be share with. So for more detains, you find a lot of information over Internet, But if you are part of a local organization, you probably can can get in touch with the legal adviser for for a company to find out more . Today's regarding the GDP 5. Purpose: Theo First question that we should ask our sources. What is the true purpose of a survey over for me seeing like an obvious question to us, But I c t often how we kind of keep the stage and it's away. We design and district should have clear goals by which you and I can measure the success off that project. So why do we do surveys surveys that one best way to get input from potential or existing customer before even we start investing too much time or money into a new idea or renter or feature where wherever we are trying to do so, you can follow a self question to help you determine the purpose off your surveyed What exactly are you trying to figure out? Why do you want to know? What do you hope to do with state when you are done? What kind of report date are you? Who is your audience? How are you going? Teoh? Get to death audience and the list can go on but started with a couple of questions. Kind of gives you the context off. Why are you going, Teoh create that serve so said set up So we go up to max. Five goals should be enough. Never exceed ago because kind of I wanna reach too many things, which once away and that is not good either. So once you got a handle off the need behind your survey, it's time Teoh move on to the next stage and the next stage will be graced. Arming with your colleagues depending up for your context, can be clients or friends or family or other state colors that are in your group. Please remember there is no bad idea breaks through me. Gather all the input you can get that analyze the data are check if there are any patterns , some things that information I get from these people. You'll observe that it's kind of repeating itself, so that will help you combined the information into a set of goals and a set of questions. So please consider that surveys take up turn and money from you. So if you don't spend enough time on defining why and what you're trying to choose, then everything will put into later on in the process will be wasted. We don a connection with the survey goes, you may find yourself unable to act on the data that you collect in the end. So basically, you're going to run that survey. You will going to put a lot of work in distributing and getting the responses. But you will notice in the end that there is nothing that you can actually do with data. So as a shore wrap up off water gets or babies is to have a clear purpose, easy to manage it to take. I get really went and accurate data and helps you confidently make more informed decisions . Foundation off the best rates are long before the first responses come running. I know it's tempting to jump right into writing questions and choosing colors, adding images and so on. But we don't getting. It's time to understand the question that you are going to ask. We are going Teoh run the risk of endangering your date, and after this purpose and goal stage is well spent on, you got the results that's needed. You can move forward with the other SEPs from the great more workload that I talked about in the Brutus less 6. Sections: If you have more than eight or 10 questions, it is better. Teoh organized those teams on sections, and you can group those based on the topic of the question. So to create the section before the stepped off question, you go and click on I The last Aiken on the action bar. When you click on that action, you'll see already that a new section was added. For each section, you are able to add a title and a description. You can add as many section as one. But please keep in mind that your form should not be too long and by the fall should not have too many sections. By grouping the questions intersection, you will simplified Phoenix process off, filling out the survey not having like 15 questions on one page to see how this looks like for a potential responded, we'll click on the preview icon from the top right corner. As you can see, here is the Progress Bar that we talked about in the beginning of the last sons, mentioning than sections the pages where you are and how many are. After feeling out the state of question for its section, you can go to the next section, and also you can go back to the previous section when you are done, some meat on that's it. So sections are very useful in organizing your survey. Organizing the sections and anything go days are it's quite easy. So clicking on the three dots on each section, you can either duplicated section move the section, the latest section or marketable. Let's quickly try all off this options. So, for example, margin above combined the set of questions from both sections into one section. Since I didn't have any questions in the second section, we see only the question that we had in the for a section. Going further with options, we can delete it and we'll do that. Now we'll add another one to continue it. Actions. We can duplicate it, and we can't move it. So this simplifies your life a lot because if you kind of think of a new section after you already did want to, you don't need Teoh. So right up in the up or down arrow, you can move it wherever you want to move it. So, for example, question five section we live, it has the last section, so I tapped once and second time Teoh, take this section. You can also drag and drop, which is much easier, of course, at the end. Just kick save and everything is safe. Another option to move it is from the section below each box. Click on the drop down and move it. Whatever you want, as you probably imagined, using this after section option allows you to set a different flow a different order off the off the section that is not similar to the one that you can actually see. Why editing this survey Because you can see Section 12 tree as you order than but using the section below. After Section one, you can actually send either dissection three after section three to Section five and so on . In the last action, which is next todo three dots. The two arrows that kind of proposing themselves are used to expand or shrink the section because if you have a section we'd like five or can questions. You kind of want a scroll through your survey without seeing all the question. Just jumping from one section to another to summarize your section to structural Serey. But keep this very sure 7. Adding and editing questions: in this election, we will quickly over you how you can add an added questions. I will go in the type of question in a future lesson so you can see as the fold Google ads automatically a question of field to request the email address in any way, as we discuss which DeBare another implication. For now, it will consider that we won't be requesting that information from from the respondents. In order to do that, just go to settings from the icon on the top right corner or from the late link under the field and removed the collect. He made address option to other question. You can tap on the plus icon on the right box with entire list affection for for the for reform and you will see that you can duplicate. You can delete. You can move the questions around. There are several times off question that you can add in a form. Andi. We will go on more details about those in a future lesson 8. Titles: Another thing you can do in structuring your serene is to add some titles between questions , which can be in addition to the section option that we discussed. This title option is added to within the same section, so the questions the several question is not split it. So, for example, if you don't want to have multiple sections, but you still want to kind of for the questions into specific sets because you have only eight questions, you can take us off this recital option and add some extra information regarding the the questions that will follow next. 9. Compulsory questions: and the last thing you should know before starting to build the survey and get in more that with the type off questions we have for Serey and we have available in Google forms as well is the validation option. And with this validation option, you basically transform a question into a required one. So if we duplicate this question and we have are required and one not required and we go to see to preview the questionnaire, we will see that as a respondent, I am able to go next. We doubt filling out the required question, but I am not able to go next without filling out the required question. So, for example, if now I click an answer, the required question and go next, I'm not blocked. Even though I didn't answer the undercard question How the supplies to your survey? Well, you need to be aware off how many's require question. Do you want to add Teoh survey and not to have a very bro surveyed and to have all questions require? You should look in maintaining our balance between ah, the require question and our great question. But definitely if you're surveys quite long, you should let the respondents the options is keep some some of the questions. The last mentioned that the validation off question in a surveyed of validation off the answers can be under this form off requiring. Ford responded to answer questions, But it can take other forms as well, especially when you have a quiz and you want to put some rules to the answers, and we'll go in more depth regarding that type of validation in the next lesson. 10. Answer validation: So in this lesson, we want to go through the option to validate the answer off the questions this option is serious for especially wanna include questions or have a complete form off the quayside off test type of Simon, depending on what you want to achieve. So, for example, let's start with them short answer of type of question and typing, Uh, general question. And for this sort of question, we may want you find over. Add some limits to it, and this limits can be related to you or text lands, regular expression or number. And, uh, our example is regarding the text. So we should go that. So, for example, we can put some rules that the text does not contain a specific work. Dabbed, um, contains a specific word. And also another one option is the lens off the text, for example, to be minimum 10 characters or maximum 100 characters and so on. Whatever the rule you want to set, you can do dad and also display error message, for example. Now, I didn't add any custom text for on error. If I do not comply with the rule at the creator of the survey had set. So if I tap on something now, I will receive the message. That answer must have at least and characters. And this use case this'll kind off message is fine, because is now no secret that the answer should have at least and characters. But another situation. For example, Let's say we do have a quiz on the study month and you ask, usually see answer. How much is the tree plus five and this type of question? First of all, Google Super smart, and he identify automatically what a few question it is. So it moves to short answer on also created validation response So you can move this if you don't want to add a validation sponsors. But in this type of question, and Google kind of intuitively thought that you may want to other responsible Dacian and just display the option to set it. So, for example, in our case with this question, we want to set a rule that a the the respondent can go to the next question only if he did after correctly. So we want the number to be equal to eight, right? So in this case, if we go and reviewed the question, and we try to answer incorrectly. You will get a message that the number must be equal to eight. Or maybe you don't want to tell the respond them, which is the right number, because, being a quizzed, he needs to find the right answer themselves. So in this case, you can add a custom error type. For example. Please try again. And in this case, if we go back to privy our question and Seiple on incorrect number, we will see a custom text message, which is great, and the user should in this case, try again, and only when he could. She, responding correctly, will be able to go to the next time. Let's go to another type off validation, for example, for a paragraph here, the user should. The responders should add the more consistent reply. Not just a short dancer again, even if it's a long paragraph, you can also say toe land rule not to have, like 1000 words or characters, but just 200 and another thing you can set is regular expression. That it does match a specific expression doesn't match doesn't contain a hunting ending on the needs. You have for a specific question, you can add several rules to your questions. As you can see for specific questions, you do not have the option to validate and settle. So you do have validation for short answer paragraph are you do not have the validation for all. All the question of staff you have available will go for us. So this is It's regarding the validation off the answers. I usually use this option and future if you have a Simon, a test kind of survey for a not a survey through which you kind of gather some input from your audience. But it's nice to know what kind of options we have. Maybe it will be useful at some point in time. And another thing. Remarkable Day Shinzo. This this one is not used that much anymore, considering to the new option of Google offers. For example, you can request an email address using either the option that Google sets automatically when you create form by using the collective meant address option. All you can add like a separate question in your for as you notice when I typed email in my question field, go automatically more said it as short answer, and it gives your suggestion to use enable in May collections. That thing, which looks different on, is in the first section off the survey. If we still want to try collecting it in wait as, um, foreign question were moved after general set things and go back. And in this case, what I wanted to show you is the fact that you can said, um, specific condition and rule for the inmate field. So, for example, Weekend said it was a role at his needs to be that calm. And in this case, if we go to provide a question and we try to booth an email address and some meat weekend off. But the only thing it tells me is must match a pattern, which is non. It's certainly very informative, and you can use that feeling tea set specific next hour 11. Add a ogical flow: so you can use simple contact form with only off your fields. But when you do longer surveys, you can quickly get overwhelming with dozen off questions on one page or um, for a specific type of surveys on depending on the respondent state it may send. It could may stand for that responded to continue with one or another set of questions. So, for example, as you can see in the survey shown, you can have a survey Teoh address some questions, too. People that to conserve in the last year or they did not Degussa rate in the last year, so you may not want to show them questions regarding what type of survey did you took. If they answer, they didn't took any any curse. So you have the option to kind of break your form into chunks, and the answer wants that of questions at a time. And this come very handy by starting with section so you can know where questions should go and give her more off user friendly title and description, because this will be shown to the respondents as well. You can drag and drop question before sections, So just in case you wanna kind of moved from one section to another? You can do that very quickly. Or another tip is if you buy, we stayed the leader. The question just dio press control z annual kind of undo the action. So it's a perfect way to start for with logic, jumps, say one Jascha respondent for our questions, based on the answer on behalf to ask which kind of meal and s and d to an event wants. But, for example, from the attendee is not vegetarian, and you want to ask them what kind of meat the prefer you wouldn't want as that vegetarian , so that might create very uncomfortable experience for for that person. So in order to create it, logical jumps it's very easy to do that you can dio create a logical jumps for entire section. So, for example, we discussed over it is this you can send an easier from for section to the other section and so on, But but a garden, um, jumps for a specific answer. You tap on the tree docks where we find validation options as well on you select go to section based on answer. So, for example, in our case. If the user says no, they did not take a curse in the last year. You want to send them to the section specific rated for those that did not took the curse in the last year. Similar for those that replied, Yes, you want to take them to the set of questions that they did took occurs in the last year. So, for example, data of the person that did occurs we want to ask them if that charisma meet matched their expectations. And if they didn't, you can ask them in what kind off classes are they interested in the following period, or if they aren't interested in any class federal? So this waas ah, vory quick wrap up. Overview off how you can create logical jumps into your survey or for work, any type of form you intend to create. Be creative with with the questions and from section and jumps that will let you turn your form into a meaning application on this can be a great way to condense detail surveys down into only the most important questions for each person, which in the end, will we'll show up in a very high conversion rate off your respondents 12. Questions types: so you can use simple contact form with only off your fields. But when you do longer surveys, you can quickly get overwhelming with dozen off questions on one page or um, for a specific type of surveys on depending on the respondent state it may send. It could may stand for that responded to continue with one or another set of questions. So, for example, as you can see in the survey shown, you can have a survey Teoh address some questions, too. People that to conserve in the last year or they did not Degussa rate in the last year, so you may not want to show them questions regarding what type of survey did you took. If they answer, they didn't took any any curse. So you have the option to kind of break your form into chunks, and the answer wants that of questions at a time. And this come very handy by starting with section so you can know where questions should go and give her more off user friendly title and description, because this will be shown to the respondents as well. You can drag and drop question before sections, So just in case you wanna kind of moved from one section to another? You can do that very quickly. Or another tip is if you buy, we stayed the leader. The question just dio press control z annual kind of undo the action. So it's a perfect way to start for with logic, jumps, say one Jascha respondent for our questions, based on the answer on behalf to ask which kind of meal and s and d to an event wants. But, for example, from the attendee is not vegetarian, and you want to ask them what kind of meat the prefer you wouldn't want as that vegetarian , so that might create very uncomfortable experience for for that person. So in order to create it, logical jumps it's very easy to do that you can dio create a logical jumps for entire section. So, for example, we discussed over it is this you can send an easier from for section to the other section and so on, But but a garden, um, jumps for a specific answer. You tap on the tree docks where we find validation options as well on you select go to section based on answer. So, for example, in our case. If the user says no, they did not take a curse in the last year. You want to send them to the section specific rated for those that did not took the curse in the last year. Similar for those that replied, Yes, you want to take them to the set of questions that they did took occurs in the last year. So, for example, data of the person that did occurs we want to ask them if that charisma meet matched their expectations. And if they didn't, you can ask them in what kind off classes are they interested in the following period, or if they aren't interested in any class federal? So this waas ah, vory quick wrap up. Overview off how you can create logical jumps into your survey or for work, any type of form you intend to create. Be creative with with the questions and from section and jumps that will let you turn your form into a meaning application on this can be a great way to condense detail surveys down into only the most important questions for each person, which in the end, will we'll show up in a very high conversion rate off your respondents 13. The Dichotomous questions: did I. Cottam was question survey is generally a yes or no question you far seeking information only about product users. You may want us this type of question to kind of skin out, eliminate those who haven't chased your products or services. So researchers used screening questions to ensure that those people that are interested in participating in the survey you might also want to use that gotta most questions to separate respondents or branch into groups or those who have for chase or those who had not been chased. Your product or service is once they're separated, different questions can ask Teoh each off this groups. So, for example, when we discuss creating ah, logical flow over survey, you will use a dichotomous question to kind of start the the logical flow off the survey. For example, I already have here question at it, but I will delete it and re avid. So basically, with this question, I want you screen out people who had a Google from cars and they those who didn't in the last six months, for example, Google, already suggestive of the options on that, simplifies your creation very much. But we are not interested in May before now, but you can use this as well to go forward. Er you will follow the steps that we discussed in the previous lesson, meaning you will go to the three dots and choose go to section based on answer. You should do that after you already created your section. So as we discussed, you will design your survey before you can actually come and Google Fourth and start building. You'll already have your structure. Your section decided information to add description and so on. Because if you start just adding questions here in Google form on, think of the questions as you go on. That will take more time and finalizing the survey. So, for example, will choose to go to Section one if they took a survey occur. Sorry to ask them for the run about the quality and the satisfaction for that curse. And if they didn't, they will go to another section where we can ask users. Respondents Teoh tell us more about what curses. They may be interested. I usually Google sets up automatically the type of questions based on the text that you input in the sytem 14. Multiple choice questions: did I. Cottam was question survey is generally a yes or no question you far seeking information only about product users. You may want us this type of question to kind of skin out, eliminate those who haven't chased your products or services. So researchers used screening questions to ensure that those people that are interested in participating in the survey you might also want to use that gotta most questions to separate respondents or branch into groups or those who have for chase or those who had not been chased. Your product or service is once they're separated, different questions can ask Teoh each off this groups. So, for example, when we discuss creating ah, logical flow over survey, you will use a dichotomous question to kind of start the the logical flow off the survey. For example, I already have here question at it, but I will delete it and re avid. So basically, with this question, I want you screen out people who had a Google from cars and they those who didn't in the last six months, for example, Google, already suggestive of the options on that, simplifies your creation very much. But we are not interested in May before now, but you can use this as well to go forward. Er you will follow the steps that we discussed in the previous lesson, meaning you will go to the three dots and choose go to section based on answer. You should do that after you already created your section. So as we discussed, you will design your survey before you can actually come and Google Fourth and start building. You'll already have your structure. Your section decided information to add description and so on. Because if you start just adding questions here in Google form on, think of the questions as you go on. That will take more time and finalizing the survey. So, for example, will choose to go to Section one if they took a survey occur. Sorry to ask them for the run about the quality and the satisfaction for that curse. And if they didn't, they will go to another section where we can ask users. Respondents Teoh tell us more about what curses. They may be interested. I usually Google sets up automatically the type of questions based on the text that you input in the sytem 15. Scale questions: the scaling question times are not simple questions with answer yes or no. They're more based on agreeing or disagreeing on a certain aspect addressed in the question . So this are essential in measuring responded opinion or attitude towards a given subject. This case is typically 57 or nine point agreements Kate used to measure. Respondents agreement with the variety off statement, so like a scale could be in a polar or bipolar, and we'll see immediately what that means. Only poor scales. Ricardo, respondent to Rada. Degree off presence or absence of a particular quality, such as usefulness or satisfaction. This is often done. We using a five point scale. So, for example, let's out after this question on your question. And let's ask our respondents about how likely our day two recommends this curse, too. A friend automatically, um, Google identified this question as a linear scale. So we mentioned that we I have for this Unipol or scare five points. So as an option, we can foot another type of scale staple skilled, and this is usually used to measure the Satish satisfaction or, uh, off the respondent. So if we add a new question off small remark here. If we want to have a question, be sure that you tap selected. The question that will be in the front of the question went off course afterwards. You can you can move, removed the questions and we drag and drop. But it's easier to have the selected. Otherwise, it will be added to the last section for question that you select. So let's see how the staple scale looks like again. Go, go identified this and for this type of scare, we usually have, like off 10 points, 10 points and where one can be very likely. And then we'll be very likely. So the same thing We measured agreement or disagreement of the user. What you can do also for this type of scale, you can not exactly this question, but in other situations where the text so allows it, you can use emojis Teoh represent extremes off the scales is not appropriate for our question right here. But it goes farewell with another. Another type of questions 16. Matrix questions: so metric. Stable questions are arranged as a tabular format, with questions listed on the left of the table and the answers. Options are at the top of the table. There are multiple variants off the magics questions, but we're go through today to see two options off days with multiple question used. So moved two points. Case allow respondents to select only on option for for a specific topic. Subject. Why Multi Select allows them to select multiple options. So what that that means aides, For example. We kind of discussed a multiple choice and checkbooks. Single options. In the multiple choice case, the respondent can choose one option. Where in the check boxes case the user can click and select multiple options. The same thing applies the same rule through the metrics questions. So a metrics table question with a single option is named multiple choice. Great, similar to the first question that we discussed and similar. A metrics table question where the other cancers, like multiple answers his name. Checkbook Street. So we'll start creating several questions for this type of magic stables and, for example, we'll ask. Here's to you specify if they agree or disagree with some and will add the first metric stable question to get a little picture off. How these look like as you've seen immediately after facing the question text title Google . Switch it to multiple tries. Grade. Andi You will see section name Rose in the sectioning columns. Throws is for the values and columns is for the answer options. So let's put our values first, for example, and the state months Teoh find more about of how the respondents, how the participants to discursive, felt about don't specific aspect of it. And as SK, we'll have strongly agree. I disagree. Neutral, I agree, and strongly I agree. If we want to see how this looks like for responding, we tap on proof you go to the section where the question was at it. And as you can see, I, as a respondent, can choose on option for each state, one that we included in the question. This is one type off Matics question, and it's also ah scale question because you kind of scale each state one that we would place there. You can use multiple choice option as well, but you will have one statement or question so What metrics table question allows you is to kind of condense and group the same specific type of questions you want to ask the user if he agrees, disagrees or is satisfied that satisfies in regards to a specific value. You can group more values and ask the questions at once, then include, like seven questions for that topic. So this is very helpful. Another type of magics question is check box Good question, which is work similarly with the difference that I, as a user, will be able to select multiple options that I listed in the answers column section as they wrap up for quick tapes when you I want to write good magics question is to keep response options short a short as possible. As you can see, these are quite short. Never used too much text or words to express the option. Try to display only five or fewer response options. This is easier to scan and true understand, and to reply to the metrics table question in the ter place. Keep the item wording. Short items are the the roads. So basically, this are the items, the values that we want to address. Uh, we I cannot say that the current on are very short, but are not very long, either. If we go and look how are display in the final survey? But even though item will be in the for example, with the double number of characters that we have here and each off the items doubles its land, that's a very one. Look pretty good, and it will be even difficult to reply to it because you have to read a lot to understand the question. And last but not least, the four recommendation is again. Try to display five or less items as well as we suggested for the answer options to have five or less items and five point scale for the answer options you can find. Ah, lots off metrics table question examples over the Net. Do a search and take a look off Howie. You can formulate specific questions to gather the information that you need 17. Ranking questions: so metric. Stable questions are arranged as a tabular format, with questions listed on the left of the table and the answers. Options are at the top of the table. There are multiple variants off the magics questions, but we're go through today to see two options off days with multiple question used. So moved two points. Case allow respondents to select only on option for for a specific topic. Subject. Why Multi Select allows them to select multiple options. So what that that means aides, For example. We kind of discussed a multiple choice and checkbooks. Single options. In the multiple choice case, the respondent can choose one option. Where in the check boxes case the user can click and select multiple options. The same thing applies the same rule through the metrics questions. So a metrics table question with a single option is named multiple choice. Great, similar to the first question that we discussed and similar. A metrics table question where the other cancers, like multiple answers his name. Checkbook Street. So we'll start creating several questions for this type of magic stables and, for example, we'll ask. Here's to you specify if they agree or disagree with some and will add the first metric stable question to get a little picture off. How these look like as you've seen immediately after facing the question text title Google . Switch it to multiple tries. Grade. Andi You will see section name Rose in the sectioning columns. Throws is for the values and columns is for the answer options. So let's put our values first, for example, and the state months Teoh find more about of how the respondents, how the participants to discursive, felt about don't specific aspect of it. And as SK, we'll have strongly agree. I disagree. Neutral, I agree, and strongly I agree. If we want to see how this looks like for responding, we tap on proof you go to the section where the question was at it. And as you can see, I, as a respondent, can choose on option for each state, one that we included in the question. This is one type off Matics question, and it's also ah scale question because you kind of scale each state one that we would place there. You can use multiple choice option as well, but you will have one statement or question so What metrics table question allows you is to kind of condense and group the same specific type of questions you want to ask the user if he agrees, disagrees or is satisfied that satisfies in regards to a specific value. You can group more values and ask the questions at once, then include, like seven questions for that topic. So this is very helpful. Another type of magics question is check box Good question, which is work similarly with the difference that I, as a user, will be able to select multiple options that I listed in the answers column section as they wrap up for quick tapes when you I want to write good magics question is to keep response options short a short as possible. As you can see, these are quite short. Never used too much text or words to express the option. Try to display only five or fewer response options. This is easier to scan and true understand, and to reply to the metrics table question in the ter place. Keep the item wording. Short items are the the roads. So basically, this are the items, the values that we want to address. Uh, we I cannot say that the current on are very short, but are not very long, either. If we go and look how are display in the final survey? But even though item will be in the for example, with the double number of characters that we have here and each off the items doubles its land, that's a very one. Look pretty good, and it will be even difficult to reply to it because you have to read a lot to understand the question. And last but not least, the four recommendation is again. Try to display five or less items as well as we suggested for the answer options to have five or less items and five point scale for the answer options you can find. Ah, lots off metrics table question examples over the Net. Do a search and take a look off Howie. You can formulate specific questions to gather the information that you need 18. Constant Sum Questions: and another tackle question again is not available with Google forms. And unfortunately for this one, I didn't find a way to kind of integrated and based on what options we already have available. And that's up a question. Is his name constant? Some survey survey question on what this means is you basically have Teoh, for example, allocate 100 points between several values that you are evaluating. This is another way for a user for responding to kind of said the importance or what specific, uh, attribute that you are trying Teoh to measure. But unfortunately, this type of question is not in Google forms, and I will agree that it's for the best, because it maybe maybe a little more difficult for a user to kind of calculate that in order to set the importance on for specific value 19. Design: we can design. There isn't that much you can do You with Google forms the things you can adjust our it's the color off the heather or place it it an image and also the color off the background by the phone We're form is designed, as you see in the current screen, with this part of all that purple for invents purple heather and a very afraid we're in the background. In order to change the corner, you need to click on the I cannot, with Connor ballot on the top right of the screen and adjusted as you wish. You can select from pretty fine colors and pre listed here. Or you can click on plus and either selected by sliding on the polar scale. Or you can add directly the hex cold here off your off your wanted corner in order to get this crowed or idea for a ballot. There are pent up tools on the Web I willing, into the results of some tools for you to get inspired. Spend from the section below. You can change the background as so the background color basically is automatically generated starting from the main corner, but you can choose between four shades off the color, so it light medium dark and great. You can also change the phones, but you don't have Teoh. Many styles cover for gratifying bones and regarding the heather image. Telephone heather Choose image. You can opt in for selecting an immature offered by Google in the local gallery, or you can upload from your albums or from your computer. There are plant or free stock images though you can. You can choose whatever works best for your surveyed. Please keep in mind that the size off the image is quite small in terms off height. So, for example, if you see here the image that we added, it's not shown completely. If we go again to change the image, you will see the original image is actually bigger. Contains more element and you when you add it to the header, which has a small height, it won't include everything in the ordinary image, so you need Teoh pressure size it so it does include black. You want to be shown and also considered that in this section it will be covered by the survey free. You can also add videos and you can important search you too, or added, based on on a link off the video. Thank searchable the video and, added Teoh, have a feeling or how it looks. And if we look from the respondent perspective, you can see the some mail off the video and you can play. This is various for indicates you kind of want to make a video registration or construction or explanation of a product or even a Simon, depending, which is the purpose. What is the goal off your survey or if it's an important for placing on order? You can also add a video explanation for it they use. It needs to do something, so that comes in handy. 20. Save, print and collect answers: Now that we learn how to design and build a survey with Google forms, let's see how we can save it. Organizing on share it with potential audience potential residents but also with college and collaborate. So, first of all, from the fuller icons are placed in the left top corner, you are able to remove the survey around your photos in cooker drive. This is super in useful because you can quickly move it without going to go go drive. To do that. Also, you can tap on style and know that helps you. I mean this this form into the star files, which can be quickly opened by tapped by click on Start from Cougar Drive. Instead, off. Going and searching the file or opening the fuller were where you save it from the tree darts situated next to your profile picture on the sunblock. You have other much of multiple options. You can delete it and then you'll be redirected to the drive dashboard. You can make a copy, we can print it, and when you choose, bring you have an additional option to save it at speed E F or 70 Google Drive or select the printing. You have connected your computer and printed in regards to other settings. We also have preferences, and here you can set some specific options you want that will be applied. All forms like collect email addresses and also all questions make questions. If I it will be by the fold on, and you can then individually adjusted when you create before regressed, Teoh replies to the form that you just created. If you tap on responses after this is completed, you'll notice that it's no responses, an important option you have. For example, you want to stop collecting replies, but the link would share. The mail was sent. You cannot pass, really. We drove those what you can do east. You on not accepting on the slider off steptoe responses to deactivate it into not accepting responses. So, using this option, you will be able to stop responders that camp user that have building form not to fill it out, and you can no, you can add an additional message to them when they try to open it to reply. So this is very small from the three gods. Next to the extent Michael, she typed, not extended seven Microsoft. We have additional options. You can download the responses in a C S B format. Can the little responses can only the initial sheet form where you start to perfect with you can get a May notification for new responses. This is very useful. So tapping this option if you wanna receive any May when someone you replied to your survey and you can select the response destination, that means that you can select an existence spreadsheet that you may have or creativeness pressure aggressing iss if you by mistake in the fun you deleted the replies Private steak . What you can do is from the tree dots next to the sheikhs icon tap on ongoing form that once you did that tap on the sheet, I could, and that will regenerate the answers in a specific fight. This is very small in just in the case, you can know corrupt initial filed with the responses 21. Visualising results: So now, Doc, you're for is done on Shared and it's running used Dumber getting stepping on top with Booth. But if you want you on the lines, you have the option to you opened. She was I don't know that's more to. So you have a sheet with dancers and you get great sheets in this fun Maybe easy to angel eyes on, interpret and understand what runs did you get? 22. Collaboration: once the thing this is a very is completed, you will definitely want to get some input from your Pollitz. Also, while building this survey furans but operate with college, you have the option to add collaborators right clicking on the tree thoughts icon and choosing at collaborators. You can add new car legs new people by inserting their email address. Also, you can add an optional message. Do not fight them. Why they're rescinding the invitation to join the survey. Also, you can change your privacy. Blink, sharing off the surveys so public on the Web. Anyone with the league and off only with specific people by seven billion. One important deep before doing this before sending the survey to collaborate with other people so they can actually change the content of the survey themselves. You maybe want to create a copy of the surveyed to have also need initial four off the form before other people start adding their the thoughts and everything. So, question. When's you kind of agreed Meter college that you are ready? Teoh, go with survey problems. You have several options to share it again. You may want to have a second copy off the survey so you can tap on sent and you have at your disposal to re options. You can embed the cold into a webpage or whatever you want to put it. You can change the dimension off. The survey, ideally, shouldn't be two sides because the question won't be visible, and also the high should be quite biggest laced. 600. Maybe with you doubt the considerable hide the survey will be difficult to scroll and to see the questions. Another option is to share it with people we are pulling, and we also trade directly Paper court from Twitter. You might want to you when you use the link, you may want Teoh exact click on the shorter blink Teoh have a sort person off the U. R. L and first and third option. As to seven year E. Might you type the email addresses that want to send to also subject and a message? What we can you can do by using this option east to top, include for him in the main. And what that will do is Teoh insert. Actually, the survey into the inmate and people were on Gmail. Look, they have a Google account, they will be able to reply to go to survey directly from the email without opening into a window and start feeling down the survey. So you have plenty of options options due to share it, also using Adams, and we'll go in more depth. Another lesson. You can share it the various platforms you may be using, like a last warning for for customer service, best for orders. Anything you may think off, there is adamant and you may able to merge and integrate surveyed with your tools. 23. Other tips and tricks: There are a lot of add on stools that can help you with the savory building on also processing and making the best out of a form. So the 1st 1 is you might notifications. We saw that we have this option here, but in order to have the option, we need to add another and on and to add add on you need you need on Adams and you will be able to search for the wanted agony. For example, the for modification. It's this on. You either use the pure space to searching for have it as the eighties for me displayed in the top, every ardent you were selected and click on the bottom that people be here saying install. I already install it, so oh, I have the option to manage it. Another useful add on is form recycle. It's free as well, and as it says here, perhaps you recycle questions from other forms in your goods line by selecting them, even recycles back home pleases. You will help your lost in speed up the process of being oh surveyed. Let's installers is it, says the loss we need to be covered from Google Drive to his question. Students circuit, but burning for it's No let's do that, watchers. The survey sampling we can't created during this course it seems that second snow one. So why is the at the end unusual? Because you can are able to select only some questions seem port on. You can do that in multiple forms, so you basically meets multiple forms in a very quickly way that is not available. If you use, for example, duplicate for that's when you duplicate form. Copy the just the question from 14 And to add new question there, you have to add it, man. So with this till you can actually mix in super easy steps, questions from 1 to 3 or ex forms that you have created in your workers are become. I will random me to some fractions just kind of show the flow off this ever snow. Here it's, it's we kind of created a four less than two minutes, which is great, but in order to do this, you need Teoh have quite a good group off surveys over the created testing and that proved to be efficient and your nose to combine questions from those for war. You are not a lot of Adam's that you can use process and work. No. Do you go the productivity or the efficiency on the form and in order, Teoh, look for new ways to improve your prospects. You can open wagons, my foot store and look for what you are interested. I will also length in their searches area for this lesson. Other top of another settle Adams that I used. Usually when I form a great form, but again go to the Adams Market Store and before you add, don't that could help your costs.