For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. Your Officeis the Office Applications textbook written for instructors who want more than a 'skill & drill' book that enables students to learn discreet tasks but fails to illustrate the big picture of how these skills work together. Your Officebridges the gap between skill and application, and empowers students to master Office 2010 as a tool to solve problems and make decisions. The casesprogress students from learning the skills in each Office Application to using the applications as tools to make business decisions. The unique modular structureprovides a strong foundation for students through practice in each workshop and then synthesizes the objectives covered over two workshops, challenging students to really retain what they learned as opposed to learning and then forgetting soon after. The series scenariointroduces a large global business (the resort and spa) made up of smaller businesses (golf pro shop, spa, restaurants, event planning, etc) featured in the cases that run throughout all four applications. This approach gives students a solid understanding of how an organization works by exposing them to how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions. For a behind-the-scenes look at Your Office, visithttp://www.youtube.com/user/YourOffice2010 **This is a one-chapter supplement.**

Amy S. Kinser, Esq., Series Editor
Amy holds a B.A. degree in Chemistry with a Business minor and a J.D. from the Maurer School of Law both at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past eleven years teaching technology at the Kelley School of Business in Bloomington, Indiana.   Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University.  She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.

Contents

Advanced Problems Module 1

Workshop 1 : Business Problem Solving

Prepare Case: Golf Nook Clothing Store Sales, Inventory and Customer Analysis

Define the Business Problem

Planning Steps to Solve the Problem

Problem Definition

To Create the Relationships

Creating the Queries

Information Requirements

To Create Queries of Month’s Sales

Intrinsic Functions

To Create Query of Total Month’s Sales

To Create Query of Current Inventory

To Create Query of Cumulative Sales

To Create Query of Starting Inventory

To Combine Queries to Compute Percentage

To Create a Query of Percentage of Starting Inventory Sold

Exporting Data to Excel for Analysis and Charting

Analysis and Charting

Create a Report of the Problem Solution

To Complete the Sales Analysis Report

Analysis Presentation of Recommended Action

To Create the Presentation Based on the Sales Analysis Report

Inventory Analysis

Problem Definition

To Create Query of Annual Demand by Product

To Create Query of Annual Sales by Product

To Export Data to Excel for Analysis and Calculations

Analysis Report

To Complete the Inventory Analysis Report

Analysis Presentation

To Create the Presentation Based on the Inventory Analysis Report

Customer Analysis

Problem Definition

To Create Query of Customers That Have Made a Purchase

To Create Query of Customers That Have Not Made a Purchase

To Create Query of Customers and their E-mails

To Create Query of Customers That Have Made a Popular Product Purchase

To Create Query of Customers That Have Not Made a Popular Product Purchase

To Create E-mail Messages to Customers That Have Not Made a Purchase

To Create Letters to Customers That Have Not Made a Purchase

To Complete the Customer Analysis Report

To Create the Presentation Based on the Customer Analysis Report

Concept Check

Key Terms

Visual Summary

Problem Solve

Problem Solve Case 1

Perform

Perform in your Career

Perform in your Career