Nelson Higher Education

Higher Education

CMPTR, 3rd Edition

  • includes CMPTR Online, 1 term (6 months) Printed Access Card
  • Katherine T. Pinard
  • Robin M. Romer
  • Deborah Morley
  • ISBN-10: 1305862872
  • ISBN-13: 9781305862876
  • 784 Pages | Paperback
  • Previous Editions: 2014, 2012
  • COPYRIGHT: 2017 Published
Request a Copy for Review


About the Product

CMPTR from 4LTR Press combines an easy-reference paperback text with Chapter Review Cards and an innovative online experience to introduce computer concepts and applications at an affordable price. New CMPTR ONLINE lets students explore CMPTR anywhere, anytime, and on any of their devices. Intuitive StudyBits™ help students study more effectively and visually monitor their progress, while course management, assessments, and analytics assist you, the instructor. The updated concepts chapters offer increased emphasis on mobile computing, as well as new and emerging technologies including wireless power, USB-C, modular smartphones, smart watches, Microsoft HoloLens, drones, two-factor authentication, 5G, Low Power Wi-Fi, LTE-U, the Internet of Things (IoT), and much more. In the application chapters, you’ll find revised chapters on Windows 10, Edge Web browser, and the latest updates in Microsoft® Office 2016. CMPTR ONLINE includes additional material and information on using the computer and Microsoft® 2016. Each applications chapter includes walk-through videos highlighting key skills for Word, Excel, Access, and PowerPoint. CMPTR with CMPTR ONLINE engages students of all generations and learning styles and integrates seamlessly into your Computer Concepts and Applications course.


  • CMPTR OFFERS ENGAGE ALL STYPS OF STUDENTS WITH PRINTED AND INTERACTIVE LEARNING TOOLS: Like every 4LTR Press solution, CMPTR comes complete with an engaging printed book, tear-out review cards, and an interactive digital solution that offers study tools and the full text narrative. All content and delivery was developed and guided by a deep understanding of today’s students’ workflow and learning styles. Available as the printed book with online, print only, or online-only solutions, students can choose the format best for their learning style, all at the same affordable price.

  • SHORTER, COMPREHENSIVE CHAPTERS ENGAGE STUDENTS WITH A MODERN DESIGN: Like all unique 4LTR Press books, CMPTR’s content is presented in an intriguing, rich visual, accessible format that increases the number of students who read the chapter, all without minimizing valuable coverage for your course.

  • TEAR-OUT REVIEW CARDS PROVIDE A PORTABLE STUDY TOOL: These helpful Review Cards, located at the back of the Student Editions, contain all of the pertinent information for class and test preparation. Quick Start Guide Cards provide your students and you, the instructor, with a quick reference to each of the four Microsoft® Office Applications. Infographics on the student cards visually recap each chapter’s content.


"I used all aspects of the 4LTR Press solutions. I found them very helpful study tools."
— Consuelo Seda, Student, Valencia Community College

About the Author

Katherine T. Pinard

Katherine T. Pinard has more than 25 years of experience writing and editing books about computer concepts, applications, and technology. She has co-authored or contributed to more than 20 successful books and has edited or managed more than 60 titles. She is MOS certified in Word and PowerPoint.

Robin M. Romer

Over the past 25 years, Robin M. Romer has focused on writing and editing books about computing, including computer applications, Web design and development, and service desks. In 2001, Robin sold her successful imprint, Acada Books, to return to her roots and concentrate on hands-on writing and editing. She has authored and contributed to more than 30 books and edited more than 50 titles.

Deborah Morley

Deborah Morley has authored more than ten popular computer textbooks, including UNDERSTANDING COMPUTERS: TODAY AND TOMORROW and UNDERSTANDING COMPUTERS IN A CHANGING SOCIETY. Professor Morley earned her B.S. and M.S. degrees in Business Information Systems from California State University, Fresno. Today, she offers more than ten years of experience teaching at the college level.

Table of Contents

