Get premium membership and access revision papers, questions with answers as well as video lessons.

Bungoma District Mock - Computer Studies Paper 1 Question Paper

Bungoma District Mock - Computer Studies Paper 1

Course:Secondary Level

Exam Year:2009

451/1
COMPUTER STUDIES
PAPER 1
JULY / AUGUST 2009
2 ½ HOURS
JOINT INTERSCHOOLS EVALUATION TESTS
JISET 2009
COMPUTER STUDIES
PAPER 451/1
JULY / AUGUST 2009
INSTRUCTIONS TO CANDIDATES.
• Section A is compulsory.
• Write all your answers in the spaces provided in the answer sheet
• Answer question 16 and any other three questions in section B

1. In each of the following situations state the most appropriate data processing mode.
a). Hotel reservations (1mk)
……………………………………………………………………………………………………
b). Pay roll preparations (1mk)
……………………………………………………………………………………………………
2. a) What is a page description language? (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) State two types of page description languages in the market today (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
3. State two consequences of a poorly implemented system change over strategy (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
4. a) What is a section break as used in word processing? (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) State two section breaks that can be used in a word processor (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
5. a) State four levels of system testing (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) In relation to programming, what is meant by:
i). Language syntax (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Semantic
……………………………………………………………………………………………………
……………………………………………………………………………………………………
6. Distinguish between Job scheduling and job sequencing (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
7. The diagram below represents a set of keys on the computer keyboard. Study it and use it to
answer the questions that follow
a) Give the appropriate name given to the first set of keys in the diagram (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b)State what the following key combination will do when pressed in Microsoft word 2003
i). CtrI + END (1mk)
……………………………………………………………………………………………………
ii). Ctrl + DEL (1mk)
……………………………………………………………………………………………………
8. Distinguish between central processing unit (CPU) and microprocessor (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
9. Suppose that i and j are integer type variables that have been assigned the values of 3 and -5
respectively. What is the value of the following Boolean expressions? (2mks)
a). (i DIV 2) >= (j+ 6)
b). i—3=j+5
……………………………………………………………………………………………………
……………………………………………………………………………………………………
10. a) State two characteristics of Rom (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) Name two devices other than the typical computer where ROM may be used (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
11. State the functions of the following devices:
a). Net work interface card (NIC) (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b). Expansion slot (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
12. For each of the following printers state the print modes
a). Dot matrix (2mks)
……………………………………………………………………………………………………
b). Inkjet printer (2mks)
……………………………………………………………………………………………………
13. a) What is meant by disk defragmentation? (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b) State the purpose of disk defragmentation (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
14. Give any THREE differences between artificial neural networks and an expert system (3mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
15. Define the following terms as used in computing
i). Bluetooth (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). MP3 (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
SECTION B
Answer questions 16 and any other three questions in this section
16. Students in your class are divided into two groups: Group A with Biology students and Group
B with Chemistry students. Biology students attend their lessons on Fridays and Chemistry students on
Tuesdays. A program is required to read the name of each student and the group he/she belongs to
terminate by QUIT.
Print a list showing the name, day and subject that each student should attend class for that subject.
a). write a pseudocode for this program (5mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b). draw a flowchart for this program (6mks)
c) Give two differences between procedural and non procedural programming languages (4mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
17. A student at Kula Mawe High school was asked to name four computer consumables. The student
responded by naming the following; Toner, ink cartridge, plotter pen, ink ribbon.
a). Which of the items mentioned is likely not to be actively used in a school situation (1mk)
……………………………………………………………………………………………………
b). Explain to the rest of the students what is meant by:
i). Toner cartridge (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Ink cartridge (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
iii). Ink ribbon (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
c). Output devices are classified as either hard copy or softcopy devices.
i). Name two hard copy output device that can be used in a busy architectural firm (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). State two reasons why the user may prefer softcopy to hard copy output device (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
d). Use the two’s binary compliment method of subtraction to work out the following (4mks)
4561.558— 10011111.0012
……………………………………………………………………………………………………
……………………………………………………………………………………………………
18. a). Explain the meaning of the following field properties;
i). Validation rule (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Validation text
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b). Below are two table structures of files in a database
Table A Table B
Field Data type Field Data type
Employee name text Employee no Number
Employee number Auto number Data employed Data/time
DOB Date/ Time Department Text
Address Text Salary Currency
i). which of the two tables is likely to be the parent table (1mk)
……………………………………………………………………………………………………
ii). It is advisable to ‘enforce referential integrity’ when creating a relationships. What do you
understanding by the term referential integrity?. (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
iii). The field ‘employee no’ in table B likely to be the foreign key. What is a foreign Key? (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
iv). Which fields in both tables is most appropriate for creating a relationship? (1mk)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
v). What would make the relationship between the table fail to work? (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
c) i). In databases the field properties specify finer details related to the fields and the table entries
expected. State THREE field properties. (3mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). State THREE functions of a database (3mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
19. a). i). Explain three communication services offered through internet (3mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Describe the following internet terms (2mks)
Sign Up
……………………………………………………………………………………………………
……………………………………………………………………………………………………
Download
……………………………………………………………………………………………………
……………………………………………………………………………………………………

10
b). The following is a spreadsheet relating to a farmer.
A B C
1 Crop Amount Remark
2 Maize 150
3 Bean 300
4 Cashew nuts 850
5 Cabbages 1036
i). a function =IF(B2<200 “Not Viable”), IF (B2> 300,” Moderate”), IF (B2>1000, “Viable”))). Give
the appropriate result returned in cells C2, C3, C4 and C5 (2mks)
ii). Text can easily be selected using a mouse in word processing. How do you select
a). Multiple paragraph
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b). Vertical block of text
……………………………………………………………………………………………………
……………………………………………………………………………………………………
c). Distinguish between (2mks)
i). A window and an orphan in word processing
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Computer Crime and Computer abuse
……………………………………………………………………………………………………
……………………………………………………………………………………………………
d). i). Give one purpose of drop caps on a text paragraph (1mk)
……………………………………………………………………………………………………
ii). What is meant by artificial intelligence? (1mk)
……………………………………………………………………………………………………
iii). Give two application of artificial intelligence (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
20. You were typing a document on the computer and the power of the computer was abruptly
interrupted. When the computer was restarted, the document was no longer in memory.
a). i). explain why the document was not in memory (1mk)
……………………………………………………………………………………………………
ii). Give TWO precautions that can be employed to ensure that a document is not completely lost in
the event of a power interruption. (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
b). The two diagrams below represent two softcopy output devices.
i). Name them (2mks)
Figurel ………………………………………………..
Figure2 ………………………………………………..
ii). Other than the typical computer, name other two devices that use the device labeled figure 1 above
in the diagrams as output devices. (2mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
c). Briefly explain how data is saved on the following secondary storage devices
i). Floppy disk (4mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
ii). Magnetic tape (4mks)
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………

Bungoma District Mock - Computer Studies Paper 1 Question Paper

More Question Papers

Popular Exams