MARANATHA BOYS ACADEMY

2024 MALAWI SCHOOL CERTIFICATE OF EDUCATION EXAMINATION

COMPUTER STUDIES PAPER TWO GROUP QUESTIONS

QUESTION 1
a. Create a spreadsheet called “Productivity” and enter the following data.
(4 marks)

b. Using a formula, calculate Total Hours for Foster Dika

(2 marks)
c. Replicate the formula to find the Total Hours for the rest of the workers (3
marks)
d. Using “If Analysis” create a formula to determine productivity of each
worker where “Total Hours” is less than 106, label “Low”, while where
“Total Hours” is more than 106, label “High”
(4 marks)
e. Replicate the formula to find the productivity for the rest of the workers
(1 mark)
f. Create a right header and type your examination number
(2 marks)
g. Apply cell borders to the data entered. (2
marks)
h. Print the spreadsheet
(1 mark)

QUESTION 2
a. Create a database named “2024 Athletes” and save it a removable disk (2
marks)
b. Design a database table with “Reg No” field as a primary key (3
marks)
c. Save the table with your examination number as the table name
(1 mark)
d. Enter the data below

Page 1 of 6
e. Filter all athletes that come from Karonga (2
marks)
f. Print the filtered data (1
mark)
g. Create a datasheet form from the table showing all the fields (2
marks)
h. Print the datasheet form in Landscape (2
marks)

QUESTION 3

a. Create a spreadsheet called ”Telephone Bills” and save it in a

removable disk
(2 marks)
b. Enter the data below
(3 marks)

c. Using a mixed cell reference formula, calculate the bill for

Administration Department in the COST PER DEPARTMENT column.
(2 marks)

Page 2 of 6
 d. Replicate the formula to calculate bills for the other departments (1
mark)
e. Create a column chart as a “new sheet” representing Department
and cost per department only.
(3 marks)
f. Show values on the chart (1
mark)
g. Hide column D on the worksheet
(1 mark)
h. Apply gridlines to the data entered
(2 marks)
i. Set the text orientation for all departments to 45º
(2 marks)
j. Insert your examination number as a Header to the column chart (1
mark)
k. Insert a chart title as “Departmental Bills”
(1 mark)
l. Print the chart
(1 mark)

QUESTION 4

a. Create a database named “Students” and save it in the removable disk

(2 marks)
b. (i) Design a database table in Design view using the following field
Names and Data types.
(4 marks)
FIELD NAME DATA TYPE
StudentId Text
Surname Text
Special Diet Yes/No
Sex Text

(ii) Set a suitable field as the primary key

(1 mark)
c. Save the table with “FORM 4” as the Table Name
(1 mark)
d. Enter the following data:
(5 marks)

Page 3 of 6
 e. Run a query using design view showing Student ID; surname; special
diet and sex for only students on special diet
(5 marks)
f. Save the query with your examination number
(1 mark)
g. Print the query
(1 mark)

QUESTION 5
a. Create a spreadsheet named “Coupons” and save it in a removable disk
(2 marks)
b. Enter the following data
(3 marks)

c. i. Using an “If Analysis” formula label “Yes” in the Beneficiary column for
Jeviyasi Noah if daily income is less than 150 and label “No” in the same
column if daily income is more than 150
(4 marks)
ii. Copy the formula used in c(i) to find Beneficiary for remaining people.
(1 mark)
d. Format currency in Daily Income column as Malawi Kwacha
(2 marks)
e. Fill Beneficiary column with green colour
(2 marks)
f. Align column headings to the centre
(1 mark)

Page 4 of 6
g. Apply column headings to the centre
(1 mark)
h. Create a centre header and type your examination number
(1 mark)
i. Print the spreadsheet
(1 mark)

QUESTION 6
i. Create a database named “Student Details” and save it in a removable disk
(2 marks)
ii. Design a table with the fields shown in Table 1, with “My Students” as the
table name.
(4 marks)
iii. Enter the data in Table 1
Table 1: Datasheet 1
Admission Class First Name Last Name Gender
Number
001 4A Sabina Phiri Female
002 4C Lones Boman Female
003 4A Lonis Botoman Female
004 4A Jackson Chabwera Male
005 4C Timothy Bwerani Male

iii. Sort the data in the datasheet using class field, in ascending order
(2 marks)
iv. Create a report showing Admission number, First name, Last name, Class
and Gender in that order (5
marks)
v. Print the report in landscape (2
marks)

QUESTION 7
i. Create a spreadsheet named “Calculations” and save it in a removable
disk (2 marks)
ii. Enter the following data
(6 marks)

Page 5 of 6
 iii. Given that 1000kgs make 1 tonne,
a) Convert quantity of maize from tonnes to kilograms (2
marks)
b) Replicate the formula used in c above to the rest of the crops (1
mark)
iv. Using a formula,
a) Find the amount of maize (in kilograms) that is still in stock (3
marks)
b) Replicate the formula used in d (i) above to the rest of the crops (1
mark)
v. Add gridlines to the worksheet
(2 marks)
vi. Create a left header and insert your name
(1 mark)

QUESTION 8
i. Create a database named “Client Details” and save it in a removable disk
(1 mark)
ii. Design a table named “Bookings”
(4 marks)
iii. In the table named “Bookings” enter the following data:
CLIENT NAME DoO ROOM NO WING
Chendamale Zomba N10 North
Chibwatiko Chikwawa E22 East
Lukhele Nsanje N12 North
Hoto Blantyre W08 West
Kamoto Lilongwe S22 South
Davison Salima S19 South
Kalata Mchinji E18 East
Mwabumba Machinga W11 West
Lihuta Mzimba W12 West
Kangwa Dowa E20 East
Chigule Salima E29 East

iv. Set primary key on Room No field

(2 marks)
v. Using query method, filter all clients who booked rooms in
a) South wing and name the resulting query as “Southerners”
(1 mark)
b) North wing and name the resulting query as “Northerners” (1
mark)
c) East wing and name the resulting query as “Easterners”
(1 mark)
d) West wing and name the resulting query as “Westerners”
(1 mark)
vi. Create a columnar form from the table “Bookings” of all the fields
(2 marks)

Page 6 of 6