skip to Main Content

A Fix for the New Google Forms

I haven’t had a lot of time lately to keep up with the changes to Google Forms but got slapped in the face with them today when I needed to make a Google Form (new UI) and found no data validation options. Really?

Checked in on the chatter in our #GTAATX Hangout chat and spotted this handy reminder from Jess Powell:

Not in new forms
In the same conversation, as usual, a solution was offered. This time by the super fantabulous James Petersen:

James's Form Fix
Worked like a charm! My PLN to the rescue yet again.

 

 

The Amazing Google Race (LES Edition)

As an element of my technology sessions at Lakeland Elementary School’s teacher inservice yesterday, I took a different approach. I did this partially to better model what I have preaching (teacher as facilitator rather than all-knowing bestower of knowledge) and also to give my teacher first hand experience in how a student feels in that environment. Additionally, it made the session more interactive (less boring) and by finding answers on their own, the teachers should better remember what they learned to do. In hindsight, I also believe a major benefit is the realization of many of my teachers that they know more, and can do more, than they thought they could. Being under the pressure of a time clock and motivated to beat the other teams, they had very little wiggle room to have their creative problem solving skills hijacked by self-doubt. Instinct kicked in. From the standpoint of the facilitator, it was fascinating (and addictive) to watch that happening. Very, very cool.

Here is an amended version of the Google Slides I used to introduce the activity.

I encouraged grade-level teams to find more comfortable spots to congregate in our library. I told them they needed room to move and also to have the ability to talk as a group without other groups hearing them.  In addition, I told them that they would primarily be using one computer to navigate the challenges but other members of the team would also need their laptops here and there.

After the set of challenges was over, I went through each step of the process pointing out how I had envisioned finding the answers or completing the tasks. I also pointed out how some teams found other ways to do them. I shared how I felt as a facilitator and we talked about how the teachers felt learning in that type of activity. Overall, it was a little painful but, through the struggle of problem solving, learning happened. Teachers were engaged, working together as a team, allowing each team member’s strengths to be used.

 

Here is the overall structure of the activity.

I gave a link to a Google Form where teachers entered their team name and grade level – http://tinyurl.com/les-race. When that form was submitted, the normal “thank you for your response” statement was replaced with instructions for Challenge #1.

 

CHALLENGE #1:

Create a Google Drive folder called “Amazing Race” and share it with each member of your team and Wanda giving ALL of them the ability to edit the contents of the folder.

Upload a Google Document that has your team’s name & picture into that folder. Copy the link to that Google Document.

When you have completed this challenge, go to this URL: https://goo.gl/ZgS2Xk

When they went to the second Google Form, they were asked to past in the link to the shared Google Document. On submission, they received information for Challenge #2. 

 

CHALLENGE #2:

Create a Google Calendar event, scheduled for today at noon, titled “Let’s Get This Party Started!” and invite your team and Wanda to the event.

When you have completed this challenge, go to this URL: https://goo.gl/vPmDmz

When they followed the link to the third Google Form, they were asked if they were thinking of ways to use this with their students. I only gave them the option of answering “Yes.” The question was there more to GET them thinking about that now that they were in the midst of the activity. When the form was submitted, Challenge #3 was presented.

 

CHALLENGE #3:

This is a big one. So big, the instructions wouldn’t fit. You can find them at this URL. https://goo.gl/7nLfgo

Follow the link to that Google Document to see all the steps for Challenge #3. They created a 5 page Google Slides file. 

Slide 1 – A photo of Mabel Hubbard’s scientist husband. (This used Google Search to find out who she was and married to. Also, finding a picture of her husband and inserting it into the slide.)

Slide 2 – A screenshot of Google Maps street view of the Great Sphinx of Giza. (This used Google Search and Google Maps / Street View.)

Slide 3 – A text box containing the name of the man in this photo: http://tinyurl.com/les-who-am-i(This used Google Search by Image and insertion of text box.)

Slide 4 – A QR code that takes you to the LES website. (This involved Google Search and creation of a QR Code as well as inserting the QR code image into the slide.)

