Computer Studies Paper 2 Questions and Answers - Asumbi Girls Highschool Pre-Mock Exams May-June 2022

INSTRUCTIONS TO CANDIDATES

This paper has two questions.
Answer all the questions.
All questions carry equal marks.
Type your name and index number at the right hand corner of each print out.
Write your name and index number on the storage medium provided.
Write your name and version of software used for each question attempted.
Passwords should not be used while saving in your work.
Make a printout of the answers on the answer sheets provided
Hand all the print outs and the storage medium
This paper consists of 4 printed pages
Candidates should check to ensure that all pages are printed as indicated and no questions are missing.

QUESTIONS

Kipto’smilling company limited has given you the details below to be used in calculating expenses incurred during two quarters of the year as indicated. Use a spreadsheet package to enter the details, and save your work as Expenses 1. (10 marks)

	A	B	C	D	E	F	G
1	KIPTO’S MILLING COMPANY LIMITED P.O BOX 625 NAKURU
2	KIPTO’S MILLING COMPANY LIMITED P.O BOX 625 NAKURU
3		First quarter			Second quarter
4		January	February	March	April	May	June
5	Production cost	15642	14687	18741	19457	15412	15441
6	Transportation	1564	1469	1874	1946	1541	1544
7	Warehousing	1125	1056	1347	1398	1107	1109
8	Promotion	2564	2407	3071	3188	2525	2530
9	Salary	4525	4248	5420	5626	4456	4465

1. Copy the details of Kipto’s milling company limited to sheet 2 of your worksheet. (2marks)
2. Add a column called “Total” and calculate the Total production cost of the two Quarters. (4marks)
3. Use relative referencing to calculate the total for the other expenses. (4marks)
1. Calculate the total expenses for each month so as to give the results as “Total expenses” on row 10. (4marks)
2. On the paper provided, write the formula used to calculate the expenses for the month of April. (2marks)
1. Use absolute referencing to calculate the cumulative total expenses for the two quarters in cell H10. (4marks)
2. Write the formula used to get the cumulative total on the paper provided. (2marks)
3. Calculate the percentage of total expenses of the respective months and display the results on row 11 as “percentage of total expenses”. (4marks)
4. Write the formulae used to get the percentage of May. (2marks)
5. Draw a line graph to illustrate the percentage of the total expenses for the six months indicating the months. Save your work as Expenses 2. (10 marks)
6. Print Expenses 1 and Expenses 2. (2marks)

A hospital uses a database to maintain data about its employees.
Createa database file namedEMPLOYEE. (1 mark)

Create a table called EMPLOYEE 1 with the following fields and hence enter data into it as shownin fig 1 below. NB: Choose an appropriate primary key. (14marks)

EMP NO
NAME
DATE OF BIRTH
DEPARTMENT

BASIC PAY
Fig 1

Emp	Name	Date of birth	Department	Gross pay
01	John Kirui	16/2/1972	Computer	28000
02	Margaret Wairimu	2/2/1960	Medical	30000
03	Jane Cherono	2/5/1970	Management	15000
04	Victor Oduor	8/12/1981	Accounts	25000
05	Harry Wanyama	23/6/1983	Medical	30000
06	Jacob Kiprono	19/4/1973	Management	45000
07	Ali Mohammed	1/1/1969	Medical	30000
08	Daniel Omondi	3/5/1983	Accounts	25000
09	EverlyneKitune	11/3/1971	Medical	20000
10	Nancy Kerubo	22/9/1980	Medical	20000

1. Insert two new fields to hold the employee’s profession and deductions. (4 marks)
2. Data for included fields is as follows;
  Profession
  Mohammed, Wanyama and Wairimu are Doctors. Oduor and Omondi are accountants.
  Kiprono isan Administrator, Kirui is a systems analyst and Cherono is a secretary.
  Deductions
  Emp no Amount
  07, 05, 02 8,000
  04, 08 7,500
  06 10,000
  01 12,000
  03 3,500
  09, 10 4,000
  Enter the above data into the respective fields. (6 marks)
3. Sort the records in ascending order based on the name field and save as EMPLOYEE 2. (3marks)
1. From EMPLOYEE 2, extract a list of employees who were born between 1960 and 1972 both years inclusive and are accountants, nurses or doctors. Write down on paper provided the query expression you used to extract the data. Save the extracted list as LIST1. (8marks)
2. Remove the date and occupation criteria on LIST 1. Add a calculated field to calculate the Net pay of all employees as Gross Pay - Deductions. Save as LIST 2. (5marks)
Generate a columnar report based on LIST 2 with the following fields; Emp no, Name, Department and Net Pay. Sum up the Net Pay for all employees in the report. Save your report as REPORT. (6marks)
Print EMPLOYEE1, EMPLOYEE2, LIST1, LIST 2 and REPORT. (3marks)

MARKING SCHEME

KIPTO’S MILLING COMPANY LIMITED
P.O BOX 625 NAKURU

	First quarter			Second quarter
	January	February	March	April	May	June
Production cost	15642	14687	18741	19457	15412	15441
Transport	1564	1469	18784	1946	1541	1544
Warehousing	1125	1056	1347	1369	1107	1109
Promotion	2564	2407	3071	3188	2525	2530
Salary	4525	4248	5420	5626	4456	4465

Bold + centered + underlined each lmark = 3marks
- Bold + centered + underlined @ lmark = 3marks
- Boarders = 2marks
- Correct alignment = 2marks
- All entries correct = 7marks
One wrong entries = 5marks
Two wrong entries = 3marks
Three or wrong entries = 3marks
Wrong entries = 0

Worksheet correctly copied to sheet = 2 = 2marks

= 2marks for tithe “Total”
= 2marks for correct formula for total production cost.
KIPTO’S MILLING COMPANY LIMITED
P.O BOX 625 NAKURU

	First quarter			Second quarter
	January	February	March	April	May	June	Total	2mks
Production cost	15642	14687	18741	19457	15412	15441	9938	2mks
Transportation	1564	1469	18784	1946	1541	1544	99380	1mk
Warehousing	1125	1056	1347	1369	1107	1109	7142	1mk
Promotion	2564	2407	3071	3188	2525	2530	16285	1mk
Salary	4525	4248	5420	5626	4456	4465	28740	4mk

Total expenses any 4 correct 4 marks	25420	23867	30453	31615	25041	25089	161485
Percentage of total expenses 4 marks	15.7414	14.7797	18.8581	19.5777	15.5067	15.53364

4marks (any 4 correct)

1. = Sum (E5: E9) S = 2marks
  or
  = E5 + E6 + E7 + E8 + E9 = 2marks
1. = Sum ($ H $ 5: $ H $ 9)
  or
  = $ H $ 5 + $H$6 + $H $6 + $H $7 + $H $8
  iv) = (F9 / $ H10) * 100
  or
  = (F9 / H10) * 100