Skip to main content

Stop using Google Forms for Everything

This spring I was asked to fill out of few surveys to vote on certain changes in our community. All of the surveys were anonymous Google Forms and had simple multiple choice questions. I was only supposed to fill out each survey once but nothing prevented me from voting multiple times.

So I created a little script that allowed me to stuff the ballot boxes with my preferred choices.

Automated Google Form filling demonstration (modified from this example)

Don’t worry. I didn’t cheat on any of the real surveys… but I could have.

Google Forms offers an easy way to create surveys but it doesn’t have survey protection tools that minimize or prevent participants from taking the survey over and over again. This feature is only available if participants sign in and surrender their anonymity.

Surveys provide an easy way to get information from an audience. However, if you really care about the information you are gathering, you need to consider questions like:

  • Is the survey set up to prevent users from responding multiple times?
  • Will the survey allow you to know if you have a representative sample?
  • How will the results be analyzed and shared?

If you don’t consider questions like these, your audience may have the perception that you don’t care about the validity of the information being collected. The survey can be seen as an excuse building survey that is only used so you can have an excuse for why you made a decision.

To ensure the integrity of your survey’s responses, you may need to use a service like Qualtrics or SurveyMonkey that has a more robust set of survey protection tools.

Editable sign in screens for the Chromebook

Since you cannot take a screenshot on the Chromebook until you are signed in, it is difficult to get a good screenshot of the sign in screens. A few years back, I created some sign in screens so I could use them to create custom Chromebook sign in documents and presentations.

Google has given the Chromebook sign in screens a fresh look, so I have created new screens that match the new look.

The screens are:

  • enter email
  • enter password
  • show password
  • failed email example (with CAPTCHA)
  • first time users (Accept Terms of Service)

They were all created with the drawing tools in Google Apps so you can edit the text to display your school’s domain.

See them all here.

Also, my old screens are still useful since they are the screens for signing in to the chrome browser. I have updated them to reflect the change.

Moving from 2D to 3D using Tinkercad and Google Drawings

The concept of 3D modeling can be a challenge for young students. They may have little to no experience with the idea of 3D. To change this, teachers can build upon the prior knowledge students already possess.

what-is-3d-sm
An Introduction to Dimensions (Get these slides)

However, almost all of our students have experience with crayons, markers, and colored pencils. Creations done with these tools are done in two dimensions. Starting with a drawing is an excellent place to introduce the term dimension and the directions labeled X and Y.

The next step is to give students an experience with computer aided drawing (CAD). I like to use Google Drawings because it is free to use, easy to learn, offers a vast variety of fonts, and is already available to many schools as a part of Google Apps for Education.

Before diving into a tool like Google Drawing, I feel it is important to have a discussion with students about how the features in computer aided drawing (CAD) programs can help the creative process. For example, last year I worked with fourth graders that were creating a variety of U.S. maps. We encouraged the students to experiment with different styles and colors. The students learned that trying out different ideas in a digital drawing was much easier since it didn’t mean that that they had to start over.

To move to the third dimension, students need to move their 2D drawings into a 3D modeling tool. For 3D design, I like to use Tinkercad. It also is free and easy to use. Works created in Google Drawings can be saved as a .svg file that can be imported into Tinkercad. Once in Tinkercad, designs can be stretched in the third dimension- the Z direction. Below is a video demonstration of this process.

Fewer students feel overwhelmed when they enter gradually into the world of 3D designing and modeling. By providing students a way to transition from drawings on paper to Google Drawings to Tinkercad, they develop a foundation that often strengthens their confidence to attempt more complex designs.

Editable sign in screens for Chrome

UPDATE 3/24/18: Get New Sign in Screens – Google has updated the Chromebook sign in screens with a new look. The style used in the old screens are still used for signing in to the Chrome browser, so I made a few adjustments to them so they can be used to create custom Chrome sign in documents. I have created new Chromebook sign in screens and you can find them here.


Chrome sign in screenI can never get good pictures of the Chromebook sign in screens so I decided to recreate them.

The screens are:

  • enter email
  • enter password
  • failed email example (with CAPTCHA)
  • first time users (Accept Terms of Service)

They were all created in Google Drawings so you can edit the text to display your school’s domain.

See them all here.

Google Sheets missing full Autofill; Text Mechanic to the rescue!

