You are previewing Digital Literacy For Dummies.
O'Reilly logo
Digital Literacy For Dummies

Book Description

Develop and implement essential computer technology—with confidence

Do you want to develop an understanding of technology to enhance your education, career, or personal life, but feel inhibited by your digital literacy? Fear not! Written in plain English and absent of undecipherable high-tech jargon, Digital Literacy For Dummies makes it easy to get a grip on computer basics, the Internet, the Cloud, browsing the web, productivity programs and applications for school and the workplace, computer security and privacy, the latest in digital lifestyle topics, and so much more.

  • Walks you through the basics of developing essential computer technology skills

  • Shows you how to gain the digital literacy skills required to succeed in education, at home, and in the workforce

  • Explains how the use of smartphones and digital cameras contribute to digital literacy

  • With the introduction of 3G and 4G services in emerging countries like India, worldwide Internet usage is increasing exponentially. With this technological growth comes an opportunity for people of all ages and from all walks of life to learn new skills to keep them ahead of the curve. Packed with easy-to-follow explanations and seasoned with a bit of humor and fun, Digital Literacy For Dummies makes it easy and accessible for anyone to harness the power of technology to remain relevant in school or at work.

    Table of Contents

      1. Introduction
        1. About This Book
        2. Foolish Assumptions
        3. Icons Used in This Book
        4. Beyond the Book
        5. Where to Go from Here
      2. Part I: Computer Basics
        1. Chapter 1: It’s a Digital World
          1. PCs: Discovering the Personal Computing Connection
          2. The Business End: Multi-User Computer Systems
          3. Computer Software
            1. BIOS
            2. Operating system
            3. Utilities
            4. Applications
          4. It’s All Connected
          5. Discovering What’s Out There
            1. Shopping
            2. Fun and games
            3. Communicating online
            4. Social networking
            5. Information, please
            6. Education
        2. Chapter 2: Buying and Setting Up a Computer
          1. Understanding Computer Hardware
            1. Understanding the CPU
            2. Understanding memory
            3. Understanding hard drives
            4. Understanding input devices
            5. Understanding display screens
            6. Understanding optical drives
            7. Understanding Internet connectivity options
          2. Understanding Software
          3. Choosing a Computer
            1. Computer sizes
            2. Operating system
            3. What do you get for your money?
          4. Setting Up a Computer
            1. Unpack the computer
            2. Connect the monitor, keyboard, and mouse
            3. Set up the device
          5. Using Input Devices
            1. Using a pointing device
            2. Work with a touchscreen
            3. Understanding the keyboard layout
            4. Using keyboard shortcuts
          6. Starting Up and Shutting Down
            1. Signing in
            2. Understanding user accounts
            3. Shutting down
        3. Chapter 3: Understanding Operating Systems
          1. What Is an Operating System?
          2. Types of Operating Systems
          3. Operating Systems for Desktop and Notebook PCs
            1. Mac OS X
            2. Microsoft Windows
            3. Linux
          4. Operating Systems for Netbooks
          5. Operating Systems for Tablets and Smart Phones
          6. Learning How Operating Systems Talk to Hardware
        4. Chapter 4: Windows 8.1 Basics
          1. Getting Around in Windows 8.1
            1. Understanding the Start screen
            2. Understanding the desktop
            3. Using the Charms bar
          2. Running Applications
            1. Starting an application
            2. Switching among applications
            3. Closing an application
            4. Working in a desktop application
            5. Working in a Windows 8 application
          3. Controlling Application Windows
            1. Managing desktop windows
            2. Arranging Windows 8 apps
          4. Managing Files with File Explorer
            1. Understanding file storage
            2. Browsing drives and folders
            3. Creating a new folder
            4. Selecting files and folders
            5. Changing the file listing view
            6. Searching for files
            7. Copying or moving a file or folder
            8. Deleting and recovering files
          5. Using a Home Network
            1. Assessing your current network
            2. Setting up network hardware
            3. Connecting a computer to a wireless network
            4. Getting better wireless signal strength
            5. Sharing files and folders on a network
            6. Browsing other people’s shared resources
            7. Using a shared printer
            8. Sharing your printer with others
      3. Part II: The Online Experience
        1. Chapter 5: Understanding Internet Basics
          1. What Is the Internet?
          2. Exploring Different Types of Internet Connections
          3. Setting Up an Internet Connection
          4. Troubleshooting an Internet Connection
        2. Chapter 6: Working with the Web
          1. Discovering How the Web Works
          2. Understanding Web Addresses
          3. Checking out Internet Explorer’s Interface
          4. Performing Web Searches
          5. Using a Secure Site
          6. Viewing Your History
          7. Saving and Organizing Favorites
          8. Creating Your Own Web Content
        3. Chapter 7: Sending and Receiving Email
          1. Understanding Email
            1. Email addresses and mail servers
            2. Types of email accounts
          2. Signing Up for an Email Account
          3. Setting Up an Account in Your Email Client
            1. Setting Up an Account in Mail in Windows 8.1
            2. Setting up an account at Outlook.com
            3. Setting Up an Account in Microsoft Outlook 2013
          4. Composing and Sending Email
          5. Understanding the Inbox Interface
          6. Replying and Forwarding
          7. Managing Email Messages
            1. Deleting messages
            2. Browsing folders
            3. Creating folders
            4. Moving messages into folders
          8. Understanding Email Etiquette
        4. Chapter 8: Clouds and Online Communication
          1. Using Cloud-Based Applications
          2. Working with Microsoft OneDrive
            1. Signing into the OneDrive web interface
            2. Installing and using OneDrive for Windows Desktop
            3. Using the Windows 8 OneDrive app
          3. Participating in Social Networking
            1. Facebook and other social network sites
            2. Discussion boards
            3. Blogging
            4. Twitter
          4. Using Instant Messaging
          5. Using a Webcam
      4. Part III: Productivity Programs
        1. Chapter 9: Understanding Applications
          1. Types of Applications
          2. Installing and Removing Applications
          3. What Is Microsoft Office?
          4. Navigating an Office Application’s Interface
            1. The Start screen
            2. Ribbon and tabs
            3. The File menu
            4. Moving around in an application
            5. Changing the zoom and the view
          5. Creating a Document
            1. Typing text
            2. Inserting a picture
          6. Opening and Saving Files
            1. Saving your work for the first time
            2. Navigating in the Save As dialog box
            3. Opening a document
          7. Printing Files
        2. Chapter 10: Creating Personal Documents with Microsoft Word
          1. Creating a New Document Using a Template
          2. Adjusting Page Settings
            1. Setting page margins
            2. Setting paper size and orientation
          3. Editing and Selecting Text
            1. Filling text placeholders
            2. Typing and editing text
            3. Selecting text
          4. Formatting Text
            1. Choosing text font, size, and color
            2. Applying text attributes and effects
            3. Working with themes
            4. Applying style sets
          5. Formatting Paragraphs
            1. Applying horizontal alignment
            2. Indenting a paragraph
            3. Changing vertical spacing
            4. Creating bulleted and numbered lists
          6. Working with Styles
            1. Applying a style
            2. Modifying a style
            3. Creating a new style
            4. Copying formatting with Format Painter
          7. Checking Spelling and Grammar
          8. Creating a Table
            1. Selecting rows and columns
            2. Resizing rows and columns
            3. Formatting table borders
          9. Working with Pictures
            1. Inserting pictures from the web
            2. Understanding vector and raster graphics
            3. Inserting photos from files
            4. Changing the text wrap setting for a picture
            5. Moving a picture
            6. Resizing a picture
          10. Understanding Desktop Publishing
        3. Chapter 11: Managing and Calculating Data with Microsoft Excel
          1. Understanding the Excel Interface
            1. Moving the cell cursor
            2. Selecting ranges
          2. Typing and Editing Cell Content
            1. Editing data in cells
            2. Copying and moving data between cells
            3. Using AutoFill to fill cell content
          3. Changing the Worksheet Structure
            1. Inserting and deleting rows and columns
            2. Inserting and deleting cells and ranges
          4. Calculating with Formulas
            1. Moving and copying formulas
            2. Introducing functions
            3. Using the SUM function
            4. Inserting a function
            5. Touring some basic functions
          5. Formatting a Worksheet
            1. Adjusting rows and columns
            2. Applying a workbook theme
          6. Printing Worksheets
          7. Creating Charts
            1. Creating a pie chart
            2. Creating a column or bar chart
            3. Switching rows and columns
            4. Understanding the elements of a chart
            5. Editing the chart data range
            6. Changing the chart type
            7. Resizing a chart
            8. Moving a chart to its own worksheet
            9. Adding and positioning chart elements
            10. Formatting a chart
        4. Chapter 12: Creating Presentations with Microsoft PowerPoint
          1. Exploring the PowerPoint Interface
            1. Moving around in a presentation
            2. Understanding PowerPoint views
          2. Creating a New Presentation
            1. Creating new slides
            2. Duplicating a slide
            3. Deleting a slide
            4. Adding text to a slide
            5. Manipulating slide content
          3. Formatting a Presentation
            1. Applying themes
            2. Applying shape styles
            3. Applying a background fill
            4. Applying and removing borders
            5. Applying shape effects
            6. Turning text Autofit on or off
          4. Inserting Graphics
            1. Inserting an online image from Office.com
            2. Inserting your own pictures
          5. Adding Slide Transition Effects
          6. Setting Slides to Advance Manually or Automatically
          7. Inserting Sounds and Videos
            1. Inserting a sound clip on a slide
            2. Inserting a video clip on a slide
          8. Presenting a Slide Show
            1. Moving between slides
            2. Ending the slide show
          9. Printing Handouts and Notes
        5. Chapter 13: Storing and Retrieving Data with Microsoft Access
          1. Understanding Database and Access Basics
          2. Creating a New Database
          3. Creating a Table
          4. Creating Relationships Between Tables
          5. Entering and Editing Records
          6. Creating Queries
            1. Creating a query with the Simple Query Wizard
            2. Creating a query in Query Design View
          7. Creating Reports
      5. Part IV: Digital Security and Privacy
        1. Chapter 14: Protecting Your Computer and Data from Harm
          1. Understanding the Risks
            1. Risks
            2. Threats
          2. Protecting Against Natural Risks
            1. Creating a computer-friendly workspace
            2. Making data backups
          3. Protecting Against Human-Created Threats
            1. Strong passwords
            2. Operating system updates
            3. Virus and malware protection
            4. Firewalls
          4. Adjusting Settings to Increase Security
            1. Web browser security settings
            2. Email security settings
          5. Following Best Practices for Safer Web Use
            1. Watch out for phishing
            2. Enter financial information only on secure sites
            3. Pay attention to security certificates
            4. Shop at stores you know
            5. Be careful with online payments
            6. Be stingy with the information you provide
            7. Stay away from “vice sites”
        2. Chapter 15: Safeguarding Your Privacy
          1. Understanding Why Personal Information Is Big Business
          2. Targeted Advertising
            1. How advertisers target consumers
            2. Minimizing the information advertisers gather
            3. Tracking protection
            4. Limiting third-party cookies
          3. Identity Theft
            1. Social engineering
            2. Oversharing on social media
          4. Increasing Your Privacy on the Web
            1. Browser settings for increasing privacy
            2. Instant messaging privacy settings
            3. Email privacy settings
          5. Protecting Children from Online Threats
            1. How online predators operate
            2. How children leak information
            3. Best practices for keeping children safe
            4. Using family safety applications
          6. Avoiding Copyright Violations
            1. Plagiarism
            2. Copyright violations
            3. Keeping on the right side of the law
      6. Part V: Mobility and Multimedia
        1. Chapter 16: Expanding Computing to Other Devices
          1. Getting a Handle on Tablet Computer Basics
            1. Tablet sizes
            2. Tablet computer operating systems
            3. Navigating a tablet computer OS
          2. Understanding Smart Phone Basics
            1. Types of smart phones
            2. Selecting a smart phone
            3. Navigating a smart phone interface
          3. Grasping Digital TV and Movie Basics
            1. Signing up for online movie and TV services
            2. Watching online content
            3. Watching TV on a computer
            4. Showing computer content on a TV screen
        2. Chapter 17: Digital Cameras and Photography
          1. Learning How Digital Imaging Works
          2. Choosing a Digital Camera
            1. Body style
            2. Price range
            3. Features
          3. Choosing a Photo Organizer Program
          4. Transferring Photos from Camera to Computer
            1. Transferring photos with File Explorer
            2. Transferring photos with a photo organizer program
            3. Copying photos from a memory card
          5. Storing and Managing Digital Images
            1. Previewing and viewing photos
            2. Moving and copying images
            3. Deleting images
          6. Editing a Digital Image
            1. Rotating an image
            2. Color-correcting an image
            3. Cropping an image
          7. Printing Digital Images
            1. Checking out your printer’s settings
            2. Selecting a photo printer
            3. Printing from Windows Live Photo Gallery
            4. Using a printing service
          8. Sharing Digital Images
            1. Choose a photo sharing service
            2. Resizing a photo for sharing
        3. Chapter 18: Working with Music and Video
          1. Understanding Digital Audio
            1. What you need for digital audio
            2. How digital audio is recorded
            3. Audio file formats
          2. Organizing and Playing Digital Music
            1. Applications for playing digital music
            2. Organizing digital media on your computer
          3. Using Windows Media Player
            1. Playing stored music tracks
            2. Creating a playlist
            3. Buying Digital Music Online
            4. Ripping a CD
            5. Copying music from another computer
            6. Burning a CD with Windows Media Player
            7. Synchronizing a portable device
            8. Streaming music to other people
          4. Understanding Speech Technologies
            1. Reading written text aloud
            2. Setting up a microphone
            3. Dictating text using a microphone
            4. Controlling Windows using a microphone
          5. Understanding Digital Video
            1. Video formats
            2. Adobe Flash Media
            3. Animated GIF
            4. Applications for playing videos and movies
            5. How DVDs store movies
            6. Streaming audio and video on the web
          6. Creating and Editing Audio and Video
            1. Audio editing applications
            2. Video editing applications
            3. Editing a digital video with Windows Movie Maker
            4. Outputting your digital video project
      7. Part VI: The Part of Tens
        1. Chapter 19: Ten Computer Problems (and How to Solve Them)
          1. Your Computer Has No Power, No Nothing
          2. Windows Won’t Start Up Normally
          3. Everything’s Running Slower than Normal
            1. System Restore
            2. Refreshing Windows
          4. You Have No Internet Access
            1. Check your Internet connection
            2. Check your router
            3. Check your computer
          5. You Can’t Get Email
          6. An Application Stops Responding
          7. You Get the Blue Screen of Death
          8. You See Frequent Pop-Up Ads on the Web
          9. Your System Has No Sound
          10. The Video in a Game Is Messed Up
        2. Chapter 20: Ten Tips for Working with Windows 8.1
          1. Use Search to Start Applications
          2. Reorganize the Start Screen
          3. Pin Shortcuts to the Taskbar
          4. Make Icons and Text Larger
          5. Switch Between Programs Quickly
          6. Right-Click the Start Button
          7. Use Libraries (Or Not)
          8. Save Location Favorites in File Explorer
          9. Uninstall Unwanted Applications
          10. Prevent Programs from Loading at Startup
      8. Appendix: Making a Living in Digital Technology
        1. The Changing Workplace
        2. Careers for a Computer-Literate Person
          1. Administrative assistant
          2. Supervisor
          3. Project manager
          4. Accounting assistant
          5. Customer service representative
        3. Careers for Information Workers
          1. Word-processing specialist
          2. Social media marketer
          3. Researcher/fact-checker
        4. Careers for IT Professionals
          1. Information systems manager
          2. Health IT specialist
          3. Network installer
          4. Bench repair technician
          5. Database administrator
          6. Help desk technician
          7. Security specialist
        5. Careers for Developers
          1. Programmer
          2. Web designer
          3. Instructional designer
      9. About the Author
      10. Cheat Sheet