Home Tags Posts tagged with "Add-ons"
Tag:

Add-ons

Google Tips and Tricks

The Power of Add-Ons: Save as Doc

by Diana Benner
written by Diana Benner

Eliminating the number of decisions you have to make increases your energy level, asserts the author of The Power of Engagement. You can accomplish this in a easy way with a Google Sheets add-on. Consider this scenario. You setup a Google Form and send it out to everyone you  know. When you are looking at the responses, you realize, “Wow, I don’t want to reformat this Sheet of Form Responses for readability.” You want to avoid countless energy-sapping decisions as you try to wrap content in Sheet cells, move data around, read tiny text on a crowded screen. A wonderful Google Sheets add-on makes it easy to read through the responses submitted via a Google Form and saved in a Google Sheet.

The Power of Less Decisions

We all know that reading long paragraph field entries is a nightmare in a spreadsheet. But, good news! The add-on Save as Doc is the cherry on top when it comes to finding a solution for your Google Forms content.

power

Save as Google Doc Core Features

  • Choose any name for the generated document.
  • Select any number of adjacent cells to output.
  • Choose any heading style for column headings.
  • Add a pagebreak after each row of data.
  • Save the current settings as the default.
  • Generates a Google Document in your Google Drive.

How to Use This Google Add-on

  1. Download the add-on.
  2. Within Google Sheets, click on Add-ons.
  3. Choose “Save As Doc > Start.”
  4. Select the cells, rows, or columns to include or choose “Select all data.”
  5. Type a Save Doc File name.
  6. Modify the output settings in the sidebar.
  7. Choose “Save as Doc.”
  8. At the bottom, click on the blue Open the Doc.

The Google Three-Step

You’ve heard of the Texas two-step? Now you have the Google three-step:

  1. Use Google Forms to enter the information.
  2. The responses are compiled in Google Sheets.
  3. Use the Save as doc add-on to turn your information back into a Google Doc.

Watch this video walk through by Free Tech4Teachers blogger Richard Byrne:

More Favorites Coming Soon

Want to power through more tough tasks in Docs, Sheets, and Form with add-ons? I’ll be sharing some more of my favorites in upcoming blogs. And, if you’re a TCEA member, check out our list of recommended Chrome apps and extensions. They’re divided by category and then subject, making them easy to search through to find exactly what you need.

0 comment
0 FacebookTwitterPinterestLinkedinEmail
Google Tips and Tricks

Doing More with Google Forms

by Diana Benner
written by Diana Benner

During a recent Get Your Google On webinar, Jennifer Bergland, Director of Governmental Relations at TCEA, shared ways in which you can move beyond just the basics and do more with Google Forms. One of those ways included the use of add-ons.

If you aren’t familiar with add-ons, they are small programs built by third-party developers that can be installed to bring more functionality to your forms. Form add-ons allow you to add extra features to your forms, get customized notifications, turn your form entries into documents, and much more.

Finding Add-Ons

finding-and-opening-form-add-onsTo find Form add-ons, click on the More button (which looks like three little dots in the upper right-hand corner of your form) and then scroll to Add-Ons. You can browse through the add-ons and install the ones you want. You’ll then get a new puzzle piece icon in Google Forms, with a menu that lists each of your add-ons.

Most Google Forms add-ons run in a popover on the right side of your form, and they may also include an options pane that opens in the center. To open an add-on, just select it in the add-ons menu, which looks like a puzzle piece. To manage or remove add-ons, just open the Add-ons pane again under the More button, find the add-on you want to remove, click the green Manage button, and then select Remove in its menu.

Useful Google Forms Add-Ons

Below is a list of some useful add-ons to get started with.

Choice Eliminator 2 – This add-on eliminates options from multiple-choice, list, or checkbox questions if they’ve already been selected. It’s a great way to make a signup form.

CheckItOut – This add-on lets you check in or out items with a form. When the items get checked out, the items move to a section of the form titled Check In. When they return the item, they can check it back in, which moves it to the Check Out category.

Form Notifications – This add-on sends custom email notifications to you and, optionally, to form respondents, with details about the form results, as well as a thank you message.

formLimiter – This add-on limits how many times your form can be answered. It can watch for a number of responses, a date and time, or a set value in your results spreadsheet, and then will disable your form once that number is reached.

