Table of Contents
Section I: Computing Basics
1. Introduction to Computer Concepts
1.1 What Is a Computer?
1.1.1 Computer Software
1.1.2 Computer Hardware
1.2 History and Background of Computing Technology
1.3 Purchasing a New Computer System
1.4 How the Computer Works
1.4.1 Input Hardware Devices
1.4.2 Output Hardware Devices
1.4.3 Processing Hardware Devices
1.4.4 Data Storage
1.4.5 What Computers Can and Cannot Do
1.5 Introduction to the Windows Operating System
1.5.1 Windows 7
1.5.2 Windows 8
1.6 Introduction to Mac OS X
1.7 Shutdown Procedures
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
2. Navigating and Using the Computer Environment
2.1 Navigating the Desktop
2.1.1 The Windows Desktop
2.1.1.1 The Control Panel
2.1.1.2 Jump Lists
2.1.1.3 Task Manager
2.1.1.4 Libraries Feature
2.1.2 The Macintosh OS X Desktop
2.1.2.1 The Finder
2.1.2.2 The Dock
2.1.2.3 The Dashboard, Expose, and Spaces
2.1.2.4 Force Quit
2.2 Organizing Files and Folders
2.2.1 Files and Folders in Windows
2.2.2 Files and Folders on a Mac
2.3 Working with Files on Your Computer
2.3.1 WordPad on Windows
2.3.2 TextEdit for Macintosh
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
3. Using the Internet
In This Chapter
3.1 Background and Historical Context of the Web
3.1.1 How the Web Works
3.1.2 Connecting to the Internet
3.2 Using a Web Browser
3.2.1 Addresses on the Web
3.2.2 Microsoft Internet Explorer
3.2.3 Mozilla Firefox
3.2.4 Apple Safari
3.3 Using Web Browser Plug-Ins
3.4 Using Search Engines to Find Information on the Web
3.5 Privacy and Security on the Web
3.5.1 Browsing and Search History
3.5.2 Secure Sites
3.5.3 Safe Sites
3.6 The Web and Fair Use
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
4. Using Email and Email Clients
4.1 Introduction to Electronic Mail
4.2 Email Structure
4.3 Email Addresses
4.4 Creating a Personal Email Account
4.4.1 Email Account Types
4.4.2 Microsoft Windows Live Hotmail
4.4.2.1 Creating an Account
4.4.2.2 Navigating and Opening Email
4.4.2.3 Composing an Email
4.4.2.4 Logging Out and Logging In
4.4.3 Gmail by Google
4.4.3.1 Creating an Account
4.4.3.2 Navigating and Opening Email
4.4.3.3 Composing an Email
4.4.3.4 Logging Out and Logging In
4.5 Email Clients
4.5.1 Microsoft Windows Live Mail
4.5.2 Macintosh Mail
4.5.3 Mozilla Thunderbird
4.5.4 Connecting to Your Email Remotely
4.6 Email Etiquette
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
5. Microsoft OneDrive and Cloud Computing
5.1 Cloud Computing
5.2 Microsoft OneDrive
5.2.1 Creating a Microsoft Account
5.2.2 Uploading and Downloading Files
5.3 Integrating OneDrive with the Desktop
5.3.1 OneDrive on Windows 7
5.3.2 OneDrive on Windows 8
5.3.3 OneDrive on Mac OS X
5.4 Integrating OneDrive with Microsoft Office
5.5 Accessing OneDrive on a Remote Device
5.6 Alternate Cloud Computing Platforms
5.6.1 Google Drive
5.6.2 iCloud
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
4.4.3 Gmail by Google
4.4.3.1 Creating an Account
4.4.3.2 Navigating and Opening Email
4.4.3.3 Composing an Email
4.4.3.4 Logging Out and Logging In
4.5 Email Clients
4.5.1 Microsoft Windows Live Mail
4.5.2 Macintosh Mail
4.5.3 Mozilla Thunderbird
4.5.4 Connecting to Your Email Remotely
4.6 Email Etiquette
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
5. Microsoft OneDrive and Cloud Computing
5.1 Cloud Computing
5.2 Microsoft OneDrive
5.2.1 Creating a Microsoft Account
5.2.2 Uploading and Downloading Files
5.3 Integrating OneDrive with the Desktop
5.3.1 OneDrive on Windows 7
5.3.2 OneDrive on Windows 8
5.3.3 OneDrive on Mac OS X
5.4 Integrating OneDrive with Microsoft Office
5.5 Accessing OneDrive on a Remote Device
5.6 Alternate Cloud Computing Platforms
5.6.1 Google Drive
5.6.2 iCloud
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
6. Microsoft Outlook® and Productivity Management
6.1 Microsoft Outlook
6.1.1 Anatomy of Microsoft Outlook 2013
6.1.2 Anatomy of Microsoft Outlook 2011
6.2 Managing Email in Outlook
6.2.1 Creating a New Email
6.2.2 Formatting Email Content
6.2.3 Managing Incoming Email
6.2.4 Responding to Email
6.3 Managing Calendars
6.4 Managing Contacts
6.5 Tasks and Notes
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section II: Word Processing
7. Introduction to Word and Word Processing
7.1 Introduction to Productivity Software
7.1.1 The File Menu
7.1.2 Document Management
7.1.3 Help Files
7.1.4 Productivity Shortcuts
7.1.5 The System Clipboard
7.2 Introduction to Word Processing Software
7.3 Anatomy of Microsoft Word
7.3.1 Microsoft Word 2013
7.3.2 Microsoft Word 2011
7.3.3 Microsoft Word Web App
7.4 Diving into Word Processing
7.4.2 Formatting Text
7.4.2.1 The Font Panel
7.4.2.2 The Paragraph Panel
7.4.2.3 Format Painter
7.4.3 Bullets and Numbering
7.4.4 Document Review
7.4.4.1 Spelling and Grammar
7.4.4.2 Thesaurus
7.4.4.3 Find and Replace
7.4.5 Using Document Templates
7.4.6 Writing a Resume
7.4.7 Using Headers and Footers
7.4.8 Document Types
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
8. Developing and Editing Documents
8.1 Typography
8.2 Writing a Research Article
8.2.1 Outlining the Document
8.2.2 Using and Managing Styles
8.2.3 Using the Navigation Pane and Document Map Pane
8.3 Managing Citations
8.3.1 Footnotes and Endnotes
8.3.2 Creating a Bibliography
8.4 Setting a Page Layout
8.4.1 Formatting Columns
8.4.2 Adding Graphic Elements and Captions
8.5 Additional Document Elements
8.5.1 Adding a Cover Page
8.5.2 Adding a Table of Contents
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
9. Advanced Features of Word Processing
9.1 Mail Merge
9.1.1 Mail Merge in Microsoft Word 2013
9.1.2 Mail Merge in Microsoft Word 2011
9.2 Additional Document Elements
9.2.1 Adding Symbols
9.2.2 Editing Equations
9.2.3 Adding Tables
9.2.4 Adding Shapes
9.3 Arranging and Grouping Elements
9.4 Editing Existing Documents
9.4.1 Document Comparison
9.4.2 Track Changes
9.4.3 Comments
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section III: Presentation Software
10. Introduction to PowerPoint and Presentation Software
10.1 Introduction to Presentation Software
10.2 Anatomy of Microsoft PowerPoint
10.2.1 Microsoft PowerPoint 2013
10.2.2 Microsoft PowerPoint 2011
10.2.3 Microsoft PowerPoint Web App
10.3 Diving into Presentations
10.3.1 Text Formatting
10.3.2 Inserting and Formatting Shapes
10.3.3 Inserting, Manipulating, and Cropping Images
10.3.4 Arranging, Linking, and Grouping Elements
10.3.5 Adding Text and Hyperlinks
10.3.6 Clip Art and Screenshots
10.3.6.1 Clip Art in Office 2013
10.3.6.2 Clip Art in Office 2011
10.3.6.3 Getting Clip Art from Office.com
10.3.6.4 Handling Clip Art
10.3.7 Sorting Slides
10.3.8 Inserting Screenshots
10.3.9 Transitions
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
11 Creating Effective Presentations
11.1 Writing Your Value Proposition
11.2 Establishing a Visual Style
11.2.1 Modifying the Slide Master
11.2.2 Planning Your Design
11.2.3 Assigning a Theme
11.2.4 Colors, Fonts, and Effects
11.2.5 Bullets and Numbering in the Slide Master
11.2.6 Adding and Formatting Slide Footers
11.2.7 Formatting Text on the Slide Master
11.2.8 Branding Your Slides
11.3 Constructing an Effective Presentation
11.3.1 Outlining
11.3.1.1 Adding Slide Notes
11.3.1.2 Best Practices for Outlining
11.3.2 Grabbing Attention in Your First Slide
11.3.3 Build the Need for Your Presentation
11.3.4 Present Your Main Contribution
11.3.4.1 Effective Visualization
11.3.4.2 Modifying Layouts
11.3.4.3 Tips for Success
11.3.5 Summarize and Conclude
11.4 Presenting Your Masterpiece
11.4.1 Live Presentations
11.4.2 Recording Narration
11.4.3 Sharing Your Presentation
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
12. Advanced Features of Presentation Software
12.1 Creating Handouts
12.1.1 Modifying the Handout Master
12.1.2 Modifying the Notes Master
12.2 Adding Advanced Media
12.2.1 Sound and Video
12.2.2 Tables
12.2.3 Charts
12.2.4 SmartArt
12.2.5 Animations
12.3 Editing Presentations
12.3.1 Opening and Editing Existing Presentations
12.3.2 Slide Setup and Slide Orientation
12.3.3 Creating a Custom Layout
12.3.4 Hiding and Showing Slides
12.3.5 Optimizing and Exporting Images from Slides
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section IV: Spreadsheet Software
13. Introduction to Excel and Spreadsheet Software
13.1 Introduction to Spreadsheet Software
13.2 Anatomy of Excel
13.2.1 Microsoft Excel 2013
13.2.2 Microsoft Excel 2011
13.2.3 Microsoft Excel Web App
13.3 Diving into Spreadsheets
13.3.1 Adding and Formatting Text
13.3.2 Formatting Values
13.3.3 Using Sequences
13.3.4 Formatting Cells
13.3.5 Freezing Panes
13.3.6 Adding Basic Formulas
13.3.6.1 Mathematical Calculations
13.3.6.2 Freezing Cells in Formulas
13.3.6.3 The SUM Function
13.3.7 Using Directional Fill
13.3.8 Navigating the Spreadsheet
13.4 Adding Charts
13.4.1 Chart Data
13.4.2 Formatting Charts
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
14. Developing Worksheets and Graphic Representations
14.1 Constructing a Worksheet
14.1.1 Merging and Splitting Cells
14.1.2 Adding and Deleting Rows and Columns
14.1.3 Hiding Rows and Columns
14.1.4 Advanced Cell Referencing
14.2 List Management
14.2.1 Using Sorting and Filters
14.2.2 Removing Duplicates
14.2.3 Text to Columns
14.2.4 Table Formatting
14.3 Additional Formatting Elements
14.3.1 Conditional Formatting
14.3.2 Tab Color
14.3.3 Comments
14.3.4 Text Boxes
14.4 Chart Types
14.4.1 Column
14.4.2 Line
14.4.3 Pie
14.4.4 Bar
14.4.5 Area
14.4.6 Scatter
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
15. Advanced Features of Spreadsheet Software
15.1 Business Applications
15.2 Using Functions
15.2.1 Common Functions
15.2.2 Text Functions
15.2.3 Value Lookup
15.2.4 IF Statements and Logic
15.2.5 Function Wizard
15.2.6 Calculation Options
15.2.7 Tracing Variables
15.2.8 Data Validation
15.3 Subtotals
15.3.1 Grouping Cells
15.3.2 Constructing Subtotals
15.4 Pivot Tables
15.4.1 Constructing a Pivot Table
15.4.2 Using Pivot Table Values in Formulas
15.5 What If Analysis
15.6 External Data Management
15.6.1 External Data Sources
15.6.2 Exporting Data
15.7 Arranging the Workspace
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Section V: Database Software
16. Introduction to Access and Database Software
16.1 Introduction to Access
16.2 Working with the Interface
16.2.1 Creating a Database
16.2.2 Creating a Database Table
16.2.3 Working with Design View
16.2.4 Primary Keys
16.2.5 More on Data Types
16.3 Data Integrity, Validation, and Good Design Practices
16.3.1 Database Backups
16.3.2 Compressing and Repairing the Database
16.4 Working with Relationships in Microsoft Access
16.4.1 Defining Relationships
16.5 Data Manipulation Using Queries
16.5.1 Basic Queries
16.5.2 Using Query Design to Develop Queries
16.5.3 Working with SQL View
16.5.4 Implementing Inner and Outer Joins
16.6 Learning to Develop Reports
16.7 Developing a Simple Form
Chapter Summary
Chapter Knowledge Check
Chapter Review Questions
Practice Exercises
Challenge Exercises
Appendices
A. Additional Productivity Software
A.1 Adobe Reader
A.1.1 Portable Document Format (PDF)
A.1.2 Adobe Reader Tools
A.1.2.1 Adobe Reader X for Windows
A.1.2.2 Adobe Reader XI for Macintosh
A.2 Microsoft OneNote for Windows
A.2.1 Anatomy of Microsoft OneNote 2013
A.2.2 Adding and Organizing Media and Notes
A.2.3 Linked Notes
A.2.4 Printing to OneNote
A.2.5 Saving and Sharing Notebooks
A.3 Microsoft Word Notebook Layout View for Macintosh
A.3.1 Notebook Layout View
A.3.2 Adding and Organizing Media and Notes
B. Alternate Productivity Software
B.1 Apache OpenOffice Software
B.1.1 OpenOffice Writer
B.1.1.1 Anatomy of Writer
B.1.1.2 Completing the Cover Letter in Writer
B.1.1.3 Completing the Resume in Writer
B.1.1.4 Mail Merge in OpenOffice Writer
B.1.1.5 Advanced Features of Writer
B.1.2 OpenOffice Impress
B.1.2.1 Anatomy of OpenOffice Impress
B.1.2.2 Completing the Projects in Impress
B.1.2.3 Advanced Features of Impress
B.1.3 OpenOffice Calc
B.1.3.1 Anatomy of OpenOffice Calc
B.1.3.2 Creating a Budget in Calc
B.1.3.3 Adding Charts in Calc
B.1.3.4 Advanced Features of Calc
B.2 Google Drive
B.2.1 Document
B.2.2 Presentation
B.2.3 Spreadsheet
C. Odd Numbered Answers to Knowledge Check Exercises
D. On The Companion Disc
Index
Introduction
If you have ever wanted to learn about using either the Microsoft operating system or the Mac operating system, along with productivity tools necessary for the modern business world, then this book is for you. You might be a new student who has little to no experience with this type of software or maybe you are a novice computer user wanting to learn to use an alternative platform; in either case, you should find this book to be a helpful and constructive companion on your journey.
When we first started looking at developing an introductory textbook, we noticed that a variety of schools offered intro courses that focused on the Microsoft environment, yet many students seemed to be showing up to class with Apple. Through the years, we have noticed that students come to class with both Microsoft and Apple products and there has never been a book that could successfully address both versions of the software used in the course.
We have yet to find an introductory textbook that offers the range of alternatives that this book offers. Microsoft Office 365 and Beyond is divided into five sections with 16 chapters that progressively introduce you to computer concepts from the moment you hit the power button all the way through to using a variety of productivity software applications available in Microsoft Office 2013 and Microsoft Office for Mac 2011.
Section I is composed of six chapters that introduce you to the computer environment. In Section I, you will learn about hardware and software, including everything from turning on your computer to identifying its major hardware components, no matter which platform you are using. Here you will also learn about using the Web and email functionality on a variety of platforms.
Section II is composed of three chapters and introduces you to word processing software that includes Microsoft Word for both the Mac and Microsoft environments. Here you will learn to develop basic word processing documents, as well as add advanced functionality.
Section III is composed of three chapters and introduces you to presentation software that includes Microsoft PowerPoint 2013 and Microsoft PowerPoint for Mac 2011. In this section, you will learn how to plan your presentation as well as how to build advanced presentations that incorporate a variety of media elements.
Section IV is composed of three chapters that introduce you to spreadsheet software. Just about any type of organization uses spreadsheet software to transform data into useful information that adds value to the organization. In this section, you will learn how to manipulate data by developing useful spreadsheets and to present data visually using graphics and charts.
Section V is composed of a chapter which introduces you to the world of databases using Microsoft Access 2013 (which is only available for the Microsoft operating system). Databases are much different than spreadsheets, although at first you might think they are similar. By using Access, you can establish complex relationships between data sets, populate a database with data, and develop powerful queries that produce useful information.
The appendices of the textbook have information on other common computer applications, including Adobe Reader (for reading PDF files) and Microsoft OneNote for Windows (for managing files). Additional productivity tools like OpenOffice.org are presented here as well with some instruction on how to complete the chapter projects using this software suite.
Chapter Structure
Each chapter is structured to provide an overview of the key concepts in order for you to demonstrate mastery at the completion of the chapter project. The sections on productivity software include a project for each chapter with detailed descriptions of how to use the various tools, functions, and commands in the respective software packages. In addition, we include the theory and history of how these applications have evolved and information on how these applications can be used to accomplish multiple tasks. Finally, chapter review questions and “Knowledge Checks” are provided to test your comprehension of the chapters.
Each chapter contains in-text activities that give you hands-on practice as you move through the chapter. You will also be given practice exercises for basic comprehension and challenge exercises to move you toward a higher level of mastery for the concepts presented in the chapter.
Companion Disc (Student Resource DVD)
The textbook provides a DVD inside the back cover that includes resources for the student. This DVD includes all of the files needed to complete the chapter exercises within the text. You will also find video tutorials, a repository of high-resolution images from the chapters, and samples of completed projects for comparison.
Instructor Resource DVD (Available Upon Adoption)
The instructor DVD contains the complete set of video tutorials, all the solutions for the Knowledge Check exercises, PowerPoint presentations for each chapter, high resolution color figures, and sample tests for each chapter to use in conjunction with the book.
Online Resources
Digital versions of the text and all of the instructor and student materials are available at authorcloudware Electronic review and desk copies are also available.