Skip to content
CuraCourse
Log inGet started for free
Library
Cover of Workplace Software and Skills

Workplace Software and Skills

by Tammie Bolling, Angela Mitchell, Tanya Scott and Nyrobi Wheeler

Published by OpenStax

Computer ScienceBusinessCollege

Workplace Software and Skills is designed to flexibly support a range of courses covering computer literacy, Microsoft Office, and Google Suite applications. The textbook covers both hard and soft skills that are applicable to a broad range of academic majors and careers. Chapters combine studio learning and guided practice with scaffolded activities designed to reinforce a student’s ability to perform higher-order tasks independently. Workplace Software and Skills leverages complementary product features in spreadsheet, word processing, presentation, and similar applications. Modules are designed for maximum flexibility by including both Microsoft Office Suite and Google Suite applications, in order to best reflect the skills needed for today’s workforce. Authentic activities and real-world contexts develop a cumulative and thorough understanding, which reinforces the importance of cross-platform proficiency. Highly visible features also note Apple/Mac functions as needed.

Teach with this book. Sign up freeAlready have an account? Log in

Adopted pages stay linked to the book. Make your own copy of any page to change it for your class.

Attribution

Adapted from Workplace Software and Skills by Tammie Bolling, Angela Mitchell, Tanya Scott, and Nyrobi Wheeler, published by OpenStax (Rice University) under CC BY-NC-SA 4.0 (https://creativecommons.org/licenses/by-nc-sa/4.0/). Access the original for free at https://openstax.org/details/books/workplace-software-skills. Changes: converted to CuraCourse lessons, with interactive practice added.

Table of contents

120 pages in 16 modules. Sign up to read and adopt them.

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