Part I: Concepts.
1. Introduction to Computers and the Internet.
What is a Computer? Types of Computers. Computer Networks and the Internet. Computers and Society.
2. Computer Hardware.
Digital Data Representation. Inside the System Unit. How the CPU Works. Storage Systems. Input Devices. Output Devices.
3. Computer Software.
Introduction to System Software and Operating Systems. Operating Systems. Utility Programs. Introduction to Application Software. Application Software for Business. Application Software for Working with Multimedia. Other Types of Application Software.
Part II: Networks and The Internet.
4. Computer Networks.
What is a Network? Network Characteristics. Data Transmission. Network Media. Communications Protocols and Networking Standards. Networking Hardware.
5. The Internet and Email.
Evolution of the Internet. Connecting to the Internet. Searching the Internet. Email and Messaging. Beyond Browsing and Email.
6. Security and Privacy.
Understanding Security Concerns. Unauthorized Access and Unauthorized Use. Computer Sabotage. Online Theft, Online Fraud, and Other Dot Cons. Cyberstalking and Other Personal Safety Concerns. Personal Computer Security. Understanding Privacy Concerns. Security and Privacy Legislation.
Part III: Windows 10.
7. Exploring Windows 10 and Managing Files.
Using the Windows 10 Desktop. Working with Windows on the Desktop. Working with the Windows File System. Working with Files. Deleting Files and Working with the Recycle Bin. Closing Apps and Windows. Getting Help in Windows. Shutting Down Windows.
Part IV: Browser and Email.
8. Using Edge, Mail, and People.
Browsing the Web with Edge. Saving Links to Web Pages. Creating Web Notes. Printing Web Pages and Web Notes. Cleaning Up the Hub and Unpinning Web Pages. Exiting Edge. Using the Mail App. Adding Information to the People App.
Part V: Office 2016.
9. Introducing Microsoft Office 2016.
Exploring Common Elements of Office Application Windows. Using the Ribbon. Selecting Text and Using the Mini Toolbar. Undoing and Redoing. Zooming and Scrolling. Working with Office Files. Using the Clipboard. Getting Help. Exiting Office Applications.
Part VI: Word 2016.
10. Creating a Document.
Entering Text. Creating Documents Based on Existing Documents. Editing Text. Switching to Another Open Document in Word. Formatting Text. Formatting Paragraphs. Copying Formats. Checking Spelling and Grammar. Previewing and Printing Documents.
11. Formatting a Long Document.
Finding and Replacing Text. Working with Styles. Working with Themes. Scrolling Through a Long Document. Working with the Document Outline. Changing the Margins. Inserting a Manual Page Break. Adding Page Numbers, Headers, and Footers. Creating Citations and a List of Works Cited. Creating Footnotes and Endnotes.
12. Enhancing a Document.
Organizing Information in Tables. Changing the Page Orientation. Dividing a Document into Sections. Inserting and Modifying Graphics. Wrapping Text Around Graphics. Moving Graphics. Adding Text Effects and WordArt Text Boxes. Working with Columns. Working with Building Blocks.
Part VII: Excel 2016.
13. Creating a Workbook.
Understanding Spreadsheets and Excel. Entering and Formatting Data. Editing Cell Content. Working with Columns and Rows. Working with Cells and Ranges. Entering Simple Formulas and Functions. Previewing and Printing a Workbook.
14. Working with Formulas and Functions.
Using Relative, Absolute, and Mixed Cell References in Formulas. Entering Functions. Using AutoFill. Working with Date Functions. Working with the PMT Financial Function. Using References to Another Worksheet. Editing Formulas and Functions. Formatting Cells and Ranges.
15. Creating an Advanced Workbook.
Using Flash Fill. Entering Formulas with Multiple Calculations. Fixing Error Values. Working with the IF Logical Function. Creating a Nested IF Function. Adding Conditional Formatting. Hiding Rows and Columns. Formatting a Worksheet for Printing.
16. Inserting and Formatting Charts.
Creating a Chart. Moving and Resizing a Chart. Modifying a Chart. Creating an Exploded Pie Chart. Creating a Column or Bar Chart. Creating a Line Chart. Editing Chart Data. Inserting and Formatting Sparklines. Inserting and Modifying Data Bars.
Part VIII: Access 2016.
17. Creating a Database.
Understanding Database Concepts. Creating a Database. Using Datasheet View. Working with Fields and Properties in Design View. Modifying a Table’s Structure. Closing and Opening Objects and Databases. Creating Simple Queries, Forms, and Reports. Compacting and Repairing a Database.
18. Maintaining and Querying a Database.
Maintaining Database Records. Working with Queries in Design View. Sorting and Filtering Data. Defining Table Relationships. Creating a Multitable Query. Adding Criteria to a Query. Creating a Copy of a Query. Adding Multiple Criteria to Queries. Creating a Calculated Field. Using a Property Sheet. Using Functions in a Query.
19. Creating Forms and Reports.
Creating a Form Using the Form Wizard. Modifying a Form’s Design in Layout View. Finding Data Using a Form. Creating a Form Based on Related Tables. Previewing and Printing Selected Form Records. Creating a Report Using the Report Wizard. Modifying a Report’s Design in Layout View.
Part IX: PowerPoint 2016:
20. Creating a Presentation.
Creating a Presentation. Moving Text and Slides, and Deleting Slides. Adding Speaker Notes. Running a Slide Show. Adding Animations. Adding Transitions. Adding Footers and Headers. Reviewing, Previewing, and Printing a Presentation.
21. Enhancing a Presentation.
Working with Slide Masters. Inserting Graphics. Creating SmartArt Diagrams. Applying Animations to Graphics. Modifying Animation Timings. Adding Video. Compressing Pictures and Media. Saving a Presentation for Distribution.
Part X: Integration.
22. Integrating Word, Excel, Access, and PowerPoint.
Object Linking and Embedding. Importing and Exporting Data. Using the Object Command in Word, Excel, and PowerPoint. Copying and Pasting Among Office Programs. Creating PowerPoint Slides from a Word Outline. Creating Form Letters with Mail Merge.