Slide 5 – There is a musical instrument on page 54 of Phonics Charts by Dr. Fry. Find a YouTube video of someone playing that instrument and insert it into the slide. (This involved Google Search – using the book title in quotes to find the exact book – which led them to Google Books. Once finding the instrument, searching YouTube for a video was next. The URL was copied and was used to insert the video into the slide.

Finally, copy the link to that Google Slide file. Go to this URL and submit it – https://goo.gl/JXnsxG

When they submitted the link to the Google Slides in the next Google Form, they received the information for Challenge #4. NOTE: After a little of time of them working on this one, I pointed out that, since the file was saved in a folder that they whole team had access to edit, different people could be working on slides simultaneously. 

 

CHALLENGE #4 – THE FINAL CHALLENGE!

Create a Google Drawing and save it in your “Amazing Race” folder.

Each member of the team must pull up the Google Drawing file at the same time. Each should draw their name using the Scribble tool.

When you have completed this challenge, go to this URL and follow the instructions there: https://goo.gl/x4EWF2

Not only did they dive into Google Drawing but they were able to collaborate on it at the same time. They had to find the Scribble tool as well. The final link takes them to a one-slide Google Slide file congratulating them and instructs them to chant their team name. This allowed me to know they were done at which time I wrote down their time (I was using a stopwatch). Other teams continued their challenges as I went through and looked at the evidence submitted, making notes of errors. 

New Addition to Google Educator Groups

I helped start GEG West Tennessee awhile back and, while we haven’t been as active as I had hoped, we have had a face-to-face event and have been looking for more ways to be of service to our members.

With the announcement last week of the redesigned Google for Education Training Center and the new certification structure, I knew we would have a renewed purpose but wasn’t quite sure how it would realize itself.

Then I checked my email and read this from our GEG Program Manager:

“We want to work with you to go further, and deliver an experience to all GEG participants that incorporates the aspects of learning we are pushing for with students: personalized, collaborative learning.”

GEG Study Groups are a way for GEGs to discuss and study the Google for Education training center resources.

Best of all is the Study Group Guide that has been provided. It lays out a semi-structured way for GEG participants to review and learn the new material as well as pass exams and obtain certifications together.

“GEG Study Groups will help GEG participants not only improve their product knowledge, but will support them in making real change in the classroom; ultimately enabling educators to effectively use technology to save time and drive student learning.”

Why haven’t I linked to the study guide? Well, I’m not sure yet if that is available for sharing outside of the GEG Leader Community but I will check as soon as I can. I can say that it includes a suggested calendar (proposed 10-weeks prior to taking a level test) for meet-ups as well as a way to organize the curriculum. They are continuing to refine and expand the study guide with GEG Leader feedback and results of a school-wide pilot they are running.

The addition of GEG Study Groups will allow for a form of more focused support by GEGs and those of us serving as GEG Leaders are indeed grateful.

GEG Study Groups

Learn more about Google Educator Groups
and how to join by visiting the GEG website.

Seriously? Come on Evernote!

I pay for a Premium Evernote account. Recently, as I have been working on my literature review for my dissertation, I have been using my Evernote account for organizing and searching PDF files of journal articles. I find it easier to search the PDFs in Evernote because of its fabulous OCR capabilities. I am not sharing these notebooks with anyone; they are for my use only and all files were gathered legally. I am not even halfway to my monthly usage maximum and I get this in my email today. It’s one thing to let me know there has been an uptick in usage and suggest best practices but the accusatory tone of this email rubbed me the wrong way. Maybe my level of stress has me oversensitive. Maybe not.

EverNO

To be fair, I received this from @evernotehelps on Twitter very shortly after sharing this blog post there. “That email auto-sends when we detect high upload; it’s not meant to be accusatory.” I certainly understand the auto-send but still think the email may benefit from a little bit of rewording. 

Print a Google Doc with Comments

This may be a trick other people have known and used for awhile but I just learned it so I am sharing here.

I am working on the outline for the literature review for my dissertation. Outline only but I used the comments feature to document my thoughts regarding the various elements of the outline and how I plan to tie them together. That way my instructor can help advise me in my thinking.

I wanted to print out the Google Doc along with the comments. Turns out, here is how to do just that.

First, on the Google Doc, use the File menu to select Download As and then Web Page. An HTML file will be downloaded to your computer. Open that HTML file in a web browser and you will see the text of the Google Document with footnotes for each of the comments.

File - Download As - Web Page

Top 25 Rated Learning Websites

I am in the midst of reviewing literature for my dissertation and came across a very interesting paper from the International Journal of Self-Directed Learning (Volume 11, Number 1, Spring 2014), “Analyzing the human learning and development potential of websites available for informal learning” (p. 12) and wanted to share a handy list included in the work. After developing a list 305 free websites for informal learning, eight criteria were used to evaluate each and all were placed into one of six categories. Included in the paper is a list of the top 25 rated learning websites according to this study. Here is that listing (Table 3, p. 19).

Language Learning

Outdoor / Adventure learning

Social Change / Global Learning

Virtual Education

Learning Portals

Shared Online Video

What do you think? Any of these new to you?

 

 

Create a Permalink for a Google Hangout

I heard about the Unhangout Project from the MIT Media Lab and MacArthur Foundation while at #EdCampUSA last week.

While I can’t dive right in to trying this (requires admin set up on their end), I was looking around their site and came across a service they offer that CAN be used right away.

Get a permanent link to a Hangout to make that Hangout into an easily reusable online meeting room; a conference call that is always available.

WARNING – Anyone using the permalink can enter the Hangout! No invitation is needed. So, while you want to make a handy permalink, I wouldn’t make it too obvious and I wouldn’t share it widely or post on social media.

  1. Go here – https://unhangout.media.mit.edu/h/
  2. Enter what you want for the ending of the permalink (which you can make shorter with a URL Shortener service later).
  3. Enter a quick title and description then create the permalink.
  4. Using the permalink takes you back to the page you are on at that time and you can launch the Hangout with the “Join Hangout” button.
  5. Various permissions must be accepted as the UnHangout Hangout App needs access to an assortment of services and features.

This won’t be useful for everyone but might be what you are looking for. If it is, great! If it’s not, share it out because someone else may find it helpful.

 

Use TeacherCal with Google Calendar!

If you are a teacher STOP what you’re doing and go to edusync.com and check out TeacherCal!

It is so super easy to set up (only takes a couple of minutes) and will be a HUGE benefit to you in running an efficient classroom for the coming school year. Not only will this increase communication and make file sharing easier with your student (especially if you aren’t lucky enough to have access to Google Classroom) but you can add parents to the loop simply by sharing the calendar with them!

Use this one interface to plan your lessons and set up to automatically share with all stakeholders (students, parents, grade-level teams, administrators).

I would go into more detail but, honestly, it is so easy and, because it is designed by teachers for teachers, the website provides an excellent overview.

  • TeacherCal is free!
  • TeacherCal allows teachers to create Google Docs right from their calendar!
  • TeacherCal automatically organizes your content in Google Drive!
  • TeacherCal syncs with Google Calendar!

Soon they will release EddyCal which will give students and parents an intuitive one-stop app.

Yes, it is in Beta but it doesn’t feel like a Beta. It is polished, not buggy at all, and ready for primetime!

Kudos to the EduSync team lead by CEO Ryan Lynch!

 

Back To Top