Your Office
Getting Started with Advanced Cases for Microsoft Office 2010
Published on 22. November 2012
Book
Paperback/Softback
128 pages
978-0-13-267549-9 (ISBN)
Description
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.**
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.**
Reviews / Votes
Instructor Reviews of the Your Office Series"...(Your Office is what) we have been waiting for. One that takes the students to the level of business, the way it is in the real world. Now the students can make a smooth transition from the classroom to that career." - Carla Jones, Middle Tennessee State University
"teaches students the skills they need in the workplace by having students create realistic documents, spreadsheets, presentations, and databases for "real world" scenarios. Students learn by practicing skills over multiple chapters and are given an opportunity to do critical thinking while working on assignments." - Rich Cacace, Pensacola State College
"Has students thinking, problem solving and invites them to look past the book ... adds value by leading them to understand where they could apply these skills in their "day to day" life." - Karen Allen, Community College of RI
"takes students through the entire process from learning the necessary features to actually being able to create documents without much direction--just like they will need to do at work!" - Susan Holland, Southeast Community College
"It is a case-based Office application text that does a great job of covering just what we need. The organization of the text is fantastic and the end-of-chapter assessments are the best I have seen in a long time." - Gina Jerry, Santa Monica College
"Is a system that allows the student a heap of hands on work, with easy to follow instructions and simply explained figures. The hands-on experience is then translated to real world situations." - Linda Fried, University of CO-Denver
"Allows the students to learn application concepts (the Why!) and not just the pointing and clicking." - Susan Fry, Boise State Univ.
"...pulls it all together. It starts with basic examples, provides practice, integrates their acquired knowledge and permits the student to perform well." - David Largent, Ball State Univ.
More details
Other editions
New editions
Amy Kinser | Brant Moriarity | Jennifer Nightingale
Your Office
Advanced Problem Solving Cases for Microsoft Office 2013
Book
08/2014
Pearson
€39.67
Shipment within 15-20 days
Persons
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.
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.
Content
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
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