 Welcome, this is Corey Dahl and with me today I have another guest from Norfolk Public Schools. This is Mickey Mueller. I'm the Educational Technology Facilitator for Norfolk Public Schools and the unofficial face of Google at Norfolk Public Schools. Okay, I'll have to add that to the slide next time. Today what we're here to talk about in this 30-minute webinar, the topic today is Google Forms and not necessarily as a basis to describing how to do it and such, but just to talk about some of the changes and some things that you can do with it as well as ideas for classroom use. Absolutely, we kind of expect that you already know how to use Google Forms, so we're not necessarily going to go through how to set up the Google Form, but even if you haven't done that, stay with us because we've got some great tips and tricks for you that you can use when you go off on your own and explore how to create a Google Form. Right, because if you're brand new to it and haven't ever used it, you'll still get a great idea of why you should be using it or ideas for classroom use, personal use, professional use and things like that. Okay, so some practical uses. There are many. We just typed a few in here. One is t-shirt orders. If you're someone who is working in school and you're in charge of the band or you're in charge of FCCLA or you're going on a trip with a certain group of people and you want t-shirts rather than one more piece of paper or one more email that you lost or I lost a sticky note that you wrote your name on it, Mickey. You know, with your size, if I use a Google Form, I have all that information at my fingertips in a nice neat spreadsheet that I won't lose. Exactly, and you can even use an add-in, a script that we're going to talk about later, but you can use a script that will actually email that information back to the person signing up for the t-shirt so they can use it as their receipt. I know at Norfolk Public Schools, we have to give everybody a receipt when they turn in money, so this would be an excellent use of a Google Form to send that information back to the person who's buying the shirt and they'd have a receipt right there. Right, so as you really get into it, you'll want that automated email to the certain person or group of people. That way they know that the information's been shared and so on. Yes, that's wonderful. Voting. You were talking about this. Don't you do this at Norfolk? Or have you seen it done with Voting? Yeah, we don't do it at Norfolk because we're not quite there yet, but Milford Public Schools, which is a smaller school down in southeast Nebraska, they actually do any kind of voting, whether it's for class officers, homecoming candidates, they use a Google Form to vote for those candidates. And it's really easy if you're collecting the user names as you fill out, as the user submits the forms, and it's really easy to go in and sort that data and then delete any duplicate votes. Right, here's some other ideas. Quizzes, and we're going to do at the end, or you could just say assessments in this case. You can use something called Flubrew, which we're going to talk about, and give you an idea of how you can not only just use this to take the quiz, or the assessment, or the check for understanding, but you can have it great for you. And that's just a little teaser. Checking for understanding, you don't have to just use it for quizzes or assessments, but as you're going throughout your lesson, you want to check and see, are they getting what I'm talking about? If we have them click on the link, and then you can see how it is they're answering. Okay, next, registration for events. Do you ever have any events that you might want registration for? Yeah, absolutely. Anytime we do a technology training at Northrop Public Schools, we have people sign up for that, so we know how many you're going to attend, and we use Google Forms for all of our registration for that kind of thing. Right, and at this time too, if you can see the chat room where you're at, there are other uses that you use it for. Please type in ways that you've used it or seen it used in the chat area. And then we'll keep talking, but people can type in there in the chat area, but you can also just follow along if you wish. Okay, walkthroughs. Many administrators, many, many administrators use a Google Form as a walkthrough, and maybe in your district they do this. So that's again a form. They walk into your classroom and they see what it is that they're seeing, and when they click submit, it sends an email to the teacher, it sends an email to themselves, and they've got an electronic copy of everything that they're seeing. There are so many uses. Oh, so many uses. I love Google Forms, and I think Google Forms is one way to get teachers excited about using Google Apps because they can see a lot of practical applications for using forms right away. Right, and Lisa says activity verification. I'm assuming, meaning as people are completing certain activities that they're using the form as a way to prove that they've finished it and things like that. Yes, for professional growth. So if you're someone in your district is struggling with keeping track of that or you need a neater way to do that, or maybe that person is you, go ahead and use a Google Form for something like that. Yeah, and Ashley, Lisa and I are planning on doing that. There have been a couple of webinars that Corey has done recently. They did one on iOS 7, and then this one, we're going to put both of those together and have our people watch it. If they watch it, they're going to answer a couple of questions on a Google Form. They'll submit that, and we'll give them some professional growth points for watching those webinars. Right, and so in your district, whatever district you're in, to note that we are recording this, and then it can be played back, and it's on our website at the service unit. And we'll talk about that at the end as well. So what's cool and new? There have always been a few things within forms, and it used to be somewhat watered down in that you had some things like text and paragraph text and multiple choice and check boxes and all these items that you normally would have. But there's a couple of things that we really want to talk about today specifically. Mickey, one of those big things is what? Images. That has been something that teachers especially have been clamoring for in Google Forms is the ability to add images to your Google Forms. And that came out last spring, and it's really been a wonderful addition to Google Forms. Right, and I heard this the most from, as you can imagine, elementary teachers. But it would also certainly add to a junior high school environment. But there were so many elementary teachers that wanted to have a picture. Absolutely. And it just makes that form, that quiz, that assessment that much different or better. Yeah, and I'm not an elementary teacher, but I love my clip art. And so on any form that I do basically now, I put a little piece of clip art on that form. Just to kind of jazz it up a little bit. Right, and we'll show you some examples here in a little bit as well. Video is another one, which is huge. Watch this video. I think we have an example later. But watch this video and then answer some questions about what you saw, what you heard, what you implied later. So these are, and if you're a Google Forms user in the past, you know how big of a deal this was for many. So if I wanted to add a picture, it's as simple as something like this. When you're in your Google Form and you wanted to add a picture, you're just going to insert that, and you just get a simple screen like this here that just says, hey, you can either drag it right into that area or you can click on that blue box there that says choose an image to upload. Right, and they do give you, if you see the full insert image option menu, they do give you several choices. So you can either have one saved on your computer or on your Google Drive, or you can actually do a Google search right through within the insert picture option. So you don't even have to go out to another tab or open up another window. You can do a Google search right within the insert image option. Right, so it just depends on where you've saved it or what you have done already. So if you just click on the choose an image to upload, then you just browse on your computer if you haven't saved or wherever it is, and then you've got it in your form. Okay, next. Here's a good example that Mickey gave to me today. You want to talk about what we're looking at here? There's a couple things, the picture and then the type of question down at the bottom there. Right, well, when you go to insert an image, you can either put the questions above the image or below it. In this case, I found this map off of the internet. I added the letters on the states there, and then I added the question below that. So I inserted the image and then added a question. This is an example of a grid question where they would have to then identify each of the states based on the letters in the picture. Right, so as you're looking at this, I just thought this was a perfect example. So you found this map of the Northeast, you put the letters in yourself, and then, as you said, this is a grid option. So if you haven't ever seen these or used it, this is a perfect example of a grid option. So they're having to look at this map, look at letter A and say, okay, letter A is what state, and then they click on that and move from there. Yeah, and I was a little worried about how this question was set up because there's so much data in here in this question, whether it be understandable, in the chat that it was a great example and she has a sped background, so I'm assuming she's saying that it's an okay way to set up this question. Right, right. Next, here's an example. Now, this isn't a live video right now, this is just a screenshot again, but imagine this as you're taking this, versus a paper pen assessment, or a paper pencil quiz. You're clicking on this video. In this case, it's out on YouTube. They're watching something with information about the water cycle, they listen to it, and then immediately afterwards, they have questions. Yeah, this would be a great situation for all those flipped classrooms out there, where you're wanting the kids to watch the videos outside of class, but you need to, you're either wondering if they are watching the videos, so you're checking to see with the questions after the video in the form, you're checking to see whether or not they did watch the video, this insert video option into a Google form is huge. Yes, very much. I just love this, and I just keep comparing it to the paper pencil version. Where you have a question about the water cycle, and on you go. This, they have some information that they can watch. But it's also okay, so they're watching, they're listening, they're thinking, they already know what the questions are, because they can read below it, so they're looking and listening for that information within the video, so you know they're getting it, and they're able to find it. It's just very different from where we grew up, isn't it? Oh, absolutely, yeah. Okay, time, this is a new one. And we had some discussions today about what were some of the uses, and maybe this is another time where if you're in the chat room, and you've used this, tell us how you've used this. But here are some ideas that we came up with today, just brainstorming. So if you're in a science lab, and again, this is a type of question here, you can have your text, and so on, but down here at the bottom, there's a time stamp there. Okay, so you can choose the time, and then you can click on duration right here, which changes it to hours, minutes, and seconds. So we were thinking, if I'm in a science lab, for instance, and the science teacher, right, is in the lab, and when you're done, yeah, he says, go to this link, answer these questions. And it might be, how long did this take to react? Or how long did you watch it before you quit? You know what I'm saying? Right, right, yeah. Just different options for using that time feature. Again, it's in one of the newer forms, the newer options in forms is the time and date. The math elapsed time. Well, as far as math elapsed time, there are many math problems, story problems, how long did it take you to get from here to there? So we're trying to think of uses and reasons why you'd choose time as one of your form questions. So if you had a math question up above describing, you know, somebody traveled this far at this speed, how long did it take, you know, and then they can choose that time in the answer. So again, not a lot of uses, study time. You said you knew someone who asked the students how much, just as they're prepping for a quiz. Yeah, my husband, Chris, teaches math at the high school and on every assessment that he gives he always asks how much time did you spend preparing for this test or this quiz. So that could be a use for this particular question type on Google Forms, too. You know, if you were trying to figure out a time when you were going to have a meeting or, you know, if we're thinking about not maybe necessarily classroom uses, time you're going to schedule a meeting or you need to have a group event some place or some time and you could get people's opinions on what time to have it. So again, some of the comments. Back to the video. Like the availability of the video right there. You're exactly right. Or you don't have to go somewhere else and do something, you have everything right in front of you. And Lisa's suggesting maybe to use the time question to log reading time, if they're having to read so much, you know, at night or something that would be an option. How much did you read this week? Yeah, those sorts of things. Just an informal gathering of information. Okay, and then down at the bottom here I just included this. So where up here I'd check the duration and it looked like hours, minutes, and seconds but when I uncheck it it just says hours and minutes and then AM or PM. So that's just the difference between checking that and unchecking that. Okay. Next, date. There's another example why you might, you know, maybe at the beginning of the year you're just wanting information. If you don't have a school information system that's giving that to you right away or you're someone who likes to send out you know, those happy birthday cards or you just want to know that sort of information you can certainly use a form to, you know, and have the students share their information that way because it's just, again, you've got it in your Google Docs you can access it from whichever device you're on. Sure. Yeah, and again if you're trying to schedule a meeting on a particular date this would be what you could use the date question to indicate to have people indicate when they were going to be free or when they were going to be available. Right. Right. So, you know, there are always practical things, uses that you'll come up with on your own but these are just some of the new features within Forms. So now I've got a couple polls here. Alright, the first one I'm going to pull in here and I'll have to open it for you. Okay. And it says how many different question types are available on a Google Form. So, everyone watching if you click on that and vote and then in a minute here we'll see okay, let's broadcast the results. And of the people who voted looks like nine. Now, I'm more curious who can answer which ones those what were those types of questions. Use your chat room here. Alright, I'll start it off. There was a text and I put that in there. I'll remember another one just to get them rolling here. Oh, I've got people typing grid. That's two. Checkboxes is three list four. I see multiple choice from Mike C choice. So how many do we have there? One, two, three, six, seven, eight. It was nine but what was the ninth one? We're missing one. Scale. Scale and the scale is an example of rate this activity with one being the lowest and five being the highest. Good job making it scale. You do not win the prize because you're part of the webinar. Oh, darn it. Sorry about that. Alright, next one. Next one and this is leading into our this is leading into our next activity here. Alright, here we go. Would you rather hand correct a pile of papers, be honest or create an assessment that can be graded for you? I'm going to broadcast the results. You'll be shocked here. Interesting. I like Mickey. Yes, I, when I was in the classroom I definitely took any advantage of having those assessments graded for me. So that leads us into our next area which is called flubrew. If you haven't seen or heard of flubrew, you need to listen to this and try this out. Here we go. Flubrew. Alright, we added the website here. So if you needed more information later, wanted to go to the website, you can certainly do that. And there's a video on there. Now, first of all, I want to make sure that everyone understands the price of this. Mickey. You know, in these times that are tough economic times, how much is flubrew? Well, you can get flubrew for the bargain basement price of $0. So, you know, if there was an applause now I would put that in there. So you guys can actually clap if you know how to do that. You can actually go up to your little person there and make them clap. But we won't get into that right at the moment. Alright, so flubrew. Transforming. See that? See this pile of papers here? Patty just clapped for us. Oh, did she? I see that. Lisa P is clapping too. Up in the presenter participant area. So here's your papers. Now, first of all, there's always a Mac PC debate and things like that, Chromebook and so on. Does flubrew care which device you're using? Flubrew does not care which device you are using. How about Google? Google does not care which device you are using. So Google's free. Google Forms is free. Free. Flubrew is free and it doesn't care which device you're on. I mean, that's the perfect solution for any school system. Win, win, win. Alright, so here we go. Again, we're assuming that you know how to create a form and the people that listen to this know how to do this. So, even if you haven't ever created a form, basically when you create a form you get a spreadsheet because that's where the answers come into. So what you're looking at here is just a screenshot of a spreadsheet that you'll see in your Google Form. Now, what are you seeing up top there, Mickey? Well, this is how you're going to go get flubrew to add it to your spreadsheet. So basically flubrew is a script and there are really smart people that are out there that write these scripts. You don't need to know anything about programming, scripting, nothing. Okay, so somebody else has already written the script for us. We just need to know where it is to go get it and install it. And it's a super simple process. You just go to the tools menu, you go to script gallery and you search for flubrew. Right, and that's the biggest piece there is just knowing where to go to get started with this because what you have to do everybody as you're listening you have to install this script to have it great for you. If you don't install this script it will not work. And I want to add before I forget it, each quiz or assessment or whatever you want it great for, you have to install the script. So once you've done it in time or two you really get good at it. Yeah, and it's not hard anyway. It walks you through the process step by step so you just read the directions and click next or whatever it tells you to do. So it is really simple but of course right every assessment that you do a Google form quiz for you would need to install the script in that spreadsheet. Right, so tools and script gallery. Alright, it's step number one. You have to search for it and when you get ready to search you see a screen that looks just like this and you just simply type in flubrew. Now notice you get this other bit set. I don't even know what it is but what you want is this flubrew right here. Okay, now once you find that if I had never done this before I'd probably want to do what? Where would your eyes go automatically that you want to do what with it? I'm thinking you want to install it. Right, exactly. So first you're going to tools and script gallery and then once you get to script gallery you are typing in the word flubrew which brings up this flubrew here and then you want to install it. Alright, when you go to install these things that will ask for your permission of course you'll grant it and you'll approve it and say yes and so on. Now once it's installed on your spreadsheet this wasn't here before. What do you see there Mickey now? A new menu that's called flubrew. Right, that's how you know whether or not you've been successful. Okay, if you don't see that that really means in the end that you perhaps maybe didn't install what you thought you were calling. So there's flubrew right there. Right, and I will back up just one step before that. It does ask you in the installation process to authorize a bunch of things and it looks kind of big and scary but it's just allowing flubrew to get at what it needs to get at to work. So just go ahead and authorize all of those flubrew to access all of those apps and then the flubrew menu will appear in your spreadsheet. Right, and I tell people that often they call right just say yes except in this case that is very much true. So just accept whatever it is that they're asking you to do. So now that you've installed it successfully you have flubrew at the top of your list. Now this will not be there until you install it. So that's a good point there. So then after that it's magic time. So what happens then after this you click on flubrew and then you go down the grade assignment. Now what happens when you grade the assignment? There are several things that need to be in place. And one probably the most important thing is in this quiz that you've created Mickey you have to as a teacher should take it first and obviously you're going to choose the correct answers because once you're in it then what happens? Right, one of the first things that flubrew is going to ask you when you go to grade the assignment is which one is the answer key? Which quiz do you want to use to be the answer key? And that's why it's important that you the teacher go through and take the quiz first with the correct answers and then use that record to work as the answer key for you. Right, so I typed in here which one is the answer key and then you're going to pick in this case I'm going to say your I'll pick the quiz that the teacher took the teacher answers and let me click enter here so people can see that. So what you're going to do is pick yours because it's going to say oh, this is the one that has the correct answers. Right, right. Otherwise it doesn't know which one's right, which one's wrong. It doesn't know how to grade the quiz, right, exactly. Exactly, okay. So then after you do that you're going to get something that looks something very similar like this. Now let's start up here at the top right away and this is what it does for you. It's saying, okay, we just did a quick fake quiz here. There are three possible points. The average points, it figures the average and how many submissions there were. We took this quiz four times. Okay, and it gives you all this information. It also gives you the time that it was taken and the name of the person. Now it actually pulls the name from the quiz. It doesn't know this, does it? No. I mean in our form we had put a question that said first name, last name. Right, those were questions that we included on the form. Now clearly as far as the questions go it's not grading their names. That's something that is ungraded. Right, and that's one of the things that when you go through and set up the script it asks you which one which questions should be graded and which ones are recognizing the student. So that one we set to student information that it did not grade first name and last name. And Flubaru is very smart. Flubaru on its own will recognize that first name shouldn't be graded. You can always change it of course if you wanted to but it recognizes it, doesn't it? I appreciate that. Especially as a new user to it if you were. So here's total points. I separated this from the top. This would be one straight line on your spreadsheet but just for our screenshots and the screen I put it below. So I can see here that Beyonce, right? Two points. It's graded for you. How many times they submitted it. And then this email grade you want to talk about this. If I would have in my form included what, what can we do with an email? Right, if you request that the students enter their email address or if you're a Google Apps for Education domain when you create a form you actually have the option of collecting the username which in this case would be the student's email address. If you get that information then through Flu Baru once you grade the quiz you can actually email the results to the students and it will list the question if they got it right or if they got it wrong and their score. Right. So here's one question here. Today is what day and so it grades it for you. It tells you that out of the four people that took it only two got it right. Here's the next one. Forms are awesome true or false and one was true in this case so they all got it right and then in last one they had to actually pick two presidents and clearly they got it right here. So all they had to do was take the quiz. I have already installed Flu Baru on my assessment. I said grade this assessment and I clicked a couple buttons and it grades it for me. Done. Done. I mean, you know, for me I would rather do it this way than take a bunch of papers home or even walk myself down to the office to use the Scantron machine, you know, because if it's busy and I have to wait for it to get, you know, to be available. I mean this I can do whenever I want. I just install the Flu Baru script and run it and it's done. Right. Lisa's pointing out something here that we can look at quick here. Right over here and I'll circle it here you'll notice the color and the color shows you what maybe needs a little bit more work. It highlights it. So this is if I was differentiating or needed to know who I needed to pull to further go over this, what day is today. I would know who to do that with. And then we have some questions here. It says, so does it automatically once you've selected the option initially go to each individual student? Julie, I'm not sure what you mean by that question, but you actually would have to go back up to the Flu Baru menu and email the grades out to the kits. So just running the Flu Baru script once, the first time it just grades it. So you would have to actually go back up to the Flu Baru menu and choose to email the grades out to the students. Hopefully that helps Julie. Right. Any other questions because we usually like to keep this right at a half an hour. We're at 414 but in a sense instead of taking this assessment and let's say there's 25 or 30 questions right and it takes quite a while to work through each one and then figure the grade. You're doing this using your technology that you have in your building and it's graded for you and out the door you go. But I still like that it's not, it's just not doing all your working and I'm looking at it because just like Lisa pointed out here, we're looking at and we're analyzing the data and seeing what needs to be worked on or reassessed or retaught later. Right and I think that that piece of it is kind of a newer feature to Flu Baru and just like with all the Google products good script authors are always updating their scripts and Flu Baru is one that does get updated so I think that's a newer feature that actually points that part of it out. How do you guard against cheating it says. Now if I was doing this in the classroom Mickey, you know I'm walking around just like it would if they were normally just taking a paper pencil test. So I mean as far as cheating goes, I don't know if I would allow them necessarily depending on what it is to be at home and taking your assessment. I don't know if that's what she's asking but if I'm doing this in a classroom and they have laptops open I'm walking around, you know and you're making sure that they're keeping their eyes on their screen. Right and I think another way too is I wouldn't if I had multiple sections of this class taking this quiz I would not email the grades to the students until after every class was done you know after every student had taken the quiz then I would email the results but yeah I mean it's just like cheating on a paper pencil test you know teacher vigilance is the number one method to prevent that I guess. Right okay so let's now here on the last screen here on our website on esu8.org's website we have this webinar link here and this is where each week if you're wondering what our Wednesday webinar is you'll see a live link there as well as the you can come back at any time and then click on those links to let's say for instance listen to this one again or if you miss some in the past you can certainly pop in on those so please visit our website Mickey thank you for coming today and then we look forward to doing this again in the future sometime. Thank you Cory. Alright thank you everybody.