GO! with Microsoft Office 2010 Getting Started




New product available - 9781292026749
336 pages
29 JUN 2010


For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 Applications. Teach the course YOU want in LESS TIME! The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defined projects for students and a one-of-a-kind supplements package for instructors.


GO! with Microsoft Office 2010 Getting StartedTable of Contents Common Features Chapter 1 Using the Common Features of Office 2010Scenario: Oceana Palm GrillProject 1A: Menu Plan Objective 1 Use Windows Explorer to Locate Files and FolderActivity 1.01 Using Windows Explorer to Locate Files and Folders Objective 2 Locate and Start a Microsoft Office 2010 ProgramActivity 1.02 Locating and Starting a Microsoft Office 2010 Program Objective 3 Enter and Edit Text in an Office ProgramActivity 1.03 Entering and Editing Text in an Office Program Objective 4 Perform Commands From a Dialog BoxActivity 1.04 Performing Commands From a Dialog Box Objective 5 Create a Folder, Save a File, and Close a ProgramActivity 1.05 Creating a Folder, Saving a File, and Closing a Program Objective 6 Print a FileActivity 1.06 Printing a File Project 1B: Memo Objective 7 Open an Existing File and Save it With a New NameActivity 1.07 Opening an Existing File and Saving it With a New Name Objective 8 Explore Application OptionsActivity 1.08 Viewing Application Options Objective 9 Perform Commands from the RibbonActivity 1.09 Performing Commands from the RibbonActivity 1.10 Minimizing and Using the Keyboard to Control the Ribbon Objective 10 Apply Formatting in Office ProgramsActivity 1.11 Formatting and Viewing PagesActivity 1.12 Formatting TextActivity 1.13 Using the Office Clipboard to Cut, Copy, and Paste Objective 11 Use the Microsoft Office 2010 Help SystemActivity 1.14 Using the Microsoft Office 2010 Help System in Excel Objective 12 Compress FilesActivity 1.15 Compressing Files Word Chapter 1 Using Graphics and ListsScenario: Laurel CollegeProject 1A: Flyer Objective 1 Create a New Document and Insert TextActivity 1.1 Starting a New Word Document and Inserting Text Objective 2 Insert and Format GraphicsActivity 1.2 Formatting Text Using Text EffectsActivity 1.3 Inserting and Resizing PicturesActivity 1.4 Wrapping Text Around a PictureActivity 1.5 Moving a PictureActivity 1.6 Applying Picture Styles and Artistic EffectsActivity 1.7 Adding a Page Border Objective 3 Insert and Modify Text Boxes and ShapesActivity 1.8 Inserting a ShapeActivity 1.9 Inserting a Text BoxActivity 1.10 Moving, Resizing, and Formatting Shapes and Text Boxes Objective 4 Preview and Print a DocumentActivity 1.11 Adding a File Name to the FooterActivity 1.12 Previewing and Printing a Document Project 1B: Information Handout Objective 5 Change Document and Paragraph LayoutActivity 1.13 Setting MarginsActivity 1.14 Aligning TextActivity 1.15 Changing Line SpacingActivity 1.16 Indenting Text and Adding Space After Paragraphs Objective 6 Create and Modify ListsActivity 1.17 Creating a Bulleted ListActivity 1.18 Creating a Numbered ListActivity 1.19 Customizing Bullets Objective 7 Set and Modify Tab StopsActivity 1.20 Setting Tab StopsActivity 1.21 Modifying Tab Stops Objective 8 Insert a SmartArt GraphicActivity 1.22 Inserting a SmartArt GraphicActivity 1.23 Modifying a SmartArt Graphic Excel Chapter 1 Creating a Worksheet and Charting DataScenario: Texas Spectrum WirelessProject 1A: Quarterly Sales Report with Embedded Column Chart Objective 1 Create, Save, and Navigate an Excel WorkbookActivity 1.01 Starting Excel and Naming and Saving a WorkbookActivity 1.02 Navigating a Worksheet and a Workbook Objective 2 Enter Data in a WorksheetActivity 1.03 Entering Text and Using AutoCompleteActivity 1.04 Filling a Series with Auto Fill and Using Excel Keyboard ShortcutsActivity 1.05 Aligning Text and Adjusting the Size of ColumnsActivity 1.06 Entering Numbers Objective 3 Construct and Copy Formulas and Use the Sum FunctionActivity 1.07 Constructing a Formula and Using the Sum FunctionActivity 1.08 Copying a Formula by Using the Fill Handle Objective 4 Format Cells with Merge & Center and Cell StylesActivity 1.09 Using Merge & Center and Applying Cell StylesActivity 1.10 Formatting Financial Numbers Objective 5 Chart Data in a Column ChartActivity 1.11 Charting Data in a Column Chart Objective 6 Prepare a Worksheet for Printing and Close ExcelActivity 1.12 Changing Views, Creating a Footer, and Using Print PreviewActivity 1.13 Deleting Unused Sheets in a WorkbookActivity 1.14 Printing a WorksheetActivity 1.15 Displaying, Printing, and Hiding Formulas Project 1B: Inventory Valuation Objective 7 Check Spelling in a WorksheetActivity 1.16 Checking Spelling in a Worksheet Objective 8 Enter Data by RangeActivity 1.17 Entering Data by Range Objective 9 Construct Formulas for Mathematical OperationsActivity 1.18 Using Arithmetic OperatorsActivity 1.19 Copying Formulas Containing Absolute Cell References Objective 10 Edit Values in a WorksheetActivity 1.20 Editing Values in a WorksheetActivity 1.21 Formatting Cells with the Percent Style Objective 11 Format a WorksheetActivity 1.22 Inserting and Deleting Rows and ColumnsActivity 1.23 Adjusting Column Widths and Wrapping Text Access Chapter 1 Getting Started with Access DatabasesScenario: Capital Cities Community CollegeProject 1A: Contact InformationObjective 1: Identify Good Database DesignActivity 1.01 Using Good Design Techniques to Plan a DatabaseObjective 2: Create a Table and Define Fields in a New Blank DatabaseActivity 1.02 Starting with a New Blank DatabaseActivity 1.03 Creating Fields in a TableActivity 1.04 Renaming Field in a TableActivity 1.05 Adding a Record to a TableActivity 1.06 Assigning the Data Type of a Field in Datasheet ViewActivity 1.07 Adding Additional Records to a TableActivity 1.08 Importing Data from an Excel Workbook to an Existing Access TableObjective 3: Add and Change the Structure of TablesActivity 1.09 Deleting a Table Field in Design ViewActivity 1.10 Modifying a Field Size and Description in Design ViewActivity 1.11 Setting a Primary Key and Saving a TableActivity 1.12 Adding a Second Table to a Database by Importing an Excel SpreadsheetActivity 1.13 Adjusting Column WidthsActivity 1.14 Printing a TableObjective 4: Create and Use a Query, a Form, and a ReportActivity 1.15 Using the Simple Query Wizard to Create a QueryActivity 1.16 Creating a FormActivity 1.17 Creating, Modifying, and Printing a ReportObjective 5: Save, Close, and Change the Properties of a DatabaseActivity 1.18 Changing Database PropertiesActivity 1.19 Closing and Saving a Database Project 1B: Student WorkshopsObjective 6: Create a Database Using a TemplateActivity 1.20 Creating a New Database Using a TemplateActivity 1.21 Building a Table by Entering Records in a Multiple Items FormObjective 7: Organize Database Objects in the Navigation PaneActivity 1.22 Organizing Database Objects in the Navigation PaneObjective 8: Create a New Table in a Database Created with a TemplateActivity 1.23 Creating a New Table and Changing Its DesignObjective 9: View a Report and Print a Table in a Database Created with a TemplateActivity 1.24 Viewing a ReportActivity 1.25 Printing a Table PowerPoint Chapter 1 Getting Started with Microsoft Office PowerPointScenario: Lehua Hawaiian Tours Project 1A: Company OverviewObjective 1: Create a New PresentationActivity 1.1 Identifying Parts of the PowerPoint WindowActivity 1.2 Entering Presentation Text and Saving a PresentationActivity 1.3 Applying a Presentation ThemeObjective 2: Edit a Presentation in Normal ViewActivity 1.4 Inserting a New SlideActivity 1.5 Increasing and Decreasing List LevelsActivity 1.6 Adding Speakers Notes to a PresentationActivity 1.7 Displaying and Editing Slides in the Slide PaneObjective 3: Insert and Format Pictures to a PresentationActivity 1.8 Inserting a Picture from a FileActivity 1.9 Applying a Style to a PictureActivity 1.10 Applying Artistic Effects to a PictureObjective 4: Print and View a PresentationActivitiy 1.11 Viewing a Slide ShowActivity 1.12 Inserting Headers and FootersActivity 1.13 Printing a PresentationProject 1B: New Product AnnouncementObjective 5: Edit an Existing PresentationActivity 1.14 Displaying and Editing the Presentation OutlineActivity 1.15 Inserting Slides from an Existing PresentationActivity 1.16 Finding and Replacing TextObjective 6: Format a Presentation Activity 1.17 Changing Fonts, Font Sizes, Font Styles, and Font ColorsActivity 1.18 Aligning Text and Changing Line SpacingActivity 1.19 Modifying Slide LayoutObjective 7: Use Slide Sorter ViewActivity 1.20 Deleting Slides in Slide Sorter ViewActivity 1.21 Moving Slides in Slide Sorter ViewObjective 8: Apply Slide TransitionsActivity 1.22 Applying Slide Transitions to a PresentationObjective 9: Use Reading ViewActivity 1.23 Viewing and Editing a Presentation in Reading View