Supercharge Google Forms with Add-Ons

hello and welcome to today's webinar supercharge Google Forms with add-ons this session is part of a series of free webinars offered every week or two by the start portage area computer consortium or SPARC for short SPARC is an information technology center up here in Northeast Ohio where we support about 30 school districts however this webinar is open to everyone and we'd like to welcome all the people who have joined us live today or are watching the recording in the future my name is Eric Kurtz and I'm a technology integration specialist here at SPARC and I'll be your presenter for this session today I am joined by my colleague Anthony lucky and Anthony will be monitoring the chat we'll talk about that in just a little bit and explain how to get into that all of the information for today's session can be found at tiny dot CC slash spark SP AR c c23 v now if you're watching this live you're probably already at that site but if you're watching this recorded in the future you might not be so what definitely encouraged you to go to that website when you do it will bring you over to this page right here and this is the web page for this particular session so if you scroll down here you will find the live video that you guys are watching now which will become the recorded video afterwards so you can always come back to the exact same page you're at right now to be able to view this again or to share it with other people below that you'll see a section for session resources now not a whole lot of resources today just to help guide and a slideshow we're going to run through the slideshow together but I've opened up the help guide in another tab so you can see that real quick basically it's going to cover the material that we are covering as to what are add-ons how do you install them how do you then use them once they're installed how do you remove them if you want to get rid of one and then a list of add-ons that we're going to try to get through now we may not get through every single one of these in the hour but these are all forms add-ons that I've had a lot of success with and really enjoy and definitely recommend so that hand doubt goes along with our session today and can be found right under the video now below there's a section for the live session chat document if you give that a click it's going to open up a Google Doc and you've got full edit rights to that you can ask a question share a comment help each other as well if somebody has a question and you know the answer hey please feel free to fill that in now Anthony's gonna be monitoring that document so he'll do his best to put answers in there as well and if for any reason there's something that doesn't get answered he can let me know at the end of the session if we have a little bit of time to take a few questions and I'll be glad to address those as well below that is the session evaluation just a quick little Google Form if you don't mind filling that out afterwards your feedback is always appreciated and finally say something in this for you how about earning a certificate of attendance yes when you're done watching the webinar we have a short little quiz here at the bottom you can take and once you pass that quiz you'll be emailed a PDF certificate of attendance for one contact our for watching the webinar fantastic now while you're on the site feel free to also check out a few other things we have there we've got across the top a link to our upcoming PD schedule so you can see all the other webinars that we have on the horizon and then next to there is a tab for our recorded trainings we're actually up to 33 recorded webinars already so there's a ton of topics there on a lot of Google related things but educational technology in general definitely check those out while you're there there's also a newsletter link at the top you can sign up for our sparklines newsletter so you can stay in the loop on all the new things we're doing and webinars and PD opportunities and finally there's a link there for contacts you can get in touch with me or Anthony if you need to fantastic all right well let's go ahead and we'll just head back to the page very good and jump on over to our slide show and let's get started so our agenda for today is we're going to start by talking about what are add-ons how to find and install them how to remove them if you decide there's one you don't want and then after that we're pretty much just going to spend the bulk of the time going through a whole bunch of add-ons that I think are excellent options for schools to use what you need to be successful in this session ah you will need a Google account can be a regular gmail account that's perfectly fine or Google Apps account and of course you'll need access to Google Forms since we are looking at add-ons for forms it would help to have a general understanding of Google Forms we're not really going to turn this into a session about how to use Google Forms there's plenty of information on our previous webinars on that so if you want to learn more about that I'll show you real quick if I head back over to the tech integration page and go to the recorded trainings I've done two of them already one on basic online assessments with forms and another unadvised assessments with forms and those have a lot of great information on how to use Google Forms so if you don't know anything about forms there's some wonderful resources there to get you guys started as well this one we're going to be focusing just on the app Don's alright so on with the session don't forget tiny CC slash spark SP ARCC 235 is where all the resources are in alright so let's start off with a little overview of Google Forms add-ons so first thing first Google Forms itself I guess we'll do a quick overview of that in case you're not familiar Google Forms is one of the pieces of the Google Drive suite so you've got Docs and sheets and slides and drawings and forms now forms lets you create surveys quizzes questionnaires polls pretty much any kind of form that you could normally have on paper you can convert into an electronic digital form with Google Forms it supports nine different types of questions that you can use you can also insert images you can insert videos it can be anonymous which makes a lot of sense for polls and questionnaires and things like that or it can collect usernames like if you're doing a quiz and you want to make sure you know who the student is basically you create a form you share it online for other people to complete and as they do the data gets collected into a Google sheet in the background and there's much much more to forms beyond just that but that's the gist of what Google Forms is about now Anton's well here's the idea even though forms is awesome and it really is I absolutely love Google Forms I think it is such a powerful program that has so many applications in a school situation even though it's awesome it doesn't do everything that Google is always adding new features but in the meantime Google also allows third-party developers to create what are called add-ons which give you extra features things that are not normally found in Google Forms now who knows maybe someday Google will add these as features that are just built-in but until that time comes we can use add-ons as well all right so how do you install add-ons now fair warning everything I'm gonna be showing you today is in the new version of form I say new as of March 2016 you could be watching this recording sometime in the future and it won't be the new version of forms anymore it'll be the the normal version by that point but for a lot of us we have just recently switched over from the old version of forms to the new version of forms I am NOT going to be referencing the old version at all everything works the same I mean all the add-ons they all work and all that's fine it's just the buttons are kind of in different spots but I will be using the new version of forms for all of my examples here today so how do you get to add-ons well I'll fire up a form here in just a moment and show you that but the general idea is in the top right hand corner there's these little three dots in your form which is actually the more button and if you click that you can go down to a section called add-ons that will get you into an add-ons menu and once you get into that add-ons menu you can browse through all the add-ons that are there and when you find one you like you click the plus free button and that installs it so let's try that out so I'm going to open up Google Drive over here I've already got it open so I'm going to pop over to my Google Drive tab and I'm actually in the folder for our webinar today I'll just use that folder since we've already got a bunch of stuff in there and what I'm going to do is I'm going to create a new Google Form just to show you the idea of finding and installing an add-on so from Google Drive I'll go to the top left hand corner here where the big happy red new button is give that a click from the drop-down there I'll go down to more and then Google Forms Google Forms does get hidden a little bit it's not in the top tier you got to go down two more and then from there you can get to Google Forms let's go ahead and create a new Google form give that a moment to pop up there we go and so here is a nice blank simple new Google form again using the new Google Forms option rather than the old version and in the very very top right hand corner like I mentioned there's these three little vertical dots if I hover above them it says more that's the more button if I give that a click I get a drop down and from that drop down one of the options is add-ons if I give a click on add-ons it now opens up the add-on browser now if you're used to add-ons in Google Documents or Google sheets same idea and that's of an important point to mention add-ons don't exist for every program they work in forms and Docs and sheets at the moment there are no add-ons for Google slides and Google drawings now I'm hoping in the future that won't be the case that you know maybe if you're listening again in the future maybe it's not the case anymore I would love for there to be add-on for sheets and drawings or should't for slides and drawings but there's not at the moment so it just forms Docs and sheets having said that add-ons only work within the program you install them for so if I install gmath for forms it doesn't automatically show up in Docs and sheets there is a gmask for Docs and sheets but i'd have to install it separately for those programs so basically this is the browser and you just kind of scroll down and you look to see the add-ons that are there now there's not a ton for forms it's growing all the time we're getting more and more and more there's not a ton though compared to the other programs so let's say I find one I'm interested in so I'm going to grab form Ranger a form Ranger is one of them on our list for today I don't know that we're going to get a chance to really do too much with it so this will maybe be the covering a form Ranger for us today so if I find an add-on they go hey this looks kind of interesting what I can do is just hover on that add-on and just give a click on it and when you do it's going to pop up a screen where you get more information about the add-on this can be a great way to decide do I really want to install this what does it do is this worth using normally you'll get some pictures you can scroll through here that will show you how the program works sometimes there's even a video here you can play like a YouTube clip that's great below that if you scroll down there'll be a section called the overview where you can read more about the add-on that can be really helpful to get a better idea of what does this thing actually do and then below that is a section of user reviews again very helpful to read what have other people said about this add-on and forum Rangers a lot of really nice 4 star 5 star ratings lot of good comments so that would be encouraging for you to say yeah I think this looks like a good add-on you can also look up at the top here and see how many users there are we've got over 54,000 users for forum Ranger if you look at all that and decide yep I think this is a pretty cool add-on which by the way if you don't know what forum Ranger does basically it allows you to dynamically populate the options in a forum so if you've got a question instead of you typing in all the possible responses and the multiple choice or the checkboxes you can point to a column in a Google sheet and it pulls from that column and it throws those options in for the answers that column could be something that you're typing in or that's being calculated by some spreadsheet formulas it could be a column that is coming from another form that then feeds this form so it's pretty neat a lot of options for it if you decide hey I think I do want forum Ranger all you have to do in the top right you see a big happy blue plus free button give that a click and it'll ask permission add-ons always say here's what they need to be able to do do you want to give it permission scroll down down down down down click the allow button and as simple as that the add-on gets installed now the important thing to realize here is this is a one-time process you don't have to install the add-on every time you want to use it on a new form it's being installed not to your computer not to this particular form it's being installed to your account so anytime using my same account that I go to Google Forms that add-on will now be available for me okay of course I can get rid of it and then reinstall it but the nice thing is I don't have to reinstall it just to use it over and over again so that's how you install an add-on let's head back over to the slideshow and talk about how do you launch them after you've installed them well the idea is after they've been installed you'll get this little puzzle piece add-ons icon up here in the top right hand corner and it won't be there until you have some add-ons but once you start installing them it'll show up if you click that you'll get a drop down showing you the add-ons you have and you can just pick an add on from there to launch so if I go back over to my form and I go up that little puzzle piece up here on the top right give that a click you'll see I've got a list of different add-ons that I can now click on to launch and we'll be launching a whole bunch of these throughout our session here today all right fantastic last thing before we get into a survey of all these wonderful add-ons is what if you decide you know mmm I really think here for that add-on I don't I don't need it I want to get rid of it you absolutely can do that so to do that you basically repeat the same process you did to install the add-on you open up the add-ons window you find the add-on and then there's a manage button you can click which then allows you to choose remove so let me go through that process we'll go ahead and remove form Ranger so you can just see that again you go up to the three dots the little more button and you go back down to add-on so it's just like when you went to install the add-on you're going to do the same thing to uninstall the add-on so go to the three dots go down to add-ons find the add-on you want to get rid of in this case form Ranger not nothing wrong with form Ranger just using that as an example and when you hover above form Ranger you'll see I get a manage button normally it's a plus free button to install it after it's been installed it turns into a green manage button go ahead and click on the manage button and you get a little drop-down and you can choose remove from the drop down list there and at that point simple as that it uninstalls the add-on now you can always add it back with the plus free button but it takes it out of there as quickly as that and that's it that's how you get rid of an add-on if you don't want to keep it all right guys well let's go ahead now and try to get through as many of these as we can in the time that we have we'll do our best to to hit these salome I'm going to move pretty quickly because again I want to make sure we get through a lot of these and some of them are very simple they just do a very simple little task and so we will move kind of quickly through some of them spend a little bit more time on some other ones as always if you have questions please be using the chat doc and Anthony is going to keep on watching that and let me know if there's any issues as we go through all right and I'll close out of that form you don't need that guy anymore all right let's get going so the first add-on these are not in any particular order other than I kind of put some of the simpler easier quicker to use ones at the front and save some of the bigger ones for the end in case we run out of time so it can get as many and as we can okay so choice Eliminator two is the first one basically what choice Eliminator does is it allows you to create a form where you've got a multiple choice question or a checkbox question something like that and as people make a choice in that form it then removes that choice from from future uses of the form so for example let's say you want students to pick a topic for their research paper and you've got a list of all these famous Americans well the first student who gets there and chooses George Washington and hit submit well the next time a student goes there George Washington won't be in the list anymore it actually just disappears I've done an example for all of these so let me go ahead and pull up choice Eliminator here so I'm gonna pop back over to our our folder and I'm going to find choice Eliminator and again I've already pre-made these to try to save a little bit of time today so as much as possible I've already created these forms I've just left off the spot where I use the add-on so again not really going to go through how to make the form please refer to some of our previous webinars on creating forms if you want that as well and I'll add on our on the resource page I actually have a couple other form tutorials so I'll add those on and I'll expand out that resource a little bit further if you do need those they're not on there right now but I'll swing back around after the webinar and put those underneath the video as well so here's choice Eliminator or here's your the form I'm going to use choice Eliminator with and you'll notice it's just a single question it's very simple I said choose a time for your conference appointment so let's pretend it's parent-teacher conference or whatever the case might be and I've got appointments from 4 o'clock to 7:30 and I want people to choose which time they want to use all right so I've already got my questions set up and if I go up to my add-ons button I've already got choice Eliminator 2 installed so it's already there ready to go I don't need to install it again so let me go ahead and click on choice Eliminator 2 to fire that up and when it does it opens up a little window asking if I want help or if I want to configure it well I'm going to say I want to configure it and now it's going to open up a panel this is very normal most add-ons work this way they typically pop up a little panel on the side give you some options and then they do their thing so in this case what it's doing is it's going to ask me to choose which question is which question am I going to use to turn on the option for eliminating choices there well right now there's only one and that's choose a time for your conference if I had other questions there'd be a whole list of questions down the side I just have one question so I'm going to click on choose a time for your conference and then all you have to do is check the box it says eliminate choices and if I check that then basically it's saying at this point from here on out any time somebody takes this form and fills it out this question choose your conference appointment it's going to eliminate whatever choice somebody makes now that's pretty simple but it does get a little bit more sophisticated if you want there is a little gear next to there where if I want to I can click that little gear and I can dig in a little bit deeper including saying you know what I actually have room for more than just one person at each of these you know maybe it's not a conference maybe we're signing up for you know maybe it is like choosing a famous American to write about and more than one person's allowed to choose that same famous American for example well you can come in here and you can change the limit so that it's not necessarily just one it could be two or three before it gets eliminated now I'm not going to do that I'll go ahead and leave it just at one so we can see it but be aware you've got that option and that's pretty much it guys at that point it's turned on so let's see it in action so at this point I've got four o'clock through 7:30 half an hour each time if I come up here to my button to view my form the little eyeball button up here on the top let's open up my form there's my form and I say okay let's pick a time so watch what we do we're going to pick four o'clock and it should disappear it's not a choose four o'clock it's always great when you do these things live you never know hopefully everything works great today but let's see so if I choose four o'clock and I hit submit at that point I've chosen four o'clock so if I come back around to my forum now well you look at that four o'clock is not even there anymore it starts at 4:30 so it's been eliminated as quickly as that so if I go to view my forum again for clocks not even there anymore so maybe I choose you know six o'clock and I submit that and again as that happens it will automatically update and boom now six o'clock isn't in there so that's choice Eliminator two an awesome extension very easy to use a great way to limit how many times people can choose a choice all right let's keep on going what's our next one to look at next up is forum values now forum values allows you to have a premade list of answers that you use a whole lot so you're always using this same list of things maybe it's student names or maybe it's buildings in your district in my case because I work at spark and I serve about 30 soup school districts there's a lot of times I create a forum and one of the questions is pick your district well I don't want to have to type those in every single time or go hunt them down and copy them and paste them I know that's not hard to do but form values allows me to save them ahead of time so that I can just paste them in anytime I need to so let's try that so let's find forum values here it is I've got two forum ready for that and so basically forum values I made a question and the question is simply choose your school district and I don't really have any options just one option I'm choosing a drop-down menu for my for this form question so let's say I want to insert all of my school districts into that list there okay so by having the question choose your school district I now go up to my add-ons and from there I choose form values in the drop-down now in form values opens up I can choose to use or create my choices now I've already created them but I'll show you how that works too so here we go it opens up the panel and there is a blue button that says create or edit your value list now again I've already done this but I'll click it to show you what it looks like if I give a click on this this is where the form values are stored it's a spreadsheet and so they've got some pre-built letters teachers trees I didn't actually create those I did one called districts and so down here are all the districts that I need to use over and over and over and over again whenever I'm creating forms so I basically just typed in districts and put them all down below there so now how do I use it well what I do is I choose which question I want to apply it to and again I only have one question to choose your school district obviously normally I'd have a bunch of questions to choose from and then next choose a value list so not letter of teachers or trees I'm going to go with districts so I choose districts and I click Submit and as soon as I do that it's going to grab those values and give that a second to reload there it is it's going to grab those values and it's going to paste them right in and look at that choose your school district all of those are now pasted in for me as simple as can be so that's just a nice convenient way to have those handy yes I know you can copy and paste from a word doc you can copy and paste from a Google Doc or from a text file but it's just nice to not have to go hunt down and search it just to have it right there in that list all right that's form values let's keep going what's up next our next one is form limiter form limiter allows you to turn off a Google Form when you've reached a certain date and time or when you received a certain amount of responses now you may not have even known you can actually turn off a Google Form if you didn't know that you can do that so let's open up form the form limiter example so here's form limiter and I'll show you first well you can do this manually okay so for example if I create this form and in this case it's just like a sign-up form so I've got enter your name to sign up so we're just going to type in you know my name to submit I'm signing up or you know whatever it might be again all these forms would typically be much longer I have a lot more in them just doing this as an example now manually I can go to the responses tab up here at the top and over here is a slider that says accepting responses I can turn that off and turn that back on so your form does not have to be live all the time you can on your own turn it off and turn it back on well the thing is that's manual you have to go click it well what if you didn't want to click it what if you wanted it to happen automatically like hey you can take this quiz until midnight on Thursday or for example right or you can sign up for something until there's 30 people who have signed up whatever the case might be so if you have a particular need to set a limit and you don't want to be sitting there monitoring it the whole time you can use form limiter so how does it work well come up to the little add-ons button the puzzle piece go down to form limiter to bring that up and it says what do you want to do I want to set a limit and once that comes up I now have down the side an option to choose what kind of limit I want to set and the choices I have include date and time maximum number of responses or a cell value from a spreadsheet so you can get really fancy if you've got a spreadsheet somewhere that's doing some crazy fancy calculations you can actually point to that spreadsheet to have the form limiter get triggered I'm just going to say maximum number of form responses and at that point I'm going to say that will take three responses now technically it's going to be four I know it's kind of weird you just got to go one number below at least from my experience because it says when the number of responses is greater than that then it gets turned off so you can do three the fourth person actually is able to submit and then at that point you've gone above the limit and then it turns off at least that's been my experience so pick a number one below what you're trying to stop at and that's pretty much it you tell it the number now if I didn't do an I could have also set a date and time and then you just put in the day and you put in the time and it allows you to pick the date and time very very very simple to do I'm just going to do maximum number and I'll say three submissions which is really four and I'll hit save and enable and let's see if it works okay so we've got that saved let's go ahead and we will go view our form and what we want to do is sign up so we'll come here and we'll have a user one we'll do user one we'll have him sign up and excellent he's signed up and so one person has now signed up so now let's go and view it again still working fine let's do user to let him sign up he got in no problem okay don't get two responses let's go again and we're up to user three we still should be flying shouldn't be hitting a limit yet submit that and now we've reached our limit but again it says when it's greater than that so we should be able to get one more in yes this should be user four and at this point that should be the end of it and let's see so at this point if somebody else tries to see it it should say that it's been turned off let's go to view it and look at that the form is no longer accepting responses has been automatically closed by Eric Hertz alright so that is form limiter you set a time and date or you set a maximum or you point to a spreadsheet cell that you want to use as the trigger to turn this off phantoms of course you can turn it back on just go to X responses and you can just slide that manually to turn it back on if you want all right good stuff let's keep going next up on the list we have check it out check it out is a nice add-on if you want to check out data projectors Chromebooks something simple like that and really all you need to know is is it in or is it out we just want to be able to keep track of what is available and what isn't all right so let me find my check it out form here it is and so what I've got here is just a simple blank form nothing too fancy about it and I'm actually got not gonna type anything in yeah I'm gonna start by rope running the add-on because it kind of it's kind of a wizard that talks you through the process so I'm not actually going to build my form just yet now I could of course put in you know what's your name and all that kind of stuff what you would do certainly if you were really doing a check it in check it out kind of a thing you'd ask for their name or you'd collect their name or something like that but I'm going to go ahead and go up to my add-ons I'm going to go down to check it out and it's going to ask me to add or edit my question set so give that a moment to pop up it's going to say okay what do you want to do do you want to make a new question yes I do and what is the thing that we are checking in and out well in this case I'm going to say we're checking in and out beta projectors just for an example just so we have something to use as an example there below there what type of a question is this going to be is it you know checkboxes choose from a list multiple choice well I mean if you do checkboxes somebody could I guess check out more than one at a time that would be fine so we could just do checkboxes I guess that's okay and then it wants to know what information to put one everything's checked out or everything's checked in and so that's the text that it will use for that okay that looks good let's go ahead and hit add and it's creating that question for me give that a moment okay so there's my question and it says okay so this is to check out data projectors and to check them in so let me come here what says enter your items so right here I want to put all the projectors that somebody could check out so I'm going to go ahead and paste those in there we go and hit done or click off of that to be done and so there we go and my first question again I miss you know we don't really need this first question but it could be like what's your name or something like that I'll go ahead and take that question out all right so we basically have two questions question one check out the data projectors question two check in the data projectors so here's the way it works if somebody comes to this form now they will see what is currently available to be checked out or what has been checked out and if they choose one of these and check it out it will move down to the other list waiting to be checked back in aha so let's go ahead and let's view this form so here it is it says hey let's check it again normally you'd have you know fill in your name and all that kind of stuff as well but I'm just gonna say I need to check out projector two for whatever reason and I go ahead and hit submit again I'm checking out projector to hit submit says thank you that's great now if we come back to the forum would you look at that projector 1 3 & 4 are available but 2 has been checked out so somebody comes to the forum now they're going to see that only 1 3 & 4 are available or if I'm the person who checked out two I could check it back in and it would move it back over to that list now of course it would make sense if you're doing this too in your spreadsheet that is collecting all of these things you'd probably want to have it turned on so that it collects their user name and that it timestamps it's all that stuff's being recorded in the spreadsheet as well so you can see who actually did check it out that's a great one for managing those sort of items alright keep on going next up form recycler form recyclers an add-on that basically lets you use questions from other forms maybe you put together this awesome quiz or this survey and you really don't want to just have to recreate the whole thing but you you only need a couple of questions out or you need to from this forum and three from that forum and how do you get them all done well I mean you could copy one but that's a lot of work to do that for all of them so form recycler to the rescue so how does that one work well let's go ahead and fire up form recycler so here is my premade form and let's say I would like to use some questions from a previous webinar we did one way back on Google drawings for graphic organizers and that one had a few questions in it but I also had some pictures and I want to show you this works for pictures as well not just for questions alright so here is my basically blank form if I go to my little puzzle piece add-on and I go down to form recycler and go ahead and launch that I can choose recycle form questions and now it's going to ask me to go find the form I want to use so let me come in here and let me look for the one on Google drawings see if it finds it quick enough there Google drawings for graphic organizers okay looks like it's starting to find it there Google drawings for graphic organizers and we'll run a search for that and there it is webinar quiz Google drawings for graphic organizers so we're going to grab that quiz and we're going to select it and what it's going to do is it's now going to list all of the questions that were in that original form and then I can just pick the ones I want so not to pull everything it's not going to grab like the whole entire unless I want it to it's not going to grab everything it's just going to grab the ones that I want it to grab once it does load those in and I'm I picked one with a whole bunch of stuff in there so it does look like it is taking it just a little bit of time to load give that a moment and if it doesn't that's okay we'll grab a different one if for some reason that one is not loading in quickly enough and does not look like you're just loading it very quickly so we might have to grab another example that's too bad that one's not coming up real fast well hey we made it to 406 without a technical problem that's not too bad let's try that again a form recycler well pick a we'll pick a different I think I've got a copy of that one that might load a little faster so we'll try it one more time so let's see so that was Google drawings for graphic organizers and let me try my copy of that let me see if that one opens up a little faster than the original and if not oh that's too bad and when we just come back to it - I can let it just sit here and run it just may need a little bit of time to go out and grab that because it just might be running a little bit slow there yeah that's okay well we'll let it do its thing and then we'll swing back around to it we'll check on it in between and we'll see if it has come up by then and if not I said I can grab another form that may have been a bad choice the one that I chose but so we'll let that sit for a moment and then we'll swing back around to it anaphor I've used it wonderful it is a great a great add-on alright next one up now this is a biggie gmath a lot of people know this one because it does show up in Google Docs and Google sheets as well it's a great one for Google Forms because it allows you if you're a math teacher or a science teacher to be able to put in things that are more mathematical or have special notation that are harder to put into a form normally so let's go ahead and let's try a couple quick examples in G math and see how it works a peek and see how it's still running hasn't gotten there yet okay well we'll come back to it okay so let's go to G math here and here's my G math form and now that I've got that poopin again I don't have anything in it I'm just going to build this from scratch with G math I'm going to do a couple of questions just to show you how you can use G Mack so if I come up to my little add-ons button in the top and I come down and I choose G math for forms what I get is a big list of different things I can create maybe I want to make a math expression or maybe a graph or maybe a chart a statistical display or handwriting entry or a multiple-choice question or even deploy this and hopefully I can show you that hopefully enough time I can show you how that works let me do a math expression first and here's the way G math works over here on the side what I get is a menu where I can pull from a lot of pre-made mathematical symbols things like exponents and matrices and fractions and I can click on these over here on the side and I can build my question that I want to insert into the form because normally all you can type in is regular text you really can't put mathematical expressions in but G math what it does is it creates an image it makes a picture for the math problem and it sticks that picture into the form separately from your question so that's how it gets around that so I'm going to go ahead I'm going to clear out the demo1 they've got here for me and I'm go ahead and say let me do a fraction so let me add a fraction and when I do that it gives me a little formula here for fraction a/b which makes a over B down here on the right hand bottom corner so I can go in and change the a and the B to be whatever I want them to be it doesn't have to be a over B it can be numbers so let's do something like oh I don't know 4 plus 2 and then maybe I want to multiply that by something I'll come back to that me do the bottom here instead of B we'll say something like 3 minus 1 and for that 2 instead of being just a 2 maybe I want to be like 2 times something so let's come down let's find the x button I just went right by it did I did I did I did I not let me find my little x button here Oh boom boom yeah I am probably missing it you're probably looking right at it and going right by I see the X for x but I was looking for the little dot there it is I found it I knew I was looking at it there it is a times B all right and so instead of a again we'll make that 2 and then instead of times B we'll make it the 6 here we go so basically all you're doing is using the pre-made formulas and you're just filling in in place of A's and B's you're putting in your numbers and your letters so I could have a problem like 4 plus 2 times 6 divided by 3 minus 1 which normally I couldn't just put into a form because it's a fraction and that there's no way to really type that easily into the form at that point all I do is click the insert button and it's going to insert two things it's going to insert a picture of the mathematical expression and then it's going to insert a blank question to go along with it because really it's two separate things the question and the mathematical expression that's an image the image and the question are two separate things so let me click insert and give it a moment to do its thing and there it is so now over here on the side and we won't use question one I'll just get rid of that question there we go I now have two things I've got my image and then I've got my question that goes with it so there's my image there's my question and that's the way forms works images and questions are two separate things they're not actually hooked together technically so for the image maybe or for the question maybe I'll say something like this let's say simplify the expression shown below in Figure 1 and then for the possible answers let's make this multiple choice we'll throw in 2 8 9 and 18 okay now over here I'll actually put in for the title this we'll call it figure number one and since I said below I actually can drag it down so I'll drag it down below my question and there we go so the question is simplify the expression shown below in Figure one and then figure 1 shows the actual expression and then people could go ahead and solve that now you can do other things besides that you could come back to gee math and you can insert a graph I've got an example but for the sake of time I want to get a few more things in so I'm not going to show that one that's okay then the statistical display is more like a bar graph handwriting entry is awesome you can just use your mouse depending on how good you are through mouth so you can draw whatever you want to put into the form but what I want to show you just really really neat on the very end here is what's called deploying G math and this is a little bit trickier when you do the deploying because what it lets you do is it lets the student use G math to fill out the answers to the questions so let's say I go ahead and add another question here and we'll say something like this I'm going to add a question and the question will be simplify the expression shown in Figure two we'll just view this for figure two we'll let it be a short answer and let's drag that one down and then I'm going to put below there a G math expression for people to work out and let's I've already pre typed it so save a little bit of time just make it a little bit faster here wait and it's X to the fifth power divided by X to the third power so let me insert that and once that gets in there give that a moment oh it's already in there it's faster than I thought don't need that one so now I've got my question which is simplify the expression shown in Figure two and then figure two is X to the fifth divided by X to the third well the thing is and we can make that bigger if we want I can stretch that out that's a little hard to see oops got a little bit fuzzy they're not that big air guy let's make it a little bit smaller there oh now it's going to be too big that's okay well you get that to you I can shrink that up eventually here but it's giving me a little bit of trouble at the moment that's okay we'll just leave a box X to the fifth divided by X to the third the point is for a student to answer that they can't just type in x squared because there's no way to do that on just an easy regular keyboard so instead they can use G math to add that in if I deploy G math with it I'll show you what I mean in a second let me add one last one here I'm just going to do one last example and then we'll deploy this what if I come here and I add another question and for this question I say draw an example of a trapezoid we'll make that a short answer as well and so again I want the students to be able to just literally draw a trapezoid in their quiz so now I've got a quiz that has three questions simplify this simplify this one and draw a trapezoid now they could answer the first by clicking the buttons they can't answer the second one easily because there's no way for them to just type in x squared and they definitely can't answer this one draw a trapezoid because you can't draw inside of a form unless I come back up to my menu for add-ons and I go to G math reforms and I choose deploy G math for responses to this form now if I do that what it does is it allows me to get a special link and we'll turn on the trigger here so that this runs automatically and it gives me a special link if I copy this link that if I give this deployed URL this special link to the students watch what happens my form loads up on one side and gmath loads up on the other side how about that so now they can actually use G math to submit their answers to the form so I could say okay well what's the answer to this one we'll say two and if I want to simplify this X to the fifth over X to the third I can't actually type in x squared but I could come over here and take X to the a power and then I could put in a two instead of an A and I could create my answer there click on create to paste and it gives me a code that I can simply come in and copy that code and as the student I can paste that code in now it looks crazy but it actually will translate in the spreadsheet into the image of x squared and so I'm using G math to get a special code to answer these same thing for the drawing one if I want to draw I can come over here and I can choose the handwriting entry and I could draw it's not very good but I'll try I could draw a trapezoid and after I draw what's a terrible trapezoid I click the insert button it again gives me a link here it gives me a special code that I can copy and after I copy that I can paste that in for my answer and so I'm not actually seeing the trapezoid here I'm not actually seeing the x squared here but I will see them on the other end as the teacher in the spreadsheet so G math cannot just be used for you to create cool mathematical expressions in the form it can also be used for your students to turn in answers that it that use symbols and mathematical expressions and images and wouldn't even have to be math if you're having them draw a picture that could work for any subject anything you want them to draw they could draw and then submit it so let's go ahead and submit this and now that that's been submitted let's go ahead and let's go to our spreadsheet and let's take a look at the response so what comes in here a little hard to see from here but I'm going to go ahead and see if I can zoom in a little bit here so you guys can see this a little bit better what it does is it gives me of course the time and date and then over here it gives me the code that that got submitted now sometimes the code immediately turns into an image and for some reason it doesn't you can just click on the code and there's a little apostrophe at the start if you take that apostrophe out then it renders the image that apostrophe kind of like makes it not to show up so again if you do see that problem just click on it and just take that apostrophe out and whoops try that again Eric kind of posture V out and then let it draw the image in and if you can't see the image real well you can make this taller and there you go so now you can see in the spreadsheet the actual trap is the way they drew and you can see the mathematical expression they submitted so really creative way until Google does something new with forms that lets us do rich text and things like that what a creative way that it allows you to be able to add things with symbols and superscripts and subscripts and drawings all right very good let's keep on going o our form recycler still didn't come through that is a shame I really did want to show you that I will try one other form instead of that one I'll just grab one that's different than that I feel bad that one didn't come through I'll just grab maybe anything I'll steal one of yours I saw one of yours in the list there you're navigating google drive was that one of yours maybe yours are going to play nicer than one of my old ones I know that my old ones I had made with my other account so it is possible that that was one of those old ones that wasn't working so or form recycler just might be having a bad day I still don't want you to give up on it though I have used it it is a really nice one all right can we squeeze a couple more in here I hope so just a few more doc appender now doc appender you've heard me talk about if you watched my webinar on rubric tools it's a really nice add-on that serves well for things like rubrics or informal assessments let's see you're walking around the class and you just want to record how students are doing doc appender lends itself well to that so what is doc well the best way to explain it is to show it so here's basically the idea let's say you have a folder that has documents in it where each document pertains to a student so I'll come over here to my Google Drive and I'm going to go to my classroom folder I'll use that as an example so if I come here to Google classroom we look at my classroom folder if you use Google classroom you have a classroom folder and then inside of there I'm going to use my one from my rubric tools webinar and then inside of there let me grab one of my essays I'm going to do essay assignment number two so here I have a folder that has six files in it from six different students test user one two three or four five and six this could be a folder with documents for each student for informal observation so it could be a blank a Google Doc for each kid just maybe their name is at the top of it and that's it so it doesn't have to be an assessment it could be a document where you're keeping notes about how the student is doing in class but the point is it's a single folder with a list of documents each student has their own document okay with that said if I come over here and I find doc appender here's my form I'm going to use for doc appender the way it works is you basically build what you want to append on to those documents so I have built a rubric in this case I've got ideas organization word choice and mechanics I built a rubric and what I want to do is I want to be able to from this form pick the students document fill out the rubric and let that get appended stuck to the bottom of their document so if I come over here and I look at test user fives essay at the moment there's nothing there but their essay if you scroll down it's blank it's just there's their essay nothing at the bottom it's all blank well what I want to do oh hey farm cycler worked Anthony welcome back to that it grabbed yours okay so if I use doc appender here what I'm going to do is I'm going to take this form with this rubric and I'm going to run doc appender and tell it to attach this form to this older and then anytime I use doc appender I can just fill out the form and it will automatically take the responses from the form and stick it to the bottom of the students document in this case for a rubric but you could use it again for behavior observations things like that so let's run it come up to my add-on come down to doc appender there's dr. Pender and say I want to open up the sidebar here and once doc appender opens up I have to choose the folder I want to use so I'm going to pick from Drive going to pick that same folder we just talked about so I'm going to go to my classroom folder so let me head over to classroom see if I can find the classroom folder there it is and inside of classroom let's open up classroom let's find my rubric tools folder and inside of there a say assignment number two so I'm selecting that folder that's holding all of those now that I've done that I'm going to hit next and it's going to say which question do you want to use that's going to be the hey pick the student document drop down list well I made a question called select document so I'm going to say let's so let's refresh the list here give it a second I'm going to say select document is the question that I want to list all of the kids documents in so I can pick it from that so let's do that and let's save that and now select a document instead of being just blank here is actually going to list all of the student documents and there they are there's essay user one two three four five and six so there they got sucked in let's go next and now it says which of these questions do you want to stick to the bottom of their document well I want to use ideas organization word choice and mechanics I want those four to get stuck to the bottom let's go ahead and enable that and there we go that's a little bit of setup but now that it's setup it's really really easy to use so let's go ahead and use it so remember this is essay assignment four test user five there's nothing at the bottom if I go ahead and run this form now if go to the live view where it says select document I can pick test user 5 it has sucked in all the files from that folder then I can say test user 5 got a 3 on ideas a foreign organization a 3 on word choice and a 2 on mechanics and as soon as I hit submit it should append that to the bottom of his document let's see if it works so let's hit submit let's go over to his document give that a moment to run and there it is and now stuck on the bottom of his document is his rubric now again you could use this day after day after day and it's just going to keep appending each time the new information you added you could even choose to have it do the time stamp and you'll have them time stamped as well so this could be a running behavior record for each student and you're just walking around the classroom with your tablet or your iPad or your Android tablet and you're just clicking on this any time you need to to record information about the students alright we're just about out of time form recycler did come up excellent there it is so form recycler did come up and all you have to do to use form recycler is choose the questions that you want including pictures so I'll go ahead and pick a couple of these here that have questions and pictures and after you pick the ones you want you just click insert questions and it grabs those questions from the old form and yay it works beautifully there it is so there's the question there's the picture there's another question so yes good job form recycler again apologize for of the the ones I chose just must have been some bad examples so excellent alright we're just about out of time but let me at least show you very quickly data director and I think while we're just going to have to pretty much wrap it up just by showing these real quick data director does a ton of things but there's one thing it does that I think is really cool and I think all the stuff it does is cool but there's one really cool thing I like and data director so let me show you data director real quick basically data director can be used to do all kinds of stuff like you can send the responses to a different spreadsheet you can send in email when somebody submits a form you can add a guest to your calendar event okay all that stuff's fine there's nothing wrong with any of that look at the last thing it does this one I actually really like it can create and save and edit URL and may say Oracle what are you talking about what you mean an edit URL here's the deal when somebody fills out a form there is an option you can check normally to say let the user edit what they've submitted let them go back and make changes in the future and if you check that box it basically sends the user an email or it puts a link up on the screen that says hey if you want to come back later and change your responses you can use this link well the thing is people don't pay attention to that they delete it they close out of the screen and then you don't have that special URL anymore this will let you collect all of those edit URLs they may say Eric why would you want to do that well here's a use case let's say you want to do something like an emergency medical form or a parent contact form and you want the parents to be able to update it every year without having to recreate the whole thing every time you could create a form that asks for their name their address all the sort of stuff you could turn on data director and let it save that edit URL so next year you simply send the parents that special URL that's unique to them and guess what they can do they can open up the form and just change what's new so they don't have to redo the whole thing they can just put in their new address or if nothing has changed nothing needs to change so let me show you how it works so I've created this form asking for your address information if I come here and I launch data director go ahead and turn that on moving fast here we'll get to we'll get through it let me turn it on real quick so I'm turning on data director and then I'm going to choose the alternate destination option because I do have to do that it actually sends this link over to a different form so I turn on alternate destination and then I say let's create a new form to hold this information in and then I give it a name we'll just call it beta director DD test what call it DD test and then I can say what gets included well right here the Edit URL I can say whenever somebody submits a form send the data to the normal spreadsheet but also send a copy to this other spreadsheet where we get the Edit URL included bingo let's hit save and let's try this out so now that that's turned on if we go to view this form and I start to fill it out so I put in my name and I put in my email address and then let's say I run out of time and I don't get everything filled in so I get a few things in me I get my city my my state in and that's it I go ahead and submit this okay there we go normally that's it it's done it's over I wouldn't be able get back to that form but what data director has done is its created a new spreadsheet if I go to my drive it should be sitting in the root of my drive let's go to a quick refresh here and see if it's sitting there scroll down down down should be there sort by last modified Eric that would probably help there it is DD test let's open it up and would you look at that I'll zoom in so you can see this what you're going to see is we've got the timestamp my name my email address my state I didn't put in the street address or city or zip but no problem scroll over and there's the Edit URL that special address that let's say I need to come back and finish filling this out or maybe I did fill everything out but I just want to say hey it's August again parents please open up your form from last year and make changes let's try it click on this click on the link and look what it does it opens up the form with my name my email address in my state already pre-populated so the tea the parent can just finish filling it out you can say ah sorry about that I forgot to put in you know where I was at here so let's you know this is not my real address and there we go right - oh and let's hit submit and now what it's doing is it's going to update that and so as you see it's not a new record it's just updating the existing record so that's a really clever way that you could do that now it could be for kids completing or retaking a quiz going back in and finishing a quiz because I've heard that people say oh forms are great but whenever student doesn't get done they can't get back into it or they could but they forgot to record the link or whatever you could use data director to collect all of those all right last one and we are out of time yes Anthony one reminder or did it director because you can use the sheets add-ons you could have an email back to the mom I know you can oh the sheet right yeah what I would do is obviously it's just collecting that edit link I would say you know next August when it's time for the parents to refill this to fill this out again I would use yet another mail merge and I would send them all an email that has that link embedded in there so absolutely I would not do that manually at all I would definitely use yet another mail merge or autocrat or something like that to send them the link saying please click this and update it for the new year last one and I am sorry we're going over just a little bit but we won't charge anybody any extra how about that Anthony the next five minutes are free we will not actually charge them anything for the extra half price okay so half of zero is zero this will cost you zero as well okay so you last one here advanced summary most you guys know that when you do a Google Form it will create for you a nice summary we all love that it's nice gives you bar graphs and pie charts and so forth but there is a pretty neat add-on called advanced summary that goes a little further and it makes a little bit more sophisticated um summary of bar graphs and pie charts and it lets you filter I've heard people ask that so many times can I see these bar graphs and pie charts but only for the sixth-grade students are only for certain things and normally the answer is no you just get a summary of everything well advanced summary does let you do that so let's go ahead and I'll open that one up and that would be our final one here and so let's go ahead and what I've got this is um this is a survey from a couple years back on BYOD so is an actual survey it does have data in it okay we asked students what grade are you in what devices do you own did you bring them to school what was good what was that it was a BYOD follow-up survey so if I come up here to my little add-on button and I choose advanced summary what it does is it lets me create an advanced summary where I can choose which things I want to be able to filter by and it gives me all my questions down here I don't have to check things to include them in the summary I'm just checking what I want to be able to filter by so maybe I want to filter by their grade and I want to filter by the different types of devices they own but I really don't need to filter by anything else that's enough and at that point just click on the little button to move over and it's going to generate this advanced summary for me and here it comes and so now I get this really neat graph got my pie charts I've got oh and it also does word clouds so if you have a question where somebody is putting in a written answer it'll create word clouds for you and you can even hit the details below there if you want to see exactly what they typed but you can get a nice word cloud as well which is great so pie charts bar graphs word clouds all that's great but what I really love is the filters at the top so I can say oh this is really good data but I wonder well is it different for our freshmen versus our seniors did the seniors bring in their device is more than the freshmen but a little so like for example I could say let's come to what is your current grade level and let's limit it to just grade 12 so if I do that it refreshes this now and now I can see you know wow it looks like when I chose grade 12 we had almost half of them owned a laptop and brought it into school that's pretty big but now let's come back up take off grade 12 and let's do grade 9 instead and Wow I own a laptop and I brought into the school only 22% so I can start drilling down into the data with these filters that I normally would not be able to sure we got there all right all right well good good good stuff so as we start to wrap up Anthony are there unanswered questions no oh fantastic thank you for monitoring that and thank you for those who have been in the chat dock for all that you've been contributing to that as well as we do start to wrap up I do want to remind everybody that all of the resources from this session can be found at tiny dot CC slash spark 235 again that's the webpage over here where you'll find the recorded video once this is done you'll find the session resources and I'm going to add a few more things for forms there I got a couple other ones that might help you if you need a forms 101 below there we still do have the evaluation for the session love to get your feedback on these things if you don't mind filling that out and get yourself a certificate of attendance just take the quiz at the bottom pass that and you'll be sent a one hour a one contact our PDF certificate of attendance now while you're on the site again please do check out our PD schedule for upcoming webinars check out our recorded trainings from all the past ones sign up for the newsletter and of course contact us if you have any questions Anthony I always happy to hear from you guys other than that just want to say thank you guys so very much for taking the time to watch this session hope you found at least a couple of tools there that you can take and use in your classroom we've got through about 8 or 9 of those and saw a few others too hopefully piqued your interest we hope to see you again over the coming weeks for more educational technology webinars take care

Channel: Eric Curts

Views: 84,231

Rating: 4.7798166 out of 5

Keywords: GAFE, Google Apps for Education, Google Forms, Add-ons, Eric Curts, SPARCC, gmath, formlimiter, Choice Eliminator, docappender, checkitout

Id: gJdjdO8EFlM

Length: 67min 32sec (4052 seconds)

Published: Tue Mar 15 2016