VIDEO SUPERSTORE

Video Superstore has hired you to design two online data entry screens. Based on what you

know about the operation of a video rental store, complete the following 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.

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

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.

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

Existence Check 

Reasonable Check 

Validity Check

PERSONAL TRAINER, INC.

Personal Trainer, Inc., owns and operates fitness centers in a dozen Midwestern cities. The

centers have done well, and the company is planning an international expansion by opening

a new “supercenter” in the Toronto area. Personal Trainer’s president, Cassia Umi, hired an

IT consultant, Susan Park, to help develop an information system for the new facility.

During the project, Susan will work closely with Gray Lewis, who will manage the new

operation.

Background

Following the decision to use an in-house team to develop a design prototype, Susan

began to work on the physical design for Personal Trainer’s new information system. At this

stage, she is ready to begin working with Gray on the output and user interface design.

Together, Susan and Gray will seek to develop a user-centered design that is easy to learn

and use. Personal Trainer users will include managers, fitness instructors, support staff, and

members themselves.

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.

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.

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 rules for data entry screens.

Data validation

• Simple range validation 
• Constraint validation
• Code validation
• Cross-reference validation
• Structured validation
• Data-type validation

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

NEW CENTURY HEALTH CLINIC

CASE STUDY ONE

The associates at New Century Health Clinic approved your recommendations for a new

computer system. Your next step is to develop a design for the new system, including output and user interface issues.

Background

To complete the output and user interface design for the new information system at New

Century, you should review the DFDs and object-oriented diagrams you prepared previously, and the rest of the documentation from the systems analysis phase. Perform the following tasks.

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 a mock-up report and a report analysis form.

ANSWER

2. Design the daily appointment list and a monthly statement to make it readable and visually attractive. Include a mock-up report and a report analysis form for each report.

ANSWER

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

ANSWER

Clients Name, Weight, Height, Blood Pressure, Relative, Birth Date, Age, Symptoms, is required for the source document.

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

ANSWER

The most important is the reasonableness check, to verify the logical meaning of the input. A validity check should be used to identify the validity of information that the user input and to avoid future errors. Sequence check and existence check also should be used so that there were no mandatory fields will be accepted. 

CASTLE POINT ANTIQUE AUCTION

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.

Question 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). 

ANSWER:

Question 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. 

ANSWER:

The layout for this Web-based source document that describes the antiques or products is that it should be well organized. Elders usually fond of antique so in order prevent them from giving unpleasantness, the layout must be well-arranged or well- organize.

Question 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. 

ANSWER:

Question 4:

Suggest several types of data validation checks that could be used when input data is entered.

ANSWER:

SKY-HIGH INTERNET SERVICE

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. 

Question 1:

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

ANSWER:

Question 2:

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

ANSWER:

Question 3:

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

ANSWER:

Hi Tammy, batch input system is useful and an advantage specially when dealing with a predefined schedule, such as determining the financial status or accounting. Online data entry is an advantage also in handling transactions that needs immediate response, so there should be an analysis of which system will be using in a particular component.

Question 4:

Suppose that Sky-High is predicting 25% 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% annual attrition rate for existing customers.

ANSWER:

The customers most likely to be increased in the next three years. Since there is a time issue during customer data entry, there should be an additional entry operators to handle the growth each year.

NORTH SHORE BOAT SALES AND TERRIER NEWS

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.

Question 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.

ANSWER:

SWITCHBOARD

STORYBOARD

Question 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.

ANSWER:

Question 3:

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

ANSWER:

• Provide a new web page for the annual reports of the North Shore Boat Sales, it may help the customers to understand what the company is heading on.
• Another web page for the customer's ideal boat and also he can customize the color of what the boat he wants

Question 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.

ANSWER:

Terrier News

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.

Question 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.

ANSWER:

Question 2:

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

ANSWER:

Question 3:

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

ANSWER:

The New System must have at least the following of this Guidelines :

• Visibility of system status
• User control and freedom
• Consistency and standards
• Error prevention
• Flexibility and efficiency of use
• Help users recognize, diagnose and recover from errors

Question 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.

ANSWER: