Shaffer A., Carey P. etc. New Perspectives on Microsoft Office 2010. 1st Course

Course Technology, Cengage Learning, 2011. – 1092 p.
Shaffer A., Carey P., Finnegan K.T., Pinard K.T., Ageloff R., Ruffolo L., Romer R.M., Pedicini J.E., Parsons J.J., Oja D., Adamski J.J., Cram C.M., Zimmerman S.S., Zimmerman B.B.The New Perspectives Series’ critical-thinking, problem-solving approach is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft Office 2010 has to offer.
In developing the New Perspectives Series, our goal was to create books that give students the software concepts and practical skills they need to succeed beyond the classroom. We’ve updated our proven case-based pedagogy with more practical content to make learning skills more meaningful to students.
With the New Perspectives Series, students understand why they are learning what they are learning, and are fully prepared to apply their skills to real-life situations.Essential Computer Concepts.
Learning About the Components of Computer Systems.
What Is a Computer?
Types of Computers.
Computer Systems.
Data Representation.
Processing Hardware.
Motherboard.
Microprocessor.
Cards.
Memory and Storage.
Memory.
Storage Media.
Input and Output.
Input Devices.
Output Devices.
Data Communications.
Data Bus.
Networks.
Telecommunications.
The Internet.
Security Threats on Your Computer.
Computer Software.
System Software.
Application Software.
Computing in the Cloud.
Putting It All Together.
ProSkills Exercise: Decision Making.Exploring the Basics of Microsoft Windows 7.
Investigating the Windows 7 Operating System.
Session 1.
Starting Windows 7.
Touring the Windows 7 Desktop.
Interacting with the Desktop.
Exploring the Start Menu.
Running Multiple Programs.
Switching Between Programs.
Closing Programs from the Taskbar.
Using Windows and Dialog Boxes.
Manipulating Windows.
Using the Ribbon.
Using List Boxes.
Working with Dialog Boxes.
Session 1 Quick Check.
Session 2.
Exploring Your Computer.
Navigating with the Computer Window.
Changing the View.
Navigating with Windows Explorer.
Getting Help.
Viewing Windows Basics Topics.
Selecting a Topic from the Contents List.
Searching the Help Pages.
Turning Off Windows 7.
Session 2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Problem Solving.Managing Your Files.
Organizing Files and Folders with Windows 7.
Organizing Files and Folders.
Understanding the Need for Organizing Files and Folders.
Developing Strategies for Organizing Files and Folders.
Exploring Files, Folders, and Libraries.
Using Libraries and Folders.
Navigating to Your Data Files.
Managing Folders and Files.
Creating Folders.
Moving and Copying Files and Folders.
Naming and Renaming Files.
Deleting Files and Folders.
Working with Compressed Files.
Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Decision Making.Browser and Email Basics.
Introduction to Microsoft Internet Explorer and Microsoft Windows Live Mail.
The Internet and the Web.
Internet Service Providers and Web Browsers.
Starting Microsoft Internet Explorer.
Search Engines and Uniform Resource Locators.
Using a Search Engine.
Entering a URL in the Address Bar.
Tabbed Browsing.
Using the Favorites Center.
Using the History List.
Using the Favorites List.
Subscribing to an RSS Feed.
Saving Web Slices.
Printing and Saving a Web Page.
Session 1 Quick Check.
Exploring Email.
Examining How Email Works.
Addressing Email.
Sending and Receiving Email Using Windows Live Mail.
Working with Email Messages.
Replying to Email Messages.
Deleting Email Messages.
Adding Contacts to Your Contacts Folder.
Attaching a File to a Message.
Managing Your Schedule with Windows Live Calendar.
Session 2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Written Communication.Getting Started with Microsoft Office 2010.
Preparing a Meeting Agenda.
Exploring Microsoft Office 2010.
Starting Office Programs.
Switching Between Open Programs and Files.
Exploring Common Window Elements.
Resizing the Program Window and Workspace.
Switching Views.
Zooming and Scrolling.
Using the Ribbon.
Clicking Buttons.
Using Galleries and Live Preview.
Opening Dialog Boxes and Task Panes.
Using Contextual Tools.
Displaying Contextual Tabs.
Accessing the Mini Toolbar.
Opening Shortcut Menus.
Working with Files.
Saving a File.
Closing a File.
Opening a File.
Sharing Files Using Windows Live SkyDrive.
Getting Help.
Viewing ScreenTips.
Using the Help Window.
Printing a File.
Exiting Programs.
Quick Check.
Review Assignments.
ProSkills Exercise: Teamwork.Word Level I Tutorials.
Tutorial 1 Creating a Document
Writing a Business Letter and Formatting a Flyer.
Session 1.1.
Starting Word.
Creating a Block Style Business Letter.
Entering Text.
Inserting a Date with AutoComplete.
Entering the Inside Address.
Using the Undo and Redo Buttons.
Correcting Errors as You Type.
Proofreading a Finished Document.
Adjusting Paragraph and Line Spacing.
Adjusting the Margins.
Previewing and Printing a Document.
Opening a Blank Document and Creating an Envelope.
Session 1.1 Quick Check.
Session 1.2.
Opening an Existing Document.
Changing Page Orientation.
Changing the Font and Font Size.
Applying Text Effects, Font Colors, and Font Styles.
Aligning Text.
Adding a Paragraph Border and Shading.
Inserting, Deleting and Resizing a Photo.
Session 1.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 2 Editing and Formatting a Document Editing an Academic Document According to MLA Style.
Session 2.1.
Revising a Document.
Creating Bulleted and Numbered Lists.
Moving Text in a Document.
Dragging and Dropping Text.
Cutting or Copying and Pasting Text using the Clipboard.
Finding and Replacing Text.
Using the Spelling and Grammar Checker.
Working with Styles.
Working with Heading Levels.
Working with Themes.
Session 2.1 Quick Check.
Session 2.2.
Reviewing the MLA Style.
Indenting a Paragraph.
Inserting and Modifying Page Numbers.
Creating Citations and a Bibliography.
Creating Citations.
Generating a Bibliography.
Modifying an Existing Source.
Updating a Bibliography.
Finalizing an MLA Works Cited List.
Session 2.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 3 Creating a Multiple-Page Report Writing a Recommendation.
Session 3.1.
Working with Headings in the Navigation Pane.
Inserting a Blank Table.
Entering Data in a Table.
Selecting Part of a Table.
Sorting Rows in a Table.
Inserting Rows and Columns in a Table.
Deleting Rows and Columns.
Changing Column Widths.
Formatting Tables with Styles.
Session 3.1 Quick Check.
Session 3.2.
Setting Tab Stops.
Creating Footnotes and Endnotes.
Formatting a Document in Sections.
Creating SmartArt.
Adding Headers and Footers.
Inserting a Cover Page.
Session 3.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 4 Desktop Publishing and Mail Merge Creating a Newsletter and Cover Letter.
Session 4.1.
Formatting Text in Columns.
Inserting Drop Caps.
Inserting Symbols and Special Characters. 1
Using WordArt to Create a Headline.
Wrapping Text Around a Graphic.
Resizing WordArt.
Moving WordArt.
Applying WordArt Styles.
Inserting Clip Art.
Cropping a Graphic.
Moving and Aligning a Graphic.
Session 4.1 Quick Check.
Session 4.2.
Editing Photographs.
Rotating a Photo.
Removing a Photo's Background.
Applying a Picture Style.
Balancing Columns.
Inserting a Border Around a Page.
Performing a Simple Mail Merge.
Selecting a Data Source.
Inserting Merge Fields.
Previewing the Merged Document.
Merging the Main Document and Data Source.
Session 4.2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Written Communication.Excel Level I Tutorials.
Tutorial 1 Getting Started with Excel Creating an Order Report.
Session 1.1.
Introducing Excel.
Understanding Spreadsheets.
Exploring the Excel Window.
Navigating Between Worksheets.
Navigating Within a Worksheet.
Planning a Workbook.
Entering Text, Numbers, and Dates.
Entering Text.
Entering Multiple Lines of Text Within a Cell.
Entering Dates.
Entering Numbers.
Working with Columns and Rows.
Setting Column Widths.
Setting Row Heights.
Inserting a Column or Row.
Deleting and Clearing a Row or Column.
Session 1.1 Quick Check.
Session 1.2.
Working with Cells and Ranges.
Selecting a Range.
Moving and Copying a Range.
Inserting and Deleting a Range.
Working with Formulas.
Entering a Formula.
Copying and Pasting Formulas.
Introducing Functions.
Entering a Function.
Entering Functions with the AutoSum Feature.
Working with Worksheets.
Inserting or Deleting a Worksheet.
Renaming a Worksheet.
Moving and Copying a Worksheet.
Editing Worksheet Content.
Undoing and Redoing an Action.
Using Find and Replace.
Using the Spelling Checker.
Previewing and Printing a Workbook.
Changing Worksheet Views.
Working with Portrait and Landscape Orientation.
Printing the Workbook.
Viewing and Printing Worksheet Formulas.
Session 1.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 2 Formatting a Workbook
Designing a Financial Report.
Session 2.1.
Formatting Cell Text.
Applying Fonts and Font Styles.
Applying a Font Color.
Formatting Text Selections.
Working with Colors and Backgrounds.
Applying a Fill Color.
Adding a Background Image.
Formatting Calculated Values.
Creating Formulas to Add, Subtract, and Divide Values.
Applying Number Formats.
Formatting Dates and Times.
Formatting Worksheet Cells.
Aligning Cell Content.
Indenting Cell Content.
Merging Cells.
Rotating Cell Contents.
Adding Cell Borders.
Exploring Options in the Format Cells Dialog Box.
Copying and Pasting Formats.
Copying Formats with the Format Painter.
Copying Formats with the Paste Options Button.
Copying Formats with Paste Special.
Session 2.1 Quick Check.
Session 2.2.
Applying Cell Styles.
Working with Themes.
Creating Formulas to Add and Subtract Values.
Creating Formulas to Calculate Totals.
Creating Formulas to Subtract Values.
Working with Table Styles.
Selecting Table Style Options.
Highlighting Cells with Conditional Formats.
Hiding Worksheet Data.
Formatting the Worksheet for Printing.
Defining the Print Area.
Inserting Page Breaks.
Adding Print Titles.
Creating Page Headers and Footers.
Defining the Page Margins.
Session 2.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 3 Working with Formulas and Functions Developing a Family Budget.
Session 3.1.
Understanding Cell References.
Using Relative References.
Using Absolute References.
Using Mixed References.
Working with Functions.
Understanding Function Syntax.
Inserting a Function.
Typing a Function.
Session 3.1 Quick Check. 1
Session 3.2.
Entering Data and Formulas with AutoFill.
Using the Fill Handle.
Using the Auto Fill Options Button.
Filling a Series.
Developing a Savings Plan. 1
Working with Logical Functions.
Using the IF Function.
Working with Date Functions.
Working with Financial Functions.
Using the PMT Function.
Session 3.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 4 Enhancing a Workbook with Charts and Graphs Charting Financial Data.
Session 4.1.
Creating an Excel Chart.
Selecting a Data Source.
Selecting a Chart Type.
Moving a Chart to a Different Worksheet.
Moving and Resizing Charts.
Designing a Pie Chart. 1
Choosing a Chart Style. 1
Choosing a Chart Layout.
Formatting the Chart Title.
Formatting the Chart Legend.
Formatting Data Labels.
Defining Pie Slice Colors.
Creating a Column Chart.
Inserting a Column Chart.
Formatting a Column Chart Title and Legend.
Editing the Axis Scale and Text.
Formatting the Chart Columns.
Session 4.1 Quick Check.
Session 4.2.
Creating a Line Chart.
Formatting Date Labels.
Setting Label Units.
Overlaying a Chart Legend.
Adding Gridlines.
Adding an Axis Title.
Editing and Revising Chart Data.
Changing a Data Value.
Adding a Data Series to an Existing Chart.
Creating a Combination Chart.
Creating a 3-D Chart.
Adding Sparklines and Data Bars.
Creating Sparklines.
Adding and Formatting Sparkline Markers.
Creating Data Bars.
Modifying a Data Bar Rule. 2
Creating a Chart Sheet.
Session 4.2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Decision Making.Access Level I Tutorials.
Tutorial 1 Creating a Database
Creating a Database to Contain Customer, Contract, and Invoice Data.
Session 1.1.
Introduction to Database Concepts.
Organizing Data.
Databases and Relationships.
Relational Database Management Systems.
Creating a Database.
Creating a Table in Datasheet View.
Renaming the Default Primary Key Field.
Changing the Data Type of the Default Primary
Key Field.
Adding New Fields.
Entering Records.
Saving a Table.
Opening a Table.
Session 1.1 Quick Check.
Session 1.2.
Copying Records from Another Access Database.
Navigating a Datasheet.
Creating a Simple Query.
Creating a Simple Form.
Creating a Simple Report.
Printing a Report.
Viewing Objects in the Navigation Pane.
Managing a Database.
Compacting and Repairing a Database.
Backing Up and Restoring a Database.
Session 1.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 2 Building a Database and Defining Table Relationships Creating the Invoice and Customer Tables.
Session 2.1.
Guidelines for Designing Databases.
Guidelines for Setting Field Properties.
Naming Fields and Objects.
Assigning Field Data Types.
Setting Field Sizes.
Setting the Caption Property for Fields.
Changing the Format of a Field in Datasheet View.
Creating a Table in Design View.
Defining Fields.
Specifying the Primary Key.
Saving the Table Structure.
Modifying the Structure of an Access Table.
Moving a Field.
Adding a Field.
Changing Field Properties.
Session 2.1 Quick Check.
Session 2.2.
Adding Records to a New Table.
Importing Data from an Excel Worksheet.
Creating a Table by Importing an Existing Table Structure.
Adding Fields to a Table Using the Data Type Gallery.
Modifying the Imported Table.
Deleting Fields from a Table Structure.
Renaming Fields in Design View.
Changing the Data Type for a Field in Design View.
Adding Data to a Table by Importing a Text File.
Defining Table Relationships.
One-to-Many Relationships.
Referential Integrity.
Defining a Relationship Between Two Tables.
Session 2.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 3 Maintaining and Querying a Database Updating and Retrieving Information About Customers, Contracts, and Invoices.
Session 3.1.
Updating a Database.
Modifying Records.
Finding Data in a Table.
Deleting Records.
Introduction to Queries.
Creating and Running a Query.
Updating Data Using a Query.
Creating a Multitable Query.
Sorting Data in a Query.
Using an AutoFilter to Sort Data.
Sorting Multiple Fields in Design View.
Filtering Data.
Session 3.1 Quick Check.
Session 3.2.
Defining Record Selection Criteria for Queries.
Specifying an Exact Match.
Modifying a Query.
Changing a Datasheet's Appearance. 1
Changing the Alternate Row Color in a Datasheet. 1
Using a Comparison Operator to Match a Range of Values.
Defining Multiple Selection Criteria for Queries.
The And Logical Operator.
The Or Logical Operator.
Creating a Calculated Field.
Formatting a Calculated Field.
Using Aggregate Functions.
Working with Aggregate Functions Using the Total Row.
Creating Queries with Aggregate Functions.
Using Record Group Calculations.
Working with the Navigation Pane.
Session 3.2 Quick Check. 1
Review Assignments.
Case Problems.
Tutorial 4 Creating Forms and Reports Using Forms and Reports to Display Customer and Contract Data.
Session 4.1.
Creating a Form Using the Form Wizard.
Modifying a Form's Design in Layout View.
Applying a Theme to a Form.
Adding a Picture to a Form.
Changing the Color of the Form Title.
Changing the Type of Line on a Form.
Navigating a Form.
Finding Data Using a Form.
Maintaining Table Data Using a Form.
Previewing and Printing Selected Form Records.
Session 4.1 Quick Check.
Session 4.2.
Creating a Form with a Main Form and a Subform.
Creating a Report Using the Report Wizard.
Modifying a Report's Design in Layout View.
Applying a Theme to a Report.
Resizing a Field on a Report in Layout View.
Changing the Title Font Color and Inserting a Picture in a Report.
Using Conditional Formatting in a Report.
Session 4.2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Teamwork.PowerPoint Level I Tutorials.
Tutorial 1 Creating a Presentation
Presenting Information About a Recreational Timeshare Company.
Session 1.1.
Creating a New Presentation.
Planning a Presentation.
Creating a Title Slide.
Adding a New Slide and Choosing a Layout.
Creating a Bulleted List.
Using Themes.
Opening an Existing Presentation.
Editing Text.
Selecting and Formatting Text.
Editing Text in the Slide Pane.
Undoing Actions.
Using AutoCorrect.
Editing Text in the Outline Tab.
Rearranging Slides.
Deleting Slides.
Running a Slide Show.
Session 1.1 Quick Check.
Session 1.2.
Creating a Presentation Based on an Existing Presentation.
Animating Text.
Animating Slide Titles and Bulleted Lists.
Modifying the Start Timing of an Animation.
Adding Transitions.
Inserting Footers, Slide Numbers, and the Date.
Using Speaker Notes.
Checking the Spelling in a Presentation.
Previewing and Printing a Presentation.
Session 1.2 Quick Check.
Review Assignments.
Case Problems.
Tutorial 2 Adding and Modifying Text and Graphic Objects Preparing a Presentation About a Travel Company.
Session 2.1.
Understanding Graphics.
Adding a Graphic from a File.
Inserting Clip Art.
Resizing and Repositioning a Graphic.
Formatting Objects.
Adjusting the Color of a Picture.
Modifying a Graphic's Border Color, Effects, and Shape.
Applying a Style to a Graphic.
Drawing and Formatting Shapes.
Adding Text to a Shape.
Inserting and Formatting Text Boxes.
Flipping and Rotating Objects.
Session 2.1 Quick Check.
Session 2.2.
Modifying the Slide Master.
Modifying Text Placeholders.
Modifying the Font Style in the Slide Master.
Creating SmartArt Diagrams.
Creating a SmartArt Diagram.
Converting a Bulleted List into a SmartArt Diagram.
Modifying a SmartArt Diagram.
Animating Objects.
Animating Graphics.
Changing the Sequence of an Animation.
Customizing the Direction of an Animation.
Inserting Headers and Footers on Handouts and Notes Pages.
Broadcasting a Presentation.
Session 2.2 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Verbal Communication.Integrating Word, Excel, Access, and PowerPoint.
Creating Documents for a Home Care Company.
Session 1.
Object Linking and Embedding.
Embedding an Excel Chart in a Word Document.
Modifying an Embedded Object.
Linking Excel Worksheet Data to Word.
Updating Linked Objects.
Session 1 Quick Check.
Session 2.
Using Excel Data in Access.
Preparing an Excel List for Import.
Importing an Excel List into an Access Table.
Using Access Data in a Word Document.
Querying Data in an Access Database.
Exporting Query Results from Access to Word.
Session 2 Quick Check.
Session 3.
Creating a Word Outline.
Creating PowerPoint Slides from a Word Outline.
Copying and Pasting Access Query Results into a PowerPoint Presentation.
Linking an Excel Chart to a PowerPoint
Presentation.
Session 3 Quick Check.
Review Assignments.
Case Problems.
ProSkills Exercise: Verbal Communication.Appendix:
A Introduction to SkyDrive and Office Web Apps.
Sharing Files and Collaborating with Others Online.
Exploring Windows Live.
Obtaining a Windows Live ID.
Uploading Files to SkyDrive.
Using Office Web Apps.
Creating Folders and Organizing Files on SkyDrive.
Giving Permission for Access to a Folder on Your SkyDrive.
Co-Authoring with the Excel Web App.
Glossary/Index.
Task Reference.