Synopses & Reviews
For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.
Your Office is 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 Office bridges the gap between skill and application, and empowers students to master Office 2010 as a tool to solve problems and make decisions.
The cases progress students from learning the skills in each Office Application to using the applications as tools to make business decisions.
The unique modular structure provides 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 scenario introduces 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.
**This is a one-chapter supplement.**
About the Author
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.
Table of 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
To Create the Relationships
Creating the Queries
To Create Queries of Month’s Sales
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
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
To Complete the Inventory Analysis Report
To Create the Presentation Based on the Inventory Analysis Report
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
Problem Solve Case 1
Perform in your Career
Perform in your Career