4021Q3 SPECIMEN COMPUTER SCIENCE

Extracted Content: 4021Q3 SPECIMEN COMPUTER SCIENCE

Page 1

Extracted Text

ZIMBABWE SCHOOL EXAMINATIONS COUNCIL

General Certificate of Education Ordinary Level

COMPUTER SCIENCE 4021/3

PAPER 3 Practical

SPECIMEN PAPER 3 hours

Additional materials:
cD

TIME 3 hours
INSTRUCTIONS TO CANDIDATES
Insert your name, Centre number and candidate number as a header.
Answer all questions.
Indicate software you use for each question.
All answers must be printed.

Submit both the hard copy and soft copy of your answers.

INFORMATION TO THE CANDIDATE

1. This paper consists of questionon: Programming 50 marks,
Database 30 marks
Web design 20 marks
Paper totalis 100 marks

The number of marks is given in brackets [ ] at the end of each question or part question.

This question paper consists of 4 printed pages.

Copyright: Zimbabwe School Examinations Council, Specimen paper
©ZIMSEC Specimen paper [Turn over

---

Page 2

Extracted Text

Answer all questions.
For each question, indicate software used.

Design an interface and write a code that prompts a user to enter his/her name
then, the output will be shown e.g. “Hello Chipo.”

Create a program code to generate a random number between 1 to 6.
Y ou can use the random class.

Click to generate random
number

[|

Produce the interface above.

Write a program code to display the harsh pattern as shown below.

eH He ROE
eH He ROE
eH He ROE
eH He ROE
eH He ROE

Print the code and interface above.

Write and design a program to determine whether an input number is an even
number.

Print the code and the interface

(a) Create a website with the following:
The title of your Website is “Matulise;”
Welcome to Frecy High School;
We offer practical subjects at ‘O’ Level;
We offer Arts, Commercials and Sciences at ‘A’ Level.
(b) Show pictures on the website you created in (a).
Save document as ‘School.’
Print web pages created.

4021/3 Specimen paper

[10]

[15]

---

Page 3

Extracted Text

(a) Create three related tables, ‘customer’, ‘products’ and ‘orders’ as

shown:
Customers
Customer ID | First Name | Last Name
1 Peter Homela
2 Gibson Ndlovu
3 James Moyo
4 John Sibanda
5 Alfred Matare
6 Susan Brown
7 Thomas Meki
8 Tafadzwa Chaminuka
9 Thulani Mangena
10 Solomon Mhlanga
11 Charles Jones
Products
ProductID | Product Name | Price
1 Deskjet Printer | $200
2 Dell Desktop $190
3 Laptop $175
4 Toner $50
5 Cartridge $40
6 Canon Printer $65
7 Typek A4 $25
Orders
Order ID | CustomerID | Product ID
1 1 1
2 2 2
3 10 3
4 10 4
5 3 5
6 4 1
7 5 3
8 6 6
9 7 4
10 8 2
11 1 6
12 6 1
(New) 0 0
(b) Establish the relationship among the tables in (a). [15]
Print the screenshot of the result. [4]
4021/3 Specimen paper

Turnover

---

Page 4

Extracted Text

d)

e)

Using tables in (a), create a query that returns the Firstname and
Lastname of all customers who have ordered a product.

Name it “Customer orders.”

Produce a report from ‘product’ table in (a) and name it “Customer
report.”

Export the report in (d) to a package of your choice.

4021/3 Specimen paper

[5]

[4]
[2]

---