Name: ________________________________________________________ Class: ________________
BWAILA SECONDARY SCHOOL
2025/2026 END OF TERM I FORM 3 EXAMINATIONS
COMPUTER STUDIES (PAPER II)
December 2025 (50 marks) Time Allowed: 2 h 30 min
Instructions
Question Tick if Do not write in
1. This paper contains 5 printed pages.
number answered these columns
Please check.
2. This paper has three practical questions to
be answered using a computer. After
1
completing each question, print your
work. Save the answers on a removable
2
disk or CD to be submitted with the printed
copies. Questions 1 and 2 carry 20 marks
each and question 3 carry 10 marks. 3
3. After saving your work on the removable
TOTAL
disk or CD, delete any work that you may
have saved on the computer. Failure to
follow this instruction may lead to other candidates copying your work and this may lead
to disqualification.
4. Write your Full Names(s) and Class at the top of each page used as an answer sheet and
on the removable disk/CD.
5. At the end of the paper, submit all printed work and the removable disk or CD used.
Page 1 of 5
Name: ________________________________________________________ Class: ________________
1)
Scenario
The Bwaila Secondary School Examination Committee requires a worksheet to calculate
student performance based on Continuous Assessment (CAT). Follow the instructions
carefully.
a) Open Microsoft Excel and create a new workbook. Save it as: “F3_CAT_Scores”
(1 mark)
Student Name CAT1 (40) CAT2 (60) Total Score (100) Average Mark Grade
Linda Chirwa 35 55
Peter Nkhoma 20 38
Mary Phiri 30 40
James Mwale 25 50
John Banda 40 60
b) Enter the student data above into the worksheet exactly as shown: (3 marks)
c) Use a formula to calculate the Total Score for each student using absolute cell
referencing. (3 marks)
d) Use a suitable function to calculate the Average Mark for each student. (3 marks)
e) Use a conditional statement (IF function) to assign the correct Grade for each
student based on the Average Mark: | A (80 - 100) | B (70 - 79) | C (60 - 69) |
|D (50 - 59) | F (Below 50)| (3 marks)
f) Center-align all column headings and bold the entire header row. (2 marks)
g) Sort the entire data table by Total Score in descending order. (2 marks)
h) Add a header with your full name and class and a centered footer containing the
current Date. (2 marks)
i) Print the worksheet showing gridlines and in landscape orientation. (1 mark)
Page 2 of 5
Name: ________________________________________________________ Class: ________________
2)
Scenario
You are required to design a marriage engagement invitation card using MS
Publisher. Use the exact details provided below.
a) Create a new publication and save it with the name: “Marriage_Invite” (2 marks)
b) Set the page size to B5 and orientation to Landscape. (1 mark)
c) Insert the following text exactly as it appears and place each item appropriately
for an invitation card:
WEDDING INVITATION
MARY WEDS JOSEPH
Date: 14th June, 2026
Venue: Bwaila Gardens, Lilongwe
Time: 09:00 AM
(5 marks)
d) Insert a text box covering the whole page the do the following:
i) Apply a Border Art know as “Balloons…3 Colors” to the text box.
ii) Send the text box backwards (to the bottom of the stuck). (2 marks)
e) Insert the picture Desktop/ExamDocuments/wedding_rings.jpg. and do the
following
i) Adjust it to cover the entire printable area. In picture format on quick style
select Metal Frame
ii) In picture format recolor the picture to “RGB (255, 192, 0) Accent 4
Dark”. Then send the picture backwards to the end of the stuck. (3 marks)
f) Apply the following formatting to the text
i) Wedding invitation must be bold and font size 48 pts
ii) MARY WEDS JOSEPH, font 36pts, font name “Bradley Hand ITC” Bold
iii) Date and time must be Times New Roman font 20 pts
iv) Venue in font named “Curlz MT” with font size 22 pts. (3 Marks)
g) Export the finalized work to jpeg format and save it in the USB drive (2 marks)
h) Save in USB drive and print the completed invitation card. (2 marks)
In the next page is the sample of the finalized work.
Page 3 of 5
Name: ________________________________________________________ Class: ________________
Page 4 of 5
Name: ________________________________________________________ Class: ________________
3)
Scenario
You are required to create a class presentation to review the topic DTP Software using
MS PowerPoint. Follow the instructions exactly.
a) Create a new presentation and save it with the name: “DTP_Review” on a
removable disk/USB drive. (1 mark)
Create three slides with the following titles and simple content: (2 marks)
i) Slide 1: Desktop Publishing Software Review
Subtitle: By “Your Name”
ii) Slide 2: Definition
Content: Software used to create documents like newsletters, invitations,
and posters.
b) On Slide 3 (Benefits), insert a SmartArt graphic called “Basic Process” found on
process. Position it neatly on the slide and write these benefits in it as below.
(3 marks)
c) On the Slide Master, change the Master Title Style font to: (1 marks)
i) Font: Garamond ii) Size: 40 points
d) On the slide master insert your name, current date and time and slide page number
to be displayed in each slide footer then apply the Cube transition to all slides.
(2 marks)
e) Print the presentation as a handout showing 4 slides per page. (1 mark)
END OF QUESTION PAPER
Page 5 of 5