State the seven layers of the OSI model
What is a defragmentation software
State two advantages of electronic databases over a flat file
Computer Studies KCSE 2006 Paper 1
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
Confidential information about the students is to be stored on the computer system. Explain the measures that can be taken to ensure that such information remains confidential.
- 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
An organisation that supplies audiobooks over the internet is moving into a new office building.
(a) One reason for networking devices is to provide access to the internet.
(i) Give two other reasons for connecting devices to networks.
Name three of the stages in the system life cycle
– fact finding
– feasibility study
– analysis
– design
– testing
– documentation
– implementation/changeover/installation
– evaluation
– maintenance
State advantages of batch processing
What is a computer system ?
A computer system refers to computer components that collectively function as a single unit to achieve the desired goal. It can also be defined as a collection of hardware, software, and liveware that work together to receive, process, and manage data
A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed
Blackout: This is unexpected discontinuation of power supply in the laboratory.
Power sag: Sudden drop of voltage levels that lasts less than a second.
Transients/ surge: High voltage flowing.
Brownout: Partial blackout where there's low voltage flow.
State two reasons why the data in fields such SEX field in a database should be coded.
Viruses, pharming and phishing are all examples of potential Internet security issues.
Explain what is meant by each of these three terms.
Virus
Pharming -
Phishing
KCSE 2016 COMPUTER STUDIES PAPER 1
State the function of each of the following keys on the computer keyboard : (2mks)
Backspace;
Insert
An organization intends to replace an existing system by carrying out the process in stages .
Name the implementation strategy ; (1mk)
Give two reasons why the organization is opting to use the implementation strategy in (a) above (2mks)
Give a reason why HMTL is not regarded as a programming language
Distinguish between one to one and one to many relationships as used in relational databases
One to one - Each record in the parent table has exactly one related record in the child table, and vice versa.
One to Many - Each record in the parent table can have multiple related records in the child table, but each record in the child table is related to only one record in the parent table
Factors to consider when choosing DTP software. (4 marks)
Define the following terms as used in the internet
HTTPS/HTTP: this is a protocol that is used to send data to web pages across the Internet
Uniform Resource Locator (URL): a text-based version of a web address
Internet Service provider /ISP - his is the company that provides a user with a connection to the Internet
browser - Software/application that allows users to view web pages / render HTML -
cookie - a text file (stored by a web browser) that contains data about a user’s browsing habits/details/preferences
Computer programs require translation to execute. (a) Compilers and interpreters translate high-level programming languages into machine code. Describe the main differences between a compiler and an interpreter.
Outline three ways through which ICT can used in marketing
ICT is used to create e-commerce platforms that have made business transactions easier and convenient by allowing customers make purchases and payments from anywhere at any time
ICT is used by marketing agents to create exciting multimedia presentations concerning products or services and present them to the target customers using presentation software such MS PowerPoint
Using multimedia, presentation and animation software, it is possible to design attractive advert materials and video clips to display on billboards, broadcast over a television or uploaded on the internet
List three characteristics of Internet Protocol version 6 (IP6).