My Google Tools Tutorial Videos in One Playlist

Over the last year I've created a bunch of how-to videos to answer common questions about Google Drive, Docs, Spreadsheets, Forms, Chrome, Maps, and Earth. This evening I finally put all of those videos into one playlist. That playlist is embedded below.


I'll be adding more videos to this playlist as I create them.

The Solutions to Common Stains Found in One Great Database

Stain Solutions is a handy website developed by Susan Taylor at the University of Illinois Extension. The site is a database of dozens of common stains and the solutions to remove them. Click on a stain in the chart and you will be taken to a list of the ingredients needed to make a solution that will remove your chosen stain. Directions and warnings are provided along with the solutions.

Applications for Education
I don't know of any teacher who hasn't stained work clothes themselves or had them stained as the result of a student mishap. I've stained enough neckties to create a drop-cloth. Coffee, ink, and markers seem to be the leading causes of those stains. Solutions to remove all those stains can be found on Stain Solutions.

H/T to LifeHacker.

Video Book Reviews in the Common Craft Style

This evening on the Common Craft blog I saw a video in which someone reviewed The Art of Explanation by making a video in the Common Craft style. The producer of the video, Bruce Herwig, wrote a blog post explaining the lessons he learned in the video production process.


Applications for Education
I've written about book trailers a handful of times in the past. (Most recently in this post in June). Usually those projects are focused on having students produce something that will get other students interested in a book. The approach that Bruce Herwig uses in the video above is slightly different as it focuses more on providing a clear overview of the book rather than just trying to hook viewers into reading the book. That approach could be a good one for high school students to use as a means to providing reviews of non-fiction works that may not have the entertainment value of fiction works.

Long Awaited Features Added to Google Forms

Whenever I lead a workshop about Google Forms teachers always ask if there is a way to limit response and if there is a way to randomize the order of the questions in the form. Starting today the answer is yes. Google has finally added those options to Google Forms.

Limiting form responses to one per person is now a simple matter of checking the box labeled "only allow response per person." That option appears above the title of your form.

Randomizing the sequence in which questions appear on your Google Forms is now just a matter of clicking the box labeled "shuffle question order." With that box selected each person viewing your form will see the questions in a different sequence.

Click the image to view it in full size.

These new features are available now to anyone using a Gmail account to access Google Forms. According to Google's official Google Apps Updates blog the new features will be rolled out to Google Apps for Edu and Business users over the next two weeks.

There were some other new, but less significant, features added to Google Forms today. Those features include shortened URLs for sharing Forms, the option to search with the help menu, and limiting "grid style" questions to one response. 

I don't think that the shortened Forms URLs will be terribly useful because the shortened URLs cannot be customized and they are case sensitive just like Goo.gl URLs. I prefer to use Bitly to create custom shortened URLs.