GO! with Microsoft Excel Brief

For introductory computer courses on Microsoft Excel 2010 or courses in computer concepts with a lab component on Excel.

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.

Common Features Chapter 1 Using the Common Features of Office 2010 Scenario: Oceana Palm Grill Project 1A: Menu Plan

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 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 Print a File Activity 1.06 Printing a 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 Application Options 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

Objective 11 Use the Microsoft Office 2010 Help System Activity 1.14 Using the Microsoft Office 2010 Help System in Excel

Objective 12 Compress Files Activity 1.15 Compressing Files

Chapter 1 Creating a Worksheet and Charting Data Scenario: Texas Spectrum Wireless Project 1A: Quarterly Sales Report with Embedded Column Chart

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 Filling a Series with Auto Fill and Using Excel 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 in a Column Chart Activity 1.11 Charting Data in a Column Chart

Objective 6 Prepare a Worksheet for Printing and Close Excel Activity 1.12 Changing Views, Creating a Footer, and Using Print Preview Activity 1.13 Deleting Unused Sheets in a Workbook Activity 1.14 Printing a Worksheet Activity 1.15 Displaying, Printing, and Hiding Formulas

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

Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks Scenario: Laurales Herbs and Spices

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 Unvreezing 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

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 Cell Contents Activity 2.19 Copying and Pasting Cell Contents

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

Objective 12 Format and Print Multiple Worksheets in a Workbook Activity 2.24 Moving and Formatting Worksheets in a Workbook Activity 2.25 Printing All the Worksheets in a Workbook

Chapter 3 Charting Data Scenario: City of Orange Blossom Beach Project 3A: Pie Chart Objective 1 Create a Pie Chart and a Chart Sheet Activity 3.01 Calculating Percentages Activity 3.02 Using Formula AutoComplete Activity 3.03 Creating a Pie Chart with a Chart Sheet

Objective 2 Format a Pie Chart Activity 3.04 Applying 3-D to a Pie Chart Activity 3.05 Rotating Slices in a Pie Chart Activity 3.06 Exploding and Coloring a Pie Chart Activity 3.07 Formatting the Chart Area of a Pie Chart Activity 3.08 Inserting a Text Box in a Chart

Objective 3 Update a Chart and Insert WordArt Activity 3.09 Updating a Chart Activity 3.10 Inserting WordArt in a Worksheet

Objective 4 Preparing a Chart Sheet for Printing Activity 3.11 Preparing and Printing a Chart Sheet

Objective 5 Design a Worksheet for What-If Analysis Activity 3.12 Using Parentheses in a Formula Activity 3.13 Calculating a Value After an Increase

Objective 6 Perform What-If Analysis Activity 3.14 Performing What-If Analysis Activity 3.15 Using Paste Special

Objective 7 Compare Data with a Line Chart Activity 3.16 Creating a Line Chart to Compare Data

Several changes have been made to both the student text and the Annotated Instructor's Edition, based on feedback from instructors and students.

Student Text:

• Chapter Opening Page was slightly modified
• Objectives now include page references indicating where each objective is covered
• The chapter introduction presenting the scenario for the chapter is now included on this page
• Project Opening Page was redesigned to clearly outline:
• Project Activities - describing what the student will create in the project
• Project Files - outlining the starting file(s) needed and what the final project will be saved as
• Project Results - illustrating what the final project will look like
• Another Way boxes, providing students with alternative methods of completing tasks, are now presented in the margin instead of right in line with the steps of the project to avoid confusion
• NEW! Student Videos (formerly called AV-EDDs) now accompany every student textbook, not just the Office Volume 1 book
• NEW! myitlab and myitlab:grader icons now appear next to the applicable projects in the text and end of chapter material (Projects A, B, and G)
• NEW! Business Running Case is included at the end of each application, allowing students to demonstrate their understanding of skills learned over several chapters
• End-of-Chapter changes
• Concepts Assessments now includes Multiple Choice instead of Fill-in-the-blank
• Content-Based Assessments
• Project C = Skills Review (covering skills in Project A)
• Project D = Skills Review (covering skills in Project B)
• Project E = Mastering Project (covering skills in Project A)
• Project F = Mastering Project (covering skills in Project B)
• Project G = Mastering Project (covering skills in both Projects A & B) * also in Grader
• Project H = GO! Fix It NEW!
• Project I = GO! Make It NEW!
• Project J = GO! Solve It NEW! Includes task-specific rubric printed in the textbook
• Project K = GO! Solve It NEW! Includes task-specific rubric printed in the textbook
• Outcomes-Based Assessments
• Rubric
• Project L = GO! Think NEW! This was titled 'Problem Solving'
• Project M = GO! Think NEW! This was titled 'Problem Solving'
• Project N = You and GO!
• Project O = GO! Collaborate NEW! This was titled 'Group Business Running Case'

