Wednesday, March 6, 2019

My Five Favorite Google Sheets Add-ons

Last week and through the beginning of this week I have been featuring my favorite Google Docs, Slides, and Forms add-ons. Today, it is time to share my favorite Google Sheets add-ons. These aren't necessarily the most popular add-ons, but they are the ones that I think of first whenever I'm asked for recommendations for Sheets add-ons to try.

Flippity provides teachers with twenty handy Google Sheets templates for creating things like quiz games, audio flashcards, and progress trackers. Flippity's Google Sheets Add-on that makes all of their templates available with just a couple of clicks in any of your Google Sheets. In the video embedded below I demonstrate how to install and use Flippity's Google Sheets Add-on.

Flubaroo is not as popular as it once was, but it is still a great Google Sheets add-on. Flubaroo you grade all at once all of your students' responses to a quiz created in Google Forms. You're probably saying to yourself, "Google Forms does that too." You're right Google Forms does do that, but Flubaroo lets you do more than just grade quizzes. You can use it do things to print score sheets for your students, give students digital badges, and give partial credit for answers. Take a look at this video for an overview of ten things you can do with Flubaroo.

Online Rubric is a Google Spreadsheets Add-on that enables to you create rubrics, enter scores, and email scores to students all from one place. Online Rubric provides very clear instructions for each step of the processes of creating a roster sheet, creating a rubric, and emailing grades to students. The video below provides a demonstration of how to use the Online Rubric Add-on.

Add Reminders is a Google Sheets Add-on that will set-up your spreadsheet so that you simply enter reminder messages and email addresses then specify a date on which you want your reminders sent. The Add Reminders Add-on allows you to send the same reminder to everyone in your email list or you can send individualized reminders to everyone in your email list. Watch the video below to learn how to use the Add Reminders Add-on.

If you're the person in charge of scheduling conference room, computer lab, library, or science lab use, Lab Scheduler is the Add-on for you. This little Add-on will give your Google Sheet an easy-to-follow template for coordinating room use without the need to make a zillion entries in a Google Calendar. Share the Sheet with your staff as view-only so they can see who has reserved a lab.

How to Move Materials Between Your G Suite Accounts

Earlier this week a reader sent me the following question, "Do you have a suggestion for a way to move my folders from one Google drive to another one? I'm moving and want to take with me my work folders." I do have a suggestion. The suggestion is to either download your folders as ZIP files and then upload them to your new account or to simply share the files between the old account and new account. I demonstrate both options and explain a bit more about them in the following video.

Tuesday, March 5, 2019

Spring Forward This Weekend!

This weekend those of us in North America who observe Daylight Saving Time have to move our clocks forward by one hour. This time around it is especially annoying for me because I have an early morning flight on Sunday. And, of course, my dogs and my toddlers don't observe Daylight Saving Time. If you have kids that are older than mine or students who are wondering about the reasons for Daylight Saving Time, check out the following resources.

The following videos offer concise explanations of Daylight Saving Time.

Even though it is not about daylight saving time, this TED-Ed lesson about the standardization of timezones is worth watching.

The Answer to the Question I'm Asked More Than Any Other

I answer a lot of emails from readers who ask all kinds of questions about educational technology. One question that I answer more often than any other is about the screencast videos I post on my YouTube channel. People often want to know how I get the yellow circle to follow my cursor around the screen. The answer to that is, "I use Screencast-o-matic."

Screencast-o-matic is available in a browser-based version and in a desktop version. I use the desktop version unless I'm using my Chromebook. There are three Screencast-o-matic service plans to choose from. Those versions are free, deluxe, and premier.

The free version of Screencast-o-matic offers everything that students and most teachers need to create a quick screencast video. The free version includes quick sharing to Google Classroom, video captioning, password protection of your videos. Those are just three of the eighteen features available to users of the free version of Screencast-o-matic.

The deluxe version of Screencast-o-matic is the version that I use. The deluxe version offers twenty-three more features than the free version offers. Those extra features are mostly found in the video editing capabilities which include greenscreen capabilities, hiding and revealing webcams, zoom features, and the removal of Screencast-o-matic's watermark.

The premier version of Screencast-o-matic provides everything in the free and deluxe versions plus fifty times the storage space of the other plans and dedicated video playback pages.

If you have an educational technology question for me, join me on Wednesday for Practical Ed Tech Live!

5 Favorite Google Slides Add-ons

Last week I shared my favorite Google Forms add-ons. Yesterday, I shared my favorite Google Docs add-ons. So today I'm sharing my favorite Google Slides add-ons.

Unsplash Photos Google Slides add-on gives you instant access to Unsplash's collection of free, royalty-free photographs. In the following video I demonstrate how to add the Add-on to your Google Slides, how to use Unsplash Photos, and I explain the licensing of Unsplash Photos.

Photo Slideshow
Photo Slideshow is a free Add-on that makes it quick and easy to import an entire Google Photos or Google Drive folder into Google Slides. Once you have installed the Add-on just select either Google Photos or Google Drive and then choose the folder of images that you want to have displayed in a slideshow. Each image in the folder will automatically be placed on a slide.

Easy Accents
This add-on appeared in my list of recommended Google Docs add-ons. I recommend the Google Slides version of it too. Easy Accents for Google Slides is easy to use. When you have it installed you can launch it on any slide. Type as you normally would until you need to add an accent mark that isn't easy to create on your keyboard. Then just insert the letter and accent mark that you need from the Easy Accents keyboard. After inserting the letter and accent mark you can go back to typing on your physical keyboard.  Easy Accents for Google Slides currently supports more than twenty languages.

Grackle is a service that will check your Google Documents, Slides, and Sheets for accessibility. It is available as an Add-on for Google Docs, for Google Slides, and for Google Sheets. When you run Grackle's accessibility checker it will identify places where your slide doesn't meet accessibility standards. It makes suggestions for improvement on the areas in which your document, slide, or sheet doesn't meet accessibility standards. Some of the suggestions can be implemented with just a click from the Grackle Add-on menu while others are changes that you will have to make yourself.

Add Audio to Your Google Slides!
This isn't an add-on, it's a Chrome extension that you install to work with your Google Slides. AudioPlayer for Slides is a Chrome extension that will let you add music or spoken audio to your Google Slides presentations. With the extension installed you can simply right-click on a slide in your presentation and then select an audio file from your Google Drive to play on that slide. Unfortunately, the audio file will only play on the selected slide and not over all of the slides throughout the presentation. It should also be noted that you can only play audio files that you have stored in your Google Drive.