Definition

• Disk formatting is the process of preparing a data storage media for initial use

Reasons:

• To make a disk blank for reuse
• To make it compatible with another operating system
• to create tracks and sectors for first time use

Advantages

•  A touch screen is very intuitive
• Easy to use as the user simply touches what they see on the display
• Save space as no keyboard or mouse is required.
• Touch monitors can even be mounted on the wall.
• Touching a visual display of choices requires little thinking and is a form of direct manipulation that is easy to learn.
• Touch screens are the fastest pointing devices.
• Touch screens have easier hand-eye coordination than mice or keyboards.
• No extra workspace is required as with other pointing devices.
• Touch screens are durable in public access and in high volume usage

Disadvantages

• Difficult for people with accessibility issues, e.g no feedback, disability
• Can be easily damaged/scratched
• Damaged/scratched screen prevent the interface from functioning as it should
• Dirty screens difficult to read
• Users must be within arm’s reach of the display
• It is difficult to select small items
• User's hand may obscure the screen
• Screens need to be installed at a lower position and tilted to reduce arm fatigue
• Some reduction in image brightness may occur
• They cost more than alternative devices

(i) Referential integrity

• Two entities that are related require that a foreign key must have a matching primary key

(ii) Entity integrity

• Entity integrity specifies that the Primary Keys on every instance of an entity must be kept, must be unique and must have values other than NULL

(b) Describe how data integrity can improve the process of database management. (2 marks)

• Data integrity is the maintenance of, and the assurance of, data accuracy and consistency over its entire life-cycle and is a critical aspect to the design, implementation, and usage of any system that stores, processes, or retrieves data
• The overall intent of any data integrity technique is the same: ensure data is recorded exactly as intended (such as a database correctly rejecting mutually exclusive possibilities)

(i) the potential health hazards of this type of work,

• backstrain due to long periods of immobility
• eye strain due to long periods of staring  at the screen
• RSI- continual use of the same muscle group

(ii) the ways that management can help to overcome the effects of the health hazards.

• Move around regularly
• use ergonomic chair
• use anti-glare screen
• use of wrist pads

Blagging

• This is where a victim is tricked/persuaded by a fraudster to give their details or payment information for a false reason/purpose;

Phishing

• This is where the victim receives and responds to communication that appears to be from a valid or known source but is in fact fraudulent. (It allows the fraudster to capture private information before the victim realises);

Shouldering

• This is where someone watches and records\remembers a victim entering their pin or security information such as passwords. (They can then use this information to gain access to a system)

• It prevents double-booking which could happen in paper-based booking system
• The customer gets immediate feedback on the availability of seats
• The customer can make  booking at any time of the day
• Emails provided by customers during booking can be used by companies for advertisement

• provides an interface between the computer user and the hardware
• Manages the allocation and deallocation of the CPU to processes.
• manages Input-output devices by use of drivers

• consists of values between 0–255 / 0–FFF
• values are separated by full stops/colons
• it is a unique address
• can be static or dynamic
• can be public or private
• can be IPv4 / have four groups of digits
• can be IPv6 / have eight groups of digits
• in IPv6: can replace groups of zeros.

• It is a program written in a high level langauage

(i) Unexpectedly halts the program. Run time (execution)

(ii) The program produces the wrong output.  Logical
 (b) Another error can result from incorrectly using the rules or grammar of the programming language.

(i) Name this error. Syntax

(ii) State when this error is detected.

Syntax error is detected during translation into executable code / attempted to run but fails

specify output requirements
design documents/screen displays
data for input/storage
form design
storage devices
file structures/access/design
data security/back up files
systems flowchart etc.
implementation i.e. pilot/intermediate/parallel running
testing strategy
training
hardware/software
programming/algorithms
validation
user manual
technical documentation
entering data into system

A backup is a copy of data that can be used if the original data is lost.

– faster communications now widely available
– safety reasons, e.g. increase in terrorist attacks on international flights
– reduced transportation/accommodation/hardware costs
– environmental issues, e.g. reduced carbon footprint
– increase in multinational working

SECTION A (40 MARKS)

1.What is meant by

    a)Analogue data

     b)Digital data                           (4 mks)

2. Distinguish between transcription and transposition types of errors and give an example of each  (4mks)

3. a)What are peripheral devices?  (1mk)

   b)Give two examples of peripheral devices  (1mk)

4a)What meant by the term user-friendly as used in software development? (1mk)

  b)Distinguish between the terms single-tasking and multi-user as used in operating systems  (2mks)

5.What actions should be taken in case of a fire outbreak in the computer laboratory?  (4mks)

6a) What is an Internet Service Provider?    (1mk)

  b) An employee in a business company is charged with the responsibility of putting the company advertisements on the Internet.

 i) State the professional title of the employee. (1mk)

ii) Give an example of software used by this employee to carry out the above task.    (1mk)

7.Differentiate between COM ports and LPT ports     (2mks)

8.Explain two ways in which ICT can enhance commerce.  (2mks)

9. Explain the following software terms:

    a) Portability       (1 mk)

    b) Modularity      (1 mk)

10. a) State two application areas of desktop publishing software. (2mks)

     b) Explain the following graphic terms:                                                                                     

     i) Rotate (1 mk)

    ii) Crop  (1mk)

12. a)List two arithmetic operations that can be performed on a row of numeric data in a word processing table.    (1 mk)

     b) In each case of (a) above, write the expression used.  (2mks)

13. List two methods of gathering information during the system development process   (2mks)

14.Name three types of optical disks.(3mks)

15.The diagram below shows a formatted plate surface of a storage disk.

            Shade and label:

            a)         one sector                                                                                ( 1mk)

            b)         One block                                                                                (1mk)

SECTION B (60 MKS)

Answer question 16 and any other three questions from this section in the  space provided

16 a) List two examples of:

       i) Third generation languages    (2mks)

       ii) Object oriented languages    (2 mks)

b) Draw a flowchart to compare three non-equal numeric values A, B, C and prints the largest of the three. (11 mks)

17 a) One of the functions of an operating system is job scheduling.  Explain what is meant by job scheduling.   (1mk)

    b)List and explain three types of user interfaces.                      (6 mks)

    c)Describe the following categories of software:

       i) Firmware                 (1mk)

       ii) Proprietary software  (1mk)

     d) a new company XYZ intends to go into the business of desktop publishing. Advise the company on three computer hardware system specification features to consider as a measure of enhancing performance. (6 mks)

18. a) distinguish between the following sets of terms as used in spreadsheets.        (2mks)

     i)Worksheet and workbook

     ii) Filtering and sorting

     b) State one way in which a user may reverse the last action taken in a spreadsheet package.        (1 mk)

     c)The following is a sample of a payroll. The worksheet row and column headings are marked  1, 2, 3, .  and A, B, C.  respectively