CHAPTER 1 OVERVIEW - CSUSM



Systems Analysis and Design

Seventh Edition

End of Chapter Solutions

Chapter SEven

Output and User Interface Design

ANSWERS TO CASE-SIM: SCR ASSOCIATES

CASE-SIM: SCR ASSOCIATES

Assignments

1. Create a detail report that will display all SCR courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in a group footer.

Answers will vary. A sample report, and its design, might appear as follows:

[pic]

[pic]

2. Create a switchboard design with control buttons that lead to students, instructors, courses, course schedules, and course rosters. Allow a user to add, update, or delete records in each area. Jesse wants to see storyboards that show the proposed screens.

Students should come up with a design that is attractive and easy to understand. Lower-level screens should present a consistent design. Sample designs for the main switchboard and a student sub-form follow:

Main switchboard:

[pic]

Student form:

[pic]

3. Suggest data validation checks for data entry screens.

Answers will vary. Students should suggest any suitable design features explained in this chapter. Students might recommend several of the data validation checks described on page 317 For example, an existence check would prevent empty data fields; a data type check would prevent inappropriate data entry (such as alphabetic data in the member Number field); and a reasonableness check would set suitable limits.

4. Create a source document for an SCR mail-in registration form. Also need a design for a Web-based course registration form.

The paper form should follow the guidelines described on pages 318-319 Students should suggest designs that are easy to use, with effective caption techniques, clearly identifiable zones, and a logical flow. The Web-based form could use some of the features used in the online form shown in Figure 7-38 on page 319. These features include drop-down list boxes and input masks. In any case, the online design should provide a logical layout that is easy to understand and use.

ANSWERS TO CHAPTER EXERCISES

Review Questions

1. List and describe various types of output, including technology-based forms of information delivery.

Technology advances have had an enormous impact on how people communicate and obtain information. In addition to printed output, other forms of output include:

• Internet-based information delivery: Millions of firms use the Internet to reach new customers and markets around the world.

• E-mail: E-mail has become an essential means of internal and external business communication. Employees send and receive e-mail on local or wide area networks, including the Internet.

• Audio output: Audio output can be attached to an e-mail message or inserted as an audio clip in a document. In addition, many firms use automated systems to handle voice transactions and provide information to customers.

• Automated facsimile systems: Some firms use automated facsimile, sometimes called faxback systems, to allow a customer to request a fax using e-mail, the company Web site, or by telephone. The response is transmitted in a matter of seconds back to the user’s fax machine.

• Computer output to microfilm (COM): COM systems, such as microfilm and microfiche, capture an image of a document and produce film output. Users then can retrieve, view, and print the images.

• Computer output to laser disk (COLD): Computer output to laser disk (COLD) is a relatively new way to store images of paper documents. Using COLD technology, a paper document is scanned, and the digital image is stored on a high-density laser disk medium. COLD technology also enables rapid information retrieval of formatted information. For example, if an insurance company stores thousands of paper application forms, special software can treat the document as data and extract information from a particular column or area on the form.

• Specialized forms of output: Businesses require a variety of specialized output devices, such as retail point-of-sale terminals, automated teller machines (ATMs), special-purpose printers, plotters, digital camera, and programmable devices (such as television sets, VCRs, and microwave ovens) that produce visual output displays. (Pages 284–287)

2. Define detail reports, exception reports, and summary reports. Explain the concept of a control field and how it is used to produce a control-break report.

A detail report produces at least one line of output for every record processed. In an exception report, only those records that satisfy a specific condition are reported. A summary report displays only subtotals and totals. A control field is a field that controls the output by determining its sequence and defining a control break. A control break occurs when the value of a control field changes. A control break report is one that uses one or more control fields and generates some type of special output, such as printed subtotals or totals, at control break points. (Page 287–289)

3. Explain the concept of human-computer interaction (HCI).

Human-computer interaction describes the relationship between computers and people who use them to perform business-related tasks. HCI concepts apply to everything from a PC desktop to the main menu for a global network. HCI includes all the communications and instructions necessary to enter input to the system and to obtain output in the form of screen displays or printed reports. (Page 299)

4. Describe eight principles for a user-centered interface design.

Eight principles for a user-centered design are:

▪ Understand the underlying business functions

▪ Maximize graphical effectiveness

▪ Profile the system’s users

▪ Think like a user

▪ Use prototyping

▪ Design a comprehensive interface

▪ Continue the feedback process

▪ Document the interface design (Page 303)

5. Explain each of the data validation checks mentioned in this chapter.

Data validation checks include the following:

▪ Sequence checks are used when the data must be in some predetermined sequence.

▪ Existence checks are used for mandatory data items.

▪ Data type checks test to ensure that a data item fits the required data type.

▪ Range checks test data items to verify that they fall between a specified minimum and maximum value.

▪ Reasonableness checks identify values that are questionable, but not necessarily wrong.

▪ Validity checks are used for data items that must have certain values.

▪ Combination checks are performed on two or more fields to ensure that they are consistent or reasonable when considered together.

▪ Batch controls are totals used to verify batch input and might involve checking data items such as record counts and numeric field totals. (Page 317 and 318)

6. Describe six types of user interface controls, and provide an example of how you could use each type in a data entry screen.

Controls can include menu bars, toolbars, dialog boxes, text boxes, toggle buttons, list boxes, scroll bars, drop-down list boxes, option buttons, check boxes, command buttons, and calendar controls, among others. Controls can be used as follows:

▪ Menu bar: The main menu options display at the top of the screen in a menu bar. Some software packages allow you to create customized menu bars and toolbars.

▪ Toolbar: A toolbar contains icons or buttons that represent shortcuts for executing common commands. The commands might be navigation shortcuts or can trigger other actions.

▪ Command button: Command buttons initiate an action such as printing a form or requesting Help.

▪ Dialog box: A dialog box allows a user to enter information about a task that the system will perform.

▪ Text box: A text box can display messages or provide a place for a user to enter data.

▪ Toggle button: A toggle button is used to represent on or off status — clicking the toggle button switches to the other status.

▪ List box: A list box displays a list of choices that the user can select.

▪ Scroll bar: A scroll bar allows the user to move through the available choices when they do not all fit on the screen.

▪ Drop-down list box: A drop-down list box displays the current selection. When the user clicks the arrow, a list of the available choices displays.

▪ Option button: Option buttons, or radio buttons, represent groups of options. The user can select only one option at a time; selected options contain a black dot.

▪ Check box: A check box is used to select one or more choices from a group. A checkmark or an X represents selected options.

▪ Calendar control: A calendar control allows the user to select a date that the system will display and store as a field value. (Page 310 and 311)

7. Explain the concept of a GUI and a switchboard. How does a GUI design differ from a character-based screen design?

A GUI uses graphical objects and techniques. A well-designed GUI helps users learn and use a system effectively. Now that GUIs have become universal in application packages, users expect in-house software also to have GUIs. Unlike a character-based screen design, a GUI combines process control and data entry. A switchboard is an opening screen that introduces an application and allows users to view the main options. A switchboard contains command buttons that enable users to navigate the system and select tasks. (Pages 300, 311)

8. Explain batch and online input methods. Define source data automation and provide an example.

Using batch input, data entry is performed on a specified time schedule, such as daily, weekly, monthly, or longer. Although batch input is used in specific situations, most business activity requires online input. Online input offers immediate validation and availability of data. A popular online input method is source data automation, which combines online data entry and automated data capture using input devices such as magnetic data strips, or swipe scanners. Examples of source data automation include retail stores that use portable bar code scanners to log new shipments and update inventory data, and libraries that use handheld scanners to read optical strips on books. (Page 312)

9. What are five principles of source document design?

Principles of source document design include the following:

▪ Provide enough space, both vertically and horizontally, for users to enter the data.

▪ Indicate data entry positions clearly using blank lines or boxes and descriptive captions.

▪ Use a heading zone that contains the company name or logo and the title and number of the form.

▪ Use a control zone that contains codes, identification information, numbers, and dates that are used for storing completed forms.

▪ Use an instruction zone that contains instructions for completing the form.

▪ Use a body zone that contains captions and areas for entering variable data. If totals are included on the form, place them in a totals zone.

▪ Use an authorization zone if any signatures or approvals are required.

▪ Provide an information flow from left to right and top to bottom, to match the way users read documents naturally. (Page 318)

10. Provide four guidelines for reducing input volume.

Four guidelines for reducing input volume are:

▪ Input necessary data only. Do not input a data item unless it is needed by the system.

▪ Do not input data that the user can retrieve from system files or calculate from other data.

▪ Do not input constant data. If orders are in batches with the same date, then a user should enter the order date only once for the first order in the batch. If orders are entered online, then the user can retrieve the order date automatically using the current system date.

▪ Use codes whenever possible. Codes are shorter than the data they represent, and coded input can reduce data entry time. (Page 314 and 315)

Discussion Topics

1. Some systems analysts maintain that source documents are unnecessary. They say that all input can be entered directly into the system, without wasting time in an intermediate step. Do you agree? Can you think of any situations where source documents are essential?

The answer depends on the business processes involved. In many situations, a source document is the only way to capture and record data. In other situations, a source document is unnecessary. For example, if a school adopts an online registration system, data can be entered directly into the system. Even when not required, a source document might be desirable as a working document that allows a user to review data before entering it into the system. During interviews, observation, and other forms of fact-finding, many people find it quicker and easier to take handwritten notes, which become source documents for later data entry. Given the trend toward handheld computers, automated data capture, and voice recognition software, traditional keyboard data entry might disappear.

2. Some systems analysts argue, “Give users what they ask for. If they want lots of reports and reams of data, then that is what you should provide. Otherwise, they will feel that you are trying to tell them how to do their jobs.” Others say, “Systems analysts should let users know what information can be obtained from the system. If you listen to users, you’ll never get anywhere, because they really don’t know what they want and don’t understand information systems.” What do you think of these arguments?

Neither of these arguments, which present two extreme viewpoints, is totally justifiable. The best policy probably is somewhere between these two views. The first argument has some truth because information systems are designed for the users. When a user really needs information in the form of a long printed report, then that information must be provided. The implication about user attitudes is unfair. Users and IT professionals have a common goal — to serve the organization.

The second viewpoint is even weaker. A systems analyst should always be willing to offer suggestions. It is true that users sometimes do not know what information to ask for, and a business-oriented systems analyst can help them define their requirements.

3. Suppose your network support company employs 75 technicians who travel constantly and work at customer sites. Your task is to design an information system that provides technical data and information to the field team. What types of output and information delivery would you suggest for the system?

Answers will vary. This type of organization probably would require an information system capable of providing remote access on a 24/7 basis. Automated facsimile would give the representatives the ability to obtain printed reports, and e-mail would allow them to keep in touch. Technical support representatives would need access to an online technical library with links to relevant documents and information. An Internet-accessible knowledge base would provide strong support for the field service team. Using a Web-based system, technical support representatives could input technical data and symptoms, receive suggestions, determine parts availability, and receive service assignments. This system might be enhanced by wireless technology. Encourage students to research real-world practices, and to contact firms that provide field service to learn more about current technology applications.

4. A user interface can be quite restrictive. For example, the interface design might not allow a user to exit to a Windows desktop or to log on to the Internet. Should a user interface include such restrictions? Why or why not?

The answer depends on security issues. In a high security environment, it might be desirable to have the information system launch automatically when a user powers up a workstation. The design also might prevent users from exiting to Windows or obtaining Internet access, due to sensitive data or security concerns. This is the same type of built-in security that a diskless workstation offers. If user options are limited by hardware or software configuration, then fewer security concerns exist. Of course, no system is foolproof, and system administrators constantly must be vigilant. Ask students whether they ever worked in situations where their workstation processing or data access options were limited purposely, and how that affected their work.

Projects

1. Visit the administrative office at your school or a local company. Ask to see examples of output documents, such as computer-printed invoices, form letters, or class rosters. Analyze the design and appearance of each document, and try to identify at least one possible improvement for each.

Using the guidelines in the chapter, students should be able to suggest various improvements to the output documents they find. It might be interesting to ask students to submit their suggestions to the class and see whether other students agree or disagree with the recommendations.

2. Search the Web to find an example of an attractive user interface. Document your research and discuss it with your class.

Answers will vary. It might be interesting to ask students what criteria they think are important in determining whether an interface is “attractive” to them. Another approach might be to have the instructor choose a site and have students rate the design, using the criteria explained in this chapter.