New to this edition

  • NEW CMPTR ONLINE FROM 4LTR PRESS ENABLES STUDENTS TO STUDY HOW AND WHEN THEY WANT: Based on a deep investigation of students’ challenges and workflows in Computer Concepts and Applications, CMPTR ONLINE lets students study how and when they want on their devices. They find fun facts, tips and tricks provided through photos, animations, and step-by-step videos. With StudyBits, CMPTR ONLINE helps students connect to the content they need, and serves as a living manual for Windows 10 and MS Office 2016!
  • STUDYBITS™ CONNECT STUDENTS TO PERSONALIZED, EFFICIENT STUDY TOOLS: Students easily collect notes and create StudyBits™ from interactive content to collect what’s important. With intuitive tagging and filtering options, students can maximize their study efforts as they make and review flashcards, take practice quizzes, view related content and track their progress all in one place. This is coupled with straightforward course management, assessment tools, and analytics for you, the instructor.
  • CMPTR FEATURES THE LATEST UPDATES IN THE MICROSOFT® 2016 OFFICE SUITE: Revised chapters highlight Windows 10, Edge web browser, and Office 2016 applications. For quick reference, all Office 2013 applications chapters are still available through CMPTR ONLINE. CMPTR ONLINE also features fun facts, tips and tricks for using the computer and Microsoft® 2016 applications. Each applications chapter includes walk-through videos highlighting key skills for Word, Excel, Access, and PowerPoint®.


All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

CMPTR Online, 2 term (12 months) Instant Access  (ISBN-10: 1305864077 | ISBN-13: 9781305864078)

CMPTR ONLINE enables students to study how and when they want, including on their own devices. Based on a deep investigation of students’ challenges and workflows in Computer Concepts and Applications, CMPTR ONLINE lets students explore fun facts, tips and tricks provided through photos, animations, and step-by-step videos. Unique StudyBits™ offer interactive study help. CMPTR ONLINE encourages critical thinking and serves as a living manual for Windows 10 and MS Office 2016!

Instructor's Website  (ISBN-10: 1337103829 | ISBN-13: 9781337103824)

Find everything you need for your course in one place. This collection of book-specific lecture and class tools is available online via Access and download PowerPoint® presentations, images, instructor’s manual, and more.

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1305864085 | ISBN-13: 9781305864085)

Cengage Learning Testing, powered by Cognero®, is a flexible, online system that allows you to import, edit, and manipulate content from the text’s test bank. Create multiple test versions in an instant and deliver tests from your LMS or classroom. Every question has undergone a series of accuracy checks and anti-piracy reviews, as well as a multi-point inspection to remove weak question options,), sharpen ambiguous questions, and ensure balanced coverage of major course concepts, difficulty levels, and Bloom’s Taxonomy. The test questions are different from Practice Quizzes for students.

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

SAM trains and assesses essential Microsoft Office and computer concepts skills. Students engage in a hands-on simulated environment, then apply their skills live in the applications with real world scenarios. SAM’s auto-graded assignments and flexible reporting tools saves instructors time and energy.

Student Supplements

CMPTR Online, 2 term (12 months) Instant Access  (ISBN-10: 1305864077 | ISBN-13: 9781305864078)

CMPTR ONLINE lets you study anytime, anywhere, including on your own device. You collect notes and create StudyBits™ from interactive content to remember what’s most important. You can use preset study resources or personalize your review through easy-to-use tags and filters. Make flashcards, review related content, connect with classmates and track your progress with Concept Tracker. Add in assignments from your instructor and you have everything in one place. Photos, animations, and step-by-step videos offer fun facts and tips for learning MS Word, Excel, Access, and PowerPoint®.

SAM 365 & 2016 Assessment, Training, and Projects Instant Access with 1 MindTap Reader, (6 months) Instant Access  (ISBN-10: 133711393X | ISBN-13: 9781337113939)

This access code is available to you for as long as your institution uses SAM 365 & 2016. MindTap Reader access length is dependent upon how it was setup by your instructor. SAM – Skills Assessment Manager – is the top online training resource for Microsoft Office and computer concepts skills. With automatic feedback on assignments and personalized study guides, SAM helps you stay on track for improved grades. SAM has all your course content in one easy location. SAM training and assessments simulate the real Microsoft Office environment and SAM projects let you apply the skills live in the application using real-world scenarios, preparing you for more workplace success.