GO! with Microsoft Office 2010 Volume 1 | |
Table of Contents | |
Common Features Chapter 1 Using the Common Features of Office 2010 | |
Scenario: Oceana Palm Grill | |
Project 1A: PowerPoint File | |
Objective 1 | Use Windows Explorer to Locate Files and Folder |
Activity 1.01 | Using Windows Explorer to Locate Files and Folders |
Objective 2 | Locate and Start a Microsoft Office 2010 Program |
Activity 1.02 | Locating and Starting a Microsoft Office 2010 Program |
Objective 3 | Enter and Edit Text in an Office Program |
Activity 1.03 | Entering and Editing Text in an Office 2010 Program |
Objective 4 | Perform Commands From a Dialog Box |
Activity 1.04 | Performing Commands From a Dialog Box |
Objective 5 | Create a Folder, Save a File, and Close a Program |
Activity 1.05 | Creating a Folder, Saving a File, and Closing a Program |
Objective 6 | Add Document Properties and Print a File |
Activity 1.06 | Adding Document Properties and Printing a File |
Project 1B: Word File | |
Objective 7 | Open an Existing File and Save it With a New Name |
Activity 1.07 | Opening an Existing File and Saving it With a New Name |
Objective 8 | Explore Options for an Application |
Activity 1.08 | Viewing Application Options |
Objective 9 | Perform Commands from the Ribbon |
Activity 1.09 | Performing Commands from the Ribbon |
Activity 1.10 | Minimizing and Using the Keyboard to Control the Ribbon |
Objective 10 | Apply Formatting in Office Programs |
Activity 1.11 | Formatting and Viewing Pages |
Activity 1.12 | Formatting Text |
Activity 1.13 | Using the Office Clipboard to Cut, Copy, and Paste |
Activity 1.14 | Viewing Print Preview and Printing a Word Document |
Objective 11 | Use the Microsoft Office 2010 Help System |
Activity 1.15 | Using the Microsoft Office 2010 Help System in Excel |
Objective 12 | Compress Files |
Activity 1.16 | Compressing Files |
Word Chapter 1 Using Graphics and Lists | |
Scenario: Laurel College | |
Project 1A: Flyer | |
Objective 1 | Create a New Document and Insert Text |
Activity 1.01 | Starting a New Word Document and Inserting Text |
Objective 2 | Insert and Format Graphics |
Activity 1.02 | Formatting Text Using Text Effects |
Activity 1.03 | Inserting and Resizing Pictures |
Activity 1.04 | Wrapping Text Around a Picture |
Activity 1.05 | Moving a Picture |
Activity 1.06 | Applying Picture Styles and Artistic Effects |
Activity 1.07 | Adding a Page Border |
Objective 3 | Insert and Modify Text Boxes and Shapes |
Activity 1.08 | Inserting a Shape |
Activity 1.09 | Inserting a Text Box |
Activity 1.10 | Moving, Resizing, and Formatting Shapes and Text Boxes |
Objective 4 | Preview and Print a Document |
Activity 1.11 | Adding a File Name to the Footer |
Activity 1.12 | Previewing and Printing a Document |
Project 1B: Information Handout | |
Objective 5 | Change Document and Paragraph Layout |
Activity 1.13 | Setting Margins |
Activity 1.14 | Aligning Text |
Activity 1.15 | Changing Line Spacing |
Activity 1.16 | Indenting Text and Adding Space After Paragraphs |
Objective 6 | Create and Modify Lists |
Activity 1.17 | Creating a Bulleted List |
Activity 1.18 | Creating a Numbered List |
Activity 1.19 | Customizing Bullets |
Objective 7 | Set and Modify Tab Stops |
Activity 1.20 | Setting Tab Stops |
Activity 1.21 | Modifying Tab Stops |
Objective 8 | Insert a SmartArt Graphic |
Activity 1.22 | Inserting a SmartArt Graphic |
Activity 1.23 | Modifying a SmartArt Graphic |
| |
Word Chapter 2 Creating Table and Letters | |
Scenario: Madison Staffing Services | |
| |
Project 2A: Resume | |
Objective 1 | Create a Table |
Activity 2.01 | Creating a Table |
Objective 2 | Add Text to a Table |
Activity 2.02 | Adding Text to a Table |
Activity 2.03 | Inserting Existing Text into a Table Cell |
Activity 2.04 | Creating Bulleted Lists in a Table |
Objective 3 | Format a Table |
Activity 2.05 | Changing the Width of Table Columns |
Activity 2.06 | Adding Rows to a Table |
Activity 2.07 | Merging Cells |
Activity 2.08 | Formatting Text in Cells |
Activity 2.09 | Changing the Table Borders |
Project 2B: Cover Letter and Resume | |
Objective 4 | Create a New Document from an Existing Document |
Activity 2.10 | Creating a Letterhead |
Activity 2.11 | Creating a Document from an Existing Document |
Objective 5 | Change and Reorganize Text |
Activity 2.12 | Recording AutoCorrect Entries |
Activity 2.13 | Creating a Cover Letter |
Activity 2.14 | Finding and Replacing Text |
Activity 2.15 | Selecting and Moving Text to a New Location |
Activity 2.16 | Inserting and Formatting a Table in a Document |
Objective 6 | Use the Proofing Options |
Activity 2.17 | Checking Spelling and Grammar Errors |
Activity 2.18 | Using the Thesaurus |
Objective 7 | Create a Document Using a Pre-Designed Template |
Activity 2.19 | Locating and Opening a Template |
Activity 2.20 | Replacing Template Placeholder Text |
Activity 2.21 | Removing Template Controls and Formatting the Resume |
Activity 2.22 | Saving a Resume as a Web Page |
| |
Word Chapter 3 Creating Research Papers and Newsletters | |
Scenario: Memphis Primary Materials | |
| |
Project 3A: Research Paper | |
Objective 1 | Create a Research Paper |
Activity 3.01 | Formatting Text and Page Numbers in a Research Paper |
Objective 2 | Insert Footnotes in a Research Paper |
Activity 3.02 | Inserting Footnotes |
Activity 3.03 | Modifying a Footnote Style |
Objective 3 | Create Citations and a Bibliography in a Research Paper |
Activity 3.04 | Adding Citations |
Activity 3.05 | Inserting Page Breaks |
Activity 3.06 | Creating a Reference Page |
Activity 3.07 | Managing Document Properties |
Project 3B: Newsletter with Mailing Labels | |
Objective 4 | Format a Multiple-Column Newsletter |
Activity 3.08 | Changing One Column Text to Two Columns |
Activity 3.09 | Formatting Multiple Columns |
Activity 3.10 | Inserting a Column Break |
Activity 3.11 | Inserting a ClipArt Image |
Activity 3.12 | Inserting a Screenshot |
Objective 5 | Use Special Character and Paragraph Formatting |
Activity 3.13 | Applying the Small Caps Font Effect |
Activity 3.14 | Adding a Border and Shading to a Paragraph |
Objective 6 | Create Mailing Labels Using Mail Merge |
Activity 3.15 | Opening the Mail Merge Wizard Template |
Activity 3.16 | Completing the Mail Merge Wizard |
Activity 3.17 | Previewing and Printing the Mail Merge Document |
| |
Excel Chapter 1 Creating a Worksheet and Charting Data | |
Scenario: Texas Spectrum Wireless | |
| |
Project 1A: Sales Report with Embedded Column Chart and Sparklines | |
Objective 1 | Create, Save, and Navigate an Excel Workbook |
Activity 1.01 | Starting Excel and Naming and Saving a Workbook |
Activity 1.02 | Navigating a Worksheet and a Workbook |
Objective 2 | Enter Data in a Worksheet |
Activity 1.03 | Entering Text and Using AutoComplete |
Activity 1.04 | Using Auto Fill and Keyboard Shortcuts |
Activity 1.05 | Aligning Text and Adjusting the Size of Columns |
Activity 1.06 | Entering Numbers |
Objective 3 | Construct and Copy Formulas and Use the Sum Function |
Activity 1.07 | Constructing a Formula and Using the Sum Function |
Activity 1.08 | Copying a Formula by Using the Fill Handle |
Objective 4 | Format Cells with Merge & Center and Cell Styles |
Activity 1.09 | Using Merge & Center and Applying Cell Styles |
Activity 1.10 | Formatting Financial Numbers |
Objective 5 | Chart Data to Create a Column Chart and Insert Sparklines |
Activity 1.11 | Charting Data in a Column Chart |
Activity 1.12 | Creating and Formatting Sparklines |
Objective 6 | Print, Display Formulas, and Close Excel |
Activity 1.13 | Changing Views, Creating a Footer, and Using Print Preview |
Activity 1.14 | Deleting Unused Sheets in a Workbook |
Activity 1.15 | Printing a Worksheet |
Activity 1.16 | Displaying, Printing, and Hiding Formulas |
Project 1B: Inventory Valuation | |
Objective 7 | Check Spelling in a Worksheet |
Activity 1.16 | Checking Spelling in a Worksheet |
Objective 8 | Enter Data by Range |
Activity 1.17 | Entering Data by Range |
Objective 9 | Construct Formulas for Mathematical Operations |
Activity 1.18 | Using Arithmetic Operators |
Activity 1.19 | Copying Formulas Containing Absolute Cell References |
Objective 10 | Edit Values in a Worksheet |
Activity 1.20 | Editing Values in a Worksheet |
Activity 1.21 | Formatting Cells with the Percent Style |
Objective 11 | Format a Worksheet |
Activity 1.22 | Inserting and Deleting Rows and Columns |
Activity 1.23 | Adjusting Column Widths and Wrapping Text |
Excel Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks | |
Scenario: Laurales Herbs and Spices | |
Project 2A: Inventory Status Report | |
Objective 1 | Use SUM, AVERAGE, MEDIAN, MIN, and MAX Functions |
Activity 2.01 | Using the SUM and AVERAGE Functions |
Activity 2.02 | Using the MEDIAN Function |
Activity 2.03 | Using the MIN and MAX Functions |
Objective 2 | Move Data, Resolve Error Messages, and Rotate Text |
Activity 2.04 | Moving Data and Resolving a # # # # Error Message |
Activity 2.05 | Rotating Text |
Objective 3 | Use COUNTIF and IF Functions and Apply Conditional Formatting |
Activity 2.06 | Using the COUNTIF Function |
Activity 2.07 | Using the IF Function |
Activity 2.08 | Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars |
Activity 2.09 | Using Find and Replace |
Objective 4 | Use Date & Time Functions and Freeze Panes |
Activity 2.10 | Using the NOW Function to Display a System Date |
Activity 2.11 | Freezing and Unfreezing Panes |
Objective 5 | Create, Sort, and Filter an Excel Table |
Activity 2.12 | Creating an Excel Table |
Activity 2.13 | Sorting and Filtering an Excel Table |
Activity 2.14 | Converting a Table to a Range of Data |
Objective 6 | Format and Print a Large Worksheet |
Activity 2.15 | Printing Titles and Scaling to Fit |
Project 2B: Weekly Sales Summary | |
Objective 7 | Navigate a Workbook and Rename Worksheets |
Activity 2.16 | Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color Worksheets |
Objective 8 | Enter Dates, Clear Contents, and Clear Formats |
Activity 2.17 | Entering and Formatting Dates |
Activity 2.18 | Clearing Cell Contents and Formats |
Objective 9 | Copy and Paste by Using the Paste Options Gallery |
Activity 2.19 | Copying and Pasting by Using the Paste Options Gallery |
Objective 10 | Edit and Format Multiple Worksheets at the Same Time |
Activity 2.20 | Grouping Worksheets for Editing |
Activity 2.21 | Formatting and Constructing Formulas on Grouped Worksheets |
Objective 11 | Create a Summary Sheet |
Activity 2.22 | Constructing Formulas that Refer to Cells in Another Worksheet |
Activity 2.23 | Changing Values in a Detail Worksheet to Update a Summary Worksheet |
Activity 2.24 | Inserting Sparklines |
Objective 12 | Format and Print Multiple Worksheets in a Workbook |
Activity 2.25 | Moving and Formatting Worksheets in a Workbook |
Activity 2.26 | Printing All the Worksheets in a Workbook |
| |
Excel Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools | |
Scenario: City of Orange Blossom Beach | |
Project 3A: Budget Pie Chart | |
Objective 1 | Chart Data with a Pie Chart |
Activity 3.01 | Creating a Pie Chart and a Chart Sheet |
Objective 2 | Format a Pie Chart |
Activity 3.02 | Applying Percentages to Labels in a Pie Chart |
Activity 3.03 | Formatting a Pie Chart with 3-D |
Activity 3.04 | Rotating a Pie Chart |
Activity 3.05 | Exploding and Coloring a Pie Slice |
Activity 3.06 | Formatting the Chart Area |
Activity 3.07 | Inserting a Text Box in a Chart |
Objective 3 | Edit a Workbook and Update a Chart |
Activity 3.08 | Editing a Workbook and Updating a Chartt |
Activity 3.09 | Inserting WordArt in a Worksheet |
Objective 4 | Use Goal Seek to Perform What-If Analysis |
Activity 3.10 | Using Goal Seek to Perform What-If Analysis |
Activity 3.11 | Preparing and Printing a Workbook with a Chart Sheet |
Project 3B: Growth Projection with Line Chart | |
Objective 5 | Design a Worksheet for What-If Analysis |
Activity 3.12 | Using Parentheses in a Formula to Calculate a Percentage Rate of Increase |
Activity 3.13 | Using Format Painter and Formatting as You Type |
Activity 3.14 | Calculating a Value After an Increase |
Objective 6 | Answer What-If Questions by Changing Values in a Worksheet |
Activity 3.15 | Answering What-If Questions and Using Paste Special |
Objective 7 | Chart Data with a Line Chart |
Activity 3.16 | Inserting Multiple Rows and Creating a Line Chart |
Activity 3.17 | Formatting Axes in a Line Chart |
Activity 3.18 | Formatting the Chart and Plot Areas |
Activity 3.19 | Preparing and Printing Your Worksheet |
| |
Access Chapter 1 Getting Started with Access Databases | |
Scenario: Capital Cities Community College | |
Project 1A: Contact Information Database with Two Tables | |
| |
Objective 1 | Identify Good Database Design |
Activity 1.01 | Using Good Design Techniques to Plan a Database |
| |
Objective 2 | Create a Table and Define Fields in a New Blank Database |
Activity 1.02 | Starting with a New Blank Database |
Activity 1.03 | Assigning the Data Type and Name to Fields |
Activity 1.04 | Renaming Fields and Changing Data Types in a Table |
Activity 1.05 | Adding a Record to a Table |
Activity 1.06 | Adding Additional Records to a Table |
Activity 1.07 | Importing Data From an Excel Workbook to an Existing Access Table |
Objective 3 | Change the Structure of Tables and Add a Second Table |
Activity 1.08 | Deleting a Table Field in Design View |
Activity 1.09 | Modifying a Field Size and Adding a Description |
Activity 1.10 | Viewing a Primary Key in Design View |
Activity 1.11 | Adding a Second Table to a Database by Importing an Excel Spreadsheet |
Activity 1.12 | Adjusting Column Widths |
Activity 1.13 | Printing a Table |
| |
Objective 4 | Create and Use a Query, Form, and Report |
Activity 1.14 | Using the Simple Query Wizard to Create a Query |
Activity 1.15 | Creating and Printing a Form |
Activity 1.16 | Creating, Modifying, and Printing a Report |
| |
Objective 5 | Save and Close a Database |
Activity 1.17 | Closing and Saving a Database |
| |
Project 1B: Student Workshops Database | |
Objective 6 | Create a Database Using a Template |
Activity 1.18 | Creating a New Database Using a Template |
Activity 1.19 | Building a Table by Entering Records in a Multiple Items Form |
Objective 7 | Organize Objects in the Navigation Pane |
Activity 1.20 | Organizing Database Objects in the Navigation Pane |
Objective 8 | Create a New Table in a Database Created with a Template |
Activity 1.21 | Creating a New Table and Changing Its Design |
Objective 9 | Print a Report and a Table in a Database Created with a Template |
Activity 1.22 | Viewing and Printing a Report |
Activity 1.23 | Printing a Table |
| |
Access Chapter 2 Sort and Query a Database | |
Scenario: Capital Cities Community College | |
Project 2A: Instructors and Courses Database | |
Objective 1: | Open an Existing Database |
Activity 2.01 | Opening and Renaming an Existing Database |
Activity 2.02 | Resolving Security Alerts and Renaming Tables |
Objective 2: | Create Table Relationships |
Activity 2.03 | Creating Table Relationships and Enforcing Referential Integrity |
Activity 2.04 | Printing a Relationship Report and Displaying Subdatasheet Records |
Objective 3: | Sort Records in a Table |
Activity 2.05 | Sorting Records in a Table in Ascending or Descending Order |
Activity 2.06 | Sorting Records in a Table on Multiple Fields |
Objective 4: | Create a Query in Design View |
Activity 2.07 | Creating a New Select Query in Design View |
Activity 2.08 | Running, Saving, Printing, and Closing a Query |
Objective 5: | Create a New Query from an Existing Query |
Activity 2.09 | Creating a New Query from an Existing Query |
Objective 6: | Sort Query Results |
Activity 2.10 | Sorting Query Results |
Objective 7: | Specify Criteria in a Query |
Activity 2.11 | Specifying Text Criteria in a Query |
Activity 2.12 | Specifying Criteria Using a Field Not Displayed in the Query Results |
Activity 2.13 | Using Is Null Criteria to Find Empty Fields |
Project 2B: Athletic Scholarships | |
Objective 8: | Specify Numeric Criteria in a Query |
Activity 2.14 | Opening an Existing Database and Importing a Spreadsheet |
Activity 2.15 | Creating Table Relationships |
Activity 2.16 | Specifying Numeric Criteria in a Query |
Activity 2.17 | Using Comparison Operators |
Activity 2.18 | Using the Between . . . And Comparison Operator |
Objective 9: | Use Compound Criteria |
Activity 2.19 | Using AND Criteria in a Query |
Activity 2.20 | Using OR Criteria in a Query |
Objective 10: | Create a Query Based on More Than One Table |
Activity 2.21 | Creating a Query Based on More Than One Table |
Objective 11: | Use Wildcards in a Query |
Activity 2.22 | Using a Wildcard in a Query |
Objective 12: | Use Calculated Fields in a Query |
Activity 2.23 | Using Calculated Fields in a Query |
Objective 13: | Calculate Statistics and Group Data in a Query |
Activity 2.24 | Using the MIN, MAX, AVG, and SUM Functions in a Query |
Activity 2.25 | Grouping Data in a Query |
| |
Objective 14: | Create a Crosstab Query |
Activity 2.26 | Creating a Crosstab Query Using One Table |
| |
Access Chapter 3 Forms, Filters, and Reports | |
Scenario: Capital Cities Community College | |
| |
Project 3A: Students and Majors | |
Objective 1: | Create and Use a Form to Add and Delete Records |
Activity 3.01 | Creating a Form |
Activity 3.02 | Adding Records to a Table by Using a Form |
Activity 3.03 | Deleting Records from a Table by Using a Form |
Activity 3.04 | Printing a Form |
Objective 2: | Create a Form by Using the Form Wizard |
Activity 3.05 | Creating a Form by Using the Form Wizard |
Objective 3: | Modify a Form in Design View and in Layout View |
Activity 3.06 | Grouping Controls and Applying a Theme to a Form in Layout View |
Activity 3.07 | Modifying a Form in Design View |
Activity 3.08 | Adding, Resizing, and Moving Controls in Layout View |
Activity 3.09 | Formatting and Aligning Controls in Layout View |
Objective 4: | Filter Records |
Activity 3.10 | Filtering Data by Selection on One Field |
Activity 3.11 | Using Filter By Form and Advanced Filter/Sort |
Project 3B: Job Openings | |
Objective 5: | Create a Report by Using the Report Tool |
Activity 3.12 | Creating a Report Using the Report Tool |
Activity 3.13 | Modifying a Report in Layout View and Printing a Report |
Objective 6: | Create Reports by Using the Blank Report Tool and the Report Wizard |
Activity 3.14 | Creating a Report by Using the Blank Report Tool |
Activity 3.15 | Creating a Report by Using the Report Wizard |
Objective 7: | Modify the Design of a Report |
Activity 3.16 | Formatting and Deleting Controls in Layout View |
Activity 3.17 | Modifying Controls in Design View |
Activity 3.18 | Aligning Controls in Design View |
Objective 8: | Print a Report and Keep Data Together |
Activity 3.19 | |
| |
| |
| |
| |
PowerPoint Chapter 1 Getting Started with Microsoft Office PowerPoint | |
Scenario: Lehua Hawaiian Tours | |
| |
| |
Project 1A: Company Overview | |
Objective 1: | Create a New Presentation |
Activity 1.01 | Identifying Parts of the PowerPoint Window |
Activity 1.02 | Entering Presentation Text and Saving a Presentation |
Activity 1.03 | Applying a Presentation Theme |
Objective 2: | Edit a Presentation in Normal View |
Activity 1.04 | Inserting a New Slide |
Activity 1.05 | Increasing and Decreasing List Levels |
Activity 1.06 | Adding Speakers Notes to a Presentation |
Activity 1.07 | Displaying and Editing Slides in the Slide Pane |
Objective 3: | Add Pictures to a Presentation |
Activity 1.08 | Inserting a Picture from a File |
Activity 1.09 | Applying a Style to a Picture |
Activity 1.10 | Applying and Removing Artistic Effects |
Objective 4: | Print and View a Presentation |
Activitiy 1.11 | Viewing a Slide Show |
Activity 1.12 | Inserting Headers and Footers |
Activity 1.13 | Printing a Presentation |
Project 1B: New Product Announcement | |
Objective 5: | Edit an Existing Presentation |
Activity 1.14 | Displaying and Editing the Presentation Outline |
Activity 1.15 | Inserting Slides from an Existing Presentation |
Activity 1.16 | Finding and Replacing Text |
Objective 6: | Format a Presentation |
Activity 1.17 | Changing Fonts, Font Sizes, Font Styles, and Font Colors |
Activity 1.18 | Aligning Text and Changing Line Spacing |
Activity 1.19 | Modifying Slide Layout |
Objective 7: | Use Slide Sorter View |
Activity 1.20 | Deleting Slides in Slide Sorter View |
Activity 1.21 | Moving Slides in Slide Sorter View |
Objective 8: | Apply Slide Transitions |
Activity 1.22 | Applying Slide Transitions to a Presentation |
Activity 1.23 | Displaying a Presentation in Reading View |
| |
PowerPoint Chapter 2 Formatting PowerPoint Presentations | |
Scenario: Fascination Entertainment Group | |
| |
Project 2A: Employee Training Presentation | |
Objective 1: | Format Numbered and Bulleted Lists |
Activity 2.01 | Selecting Placeholder Text |
Activity 2.02 | Changing a Bulleted List to a Numbered List |
Activity 2.03 | Modifying the Bulleted List Style |
Activity 2.04 | Removing a Bullet Symbol from a Bullet Point |
Objective 2: | Insert ClipArt |
Activity 2.05 | Inserting ClipArt |
Activity 2.06 | Moving and Sizing Images |
Activity 2.07 | Changing the Shape of a Picture |
Objective 3: | Insert Text Boxes and Shapes |
Activity 2.08 | Inserting a Text Box |
Activity 2.09 | Inserting, Sizing, and Positioning Shapes |
Activity 2.10 | Adding Text to Shapes |
Objective 4: | Format Objects |
Activity 2.11 | Applying Shape Fills, Outlines, and Styles |
Activity 2.12 | Applying Shape and Picture Effects |
Activity 2.13 | Duplicating Objects |
Activity 2.14 | Aligning and Distributing Objects |
Project 2B: Event Announcement | |
Objective 5: | Remove Picture Backgrounds and Insert WordArt |
Activity 2.15 | Removing the background froma Picture and Applying Soft Edge Options |
Activity 2.16 | Applying WordArt Styles to Existing Text |
Activity 2.17 | Inserting a WordArt Object |
Objective 6: | Create and Format a SmartArt Graphic |
Activity 2.18 | Creating a SmartArt Graphic from Bullet Points |
Activity 2.19 | Adding Shapes in a SmartArt Graphic |
Activity 2.20 | Creating a SmartArt Graphic Using a Content Layout |
Activity 2.21 | Changing the SmartArt Layout |
Activity 2.22 | Changing the Color and Style of a SmartArt Graphic |
Activity 2.23 | Customize the Size and Shape of a SmartArt Graphic |
Activity 2.24 | Converting a SmartArt to Text |
| |
PowerPoint Chapter 3 Enhancing a Presentation with Animation, Tables, and Charts | |
Scenario: City of Golden Grove | |
| |
Project 3A Informational Presentation | |
Objective 1: | Customize Slide Backgrounds |
Activity 3.01 | Changing the Theme Colors and Theme Fonts |
Activity 3.02 | Applying a Background Style |
Activity 3.03 | Hiding Background Graphics |
Activity 3.04 | Formatting a Slide Background with a Picture |
Activity 3.05 | Applying a Background Fill Color and Resetting the Slide Background |
Objective 2: | Animate a Slide Show |
Activity 3.06 | Applying Animation Entrance Effects and Effect Options |
Activity 3.07 | Setting Animation Timing Options |
Activity 3.08 | Using Animation Painter and Removing Animation |
Objective 3: | Insert a Video |
Activity 3.09 | Inserting a Video |
Activity 3.10 | Formatting a video |
Activity 3.11 | Editing and Compressing a Video |
Project 3B Summary and Analysis Presentation | |
Objective 3: | Create and Modify Tables |
Activity 3.12 | Creating a Table |
Activity 3.13 | Modifying the Layout of a Table |
Activity 3.14 | Modifying a Table Design |
Objective 4: | Create and Modify Charts |
Activity 3.15 | Creating a Column Chart and Applying a Chart Style |
Activity 3.16 | Creating a Line Chart and Deleting Chart Data |
Activity 3.17 | Animating a Chart |
| |
Integrated Projects Chapter 1 Integrated Projects 2010 | |
Scenario: Front Range Action Sports | |
| |
Project 1A: State Sales | |
Objective 1: | Export Access Data to Excel |
Activity 1.01 | Exporting Access Data to Excel |
Activity 1.02 | Creating and Sorting an Excel Table |
Activity 1.03 | Inserting a Total Row in an Excel Table |
Objective 2: | Create an Excel Worksheet from a Word Table |
Activity 1.04 | Formatting a Word Table |
Activity 1.05 | Copying and Pasting a Word Table into an Excel Workbook |
Activity 1.06 | Using the SUM Function and Fill Handle in Excel |
Objective 3: | Copy and Paste an Excel Chart into Other Programs |
Activity 1.07 | Creating and Formatting Charts in Excel |
Activity 1.08 | Copying and Pasting an Excel Chart into Word |
Activity 1.09 | Pasting an Excel Chart in PowerPoint |
Objective 4: | Copy and Paste an Object from PowerPoint into Excel |
Activity 1.10 | Inserting a SmartArt Graphic |
Activity 1.11 | Copying and Pasting a SmartArt Graphic |
Project 1B: Taos Memo | |
Objective 5: | Link Excel Data to a Word Document |
Activity 1.12 | Accessing Paste Special |
Objective 6: | Modify Linked Data and Update Links |
Activity 1.13 | Updating the Linked Data |
Objective 7: | Create a Table in Word from Access Data |
Activity 1.14 | Exporting an Access Table to an RTF File |
Activity 1.15 | Inserting Access Data into a Word Document |
Objective 8: | Use Access Data to Complete a Mail Merge in Word |
Activity 1.16 | Adding Records to an Access Table |
Activity 1.17 | Starting Mail Merge in Word |
Activity 1.18 | Adding Merge Fields |