3. Examine various application software packages to find examples of good (or bad) user interface design. Document your research and discuss it with your class.

Again, answers will vary depending on what the student thinks is “good” or “bad” design. The important thing is to share individual viewpoints and reasons. One student might see an attribute or design element that another student might ignore. If the entire class analyzes a specific software package, most design strengths and weaknesses will come to light.

4. Search your own files or review other sources to find good (or bad) examples of source document design. Document your research and discuss it with your class.

This task is similar to the previous assignment. It might be especially interesting to review documents that are familiar to the entire class, such as registration documents at the school.

ANSWERS TO APPLY YOUR KNOWLEDGE

1 North Shore Boat Sales

Situation: North Shore Boat Sales sells new and used boats and operates a Web-based boat brokerage business in Toronto. The company has grown and North Shore needs a new information system to manage the inventory, the brokerage operation, and information about prospective buyers and sellers. Dan Robeson, the owner, asked you to design samples of computer screens and reports that the new system might produce.

1. Design a switchboard that includes the main information management functions that North Shore might require. Create a storyboard with a design layout that allows customers to perform the following functions: obtain information about new boats, obtain information about used boats, send an e-mail to North Shore, learn more about the company, or review links to other marine-related sites.

Students can use their online form design skills to suggest a suitable layout. A sample follows:

[pic]

2. Prospective buyers might want to search for boats by type, size, price range, or manufacturer. Develop a screen design that would permit those choices.

A screen design might resemble the popular Web site shown here. Note the multiple search criteria.

[pic]

3. Suggest reports that might be useful to North Shore’s management.

Answers will vary. Based on the fact statement and information from the chapter, students should be able to suggest specific examples of detail, exception, and summary reports that would be valuable to North Shore’s management. Ask students to state any assumptions they used, and find out whether other class members agree.

4. Suggest the general layout for a Web-based source document that prospective sellers could use to describe their boats. The information should include boat type (sail or power), manufacturer, year, length, type of engine, hull color, and asking price.

A design might resemble the online form shown here.

[pic]

2 Terrier News

Situation: Terrier News is a monthly newsletter devoted to various breeds of terriers and topics of interest to terrier owners and breeders. Annie West, the editor and publisher, asked you to help her design a system to enter and manage the hundreds of classified ads that Terrier News publishes. Some ads are for dogs wanted; some are for dogs for sale; and some offer products and services.

1. Design a suitable source document for ads that are telephoned or mailed in.

Answers will vary. Students should apply the skills and principles they learned in the chapter. Students should consider form layout, including the placement of a heading zone, instruction zone, body zone, and authorization zone. Information flow also is important.

2. Explain user-centered design principles in a brief memo to Annie.

Good user-centered design depends on eight basic principles, which are:

▪ Understand the underlying business functions

▪ Maximize graphical effectiveness

▪ Profile the system’s users

▪ Think like a user

▪ Use prototyping

▪ Design a comprehensive interface

▪ Continue the feedback process

▪ Document the interface design

3. Suggest at least four user interface design guidelines that could be used for the new system.

A list of user interface design guidelines includes the following:

▪ Focus on basic objectives

▪ Build an interface that is easy to learn and use

▪ Provide features that promote efficiency

▪ Make it easy for users to obtain help or correct errors

▪ Minimize input data problems

▪ Provide feedback to users

▪ Create an attractive layout and design

▪ Use familiar terms and images

4. Suggest several types of controls that might be used on the switchboard you plan to design. Explain why you chose each control, and create a storyboard that shows the switchboard layout.

|Control |Reason |

|Menu bar |A menu bar displays the main options at the top of the screen. |

|Toolbar |A toolbar contains icons or buttons that represent shortcuts for executing |

| |common commands. |

|Command button |Command buttons initiate an action such as printing a form or requesting Help. |

|Dialog box |A dialog box allows a user to enter information about a task that the system |

| |will perform. |

|Text box |A text box can display messages or provide a place for a user to enter data. |

|Toggle button |A toggle button is used to represent on or off status — clicking the toggle |

| |button switches to the other status. |

|List box |A list box displays a list of choices that the user can select. |

|Scroll bar |A scroll bar allows the user to move through the available choices. |

|Drop-down list box |A drop-down list box displays the current selection; when the user clicks the |

| |arrow, a list of the available choices displays. |

|Option button |Option buttons, or radio buttons, represent groups of options. The user can |

| |select only one option at a time; selected options contain a black dot. |

|Check box |A check box is used to select one or more choices from a group. Selected |

| |options are represented by a checkmark or an X. |

|Spin bar |A spin bar allows a user to flip through various choices that appear in a |

| |window. |

|Calendar control |A calendar control allows the user to select a date that the system will |

| |display and store as a field value. |

3 Sky-High Internet Services

Situation: Sky-High Internet Services is a leading Internet service provider in a metropolitan area. The new customer billing system has caused an increase in complaints. Tammy Jones, the office manager, asked you to investigate the situation. After interviewing data entry operators and observing the online data input process, you are fairly certain that most errors occur when data is entered.

1. Write a brief memo to Tammy explaining the importance of data validation during the input process.

Students should understand that when it comes to data validation, an ounce of prevention is worth a pound of cure. A data validation check improves input quality by testing the data and rejecting any entry that fails to meet specified conditions. Responses should point out that the best defense against incorrect data is to identify and correct errors by using data validation checks before they enter the system.

2. Suggest at least three specific data validation checks that might help reduce input errors.

Students can suggest at least eight types of data validation checks into the input process.

a) Sequence checks, which are used when the data must be in some predetermined sequence.

b) Existence checks, which are used for mandatory data items such as Social Security number.

c) Data type checks, which test to ensure that a data item fits the required data type, such as numeric or alphabetic.

d) Range checks, which test data items to verify that they fall between a specified minimum and maximum value.

e) Reasonableness checks, which identify values that are questionable, but not necessarily wrong.

f) Validity checks, which are used for data items that must have certain specified values.

g) Combination checks, which are performed on two or more fields to ensure that they are consistent or reasonable when considered together.

h) Batch controls, which are totals used to verify batch input. Batch controls might check data items such as record counts and numeric field totals.

