Muutke küpsiste eelistusi

Go! All in One: Computer Concepts and Applications & Mylab It with Pearson Etext -- Access Card -- For Go! All in One Computer Concepts and Applications Package 2nd ed. [Multiple-component retail product]

(Pasadena City College), (Pasadena City College), , (University of Miami), (Eastern Michigan University), (Tidewater Community College),
  • Formaat: Multiple-component retail product, kõrgus x laius x paksus: 274x241x38 mm, kaal: 1637 g, Contains 1 Paperback / softback
  • Ilmumisaeg: 21-Jun-2014
  • Kirjastus: Pearson
  • ISBN-10: 0133933458
  • ISBN-13: 9780133933451
  • Multiple-component retail product
  • Hind: 205,49 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Multiple-component retail product, kõrgus x laius x paksus: 274x241x38 mm, kaal: 1637 g, Contains 1 Paperback / softback
  • Ilmumisaeg: 21-Jun-2014
  • Kirjastus: Pearson
  • ISBN-10: 0133933458
  • ISBN-13: 9780133933451

0133933458 / 9780133933451 Go! All in One: Computer Concepts and Applications & MyITLab with Pearson eText -- Access Card -- for GO! All In One Computer Concepts and Applications Package

Package consists of:

0133427293 / 9780133427295 Go! All in One: Computer Concepts and Applications

0133459837 / 9780133459838 MyITLab with Pearson eText -- Access Card -- for GO! All In One Computer Concepts and Applications

GO! Walkthrough xviii
Unit 1 Introduction to Computers, Windows 8.1, and Office 2013 Features
1(150)
Chapter 1 Computers and Information Processing
3(24)
Objective 1 Recognize Computers
4(3)
Concept 1.01 Understanding Embedded Computers and Convergence
4(2)
Concept 1.02 Exploring Smart Homes
6(1)
Objective 2 Explain the Functions of a Computer
7(1)
Concept 1.03 Understanding the Information Processing Cycle
7(1)
Objective 3 Describe How Computers Represent Data Using Binary Codes
8(1)
Concept 1.04 Understanding Binary Code
8(1)
Concept 1.05 Measuring Data
9(1)
Objective 4 Describe the Evolution of Computer Systems
9(2)
Concept 1.06 Reviewing a Brief History of Computers
9(2)
Objective 5 List the Various Types and Characteristics of Personal Computers
11(3)
Concept 1.07 Comparing Desktop Computers
12(1)
Concept 1.08 Comparing Portable Computers
12(1)
Concept 1.09 Choosing a Computer Platform: Mac or PC?
13(1)
Objective 6 Give Examples of Other Personal Computing Devices
14(4)
Concept 1.10 Looking at Smartphones and E-Readers
14(2)
Concept 1.11 Examining Other Devices
16(2)
Objective 7 List the Various Types and Characteristics of Multiuser Computers
18(2)
Concept 1.12 Understanding Servers and Mainframes
18(1)
Concept 1.13 Computing on a Large Scale
19(1)
Objective 8 Explain the Safe and Efficient Use of Technology
20(3)
Concept 1.14 Creating Healthy and Safe Workspaces
20(3)
Chapter Summary, GO! Learn It Online, and GO! for Job Success
23(1)
Glossary
24(2)
On the Web
26(1)
Ethics and Social Media
26(1)
Collaboration
26(1)
Chapter 2 Getting Started with Windows 8.1
27(68)
Project 2A Getting to Know Windows 8.1
28(1)
Objective 1 Use File Explorer and Desktop Apps to Create a New Folder and Save a File on a Removable Storage Device
29(14)
Activity 2.01 Understanding User Accounts in Windows 8.1
29(2)
Activity 2.02 Turning On Your Computer, Signing In to a Windows 8.1 User Account, and Exploring the Windows 8.1 Environment
31(4)
Activity 2.03 Pinning a Program to the Taskbar
35(1)
Activity 2.04 Creating a New Folder on a Removable Storage Device
36(3)
Activity 2.05 Creating and Saving a File
39(4)
Objective 2 Identify the Functions of the Windows 8.1 Operating System and the Windows Store Apps
43(2)
Activity 2.06 Identifying Operating System Functions and Windows Store App Functions
44(1)
Objective 3 Use Windows Store Apps
45(5)
Activity 2.07 Using Windows Store Apps
45(6)
Activity 2.08 Moving Between the Start Screen and Desktop and Saving a Windows Store App Screenshot as a File
51
Objective 4 Sign Out of Windows 8.1 and Turn Off Your Computer
50(2)
Activity 2.09 Locking, Signing Out of, and Shutting Down Your Computer
50(2)
Objective 5 Customize and Manage User Accounts
52(3)
Activity 2.10 Change How Your Desktop Displays on Startup and the Arrangement of Your Start Screen
52(3)
Project 2B Managing Files and Folders
55(1)
Objective 6 Use File Explorer to Display Locations, Folders, and Files
56(9)
Activity 2.11 Downloading Files from a Website
56(2)
Activity 2.12 Using File Explorer to Display Locations, Folders, and Files
58(6)
Activity 2.13 Using the Navigation Pane to Display the Folder Structure
64(1)
Objective 7 Start Programs and Open Data Files
65(5)
Activity 2.14 Starting Programs and Opening Data Files
65(5)
Objective 8 Personalize Your Windows 8.1 Start Screen
70(1)
Activity 2.15 Personalizing Your Windows 8.1 Start Screen
70(1)
Objective 9 Create, Rename, and Copy Files and Folders
71(5)
Activity 2.16 Copying Files from a Removable Storage Device to the Documents Folder on the Hard Disk Drive
71(1)
Activity 2.17 Creating and Renaming Folders
72(2)
Activity 2.18 Renaming Files
74(1)
Activity 2.19 Copying Files
74(2)
Objective 10 Move and Delete Files and Folders
76(4)
Activity 2.20 Moving Files
76(2)
Activity 2.21 Copying and Moving Files by Snapping Two Windows
78(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
80(1)
Review and Assessment Guide
81(1)
Glossary
82(4)
Skills Review
86(5)
Mastering
91(4)
Chapter 3 Introduction to Microsoft Office 2013 Features
95(56)
Project 3A Note Form
96(1)
Objective 1 Use File Explorer to Download, Extract, and Locate Files and Folders
97(2)
Activity 3.01 Using File Explorer to Download, Extract, and Locate Files and Folders
97(2)
Objective 2 Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App
99(3)
Activity 3.02 Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App
99(3)
Objective 3 Enter, Edit, and Check the Spelling of Text in an Office 2013 Program
102(3)
Activity 3.03 Entering and Editing Text in an Office 2013 Program
102(2)
Activity 3.04 Checking Spelling
104(1)
Objective 4 Perform Commands from a Dialog Box
105(3)
Activity 3.05 Performing Commands from a Dialog Box
105(2)
Activity 3.06 Using Undo
107(1)
Objective 5 Create a Folder and Name and Save a File
108(5)
Activity 3.07 Creating a Folder and Naming and Saving a File
109(4)
Objective 6 Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App
113(4)
Activity 3.08 Inserting a Footer, Inserting Document Info, and Adding Document Properties
113(2)
Activity 3.09 Printing a File and Closing a Desktop App
115(2)
Project 3B Memo
117(1)
Objective 7 Open an Existing File and Save It with a New Name
118(2)
Activity 3.10 Opening an Existing File and Saving It with a New Name
118(2)
Objective 8 Sign In to Office and Explore Options for a Microsoft Office Desktop App
120(1)
Activity 3.11 Signing In to Office and Viewing Application Options
120(1)
Objective 9 Perform Commands from the Ribbon and Quick Access Toolbar
121(7)
Activity 3.12 Performing Commands from the Ribbon and the Quick Access Toolbar
122(5)
Activity 3.13 Minimizing and Using the Keyboard to Control the Ribbon
127(1)
Objective 10 Apply Formatting in Office Programs
128(11)
Activity 3.14 Changing Page Orientation and Zoom Level
128(1)
Activity 3.15 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles
129(2)
Activity 3.16 Using Format Painter
131(2)
Activity 3.17 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste
133(6)
Objective 11 Compress Files and Use the Microsoft Office 2013 Help System
139(2)
Activity 3.18 Compressing Files
139(1)
Activity 3.19 Using the Microsoft Office 2013 Help System in Excel
140(1)
Objective 12 Install Apps for Office and Create a Microsoft Account
141(3)
Activity 3.20 Installing Apps for Office
141(1)
Activity 3.21 Creating a Microsoft Account
142(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
144(1)
Glossary
145(6)
Unit 1 Case Project: Tasks Performed by an Interior Designer Using Windows and Office 2013
149(2)
Unit 2 The Internet, Microsoft Cloud Computing, and OneNote
151(96)
Chapter 4 The Internet
153(38)
Objective 1 Recognize the Importance of the Internet
154(2)
Concept 4.01 Looking Back: How the Internet Got Started
154(1)
Concept 4.02 Examining the World Wide Web
155(1)
Objective 2 Compare Types of Internet Connections
156(3)
Concept 4.03 Establishing a Connection
156(3)
Objective 3 View Content on the Web
159(4)
Concept 4.04 Comparing Browsers
159(2)
Concept 4.05 Configuring a Web Browser
161(1)
Concept 4.06 Installing Add-Ons, Plug-Ins, and Toolbars
162(1)
Objective 4 Demonstrate How to Navigate the Web
163(3)
Concept 4.07 Using Web Addresses
163(2)
Concept 4.08 Searching the Web
165(1)
Objective 5 Discuss How to Evaluate the Credibility of Information Found on the Web
166(1)
Concept 4.09 Critically Evaluating Webpages
166(1)
Objective 6 Compare Different Forms of Synchronous Online Communication
167(3)
Concept 4.10 Using Chat and Instant Messaging
167(1)
Concept 4.11 Making Calls with Voice over IP
168(2)
Objective 7 Compare Different Forms of Asynchronous Online Communication
170(3)
Concept 4.12 Reading and Sending Email
170(2)
Concept 4.13 Using Forums and Discussion Boards
172(1)
Concept 4.14 Practicing Netiquette
173(1)
Objective 8 Discuss the Roles of Social Media in Today's Society
173(10)
Concept 4.15 Using Social Network Sites
174(1)
Concept 4.16 Exploring Virtual Worlds
175(1)
Concept 4.17 Sharing with Social Video, Image, and Music Sites
176(2)
Concept 4.18 Protecting Yourself Online
178(1)
Concept 4.19 Blogging and Microblogging
178(1)
Concept 4.20 Podcasting and RSS
179(1)
Concept 4.21 Using Wikis
180(1)
Concept 4.22 Sharing with Social Review, Bookmarking, and News Sites
181(2)
Objective 9 Recognize Different Types of E-commerce
183(3)
Concept 4.23 Comparing Types of E-commerce
183(1)
Concept 4.24 Shopping Online Safely
184(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
186(1)
Glossary
187(2)
On the Web
189(1)
Ethics and Social Media
189(1)
Collaboration
189(2)
Chapter 5 Using Internet Explorer, Microsoft Cloud Computing, and OneNote
191(56)
Project 5A Internet Explorer
192(1)
Objective 1 Navigate with Internet Explorer 11
193(5)
Activity 5.01 Navigating with Internet Explorer 11
193(5)
Objective 2 Navigate with Tabs
198(2)
Activity 5.02 Navigating with Tabs
198(2)
Objective 3 Search the Internet
200(2)
Activity 5.03 Searching the Internet
201(1)
Objective 4 Use Internet Explorer 11 in the Desktop
202(3)
Activity 5.04 Using Tabbed Browsing with Internet Explorer 11 in the Desktop
202(3)
Objective 5 Organize Favorites
205(3)
Activity 5.05 Organizing Favorites and Creating a Favorites Folder
205(1)
Activity 5.06 Using the Favorites Bar
206(2)
Project 5B Cloud Computing and OneNote
208(1)
Objective 6 Send and Receive Email
209(5)
Activity 5.07 Using Outlook.com
209(2)
Activity 5.08 Sending and Receiving Email Using Outlook.com
211(3)
Objective 7 Communicate Using Skype
214(4)
Activity 5.09 Adding Contacts in Skype
214(2)
Activity 5.10 Instant Messaging with Skype
216(1)
Activity 5.11 Participating in a Skype Call
217(1)
Objective 8 Use OneDrive
218(5)
Activity 5.12 Creating Folders and Storing Documents on OneDrive
218(2)
Activity 5.13 Saving a Document to OneDrive
220(1)
Activity 5.14 Sharing Files by Using Email
221(2)
Objective 9 Use OneNote to Create a Notebook
223(9)
Activity 5.15 Creating a Notebook
223(2)
Activity 5.16 Creating Sections and Pages in a Notebook
225(2)
Activity 5.17 Inserting and Formatting Content
227(2)
Activity 5.18 Inserting a Table
229(1)
Activity 5.19 Inserting Objects
229(3)
Chapter Summary, GO! Learn It Online
232(1)
Review and Assessment Guide
233(1)
Glossary
234(2)
Mastering
236(11)
Unit 2 Case Project: A OneNote Notebook Created by a Director of Sales for Oro Jade Hotel Group
243(4)
Unit 3 Computer Hardware and Microsoft Word
247(138)
Chapter 6 Hardware
249(30)
Objective 1 Explain the Function of the Central Processing Unit
250(3)
Concept 6.01 Examining the Central Processing Unit
250(1)
Concept 6.02 Improving CPU Performance
251(2)
Objective 2 Identify the Parts of a System Unit and Motherboard
253(4)
Concept 6.03 Exploring the Motherboard
254(1)
Concept 6.04 Comparing Ports and Connectors
255(1)
Concept 6.05 Looking at the BIOS
256(1)
Concept 6.06 Comparing Types of Memory
256(1)
Objective 3 Describe Important Input Devices and Their Uses
257(6)
Concept 6.07 Identifying Keyboards
257(1)
Concept 6.08 Using a Mouse and Other Pointing Devices
258(1)
Concept 6.09 Exploring Digital Cameras and Webcams
259(1)
Concept 6.10 Scanning Information
260(1)
Concept 6.11 Using Microphones and Game Controllers
261(1)
Concept 6.12 Recognizing Adaptive Input Devices
262(1)
Objective 4 Describe Important Output Devices and Their Uses
263(3)
Concept 6.13 Comparing Video Output Devices
263(2)
Concept 6.14 Exploring Audio Output Devices
265(1)
Concept 6.15 Recognizing Adaptive Output Devices
265(1)
Objective 5 Compare the Features of Various Printer Types
266(2)
Concept 6.16 Selecting a Printer
267(1)
Objective 6 Discuss Important Communication Devices
268(1)
Concept 6.17 Understanding Network Adapters and Modems
268(1)
Concept 6.18 Understanding Fax Devices
269(1)
Objective 7 Compare Storage Devices
269(5)
Concept 6.19 Comparing Optical Discs
269(1)
Concept 6.20 Examining Solid-State Storage
270(2)
Concept 6.21 Understanding Hard Drives
272(1)
Concept 6.22 Choosing Energy Star--Rated Devices
272(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
274(1)
Review and Assessment Guide
275(1)
Glossary
276(2)
On the Web
278(1)
Ethics and Social Media
278(1)
Collaboration
278(1)
Chapter 7 Creating Documents with Microsoft Word 2013
279(58)
Project 7A Newsletter
280(1)
Objective 1 Create a New Document and Insert Text
281(1)
Activity 7.01 Starting a New Word Document and Inserting Text
281(1)
Objective 2 Change Document and Paragraph Layout
282(5)
Activity 7.02 Formatting Multiple Columns
283(1)
Activity 7.03 Setting Margins
284(1)
Activity 7.04 Aligning Text
285(1)
Activity 7.05 Changing Space After Paragraphs
286(1)
Objective 3 Format Text
287(4)
Activity 7.06 Formatting Text
287(2)
Activity 7.07 Managing Hyperlinks
289(2)
Objective 4 Set Tab Stops
291(1)
Activity 7.08 Setting Tab Stops
291(1)
Objective 5 Insert and Format Graphics
292(4)
Activity 7.09 Inserting and Resizing Pictures
292(1)
Activity 7.10 Wrapping Text Around a Picture
293(1)
Activity 7.11 Moving a Picture
294(1)
Activity 7.12 Applying Picture Styles and Artistic Effects
294(1)
Activity 7.13 Adding a Page Border
295(1)
Objective 6 Insert and Modify Text Boxes and Shapes
296(2)
Activity 7.14 Inserting a Shape with Text
296(1)
Activity 7.15 Inserting a Text Box
297(1)
Activity 7.16 Resizing and Formatting Shapes and Text Boxes
297(1)
Objective 7 Insert and Format a SmartArt Graphic
298(2)
Activity 7.17 Inserting a SmartArt Graphic
298(1)
Activity 7.18 Modifying a SmartArt Graphic
299(1)
Objective 8 Preview and Print a Document
300(4)
Activity 7.19 Adding a File Name to the Footer
300(1)
Activity 7.20 Previewing and Printing a Document
301(3)
Project 7B Research Paper
304(1)
Objective 9 Create a Research Paper
305(3)
Activity 7.21 Formatting Text and Page Numbers in a Research Paper
305(2)
Activity 7.22 Changing Line Spacing
307(1)
Objective 10 Proofread and Correct a Document
308(4)
Activity 7.23 Checking Spelling and Grammar Errors
308(1)
Activity 7.24 Using the Thesaurus
309(1)
Activity 7.25 Finding and Replacing Text
310(2)
Objective 11 Insert Footnotes in a Research Paper
312(2)
Activity 7.26 Inserting Footnotes
312(1)
Activity 7.27 Modifying a Footnote Style
313(1)
Objective 12 Create Citations and a Bibliography in a Research Paper
314(10)
Activity 7.28 Adding Citations
314(3)
Activity 7.29 Inserting Page Breaks
317(1)
Activity 7.30 Creating a Reference Page
317(7)
Chapter Summary, GO! Learn It Online, GO! for Job Success
324(1)
Review and Assessment Guide
325(1)
Glossary
326(2)
Mastering
328(9)
Chapter 8 Using Word to Create Resumes and Cover Letters
337(48)
Project 8A Resume
338(1)
Objective 1 Create a Table
339(1)
Activity 8.01 Creating a Table
339(1)
Objective 2 Add Text to a Table
340(5)
Activity 8.02 Adding Text to a Table
340(1)
Activity 8.03 Copying Existing Text into a Table Cell
341(2)
Activity 8.04 Creating and Formatting a Bulleted List
343(2)
Objective 3 Format a Table
345(6)
Activity 8.05 Changing the Width of Table Columns
345(1)
Activity 8.06 Adding Rows to a Table
346(1)
Activity 8.07 Merging Cells and Setting Tabs in a Table
347(1)
Activity 8.08 Formatting Text in Cells
348(1)
Activity 8.09 Changing the Table Borders
349(2)
Objective 4 Save a Document as PDF
351(5)
Activity 8.10 Saving a Resume as PDF
352(4)
Project 8B Cover Letter and References
356(1)
Objective 5 Create a Building Block
357(2)
Activity 8.11 Creating a Letterhead Building Block
357(2)
Activity 8.12 Inserting a Building Block from the Building Blocks Organizer
359(1)
Objective 6 Create a Cover Letter
359(3)
Activity 8.13 Recording AutoCorrect Entries
360(1)
Activity 8.14 Creating a Cover Letter
360(2)
Objective 7 Reorganize Text
362(3)
Activity 8.15 Selecting and Moving Text to a New Location
362(1)
Activity 8.16 Converting Text to a Table
363(2)
Objective 8 Create a Document By Using a Template
365(7)
Activity 8.17 Locating and Opening a Template
365(1)
Activity 8.18 Replacing Template Placeholder Text and Removing Controls
366(6)
Chapter Summary, GO! Learn It Online, GO! for Job Success
372(1)
Review and Assessment Guide
373(1)
Glossary
374(1)
Mastering
375(10)
Unit 3 Case Project: Documents Created by a Marketing Manager for Oro Jade Hotel Group
381(4)
Unit 4 System Software and Microsoft Excel
385(154)
Chapter 9 System Software
387(34)
Objective 1 Understand the Purpose and Functions of Operating Systems
388(7)
Concept 9.01 Providing the User Interface
389(2)
Concept 9.02 Managing System Resources
391(2)
Concept 9.03 Managing and Controlling Hardware
393(2)
Concept 9.04 Interacting with Software
395(1)
Objective 2 Use Desktop Operating Systems
395(4)
Concept 9.05 Exploring Windows
395(1)
Concept 9.06 Examining Mac OS
396(2)
Concept 9.07 Comparing Unix and Linux
398(1)
Objective 3 Compare Specialized Operating Systems
399(2)
Concept 9.08 Identifying Embedded Operating Systems
399(1)
Concept 9.09 Exploring Network Operating Systems
400(1)
Objective 4 Use System Utilities
401(4)
Concept 9.10 Using Disk Utilities
401(4)
Concept 9.11 Using Antivirus Software
405(1)
Objective 5 Compare Methods for Backing Up a System
405(2)
Concept 9.12 Backing Up with Windows and OS X
406(1)
Concept 9.13 Using Drive Imaging and System Restore
407(1)
Concept 9.14 Backing Up to the Cloud
407(1)
Objective 6 Understand the Importance of File Management
407(4)
Concept 9.15 Navigating a Windows Computer
407(1)
Concept 9.16 Examining Mac OS X Finder and Folders
408(1)
Concept 9.17 Understanding Mobile Devices and File Storage
409(1)
Concept 9.18 Creating and Using Folders
409(1)
Concept 9.19 Storing Files in the Cloud
410(1)
Objective 7 Recognize and Work with File Types
411(5)
Concept 9.20 Understanding File Names and Extensions
411(1)
Concept 9.21 File Properties
411(2)
Concept 9.22 Compressing Files
413(3)
Chapter Summary, GO! Learn It Online, GO! for Job Success
416(1)
Glossary
417(2)
On the Web
419(1)
Ethics and Social Media
419(1)
Collaboration
419(2)
Chapter 10 Creating Worksheets with Column Charts Using Microsoft Excel 2013
421(60)
Project 10A Sales Report with Embedded Chart and Sparklines
422(1)
Objective 1 Create, Save, and Navigate an Excel Workbook
423(3)
Activity 10.01 Starting Excel and Naming and Saving a Workbook
423(1)
Activity 10.02 Navigating a Worksheet and a Workbook
424(2)
Objective 2 Enter Data in a Worksheet
426(5)
Activity 10.03 Entering Text and Using AutoComplete
426(1)
Activity 10.04 Using Auto Fill and Keyboard Shortcuts
427(1)
Activity 10.05 Aligning Text and Adjusting the Size of Columns
428(2)
Activity 10.06 Entering Numbers
430(1)
Objective 3 Construct and Copy Formulas and Use the SUM Function
431(3)
Activity 10.07 Constructing a Formula and Using the SUM Function
431(2)
Activity 10.08 Copying a Formula By Using the Fill Handle
433(1)
Objective 4 Format Cells with Merge & Center and Cell Styles
434(3)
Activity 10.09 Using Merge & Center and Applying Cell Styles
434(1)
Activity 10.10 Formatting Financial Numbers
435(2)
Objective 5 Chart Data to Create a Column Chart and Insert Sparklines
437(5)
Activity 10.11 Charting Data By Using Recommended Charts
437(1)
Activity 10.12 Modifying and Formatting a Chart
438(3)
Activity 10.13 Creating and Formatting Sparklines
441(1)
Objective 6 Print, Display Formulas, and Close Excel
442(6)
Activity 10.14 Creating a Footer, Centering a Worksheet, and Using Print Preview
442(2)
Activity 10.15 Printing a Worksheet
444(1)
Activity 10.16 Changing Page Orientation and Displaying, Printing, and Hiding Formulas
444(4)
Project 10B Inventory Valuation with Quick Analysis
448(1)
Objective 7 Check Spelling in a Worksheet
449(1)
Activity 10.17 Checking Spelling in a Worksheet
449(1)
Objective 8 Construct Formulas for Mathematical Operations
450(5)
Activity 10.18 Using Arithmetic Operators
451(1)
Activity 10.19 Using the Quick Analysis Tool
451(2)
Activity 10.20 Copying Formulas Containing Absolute Cell References
453(2)
Objective 9 Edit and Format a Worksheet
455(13)
Activity 10.21 Editing Values in a Worksheet
455(1)
Activity 10.22 Formatting Cells with the Percent Style
456(1)
Activity 10.23 Inserting and Deleting Rows and Columns
457(2)
Activity 10.24 Formatting Cells As a Date
459(1)
Activity 10.25 Adjusting Column Widths and Wrapping Text
459(2)
Activity 10.26 Clearing Cell Contents and Formats and Using the Format Painter
461(7)
Chapter Summary, GO! Learn It Online, GO! for Job Success
468(1)
Review and Assessment Guide
469(1)
Glossary
470(2)
Mastering
472(9)
Chapter 11 Creating Tables and Inserting Functions and Charts
481(58)
Project 11A Inventory Status Report
482(1)
Objective 1 Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
483(4)
Activity 11.01 Using the SUM and AVERAGE Functions
483(2)
Activity 11.02 Using the MEDIAN Function
485(1)
Activity 11.03 Using the MIN and MAX Functions
486(1)
Objective 2 Move Data, Resolve Error Messages, and Rotate Text
487(2)
Activity 11.04 Moving Data and Resolving a ##### Error Message
487(1)
Activity 11.05 Rotating Text
488(1)
Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting
489(4)
Activity 11.06 Using the COUNTIF Function
489(1)
Activity 11.07 Using the IF Function
490(1)
Activity 11.08 Applying Conditional Formatting by Using Highlight Cell Rules and Data Bars
491(1)
Activity 11.09 Using Find and Replace
492(1)
Objective 4 Use Date & Time Functions and Freeze Panes
493(2)
Activity 11.10 Using the NOW Function to Display a System Date
493(1)
Activity 11.11 Freezing and Unfreezing Panes
494(1)
Objective 5 Create, Sort, and Filter an Excel Table
495(3)
Activity 11.12 Creating an Excel Table
495(1)
Activity 11.13 Sorting and Filtering an Excel Table
496(1)
Activity 11.14 Converting a Table to a Range of Data
497(1)
Objective 6 Format and Print a Large Worksheet
498(5)
Activity 11.15 Changing Orientation, Printing Titles, and Scaling to Fit
498(5)
Project 11B Restaurant Sales
503(1)
Objective 7 Create and Format a Pie Chart
504(7)
Activity 11.16 Creating a Pie Chart and a Chart Sheet
504(2)
Activity 11.17 Updating Data Labels and the Chart Title in a Pie Chart
506(2)
Activity 11.18 Formatting a Pie Chart with 3-D
508(1)
Activity 11.19 Rotating a Pie Chart
509(1)
Activity 11.20 Exploding and Coloring a Pie Slice
509(1)
Activity 11.21 Formatting the Chart Area
510(1)
Objective 8 Create and Format a Line Chart
511(5)
Activity 11.22 Creating a Line Chart
512(1)
Activity 11.23 Formatting Axes and Lines in a Line Chart
513(1)
Activity 11.24 Formatting the Chart and Plot Areas
514(2)
Objective 9 Edit a Workbook and Update Charts
516(1)
Activity 11.25 Editing a Workbook and Updating Charts
516(1)
Objective 10 Rename Worksheets
516(2)
Activity 11.26 Modifying Worksheet Tabs and Moving Worksheets
517(1)
Objective 11 Format and Print a Workbook with Multiple Worksheets
518(6)
Activity 11.27 Formatting Multiple Worksheets in a Workbook
518(1)
Activity 11.28 Printing All the Worksheets in a Workbook
519(5)
Chapter Summary, GO! Learn It Online, GO! for Job Success
524(1)
Review and Assessment Guide
525(1)
Glossary
526(2)
Mastering
528(11)
Unit 4 Case Project: Excel Workbooks Created by a Day Spa Manager
535(4)
Unit 5 Networks, Security and Privacy, Microsoft PowerPoint, and Microsoft Access
539(176)
Chapter 12 Networks, Security, and Privacy
541(38)
Objective 1 Discuss the Importance of Computer Networks
542(3)
Concept 12.1 Using Peer-To-Peer Networks
542(2)
Concept 12.2 Using Client-Server Networks
544(1)
Objective 2 Compare Different Types of LANs and WANs
545(4)
Concept 12.3 Comparing Small Networks
545(2)
Concept 12.4 Recognizing LAN Topologies
547(1)
Concept 12.5 Examining Large Networks
547(2)
Objective 3 List and Describe the Hardware Used in Both Wired and Wireless Networks
549(3)
Concept 12.6 Understanding Network Adapters
549(2)
Concept 12.7 Recognizing Network Hardware
551(1)
Objective 4 List and Describe the Software and Protocols Used in Both Wired and Wireless Networks
552(5)
Concept 12.8 Using Peer-To-Peer Network Software
553(1)
Concept 12.9 Using Client-Server Network Software
554(1)
Concept 12.10 Understanding Network Protocols
555(2)
Objective 5 Explain How to Protect a Network
557(1)
Concept 12.11 Setting Up Firewalls and Securing Access
557(1)
Concept 12.12 Keeping Software Up to Date
557(1)
Objective 6 Recognize Various Types of Cybercrime
558(4)
Concept 12.13 Recognizing Personal Cybercrime
558(2)
Concept 12.14 Protecting Yourself from Identity Theft
560(1)
Concept 12.15 Detecting Cybercrime Against Organizations
560(2)
Objective 7 Differentiate Between Types of Malware
562(4)
Concept 12.16 Avoiding Spam and Cookies
562(1)
Concept 12.17 Preventing Adware and Spyware
563(1)
Concept 12.18 Protecting Against Viruses, Worms, Trojans, and Rootkits
564(2)
Objective 8 Explain How to Secure a Computer
566(3)
Concept 12.19 Securing a System with Software
566(2)
Concept 12.20 Securing a System with Hardware
568(1)
Objective 9 Discuss Safe Computing Practices
569(6)
Concept 12.21 Setting Up and Securing User Accounts
570(2)
Concept 12.22 Encrypting Information
572(1)
Concept 12.23 Implementing Acceptable Use Policies
573(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
575(1)
Glossary
576(2)
On the Web
578(1)
Ethics and Social Media
578(1)
Collaboration
578(1)
Chapter 13 Creating and Editing Presentations with Microsoft PowerPoint 2013
579(54)
Project 13A Tour Overview
580(1)
Objective 1 Create a New Presentation
581(3)
Activity 13.01 Identifying Parts of the PowerPoint Window
581(1)
Activity 13.02 Entering Presentation Text and Saving a Presentation
582(1)
Activity 13.03 Applying a Presentation Theme and Variant
583(1)
Objective 2 Edit a Presentation in Normal View
584(5)
Activity 13.04 Inserting New Slides
584(2)
Activity 13.05 Increasing and Decreasing List Levels
586(1)
Activity 13.06 Removing a Bullet Symbol from a Bullet Point
587(1)
Activity 13.07 Adding Speaker's Notes to a Presentation
587(1)
Activity 13.08 Displaying and Editing Slides in the Slide Pane
588(1)
Objective 3 Add Images to a Presentation
589(5)
Activity 13.09 Inserting Online Pictures
589(2)
Activity 13.10 Inserting Pictures
591(1)
Activity 13.11 Moving and Sizing Images
592(1)
Activity 13.12 Applying Artistic Effects and Styles to an Image
593(1)
Objective 4 View and Print a Presentation
594(7)
Activity 13.13 Applying Slide Transitions to a Presentation
594(2)
Activity 13.14 Viewing a Slide Show
596(1)
Activity 13.15 Inserting Headers and Footers
596(1)
Activity 13.16 Printing a Presentation
597(4)
Project 13B Fitness Center
601(1)
Objective 5 Edit an Existing Presentation
602(4)
Activity 13.17 Displaying and Editing the Presentation Outline
602(1)
Activity 13.18 Finding and Replacing Text
603(1)
Activity 13.19 Changing a Bulleted List to a Numbered List
604(1)
Activity 13.20 Modifying a Bulleted List Style
604(2)
Objective 6 Format a Presentation
606(2)
Activity 13.21 Changing Fonts, Font Sizes, Font Styles, and Font Colors
606(1)
Activity 13.22 Aligning Text and Changing Line Spacing
607(1)
Activity 13.23 Modifying Slide Layout
607(1)
Objective 7 Insert and Format Objects
608(5)
Activity 13.24 Inserting a Text Box
608(1)
Activity 13.25 Inserting, Sizing, and Positioning Shapes
609(1)
Activity 13.26 Adding Text to Shapes
610(1)
Activity 13.27 Applying Shape Fills, Outlines, and Styles
610(1)
Activity 13.28 Applying Shape and Picture Effects
611(1)
Activity 13.29 Animating an Object
612(1)
Activity 13.30 Inserting a WordArt Object
612(1)
Objective 8 Create and Format a Smart Art Graphic
613(3)
Activity 13.31 Creating a SmartArt Graphic from a Bulleted List
613(1)
Activity 13.32 Adding Shapes in a SmartArt Graphic
614(1)
Activity 13.33 Creating a SmartArt Graphic By Using a Content Layout
615(1)
Activity 13.34 Changing the Color and Style of a SmartArt Graphic
616(1)
Objective 9 Use Slide Sorter View and Presenter View
616(8)
Activity 13.35 Deleting and Moving Slides in Slide Sorter View
616(2)
Activity 13.36 Using Presenter View
618(6)
Chapter Summary, GO! Learn It Online, GO! for Job Success
624(1)
Review and Assessment Guide
625(1)
Glossary
626(1)
Mastering
627(6)
Chapter 14 Creating an Access Database and Running Queries
633(82)
Project 14A A Contact Information Database with Two Tables
634(1)
Objective 1 Identify Good Database Design
635(1)
Activity 14.01 Using Good Design Techniques to Plan a Database
635(1)
Objective 2 Create a Table and Define Fields in a New Database
636(10)
Activity 14.02 Starting with a New Database
636(2)
Activity 14.03 Assigning the Data Type and Name to Fields
638(2)
Activity 14.04 Renaming Fields and Changing Data Types in a Table
640(1)
Activity 14.05 Adding a Record to a Table
641(1)
Activity 14.06 Adding Records to a Table
642(1)
Activity 14.07 Importing Data from an Excel Workbook into an Existing Access Table
643(3)
Objective 3 Change the Structure of Tables and Add a Second Table
646(9)
Activity 14.08 Deleting a Table Field in Design View
646(1)
Activity 14.09 Modifying a Field Size and Adding a Description
647(1)
Activity 14.10 Viewing a Primary Key in Design View
648(1)
Activity 14.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet
649(2)
Activity 14.12 Adjusting Column Widths
651(1)
Activity 14.13 Printing a Table
652(3)
Objective 4 Create Table Relationships
655(5)
Activity 14.14 Creating Table Relationships and Enforcing Referential Integrity
655(4)
Activity 14.15 Printing a Relationship Report and Displaying Subdatasheet Records
659(1)
Objective 5 Create and Use a Query, Form, and Report
660(6)
Activity 14.16 Using the Simple Query Wizard to Create a Query
660(2)
Activity 14.17 Creating and Printing a Form
662(2)
Activity 14.18 Creating, Modifying, and Printing a Report
664(2)
Objective 6 Save and Close a Database
666(4)
Activity 14.19 Closing and Saving a Database
666(4)
Project 14B Mackinac Guest Rooms
670(1)
Objective 7 Create a Query in Design View
671(3)
Activity 14.20 Creating a New Select Query in Design View
671(2)
Activity 14.21 Running, Saving, Printing, and Closing a Query
673(1)
Objective 8 Create a New Query from an Existing Query
674(3)
Activity 14.22 Creating a New Query from an Existing Query
674(2)
Activity 14.23 Sorting Query Results
676(1)
Objective 9 Specify Criteria in a Query
677(5)
Activity 14.24 Specifying Text Criteria in a Query
677(1)
Activity 14.25 Specifying Criteria By Using a Field Not Displayed in the Query Results
678(1)
Activity 14.26 Using Is Null Criteria to Find Empty Fields
679(1)
Activity 14.27 Creating a Query Based on More Than One Table
680(2)
Objective 10 Specify Numeric Criteria in a Query
682(2)
Activity 14.28 Specifying Numeric Criteria in a Query
682(1)
Activity 14.29 Using Comparison Operators
683(1)
Objective 11 Use Compound Criteria in a Query
684(1)
Activity 14.30 Using AND Criteria in a Query
684(1)
Activity 14.31 Using OR Criteria in a Query
685(1)
Objective 12 Use Calculated Fields, Statistics, and Grouping in a Query
685(5)
Activity 14.32 Using Calculated Fields in a Query
686(2)
Activity 14.33 Using the AVG and SUM Functions in a Query
688(2)
Activity 14.34 Grouping Data in a Query
690(1)
Objective 13 Create a Report Based on a Query Using a Wizard
690(8)
Activity 14.35 Using a Wizard to Create a Report Based on a Query
690(8)
Chapter Summary, GO! Learn It Online, GO! for Job Success
698(1)
Review and Assessment Guide
699(1)
Glossary
700(2)
Mastering
702(13)
Unit 5 Case Project: PowerPoint Presentation and Database Created by a Sales Operations Manager for Oro Jade Hotel Group
711(4)
Unit 6 Application Software and Cloud Computing with Google
715
Chapter 15 Application Software
717(34)
Objective 1 Identify Types and Uses of Business Productivity Software
718(4)
Concept 15.01 Comparing Office Suites
718(3)
Concept 15.02 Identifying Other Types of Business Software
721(1)
Objective 2 Categorize Home and Educational Programs
722(5)
Concept 15.03 Using Office Applications
723(1)
Concept 15.04 Comparing Finance and Tax Preparation Software
723(1)
Concept 15.05 Selecting Educational and Reference Software
724(1)
Concept 15.06 Playing and Learning with Games
725(1)
Concept 15.07 Using Portable Apps
726(1)
Objective 3 Identify Media and Graphic Software
727(8)
Concept 15.08 Clarifying Compression and Decompression
727(1)
Concept 15.09 Designing with Desktop Publishing
727(1)
Concept 15.10 Using Graphic Programs
728(3)
Concept 15.11 Simplifying Three-Dimensional Rendering Programs
731(1)
Concept 15.12 Creating Animations
731(1)
Concept 15.13 Using Audio Editing and Speech Recognition Software
732(1)
Concept 15.14 Using Video Editing Programs
732(1)
Concept 15.15 Reviewing Webpage Authoring Programs
733(1)
Concept 15.16 Using Media Management Software
734(1)
Objective 4 Assess a Computer System for Software Compatibility
735(1)
Concept 15.17 Determining System Requirements
735(1)
Concept 15.18 Reviewing System Requirements
736(1)
Objective 5 Compare Various Ways of Obtaining Software
736(3)
Concept 15.19 Purchasing: Is It Free or Fee?
736(1)
Concept 15.20 Locating Sources of Software
737(2)
Objective 6 Respect Software Licenses and Registration Agreements
739(1)
Concept 15.21 Reviewing Licenses and Registration
739(1)
Objective 7 Discuss the Importance of Cloud Computing
740(2)
Concept 15.22 Cloud Computing
740(2)
Objective 8 Install, Uninstall, and Update Software
742(5)
Concept 15.23 Installing Software
742(1)
Concept 15.23 Updating and Uninstalling Software
743(4)
Chapter Summary, GO! Learn It Online, GO! with Job Success
747(1)
Glossary
748(2)
On the Web
750(1)
Ethics and Social Media
750(1)
Collaboration
750(1)
Chapter 16 Cloud Computing Online with Google
751
Project 16A Google Productivity
752(1)
Objective 1 Store Files Online in Google Docs
753(5)
Activity 16.01 Converting an Excel Worksheet to a Google Docs Spreadsheet
753(3)
Activity 16.02 Editing a File in Google Sheets
756(2)
Objective 2 Use Google Docs to Create and Edit a Word Processing Document
758(2)
Activity 16.03 Creating a New Document in Google Docs
758(1)
Activity 16.04 Entering Text and Inserting Blank Lines
759(1)
Objective 3 Share Documents By Using Google Docs
760(2)
Activity 16.05 Sharing a Document
760(2)
Objective 4 Manage a Calendar
762(5)
Activity 16.06 Creating a Calendar
762(3)
Activity 16.07 Sharing a Calendar
765(2)
Project 16B Working Online
767(1)
Objective 5 Create a Blog
768(6)
Activity 16.08 Creating a Blog
768(3)
Activity 16.09 Customizing Your Blog
771(1)
Activity 16.10 Posting to a Blog
772(2)
Objective 6 Create a Profile on Google+
774(5)
Activity 16.11 Creating a Google+Profile
774(3)
Activity 16.12 Adding People in Google+
777(1)
Activity 16.13 Sharing What's New in Google+
778(1)
Activity 16.14 Participating in a Google+Hangout
778(1)
Objective 7 Create a Website
779(3)
Activity 16.15 Creating a Website By Using Google Sites
780(2)
Chapter Summary, GO! Learn It Online, GO! for Job Success
782(1)
Review and Assessment Guide
783(1)
Glossary
784(1)
Mastering
785
Unit 6 Case Project: A Google Doc, Blog, and Webpage Created by a Director of IT for a Hotel
791
Glossary 1(1)
Index 1