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