Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo
Workplace Software and Skills

3.8 Collaborative Editing and Reviewing in Google Docs

Workplace Software and Skills3.8 Collaborative Editing and Reviewing in Google Docs

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Learning Objectives

By the end of this section, you will be able to:

  • Use the Tools menu and collaboration functionality

Google Docs has many desirable features, but one of its biggest strengths as a word processing software program is its ability to facilitate collaboration among multiple users. People like to use Docs for the ease of sharing documents, tagging contacts, and inserting internet-enabled comments because these features make working together easy. Microsoft Office has these capabilities as well, but because Google is free to use, many people and small businesses prefer it. Nevertheless, many businesses use both because some features function better in one product, and other features function better in the other. Google’s collaboration features have been part of the apps from their inception. These features allow real-time edits to be seen by other users. In the early drafts of the market trends report, you will use Docs for collaboration, because many in your department are more familiar with the collaborative features in Docs.

In this section, you will take your market trends report and learn how to work on it with other employees at WorldCorp, getting them to insert and verify data that you need to complete your task.

Real-World Application

Recognizing Collaborators

The collaborative power of applications today is unparalleled. Internet capabilities have spurred new ways of working together and applications have incorporated these capabilities to provide collaborative features across a range of suites, including the two discussed in this textbook, Microsoft Office and Google Workspace. You can leverage not only the embedding capabilities across these suites, but you can also then create and modify these files and documents across individuals and teams.

While ease in this collaboration is well-established, less obvious is how to credit collaborators who are contributing to these files. Internet-enabled collaboration makes recognizing collaborators easier because user histories and versions can be tracked. Depending on the purpose of the document, you may or may not be listing its authors and contributors. It is important to follow your company’s established protocol when identifying and recognizing collaborators formally; regardless, one should always at a minimum recognize contributions informally. This may come in an email when presenting the file or verbally during a presentation.

Tools Menu and Collaborating

The Tools menu options include spelling and grammar, citations, the Explore command, tools for reviewing changes in Suggesting mode, and the dictionary. The Docs Tools menu contains some of the same tools that are found on the Review tab in Word. These are tools and commands to make your document professional and polished, as well as enable collaboration. These tools make collaboration between cowriters and coeditors possible, as everyone can review the suggestions and comments, tag others in the comments, and add citations and references.

Spelling and Grammar

Before sending or sharing any document in the workplace, you want to make sure it is as error-free as possible. You can do that by accessing the features of the Spelling and grammar command in the Tools menu. The dialog box shown in Figure 3.57 has the same functionality and overall feel as Word, and it operates in the same way, too, resolving each incident one-by-one.

The words “thelocated” are highlighted orange in a document. Editing mode is selected with options for: Spelling and grammar, and Change thelocated to: (a blue bubble displays with they located inside).
Figure 3.57 The spelling and grammar checking tool in Docs is similar to Word’s. Always check that the suggestion is correct before accepting it. (Google Docs is a trademark of Google LLC.)

As in Word, Docs offers users the option to add words to a Personal dictionary, so that they are not flagged as errors by the spell-checker tool. To access the Personal dictionary, go to the Tools tab and hover your cursor over the Spelling and grammar command. In the drop-down menu that appears, select Personal dictionary. You can manually add words to it from there.

Citations and Explore

Citations are what give credit to sources. Sources should receive credit for contributing to your report, but citations are also vital to avoid plagiarism. Citations appear in many different kinds of documents, from educational papers to business plans. As you learned in Navigating Google Docs, Google’s Explore command is an automated feature that is used in conjunction with citations. Word has a similar command called Smart Lookup, but it only allows you to search the internet, not get autogenerated citations.

Assume that you have a list of web pages that you used as the bibliography for your WorldCorp market trends report. Without automation, you would need to manually type in the website title, address, and date for each source you are citing, whether it is in a simple list at the bottom of the report, or as a footnote, or even in a separate document. With automation—that is, the Explore command—this task could become much less time-consuming.

As you are writing the report, you can cite the source, and have Docs do the formatting of the reference. You can cite the source either as a footnote or in the body of the text itself. Citing with footnotes is made easy with Docs. Just select a sentence or word and go to the Explore icon at the bottom of the page (Figure 3.58).

An Explore button is shown in the bottom of a computer screen.
Figure 3.58 The Explore button is a gateway to formatting references. (Google Docs is a trademark of Google LLC.)

A sidebar will appear, where you can once again search for the source in a Google Search (Figure 3.59). When you have found the referenced site again, just use the Google Search feature of citation formatting.

An Explore pane is open. The search bar lists: Sources: Laptops - United States. Below are three tabs – Web, Images, and Drive. The Web results list below.
Figure 3.59 The right side of the figure shows the references for the highlighted information. (Google Docs is a trademark of Google LLC.)

Then, click on Cite as footnote on the Google Search Explore sidebar (Figure 3.60).

An Explore pane is open with Sources: Laptops-United States in the search. In the top right corner of the first Web result a quotation mark is labeled Cite as footnote.
Figure 3.60 If you have a document that needs multiple sources formatted, the cite as footnote will be a handy tool. (Google Docs is a trademark of Google LLC.)

The Explore tool automatically adds the citation on a footnote, using the citing format of the manual of style of your choice (Figure 3.61).

A citation is shown at the bottom left of a document under a line and indicated with a small “1” that matches the information in the text of the document.
Figure 3.61 Using the Explore tool lets you add citations rapidly. (Google Docs is a trademark of Google LLC.)

Suggesting Mode

When you share the market trends report with your colleagues for their input, you need to make sure that everyone’s individual edits are captured in a clear way, similar to Track Changes in Word. The way to do this is through Suggesting mode, as the chapter on Essentials of Software Applications for Business introduced. To turn on Suggesting mode, go to the top right of the Docs window and look for the drop-down menu that says Editing. As you click on it, select Suggesting, as Figure 3.62 shows. In this mode, every time you add text, it will be surrounded with a bracket. If you delete something, the text will get a strikethrough. All of these changes will be accompanied by a comment box that shows a check or a cross. To accept the change, choose the check; to reject, choose the cross.

The key to making sure your colleagues can make these suggested changes in the first place is to make sure they know to turn on Suggesting mode when they begin working on the document. You can either inform your colleagues about this manually or share the document with them in Comment-only mode by selecting Commenter when you share the document with them.

(a) Suggesting mode is open with options for: Editing, Suggesting, Viewing. (b) Words highlighted in the document link to a comment box with image, name, time/date of comment, and the comment.
Figure 3.62 (a) Google’s version of Track Changes is called Suggesting mode. (b) When you make an edit to the document, you can also add comments to other users about the edit. (Google Docs is a trademark of Google LLC.)

Reviewing Suggested Edits

You may want to create a document outlining the processes and workflow of the changes to your document, particularly if there are multiple people working on it. You may want your report to be edited in a certain order, perhaps with differing levels of access to the document. Or, you might want several people to work on it at the same time. In the end, because you are the person in charge of producing the report, you will likely want to review the overall result, after all changes have been added by others, so that you can accept or reject all of the changes. This is where you will use the Tools menu’s Review suggested edits command. If the document is filled with suggestions, it might be hard to read, so this feature is highly recommended, as it simplifies the process of reviewing.

As Figure 3.63 shows, the drop-down box will display the options of Preview Accept All or Preview Reject All. This is like the Track Changes feature combo box that says All Markup and No Markup. If you Preview Accept All, you can see the document as if all the suggested edits were accepted. This will also make the document easier to read. If you are satisfied with the changes, then you can just select Accept All. In contrast, the Preview Reject All shows the original document before this version, without the current version’s changes, and it doesn’t show brackets or strikethroughs as well. This way, you can control whether the document is progressing properly or communicate with some collaborators if there is an issue with their additions or edits. Although this function is available, it is not advisable to simply accept or reject all suggested edits in the document. You should plan to review each suggested edit throughout the document and make the determination about the edits one by one. You can review the suggested edits individually by using the up and down arrows in the Review suggested edits tool in the Tools menu.

Editing is visible in a Google Doc. Suggested edits is selected (with Show suggested edits); forward and backward arrows are highlighted. At the right, Accept All and Reject All buttons are visible.
Figure 3.63 As you work in Suggesting mode, your changes are tracked and recorded. The font color changes for additions and strikethrough is used to show deletions. (Google Docs is a trademark of Google LLC.)
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.