GoogleFest OK 2016 - Presentations and Questions

As promised, here is the article with both of my presentations from GoogleFest OK 2016.  This event was a huge success and was an afternoon full of information and fun.  Plus it was free - Thanks to the Google Data Center in Pryor, OK and the TulsaTech Owasso Campus.



There were two tracks during the conference, so the first of the two slide shows is a Google basics treatment called Getting Started with Google Apps for Education.  The second is a quick look at Google Apps tips for advanced users, called Go! Go! Google - 25 Tips in 30 Minutes.  

Questions from the audience are posted at the end of this article, along with my answers.  Thanks to all who were in attendance!







Questions:

• Can you take your google docs with you if you leave the school district?
• Yes, you can! With graduating seniors, we help them migrate their portfolio of work from their GAFE account to a free Gmail account so they can take it with them to college. Go to https://takeout.google.com/settings/takeout to download a ZIP file of all information you'd like to migrate from your old Drive account. Then decompress your ZIP file and upload the contents to your new Drive account.

• Can you translate into Cherokee? What about other native american languages?
• No. At this time you cannot. Here is the full list of languages that you can translate to:
• https://translate.google.com/about/intl/en_ALL/languages/

• How were the animations created for your presentation? Gifs?
• For my presentations I used SnagIt, which is a software that allows you to create screenshots and animated GIFs. It was available as a Chrome extension, which was created by TechSmith. While they are no longer supporting this extension in the Chrome Webstore, you can purchase the software from their website here - https://www.techsmith.com/.
• I also use Camtasia by Techsmith, which allows you to create professional quality videos.

• How does the new Google Form quizzes handle fill in the blank questions? Does it mark it for review?
• At this time, you cannot assign a correct answer or points to a short answer question. As a result, it also does not allow you to mark them. This would mean that you would need to average the score manually.
• You could use an AddOn such as Flubaroo to handle this, as it does allow you to adjust the grade after scoring short answer questions.
• Flubaroo - https://goo.gl/DralHr
• Tutorial - http://goo.gl/JXQmS8

• When docs are translated in different languages, does it change the sentence structure -- like if it changes to English to Spanish, does it put the nouns and verbs in the appropriate places?
• Yes it does. However, with any translation tool, you will want to educate students to be wary of using them to cheat in a foreign language class, as they sometimes do make mistakes. But from what I have seen and hear, foreign students have been pleased with what Google Translate does in Google Docs.

• Is the document identifier in another location (like settings) in addition to being part of the web address? Is that identifier a GUID?
• It is not located anywhere else. It is located only in the address line, as you can see in this sample address for the presentation above:
• https://docs.google.com/presentation/d/1avF9htF0nf7DcPesIPvmUscVOBk99vCMz2vkatSFi9o/edit?usp=sharing
• The ID for this doc is highlighted in red.


• GUID (Globally Unique Identifier) are typically used by Microsoft, and some other entities, for Java, C++, and programming uses.


• The string of characters in the address for a Google Doc is not a GUID.

• I need more information on linking sheets
• Here you go... http://www.techycoach.com/2016/02/google-sheets-import-data-from-one.html

• Is google nav in doc like verbatim? https://paperlessdebate.com
• If you are speaking of the navigation pane you can use with Google Docs (Tools>Document Outline), no. It is strictly a tool to navigate through a document using the headings of your doc.
• If you are speaking of the Research Tools in Docs and Slides, check out this tutorial to see how it compares when researching and formatting your document (https://youtu.be/spe9WoQQBJo?list=PLWs92wbpe-2ZhdIDbo9yAuGwhD2ooWGif)

• I would like to have a Google Form that is evergreen and can be updated by the student and will overwrite fields in the sheet based on log in ID of the Student. Is it possible???
• Google Forms are strictly used to gather information in a way similar to what you would find in Poll Everywhere or Survey Monkey.
• They are evergreen in the sense that they can be continually updated and utilized far into the future.
• If you have created the form, the student cannot edit it, unless you add them as a collaborator.
• It will not automatically allow you to overwrite existing fields based on Login, but you can make this happen using a script. Try this link to see how - https://productforums.google.com/forum/#!topic/docs/GJIihaVGrJQ

• Can you import a drawing that you have already created into a Google Doc?
• There are two ways to handle this.
• You can simply open the Google Drawing, Click File>Download As and save the drawing as an image (JPG, PNG), and then insert into your document.
• Or, follow these instructions from the Google Docs Editors Help page
1. Sign in to Drive at drive.google.com.
2. Open a drawing.
3. Click the Edit menu.
4. Hover over “Web clipboard” and select Copy entire drawing to web clipboard.
5. Open the Google Doc or Slide where you want to insert the drawing.
6. Click the Edit menu > Hover over “Web clipboard” > Click the drawing name.
7. A copy of your drawing has been added to the file.

• How can I share a contact in gmail?
• To my knowledge, there is no simple way to do this in a free Gmail account, due to privacy settings in Gmail and Contacts. All information I have read is that you are only able to do this in the same domain.
• In a GAFE Gmail Account you can share your entire contact list:
1. Click on the dropdown menu in the upper left, next to the words Gmail.
2. Choose Contacts
3. Place a check next the contact you would like to share.
4. Click the More button at the top.
5. Click Manage Delegation Settings
6. Add email addresses with whom you'd like to share your contacts list.
• This is probably not the answer you were looking for, as I assume you wish to only share ONE contact, as in the form of a vCard. Unfortunately, there is no easy way to do this.

• How can I convert information from a spreadsheet back into doc format without having to copy and paste every cell?
• The best solution to this issue is to use the Google Sheets AddOn, Save As Doc.
• This will allow you to convert a Google Sheet to a Google Doc.

• How did you create this page for Q&A?
• The Q&A Feature is now a full feature of Google Slides. Watch this tutorial to see how it works
• http://www.techycoach.com/2016/05/now-taking-questions-presenter-view-for.html