Name …………………………………… Adm. No/Index No…………………………………..
Candidate’s Signature …………………
2 ½ Hours
KENYA CERTIFICATE OF SECONDARY EDUCATION
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
Nelson MokayaErnest Mwangi
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)