Get premium membership and access revision papers, questions with answers as well as video lessons.
Computer Studies Question Paper
Computer Studies
Course:Secondary Level
Institution: Kcse question papers
Exam Year:2013
451/2
COMPUTER STUDIES PRACTICAL
APRIL 2013
150 MINUTES
Instruction to candidates
Create a folder on the desktop with your names and admission numbers and save all your work on it (10mks)
QUESTION ONE
Type the following letter as it appears in a word processor. Use the mail merge feature to produce copies of the same letter to the persons whose details are given below:-
MWANGAZA HIGH SCHOOL
P.O. BOX 4800
ELDORET
8TH JULY, 2010
<NAME>< ADMNO>
<ADDRESS>
<TOWN>
Dear <Name>
RE: 2009 KCSE RESULTS
I AM Happy to inform you that NOKDEC Examinations are out. Kindly arrange to visit our school on <<date to visit>at 9.900 a.m. in order to know the details. Remember to carry your original K.C.S.E certificate and examination register card bearing the index number.
Yours truly,
Head teacher
Data source (list of students)
Name Adm. No Address Town Date of visit
Mark Otieno 8071 P.O BOX 24 Sondu 10/08/2010
Kevin Kirui 8089 P.O BOX 172 Kericho 11/08/2010
Bernard Soi 8065 P.O BOX 84 Bomet 24/08/2010
Required:-
Save main document as main LETTER (1mk)
Save data source as data (1mk)
Change address and reference font size to 14 points (1 1/2mk)
Underline the reference (1/2mk)
Merge the letter into main document so as to produce copies for all the candidates and save it as Results 2009
Type the following text In a word processor and save it as computer literacy (15mks)
INTRODUCTION TO COMPUTER & OPERATING SYSTEM
A computer is a machine or an electronic device that can solve problems by accepting data, performing certain operations on that data (processing) and presenting the results of those operations (information)
Basic characteristics that distinguish a computer from other information processing devices:-
A computer is electronic- that is, all its processing operation is carried out with electronic signals.
A computer can store information for future reference. This is done on temporary basis with memory circuits and permanently with storage devices such as magnetic disk and tapes.
Computer is programmable- unlike other devices built to perform a single function, a computer can be instructed or programmed to perform a variety of tasks.
HOW A COMPUTER WORKS.
Connecting the data (raw facts) into information (organized, usable form) is called data processing. Data get into the system by means of an input device e.g. Keyboard then the computer performs the necessary calculations or manipulation on data and finally the organized information is displayed by an output device e.g. a monitor.
FUNCTIONS PERFORMED BY A COMPUTER
Although computers have many applications, they can perform only three basic tasks
Arithmetic functions on numeric data (adding, subtracting, multiplication and dividing).
Test relationship data items (by comparing values).
Store and retrieve data.
These skills are really no more than people can do, but the computer can accomplish the task more;
faster
accurately
reliably
REQUIRED
Align the title to the centre and underline it. (1mk)
Add the border to the title (2mk)
Replace all the roman numbers with bullets. (2mk)
–insert the footer “ computer assessment test 2012” (1mk)
-insert the header “your name and index number” (1mk)
Set the spacing to exactly 1.5 (3mk)
Insert the word art “COMPUTER” and set it to appear behind the text. (2mk)
Search for words “computer” and replace all with “PC”. (1mk)
Move the paragraph with the title “how a computer operates” to the end of the document.
Set the font style of the document to aerial black. (1mk)
Save your work as “computer literacy2” (1mk)
Question two
Create a database called ST TRIZA with the following details of table 1 and table 2 (30mks)
Table1: STUDENTS
Adm No First Name Last name class gender DOB
St/001 Tota malemba 1E M 1978
St/002 kilim Mafia 2N F 1990
St/003 kalif Elshabaab 3N M 1991
St/004 Tima Kokoi 1E M 2000
St/005 Siwezi Toba 2E F 1998
St/006 elipa Papa 1E M 1980
St/007 Trukofa Kemboi 3N F 1994
St/008 Kiki Wetu1 1E M 1984
St/009 Pepe Kale 3N M 1982
St/010 dudu Moja 1E F 1980
Table 2: ACCOUNTS
Adm No Amount Amount paid Contact Address
St/001 15400 15000 142,KITALE
St/002 16300 12000 300,LODWAR
St/003 23000 8000 400,KITALE
St/004 40000 40000 540,KAKUMA
St/005 10000 10000 300,ELDORET
St/006 13000 12000 533,MACHAKOS
St/007 1400 13000 499,GARISA
St/008 20000 20000 201,TURBO
St/009 40000 40000 241,NAIROBI
St/010 13000 13000 3001,TAITA
Create a relationship between these two tables. (2mks)
Make the following queries;
Filter all the students from 1E save as FORM 1E (2mks)
Calculate balance of money that these students owe the school. Save as FEE ARREARS (5mks)
Filter all the male students and save as ST TRIZA BOYZ (2mks)
Make form saving it as ACCOUNT FORM basing on table 2 (2mks)
Make a report basing on FEE ARREARS, the title of this report should read the name of the school ST TRIZA 2003. Save it as FARREARS REP. (5mks)
END
More Question Papers