O'Brien CoverManagement Information Systems 4/e - James A. O'Brien
Online Learning Center 

Chapter 3: Solving Business Problems with Information Systems



Application Exercises
Answers to Application Exercises

1. Systems Study Report

Study an information system described in a case study in this text or one used by an organization in which you have access. Write up the results in a system study report. Make a presentation to the class based on the results of your system study. Use the outline in Figure 3.32 as a table of contents for your report and the outline of your presentation. Use presentation software and/or overhead transparencies to display key points of your analysis.

Responses will vary.

2. Village Inn Restaurants: Using the Systems Approach

Village Inn Restaurant is a national chain of coffee shop restaurants. Typically a waitress takes your order on a paper form inserts it into a small terminal connected to an in-store network server and enters appropriate data about your order. The computer produces a paper printout of your order in the kitchen for the cooks calculates your bill and prints the details of your order on the paper order form. This form is then returned to your table. When you are ready to leave you give this form to the cashier who keys data about your payment into a point-of-sale terminal.

Assume that some customers are complaining about slow service which the cooks blame on incorrect orders by waitresses. Use the concepts of the systems approach as illustrated in Figure 3.2 that we discussed in Section I of this chapter to answer the following questions:

  1. What specific steps would you take to study this problem and propose a solution?

    All of the steps in the systems approach would have to be used to study this problem and propose a solution.

  2. What are three questions you would ask in a system study interview?

    Students answers will vary here. However this may be a general idea of what they might include.
    1. What do you think the problem is?
    2. What do you think would be good alternatives to solve the problem?
    3. What benefits would materialize from your suggested solution.


  3. What do you think the problem(s) is (are)? Why?

    The system was probably developed with little if any input or feedback from the end users.

  4. What are two possible solutions you can think of? What are their advantages and disadvantages?

    Responses will vary.

  5. If you had to choose one solution what would it be? Why did you choose it?

    Responses will vary

  6. How would you implement your solution?

    Responses will vary.


3. ABC Department Stores: End User Spreadsheet Development

Use an electronic spreadsheet and follow the basic activities of the end user spreadsheet application development process in Figure 3.33. Create the ABC in Figure 3.34 using the formulas shown in Figure 3.35. The basic parameters (control variables) in the spreadsheet are the amount of money initially invested the ratio of expenses to revenue the tax rate and the rate of growth in revenue. These parameter values are placed in a control area at the top of the spreadsheet so they can be identified and changed easily to see their impact on the other calculations.

Other formulas simply reflect that profit is revenue minus expenses and after-tax profit is profit minus taxes. The sum and average functions complete to final two columns of the spreadsheet.

  1. Enter $1 000 for 1997 sales 60 percent for the ratio of expenses to revenue 40 percent for the tax rate and 10 percent for the rate of revenue growth. Notice how the spreadsheet as shown in Figure 3.34 is instantly generated and displayed. Store and print this spreadsheet.

    Click here to download Microsoft Excel spreadsheet.

  2. Use the spreadsheet you created to perform what-if analysis. Change the 1997 revenue the revenue growth rate the expense ratio or tax rate and observe the impact on profits. (For example increase revenue for 1997 by $1 000 increase expenses to 65 percent of revenue and decrease taxes to 25 percent of profit.) Print a copy of the spreadsheet with the results of these changes then make at least on more set of changes to values of your own choosing and print a copy of those results as well.

    Click here to download Microsoft Excel spreadsheet.

  3. Create graphics displays of parts of the spreadsheet you developed and get printouts of your graphs. Figure 6.36 shows examples of the kinds of graphs that might be generated. Make changes to your spreadsheet parameter values and note how the graph results change to reflect these changes.

    Click here to download Microsoft Excel spreadsheet.

  4. Write a short explanation of what happened when you did a what-if analysis and its implications for a managerial end user.

    Responses will vary.


4. Student Scores: End User Database Development

Use a database management software package and follow the basic activities of the end user database development process in Figure 3.37. Create a Student Exam Scores Database Table to store the sample data in Figure 3.38. Each student record includes the student's name Social Security number gender and grades for three exams.

  1. Create the Student Exam Scores table enter the data records for the seven students shown below and get a printed listing of the Student Exam Scores table.

    See Data/Solution Disk or
    click here to download the Microsoft Access Database


  2. Edit the Student Exam Scores file by changing at least two exam scores and add at least one new student record. Choose any values you want for these changes and additions. When you have completed these changes get another printed listing of the Student Exam Scores table.

    See Data/Solution Disk or
    click here to download the Microsoft Access Database


  3. Use a database query to retrieve a printed listing of all students whose score on the first exam was 85 or higher similar to Figure 3.39.

    See Data/Solution Disk or
    click here to download the Microsoft Access Database


  4. Create a print a report showing the exam scores and total points earned by students sorted in ascending order by total points similar to Figure 3.40.

    See Data/Solution Disk or
    click here to download the Microsoft Access Database




HomeChapter IndexPreviousNext

Begin a search: Catalog | Site | Campus Rep

MHHE Home | About MHHE | Help Desk | Legal Policies and Info | Order Info | What's New | Get Involved



Copyright ©1998 The McGraw-Hill Companies. All rights reserved.Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.
For further information about this site contact mhhe_webmaster@mcgraw-hill.com.


Corporate Link