Invite Sign Form Simple

Sign-in, Sign-Out Roster Form

in this video we're going to see how you can create a sign-up sheet for your students this could be for a volunteer activity or really for anything that you would like your students to sign up for I have a few items that I would like to include in my signup sheet including full name cell phone number and the rest of these items over here the way that you can create a sign-up sheet is you need to have a Google account which I already have so I'm going to go to Google and what you want to do on this page is click on the apps link select drive and this is going to take you to your Google Drive page hopefully you already have one if you do not have a Google Drive page you will need to sign up for one it is absolutely free once you're logged in to your Google Drive you want to select new scroll down to more and then to Google Forms click on it this is going to go ahead and open up the area where you can start creating your form the first thing that I'm going to do is create or change the theme for the forum because this kind of looks a bit bland so I'm going to click on change theme you're going to be presented with several theme options on the right menu panel I'm going to select the homework as my option and I'm going to start working on this particular signup sheet I'm going to create a signup sheet for a volunteer event once you've selected a theme click on edit questions I'm going to give my form a description when you're creating your questions you are able to create questions that are in multiple choice format text fields checkboxes scale grid date and time for my particular purposes I simply need to create text boxes where students can fill out information so I'm going to select text and the first question is their first and last name if you want to make this a mandatory question that students have to answer be sure to check the required question box once that is done go ahead and click on done and add another item I'm going to select text again and I can create my second question and I'm going to go back to my list to see what my second option was okay so I need a cellphone and email address and student ID you'll notice that there's a field labeled help text this is an area that appears under the title where you can provide an explanation or a description if necessary for example since this is a phone field I'd like my students to present their phone numbers in the following fashion area code and then the number - and then the number here this is required click on done and there's a description and the actual title of the field the last question is actually more of a multiple-choice question I want to find out which of the classes that I'm currently teaching students would like to apply their extra credit for volunteering towards so the question could be something like this I'm going to select the choose from a list and I'm going to give students multiple choices the first one is HRM 51 the second one will be HRM 64 that's it so the students taking any one of these classes they are able to apply the extra credit to one of them simply by selecting and I will make this an optional question so I'm not going to click on required when you're done you can go ahead and review your signup sheet and if you'd like to add a description you can just go ahead and type it over here I don't think I'm going to provide one at this point we are done with the form if you'd like to see what the form looks like all you need to do is simply click on the view live form once you click on this it's going to open up a new tab with the actual live form there you go and there's a life form one thing I typically like to do when I'm creating these forms is I usually like taking the link to the form and creating a short version of this and emailing that to my students so I'm going to copy that link open a new tab you can go to google and type in google short nerv there we go select the first option and all you have to do at this point is type in the entire link that you copied and click on shorten URL this will create a code over here on the side which is a shortened version of the full URL press ctrl C if you're on a pc or command-c if you are on a mac or simply right-click and copy that link if I were to paste that link right over here it'll take me to the form now if you would like to see where this form is located and if you'd like to see the responses to your form you can access that through Google Drive so I'm going to go and close all of this over here we've already created the form if you go back to your Google Drive you'll notice that there is a form that is listed right there it is a sign-up sheet for volunteer event if I were to click on it it will open up a new tab and there's a forum if you want to see the responses simply click on the view response link which is at the top of the forum you'll notice also that it says that currently there are zero responses because no one filled out the form so let's go ahead and click on the live form and complete this form just to see what it looks like great once the student submits the form they're going to get this page right over here if I were to go back to my original sheet you'll see over here it says that there is a one response so I can click on response and there are different ways that you can look at the responses you can go to the summary of responses and see who signed up or you can click on view responses and it's going to give you an option of creating the responses in a spreadsheet which is really a great option so I will click on the create button as you see this option basically creates a CVS or a Google sheets version sort of like an Excel version of the signup sheet it shows me the time that the person signed up with their name cell numbers - all of the data is over here it's very easy to download this if I ever wanted to I can simply go to file and I can download it as an excel file or as a PDF if I want to or a CSV which is a comma separated values file that's it for this tutorial I hope you found it useful if you did I would HIGHLY appreciate it if you were to subscribe to our Channel and if you'd like to find out more about us please visit us at faculty workshop com