(SPEECH) 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. (DESCRIPTION) Title slide, Innovative Collaboration Tips and Ideas for using Google - Part 2. Project Focus. For C.A.E.P. Consortia. (SPEECH) 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. (DESCRIPTION) What was covered in Part 1? Collaborating. Use existing email address to create Google account for access to Drive Apps. The 2 types of Google (Club and Pub). Different share options (editor, commenter, viewer). Commenting vs. Suggesting. Preview and Force Copy sharing. Protecting Sheets and ranges. Using Sites to share. And more! Check out the video and handout at Cal Adult Ed dot org. (SPEECH) 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. (DESCRIPTION) Text, What will be covered in Part 2? Good question! Things that you may not know you could do with Drive Apps. (SPEECH) 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. (DESCRIPTION) Project Ideas using Google. Slides. Setup and Layout, Flash Cards (template), Brochure (resize), InfoGraphic or poster (resize and Draw), Interactive study guides, Inserting video. Docs. Easy T.O.C. using Outline, Links and Bookmarks, explore for research, Other ideas... Sheets & Forms. Reusing Forms, Attendance download, Report data (with protection). (SPEECH) 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. (DESCRIPTION) Text, Page Setup and Layout. Slides do not have to be the default width and length of a presentation. Customize the Page Layout to create any print style needed including 8 1/2 by 11 (flyer, 1 page infographic, tri-fold brochure), 24 by 36 (poster), 5.8 by 4.1 (postcard), and more! Add Grid or Layout lines to the Master slide to allow for exact placement of objects on every slide, margins, gutter space and bleeds. Add additional Layout lines to individual slides for fine tuning as needed. Drag from ruler down for horizontal line, from ruler left for vertical line. Rule of Michael: Whatever outer margins, make the inner margins twice the width. An outer margin of 1/4 inch should have an inner margin of 1/2 inch. (SPEECH) 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-- (DESCRIPTION) Clicks Custom in Page setup. (SPEECH) 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. (DESCRIPTION) Hits Cancel. (SPEECH) I want you to see this. (DESCRIPTION) Page Setup and Layout slide. (SPEECH) So once you have that Layout made, everything you put on it will become that size. Let's do it for real. (DESCRIPTION) New tab in browser. (SPEECH) 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. (DESCRIPTION) Untitled presentation, Click to add title, Click to add subtitle. (SPEECH) 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. (DESCRIPTION) 8 1/2 by 11 inches. Clicks Apply button. (SPEECH) 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. (DESCRIPTION) Drags dotted vertical line to center of blank slide. (SPEECH) 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. (DESCRIPTION) Clicks ruler along top and drags horizontal line down. (SPEECH) 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. (DESCRIPTION) Slide with a header and three columns underneath header. Text in header, Title headers can go all the way to the top and to either edge on left and right. But the text may bleed into the margins and it should not. Set padding using the format options. In Column 1, Text, Title right inside. Draw your own images using the shapes tool - no copyright violations or permissions needed. In Column 2, outline of California state, Text, Title middle inside, Use format options for drop shadow. In Column 3, Text, Title right inside, All the tools you need to create a brochure are contained within Slides. Is this the perfect layout tool? Heck no! But it gets the job done and it is free! Good practice for students (and staff). (SPEECH) 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. (DESCRIPTION) Pulls line from vertical ruler on left-hand side to .25. Several grid lines appear separating the columns. (SPEECH) 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. (DESCRIPTION) Points cursor over grid lines to left and right of centerfold. (SPEECH) 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. (DESCRIPTION) Basic steps to create brochure using slides. 1, Resize the page setup to the full size of brochure. Portrait? landscape? tri-fold? 2, Position Layout lines on master to include for margins, bleeds, gutters, centers, et cetera. -- 3, use text tool, text color, shapes, and inserts to create outside of brochure (slide 1). 4, Repeat #3 to create inside of brochure (slide 2). 5, Optional, Create instructions page for print shop denoting layout lines with real lines. 6, Download as PDF. 7, Send to print shop. (SPEECH) 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. (DESCRIPTION) Question mark. (SPEECH) 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. (DESCRIPTION) Text, Online flash cards for students. (SPEECH) 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? (DESCRIPTION) Slide shows card with nine squares in a three by three shape. Text, Screen size dependent on page layout. (SPEECH) 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. (DESCRIPTION) Text on card, Waffle or App launch. Select to move between Google apps & tools. Next slide shows a card with an upside triangle and two sets of three dots, one vertical and one horizontal. Text on card, More! Drop-down arrow and dot dot dot. Specific settings or additional features for the app that is open. Look for arrow, horizontal and vertical ellipsis (skinny snowman). (SPEECH) This is a More Button or a Dropdown Arrow. So again, just an idea for some flashcards. (DESCRIPTION) Text, Create interactive study guides. 1, Create slides deck with all content. 2, Add a T.O.C. slide at the beginning. 3, Link T.O.C. to matching slide title. Make sure you have a return back to T.O.C. -- 4, Share with students in Preview. 5, Make chapters live as needed (add fail safes of hidden slides). 6, Edit content as needed -- the students will only see what you have linked. (SPEECH) Something else that you could do, create interactive study guides. (DESCRIPTION) Text at top of slide, Slides: Table of contents. Slide has two sides of listed text with fold in center. (SPEECH) 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? (DESCRIPTION) Clicks on dark blue text, Customize page setup practice. (SPEECH) 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. (DESCRIPTION) Navigates to slide with title, Customizing page layout. (SPEECH) 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. (DESCRIPTION) Points to light blue text on Table of Contents slide. (SPEECH) 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. (DESCRIPTION) Hits Share button along top. Share with others pop-up opens. (SPEECH) 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. (DESCRIPTION) Drags text box onto blank slide and pastes link inside. (SPEECH) 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. (DESCRIPTION) Opens browser tab and copies link. (SPEECH) And what happens when they open the link is that it looks like this. (DESCRIPTION) Title slide opens, Innovative Collaboration Tips and Ideas for Using Google - Part 2. (SPEECH) There's no way for them to copy. (DESCRIPTION) Advances through slides deck quickly. (SPEECH) 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. (DESCRIPTION) Text, Video guide. Add video to a slide with a link to a form for interactive homework or classwork. Teacher can utilize format options to denote start and end times. Watch the video and find the answer to these questions: How many ideas are needed? How do you decide which ideas to use? Video clip with play button in center. (SPEECH) 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. (DESCRIPTION) In Format options menu on right-hand side, First option listed is Video playback. (SPEECH) 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. (DESCRIPTION) Pushes Play button in subsection. (SPEECH) 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. (DESCRIPTION) Text, Preview share recap. Preview allows views without "touch" or copy. Changes to the file appear in real time to the viewer. Links always work (if formatted properly). 1, Select the Share button. 2, Select "Get shareable link" (view only) and copy the link. 3, Paste the link into a file, email, on a site, et cetera. 4, Delete all text from slash edit and replace with slash preview. 5, Send that link. (SPEECH) 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. (DESCRIPTION) Text, Document Outline. Use Document outline as a Table of Contents. Lines of text that are bold appear the Outline. Each Outline entry is clickable. Entries not needed can be deleted from the Outline without being deleted from the document. (SPEECH) 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." (DESCRIPTION) Document title, T.O.C. and Explore Example. (SPEECH) 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. (DESCRIPTION) Outline appears on left-hand side with Articles and subsections. (SPEECH) 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. (DESCRIPTION) Clicks on Article II in Outline menu. (SPEECH) 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. (DESCRIPTION) Points to blue underlined text, T.O.C. Top. (SPEECH) This right here. It's really tiny, let's see if I can make it bigger. (DESCRIPTION) Increases text size to 200%. (SPEECH) 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. (DESCRIPTION) Highlights the words Turn On, Navigates to Insert Link along top. (SPEECH) 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. (DESCRIPTION) Scrolls through Outline. (SPEECH) 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. (DESCRIPTION) Text, Document Links. A link connects information in a document to another location within the same document OR to an online location outside the document. Both aid in navigation. Link, add navigation to web site, online doc or shared Drive file. Bookmarks, add navigation within a document or to another document. (SPEECH) OK so we've already talked about the Bookmark. Another navigation tool is the Link tool. (DESCRIPTION) Navigates to Constitution text. (SPEECH) 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. (DESCRIPTION) Scrolls through list of Articles within document. (SPEECH) 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. (DESCRIPTION) Highlights the words Section 1. (SPEECH) 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. (DESCRIPTION) Clicks Images tab under Explore on right-hand side. (SPEECH) 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. (DESCRIPTION) Explore at bottom right. (SPEECH) 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. (DESCRIPTION) C.D.E. website opens. (SPEECH) 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. (DESCRIPTION) Highlights and deletes first citation. (SPEECH) 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. (DESCRIPTION) Text, Document Explore. Research without leaving a document (unless needed). Explore will search Web, Images, and your Drive for quick access and easy insert. (SPEECH) 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. (DESCRIPTION) Other Document Ideas. Edit Office files from Drive without converting them (Office not required) Chrome browser only. 1, Turn off Convert to Google within Drive settings. 2, Install the "Office Editing for Docs, Sheets, & Slides" Chrome extension. 3, Open an Office file within Drive. 4, You may be prompted to Open With -- select the extension. 5, The file opens in Docs, Sheets, or Slides, but keeps the Office extension. If you make changes, the file saves in the original Office format. Convert Files to PDF for compressed (smaller size) file to send via email. Send meeting agenda before a meeting for input from staff or attendees. Class project -- create class newsletter using columns. (SPEECH) 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. (DESCRIPTION) Settings window pops up. (SPEECH) 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. (DESCRIPTION) Question mark. (SPEECH) 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. (DESCRIPTION) Text, Forms & Sheets. (SPEECH) 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. (DESCRIPTION) Google spreadsheet opens titled Pivot Table - School data. (SPEECH) 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. (DESCRIPTION) Clicks Student Data tab at bottom, Opens table with columns labeled Student Name, Gender, Class Level. (SPEECH) 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. (DESCRIPTION) Opens tab next to Student Data titled Count of Class Level. (SPEECH) But if you have a Pivot Table, you can tell it, "I want this range and I want you to count." (DESCRIPTION) Table with two columns, Class Level and Count of Students. (SPEECH) 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. (DESCRIPTION) Text, Reuse Form for Multiple Uses. Linking a Form to a Sheet = all data collected appears in the Sheet. Unlinking a Sheet from a Form only breaks the handshake. The data is never lost. A Form that is Unlinked can be Relinked to the same Sheet (and then reused). (SPEECH) So I'm going to open up a form real quick because I have it linked. Here's the form. (DESCRIPTION) Google Form titled Sign In 2019. (SPEECH) And I use this for all my trainings. (DESCRIPTION) Clicks Responses tab. Table with several columns appears. (SPEECH) 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. (DESCRIPTION) Sign In 2019 Form. (SPEECH) So I use it over and over and over again. I don't have 50 forms for every workshop that I do. (DESCRIPTION) Clicks vertical ellipsis, then Unlink Form. (SPEECH) 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. (DESCRIPTION) Select button. (SPEECH) 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. (DESCRIPTION) Linking to Spreadsheet, Spreadsheet Linked. (SPEECH) 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. (DESCRIPTION) Text, Password Protect a Form. Within a Section, include a password or passphrase answer that has Response Validation set. User will be unable to proceed to next Section without providing correct answer. Name, Email, Type password to proceed, Correct Answer, Continue to fill out the form, Wrong answer, Sorry, that was incorrect, Select the back button and try again. (SPEECH) 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. (DESCRIPTION) Checkmark next to Response validation. (SPEECH) 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. (DESCRIPTION) Text, Sheets - Cool Functions. Split text to columns -- Need first and last name separated? Time separated from date? Characters at end of similar text to be removed? Use this function - great time saver! Remove Duplicates - Takes the guesswork out of similar columns/rows. Trim Whitespace - Removes leading, trailing, and repeated spaces in text. Very important for formulas - extra spaces are killers in formulas. (SPEECH) 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. (DESCRIPTION) Under Data in top menu, Remove duplicates. (SPEECH) 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. Something else I wanted to show you-- and I'm running out of time, I always work on the time-- the Split. So I'm selecting this column. (DESCRIPTION) Column titled Name Split filled with first and last names. (SPEECH) How many times have we have gotten a spreadsheet and it's got data in it and we want it to be split? We want the first name and the last name, we don't want just name, right. So what you do is you go here, you go to Data and you use the magic one, Split text to columns. And it's asking me, what do you want me to split it on, the Comma, Semicolon, the Period, the Space, maybe Custom, maybe I have a slash, or a web address and I want to get rid of the www. I could add that and then it would just leave me with whatever's to the right. So I'm going to add Space and there we go. Now my names are in first and last name order now. John Quincy, he's got his middle name in there so I've got some tweaking to do, OK. But this is a really cool function. I use this all the time. Now someone asked about Draw-- that was basically the last slide-- Draw is a very, very powerful tool. I'm going to add a blank here so that you can see some of what you can do. There's a bunch of shapes that you can use to draw your own stuff. (DESCRIPTION) On blank slide, drags rectangular shape out from cursor. (SPEECH) And all the shapes that you have-- you can type in tongues-- and as you move the shape, the text comes with it. I'm going to open up something that I created a while back and I've been working on it as I need to. This is my images file. So this is also something you could use with your consortium, you just create a Slides deck full of images. Every one of these images and I'm showing you right now, I have created. This belongs to me. I created it. This calendar looks very Google-ish doesn't it? But I created this. So I don't have to ask anybody permission to use their graphics, I have them. I've made them myself. This is one and this little book right here, I created those books. Those are mine. And it's really kind of easy to do, It's actually really cool too. It's kind of fun to do. I've learned to use the Curve. I'm just clicking click, click, click, click, click, click, click, and then it attaches itself, right. When I double click on it, each click created a little dot. And now I can morph it into anything that I want. (DESCRIPTION) Highlights image of mug, Several dots appear on outline. (SPEECH) So this right here, you see all the little dots right there, I can make this-- I'm not going to do it to this one because I don't want to screw it up. I want to copy and paste, there we go. So I could make this handle right here come in a little bit. And then we have a different handle, OK. This image belongs to me. So the power of Draw is really, really cool. I also, just for my own sanity because sometimes looking at these little shapes, especially on a small laptop, it's kind of hard to figure out what you can do or which shape it is. Is this the square or is that the square? So what I did was I created a Slides that has each one of the shapes and then when I see the gold handles then I go, "Oh yeah, that's the one I can do this with, OK." (DESCRIPTION) Clicks gold handle on shape and moves corner of rectangle in. (SPEECH) I'm going to undo that. So whenever you see gold handles you can do something with it. So try it out it's really cool. OTAN has a workshop on Slides and Draw. We just finished one in Mt. Diablo. There might be some people in here that did it. And hopefully we'll get to go back and show them some more. So the more you practice with it. Now this is a Microsoft image, OK. It's a clip art that I copied. Here's my image over here. Not too bad, huh? (DESCRIPTION) Side by side images, human figure in hard hat stands before easel. (SPEECH) So and I've been practicing, I'll give you that. And I've done a lot of stuff, I'm scrolling through here. I had somebody ask me if I could make some tools. Sure, I'll try it out. So here's a hammer. And another great thing about the images is that when you create your own, you can actually recolor them. And you can also make them different sizes. So I can take this hammer and I can make the entire thing a different size just like that. If I needed a smaller one. So that's a Draw in a nutshell. And I'm going to stop sharing or I'm going to pause and annotate here. So we can go, because I know I'm out of time. It is amazing, isn't it cool? Yay! And I'm so sorry folks, we got started just a little bit late and I was a little bit harried because of all the tech problems I was having. Apologies for the start but I think we ended on a good note. If you have any questions whatsoever about what I've shown you here or if you're having any problems like, gosh you know she showed us that Protect Range thing that I can't remember. You can watch the video or you can call me. Just contact support@otan.us or even better, go through caladulted.org and submit a request through TAP. Veronica will yell at me, she's right over the wall. And I will get your question that way. So either way you're going to get a hold of me and I'll help you out. OK. "Would you be able to share your Google Slides again, pretty please?" Which Google Slides, Inland Assistant. If you're asking for that handout with all my images, heck no. [LAUGHS] You can make your own. Yes, the Collaborating Tips for Consortia, it's a PDF right now. I tell you what, if anybody wants the actual Slides deck, if you type your email address in this chat right now I will share that with you. You'll have View Rights so that you can create your own copy instead of having the PDF. So if you type your email address in right now I will send that to each one of you. And make sure you get the Slides deck, not just the PDF. But the PDF is pretty cool and all the links inside of it will work, but I understand you wanting the Slides deck. Wow, everybody wants it, OK. Coollie mondo. Thank you, Paige. And if that's the Paige that I think it is, shame on you for missing the last workshop. [LAUGHS] All right folks, thank you so much. I appreciate your patience and I will be sending that Slides deck to everybody. Veronica, I'm going to let it out. Well I'm going to I'm going to go bang my head against the desk. Veronica, are you there? Here I am. Sorry, I was still on mute but speaking. Thank you all so much for your participation this afternoon. I hope you all found this webinar to be of value in your collaboration efforts within your consortium or even at your agency. As I mentioned in the chat pod, if you are interested in receiving this type of workshop at your site an in-person, hands-on, interactive workshop, please be sure to submit a support request. Or if you think that another webinar such as this would be a value to the Adult Education field, please be sure to let us know as well so that we could start planning around that. We are here to make sure that we are providing the types of workshops and resources that will be of value to you within your consortium and at your agency. I am about to close the webinar and when I do, the evaluation will appear. And again, that's an opportunity for you to express what it is that you're looking for so that we're able to successfully meet your needs. In addition, I am posting the URL of exactly where the PowerPoint, or the PDF, that Melinda has provided as well as the webinar recording will be located. So if you would like to share this with others or if you want to go back for a recap, it will be available for you. So I'm posting that URL here. And again, thank you all so much for your participation and your attention this afternoon. Have a great afternoon.