3. Would a batch input system offer any advantages? Write a brief memo to Tammy stating your views.

Students should understand that batch input involves data entry on a specified time schedule, such as daily, weekly, monthly, or longer. As an Internet service provider, Sky-High must set up and configure customer accounts at any time, and a batch input method would interfere with customer service and delay Internet access for new accounts. Monthly billing for established accounts, however, might be done on a batch basis, on a designated day (such as the last business day of the month). If Sky-High provides multi-level accounts, where a specific number of dollars buys a specific number of hours, assume that the company has industry-specific ISP software that automatically tracks usage and billing — so the results could be applied to customer accounts in a batch at month’s end. In this sense, batch input offers the advantage of a scheduled, automated procedure that is unlikely to introduce human data entry errors. Even so, Sky-High probably will have to input various changes or adjustments manually, so data validation checks still will be needed in many situations.

4. Suppose that Sky-High is predicting 25 percent annual growth, on a current base of 90,000 customers. If the growth pattern holds, how many customers will Sky-High have in three years? If it takes about 12 minutes to enter a new customer into the system, how many additional data entry operators will be needed to handle the growth next year? Assume that an operator works about 2,000 hours per year. Also assume a 30 percent annual attrition rate for existing customers.

In this assignment, students must calculate staffing needs based on specific assumptions. Answers might vary, depending on assumptions used. The main goal is to have students apply realistic methods and accurate calculation skills. The sample spreadsheet shown below is based on the facts stated in the assignment, and fractional staffing is rounded up or down to a whole number.

[pic]

4 Castle Point Antique Auction

Situation: Castle Point Antique Auction operates a successful Web site that offers an auction forum for buyers and sellers of fine antiques. Monica Creighton, the owner, asked you to help her design some new documents and reports.

1. Suggest the general layout for a Web-based source document that prospective bidders would submit. The information should include user ID, password, name, address, telephone, e-mail address, item number, bid offered, and method of payment (money order, check, American Express, MasterCard, or Visa).

Suggest to students that they view real-world examples of Internet auction site documents before completing their own designs. The Web has numerous examples, and excellent models are readily available. This chapter contains many tips and suggestions about form design. You might ask class members to critique various sites and develop a checklist of do’s and don’ts for designing the required documents.

2. Suggest the general layout for a Web-based source document that prospective sellers could use to describe their antiques. The information should include the user ID, password, item, dimensions, origin, condition, and asking price.

This assignment is similar to the previous one. Again, suggest to students that they view real-world examples of Web-based item description forms for auction sites. Also remind them to apply tips and suggestions described in the chapter. Answers will vary — the objective is to come up with realistic, effective examples that demonstrate good design principles.

3. Write a brief memo to Monica explaining the difference between detail reports, exception reports, and summary reports. Suggest at least one example of each type of report that she might want to consider.

For each report, student responses should include characteristics and examples similar to the following.

|Report Type |Characteristics |Castle Point Examples |

|Detail |A detail report produces one or more lines of output |Castle Point probably requires an overall |

| |for each record processed. Each line of output printed|transaction report that would show each |

| |is called a detail line. All the fields in the record |auction sale. Information on the detail line |

| |do not have to be printed, nor do the fields have to |might include date, time, item, price, payment|

| |be printed in the sequence in which they appear in the|method, and other specific data about the |

| |record. A detail report should provide totals for |transaction. |

| |numeric fields, using a control-break field to | |

| |determine the subtotal groupings. | |

|Exception |An exception report displays only those records that |The company might be interested in a variety |

| |meet a specific condition or conditions. Exception |of exception reports. Examples might include a|

| |reports are useful when the user wants information |report on items that were sold or offered |

| |only on records that might require action, but does |above (or below) a specific price level; |

| |not need to know the details. |transactions that took place at peak Internet |

| | |usage periods; or buyer or seller information |

| | |for certain types of items. In each case, |

| | |management wants to focus on specific |

| | |information to support marketing analysis or |

| | |decision-making. |

|Summary |Summary reports are used by managers who want to see |Castle Point managers might want to see |

| |total figures rather than supporting details. |various summary reports, depending on their |

| | |needs. Examples might include an overall daily|

| | |transaction total, the total number of items |

| | |offered at auction each day, the total number |

| | |of bidders, and so on. |

4. Suppose Castle Point wants to print a catalog of current items. How long would it take to print a list of 2,500 items, at five items per page, on a laser printer rated at 20 ppm?

Students should start by dividing the 2,500 items by five items per page, to arrive at a total of 500 pages. At 20 ppm, it would take 25 minutes (500/20) to print the catalog.

ANSWERS TO CASE STUDIES

New Century Health Clinic

Assignments

1. Dr. Jones has asked you to create a monthly Claim Status Summary report. He wants you to include the insurance company number, the patient number and name, the procedure date, the procedure code and description, the fee, the date the claim was filed, the amount of the claim, the amount of reimbursement, and the amount remaining unpaid. He wants you to group the data by insurance company number, with subtotals by company and grand totals, for each numeric field. When you design the report, make sure to include printer spacing charts, a mock-up report, and a report analysis form.

During the requirements modeling in Chapter 3, students were asked to prepare interview questions for New Century employees, and sample responses were provided for instructor use. One of the people interviewed was Tom Capaletti, who handles insurance processing. Tom mentioned that he had a problem with the Claim Status Summary, because it took so much time to prepare the information and to put the unpaid claims into the four aging brackets. Now students have the opportunity to design the Claim Status Summary to which Tom referred. A sample of a printer spacing chart, a mock-up report, and a report analysis form follow.

a. Printer spacing chart:

| |NEW CENTURY HEALTH CLINIC | |

| |CLAIM STATUS SUMMARY | |

| |MONTH OF JULY, 2007 | |

| | | | | | |

| | | | | | |

|INSURANCE COMPANY |PATIENT |PROCEDURE |CODE |PROCEDURE |DATE |

|NUMBER |NAME |DESCRIPTION | |DATE |CLAIM FILED |

|------------------ | | | | | |

| |---------------------------- |------------------- |------- |----------------- |-----------------|

| | | | | |- |

| | | |AMOUNT OF | | |

| | | |CLAIM |AMOUNT OF |AMOUNT |

| |PATIENT NUMBER |FEE |------- |REIMBURSEMENT |UNPAID |

| |------------- |----- | |------------- |----------- |

| | | | | | |

|XXX |XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |XXXXXXXXXXXXXXXXXXX |XXX.XX |Z9/99/99 |Z9/99/99 |

| |XXXXX |ZZ9.99 |Z,ZZ9.99 |Z,ZZ9.99 |Z,ZZ9.99 |

| | | | | | |

| |XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |XXXXXXXXXXXXXXXXXXX |XXX.XX |Z9/99/99 |Z9/99/99 |

| |XXXXX |ZZ9.99 |Z,ZZ9.99 |Z,ZZ9.99 |Z,ZZ9.99 |

| |SUBTOTALS FOR COMPANY XXX |--------------- |--------- |--------------- |-----------------|

| | |Z,ZZ9.99 |ZZ,ZZ9,99 |ZZ,ZZ9.99 |ZZ,ZZ9.99 |

| | | | | | |

| | | |TOTAL UNPAID|0-30 DAYS: |ZZ,ZZ9.99 |

| | | |BY AGING |31-60 DAYS: |ZZ,ZZ9.99 |

| | | |BRACKET |61-90 DAYS: |ZZ,ZZ9.99 |

| | | | |OVER 90 DAYS: |ZZ,ZZ9.99 |

| | | | | | |

|XXX |XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |XXXXXXXXXXXXXXXXXXX |XXX.XX |Z9/99/99 |Z9/99/99 |

| |GRAND TOTALS |----------------- |--------- |--------------- |---------------- |

| | |Z,ZZ9.99 |ZZ,ZZ9.99 |ZZ,ZZ9.99 |ZZ,ZZ9.99 |

| | | |TOTAL UNPAID|0-30 DAYS: |ZZZ,ZZ9.99 |

| | | |BY AGING |31-60 DAYS: |ZZZ,ZZ9.99 |

| | | |BRACKET |61-90 DAYS: |ZZZ,ZZ9.99 |

| | | | |OVER 90 DAYS: |ZZZ,ZZ9.99 |

| | | | | | |

b. Report mock-up:

| |NEW CENTURY HEALTH CLINIC | |

| |CLAIM STATUS SUMMARY | |

| |MONTH OF JULY, 2007 | |

| | | | | | |

|INSURANCE COMPANY |PATIENT |PROCEDURE |PROCEDURE |PROCEDURE |DATE |

|NUMBER |NAME |DESCRIPTION |CODE |DATE |CLAIM FILED |

|---------------------| | | | | |

|------ |-------------------------------- |----------------------|---------------|---------------------|------------------|

| | |--- |--- |---- |-------- |

| |PATIENT NUMBER |FEE |AMOUNT OF |AMOUNT OF |AMOUNT |

| | | |CLAIM |REIMBURSEMENT |UNPAID |

| | | | | | |

|123 |John Q. Smith |Physical Examination |32145.00 |2/10/04 |2/12/04 |

| |11221 |150.90 |165.85 |150.90 |0.00 |

| | | | | | |

| |John Doe |Blood Test |91762.00 |4/05/99 |4/06/99 |

| |13133 |50.00 |55.99 |50.00 |0.00 |

| | |------------ |---------------|----------------- |----------------- |

| |SUBTOTALS FOR COMPANY 123 |200.90 |-- |200.90 |0.00 |

| | | |221.84 | | |

| | | | | | |

|124 |Bob Johnson |X-ray |43567.00 |2/13/04 |2/16/04 |

| |43532 |100.00 |115.50 |100.00 |15.50 |

| | | | | | |

| | | | | | |

| | | | | | |

| | |------------ |---------------|----------------- |---------------- |

| |SUBTOTALS FOR COMPANY 124 |100.00 |-- |100.00 |7,048,24.00 |

| | | |115.50 | | |

| | | | | | |

| | | |TOTAL |0 - 30 DAYS: |1,230.99 |

| | | |UNPAID BY AGING|31 - 60 DAYS: |3,789.95 |

| | | |BRACKET |61 - 90 DAYS: |1,157.34 |

| | | | |OVER 90 DAYS: |2,100.95 |

| | | | | | |

| | | | | | |

| | |----------------------|---------------|---------------------|------------------|

| |GRAND TOTALS |--- |--- |-- |----0.00 |

| | |300.90 |337.34 |300.90 | |

| | | | | | |

| | | |TOTAL |0 - 30 DAYS: |62,530.99 |

| | | |UNPAID BY AGING|31 - 60 DAYS: |88,789.95 |

| | | |BRACKET |61 - 90 DAYS: |91,157.34 |

| | | | |OVER 90 DAYS: |42,110.95 |

c. Report analysis form:

SYSTEM DOCUMENTATION

NAME OF SYSTEM DATE PAGE 1 of 1

New Century Health Clinic April 5, 2007

ANALYST PURPOSE OF DOCUMENTATION

Sally Student Monthly Claim Status Analysis

FIELD FIELD TYPE LENGTH

Insurance Company Number Numeric 3

Patient Number Alphanumeric 5

Patient Name Alphanumeric 30

Procedure Date Numeric 8

Procedure Code Alphanumeric 5.2

Procedure Description Alphanumeric 20

Fee Numeric 5.2

Date Claim Filed Numeric 8

Amount of Claim Numeric 6.2

Amount of Reimbursement Numeric 6.2

Amount Unpaid Numeric 6.2

Unpaid 0 - 30 Days Numeric 6.2

Unpaid 31 - 60 Days Numeric 6.2

Unpaid 61 - 90 Days Numeric 6.2

Unpaid over 90 Days Numeric 6.2

COMMENTS

Report heading includes month and year of report.

Column headings are stacked in two rows separated by dashed lines and are repeated on each page.

Two detail lines are printed for each record.

Records are grouped by Insurance Company Number.

At each control break, subtotals are printed for each numeric monetary field.

At the end of the report, grand totals are printed for each numeric monetary field.

The report is printed on single-ply, standard stock paper.

One copy of the report is printed for each associate.

FREQUENCY

The report is generated monthly, typically on the first weekday of the following month for distribution during the first week.

ATTACHMENTS

A printer spacing chart and a mock-up report are attached.

2. Design the daily appointment list and a monthly statement using a printer spacing chart or graph paper. Include a mock-up report and a report analysis form for each report.

The design should follow the general guidelines described on pages 318 and 319. Students should consider overall layout, report headings, page headings, column headings, alignment, and spacing. The appointment list will not require numeric totals, subtotals, or footings.

The following figure is a sample design for the daily appointment list based on the manual form that was described earlier in the textbook (see Chapter 3 of the Instructor’s Manual, which contains the New Century fact-finding summary and a sample of the form).

PAGE 9

NEW CENTURY HEALTH CLINIC

DAILY APPOINTMENT LIST

DATE: PROVIDER:

TIME PATIENT SERVICE

-------- ------------ ---------------- -----------------------------------------------------------------------

99:99 XX XXXXXXXXXXXX XXXXXXXXXXXXXXXX 99999.99 XXXXXXXXXXXXXXXX

99:99 XX XXXXXXXXXXXX XXXXXXXXXXXXXXXX 99999.99 XXXXXXXXXXXXXXXX

99:99 XX XXXXXXXXXXXX XXXXXXXXXXXXXXXX 99999.99 XXXXXXXXXXXXXXXX

The mock-up for the daily appointment list shown in the following figure is based on the form that was described in Chapter 3.

NEW CENTURY HEALTH CLINIC

Daily Appointment List

Date: 1/11/08 Provider: Dr. Garcia

Time Patient Service __________________

8:00 am John Frick 99385 - Initial preventive maintenance evaluation

8:30 am Amelia Johnson 97022 - Diathermy treatment

9:00 am Jan Riley 99450 - Basic life exam

9:30 am Susan Creighton 99401 - Preventive med. counseling

10:00 am Hospital conference

4:00 pm Bill Monroe 97022 - Whirlpool treatment

5:00 pm Dictate reports

A sample report analysis form for the daily appointment list follows:

| |

|SYSTEM DOCUMENTATION |

|System Name |Date |Page 1 of 1 |

|New Century Health Clinic |January 11, 2008 | |

|Analyst |Purpose of documentation |

|Joan James |Daily Appointment List Report Analysis |

| |

|Field Data Type Field Length |

|Page Number Numeric 1 |

|Provider Alphanumeric 20 |

|Date Numeric 8 |

|Time Alphanumeric 6 |

|Patient First Name Alphanumeric 12 |

|Patient Last Name Alphanumeric 16 |

|CPT Code Numeric 7 |

|Procedure Description Alphanumeric 20 |

| |

|COMMENTS: |

|1. Print a separate report for each provider, with two copies. One copy is sent to the provider; the other copy is kept at the |

|reception desk. |

|2. For all appointments on the specified date, print a line with appointment time, patient first and last name, CPT code, and |

|procedure description. |

|3. The report is printed on stock, 8½ x 11 paper. |

| |

|FREQUENCY: |

|The report is printed and distributed to each provider daily at 5 p.m. |

The following figure is a sample design for the monthly statement based on the manual form that was described in Chapter 3.

PAGE 9

NEW CENTURY HEALTH CLINIC

STATEMENT

TO: XXXXXXXXXXXX XXXXXXXXXXXXXXXX DATE: 99/99/99

XXXXXXXXXXXXXXXXXXXXXXXXX PRIOR BALANCE: ZZZ,ZZ9.99

XXXXXXXXXXXXXXXXXXXX, XX 99999 CHARGES: ZZZ,ZZ9.99

ACCOUNT 99999 NEW BALANCE: ZZZ,ZZ9.99

Please return the top portion with your payment. Retain this portion for your records.

Date Patient Code Service Fee Balance

-------- ------------ ---------------- -------- -------------------- ---------- ------------------------------------------------------------------------------------

99/99/99 XXXXXXXXXXXX XXXXXXXXXXXXXXX 99999.99 XXXXXXXXXXXXXXXXXX ZZZ,ZZ9.99 ZZZ,ZZ9.99

99/99/99 XXXXXXXXXXXX XXXXXXXXXXXXXXX 99999.99 XXXXXXXXXXXXXXXXXX ZZZ,ZZ9.99 ZZZ,ZZ9.99

The mock-up for the daily appointment list shown in the following figure is based on the form that was described in Chapter 3.

| NEW CENTURY HEALTH CLINIC |

|407 Court Street |

|Fullerton, CA 99690 |

|999-123-4567 |

| |

| | | | |

|To: Andrew Stevens |Date: |3/3/08 | |

|65 East Melody Lane |Prior Balance: |125.50 | |

|Fullerton, CA 99690 |Charges: |220.00 | |

| |Payments |280.00 | |

|Account 13224 |New Balance: |65.50 | |

| | | | |

|--------------------------------------------------------------------------------------------------------------- |

|Please return the top portion with your payment. Retain this portion for your records. |

| |

|Date |Patient |Code |Service |Fee |Balance |

| | | | | |125.50 |

|2/4/08 |Maria Stevens |99201.00 |New patient evaluation |100.00 |225.50 |

|2/4/08 |Maria Stevens |92283.00 |Color vision exam |25.00 |250.50 |

|2/13/08 | | |Insurance payment |CR 80.00 |170.50 |

|2/20/08 |Andrew Stevens |93015.00 |Cardiovascular stress test |95.00 |265.50 |

| | | | | | |

| | | | | | |

|2/23/08 | | |Patient payment |CR 200.00 |65.50 |

A sample report analysis form for the daily appointment list follows:

| |

| |

|SYSTEM DOCUMENTATION |

|System Name |Date |Page 1 of 1 |

|New Century Health Clinic |January 11, 2008 | |

|Analyst |Purpose of documentation |

|Joan James |Analysis of monthly statement |

|Field Data Type Field Length |

|Patient First Name Alphanumeric 12 |

|Patient Last Name Alphanumeric 16 |

|Appointment Date Numeric 8 |

|CPT Code Numeric 7 |

|Procedure Description Alphanumeric 20 |

|Household Address Alphanumeric 25 |

|Household City Alphanumeric 20 |

|Household State Alphanumeric 2 |

|Household ZIP Code Numeric 5 |

|Household Number Numeric 5 |

|MTD Charges Numeric 8 |

|MTD Payments Numeric 8 |

|Fee Numeric 7 |

|Payment Amount Numeric 8 |

