| Introduction |
|
xxi | |
| Assessment Test |
|
xliii | |
| Part I Computing Fundamentals |
|
1 | (160) |
|
Chapter 1 Understanding Operating Systems |
|
|
3 | (52) |
|
Operating Systems and Their Roles When Using Computers and Devices |
|
|
5 | (12) |
|
|
|
5 | (1) |
|
|
|
6 | (1) |
|
What Is an Operating System? |
|
|
6 | (1) |
|
How Do They All Work Together? |
|
|
7 | (2) |
|
Accessing and Locking the Operating System |
|
|
9 | (3) |
|
Software and System Updates |
|
|
12 | (5) |
|
Working with Files, Folders, and Libraries |
|
|
17 | (15) |
|
Accessing Your Files and Folders |
|
|
18 | (4) |
|
|
|
22 | (2) |
|
Managing Your Files and Folders |
|
|
24 | (8) |
|
Customizing Your Computer |
|
|
32 | (19) |
|
|
|
32 | (13) |
|
Understanding User Accounts |
|
|
45 | (6) |
|
|
|
51 | (1) |
|
|
|
52 | (1) |
|
|
|
52 | (1) |
|
|
|
53 | (2) |
|
Chapter 2 Understanding Hardware |
|
|
55 | (22) |
|
The Internal Hardware Components of a Computer |
|
|
57 | (2) |
|
Peripheral Devices That Can Be Connected to a Computer |
|
|
59 | (3) |
|
The Most Common Types of Computers and Devices |
|
|
62 | (3) |
|
How Information Is Transmitted inside a Computer |
|
|
65 | (1) |
|
How to Evaluate the Performance of a Computer or Device |
|
|
66 | (5) |
|
|
|
71 | (1) |
|
|
|
72 | (1) |
|
|
|
72 | (2) |
|
|
|
74 | (3) |
|
Chapter 3 Understanding Software |
|
|
77 | (38) |
|
The Dependencies between Hardware and Software |
|
|
79 | (2) |
|
Installing, Removing, or Reinstalling Software |
|
|
81 | (10) |
|
Software Licensing and Its Implications |
|
|
91 | (5) |
|
The Most Common Types of Office Applications |
|
|
96 | (2) |
|
Using Templates to Get Started with an Application |
|
|
98 | (3) |
|
Personal Entertainment Applications |
|
|
101 | (1) |
|
Compressing Files to Save Space |
|
|
101 | (2) |
|
Optimizing Your Computer's Hard Disk Performance |
|
|
103 | (5) |
|
Protecting Yourself from Malware |
|
|
108 | (1) |
|
|
|
109 | (1) |
|
|
|
110 | (1) |
|
|
|
111 | (1) |
|
|
|
112 | (3) |
|
Chapter 4 Troubleshooting Problems with Your Computer |
|
|
115 | (46) |
|
Dealing with Problems Caused by Software |
|
|
117 | (15) |
|
Dealing with Incompatibilities between the Operating System Version and Your Applications |
|
|
118 | (3) |
|
Dealing with Unresponsive Applications |
|
|
121 | (3) |
|
Dealing with Applications That Consume Too Many Resources |
|
|
124 | (2) |
|
Dealing with Malware Infections |
|
|
126 | (3) |
|
Using Safe Mode to Fix Problems with Windows |
|
|
129 | (2) |
|
|
|
131 | (1) |
|
Dealing with Problems Caused by Hardware |
|
|
132 | (8) |
|
Dealing with Problems Caused by Cables and Connectors |
|
|
132 | (1) |
|
Upgrading the Firmware for Your Computer's Components and Peripherals |
|
|
133 | (2) |
|
Dealing with Drivers for Your Computer's Hardware |
|
|
135 | (5) |
|
Creating Your Own Backup System |
|
|
140 | (16) |
|
Backing Up Your Data with Backup and Restore |
|
|
140 | (5) |
|
Restoring Your Data with Backup and Restore |
|
|
145 | (5) |
|
Backing Up Your Data to the Cloud with OneDrive |
|
|
150 | (6) |
|
|
|
156 | (1) |
|
|
|
156 | (1) |
|
|
|
157 | (1) |
|
|
|
158 | (3) |
| Part II Key Applications |
|
161 | (244) |
|
Chapter 5 Exploring Common Application Features in Microsoft Office |
|
|
163 | (74) |
|
Creating New Empty Documents with Microsoft Office |
|
|
166 | (14) |
|
Starting and Closing Microsoft Office Applications |
|
|
167 | (1) |
|
Opening and Closing Microsoft Office Files |
|
|
168 | (1) |
|
Creating New Empty Files with Microsoft Office |
|
|
169 | (2) |
|
Saving Your Microsoft Office Files |
|
|
171 | (4) |
|
Working with Several Windows at the Same Time |
|
|
175 | (5) |
|
The Basics of Using Microsoft Office Applications |
|
|
180 | (37) |
|
Keyboard Shortcuts for Using the Ribbon Productively |
|
|
180 | (4) |
|
Selecting, Copying, and Moving Data When Using Microsoft Office Applications |
|
|
184 | (9) |
|
Dragging and Dropping Data When Using Microsoft Office Applications |
|
|
193 | (1) |
|
Finding and Replacing Data in Your Microsoft Office Documents |
|
|
194 | (3) |
|
Checking the Spelling of Your Microsoft Office Documents |
|
|
197 | (3) |
|
Undoing Your Changes and Mistakes When Working with Microsoft Office Documents |
|
|
200 | (1) |
|
Hiding Your Data from Tables and Charts |
|
|
201 | (2) |
|
Selecting Non-adjacent Cells in Microsoft Excel Tables |
|
|
203 | (2) |
|
Sorting Data When Working with Microsoft Excel Files |
|
|
205 | (2) |
|
Adjusting the Way You View Microsoft Office Files |
|
|
207 | (4) |
|
Adjusting the Size and the Orientation of Your Microsoft Office Files |
|
|
211 | (2) |
|
Printing Your Documents from Microsoft Office |
|
|
213 | (1) |
|
Where to Get Help with Using Microsoft Office |
|
|
214 | (3) |
|
The Basics of Formatting Your Microsoft Office Files |
|
|
217 | (7) |
|
Formatting the Text in Your Documents |
|
|
217 | (3) |
|
Using Styles to Format Your Documents |
|
|
220 | (4) |
|
Working with Multimedia Files in Microsoft Office |
|
|
224 | (7) |
|
Adding Multimedia Files to Your Presentations |
|
|
224 | (4) |
|
Adjusting the Pictures Used in Your Presentations |
|
|
228 | (3) |
|
|
|
231 | (1) |
|
|
|
232 | (1) |
|
|
|
233 | (1) |
|
|
|
234 | (3) |
|
Chapter 6 Using Microsoft Word |
|
|
237 | (40) |
|
Configuring the Layout of Your Documents |
|
|
238 | (20) |
|
Adjusting Line and Paragraph Spacing in Your Documents |
|
|
238 | (3) |
|
Aligning the Text in Your Documents |
|
|
241 | (4) |
|
Organizing Your Documents into Columns |
|
|
245 | (1) |
|
Setting the Margins of Your Documents |
|
|
246 | (3) |
|
Displaying the Ruler When Editing Documents |
|
|
249 | (1) |
|
Indenting the Text in Your Documents |
|
|
250 | (4) |
|
Using Tabs to Control Where the Text Is Placed in Your Documents |
|
|
254 | (4) |
|
Organizing the Data in Your Documents |
|
|
258 | (15) |
|
Creating Bulleted and Numbered Lists |
|
|
259 | (1) |
|
Sorting Single-Level Lists |
|
|
260 | (2) |
|
|
|
262 | (3) |
|
Adding or Removing Rows and Columns in Your Tables |
|
|
265 | (1) |
|
Merging and Splitting Cells in Your Tables |
|
|
266 | (3) |
|
Adding Page Numbers to Your Documents |
|
|
269 | (4) |
|
|
|
273 | (1) |
|
|
|
273 | (1) |
|
|
|
273 | (1) |
|
|
|
274 | (3) |
|
Chapter 7 Using Microsoft Excel |
|
|
277 | (48) |
|
Navigating among Worksheets, Workbooks, and Cells |
|
|
278 | (6) |
|
Navigating between Worksheets |
|
|
279 | (1) |
|
|
|
280 | (4) |
|
Changing the Alignment and the Positioning of Cells |
|
|
284 | (3) |
|
Changing the Size of Cells |
|
|
287 | (3) |
|
Formatting How Cells Are Displayed |
|
|
290 | (2) |
|
Adding and Removing Rows and Columns |
|
|
292 | (3) |
|
Merging or Unmerging Cells |
|
|
295 | (2) |
|
Using Number Formats in Microsoft Excel Workbooks |
|
|
297 | (2) |
|
Sorting and Filtering Data |
|
|
299 | (5) |
|
|
|
300 | (2) |
|
|
|
302 | (2) |
|
Using Common Formulas and Functions |
|
|
304 | (9) |
|
Using Mathematical Operators |
|
|
305 | (2) |
|
Using Relative and Absolute References |
|
|
307 | (3) |
|
|
|
310 | (3) |
|
|
|
313 | (8) |
|
|
|
315 | (2) |
|
|
|
317 | (2) |
|
|
|
319 | (2) |
|
|
|
321 | (1) |
|
|
|
321 | (1) |
|
|
|
322 | (1) |
|
|
|
323 | (2) |
|
Chapter 8 Using Microsoft PowerPoint |
|
|
325 | (36) |
|
Adding and Removing Slides When Creating Presentations |
|
|
327 | (3) |
|
Changing the Order of Your Slides |
|
|
330 | (1) |
|
Changing the Design and the Background of Your Presentations |
|
|
331 | (3) |
|
Adding and Formatting the Text in Your Presentations |
|
|
334 | (3) |
|
Changing the Layout of Your Slides |
|
|
337 | (2) |
|
Adding Shapes and Pictures to Your Slides |
|
|
339 | (3) |
|
Adding Tables to Your Presentations |
|
|
342 | (3) |
|
Formatting the Tables in Your Presentations |
|
|
345 | (3) |
|
Adding Charts to Your Presentations |
|
|
348 | (2) |
|
Adding Video and Other Multimedia Files to Your Presentations |
|
|
350 | (2) |
|
Adding Animations to Your Presentation |
|
|
352 | (3) |
|
Setting Transitions between Slides and Viewing Your Presentations |
|
|
355 | (2) |
|
|
|
357 | (1) |
|
|
|
358 | (1) |
|
|
|
358 | (1) |
|
|
|
359 | (2) |
|
Chapter 9 Using Microsoft Access |
|
|
361 | (22) |
|
Adding, Modifying, and Removing Data in a Microsoft Access Database |
|
|
362 | (5) |
|
Using Search in a Microsoft Access Database |
|
|
367 | (3) |
|
Using Stored Queries in a Microsoft Access Database |
|
|
370 | (2) |
|
Running Predefined Reports in a Microsoft Access Database |
|
|
372 | (1) |
|
Creating Simple Reports in a Microsoft Access Database |
|
|
373 | (6) |
|
|
|
379 | (1) |
|
|
|
380 | (1) |
|
|
|
380 | (1) |
|
|
|
381 | (2) |
|
Chapter 10 Collaborating with Others When Working in Microsoft Office |
|
|
383 | (22) |
|
Adding Comments to Your Microsoft Office Files |
|
|
384 | (3) |
|
Reviewing the Comments That Were Added to a Document |
|
|
387 | (1) |
|
Tracking Changes in a Microsoft Word Document |
|
|
388 | (2) |
|
Reviewing Changes in a Microsoft Word Document |
|
|
390 | (3) |
|
Sharing Your Work Files Using Email |
|
|
393 | (3) |
|
Storing Documents Using Network Attached Storage Solutions |
|
|
396 | (2) |
|
Storing Documents Using Cloud Storage Solutions |
|
|
398 | (2) |
|
|
|
400 | (1) |
|
|
|
400 | (1) |
|
|
|
401 | (1) |
|
|
|
402 | (3) |
| Part III Living Online |
|
405 | (150) |
|
Chapter 11 Using the Internet |
|
|
407 | (34) |
|
Understanding the Terminology about the Internet and the WWW |
|
|
408 | (2) |
|
Understanding the World Wide Web |
|
|
410 | (2) |
|
|
|
410 | (1) |
|
|
|
411 | (1) |
|
|
|
411 | (1) |
|
Browsing the Web with a Web Browser |
|
|
412 | (5) |
|
Using Multiple Tabs While Browsing the Web |
|
|
417 | (2) |
|
Downloading and Uploading Files on the Web |
|
|
419 | (1) |
|
Setting a Homepage in Your Web Browser |
|
|
420 | (3) |
|
Using and Clearing Your Browsing History |
|
|
423 | (5) |
|
Using Favorites or Bookmarks in Your Web Browser |
|
|
428 | (5) |
|
Searching for Text in a Web Page from Your Web Browser |
|
|
433 | (2) |
|
Using Plug-ins, Add-ons, and Extensions in Your Web Browser |
|
|
435 | (1) |
|
|
|
436 | (1) |
|
|
|
436 | (1) |
|
|
|
437 | (1) |
|
|
|
438 | (3) |
|
Chapter 12 Understanding Networking and Its Most Important Concepts |
|
|
441 | (38) |
|
Understanding Networks: LAN vs. WAN |
|
|
442 | (3) |
|
Understanding Network Addressing |
|
|
445 | (4) |
|
|
|
445 | (1) |
|
|
|
446 | (2) |
|
Private IPv4 Address Ranges |
|
|
448 | (1) |
|
Using and Securing Wireless Networks |
|
|
449 | (3) |
|
Changing How You Authenticate to Wireless Access Points |
|
|
450 | (1) |
|
Setting the Encryption for Your Wireless Network |
|
|
451 | (1) |
|
Security Networks with Firewalls and Gateways |
|
|
452 | (3) |
|
|
|
453 | (2) |
|
Understanding the Gateway Concept |
|
|
455 | (1) |
|
Measuring the Speed of Your Internet Connection |
|
|
455 | (4) |
|
Factors Limiting the Speed of Your Internet Connection |
|
|
457 | (1) |
|
Wireless Networking Standards and Speeds |
|
|
458 | (1) |
|
Understanding the Different Types of Internet Connections |
|
|
459 | (3) |
|
|
|
460 | (1) |
|
Broadband Internet Access |
|
|
461 | (1) |
|
|
|
462 | (2) |
|
Principles for Troubleshooting Networking Problems |
|
|
464 | (1) |
|
Troubleshooting Network Problems with the Help of Windows Troubleshooting Tools |
|
|
465 | (6) |
|
Troubleshooting Network Problems from the Command Prompt |
|
|
471 | (4) |
|
|
|
471 | (2) |
|
|
|
473 | (1) |
|
|
|
473 | (2) |
|
|
|
475 | (1) |
|
|
|
475 | (1) |
|
|
|
476 | (1) |
|
|
|
477 | (2) |
|
Chapter 13 Communicating Online with Others |
|
|
479 | (30) |
|
Creating and Securing Email Accounts |
|
|
480 | (2) |
|
|
|
482 | (6) |
|
Attaching Files to Email Massages |
|
|
484 | (1) |
|
|
|
485 | (3) |
|
Replying to and Forwarding Email Messages |
|
|
488 | (2) |
|
Automating Your Email Account |
|
|
490 | (1) |
|
Organizing and Archiving Your Inbox |
|
|
491 | (2) |
|
Communicating through Text Messages |
|
|
493 | (3) |
|
Communicating through Multimedia |
|
|
496 | (2) |
|
Using Social Media and Social Networks |
|
|
498 | (4) |
|
|
|
498 | (4) |
|
|
|
502 | (1) |
|
Increasing the Privacy of Your Social Networking Activity |
|
|
502 | (3) |
|
|
|
505 | (1) |
|
|
|
505 | (1) |
|
|
|
506 | (1) |
|
|
|
507 | (2) |
|
Chapter 14 Being a Responsible Digital Citizen |
|
|
509 | (14) |
|
Personal vs. Professional Communication |
|
|
510 | (2) |
|
Verbal vs. Written Communication |
|
|
512 | (1) |
|
Inappropriate Ways of Communicating Online |
|
|
512 | (2) |
|
Censorship and Filters in the Digital World |
|
|
514 | (2) |
|
Intellectual Property, Copyright, Licensing, and Piracy |
|
|
516 | (3) |
|
|
|
517 | (1) |
|
Creative Commons: A Less Restrictive Form of Licensing |
|
|
518 | (1) |
|
|
|
519 | (1) |
|
|
|
519 | (1) |
|
|
|
520 | (1) |
|
|
|
521 | (2) |
|
Chapter 15 Maintaining Your Health and Safety While Using Computers |
|
|
523 | (14) |
|
Protecting Your Identity and Your Data |
|
|
524 | (2) |
|
Removing Data from Your Computer |
|
|
526 | (4) |
|
Keeping Your Computer Safe from Threats and Malware |
|
|
530 | (1) |
|
The Ergonomics of Using the Computer in a Healthy Way |
|
|
531 | (2) |
|
Common Problems That Are Generated by Incorrect Computer Use and Posture |
|
|
533 | (1) |
|
|
|
534 | (1) |
|
|
|
534 | (1) |
|
|
|
534 | (1) |
|
|
|
535 | (2) |
|
Chapter 16 Searching the World Wide Web |
|
|
537 | (18) |
|
Using Search Engines to Find Information Online |
|
|
538 | (4) |
|
Performing Advanced Searches Using Symbols and Search Operators |
|
|
542 | (1) |
|
Searching for Files Online |
|
|
543 | (3) |
|
Dealing with Online Advertisements |
|
|
546 | (1) |
|
Finding Valuable Information on Internet Forums and Knowledge Bases |
|
|
547 | (2) |
|
Evaluating the Information That You Find on the Web |
|
|
549 | (1) |
|
|
|
550 | (1) |
|
|
|
550 | (1) |
|
|
|
551 | (1) |
|
|
|
552 | (3) |
| Appendixes |
|
555 | (20) |
|
Appendix A Answers to Review Questions |
|
|
557 | (14) |
|
Chapter 1: Understanding Operating Systems |
|
|
558 | (1) |
|
Chapter 2: Understanding Hardware |
|
|
559 | (1) |
|
Chapter 3: Understanding Software |
|
|
559 | (1) |
|
Chapter 4: Troubleshooting Problems with Your Computer |
|
|
560 | (1) |
|
Chapter 5: Exploring Common Application Features in Microsoft Office |
|
|
561 | (1) |
|
Chapter 6: Using Microsoft Word |
|
|
562 | (1) |
|
Chapter 7: Using Microsoft Excel |
|
|
562 | (1) |
|
Chapter 8: Using Microsoft PowerPoint |
|
|
563 | (1) |
|
Chapter 9: Using Microsoft Access |
|
|
564 | (1) |
|
Chapter 10: Collaborating with Others When Working in Microsoft Office |
|
|
564 | (1) |
|
Chapter 11: Using the Internet |
|
|
565 | (1) |
|
Chapter 12: Understanding Networking and Its Most Important Concepts |
|
|
566 | (1) |
|
Chapter 13: Communicating Online with Others |
|
|
567 | (1) |
|
Chapter 14: Being a Responsible Digital Citizen |
|
|
568 | (1) |
|
Chapter 15: Maintaining Your Health and Safety While Using Computers |
|
|
569 | (1) |
|
Chapter 16: Searching the World Wide Web |
|
|
570 | (1) |
|
Appendix B Using the Practice Files |
|
|
571 | (4) |
|
IC3—Module 1: Computing Fundamentals |
|
|
572 | (1) |
|
IC3—Module 2: Key Applications |
|
|
573 | (1) |
|
IC3—Module 3: Living Online |
|
|
574 | (1) |
| Index |
|
575 | |
Lisainfo e-raamatute kohta