Showing posts with label Vocabulary. Show all posts
Showing posts with label Vocabulary. Show all posts

Monday, April 8, 2013

Changing Question Order in New Google Forms


With new Google Forms a commonly asked for feature request has finally been granted. One of the biggest issues with the old version of Google Forms was the inability to change your question order on the associated spreadsheet after you initially create the form. But now...we can change the question order and update the spreadsheet question order. See the steps below to do this:

Background

With Google Forms you can create, collaboratively edit, and send your form to potential respondents.  When you create a Form, the responses are stored in the form itself by default.  If you would like to see the individual responses, you will need to choose a response destination for your form.

Old Forms behavior:

1. Create a Form
2. Organize question order (we will call it Question Order 1)
3. Click Save
4. Go look at Spreadsheet and columns will be in Question Order 1
5. Go back to Form editor and move around question order (we will call it Question Order 2)
6. Click Save
7. Go to Spreadsheet and the columns will still be in Question Order 1

New Forms behavior:

1. Create a Form
2. Organize Question Order 1
3. Google Magic automatically saves everything
4. Choose Spreadsheet as the Response Destination
5. Go to the Spreadsheet and you will see the Question Order 1
6. Go back to Form and change the question order
7. Go back to Spreadsheet, Question Order 1 is still the view
8. Unlink the Spreadsheet from the Form
9. Relink the Form to the existing (or new) Spreadsheet
10. The column order CHANGES to the Updated Question Order

If you have any questions, please ask them on the Google Forms category of the Google Docs Help forum.

Monday, October 22, 2012

New Terms for Google Docs

If you frequent the Docs forum or Drive forum you might have noticed a few new terms for describing Google Docs.  With the introduction of Drive it has been difficult or many users to figure out what exactly is going on and what exactly everybody is talking about. You might have also noticed that "Documents" in your upper black bar now says "Drive."  I hope my guide below can help with the rebranding!

Google Drive (or Drive)- This is the all encompassing term for cloud storage of files using Google's service.  You can use this term by saying things like "Hey, my computer died, but luckily I have everything saved in my Drive."  Drive also has various apps associated with it that allow you to collaborate in real-time. These files are in a Google format and must be edited in a browser.  Currently, only Docs (see below) allow for offline editing and offline editing is not supported on mobile.

Doc(s) - Formerly known as Documents.  This will be the most confusing term going forward as the term "Google Docs" use to encompass Documents, Spreadsheets, Presentations, and Drawings.  This now refers to the Google format for word processing.  Google Documents is now Google Docs.  A single Google Docs file is called a Google Doc.  You can use this term by saying something like "Hey, I'm sick of sending this Word file through email.  How about turning it into a Google Doc so we can collaborate in real time?" (In my mind, this is much better and how it should have been from the beginning.)

Sheet(s) - Formerly known as Spreadsheets.  A single Google Sheets file is called a Google Sheet.  Not to be confused with a tab in the Sheet.  You can use this term by saying something like "Hey, I want to use Google Sheets to plan our next vacation budget!"
   Other notes: There has traditionally been dissimilarities between Microsoft Excel and Google Sheets terms.  We will see how this goes but in the past the term "workbook" has generally been avoided.  In the Google Sheets world, the terms "tab" and "sheet" will be synonymous and while the term "Sheets" could be used in place of "workbook."   However, I am going to strongly advise that "workbook" be used to describe the collection of "tabs" or "sheets" in a single file (regardless of whether we are talking about Excel or Sheets).  The capitalization of Sheets will indicate the Drive app only and a lower-case "sheets" will refer to a "tab." A lower-cased "spreadsheet" is also synonymous with "sheets" and "tabs" but the upper-case "Spreadsheets" no longer exists and should not be used.  You might want to read that a few times.

Slide(s) - Formerly known as Presentations.  This one is an easy transition and can be used by saying something like "Hey, you know building this presentation would be much easier if we did this with Slides?"

Drawings - Drawings is still Drawings.

As you can see this will be a difficult transition but I hope we can all use the same terms when discussing Google Drive on the forums or anywhere else.

Please comment if you think anything is unclear and I can make some edits!

Note: These are just my conclusions from using Google Drive but I hope Google releases something soon explaining everything.  But for now...use this.

Cheers!

Sunday, July 17, 2011

Google Docs Vocabulary

When working with Google Docs it is important to use the correct terminology.  It will also help with understanding my blog and the help center. So here goes...

Google Docs - This is the term used in general for the suite of applications
Google Documents - the text editor from the Google Docs suite
Google Drawings - used to create drawings or diagrams for insertion into other Docs suites applications or publishing online
Google Spreadsheets - the spreadsheet editor from the Google Docs suite
Google Presentations - the presentation editor from the Google Docs suite
Sheet - a single spreadsheet/tab/worksheet
Spreadsheet - might be used interchangeably with workbook (note the difference between spreadsheet and sheet)

Often Sheet and Spreadsheet are used interchangeably as well.   I do my best to differentiate the two.

I try to use these terms on this blog and the help forum community also tends to identify with these terms.  You will often see questions by other TCs or power users asking to clarify so that we all understand how to help correctly.  If you are posting on the forums (especially for help with a Google Spreadsheet) it will help to be consistent with these terms.

Note: Be careful when using the terms "Google Doc" and "Google Document."  "Document" will always refer to the text editor while a "Google Doc" could be any of the four.  Most often you will hear, "Have you heard of Google Docs?"  This question is directed towards the whole Docs suite and not just a Google Document (text editor).

Have I confused you enough?

Cheers!

P.S. Thanks ahab for your comments!