Explain why automatic validation is performed

Assignment Help Accounting Basics
Reference no: EM131459645

Explain why automatic validation is performed when data is first entered into a computer

a) Databases are designed to reduce the work of program development. Name FOUR different features that achieve this aim.

b) State the FOUR job titles of people who perform the following work in a LARGE computer installation:
i Creates user accounts
ii Corrects the logic in a development program
iii Decides the policy of the computer department

iv Interviews administration staff in order to define the users' needs for a new system

c) Draw a configuration diagram to show how information flows in a PC between the control unit, CPU, main memory and peripherals. Mark in directions of flow.
d) A person sends a message without any attachment to a business colleague using electronic mail. State FOUR items of information, other than the message itself, that would travel with the message.
e) State FOUR purposes of producing a Feasibility Study for a new computer system.
f) i Distinguish between DATA and PROGRAM
ii Distinguish between DATA and PARAMETER
g) State the name of a SPECIAL PURPOSE program and give THREE tasks it would perform.
h) Distinguish between LOW-LEVEL and HIGH-LEVEL program languages. Give the name of ONE high-level language and state the type of problems it is used to solve.
i) Write down FOUR characteristics of an ink-jet printer.
j) List FOUR precautions that a computer user should take to protect data held on CD.

2. Select ANY FOUR of the following methods of data capture.
For EACH, describe a REALISTIC business application that uses that method and would be BEST suited for it. A full answer is required for 5 marks. In EACH case, give reasons WHY the method is the best.
a) Barcode scanning
b) Keyboard
c) MICR
d) OCR
e) OMR
f) Touch screens

3. A general database is to be used to record details relating to payments made by subscribers to a magazine. ALL answers to this question must refer to THIS APPLICATION.

Name a particular database program you will use in answering this question. Give your answers in GENERAL terms and not a list of keys to be pressed.

a) i Define the terms field, file and record carefully, making clear distinctions between them.
ii Give a SINGLE example of EACH for this magazine application.

b) State ONE data type other than character/numeric (or variations of these) that could be used in a database. Give an example of its use in this magazine application.

c) Describe how the structure of the database is first defined BEFORE any data is entered.

d) Explain IN DETAIL how a list could be printed of all subscribers who have not paid their fees in full. Your answer should state the particular fields that would be necessary for this to be possible.

4. a) Consider the following FOUR types of printer:

Barrel/drum Dot-matrix Inkjet Laser

For EACH of the situations listed below, choose a DIFFERENT printer from these four and explain WHY it is the MOST appropriate for that particular task.

i To print copies for the 15 members of the Board of a 30-page report to read before a meeting. ii To print electricity bills in one run for distribution to 50,000 customers.

iii To print receipts at a petrol station when petrol is purchased.

iv To allow a student at home to produce multi-coloured diagrams as part of their coursework.

b) i Explain why a plotter is more suitable than a printer in some applications. Describe, in detail, an application where a plotter would be most useful.

ii Select and name a particular type of plotter. Explain how it is able to produce its output.

A clear, labelled diagram of the plotter may help you here.

5. A large furniture store wishes to send a ‘mailshot' to all of its previous customers to encourage more purchases. Each customer will receive a personal letter giving details of new products. Each letter will have the customer's name, address and the name of the previous item purchased. A data file already exists that includes the customer's details with the item names and dates of purchase. There is also a code for the type of customer (e.g. B = business, P = private buyer). Once the mailshot starts, it must run uninterrupted.

a) Select and state the name of a commercial word-processing package. Explain how this particular package could have been used to create the original data file.

b) Explain how a common letter can be created that includes different data for each customer. Give a brief sample letter.

c) Suppose that the company wished to target only private buyers. Explain how the mailshot could be restricted AUTOMATICALLY to just these customers.

d) The mailshot creates hundreds of letters. Describe TWO ways in which the envelopes could be addressed with the minimum of human effort.

6. The diagram below shows a spreadsheet model for the running costs within a particular organisation over the period January to September (grouped in quarter year periods) and for its four main departments.

 

A

B

C

D

E

1

 

 

EXPENDITU

 

 

2

DEPARTMENT

Jan-Mar

Apr-Jun

Jul-Sep

TOTALS

3

Personnel

2138.12

2243.5

2113

 

4

Production

5312.85

5691.44

5878.5

 

5

Purchasing

2634

2866

2555

 

6

Sales

3457.89

3945.22

4123.55

 