Let’s say you need a long series of numbers in your spreadsheet and you are trapped on a Chromebook. Yes, I could drag down to fill but this takes way too long if you have a long list of numbers.

I hate that Google Sheets cannot do what Excel can do below:

Excel wins at Autofill
Excel wins at Autofill

Fortunately, there is Text Mechanic– a website that provides a collection of text manipulation tools that work in your browser. I used the Generate List of Sequential Numbers tool get the series of numbers I needed.

Use Text Mechanic to Generate List of Sequential Numbers
Use Text Mechanic to Generate List of Sequential Numbers

From here, I can copy and paste my list into Google Sheets and start calculating.

Text Mechanic has some other great tools too. Take a look at Find and Replace Text and Add/Remove Line Breaks. They have been a big help.

Does Google hate audio?

Maybe Google doesn’t hate audio but I certainly think they skipped it for its love of video.

With all the TV and YouTube channels at our fingertips, we tend to look toward video as the only tool for expression and communication. However, much like a good book, audio allows our students to conjure up imagery from within rather than having it blasted effortlessly into their minds in the form of video.

We can also challenge our students to create new forms of expression by restricting the use of visual elements. When students are asked to create audio works, they are given a chance to develop new ways to communicate effectively.

However, audio support seems to be missing in Google Apps for Education.

You cannot play audio (unless you get help elsewhere) in Google Drive.

no audio in Drive
Google Drive can play video but not audio?

 

Google Drive knows the audio files are there Read More

Embed an HTML5 audio player in Google Sites

Want to add audio files that play in your Google Site without forcing visitors to download the files first?

audio player in Google Sites
An HTML5 audio player embedded in Google Sites

Do you need this to work on the iPad or in other browsers that do not support Flash?

Below is the URL to a gadget I made that will embed an HTML5 audio player in Google Sites.

https://sites.google.com/site/basler45678/home/html5-audio-player.xml

Watch the video below to learn how to use it.

Get a direct link to files hosted in Google Drive

Update [10/2/2016]: It appears that Google has finally put a stop to this trick.

Update [11/7/2016]: Looks like Jonathan in the comments has figured a new way to do it!

Update [2/7/2017]: The website http://gdurl.com works too!

Imagine you want to use a QR code so guests at Parents’ Night can scan the code and stream video or audio straight to their mobile device. If you share the files in Google Drive, users will be taken to a Google page where they have to download the file first. But if you can create a link that points directly to the file, users can access the content right in their mobile browser.

Direct link files in Google Drive
Direct link to files in Google Drive

Turns out you can do this while still using Google Drive. Any public folder in Drive can host files and provide direct links to the files.

How to create the hosting URL:
https://googledrive.com/host/FolderID

This will provide a folder that will give direct links to files inside the folder.
Note: hosting view will not display files created in Google Docs.

Example:

Once in the hosting folder, you can right click on any of the files to get a direct link to the file.

Hey Google, what about the children?

With Google’s new version of Android comes improved multi-user functionality. Google explains:

Share your tablet with friends and family – each person has a separate customizable space, including personal homescreens, wallpaper, apps, storage, and more. You can also manage access to apps and content to create an experience that’s appropriate for each member of the family.

Each member of the family? Really? What about those family members under 13 years old? Here’s what you get when you try to create an account for kids under 13:

TooYoungForGoogle

Google does this because of COPPA, a U.S. law that requires online web sites and services to get parental consent for all children under the age of 13 before they can share any information with the web site.

At the press event announcing the new Nexus 7, Google demonstrates a child’s profile and how the access restrictions can be managed by parents. In this situation, the child user does not appear to be old enough to have a Google account. This child’s profile is sort of sub-account that lives within the tablet’s environment and does not need to be associated with a Google account.

Nexus7 for child

However, without a Google account, the child cannot manage his or her own content used in other Google services. Apps like Drive, Calendar, and Maps will need an account to save content. Many parents just let their child use a parent account for these other Google services. Other parents create an account for their child with a false birthday. I suspect that most parents don’t use the multi-user features at all.

I think Google could do more for families. We have Google Apps for business and education. Why not for families? Instead of prohibiting accounts for children under age 13, Google should redirect to a space where parents can create and manage accounts for their kids. Here parents could control access restrictions for the accounts and pass the account over once the child is old enough.

Google already has a plan for the death of Google accounts. It’s time they improve the process for the birth of Google accounts.