Digital Literacy by Faithe Wempen Digital Literacy For Dummies® Published by: John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030-5774, www.wiley.com Copyright © 2015 by John Wiley & Sons, Inc., Hoboken, New Jersey Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior writ- ten permission of the Publisher. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, For Dummies, the Dummies Man logo, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and may not be used without written permission. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book. LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITH- OUT LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ. For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002. For technical support, please visit www.wiley.com/techsupport. Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com. Library of Congress Control Number: 2014951779 ISBN : 978-1-118-96286-2 (pbk); ISBN 978-1-118-96287-9 (ebk); ISBN 978-1-118-96307-4 (ebk) Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1 Table of Contents Introduction ................................................................. 1 About This Book ..............................................................................................2 Foolish Assumptions .......................................................................................3 Icons Used in This Book .................................................................................4 Beyond the Book .............................................................................................4 Where to Go from Here ...................................................................................5 Part I: Computer Basics ................................................ 7 Chapter 1: It’s a Digital World . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 PCs: Discovering the Personal Computing Connection ..............................9 The Business End: Multi-User Computer Systems ....................................13 Computer Software ........................................................................................13 BIOS .......................................................................................................14 Operating system .................................................................................14 Utilities ..................................................................................................15 Applications ..........................................................................................15 It’s All Connected ...........................................................................................15 Discovering What’s Out There .....................................................................17 Shopping ...............................................................................................17 Fun and games......................................................................................18 Communicating online ........................................................................18 Social networking .................................................................................20 Information, please ..............................................................................22 Education ..............................................................................................22 Chapter 2: Buying and Setting Up a Computer . . . . . . . . . . . . . . . . . . . . 25 Understanding Computer Hardware ...........................................................25 Understanding the CPU .......................................................................26 Understanding memory ......................................................................27 Understanding hard drives .................................................................28 Understanding input devices .............................................................28 Understanding display screens ..........................................................29 Understanding optical drives .............................................................30 Understanding Internet connectivity options ..................................31 Understanding Software ...............................................................................32 iv Digital Literacy For Dummies Choosing a Computer ...................................................................................33 Computer sizes.....................................................................................33 Operating system .................................................................................33 What do you get for your money? .....................................................34 Setting Up a Computer ..................................................................................35 Unpack the computer ..........................................................................35 Connect the monitor, keyboard, and mouse ....................................36 Set up the device ..................................................................................37 Using Input Devices .......................................................................................37 Using a pointing device .......................................................................37 Work with a touchscreen ....................................................................38 Understanding the keyboard layout ..................................................39 Using keyboard shortcuts...................................................................40 Starting Up and Shutting Down ....................................................................41 Signing in ...............................................................................................41 Understanding user accounts ............................................................41 Shutting down ......................................................................................42 Chapter 3: Understanding Operating Systems . . . . . . . . . . . . . . . . . . . . 45 What Is an Operating System? .....................................................................45 Types of Operating Systems ........................................................................46 Operating Systems for Desktop and Notebook PCs ..................................47 Mac OS X ...............................................................................................47 Microsoft Windows ..............................................................................48 Linux ......................................................................................................50 Operating Systems for Netbooks .................................................................51 Operating Systems for Tablets and Smart Phones ....................................52 Learning How Operating Systems Talk to Hardware ................................54 Chapter 4: Windows 8 .1 Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Getting Around in Windows 8.1 ...................................................................55 Understanding the Start screen .........................................................55 Understanding the desktop ................................................................57 Using the Charms bar ..........................................................................58 Running Applications ....................................................................................59 Starting an application ........................................................................59 Switching among applications ...........................................................62 Closing an application .........................................................................63 Working in a desktop application ......................................................63 Working in a Windows 8 application .................................................65 Controlling Application Windows ...............................................................65 Managing desktop windows ...............................................................65 Arranging Windows 8 apps .................................................................66 Managing Files with File Explorer ................................................................67 Understanding file storage .................................................................68 Browsing drives and folders ...............................................................70 v Table of Contents Creating a new folder ..........................................................................71 Selecting files and folders ...................................................................72 Changing the file listing view ..............................................................72 Searching for files ................................................................................73 Copying or moving a file or folder .....................................................73 Deleting and recovering files ..............................................................74 Using a Home Network ..................................................................................75 Assessing your current network ........................................................76 Setting up network hardware .............................................................77 Connecting a computer to a wireless network ................................78 Getting better wireless signal strength .............................................80 Sharing files and folders on a network ..............................................80 Browsing other people’s shared resources......................................83 Using a shared printer .........................................................................84 Sharing your printer with others .......................................................84 Part II: The Online Experience ..................................... 87 Chapter 5: Understanding Internet Basics . . . . . . . . . . . . . . . . . . . . . . .89 What Is the Internet? .....................................................................................89 Exploring Different Types of Internet Connections ..................................91 Setting Up an Internet Connection ..............................................................94 Troubleshooting an Internet Connection ...................................................95 Chapter 6: Working with the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Discovering How the Web Works ................................................................99 Understanding Web Addresses .................................................................101 Checking out Internet Explorer’s Interface ..............................................103 Performing Web Searches ..........................................................................106 Using a Secure Site ......................................................................................109 Viewing Your History ..................................................................................110 Saving and Organizing Favorites ...............................................................112 Creating Your Own Web Content ..............................................................113 Chapter 7: Sending and Receiving Email . . . . . . . . . . . . . . . . . . . . . . .117 Understanding Email ...................................................................................117 Email addresses and mail servers ...................................................118 Types of email accounts ...................................................................118 Signing Up for an Email Account ...............................................................119 Setting Up an Account in Your Email Client .............................................120 Setting Up an Account in Mail in Windows 8.1 ...............................121 Setting up an account at Outlook.com ............................................123 Setting Up an Account in Microsoft Outlook 2013 .........................125 vi Digital Literacy For Dummies Composing and Sending Email ...................................................................126 Understanding the Inbox Interface ............................................................128 Replying and Forwarding ............................................................................129 Managing Email Messages ..........................................................................130 Deleting messages .............................................................................130 Browsing folders ................................................................................130 Creating folders ..................................................................................131 Moving messages into folders ..........................................................133 Understanding Email Etiquette ..................................................................134 Chapter 8: Clouds and Online Communication . . . . . . . . . . . . . . . . . . 137 Using Cloud-Based Applications ................................................................137 Working with Microsoft OneDrive .............................................................139 Signing into the OneDrive web interface ........................................140 Installing and using OneDrive for Windows Desktop ....................141 Using the Windows 8 OneDrive app ................................................141 Participating in Social Networking ............................................................143 Facebook and other social network sites .......................................143 Discussion boards .............................................................................144 Blogging ...............................................................................................146 Twitter .................................................................................................147 Using Instant Messaging .............................................................................148 Using a Webcam ..........................................................................................150 Part III: Productivity Programs .................................. 151 Chapter 9: Understanding Applications . . . . . . . . . . . . . . . . . . . . . . . . 153 Types of Applications .................................................................................153 Installing and Removing Applications ......................................................154 What Is Microsoft Office? ...........................................................................157 Navigating an Office Application’s Interface ............................................159 The Start screen .................................................................................159 Ribbon and tabs .................................................................................160 The File menu .....................................................................................161 Moving around in an application .....................................................162 Changing the zoom and the view .....................................................163 Creating a Document ...................................................................................164 Typing text ..........................................................................................164 Inserting a picture ..............................................................................165 Opening and Saving Files ............................................................................166 Saving your work for the first time ..................................................166 Navigating in the Save As dialog box ..............................................168 Opening a document .........................................................................170 Printing Files ................................................................................................170 vii Table of Contents Chapter 10: Creating Personal Documents with Microsoft Word . . . 173 Creating a New Document Using a Template ...........................................173 Adjusting Page Settings ..............................................................................176 Setting page margins .........................................................................176 Setting paper size and orientation ...................................................178 Editing and Selecting Text ..........................................................................179 Filling text placeholders ....................................................................180 Typing and editing text .....................................................................180 Selecting text ......................................................................................180 Formatting Text ...........................................................................................181 Choosing text font, size, and color ..................................................181 Applying text attributes and effects ................................................182 Working with themes ........................................................................184 Applying style sets .............................................................................186 Formatting Paragraphs ...............................................................................187 Applying horizontal alignment .........................................................187 Indenting a paragraph .......................................................................188 Changing vertical spacing .................................................................190 Creating bulleted and numbered lists .............................................191 Working with Styles .....................................................................................192 Applying a style ..................................................................................193 Modifying a style ................................................................................194 Creating a new style ..........................................................................194 Copying formatting with Format Painter ........................................195 Checking Spelling and Grammar ................................................................196 Creating a Table ...........................................................................................197 Selecting rows and columns .............................................................198 Resizing rows and columns ..............................................................199 Formatting table borders ..................................................................200 Working with Pictures .................................................................................201 Inserting pictures from the web.......................................................201 Understanding vector and raster graphics ....................................202 Inserting photos from files ...............................................................205 Changing the text wrap setting for a picture..................................205 Moving a picture ................................................................................206 Resizing a picture...............................................................................208 Understanding Desktop Publishing ...........................................................208 Chapter 11: Managing and Calculating Data with Microsof t Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 Understanding the Excel Interface ............................................................211 Moving the cell cursor ......................................................................213 Selecting ranges .................................................................................213 Typing and Editing Cell Content ................................................................215 Editing data in cells ...........................................................................216 Copying and moving data between cells ........................................216 Using AutoFill to fill cell content ......................................................217 viii Digital Literacy For Dummies Changing the Worksheet Structure ...........................................................218 Inserting and deleting rows and columns.......................................218 Inserting and deleting cells and ranges ..........................................219 Calculating with Formulas ..........................................................................220 Moving and copying formulas ..........................................................221 Introducing functions ........................................................................222 Using the SUM function .....................................................................223 Inserting a function ............................................................................223 Touring some basic functions ..........................................................224 Formatting a Worksheet .............................................................................225 Adjusting rows and columns ............................................................226 Applying a workbook theme.............................................................227 Printing Worksheets ....................................................................................227 Creating Charts ............................................................................................228 Creating a pie chart ...........................................................................229 Creating a column or bar chart ........................................................230 Switching rows and columns ............................................................231 Understanding the elements of a chart ...........................................232 Editing the chart data range .............................................................234 Changing the chart type ....................................................................234 Resizing a chart ..................................................................................235 Moving a chart to its own worksheet ..............................................235 Adding and positioning chart elements ..........................................236 Formatting a chart .............................................................................237 Chapter 12: Creating Presentations with Microsof t PowerPoint . . . 239 Exploring the PowerPoint Interface ..........................................................240 Moving around in a presentation.....................................................241 Understanding PowerPoint views ....................................................241 Creating a New Presentation ......................................................................242 Creating new slides ............................................................................242 Duplicating a slide .............................................................................243 Deleting a slide ...................................................................................244 Adding text to a slide.........................................................................244 Manipulating slide content ...............................................................246 Formatting a Presentation ..........................................................................247 Applying themes ................................................................................247 Applying shape styles .......................................................................248 Applying a background fill ................................................................249 Applying and removing borders ......................................................250 Applying shape effects ......................................................................250 Turning text Autofit on or off ...........................................................251 Inserting Graphics .......................................................................................252 Inserting an online image from Office.com .....................................253 Inserting your own pictures .............................................................253 Adding Slide Transition Effects ..................................................................254