|Prior Balance Numeric 8 |

|New Balance Numeric 8 |

|Balance Numeric 8 |

| |

|COMMENTS: |

|1. In the top portion of the statement, print: |

|a. First Name, Last Name, Household Address, Household City, Household State, Household ZIP Code, Household number. |

|b. Current Date, Prior Balance, MTD Charges, MTD Payments, new Balance |

|2. For each service fee or payment, print Appointment Date, Patient First Name, Patient Last Name, CPT Code, Procedure Description, and|

|Balance. |

|3. The report is produced on preprinted stock, 8½ x 11, suitable for window envelopes. |

| |

|FREQUENCY: |

|The report is printed and mailed on the last business day of each month. |

3. Determine the data required for a new patient. Design an input source document that will be used to capture the data and a data entry screen to input the information.

If students developed a list of data elements in Chapter 4 (see New Century case study Assignment 3 on page 329), they should refer to it now. Otherwise, they can use the sample list provided. Each data element should link to an item in the input source document. A sample list of data elements follows:

Patient Data:

Patient First Name

Patient Last Name

Patient Date of Birth

Relationship Code

LAST EXAM DATE

Household Data:

Household First Name

Household Last Name

Household Address

Household City

Household Zip

Household Home Phone

Household Work Phone

Employer Group Number

In addition to these data elements, a typical input form might request a Social Security number, and information on medical history, allergies, insurance, and other data necessary to set up a patient’s medical file. In laying out the new patient form, students should follow the guidelines for source document design. They should pay particular attention to designing the form’s captions (Figure 7-36 on page 319), document zones (see Figure 7-37 on page 319), and information flow. The data entry screen should follow the guidelines on pages 315–317, with special attention to the suggestions in Figure 7-39 on page 320. The screen form should resemble the paper source document so it will be easy for a user to transfer the information from the paper form to the computer-based screen form.

4. What data validation checks would the clinic need for the new patient data entry screen? Write a brief memo with your recommendations.

Students might suggest several of the data validation checks described on page 317 and 318. For example, an existence check would prevent empty data fields; a data type check would prevent inappropriate data entry (such as alphabetic data in the Social Security Number field); and a reasonableness check would set suitable limits in other fields.

Personal Trainer, Inc.

Assignments

1. Create a detail report that will display all Personal Trainer courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in a group footer.

A sample report design follows, with a sample of the printed report.

[pic]

[pic]

2. Create a switchboard design with control buttons that lead to members, fitness instructors, activities and services, schedules, and fitness class rosters. Allow a user to add, update, or delete records in each area.

Answers will vary. A sample switchboard is shown below:

[pic]

3. Suggest context-sensitive and specific Help for the switchboard and lower-level menus and forms. Prepare storyboards that show the proposed screens. Also suggest at least six types of data validation checks for data entry screens.

As the chapter explains on page 307, context-sensitive Help offers assistance for the task in progress. Figures 7-23 on page 306 and 7-27 on page 308 provide examples of context-sensitive Help. A sample of context-sensitive Help for the Personal Trainer system might include the following:

|Area |Specific Task |Suggested Help |

|Members |Add a Member |Remind user that the SSN is a primary key, and will|

| | |not allow duplicates. If the member is already in |

| | |the system, the message “This Member Already |

| | |Entered” will be displayed. |

| |Delete a Member |Inform user that, without specific confirmation, |

| | |the system will not allow a member to be deleted if|

| | |that member currently is registered in one or more |

| | |courses. The user first must click the button |

| | |labeled “OK to delete member and cancel courses.” |

| |Update Member Information |Inform user about various data validation checks |

| | |that apply to fields in this area. |

A list of specific Help topics might include the following:

▪ Calendar functions

▪ Course minimum and maximum sizes

▪ Daily backup procedures

▪ Input masks

▪ Listing courses

▪ Lookup functions

▪ Missing information

▪ Previewing a report

▪ Report titles and content

▪ System maintenance

Students should list any six of the data validation checks described on pages 317 and 318. These include sequence checks, existence checks, data type checks, range checks, reasonableness checks, validity checks, combination checks, and batch controls.

4. Design a mail-in source document that members can use to register for fitness classes. Also design a Web-based registration form.

Answers will vary. Students should follow the guidelines in the chapter and create designs that are attractive and easy to use. The textbook provides several examples of source documents and Web forms that can be used as samples. Also refer students to the SWL case, beginning on page 331, for examples of paper source documents. Figure 7-38 on page 319 provides an example of a Web-based subscription form that could provide design ideas for the Personal Trainer registration form.

Video Superstore

Assignments

1. Design a weekly operations summary report that will include overall data on rentals, new customers, late charges, and anything else you think a store manager might want to review. Be sure to include numeric activity and dollar totals.

Answers will vary. Students should review the summary report shown in Figure 7-6 on page 290, and the SWL summary report shown in Figure 7-43 on page 333. With regard to additional data that a manager might want, encourage students to think about cost-benefit issues such as overtime, unusual expenses, inventory problems, employee absenteeism, or customer complaints.

2. Design a data entry screen for entering new members.

A data entry screen design should follow the principles discussed in the chapter, and can include menu bars, toolbars, dialog boxes, text boxes, toggle buttons, list boxes, scroll bars, drop-down list boxes, option buttons, check boxes, command buttons, and calendar controls, among others. It would be a good idea to include a system-generated member number, similar to the design used in Figures 7-34 on page 315 and 7-35 on page 316.

A sample screen follows:

[pic]

3. Design a video rental input screen. In addition to the video data, the video rental form must include the following fields: Member Number, Name, and Date.

Answers will vary. A sample screen might appear as follows:

[pic]

4. Suggest at least three data validation checks that might help reduce input errors for the video rental system.

Students might suggest several of the data validation checks described on page 317. For example, an existence check would prevent empty data fields; a data type check would prevent inappropriate data entry (such as alphabetic data in the Member Number field); and a reasonableness check would set suitable limits in the Fee field.

ANSWERS TO CHAPTER CAPSTONE CASE: SoftWear, Limited (SWL)

1. Review the mock-up report shown in Figure 7-50. When Carla showed this report to Mike Feiner, director of human resources, he said that he wanted to see the data grouped by the type of ESIP deduction with the appropriate subtotals. Carla wants you to modify the report design to satisfy his request. You can use Microsoft Access, a report generator, or simply construct a sample layout using any Word processing or drawing program. Be sure to show the placement and grouping of all fields.

This issue is similar to the one raised in Case in Point 7.4 on page 321. The first question is whether screen design is an ergonomic issue that can affect productivity and user satisfaction. Clearly, screens that are attractive, well laid out, and intuitive are likely to please users who will probably make fewer input errors and be more productive. What about users designing their own screens? Is it okay to permit some degree of personal preference or should a standard policy be used? Ask students what they think. The best answer might be “it depends.” A systems analyst’s job typically is to set the boundaries for individual preference. If possible, users should be allowed to control their work environment as long they do not adversely affect the information system, the data itself, or other users.

The key question involves the issue of user-driven design. As the textbook points out, the best results usually occur when users manage their own information needs. Unfortunately, it is difficult to design a system that is both powerful and flexible enough for users to operate without special training and support. To get a better idea of what users really want, you can ask, “If you could design your own screens, what would they look like?” Depending on the responses, it might be possible either to build in the specific elements or, even better, to design screens that would give users some flexibility as to the look and feel. Many companies allow users to customize their Microsoft Windows interface by selecting background colors, icon arrangement, and similar visual design features that do not affect data security or integrity issues.

2. Carla Moore also wants employees to have an online information request form that they can use to learn more about ESIP options and request up-to-date balances for their ESIP accounts. Follow the guidelines and suggestions in this chapter, and design an online screen form for Carla.

Answers will vary — the main objective is to demonstrate an understanding of good form and screen design. Guidelines for source document design are covered on pages 318 and 319, and several samples of online forms are provided, including the Web-based subscription form shown in Figure 7-38 on page 319. Carla wants the paper form and the online form to allow employees to obtain more information about ESIP options and request up-to-date balances for current investments. With these objectives in mind, ask students to lay out a paper form first. They should design clearly defined zones, an obvious place to enter personal information, and check boxes for user choices, where possible. The form should be easy to understand, and follow the guidelines suggested in the chapter. The online form is part of an overall user interface for an employee information access system, and students should apply the user interface design guidelines explained in the chapter.

When designing input screens, students should apply good data entry screen design principles, which are explained on pages 315–317. It is possible that one or more data checks might be used to avoid input errors, as explained on pages 317 and 318. The screen layout should resemble the source document, so users will not be confused.

3. In addition to being available online, Carla wants the information request form to be available as a paper source document, which can be used by employees who do not have easy access to the online form. Follow the guidelines and suggestions in this chapter, and design a paper source document for Carla.

Answers will vary, but the main point is that the source document should follow the same overall design layout as the online form. Source document design is discussed on pages 318–320.

4. Carla wants an update on usability, how users read on the Web. Review the material in this chapter and visit the Web site shown in Figure 7-39 on page 320, and any others that provide more information on this topic. Summarize the results of your research in a memo to Carla.

Numerous articles and sources of information about usability are available on the Web. Encourage students to use search techniques described in Part 5 of the Systems Analyst’s Toolkit, and especially to explore the invisible Web. The IBM and Microsoft sites also will provide additional information and reference material.

Manage the SWL Project

1. One of your most important activities will be to identify project tasks and determine when they will be performed. Before you begin, you should review the SWL case in this chapter. Then follow these steps:

(a) Start by identifying at least ten tasks that the SWL team needs to perform to fulfill the objectives of this chapter.

An answer might include tasks listed in the Chapter Introduction Case, and other examples of tasks found in the SWL case or elsewhere in the chapter. A sample answer follows:

Task List

• Determine what printed output users will need

• Determine what screen output users will need

• Determine how input will enter the system

• Identify all the input devices that will interact with the system

• Develop necessary output controls and security

• Consider basic principles of human-computer interaction

• Develop guidelines for effective user interface design

• Design detail reports

• Design exception reports

• Design summary reports

• Calculate printing volume and time

• Design effective source documents

• Develop various checks to minimize input errors

(b) Now analyze the tasks to determine the order in which they should be performed. You can start by dividing your list into two groups and then numbering each task. The first group should contain concurrent tasks that can be performed at any time because they are not dependent on other tasks. The second group should contain sequential tasks that cannot be performed until one or more other tasks have been completed.

Answers will vary. A sample answer follows:

|Concurrent Tasks |Sequential Tasks |

|1. Determine what printed output users will need |8. Design detail reports |

|2. Determine what screen output users will need |9. Design exception reports |

|3. Determine how input will enter the system |10. Design summary reports |

|4. Identify all the input devices that will interact with the |11. Calculate printing volume and time |

|system | |

|5. Develop necessary output controls and security |12. Design effective source documents |

|6. Consider basic principles of human-computer interaction |13. Develop various checks to minimize input errors |

|7. Develop guidelines for effective user interface design | |

(c) Next, for each sequential task, identify the specific task or tasks that must be completed before this task can begin.

Answers will vary. A sample answer follows:

|Sequential Tasks |Predecessor Tasks |

|8. Design detail reports |1,2,3,4,5,6,7 |

|9. Design exception reports |8 |

|10. Design summary reports |9 |

|11. Calculate printing volume and time |10 |

|12. Design effective source documents |1,2,3,4,5,6,7 |

|13. Develop various checks to minimize input errors |1.2.3.4.5.6,7 |

2. Visit sad7e/swlproject and explore one or more links in the SWL project management resources library. Your instructor may assign a specific topic or allow you to choose a topic on your own. Write a brief summary of your research and what you learned about project management.

Answers will depend on the topics chosen. Instructors are encouraged to challenge students with tasks that require critical thinking skills. Instructors also can require students to use Open Workbench, the free project management planning tool, which can be downloaded and installed using the link in the Features section on the Student Study Tool CD-ROM.

3. Visit the Features section on your Student Study Tool CD-ROM, where you can learn more about Microsoft Project and Open Workbench, an open-source project management program that you can download and install.

The Features section on the Student Study Tool CD-ROM includes user guides and Web links for Microsoft Project and Open Workbench. Instructors can demonstrate Microsoft Project if it is available, and show students how to download and install Open Workbench. Instructors also can create additional assignments that use project management software skills in a systems development environment.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download