22 GoogleApps Solutions from Google Certified Teachers' (GCT) List
Source: Gone Google Gear
Here are some of the responses that best lend themselves to sharing. It's not an exhaustive list. In fact, I despaired of even making a list of problems and solutions since there is so much content to share. That said, I've really enjoyed taking a moment to go back over all the shared questions and responses...I'm really learning them this time rather than just marking them as "read" in my inbox!
Here's a list of the questions addressed (which will be updated frequently, I hope):
- How do I use a GoogleDocs Form to create events in a Google Calendar?
- How do I make those Google Account creation CAPTCHA's less frustrating to complete?
- Are there any cyberbullying resources related to Google Search?
- Is it possible to send an SMS and see it shown up as an event on Google Calendar?
- How do I migrate from MS Outlook to GoogleApps, including email, contacts, and calendar information?
- How do you migrate from Groupwise to GoogleApps?
- How do you create branching surveys, say, where students get a "new" branch of the survey depending on the choice they make?
Before I turn you loose to read the responses, I have to point out that there are TONS of great questions that are orphans...no response. I'm going to compile a list of those, too, since these questions are wonderful openers to learning conversations.
Q: How do I use a GoogleDocs Form to create events in a Google Calendar?
A: To respond to this question, Aran Glancy wrote the following:
I first created a Form which asks all the relevant questions (date, time, name, location, etc.), and I then wrote a script which creates a calendar event based on that data. Here is the link to the live form: http://goo.gl/ln7y
Q: How do I make those Google Account creation CAPTCHA's less frustrating to complete?
A: Kevin Jarrett offered this tip on how to make the CAPTCHAs easier to process:
I discovered by accident out of sheer frustration that the further "off" your entry is from the correct CAPTCHA, the easier the NEXT ONE becomes. So if you don't get it on the first few tries, try entering random text like:
Q: Are there any cyberbullying resources related to Google Search?
A: Check out Valerie Becker's contribution (apparently student created):
West Tisbury School's cyberbullying Google Search Movies:
Q: Is it possible to send an SMS and see it shown up as an event on Google Calendar?
A: Chris Craft suggested looking at the information displayed on this blog, Stephen's Space.
Q: Where can I find ideas on using Google Sites (wiki) to build professional portfolios?
A: Check out Googlios.com. Here are some other examples shared by GCTs:
Q: Where can I find Google Earth for Educator resources?
A: Find those online at their new site at http://sitescontent.google.com/google-earth-for-educators/
Q: How do I put an ADD TO CALENDAR button on a web page so that when someone clicks on it, the button action will add that event to that person's GoogleCalendar?
A: Danny Silva shared this web site:
Q: How do I upload folders full of content to GoogleDocs?
A: Take advantage of this free solution, elaborated on in this blog entry.
A: Youssef Elias writes back with this solution:
I've created a Google Form for teachers to use to submit requests for activities/events they propose to be added to our school master calendar. Is there an easy way the administrator can use the spreadsheet info to respond via e-mail as to whether the event is approved or not? And can the administrator mark the spreadsheet submission as approved or not by creating a new column or would that alter the original form?
A: Responses include: Aviary, Creately, MeetingMix and TimeBridge. Also, TheFlowr
Q: How do you find free GoogleBooks?
A: James Corey shares a response:
There really are over a million free ebooks. Sometimes the problem with finding these books is the the way you are searching for the public domain books. When you go to Google Books at (books.google.com) you need to check on advanced search. In the advanced search click the button that states "full-view only." Then type any letter in the title. Try the letter c. You will immediately see that over a million options appear, some of these options are magazines, but you can sort those out. For popular public domain books, you should try typing an author or title in the search bar. Try Romeo and Juliet -- A full-view version will appear.
Subscribe to Around the Corner-MGuhlin.org
Everything posted on Miguel Guhlin's blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure