RSS

2010-KCSE-TRIAL-COMPUTER-STUDIES-P2-001

09 Sep

CST-OP2-001

Name …………………………………… Adm. No/Index No…………………………………..

Candidate’s Signature …………………

Date ………………………………………

451/2

COMPUTER STUDIES

Paper 2

(Practical)

July/August 2010

2 ½ Hours

KENYA CERTIFICATE OF SECONDARY EDUCATION

Computer Studies

(Practical)

Paper 2

1)

The table below shows a section of St. Peters Kalu girls’ fee payment by students.

ADM NO. DATE STUDENT’S NAME FEE PAID FEE BALANCE
26902836

2583

2910

2913

2921

2934

2963

2975

2836

3000

2934

3010

3001

2836

2934

2931

3001

2836

3/5/20093/5/2009

3/5/2009

3/5/2009

4/5/2009

4/5/2009

4/5/2009

5/5/2009

5/5/2009

5/5/2009

6/5/2009

6/5/2009

6/5/2009

7/5/2009

7/5/2009

7/5/2009

8/5/2009

9/5/2009

9/5/2009

Nelson MokayaErnest Mwangi

Joseph Motari

Peter Oluoch

Josephat Kimutu

Trisa Okinyi

Mary Njoroge

John Karioki

Florence Kiyaka

Chrispus Kiamba

Joseph Motari

Shem Omwenga

John Karioki

Alfred Matoke

Benjamin Okioga

Joseph Motari

John Karioki

Mary Njoroge

Benjamin Okioga

20002000

4000

2500

3000

2000

6000

1000

2900

6500

5000

2000

1200

2000

2200

2000

4000

2600

2000

a) Using a spreadsheet package, enter the information given in the table into a worksheet and rename the worksheet as FEEENTRY. Save the workbook as A:\QSS (15mks)

b) Copy the worksheet and paste it in sheet 2. Rename the worksheet as TOTAL (4mks)

c) Format the column headers so that they are aligned at 450 and bold them. Let the figures in thousands be separated by a coma and format the figures so that the read Ksh. (6mks)

d) Sort the file in alphabetical order and using a function determine the total amount paid by each student for this month (14mks)

e) Find the list of students who have paid a fee more than 5000. Paste then in a new sheet and rename the sheet as TOP (3mks)

f) Using a formula find the fee balance for each student as per the end of this month given the total fee as 17,000 (4mks)

g) Print the workbook (4mks)

2) HIGHTEC Computer College is a company dealing with computer services. It opted to computerize their work using a database program to monitor day to day computer sales. Imagine that you are their computer programmer, assist them in their goal as tabled below.

Worker Name Age Monthly Salary Allowances Gross Pay Payment method Employment terms
Peter Nyang’au 54 $20000 $5000 Cash Casual
Lucy Bosibori 50 $40000 $3000 Bank Permanent
Tom Onyancha 45 $10000 $6050 Money Order Casual
Selly Moraa 42 $15000 $1040 Cash Permanent
Tom Nyakundi 32 $30000 $9300 Bank Permanent
Raphael Nyamu 40 $21000 $4500 Bank Casual
Evans Ndemo 39 $37000 $4440 Bank Casual
Stellah Otieno 30 $25000 $7000 Bank Permanent
Mary Kemuma 35 $27000 $3500 Money Order Casual

a) Create a database called HIGHTEC and enter the above data in workers table (18mks)

b) Create a primary key to Age field (2mks)

c) In all cases change the currency to Kenyan Shillings (2mks)

d) Create a query having fields worker name, age and monthly salary whose age is less or equal to 40 and sort it in ascending order. Save it as workers query. (10mks)

e) Create a query having fields; worker name, salary, allowances. Calculate the gross pay of each worker. Name it as Gross query. (10mks)

f) Create a report from workers table having all fields and change the orientation to landscape. Save it as workers report. (4mks)

g) Print workers table, workers query, gross query and workers report. (4mks)

 
Leave a comment

Posted by on September 9, 2010 in Computer Science, Paper 2

 

Tags:

Comments are closed.

 
%d bloggers like this: