Okey dokey, I want to make sure everyone can hear me as well. So if you can just give me a thumbs up. There you go, OK. So at least a few people can hear me. That's good.

All right, so I'm going to go ahead and start sharing my screen. And we're going to hope this works, folks. Like Veronica said, there was a momentary glitch. So you should be seeing my screen with the Google Slides opened up.

And I'm infamous for going back and forth between a Slides deck and a live demo. So I'm just going to leave it like this. So that you can see the entire Slides deck and what's coming up. So I can go back and forth.

And I am doing Innovative Collaboration Tips and Ideas for Using Google Part 2. And Part 2 is a project-focused. Last one that we did was more a collaborating-focus. We went over how to use an email address-- an existing email address-- to create a Google account, the two types of Google, different share options, Commenting versus Suggesting, Previewing, Protecting Sheets, Using Sites, and more. And if you want to see all of that, as with this video and resources, you can check it all out on the caladulted.org website.

So I'm going to take a deep breath and we're going to discuss what the heck are we going to be covering in Part 2. That's a really good question. And I couldn't think of anything. And I know Veronica right now is shuddering when I say that but we went over a lot in the last session. So I was trying to think of something different, something new, that we could cover that might be new to you as well. So I came up with this.

We're going to go over some Project Ideas and how to actually put the ideas you might have into use. And show you how you can do it with each other in your consortia, or with your students at your adult education site. So I'm going to be going in deep with Slides, with Docs, and with Sheets and we're going to be doing something different in each one of those. So some of this stuff you might have seen. But I guarantee you you're going to learn something new in one of these sections, let's say.

OK so the first section, we're going to go over is Slides. And we're going to talk about Page Setup and Layout. So a lot of people don't know that they can set the Layout of a Slides to be any size they want. So you can customize a Page Layout and you can create any kind of a print style that you need for, let's say, a flyer or a brochure or a poster or a postcard. It's really, really easy and simple to do.

And, like I said before, I like diving in deep first. Going back between actually presenting and showing you stuff. So I'm going to show you exactly what I'm talking about.

If you go to the File menu when you open up a Slides deck and you go way down where it says Page Setup, you click that. This is the default, Widescreen 16:9 because we're all in HD land now. And this is the basic layout that you want when you're actually presenting and you're staying on your Slides deck. You want it to be wide, you want it to be large, you want people to be able to see it. Which is OK for presenting but it's not really what you want for a print.

So I'm going to click where it says Widescreen. And Standard 4:3, for you old schoolers you will know that this is, or was, the standard that we used to use. We used to have the 800x600 screen when you were presenting and you wanted to use the 4:3. Widescreen 16:10, that just gives you a little more of a nudge wider. And I would stay away from it, personally.

This is what I want to show you right here-- as soon as my mouse moves, here we go-- So when we click that, you can see that a 16:9 is actually 10x5.62. We can change this to centimeters, points, or pixels however you want, or however you do your measurement. Just think about this, if we change this to 11x8.5 or 8.5x11. If you changed it to 24x36, which is a poster layout. Or if you changed it to-- it's like a 5x4 something-- a postcard layout, you can actually create postcards using a Slides deck.

I'm going to Cancel this because I don't want to create anything new right now. I want you to see this. So once you have that Layout made, everything you put on it will become that size. Let's do it for real. I'm going to go to slides.new. By the way, you just learned something new. Slides.new will open up a new Slides ready to rock and roll.

So I'm going to go to File. I'm going to go to Page Setup, just like I showed you. And we're going to come here and I'm going to do Custom. And we're going to do an 8.5x11 page which is, for those of you that don't know, it's going to be a portrait layout instead of a landscape.

So I'm going to Apply. And you can see right off the bat this screen is 8.5x11. So it's long, it's a page of paper, think about that. It could be a flyer, OK.

Or it could be maybe a book, the start of a book. Because each slide-- instead of thinking of the word slide, think of the word page-- so each new page that you would create would be a page in the book. And then when you print it, you print front to back. Boom, you got a book. What a great idea for your students, they could create their own book, About Me.

Or if you have flyers that you want to create in different languages because Google was really good about translating, you could put your text on one page and then have it translated on the next page. And then you print those out and put them up all over your school or you hand them out or you mail them out, whatever you want to do with them. So that's one way of using the Page Setup.

Something else that you can do is on the Layout, you add Grid Lines and this will help you actually put everything in the right place, OK. So Grid Lines can be added two ways. If you're familiar with PowerPoint you know you have a Master Slide. So I'm going to go to View-- you have it in Google too-- I'm going to go to View Master. I'm going to go to the ruler. I'm going to click, hold, and drag from the ruler.

And you see that red line coming across? You might not see it because you're remote, you're on the Adobe. But I'm going to let go, and that went approximately in the center. I didn't put it exactly in the center because I'm doing this really fast.

So I can drag lines down exactly where I think my print is going to be, OK. And then when I go back to my Slides, they all have these Grid Lines right there on it. So when I create a New Slide, my Grid Lines are still there so that I can make each page the same or have the pictures or the margin or whatever I want exactly in the same spot.

You can also drag from your ruler just on the page itself and you can add Grid Lines that way. And something that I learned this morning, it used to be that as you added Grid Lines this way, actually on a slide not on the Master, when you went to a new slide they would disappear. But yay Google, changes on the fly. My red lines are still here, OK. But the lines that I added on my second page are also here on my first page.

If you already knew about Grid Lines you probably don't know that the Grid Lines now, when you add them on one sheet or one slide or one piece of paper, however you want to think about it, it's going to add it across the board through the entire presentation. If you don't want them anymore, just drag them off. No big. You can drag them off. The Master Slides you won't be able to drag off until you go to the Master Slide View.

OK, so here we go. If you're interested in making brochures, the Rule of Michael. Michael Pearce is a Multimedia Design Specialist here at OTAN, and he told me that whatever the outer margins are, you have to make the inner margins twice the width.

So the next slide right here, well it's not actually the next slide. The other slide was just everything that I just said, so I'm going to skip that. But here is the inside of a brochure. It was really quick and easy to set up. I did this this morning. Some of the text is the Lorem Ipsum diddly-squat and some of it is actually telling you about this layout.

So a brochure can be any size you want. Most trifold brochures are 8.5x11, and actually I should say 11x8.5. And you would fold it in thirds, right. So you have to figure out how much space goes from here to here. Now I left the lines for the text boxes so that you could see where they are located.

But what I did on a Master Slide to create a brochure for TAP is I pulled Grid Lines over. Here's 0.25, OK. And there my Grid Lines are all back. So it remembered what my Grid Lines were when I first set it up. And then as soon as I drag that one Grid Line over, they're all there.

So I don't have to redo this but just to go over this for you, this is 0.25 from the left. This way over here on the right is 0.25. So the middle trifold-- when you fold things remember whatever's on the outside edge, 0.25, you have to have at least twice that for the trifold-- so right here this is 1/2 an inch and this is 1/2 inch. Now imagine trying to figure that out for every slide. You don't have to because once you put the Grid Lines in, they are there for your next sheet of paper, OK.

So this would maybe be the inside of a brochure, then I would print, or make up the outside of the brochure, then I would download that as a PDF and send it to my print shop. And here are the steps, so they're included in the instructions and you download as PDF. An optional thing to do right here, number 5 is create an instruction sheet for your print shop. Now some of you are thinking OK yeah this is great but what do I need this for?

Well you're saving money, folks. This is free. Is it the best layout type of program in the world? It's not the best, no. There's Illustrator, there's whatever the other Adobe products are, I can't think of them right offhand but there's lots of different layout programs that you can create a brochure with. But this is free, it doesn't cost you anything. And if you get your students interested in print it's actually kind of a lucrative business to be able to do the layout and the printing.

So I'm going to come back into the room real quick and ask if there's any questions. As soon as I can figure out how to do this. Anybody have any questions so far? I'm sorry, I sound a little flustered because I am. It took me about 10 minutes to get in this room and it was right at the end. So if anybody has any questions, if everyone's good in five, four, three, two, one. OK, don't see any questions.

I'm going to go-- whoops-- see, already it's starting to muck up a little bit. Come on, share my screen. There we go. All right so we're back here, no questions.

Another idea for your students would be to create something similar on the flashcard level. So you can again set the Page Setup to where the screen size is smaller than what I have here. I'm not actually going to do this one, but you have flashcards for them.

So does anybody know what this is? Come on, there's a few of you out there, come on. What is it? If you've attended any of my workshops you know what this is. Nobody's typing, really?

This is a Waffle, or an App Launch. This is a More Button or a Dropdown Arrow. So again, just an idea for some flashcards. Something else that you could do, create interactive study guides. I just did some workshops on actually how to create Slides and use Draw.

And this kind of looks like a page out of a book, doesn't it? These do nothing, these little text boxes here. They do absolutely nothing. But this one does. Do you see how it's a different color?

And if I was actually on the page, let me go ahead and hit Present, here we go. So I can show you this is really big when it appears for the students. And I can hit Customizing Page Layout because that's the page I want them to go to. There it is. And here's what I want them to see. And to return, they hit the little button, because I've told them before with the little button does. And they come back.

I get to determine when they get to the pages. So I can make this page come up, and they can return. This page isn't ready yet, whoops, it actually went to the next slide. This page isn't ready yet, that's why it doesn't have a link.

So you get to control exactly how much your students will see. And if Google changes, which it does all the time, but if something changes or you want to add something to a page, you could update this. And your students, as they're going through the book, I'm going to call it, they would get that updated page. What this is doing is actually linking through this Slides deck.

Now I took these pages out of another Slides deck to put it in this one to show you the model. All of these pages actually do exist. And within that book, each one of those links goes to a different page. I hope that makes sense. So instead of just thinking about a program or a classroom, you could also have something set up like this for maybe professional development for your teachers or to go through step-by-step exactly what they need to go through or what's required as far as reporting is concerned.

I know some of you were concerned with the reporting, the NOVA, and all the other stuff that you have to do. So you could have all of this here on a Slides deck. Do you have to share the Slides deck in order to give it to people? Well you do kind of, but you do it in a different way. And we did cover that on the Section 1, I'm going to call it.

I'll show you real quick. So what we did was you hit the Share button, and you get the shareable link, you copy that link, and then you're done, OK. So that link just allows people to view and I haven't given it to anybody yet so they can't view it, right. So I'm going to go and I'm going to just show you what I would do if I opened an email. OK I'm going to basically insert a blank in here so I can show you the voodoo to do, OK.

So pretend this is an email. And I paste the link in the email and I say, "Hey Neal, here's the Slides deck that explains exactly what to do when you're sharing something." And what I do with this link is I take out the last part of it where it starts with Edit. So I take out the word Edit and everything else to the right and I type in the word Preview. And I send that link to whoever I wish.

And what happens when they open the link is that it looks like this. There's no way for them to copy. The links will be live. So this is the entire Slides deck.

So here's the page, the Table of Contents, right, bit-by-bit. So they can click through and see exactly what you want them to see but they have no control over the page itself. They can't change the page, they can't add anything to it, they can't take anything away from it. And if you do this the right way, they won't be able to copy it.

So view that first video, Collaborating Tips for Consortia. View that first video and that is covered there. I think I also have a slide later on that also shows you how.

One other thing that you can do as far as interacting with students or just showing people something, is to have a Video Guide. So you have a video within the Slides, and I know I've got all these lines it's a little confusing, but you have the video and then you have questions.

Let me show you how that actually looks. Here we are. Because I created this slide, I went to YouTube and I found a video on how to write paragraphs for the GED, OK. And I want them to answer these specific questions. How many ideas are needed and how do you decide which ideas to use?

This video is about 15 minutes long. I don't want them to waste the time. I want them to answer the questions soon, OK. Maybe I've got a form off to the side where they're going to answer the questions. But I want them to get to the information quickly.

So to do that what you can do when you're creating Slides, is you click on the video itself and then there's this magic button right here called Format Options. When you click it you are given some options that include Video playback. When you select Video playback, you can set the video to start at a certain time and end at a certain time. You can also play it while it's in this little subsection here. And I know you can't hear that but she was talking.

So if I wanted to change the start and end time, I could do that. I could select Autoplay when presenting so as soon as the slide comes up it's ready to rock and roll. Or maybe I just want them to see something on the movie, or the video, I don't want them to hear anything. I could mute the audio. So a lot of ideas here on how to create an interactive Slides deck.

Here's the Preview Recap because I know some people are going to want to see that without going back to that first video and that's OK. I'm going to come back into the room and see if there's any questions so far because we're about to go into Docs. So if you don't have any questions on Slides. Are we good? Everybody's good. You're all eating lunch aren't you? You're just listening to me.

I have somebody Paige is good, OK. Inland Assistant is typing, "Are you going to go over Google Drawing?" Oh my goodness, I tell you what, if there's time at the end, I will show you some Google Draw stuff, OK. So far so good Patty, thank you, thank you.

All right, so I'm going to go back to sharing my screen. Yeah Google Draw is a very powerful tool and most of the drawings that you're seeing here in this presentation, and there aren't that many really, but most of them I've created. So I don't have to worry about copyright issues. Screenshots however, tires screech, I did not create this one.

So Document outline, a lot of people don't know about this in Docs and it's really, really a cool feature. It will help you out so much if you've got a really long document or maybe minutes of a very long meeting or the bylaws and subsections of blah blah blah. The outline of the online document will help you immensely.

So I'm going to open this test up and as soon as you see it you should recognize the text there, "We the people of the United States." So I copied part of, not the entire thing, but part of the Constitution. So as we scroll down here, if I wanted you to go to Article III, you can do a search for it, OK. And you'd probably scroll past it, "Oh gosh I'm already at Article VII. OK, to go back up I got to go down blah blah."

Don't do that. Go to View and Show document outline. This will appear to the right. And everything that has been bolded and that is basically its own line, so it's using a heading, it will become a link. And when you click on it, it goes right to it.

So there's Article II. Here's Article III. And if I want to go back to the top, Article I. That doesn't quite get me there though, does it? Doesn't quite get me there.

So what I did was I created a Bookmark. This right here. It's really tiny, let's see if I can make it bigger. I mean if you just had to back away from your screens. OK so right here, TOC TOP.

So a Bookmark area on a document actually creates a link and then you can tell it where to go. OK I'm going to go back to Normal View. We're going to go back to 100%. And way up with the top, you see this right here? This is a Bookmark.

So what I did was I inserted my mouse, my cursor, right here, OK. And then I went to Insert. And because I already have one there its not going let me do it again, but I went to Bookmark, OK. So after that, I created a link OK, TOC TOP.

And to create a link it's really easy. You select some text and then you go to the Link tool. And it will ask me, because I've created some Bookmarks, "Hey, do you want to use a Bookmark or do you want to go to a web page or what do you want to do?"

OK, so I've created a Bookmark. And here's the Bookmark I created, right at "We the people." OK, so I'm going to go ahead and do that and Apply, and there's my Bookmark. So that when I click on it, it goes right where I want it to. So I could have a Bookmark here for Section 9 or I could have a Bookmark in Section 2.

Now TOC TOP, this Bookmark right here is in the Footer. So it's going to appear on every page. So I can always get back up to the top. Make sense? It's a really cool idea.

Also on the Sections, what Google does is it goes, "OK it's bold and it's got its own line. So it must be important. So we're going to put it on the outline. If it's important it must be on the outline." Well maybe it's not important to you. You can remove it.

Now I've just removed Section 1 of Article II, but it's still bold and it's still there. I didn't delete the text, I just deleted its importance from the outline. So I'm going to delete all the sections out of Article I, so that when I hit Article II it will go there. But I'm going to have to scroll up now to see the Sections 1-10 on Article I. Wow that was a mouthful.

All right, so again, all of these are links. I can go right to them. By the way, our Founding Fathers made a lot of spelling errors. I don't know if anybody knows that. I discovered that.

I can go to any of these Articles, any of these Amendments, or I can remove them from the outline. Once you open the outline, let's say you're done, you don't want to see it anymore, you can actually turn it off and that saves you some real estate if you're on a very small device. So very cool thing to use in order to maneuver or navigate through a very long document is go to View document outline, OK.

I believe the next slide is going to click about something else. It's pretty cool. Let's just make sure, yes, Document Links.

OK so we've already talked about the Bookmark. Another navigation tool is the Link tool. So I can go back here and I can select any text and I can make it a link to go anywhere or to open anything.

So I'm going to let that sink in for a minute. I can let it go anywhere, we're all used to that. It goes to a different website, right? Or it can go to anything. I could have it go to see all these headings?

OK so I can have it go right to this Article V, Amendment V if, let's say the text I selected was about ensuring the domestic tranquility and Article V has to do with that. So I make it a link. You can do it that way or, let's go back up here, go to Link tool.

You can also go to your Bookmarks, I've already shown you that. You can paste a link, OK, that goes anywhere. Let's go to CAL, www.caladulted.org, which has nothing to do with Article I but I'm the one creating the link so I can have it go anywhere I want, OK. So you can have a go to a link. You can change it or you can remove it at any time because you're the owner, you're the one creating it.

You can also have links go to-- I'm going to scroll down here-- your Drive. So if I have anything in my Drive-- I'm looking way to the right now-- anything in my Drive that I want to link to, I can add that. Or I can link to another document, I should say.

So let's think about that for a sec. Let's say I'm creating a book and I have chapter one all on its own, chapter two all on its own, chapter three all on its own. I create a Table of Contents all on its own and then in that Table of Contents, instead of using Outline view, I would have the Table of Contents with chapter one, chapter two, chapter three, as the text. So let's say this Section 1 is actually chapter one, with a little description of chapter one, and then I have it go to that document when I link it.

So you can link your documents to your documents. You can basically daisy chain them, for lack of a better description. You can also link to images.

Now this is an online document, OK. And Google is trying to help me. So it recognizes that we have the Constitution here. Most of the text is going to be related to the Constitution of the United States.

Google knows that and I know that's freaking some people out right now. Embrace it, it's going to help you. OK so embrace the love from the app that you have opened online. If you're in the least bit antsy about putting anything online regarding your own personal information, I applaud you for that. Be antsy about it and don't do it, OK.

This is the Constitution of the United States or this is a lesson plan or these are the guidelines of the consortia, whatever. I don't care who knows about it. It's OK. It doesn't have my social security number on it, it doesn't have my bank card number on it, so it's OK. So it's OK that Google is trying to help me.

So one of these images, I could certainly insert if I wanted to. If I go to WEB, I'm going to click on WEB here, I also get a bunch of different websites that I could get some research from without even leaving my documents. So if I'm doing a lot of research for my consortia and I'm doing it on a Doc, I can open up-- and I did it a different way-- but I can open up the Explore tool and do my research.

So I'm going to just put my mouse somewhere in here. I'm going to go to Tools. And here's the Explorer tool right here.

I'm going to make my window a little smaller so it drags up some, there we go. It's also down here, OK. Way down at the bottom, the Explorer tool is right there for you. So I can open it either way, OK. And then I can search.

So I can search for anything. Google is a search engine and Docs is part of Google so they work really well together. Let's do some adult education in CA. Let's see what we come up with. So the California Department of Education, there we go.

So any one of these, I could click on and it's going to open up in a new window. It opens up in a new window, or new tab. So I still have my document open. If I read the article or the website or whatever and I want to cite it, I can select the text that I want to use as my cite, C-I-T-E, OK.