Annotated Instructors Edition:

• NEW! Now Spiral bound instead of 3-hole punched and in a binder
• NEW! Chapter Dividers now include even more useful tools for instructors:
• Team Projects
• Teaching Tips
• Discussion Topics
• Expand the Projects
• Ethical Discussion Topics
• Web 2.0 Projects

Project-Based Approach: GO!’s project-based approach clusters the learning objectives around the projects, rather than around software features. Overall, this approach teaches students to solve real problems as they practice and learn the features.

• Texts are now organized by student learning outcomes and numbered objectives and as always, there are two instructional projects per chapter
• Students learn important concepts at the teachable moment, with explanatory text woven right into the steps of the project
• NEW! Each Project Opening Page clearly outlines Project Activities (what the student will do in this project), Project Files (what starting files are needed, and what their file(s) will be saved as), and Project Results (what their finished project will look like)

Designed for ease of use for students: Based on both professor and student feedback, this text has been designed to provide clear student comprehension.

• Clear Instruction: The steps of each project are written following Microsoft^® Procedural Syntax, directing students first on where to go, then what to do when performing tasks 
• Clean Design: The pages of the GO! textbook are clean and uncluttered, with lots of screenshots for visual learners
• Sequential Pagination: Pages in the GO! textbooks are numbered sequentially, like every other textbook the student is using, instead of using letters or abbreviations
• NEW! Objectives now include page references indicating where each objective is covered
• Another Way: This boxed feature provides students with alternative methods of completing tasks. NEW! These boxes are presented in the margin instead of right in line with the steps of the project to avoid confusion
• Steps are color-coded by project and are provided to guide the students throughout
• End-of-Project Icon provides students with a clearly identifiable end point for each project, useful in self-paced or online environments
• Student Videos and Podcasts offer students multimedia tools to help them learn the material covered in the chapter

The Student CDs that come with all new copies of the book include:

• Data files needed to complete all projects in the book
• Additional Projects
• Podcasts for the most complex topics in each application
• Student Videos for each A & B Project in each chapter

Designed for ease of implementation for instructors: The GO! series’ one of a kind instructional system provides you with everything you need to prepare for class, teach the material, and assess your students.

Prepare

• Transition Guide – The authors have made it quick and easy to plan the format and activities for class.
• Syllabus Template – Includes course calendar planner for 8-, 12-, and 16-week formats.
• Assignment Sheet – One per chapter that lists all possible assignments.
• Student Data Files – Examples of homework submissions to serve as examples for students.
• PowerPoints – Slides that feature key points of each chapter.
• Online Study Guide for Students – Interactive objective-style questions based on chapter content.

Teach

Annotated Instructors Edition – Includes the entire student text, spiral-bound and wrapped with teaching notes, annotations, troubleshooting tips, etc.

• Chapter Dividers clearly outline the resources per chapter by activity level: Prepare, Teach, Assess. NEW! These now include even more useful tools for instructors:
  • Team Projects
  • Teaching Tips
  • Discussion Topics
  • Expand the Projects
  • Ethical Discussion Topics
  • Web 2.0 Projects
• Instructor File Guide lists all of the Student Data Files and instructor solution files needed for the chapter
• End of Chapter Concepts Assessments contain the answers for quick reference
• Rubric from the student text is included in the AIE with suggested weights for each of the criteria and levels of performance
• Scripted Lectures are provided to the instructor which mirror the A & B projects in each chapter and can be used for in-class instruction
• Student Videos accompany each A and B project to provide students with a multimedia version of the chapter

Assess

• Assignment Tags are scoring checklist for each assignment, including the GO! Think (formerly Problem-Solving) projects.
• Point-Counted Production Tests (PCPT’s) – A cumulative exam for each project, chapter, and application that is easy to score using the provided checklist with suggested points for each task.
• Solution Files are available in the application and in PDF format
• Annotated Solution Files are designed to help instructors very quickly and easily grade assignments
• Test Bank – This test-generating program allows instructors to add, edit, or delete questions from the test bank; analyze test results; and organize a database of exams and student results.

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois   University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.

Alicia Vargas is a faculty member in Business Information Technology at Pasadena City College.  She holds a master's and a bachelor's degree in business education from California State University, Los Angeles, and has authored several textbooks and training manuals on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.