22 GoogleApps Solutions from Google Certified Teachers' (GCT) List





Image Source
As a member of the Google Certified Teacher (GCT) email list, I'm continually astonished at the both the volume of email and the number of problems/solutions shared there. It really is like trying to take a sip from a firehose spouting water! These incredibly talented folks share their knowledge and insights continually, unafraid to jump in and respond to others. 


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):


  1. How do I use a GoogleDocs Form to create events in a Google Calendar?
  2. How do I make those Google Account creation CAPTCHA's less frustrating to complete?
  3. Are there any cyberbullying resources related to Google Search?
  4. Is it possible to send an SMS and see it shown up as an event on Google Calendar?
  5. My Android phone app gives me a view of my calendar that does not seem to allow me to turn off and on multiple calendars. It also doesn't seem to have the "more" so sometimes I'm missing events.
  6. Where can I find ideas on using Google Sites (wiki) to build professional portfolios?
  7. Where can I find Google Earth for Educator resources?
  8. 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?
  9.  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?
  10. Do you have any favorite third party apps that you've used in your GoogleApps for Education domain?
  11. How do you find free GoogleBooks?
  12. How can I stay logged into multiple Google accounts in one browser?
  13. How do I remove a site (of which I am not the author) from the list on "My Sites"? 
  14. How do you embed the "Show Summary" page from a Spreadsheet/Form?
  15. Does anyone have GoogleDocs Safety Videos?
  16. How do I migrate from MS Outlook to GoogleApps, including email, contacts, and calendar information?
  17. How do you migrate from Groupwise to GoogleApps?
  18. How do you create branching surveys, say, where students get a "new" branch of the survey depending on the choice they make?
  19. We have a google spreadsheet that we want each student in a class to fill out. However, we want them to do it separately and then collaborate on it later. Suggestions?
  20. We are implementing Google Apps for Education in grades 7-12 for staff and students (4000+ accounts). We are working on the AUP and are looking for advice/suggestions. Does anyone have a AUP that they would be willing to share?
  21. Is there any way that you can have a Google Doc in more than one folder?
  22. Does anyone know how many separate sheets you can have in a single spreadsheet?
    In preparing these questions and answers, I've taken a few liberties with the content, summarizing or editing as needed. I've also tried to cite the source for the solution. If you'd rather NOT have your name listed here, drop me a DM via Twitter or email me (mguhlin is the account name for both).


    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







    Here is a link to the spreadsheet:
    https://spreadsheets.google.com/ccc?key=0AqmO9_KUVK6odHZSLXpsNnhMQnhoTHQwZ25sM016V1E&hl=en&authkey=CPvTos0M
    Here is a link to the calendar:  http://goo.gl/GYau
    If you would like to view the script that does all the work, from the spreadsheet open the Script Editor (Tools->Scripts menu). All three of these documents (form, sheet, calendar) are not actually being used for anything, so feel free to play around with them.  Just be careful, there is a limit to how many events you can create this way in a day (although it appears to be around 500 or so). I hope people find this useful!  If you want direct sharing access to any of this stuff just send me your email and I'll add you.
    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:







    sdf[gplkj sdf;lkgj sdf;lgkjsh fd;lkajdf ;dlkjf da;lkjsadf
    into the CAPTCHA field and watch what happens. 9/10 times I've done this, the new CAPTCHA is easier - sometimes a LOT easier!

    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: 







    http://www.youtube.com/watch?v=R9TKQbo5Loc
    and
    http://www.youtube.com/watch?v=O6WLu29VRHY

    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: My Android phone app gives me a view of my calendar that does not seem to allow me to turn off and on multiple calendars. It also doesn't seem to have the "more" so sometimes I'm missing events.
    A: When in the calendar itself if you click on the options button then"  more" you should see calendars and be able to select them.


    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: 
    http://www.google.com/googlecalendar/event_publisher_guide.html


    Q: How do I upload folders full of content to GoogleDocs?
    A: Take advantage of this free solution, elaborated on in this blog entry.


    Q: I am having trouble getting Google Sites to accept a YouTube video larger than width="425" height="355".
    A: Use the "embed gadget" and then changed my video size in the properties from the embed code on youtube


    Q: 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: 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?


    Q:  Do you have any favorite third party apps that you've used in your GoogleApps for Education domain?
    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.    







    Another great feature is the ability to download the entire book into a pdf file for free.  I think the number one million is associated with the number of free downloads that are available.
    Q: How can I stay logged into multiple Google accounts in one browser?
    A: Kern Kelley shares this response:
    One trick to stay logged into multiple accounts in the same browser is use Google Chrome and open an incognito window. You can be logged into both and have the tabs next to each other. It's not perfect, but it works. :)
    Q: How do I remove a site (of which I am not the author) from the list on "My Sites"? 
    A: Cheryl Davis responds:
    Open the site you want to be removed from, scroll to the bottom of the site to the footer and click the Remove Access link.
    Q: How do you embed the "Show Summary" page from a Spreadsheet/Form?
    A: Dana Nguyen (Google) responds:







    Find out the URL and then just an iframe gadget to embed onto a Google Site...To find the URL/publish the page:








    Q: Does anyone have GoogleDocs Safety Videos?

    Q: How do I migrate from MS Outlook to GoogleApps, including email, contacts, and calendar information?

    Q: How do you migrate from Groupwise to GoogleApps?
    A: Harold Olejarz shares his school's journey online at http://sites.google.com/a/maine207.org/d207-google-apps-and-gmail/

    Q: How do you create branching surveys, say, where students get a "new" branch of the survey depending on the choice they make?
    A: Nic Finelli shares his response:
    If you need specific questions with each book, but still want one url - try creating the books as multiple choice and then when that book is selected it takes them to a new page where the specific question for that book is located.
    Chad Kafka elaborates, using books as the choices student makes. He also mentions a video to watch:
    When creating the form, you can make the "next question" answer specific based on the previous question.  I think that will accomplish what you want to do.  This video explains how to set something like this up:







    http://www.youtube.com/watch?v=XPmhK0YFk9g
    If the person chooses the FIRST BOOK, you can have that response then take the user to "page 2" where they would answer questions about that book specifically.  If the person were to choose SECOND BOOK, they would go to "page 3" where the questions are about THAT book.

    Q: We have a google spreadsheet that we want each student in a class to fill out. However, we want them to do it separately and then collaborate on it later. Suggestions?
    A: Sarah Rolle shares this response:
    What about a form for them to fill out? That way they would each think of their own answers. They would automatically end up in the same spreadsheet and after all the information is input the spreadsheet could be shared with the group and they could collaborate.
    Q: We are implementing Google Apps for Education in grades 7-12 for staff and students (4000+
    accounts). We are working on the AUP and are looking for advice/suggestions. Does anyone have a AUP that they would be willing to share?
    A: ScotG responds...
    Here is a link to our AUP's and we do issue gmail accounts to students in grades 5-12.
    http://www.salineschools.com/index.php/departments/itd/376-student-acceptable-use-policies


    Q: Is there any way that you can have a Google Doc in more than one folder?
    A: Kern Kelley responds:
    If you click on the checkbox beside the document then click the Folders button at the top and check off all the folders you want the document to be in. Then click the Apply Changes. :)
    Q:  Does anyone know how many separate sheets you can have in a single spreadsheet?
    A: "Please note: Each spreadsheet can be up to 256 columns, 200,000 cells, or 100 sheets, whichever is reached first, to be converted to Google Docs format. There's no limit on rows." Taken from this site:http://edutraining.googleapps.com/Training-Home/module-4-docs/chapter-4/2-1


    That's all for now!



    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

    Comments

    Scott S. Floyd said…
    You can always find great eportfolio information on Dr. Helen Barrett's site. http://electronicportfolios.org/

    She focuses on Google sites here - http://sites.google.com/site/eportfolios/
    Tammy Worcester said…
    Great info. Thanks for sharing. I would love to see Youssef Elias's solution to the forms/spreadsheet/feedback issue, but the "answer" is showing as a copy of the question.
    Angela Brill said…
    I too would like to know the answer for Youssef Elia's solution!

    Popular posts from this blog

    #Chromecast Add-Ons to Play Various Video File Formats

    Free Professional Learning! Education On Air #googleedu

    10 Steps to a Blended Learning Classroom #MIEexpert #MIE #tceamie1