SECTION A (40 MARKS)

ANSWER ALL THE QUESTIONS IN THIS SECTION

1.Compare the two types of diskettes used in microcomputers in terms of physical size and densities.    (2mks)

2.Why is it necessary to have a UPS in a computer laboratory?  (2mks)

3 a) Explain what is meant by batch processing   (1mk)

   b) Give one advantage and one disadvantage of batch processing ( 2mks)

4. List any four high level programming languages  (2mks)

5.A 3 by 4 matrix M is to be added to another 3 by 4 matrix array N so as to give a third 3 by 4 matrix array P.  Using a high level programming language, write a program segment that assigns the sum of M and N to P.(4mks)

6. The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.  Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.  (3mks)

7.  Give three advantages of separating data from the applications that use the data in database design. (3mks)

8.  Explain the impact of information on organizations in each of the following areas:  (2mks)

   a) Competition

   b) Pace of growth

9. a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations  (2mks)

    b) Explain what is meant by automatic recalculation as used in a spreadsheet.(1 mk)

10. Describe the functions of the following computer hardware components:

   a)Mouse                     (2 ½  mks)

   b)Scanner.                   (1 ½ mks)

11. a)State two differences between Disk Operating System (DOS) and WINDOWS operating system.

 b. i) Define the term application software  (1mk)

     ii) Give one example of application software (1mk)

12. a)  Give one difference between internal and external commands in Disk Operating System.   (2mks)

      b)  Name two DOS commands that may be used for checking disk errors.  (2mks)

13. Explain how a paragraph can be moved from one place to another in word-processing. 2mks)

14.  Define the term structured programming. (2mks)

SECTION B (60MKS)

Answer question 15 and any other three questions from this section.

15.a)  What is meant by each of the following terms:

 i)   pseudocode        (1 ½ mks)

  ii)  Flowchart           (1 ½ mks)

b) a program is required to list the first 1000 numbers in the series:  2, 4, 6, 8,

10. Draw a flowchart and write a program that can be carried out this task.   (12 mks)

16. The following car details are to be entered in a database; make, date-of-manufacture, colour and cost.

 a) Prepare a suitable database structure showing field names and their field types   (5mks)

 b) Explain how you index the data such that cars of the same make and colours are together   (2mks)

 c)  Write a statement that can be used to select cars of the colour green        (2 mks)

 d) Give an instruction that would;

  i)select cars whose cost lie between 500,000/= and 1,000,000/=  (3 mks)

 ii)Determine the average cost of all cars         (3mks)

17.  a)The diagram below represents the essential features o a computer system. Study the diagram and answer the questions that follow:

i)Name the components (4mks)

            A

            B

            C

            D

ii) On the diagram above, indicate the direction of data flow using arrows.  (3mks)

b) Name the three types of buses in a computer system (3mks)

c) Explain how CPU registers may be used to carry out a basic calculation such as:2 + 7 = 9

d) Name two computers output devices. (1 Mark)

18. a)State three ways in which computer technology may affect employment patterns in organizations   (3mks)

b) State three ways in which computer technology may affect employment patterns in organizations (3mks)

c)Suggest three strategies that can be employed to manage resistance to change  (3mks)

d) Give three advantages of computerization in an organization.  (3mks)

19. a)In a computer based information system, state the purpose of the following files and give one example where such a file may be required in a school.                (8mks)

i) report file

ii)Back-up file

iii)Reference file

iv) Sort file

b) State three precautions that should be taken to ensure that diskettes are well stored.  (3 mks)

c)  Distinguish between “serial” and Indexed sequential” file organization methods.  (2mks)

d)  Distinguish between binary and octal number systems and give an example of each  (2mks)

• two's complement has only one value for zero

• Is an integration of sound, text, graphics, and video to convey information

 the trial version of software for a limited time/number of uses with limited features  free of charge

If a full version is required need to pay a fee/sign up

When the trial is over user is asked to pay/sign up

Protected by copyright

Type of software licence
 

• More RAM will improve the performance of the computer 
• More RAM will speed up the access to data
• Excessive use of VM can cause disk thrashing which decreases performance
• VM is slower to access than RAM direct (because it has to go back to RAM first)
• Moving data between RAM and VM takes processor time

Manages memory (RAM) 

• Allocates memory to programs currently executing •

Ensures programs/data do not corrupt each other: Ensures all programs and data including itself is stored in correct memory locations

Manages processes: Ensures different processes can utilise the CPU and do not interfere with each other or crash •

Allows a user to run programs : On a multi-tasking O/S ensure that all tasks appear to run simultaneously

• Allocates time slices 
• Scheduling of programs
• Handles interrupt
• Allows a user to configure hardware

Data and instructions are fetched from main memory, from addresses requested by the CPU on the address bus. (Data and instructions are sent) using the data bus. (Data and instructions are then) decoded and executed in the CPU.
Results of operations are sent back to the memory on the data bus

(a) Phishing

• Phishing is a strategy that encourages a computer user to part with sensitive information such as bank details hence the term ‘phishing’ – i.e. fishing – trying to catch someone out. For example, a perpetrator sends a user an email that appears to be genuine, for example, pretending to be a bank or a lawyer requesting that the user verify bank account details or send money to assist in the completing of a legal case.

(b) DoS

• DoS is a means of attack on a specific user/system/website which involves overloading a target with too much network traffic resulting in system slowdown, shutdown or a violation of security.

• connecting wireless headphone to a phone
• Using a wireless mouse, keyboard etc
•  

Legend

• Legends are a small visual representation of the chart's data series to understand each without confusion.

A data series

• is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits
• A group of related data points or markers that are plotted in charts and graphs

Data Marker

• A symbol on the chart that represents a single value in the worksheet.
• A column, dot, pie slice, or another symbol in the chart that represents a data value

Syntax errors-Incorrect use of programming language

Logical errors- The program do not give the expected output

Runtime errors- Premature end of a program

• Guided media uses cables to connect to computers whereas unguided media uses waves.

A parameter represents additional information that  a function requires to perform its task. Each parameter required by a function is specified in the function header

An argument the value supplied in the function call. When the function is called, the argument value is passed into the function parameter so that the function can perform its task

        Misreading error

• It covers many aspects that will be used to decide whether to go ahead with the project or not.
• The main components are technical, operational, economic, legal and scheduling.

• They execute code differently – a compiler reads a complete program at once, an interpreter reads a program line-by-line
• they identify errors in different ways – a compiler does not allow a program to run until error-free, an interpreter runs the program until the first error.

• an use Internet connection and telephone at the same time
• much faster data transfer speed
• always “on”
• charged for number of bytes/flat rate per month rather than actual time on line
• more bandwidth

• Allows creation and management of user accounts
• Helps in troubleshooting of the network
• controls access to network resources
• Provides communication services
• configures network resources
•  

- Passwords
- Hierarchy
- Only allow some staff to access student files
- Only some machines able to access
- Physical location of these machines
- Physical lock on machines
- Encrypted data in files
- Firewall if connected to the Internet

• Main memory is transitory/temporary/volatile, secondary storage is (semi-)permanent
• The processor can only use data/instructions that are in the main memory
• Main memory is directly accessible to the processor, secondary storage is not directly accessible to the processor