I'm going to hover over the web link and you'll see I'll have a little quotation mark show up. So that Cite as a footnote, I'm going to click it. And it doesn't really look like anything happened over here. But if you look where my cursor's at, it's got a little number one.

And if I scroll down this document, right here is the footnote, cde.ca.gov. OK. It also tells me when I last accessed it, which was today.

And you can also see that I already had a footnote listed. And it actually went to the document that I found online because I wanted to be able to cite it for you so you knew where it came from. And because I entered my footnote above that first footnote, it became number two. Does that make sense? So number two is down here somewhere, OK. It used to be number one until I added a footnote.

Why am I telling you all of this? Oh here it is, number two right here. Right so I added that one yesterday. And this one we just added. This was number one and I know it's in the wrong place. I apologize to all the grammar and our English teachers in the room but that's just where my mouse landed.

Footnote one, this is the second one I put in but because it is first, it comes up is number one. So if I take this one out at any time, there we go, this becomes number one now. And let me undo that. This is really important because this, in the old days, would have saved me gallons of White Out. There might be a few of you in the room that know what White Out is.

Let's say you have 30, 40, 50 footnotes in a document and you decide number 39 is no good any longer, or you want to take it out, you had to go in and white out all of the numbers, right, and then renumber them. And probably end up retyping it because it made a mess. With the Docs, all you have to do is delete the footnote. And you can delete the number from the text, which is what I just did, or you can go down to where the footnote appears and you can delete the citation.

Sorry folks, my mouse is acting up here really badly, there we go. So you can delete the citation and the footnote will disappear, when the mouse is working correctly. I'm having all kinds of tech issues.

All right, so Links and Bookmarks, we've gone over that within Docs. What else can you do in the document? We've already done the Explore tool, really cool tool, you can go in and do research without actually losing anything.

Some other document ideas, you can turn off Convert to Google, and I don't always recommend that. As a matter of fact, I'm a firm believer against doing that. However, if you go to Drive and turn off Convert, then you can share documents and edit documents as Word documents. So let me show you what I'm talking about.

We're actually going to go to Drive. And within Settings, this is the Settings gear right here, looks like a little gear. I'm going to click that. And it's redundant but you have to click Settings again, OK.

This is the magic box right here, Convert uploaded files to Google Docs editor. You want to keep that on to save yourself space because everything that you upload to your Google Drive, if it's being converted, it's zero space. It's good to go.

As long as it's a document, text file, basically, or a presentation file, or an Excel-type file. PDFs, they're going to be the same size, videos are going to be the same size, images are going to be the same size. So those don't convert but the text editors do. If you turn this off and you hit Done, when you upload a Microsoft document into your Google Drive, then it stays a Microsoft Word document.

So that when you have those people in your organization, or part of your consortia, that they don't want to use the Google, they have no use for the Google. But you want them to be able to share a document, you want them to be able to edit a document, you want them to be able to view the document. You upload it as a Microsoft Word and what you do is you install this handy little tool called Office Editing for Docs, Sheets, and Slides.

And I'm hovering my cursor over it. I'm not going to be able to scroll in for you to see it. It's a little circle with a pencil in the middle. So if you go to the Chrome extensions, you can install that, OK.

And that way when you actually open a Word Doc, you are editing it in Word without having Word installed. Or you are editing a PowerPoint without having PowerPoint installed. Or an Excel spreadsheet without having Excel installed, OK.

So go ahead and upload or save those documents that someone has sent you as a Word file, and they've warned you don't make this a Google Doc. Fine, I'm going to keep it a Word file but I'm still going to be able to edit it because I have this Chrome extension right here.

You can also, and you should, convert files to PDF. That compresses them, that makes them smaller. And then you can send them through email. Nine times out of ten, a Word Doc or a Google Doc will not send through email that well because the receiving side will detect that Word file and Word files are notorious for containing links that are not good, OK. We've all experienced that in the past.

So what you do is you convert the files to PDF. Well how do you do that, Melinda? You go to File and Download As. You can do this in Word, you can do this in PowerPoint, it doesn't matter.

You won't get the option to convert a Doc into a PowerPoint. By the same token, you won't get the option to convert a PowerPoint into a Word file. You don't see that here, right. But you can convert both of them into a PDF. And when you do that, again, it compresses it and it will make it more palatable for the receiving end of the email server that you're sending this document to.

You could send a meeting agenda using this Office Editing Chrome extension. Doesn't matter whether it's Chrome or whether it's Drive or whether it's Microsoft. You can send that meeting agenda out to anybody, they could see it and maybe, maybe on the second page, or you have a table where you assign everybody a number, you can write on row one, you can write on row two, Bill can write on row three, whatever. But then they can input their ideas for the agenda. So you get everybody's input that way and you're collaborating that way.

So those are some other document ideas. And we're going to stop real quick to see if-- and it looks like we have a question. Hang on just a sec. The British [mumbling]. "OK I don't understand. It was the British English that messed up their spelling--" oh you're talking about when I said the Founding Fathers. Yes Jodi, [laughs] the British. God love the British, yeah.

All right, all right then. How do I close this? Like that, OK. So it doesn't look like there's any questions so I'm not going to stop sharing.

We're going to go right into Sheets. And I just helped somebody recently and I can't remember what adult school they were with, but they were trying to-- I'll go over this in a sec. I want to go over-- here it is. Some cool functions here. Oh, no, it wasn't that either. Oh, the slide is gone, darn. All right I'm going to have to update that.

What she wanted to do was protect ranges. And we actually went over this in the first Google that I did so I want to show you. Pivot, here we go. And I'll just open this one because I'm going to be showing it to you later anyway.

So what the person wanted to do, she's from a consortia school, and she wanted her teachers to be able to input on certain cells, OK. So she wanted to protect part of the spreadsheet but not all of it. She wanted the capability-- let's say right here, the funding-- she didn't want anybody to touch the funding column, OK. But they could enter scores.

Well how do you do that? Well first, you have to protect it, OK. So what you're doing is you're actually protecting the Sheet and then you're unprotecting this right here, the column. And you can actually protect specific cells.

You can give John the rights to rows C1-C6. You could give Susan rows C7-15 OK. She's an over achiever she gets more cells. And so on.

What you do is you protect the pool, OK. I'm trying to use a pool metaphor here and it's not really working for me. You don't protect the Sheet, you protect the cells. There we go.

So you're taking people out of the pool, instead of putting people into the pool. This is in the first video. OK, you're going to have to trust me. I explained it a lot better there.

But you can protect specific cells within the Sheet, you can protect specific ranges, you can protect entire Sheets. OK there's that right there. OK. Lots of different stuff you can do on protection.

This is one of the next slides. You can use the Pivot Table, within the Sheet. So right here we have Student Data, and we have a lot of Student Data. And let's say I want a count of all of the sophomores, the freshmen, the juniors, and the seniors.

I could go through and count each one of these or I could create an IF statement. If C1-C61 equals senior, count one. If not, then you have to add another IF statement so that it will do it in a running order. So if it's senior, if it's junior, if it's freshmen, if it's sophomore, and if none of those then zero.

It's a really complicated process. You'd have to have a cell dedicated to senior, freshman, junior, right. It's complicated. But if you have a Pivot Table, you can tell it, "I want this range and I want you to count."

And there it is. So we have 18 freshmen, 10 sophomores, 11 juniors, and 11 seniors. And it's real-time data.

So if I change one of these to something different. Let's see, I'm going to I'm going to copy this sophomore here and I'm to put him down here. So we had 11 seniors, I believe it was 11, now it's 10. And it's just that quick.

So as the people are changing the data or as data is being input into a form let's say, your Pivot Table will also be changing. And you want to do this for really great big bits of data. You don't want to do it for like maybe five rows. It's actually harder if there's less data.

So Pivot Tables is a really cool function. This will be how you spend your summer, yay [laughs] Pivot Tables is a really cool function on Sheets and if that's what you're referring to.

Something else that you can do-- let's me make sure I'm on the right doo doo doo doo doo doo-- you can reuse forms. So I'm going to open up a form real quick because I have it linked. Here's the form. And I use this for all my trainings.

Everyone signs in. They sign in with their name, their email address, where they work, OK. And if you look down at the bottom here, you see the last place I went was Mt. Diablo. The time before that was here in Sacramento, HCCTS. Before that was a hodgepodge, actually. We had a bunch of people, see we had Monrovia, Azusa, Monrovia, Azusa. Oh this was a part of the USA consortia. This was a consortia event, Mt. Diablo again.

So you see all of these Sheets are within this Sheet. All this data came from one form, this form right here. So I use it over and over and over again. I don't have 50 forms for every workshop that I do. What I do is after people input, after people use the form, I will go here and I will unlink the form.

And what that does is that takes away the handshake, OK. That takes away the connection between the form and the Sheet, OK. And that's OK, you have to embrace that.

After you do that, what you do is you delete all of the responses from the form. It's OK, when that comes up just say OK, and I know what I'm saying Cancel now because I've already done it. There's nothing to erase, you see, there's no responses here. There's nothing that's been answered it says zero. So I've already done it, OK. I unlinked it and then I deleted all the responses.

Next thing you do is the important part, you relink the form. So when you relink it-- and here I'll tell you what, I'll go ahead and unlink it-- you get the big scary message, just ignore it and say Unlink, OK. And then you'll get this message down the bottom here it says Spreadsheet unlinked.

Now we're going to go back to that More button and we're going to select a response destination. And I'm not going to create a new spreadsheet, I'm going to select an existing spreadsheet. I happen to know what the spreadsheets name is, fortunately. It's named the same thing as my form, SIGN IN 2019, and I'm going to hit Select.

What happened right then is that it created a new Sheet within the spreadsheet. So here's Form Response 8, has no data in it. So my next workshop will be in LA.

I will use this form. I'll change the name to LA and then I'll unlink, delete, and relink. Just what I said, OK. So that I can use a form over and over again.

So this is something you could think about, maybe for attendance. If you're having a conference and you're having multiple PDs and you want people to sign in, you could use a form to do that. And you use the same spreadsheet over and over and over again. So you're saving your data and you don't have to reinvent the wheel every time.

You can also password protect a form. It's really simple to do, all you have to do is have a question that goes somewhere. Hang on just a sec, there we go. So right here, enter the password for the Groupers quiz, so this is where they would enter the password that I give the students. If they don't type it correctly, they don't get to continue.

That is how you password protect a form. Right here, this short answer text, I make it required, OK. I also click the More button over here and I choose Response validation. From Response validation, this menu will appear. I choose Regular expression matches this word, OTAN1

I could change it right now to OTAN4. And the next class that comes up, if they type OTAN1, they're not going to be able to get to the next section. They have to type OTAN4. And if they don't, they're going to get this message, "Nope, did you type all lowercase?" OK, I can make that message anything I want.

So I'm going change this back to one because otherwise I'm going to get confused in my next workshop. So that's how you can password protect a form. So if anybody ever tells you, well you can't password protect it. Yes you can, OK. I'm going to go ahead and close this and we're going to go back to our Slides deck.

So we already went over the Pivot Table. OK, some cool functions here. So also what I wanted you to see is something like this. So I have a bunch of sites here and there might be duplicates. There might be duplicate information, maybe somebody is entering the info and it's from paper and they might have grabbed the same stack at the same time and entered the data. I don't know, I'm just making this up.

What Google now has is a Remove duplicates section. So if you click this link, it will take out all of the duplicates. And you can also tell it, "OK I want you to take out the duplicate." Hang on just a sec. The range of cells, because I selected cells, or it will ask you which column do you want to remove the duplicates from. Lots of info there to get rid of.