It's our 30th issue and we've got tips from Alice Keeler!

Our Instructional Services staff was fortunate enough to attend the 2017 ITIP Summit featuring Google for Education last week in Sandusky. This two-day event provides teachers, tech coordinators and other educators with excellent educational technology information. We all attended wonderful sessions and learned a lot of great info that will work its way into future trainings.

One of the highlights of the conference was being able to hear from keynote speaker Alice Keeler, who is a self-described mom, teacher, author, Google Certified Innovator, keynote speaker, and workshop presenter. Alice has been called the Queen of Spreadsheets and notes that "the answer is always a spreadsheet!" She has written three books, "50 Things You Can Do with Google Classroom," Go Further with Google Classroom," and "Teaching Math with Google Apps."

Chris, Kim, Kristie and John with Alice Keeler

Alice also shared a variety of tips in her workshop sessions, and we'd like to bring a few of them to you in today's TTT.

In Google Forms, no need to use the sidebar to add questions:

Control-Shift-Enter (Command-Shift-Enter on a Mac) inserts another question
Control-Shift-J (Command-Shift-J on a Mac) moves a question down
Control-Shift-K (Command-Shift-K on a Mac) moves a question up

For collaboration in Slides and Sheets:

Rather then sending a copy to every student, consider using one document for collaboration, having each student add a tab (Sheets) or slide for their own work. That frees you up from open 30 documents.
Each slide or tab has its own unique URL so have students use the goo.gl shortener extension to create a shortened link and turn that in.
Use the Question and Answer feature in slides to get instant class feedback

More stuff from Alice:

All the Chrome extensions she has developed
Cool add-ons and scripts she has created
Awesome templates from Alice

Alice has lots more great info on her website... including books she has written. You can also follow her on twitter @alicekeeler.

Comments

Relax: You're in Complete Control!

Well, you may not rule the world but you are in absolute control of the content in your Google account. You can copy the content in your account to use elsewhere or use the archive tool as a simple backup. This works great if you want to backup your YouTube videos or a specific folder in g Drive. To accomplish this, follow the below instructions: Visit https://myaccount.google.com/ From the Personal Info & Privacy area, click on CONTROL YOUR CONTENT Click on CREATE ARCHIVE The next screen allows you to select what data you want to include. By default, all options are selected. If you want to archive one specific folder in gDrive and/or YouTube files, it is easiest to click on the SELECT NONE button. After clicking on the SELECT NONE button, you will need to select which ones to include in archive by clicking on the white square next to the X. The green square with a white checkmark indicates that this data will be included in archive. If you s

What the SHEETS?!?

When creating a new Google Sheet, by default, it will have one sheet tab at the bottom of the page. The program is designed so that you can have a maximum of 200 sheets. To add additional sheets, you can click on the plus sign in the sheets toolbar. One sheet will be added. To rename the sheet, click on the dropdown arrow next to the Sheet, and select RENAME. You may want to explore other sheet tab options available from the menu. There may be times when you want your Google Sheet to open to a specific tab. To accomplish this, copy the URL of the specific sheet tab. For example, if you want the Google Sheet to immediately open to the second sheet tab named Chart, copy the Chart sheet tab URL. You will notice that the information to the right of the / changes: Google Sheet URL: https://docs.google.com/spreadsheets/d/1hivDhrInFjmhl-AFB_frFOvpsyuY541hxn6ShQuo7I8/ edit?usp=sharing Chart Sheet Tab: https://docs.google.com/spreadsheets/d/1hivDhrInFjmhl-A

Review your Google app permissions!

I just LOVE the Sign in with Google buttons that you find all over the web. They are great because they use a protocol called OAUTH to securely log you in using your Google account. This means you don’t have to remember yet another username and password. We get so used to clicking these buttons to log in to sites and that means we’re racking up a bunch of sites that have access to our Google accounts. Today, I’m going to show you how to manage the connected apps and sites that you’ve authorized with your Google account. We can use this tip to review these apps and sites to see if we really use them and if we want them to have access to our Google account. Just follow these steps: Click your photo at the top right of any Google window, and select My Account. On the left side of the My Account window, click Connected apps & sites Then under the Apps connected to your account section, choose Manage apps. This will give you a list of a

Tech Tuesday Tips

Search This Blog