Sky-High Internet Services-Apply your Knowledge

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. 

Answer:

MEMORANDUM

To: Tammy Jones

From: Roxanne Bagtong

Date: April 18, 2018

Subject: Importance of Data Validation

Dear Tammy,

Data Validation is very important and plays a major role during the input process. Validating a data can be done in so many different ways. Data Validation is performed before entering the system. It also helps checking the data or values inputted by the users.

It is also important to validate data so that we can ensure the accuracy and correctness of the information. It can also help in avoiding problems or errors in the future.     

Roxanne Bagtong

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

Answer:

• Data type Check- It tests to ensure that a data item fits the required data type. For example, a numeric field must have only numbers or numeric symbols, and an alphabetic field can contain only the characters A through Z (or a through z).
• Combination Check- It is performed on two or more fields to ensure that they are consistent or reasonable when considered together. For example,if an order input for 30 units of a particular item has an input discount rate applicable only for purchases of 100 or more units, then the combination is invalid; either the input order quantity or the input discount rate is incorrect.
• Validity Check- It is used for data items that must have certain values. For example, if an inventory system has 20 valid item classes, then any input item that does not match one of the valid classes will fail the check.

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

Answer:

MEMORANDUM

To: Tammy Jones

From: Roxanne Bagtong

Date: April 18, 2018

Subject: Advantages of Batch Input System

Dear Tammy,

Good Day! 
As for my opinion, batch input system offer some advantages. It may includes, (1) Collecting and entering of data can be done offline, (2) entering of data can be done by someone in the company but at least trained, (3) processing can be done very quickly, (4) The cost of batch input system is less expensive than online input system, (5)Sharing of batch system for multiple users.
Though, I site only few of the advantages of the batch input system but still this system is a great useful in a company and also for you. 

Roxanne Bagtong

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 client or the customers will most likely increased in the next 3 years. But, since there is an issue regarding on time dealing with the data entry, there should be an additional entry operators or data encoders that would handle the growth every year.