Summary

Personalize learning with MyLab
By combining trusted author content with digital tools and a flexible platform, MyLab^™ personalizes the learning experience and improves results for each student.

You are purchasing an access card only. Before purchasing, check with your instructor to confirm the correct ISBN. Several versions of the MyLab^™ and Mastering^™ platforms exist for each title, and registrations are not transferable. To register for and use MyLab or Mastering, you may also need a Course ID, which your instructor will provide.

If purchasing or renting from companies other than Pearson, the access codes for the MyLab platform may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

Author Biography

Shelley Gaskin, Series Editor, is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor’s degree in business administration from Robert Morris College (Pennsylvania), a master’s degree in business from Northern Illinois University, and a doctorate in adult and community education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of customer education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sectors, and has also written and edited numerous computer application textbooks.

Debra Geoghan is a professor of computer science in the STEM department at Bucks County Community College, teaching computer classes ranging from basic computer literacy to cybercrime, computer forensics, and networking. She has certifications from Microsoft^®, CompTIA^®, and Apple^®. Deb has taught at the college level since 1996 and also spent 11 years in the high school classroom. She holds a BS in secondary science education from Temple University and an MA in computer science education from Arcadia University.

Throughout her teaching career, Deb has worked with educators to integrate technology across the curriculum. At BCCC she serves on many technology committees, presents technology workshops for BCCC faculty, and heads the computer science area. Deb is an avid user of technology, which has earned her the nickname “gadget lady.”

Alicia Vargas is a faculty member in business information technology at Pasadena City College. She holds a master’s and a bachelor’s degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word^™, Microsoft Excel^™, and Microsoft PowerPoint^™.

Nancy Graviett is a professor and department chair in business technology at St. Charles Community College in Cottleville, Missouri. She holds a bachelor’s degree in marketing and a master’s degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect^™, Google^®, Microsoft Outlook^™, and Microsoft Access^™.

1. Concepts: Computers and Information Processing
2. Concepts: Hardware
3. Concepts: System Software
4. Concepts: Networks, Security, and Privacy
5. Concepts: Troubleshooting and Maintenance
6. Concepts: Application Software
7. Concepts: The Internet
8. Concepts: Digital Ethics and Awareness
9. Applications: Cloud Computing
    Project 9A: Google Productivity
    Project 9B: Microsoft Cloud Computing and OneNote
    Project 9C: Using Professional Networks
10. Applications: Microsoft Office Features and Windows 10 File Management
    Project I0A: Chef Notes
    Project 10B: Hotel Files

MICROSOFT WORD 2019

11. Applications: Creating Documents with Microsoft Word
    Project 11A: Flyer
    Project 11B: Information Handout
12. Applications: Creating Cover Letters and Using Tables to Create Resumes
    Project 12A: Resume
    Project 12B: Cover Letter and Envelope
13. Applications: Creating Research Papers, Newsletters, and Merged Mailing Labels
    Project 13A: Research Paper
    Project 13B: Newsletter with Optional Mailing Labels

MICROSOFT EXCEL 2019

14. Applications: Creating a Worksheet and Charting Data
    Project 14A: Sales Report with Embedded Column Chart and Sparklines
    Project 14B: Inventory Valuation
15. Applications: Using Functions, Creating Tables, and Managing Large Workbooks
    Project 15A: Inventory Status Report
    Project 15B: Weekly Sales Summary
16. Applications: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
    Project 16A: Enterprise Fund Pie Chart
    Project 16B: Tourism Spending Projection with Line Chart

MICROSOFT ACCESS 2019

17. Applications: Getting Started with Microsoft Access 2019
    Project 17A: Advising Database with Two Tables
    Project 17B: Instructors and Courses Database
    Project 17C: Athletic Scholarships Database

MICROSOFT POWERPOINT 2019

18. Applications: Getting Started with Microsoft PowerPoint
    Project 18A: Company Overview Presentation
    Project 18B: Itinerary Presentation
    Project 18C: Employee Training Presentation

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.