In this question, explain HOW EACH of the following tasks printed below can be achieved when you set up this model. Your answers can be either a series of commands or an explanation involving the selections from menus. Your answer MUST use the most efficient method of achieving each task.

State the name of the spreadsheet program to which your answer relates.

a) In column E, for each Department, total the sales for January to September.

b) Show ALL numeric values as 2-decimal places.

c) The word EXPENDITURE is in C1. Explain WHY this word has been cut short by the program and how this can be corrected.

d) Headings in row 2 over the figures are to be moved to the right hand end of each cell.

e) Introduce an extra column between D and E. In this column, display estimated figures for the period October to December. These are to be calculated as the average of the two previous columns but should be increased by 10%.

Reference no: EM131459645

Previous Q& A

  Leading sport management agencies in the world

Take a look at the jobs performed by 3 of the leading sport management agencies in the world:

  Describe an important problem faced by society today

Provide your own analysis by asking-and answering-a relevant question from at least three domains of thinking.

  Calculate what happened to the unemployment rate last year

Which of the following would change the natural rate of unemployment? Calculate what happened to the unemployment rate last year?

  What is retailing

What is retailing? Retailing refers to the activities involved in selling merchandise to ultimate consumers.

  How will you approach the physician community

How will you approach the physician community and get their buy-in to increase immunization efforts with their patient populations?

  How do retailers select target markets

How does a retailer develop a marketing strategy? A retailer develops a marketing strategy based on its goals and strategic plans.

  What type of insight will the swot provide

What are someinternal shortcomings of the organization's social media activities (In what areas is the organization is lacking)?

  Different from workers compensation

How is Alfac the same and different from workers compensation. Need two similarities and four differences.

  What are the two components of a markup

What are the two components of a markup? A markup consists of the product's cost and an amount added by the retailer to determine its selling price.

  Transportation economics

As a supply chain consultant for a global company one has to be aware of the extra costs of importing goods into the US.

Reviews

len1459645

4/12/2017 3:25:20 AM

Explain why automatic validation is performed when data is first entered into a computer a) Time allowed: Three hours (plus an extra ten minutes’ reading time at the start – do not write anything during this time) b) Answer ALL sections of Question 1 and any THREE questions chosen from Questions 2 to 6 c) Question 1 carries 40 marks and each other question carries 20 marks. Marks for sections of questions are shown in [ ] d) The number of marks allocated for each section should determine the length of your answer and the amount of time you spend on it. Generally ONE point gains ONE mark and is rarely achieved by one-word answers. Spend about one hour on Question 1 e) Note carefully that where some questions require details of how hardware or software achieves its task, descriptions of user actions will NOT earn marks

Write a Review

 

Similar Q& A

  Prepare harley-davidson statement of cash flows

Prepare Harley-Davidson's statement of cash flows for the year ended December 31, 2004.

  A process used by a company to help identify the risks

a process used by a company to help identify the risks that it faces and to develop responses to those risks that

  Stackhouse international inc completed its first year of

stackhouse international inc. completed its first year of operations on june 30 2010. the firms income statement for

  The brodie corporation acquired bonds with a par value

On March 31, 2010, the Brodie Corporation acquired bonds with a par value of $400,000 for $425,800.

  Balance sheets-assuming that principal payments

Assume that on December 1, 2013, your company borrowed $15,000, a portion of which is to be repaid each year on November 30. Specifically, your company will make the following principal payments: 2014, $2,000; 2015, $3,000; 2016, $4,000; and 2017,..

  Prepare statements of cash receipts and disbursements

on janurary 2 2007 the s.h. park company installed a brandnew 87000 special molding machine for producing a new

  Determining the division of net income or net loss

What factors should be considered in determining the division of net income or net loss?

  Data concerning the recent periods activity in the prep

data concerning the recent periods activity in the prep department the first processing department in a company that

  Novas diamond bracelet was stolen in 2011 she originally

novas diamond bracelet was stolen in 2011. she originally paid 9800 for the bracelet but it was worth considerably more

  Preparation of the corporate tax return

The attachment financial statements have been provided by your client B4 INC. as a staff accountant at bellows and batten, you are to prepare the work papers used for preparation of the corporate tax return B4 INC, is a calendar year C corporation

  Information protection and privacy-debt covenants

Based on the e-Activity, evaluate the circumstances that contributed to the privacy violation, the consequence to the company to the breach, and management's response to the breach, indicating the appropriateness of the response.

  Capital budgeting analysis

Capital budgeting investments are feasible if, after capital budgeting analysis, the:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd