Introduction to Problem Solving with Microsoft Office 2003 - PowerPoint PPT Presentation


PPT – Introduction to Problem Solving with Microsoft Office 2003 PowerPoint presentation | free to download - id: 15d78b-ZDc1Z


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation

Introduction to Problem Solving with Microsoft Office 2003


Introduction to Problem Solving with Microsoft Office 2003 ' ... Microsoft 2003. Suite of programs including Word, Excel, Access, and PowerPoint. Introduction ... – PowerPoint PPT presentation

Number of Views:25
Avg rating:3.0/5.0
Slides: 21
Provided by: CSI
Learn more at:


Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Introduction to Problem Solving with Microsoft Office 2003

Introduction to Problem Solving with Microsoft
Office 2003
  • Youve got to seize the opportunity if it is
    presented to you.
    Clive Davis

About This Book andMicrosoft 2003
  • Focus of book
  • How to use Microsoft Office 2003 to
  • Organize ideas and information
  • Solve business problems
  • Manage data
  • Problem-solving concepts and tasks
  • Microsoft 2003
  • Suite of programs including Word, Excel, Access,
    and PowerPoint

Sections of the Book
  1. Organizing and Communicating Information
  2. How to Solve Problems with Excel
  3. How to Solve Problems with Access
  4. Integration
  5. Capstone Projects

Section 1 Organizing and Communicating
  • Managing files
  • Conducting business research on the Web
  • Composing, formatting, and distributing business
    documents (Word) and presentations (PowerPoint)

Section 2 How to Solve Problems with Excel
  • Spreadsheet program used to display, analyze, and
    manipulate numeric data
  • Widely used in business to support decision making

Section 3 How to Solve Problems with Access
  • Database program used to maintain, organize, and
    retrieve related data, and then sort, filter, and
    display the information to serve business needs
  • Supports decision making

Section 4 Integration
  • The ability to share information among programs
  • Main advantage of using Office
  • How to make data transportable and universal by
    using HTML and XML documents on their own and
    incorporated into Access databases and Excel
  • How to integrate information from Word,
    PowerPoint, Excel, and Access to create
    sophisticated documents

Section 5 Capstone Projects
  • Pose realistic business problems
  • Ask you to use the tools described in the book to
    solve the problem

Taking aProblem-Solving Approach
Problem Recognition
  • Recognize and identify the problem
  • Describe and analyze the problem

Analyzing the Problem
Analyzing the Problem
  • Data gathering
  • Consider credibility, reliability, and accuracy
  • Pre-processing
  • Manipulate data into appropriate format
  • Cleansing
  • Identify and correct data corruption
  • Filtering
  • Remove data that isnt useful or necessary

Problem Statement
  • Key characteristic
  • Some missing piece of information is identified
    that is required to solve the problem or make a

Analyzing the Solution
Understanding the Problem
  • What data is needed and what data or information
    is already known?
  • Is the data or information reliable and accurate?
  • What is the likely range of potential solutions?
  • What types of output are required? (e.g., single
    value, table, printed report, Web page)

Formulating a Solution Plan
  • Plan how to use Office by considering the steps
    you need to take to solve the problem
  • Numerical calculation
  • Determining if data meet specific criteria
  • Organizing information or results in a specific
  • Combining several of these steps
  • Place data in well-organized, easy-to-understand

Implementing the Solution
  • Input data
  • Process data
  • Depends on the problem and the proposed solution
  • Configure desired output

Implementing the SolutionWhat You Must Know
  • Spreadsheets
  • How to correctly write formulas and functions and
    use spreadsheet tools
  • Databases
  • What kind of information is stored in the
    database and how it is organized
  • Business documents and presentations
  • How to organize and articulate the information so
    that it meets the needs of your audience

Evaluating the Solution
  • Check the results to ensure they are correct

  • You work in the human resources department of
    McNamara Construction Inc. a construction
    company. Although employees receive complete
    benefit information when first hired , they
    frequently are unaware of the many benefits
    available to them other than health insurance.
    You task is to design a newsletter to keep
    employees informed of the many benefits provided.
  • Benefits available
  • Vacation and sick days accrual policy
  • Flexible spending accounts
  • 401 K and retirement benefits
  • Maternity and Family Paid Leave
  • Online training for OSHA certifications