formRecycler – This add-on lets you recycle questions from other Forms in your Drive. Just pick the Form in the popup window and it will populate with the questions from that Form. Select the ones you want to insert and the formRecycler will automatically insert them at the end of the Form.

As you can see, Google Form add-ons can save you a lot of time, as well as make your forms more functional. The next time you create a Google Form, give some of these add-ons a try, and don’t forget to tune in to our Get Your Google On webinars. They are held the first Thursday of every month and are free to TCEA members. Register here.

0 comment
1 FacebookTwitterPinterestLinkedinEmail
Chrome
Google Tips and Tricks

Chrome Add-Ons: Accent Marks and More

by Miguel Guhlin
written by Miguel Guhlin

Did you know that the Texas TEKS (§128.14. Spanish Language Arts and Reading, Grade 3) require students to learn all about adding accent marks to words in Spanish? Here are some of the expectations for students:

Write with increased accuracy using accent marks, including:

(i) Words that have a prosodic or orthographic accent on the last syllable (palabras agudas) (e.g., feliz, canción); and

(ii) Words that have a prosodic or orthographic accent on the second-to-last syllable (palabras graves) (e.g., casa, árbol);

Yet once you figure out the rules for adding accent marks, how do you do it on a device like a Chromebook? In the old days, on a Windows computer, you could type a special alt-code combination to get the accent mark. On Macs, you can use the key combination Option-e then press the letter that needs the accent mark. On a Chromebook, you can use the Google Input Tools Chrome add-on to get the job done!

Accent

Once the add-on is installed in your Chrome browser, follow these instructions (read more at Typing Spanish Characters and Accent Marks):

Using the Spanish keyboard (Spanish Keyboard Icon)
The Spanish keyboard is almost the same as an English keyboard, except with a few additional shortcuts:

  • To type an accented character, type an apostrophe (‘) followed by the letter. For example, to get á, type (‘) and then (a).
  • To type ñ, tap the semicolon (;) key.
  • To type ¡, tap the equal sign (=) key.
  • To type ¿, hold down shift and tap the equal sign (=) key.

You can also click the corresponding key on the virtual keyboard that appears.

Watch this video that walks you through the process.

 

0 comment
0 FacebookTwitterPinterestLinkedinEmail
Tasty looking banana split
Google Tips and Tricks

The Cherry on Top? Google Add-Ons

by Peggy Reimers
written by Peggy Reimers

If GAFE (Google Apps for Education) was a banana split, then Google Forms is the whipped cream on top. Forms is the best way to create a poll, survey, or quiz, or collect information. But sometimes the data that collects in the Google Sheet is hard to read and decipher AND you need the data saved back in the Google Form layout. For that, you need a powerful add-on.

We all know that reading long paragraph field entries are a nightmare in the spreadsheet. But good news! The add-on, Save as Doc, is the cherry on top when it comes to finding a solution for your Google Forms content.

Save as Google Doc Core Features

  • Choose any name for the generated document.
  • Select any number of adjacent cells to output.
  • Choose any heading style for column headings.
  • Add a pagebreak after each row of data.
  • Save the current settings as the default.
  • Generates a Google Document in your Google Drive.

How to Use This Google Add-on

  1. Download the add-on
  2. Within Google Sheets, click on Add-ons
  3. Choose “Save As Doc > Start”
  4.  Select the cells, rows, or columns to include or choose “Select all data”
  5. Type a Save Doc File name
  6. Modify the output settings in the sidebar
  7. Choose “Save as Doc”
  8. At the bottom, click on the blue Open the Doc

You’ve heard of the Texas two-step? Now you have the Google three-step:

  1. Use Google Forms to enter the information.
  2. The responses are compiled in Google Sheets.
  3. Use the add-on to turn your information back into a Google Doc.


Want to top off Docs, Sheets, and Form with more cherry-on-top add-ons? I’ll be sharing some more of my favorites in upcoming blogs. And, if you’re a TCEA member, check out our list of recommended Chrome apps and extensions. They’re divided by category and then subject, making them easy to search through.

Feature Image: Mirsa in Pixabay

0 comment
0 FacebookTwitterPinterestLinkedinEmail
Newer Posts
Older Posts