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

Computer Studies Paper Two Question Paper

Computer Studies Paper Two

Course:Secondary Level

Exam Year:2006

FRIENDS SCHOOL KAMUSINGA
KIMILILI

415/2
COMPUTER STUDIES
PAPER 2
PRACTICAL
OCT/NOV. 2006
2½ HOURS
(KNEC)

INSTRUCTIONS TO CANDIDATES
• Type your name index number at the top right hand corner of each printout
• Write your name and index number on the diskette
• Write the name and version of the software used for each question attempted in the answer sheet.
• Answer all the questions
• All questions carry equal marks
• Passwords should not be used while saving in the diskette
• All answers must be saved in your diskette
• Make a printout of the answers on the answer sheets provided.
• Arrange your printouts and tie/staple them together
• Hand in all the printouts and the diskette

1. The worksheet below is a sample of a fees register of Mambo Yote Secondary school.

MAMBO YOTE SECONDARY SCHOOL
FEES REGISTER

ADM NO NAME ADDRESS TOWN AMOUNT PAYABLE FEES PAID FEES BALANCE
2001/3 Onyango S. 350 Kisumu 3000 1500
2001/10 Kamau J. 22 Kabete 35000 30000
2001/2 Cheptoo R. 23000 Eldoret 29000 20000
2001/9 Nafula W. 11 Bungoma 64000 10000
2001/7 Nyambane, E. 226 Kisii 34250 40000
2001/6 Mwari, T. 992 Meru 33000 16000
2001/8 Kamene, G. 1 Kitui 22000 10000
2001/4 Ole, D Private Bag Kajiado 18000 8000
2001/5 Wanjiku, P 52000 Nairobi 50000

(a) Create a workbook to store the information and save it as FEES REGISTER (8 marks)

(b) Use formulae to compute: (2 marks)

i. The fees balance for each student.
ii. The total
• AMOUNT PAYABLE
• FEES PAID
• FEES BALANCE (3 marks)
(c) Use the If function to declare the following remarks about a student: (9 marks)

• “Proceed” if the fees balance is less than or equal to ¼ of the amount payable
• “Use Principal” if the fees balance is more than ¼ but less than or equal to ½ of the amount payable
• “”Send home” if the fees is more than ½ of the amount payable

(d) Use a function to count the number of students who should:
i. Proceed
ii. See the Principal
iii. Be sent home (6 marks)

(e) Format the table as follows
i. Center the title and subtitle a cross the page (3 marks)
ii. Left align all address (1 mark)
iii. Format the amount payable, fees paid and balance as currency with zero decimal places. (3 marks)

(f) Apply borders to cells in the worksheet as follows:
i. Double line for outline border (1 mark)
ii. Dotted lines for vertical inside borders. (1 mark)
iii. Dashed lines for horizontal inside borders (1 mark)

(g) (i) Rename the current worksheet as MAIN. (1 mark)
(ii) Copy the entire MIAN worksheet to a blank sheet and rename the new sheet as HOME. (2 marks)
(iii) Filter the HOME worksheet so as to display the students who come from towns starting with letter “K” and have a fee balance exceeding Sh. 10,000. (5 marks)

(h) (i) Insert your name and date as a footer in each sheet. (2 marks)
(ii) Print both worksheets (2 marks)

2. Byte Computer Services is a company with numerous branches in East Africa. In order to monitor the performance of the branches and that of the cities in which the branches are located, a database to organize the information is required.
a. Create a database file and name it COMPANY. (2 marks)

b. (i) Create a table containing the following fields. (4 marks)

Field Name Field Type
STORE-NO Number/Numeric
BRANCH Text/Character
CITY Text/Character
STAFF-SIZE Number/Numeric

(ii) make the field STORE-NO the primary key and save the tables as STORES.(2 marks)

c. (i) Create a form from the STORES table and save it as STORES-FORM. (5 marks)
(ii) Use the form to enter the records below. (5 marks)
STORE – NO BRANCH CITY STAFF-SIZE
1 Tudor Mombasa 15s
2 Bongo Dar-es-salam 14
3 Sunset Nairobi 21
4 Lakeview Kampala 15
5 King’orani Mombasa 9
6 Beach Town Kisumu 16
7 ABC Nairobi 89
8 Crane Ltd Kampala 7
9 Wheat land Nakuru 12
10 Ocean View Dar-es-salam 6

d. (i) Modify the STORES table to include an additional field with the heading SALES (SHS) (3 marks)

(ii) Enter the information below for each of the stores. (2 marks)

STORE-NO SALES
1 789,300
2 685,400
3 376,958
4 355,420
5 457,800
6 682,458
7 541,000
8 235,420
9 352,415
10 433, 443

(iii) In the STORES table, swap the fields CITY with BRANCH. (2 marks)

e. (i) Create a query from the STORES table to display the fields BRANCH, CITY, STAFF-SIZE and SALES (SHS) for stores whose sales are less than 400,000(3 marks)

(ii) Sort the records in the query above in alphabetical order of BRANCH field and save it as POOR PERFORMERSS. (2 marks)

f. (i) Create a tabular report with landscape orientation from the STORES table to display the fields in the following order.

STORE-NO, BRANCH, SALES (SHS) (4 marks)

(ii) Sort records in the report in alphatbetical order of the BRANCH field. (1 mark)

(iii) Compute the total sales and place in below the SALES (SHS) column and change its font size to 13. (5 marks)

(iv) Place two straight lines cutting across the page, one above and one below the sales total. (2 marks)

g. (i) Insert a header BYTE COMPUTER SERVICES PERFORMANCE in the report having font size 19 and centre it across the page. (3 marks)

(ii) Remove the report pagination and insert your name and index number in its place and save the report as PERFORMANCE. (2 marks)

h. Print STORES table, POOR PERFORMERS query and PERFORMANCE report. (3 marks)

Computer Studies Paper Two Question Paper

More Question Papers

Popular Exams