,,

ZIMBABWE

MINISTRY OF HIGHER AND TERTIARY EDUCATION, SCIENCE AND

TECHNOLOGY DEVELOPMENT

HIGHER EDUCATION EXAMINATIONS COUNCIL

MASHONALAND WEST AND CENTRAL REGION

COURSE: COMPUTER OPERATIONS AND PACKAGES

COURSE CODE: 115/20/CO/0.

SESSION: 2021-2022
Theory Assignment 1

QUESTION 1

a. With aid of examples briefly define the following terms as they are used in computing.
i. Output [1]
ii. Computer [1]
iii. Assembler [2]
iv. Dumb terminal [2]
v. Character [2]
vi. Storage device [2]

b. What do the following abbreviations stand for as used in computers?

i. HTML [1]
ii. LCD [1]
iii. OMR [1]
iv. GIGO [1]
v. HD [1]
vi. MODEM [1]

QUESTION 2

a. State the device used for the following:

i. Printing using heat [1]
ii. Used for fast clearance of cheques in banks [1]
iii. An input device that is sensitive to touch [1]
iv. Used in playing games [1]
v. Its contents can be erased only by exposure to ultra violet light [1]
vi. Can be used to determine name of product,supplier,size,price and quantities left at apoint
of sale system [1]
vii. It squirts/sprays droplets of ink that are directed by the electric field to paper and form
characters when printing [1]
viii. Is responsible for interpretation of instructions and regulates the flow of signals to
hardware components [1]
x. Detects pencil or ink marks made on certain locations of a document and is mainly used for
marking multiple choice exam papers by Zimsec, questionnaires and lottoj l]
xi. A drive used to read an optical disk but cannot write on it [1]
xii. A machine that can transmit documents containing both text and graphics overtelephone
lines [1]
QUESTION 3

a.Though computer networking has a number of advantages such as speed in transfer of files,
minimized costs due to resource sharing, centralized control and monitoring of computer resources
use which is easier and more convenient. There are a number of drawbacks of networking
computers.Outline any four such disadvantages [4]

b. Matika group of Companies is planning to change their secretarial department equipment. As a

computer expert you have been consulted on the use of electronic databases as a good move than
their traditional filling system. Outline three advantages of electronic database over traditionalfilling
system. [3]

QUESTION 4

a. Differentiate between a transaction file and a master file. Explain their relationship [4]

b. Differentiate the following:

i. Data and information [4]

ii. Main memory and Backing storage [4]

iii. Online data processing and batch data processing [4]

50 Marks
Theory Assignment 2

QUESTION 1

c. Computer software can be divided into two sections/operating system and application
software.State any two examples of operating system and two examples of application
software [5 marks]

b). List any five (5) features of a good word processing package [5 marks]

c). Explain briefly the meaning of the following word processing terms

(i). Indentation

(ii). Orphan

(iii) . Orientation

(iii). Page break [5 marks]

d). Explain the meaning of the DOS commands:

(i). CD

(ii). MD

(iii). Copy

(iv). Delete

(v). Rename [5 marks]

e. Outline the difference between:

i. backspace and delete keys [4 Marks]

ii. Data and Information [4 marks]

iii. Simplex and Full duplex transmission models [4 Marks]

f. Draw and label a mouse [3 Marks]

 ,,

QUESTION 2

a. Name any three spreadsheet program you are familiar with [3 marks 1
b. Madzima Stores has several departments, below is an abstract from their salaries department.
Employees have just received a salary increase and bonus this month.

A B C D E F G
1 SALARY REVIEW
2 FIRST SURNAME BRANCH GRADE SALARY SALARY BONUS NEW
NAME ($) INCREASE ($) SALARY
($)
3 Nakai Chimwaura Bindura D 800 150
4 Tatenda Muneri Muzaraban B 1700 350
i
5 Maita Kufa Nyanga C 950 200
6 Thandeka Ndlovhu Masvingo C 950 200
7 Xandaier Manzunzu Mahuwe A 1800 450
8 Byron Nhengu Harare D 800 150
9 Lameck Chigaro Gweru B 1700 350
1 Vimbiso Chiwandamira Chinhoyi A 1800 450
0
1 Proud Chibaya Harare C 950 200
1
1 Mary Gwaindepi Masvingo A 1800 450
2
1 Givemor Mangadze Hwata B 1700 350
3 e
1 Kuda Mutashu Mutare C 950 200
4
1 Alexio Mashayamom Centenary D 800 150
5 be
1 Total
6
1 Average
7
1 Maximu
8 m
1 Mimimu
9 m
2 Count
0
 v

Salary increase is 15% of the total salary

New salary is salary + salary increase + bonus

i. How much is the new salary for:

Mary Gwaindepi [2 marks]
Byron Nhengu [2 Marks]
GivemoreMangadze [2 Marks]

ii. State the formula for:

Average salary being paid currently [3 marks]
Total new salary paid by the company [3 marks]
50 marks

..
PRACTICAL1

Question la: WORD PROCESSING

Type and print the following passage as it is using Times New Roman font type. (5MARKS)

How Can I Avoid Dangers on the internet?

Little wonder, then that some expects that over 320 million people will be using the internet by the
end of this year. Use of the Internet is thus becoming common place in many parts of the world.
With schools and libraries aggressively promoting its use, millions of young people have access to it. In
the United States, nearly 65% of youth between the ages of 12 and 19 have already used or subscribed
to on-line services.

Properly used the internet can be a source of helpful information on the weather, travel, and other
subjects. Through it you can buy books, car parts and other things. Many use it for school work

Although the internet can be useful, it can also seem like a library without a librarian or other
observers. One can browse it with the feeling that no one else is around. But this is one of the greatest
dangers of using the internet. Why? Because countless Web sites contain material that is morally
corrupt and destructive.

"Some Web sites

are shocking. They
can pop up without
warning"

l(b) Insert a header of your school name and footer of your name? (2marks)

(c) Insert a column break into two to the passage above (2marks)

(d) Center the heading (2marks)

(e)lnsert a special character to the bottom of the page (2marks)

(f) Print the passage in landscape orientation (lmark)

(g) Insert a watermark of your first name? (lmark)

(h) Create a table below? (10marks)

 OUR SCHOOL GARDEN

ORANGES PLANTS

NAMES

Plantation A Good .•...

Vl Vl
Q)
0
0 .•...
Vl 0.0
ro
~
.•... 0 ..c c:
Q)
~
~ ..c 0
Q) rtl rtl c:
.o U u 0

Plantation B Dry No Yes Yes No Mike

Plantation C Wet Yes Yes Yes No John

Plantation D Very wet No No Yes No Ashton

TOTAL (25 Marks)

QUESTION 2 MICROSOFT EXCEL

Below is a spreadsheet

A c 0 E F G H
Qty in stock Min order Qty Min re-order level Price exc VAT
12 5 10 325
15 5 7 287
20 10 15 475
10 5 5 19
26 10 10 55
30 15 10 23.99
45 20 10 7.5

2a) Name the spreadsheet package you are using (lmark)

(b) Name the cells that we can find the following data 325, 7.5 and 23.99? 3marks)

(C) Calculate the total min order Qnty from the spreadsheet above and display the formula you have
used? (3marks)
 "
(d) Subtract D3 from C3? (2marks)

(e) Find 17.5% of cell F4? (2marks)

(f)Find the average of cells C3 to C9 inclusive? (2marks)

(g) Add the cells F2 and F3 and then divide the total by cell e5? (2marks)

(h) Create a bar graph to display all prices exc VAT? (3marks)

(i) Format the columns of Price exc VAT to currency? (3marks)

(j) Print the bar graph in landscape? (lmark)

(0) Multiply cells E5 and F5 (2marks)

(00) add the total of min order quantity (2marks)

TOTAL (30 MARKS)

Question 3 Database

A large second hand car company keeps details of all its cars in stock using a series of records held in a
filing cabinet. It is decided that the data should be transferred to a database held on a computer.

Here is part of the file:

(a) Create and save database called CARSALEDATABASE(Smarks)

MAKE MODEL PRICE YEAR TYPE MILEAGE

Nissan Sunny l.4L $45000 93 saloon 24000
Nissan Sunny1.4G $24500 92 Saloon 35000
Ford Mondeo $72000 97 saloon 34000
Ford Escort $35000 95 saloon 56000
Nissan 200sx $55600 95 sports 6600
Nissan 300zx $56800 96 sports 56070
Honda Civic $88000 96 saloon 10000
Mercedes 230 $200000 92 Saloon 7600
Nissan micra $330000 94 saloon 14000
(b) Reload your database and make the following amendments:

• the Nissan sunny for $24500 is actually a Nissan sunny l.4GLX 91 {1m ark)
• The Mercedes 230 needs price reducing to$129000 (lmark)
• Honda Civic is a 99 model {1m ark)
• Nissan 300zx needs price increase to $7885600{lmark)

{c)The following cars have been sold so their details need deleting from the database.

• Nissan 200sx $556000 95 sports 6600 (lmark)

• Ford escort $35000 95 saloon 56000 (lmark)
• Nissan micra $330000 94 saloon 14000 (lmark)

(d) The following cars have come in so their details need to be added to the database. Make
amendments and print the sheet. (5marks)

Nissan elegant $34089 98 saloon 5600

Ford bantam $435000 99 saloon
Nissan primera $345600 93 saloon
Toyota chaser $678900 95 sports
 (e) Create a form of Nissan models (3marks)

Total 25 marks

QUESTION 3

DESKTOP PUBLISHING
(a) Using a DTP software package of your choice create an advertisement of a hardware selling
company selling computer accessories. The advertisement should contain the following
information
./ Name of the company (2marks)
./ Picture of some computer hardware (2 marks)
./ Suitable marketing language (3marks)
./ Use Times New Roman font type (lmark)
Print the advertisement (2marks)

TOTAL 10 MARKS •

QUESTION 4

POWERPOINT

Imagine you have been asked to make a presentation of selling cars .You will need the following four
slides

Introduction

Types of cars

Model of the cars

Costing

(a) Create an introductory first slide with the title of the presentation, your name and a suitable
picture .AII of the other slides should have a title taken from the above list
(b) On slide 2 add bullets to the list of cars you are selling
(c) Save and print a copy of all slides.

TOTAL 10 MARKS
MARKING GUIDE ASSIGNMENT 1

WORD PROCESSING

QUESTION 1

QUESTION ITEM MARK

a(i) Tab stops with leader 2
characters
Font size 12 2
5 paragraph of varying 5
bulleted list
Evidence of spell checking in 5
each paragraph
Numbering 1
b(i) Word art heading "contents 1
Visible Word Art heading
(ii) Whole document font size 2
16
Monotype corsiva or dry 2
handwriting font .
(iii) Semi transparent watermark 1
Diagonal watermark 1
Watermark text (sample 1
exam)
(iv) Name and surname header 1
Left aligned 1
(v) Art page border 1
(vi) Any picture 1
(vii) Printout one side A4 portrait 1

SPREADSHEET

QUESTION 2

QUESTION ITEM MARK

a(i) Correctly entered data in columns (each column 1 4
mark)
b(i) Table heading merged 1
Centred 1
(ii) Shaded column headings (with visible data) 1
(iii) Row labels
-Total 1
-Average 1
 -Minimum 1
(iv) Calculated
-Total 1
-Average 1
-Minimum 1
(v) All figures to 1 decimal place 1
(vi) Border and lines whole worksheet 2
(vii) Display formula 1
c(i) Pic chart on water content percentage for 5 fruits 2
(ii) Chart title fruit water percentage above chart 1
(iii) Label category name and value 2
(iv) Removed legend 1
(v) Pie chart on its own page 1

DATABASE

QUESTION 3

QUESTION ITEM MARK

a Evidence of car stock list database on screen dump 1
Cars table 2
Cars table without typing errors 2
b(i) Nissan micra changed to Nissan note 1
(ii) Citroen Picasso price reduced 1
c Added 2 cars ,Nissan micra and Ford mondel to 2
cars table
d Sold cars, "Chrysler and Opel deleted 2
e(i) Sorted cars file 2
Alphabetically according to make starting with As
(ii) Numerically according to price with most 2
expensive at the top
f(i) Query: for all cars less than $ 5,000 2
(ii) All Ford cars less than $ 13000 query 2
(iii) All cars costing between $ 5000 and $ 8000 2
(iv) All sports cars 2
g Tabular report 1
Grouped by type 2

QUESTION 4

QUESTION ITEM MARK

a(i) Business cards printout with student photo as logo 1
School name as text 1
 ,

(ii) Name and class as title 2

(iii) Filled in text boxes with relevant information ( at 3
least 3 text boxes filled)
(iv) Visible formatting 1
(v) Printout 1

QUESTION 5

QUESTION ITEM MARK

A(i) Title slide J storage devices 2
(ii) At least 4 storage devices bulleted list 4
(iii) Picture slide of storage device (choice) 2
PRACTICAL 2

QUESTION 1: WORD PROCESING [30 MARKS]

(i) Use a word-processing package to type the passage below, using font type Comic Sans, size
14 and double line spacing. [4]
(ii) Save as 'Coursework "1' and print a copy [5]

CCTVcameras

Electronic security cameras have helped cut down violent crime and robberies in many of our city
centres. Sometimes these cameras are visible and act as a deterrent, whereas others are hidden
and are used during police surveillance. Although most people feel safer in city centres with the
use of these cameras, some people feel that they are an infringement of privacy. Cameras are also
used for traffic control at busy junctions and on motorways.

Information technology in the supermarket

Most large stores now use barcode readers, which are commonly called laser scanners, to input
product details into the computer system. The objectives of the scanning system are to improve
the service to customers and to increase company productivity and profits. The picture below
shows the scanning system used to scan in a barcode.

The scanning system uses a laser beam to read the bar code on the goods. The bars contain the
same information as the numeric code at the bottom of the barcode without the likely inaccuracies
of typing the number in. As the barcode is passed across the scanner this number is read and the
price and description of the goods are obtained from the computer, the sale registered and an
itemized receipt produced

(iii) Display the question number and your full name as a left aligned header. [2]

(iv) Insert a diagonal watermark "NFC COURSEWORK2021" [1]

(v) Insert any relevant picture at the bottom right of the document. [2]

(vi) Divide the second paragraph into two columns with line between. [2]

(vii) Use any word art style to insert a centered heading "Computer Applications" to the
document. [2]

(viii) Put an art page border to the whole document. [1]

(ix) Save as Coursework 2 and print [1]

 ,,

c) Create the table below as it is. [10]

SHAPES

Square

i)

G
~ Horizontal
scroll

ii)

'-'

iii)
~

iv Hie
QUESTION 2: SPREADSHEET [25 MARKS]

a. i) Type the name of the spreadsheet package you are using to answer this question. (1)
ii) Create a spreadsheetbelow, as it is and save it as Results. (2)
iii) Put borders to the spreadsheet but do not include the two headings in rows 1 and 3
(1)
iv) Merge and centre the headings. (2)
v) Put Grey shading in rows one and three (1)
Microsoft Excel

Data Review View

• IK ~·l 1= - =I@~'" I
11 • ~WrapText General

!l·lIw·II~·.A.·IIs-
I
~ -slli~t~1 ~Merge&Center.

Font r. Alignment Number

G12

~ RESULTS

A I B ! C D E F H
1 ABC ACADEMY ACADEMY (PVT) LTD

+1
~
4
SECRETARIAL STUDIES RESULTS

BUSINESS •
TYPEWRITING SHORTHAND ENGLISH ACCOUNTS
6I~:N~~I 95 77 78 88
7 FARAI 65 86 58 85
8 JANE 69 45 69 90
~9 SUE 88 89 25 89
01MELODY 77 99 63 80
11
12 "-- __ 1
13
~ 14

~J
~~
~
-~~1
22,
1< ••• 1 I Sheet!

Ready I

1= P [DJ I!!I II ()o aa a a Q

b. i) Create a columnnamed 'TOTAL' in cell FS (1)
ii) In cells A11 to A14 type the following headings: CANDIDATURE, AVERAGE, HIGHEST and
LOWEST. (4)
c. Use formula to calculate the
i) Total number of candidates for SHORTHAND (1)
ii) Average mark for each subject (1)
iii) Highest mark per subject (1)
 iv) Lowest mark per subject [1)
d. i) Sort the data in ascending order of name [1)
ii) Format all the average marks to 1 decimal place [1)
iii) Insert a header 'YOUR NAME AND CLASS' then print [1)

e. i) Create a column graph to show all the students' marks per subject [2)
ii) Add a chart title 'SECRETARIAL STUDIES RESULTS' [1)
iii) Label the vertical and horizontal axis appropriately [2)
iv) Show data labels on inside end [1)
QUESTION 3: DATABASE [25 MARKS]

a) Create a database caliedCAR STOCK LlSTand in tableCARSenter the following data: Verify the
data by proofreading and then save and print a copy. [4)
MAKE MODEL PRICE YEAR TYPE MILEAGE
Honda Legend $17,000 2009 Saloon 23,000
Ford Focus $9,800 2007 Estate 30,000
Chrysler Sebring $5,600 2006 Saloon 25,000
Audi A4 $2,300 2009 Sports 65,000
Volvo C70 $14,000 2010 Saloon 15,000
Peugeot 307 $3,900 2004 Saloon 27,000
Ford Focus $12,000 2009 Estate 13,000
Ford Mondeo $10,000 2008 Saloon 45,000
Porsche 911 $45,000 2009 Sports 30,500
BMW 325 $29,000 2009 Sports 23,000
Vauxhall Corsa $6,000 2010 Saloon 35,000
Fiat 500 $5,000 2010 Saloon 11,000
Volkswagen Golf $8,000 2009 Saloon 15,000
Ford focus $11,950 2010 Estate 12,000
BMW X5 $32,650 2010 Estate 8,000
BMW X5 $34,500 2009 SUV 3,000
SUZUKI Swift $7,999 2010 Saloon 13,000
NISSAN Micra $3,600 2007 Saloon 45,000
Ford C Max $14,000 2009 MPV 24,000
Citroen Picasso $15,750 2008 MPV 30,000
Toyota Yaris $10,000 2009 Saloon 38,000

b) Reload the database and make the following amendments and print
 -,

i} The Nissan Micra for $3,600 is actually a Nissan Note [1]

ii} The Citroen Picasso needs its price reducing to $14,995 [1]

c} The following cars have come in, so they should be added to the database: [2]
Nissan Micra $25,500 2003 Saloon 72,000
Ford Mondeo $3,560 2003 Saloon 55,000
Save the database
d} The following cars have been sold so their details need deleting from the database:
Chrysler Sebring $5,600 2003 Saloon 25,000
Opel Corsa $6,000 2003 Saloon 35,000
After deleting these records, save the database. [2]
e} Sort the CARS file
i} Alphabetically according to make, with the As at the top of the file. [2]
ii} Numerically according to price, with the most expensive car at the top [2]
Produce a printout for each one.
f} Search for
i} Details of all cars costing more than $5,000 [2]
ii} Details of all Ford cars costing less than $13,000 [2]
iii} Details of all cars costing between $5,000 and $8,000 [2]
iv} Details of all sports cars [2]
g} Print a tabular report of all cars in the database grouped by Type [3]

QUESTION 4: DESKTOP PUBLISHING [10 MARKS]

a. Create an advertisement using THE WORKS classic design template [2]

b. i} Use copperplate gothic font scheme for the advertisement heading. You can use various fonts of
your choice for other parts of the advertisement. [2]

ii} Use the rectangle page size option. [1]

iii} Customize the template text to suite the title of your advertisement [5]

QUESTION 5: POWERPOINT [10 MARKS]

a. Your school head has asked you to create a presentation for the whole school about the 2020
results. Your presentation should have following slides
i} Title slide 'YOUR SCHOOL NAME 2020 '0' results' [1]
ii} Slide 2: The following table
 ,,
[3]
2020 '0' LEVEL RESULTS
SUBJECT MALE FEMALE
ENGLISH 56 60
MATHS 75 50
INTEGRATED SCIENCE 80 77
GEOGRAPHY 95 86
ANY INDIGENOUS LANGUAGE 84 90
HISTORY 88 90

iii) Slide 3: The following Column graph [3]

100
% 90
80 -
70
p 60
50
a 40
s 30
20
s 10
o • MALE

• FEMALE

subject

iv) Slide 4: Your photograph as the overall best candidate. Put a label at the bottom of the
photo OVERALL BEST 2020. Write your name in a text box inserted at the top right corner of
your photograph. [2]

b. Print all the slides on one page [1]

MARKING GUIDE

WORD PROCESSING

QUESTION ITEM MARK

l(i) Comic sans 1
Size 14 1
Double line spacing 1
As it is left aligned 1
(ii) Printout of original 5
l(iii) Header with question number 2
And full name

l(iv) NFC Coursework 2021 1

Diagonal watermark
l(v) Picture at bottom right of 1
Document
Relevant picture 1
l(vi) 2nd Paragraph 2 columns 1
Line between 1
l(vii) Heading Computer Applications • 1
In word art
Centred 1
l(viii) Art page border 1
l(ix) Printout 1
Square with text added 2
l(c)(ii) Scroll with text added 2
l(c)(iii) Arrow with text added 2
l(c)(iv) Callout with text added 2
1c Table 2
TOTAL 30

SPREADSHEET

QUESTION ITEM MARK

2(a)(i) Spreadsheet name 1
2(a)(ii) Spreadsheet creation 2

2(a)(iii) Borders excluding headings 1

2(a)(iv) Merge and centre 2 headings 2
2(a)(v) Shading on row 1 heading 1
2(b)(i) Total column heading in cell FS 1
2(b)(ii) headings in cells All to A14 4
 "
2(c)(i) Calculation of values for:
-Count 1
-average 1
-highest 1
-lowest 1

2(d)(i) Sorted in ascending order by name 1

2(d)(ii) Average marks 1 decimal place 1
2(d)(iii) Header "student , name of class 1
2(e)(i) Column graph containing all student marks per 2
subject
2(e)(ii) Chart title "Secretarial studies results. 1
2(e)(iii) X axis labels 1
2(e)(iv) Y axis label 1
Data labels on inside end 1

DATABASE

QUESTION ITEM MARK

3(a) Original database table 4
(b) Table with amended details ie. Nissan Note and 2
citroen's price of $14,995

(c) Table with added records ie. Nissan Micra and Ford 2
Mondeo
(d) Table with deleted records ie. Chrysler Sebring and 2
Opel Corsa
(e) (i) Soarted table according to make 2
(ii) Sorted table according to price
2
(f) (i) Query for cars more than $5000 2
(ii) Query for ford less than $13000
(iii) Query for cars between $5000 and $8000 2
(iv) Query for all sport cars
2

2
(g) Report for all cars 1
Tabular 1
Grouped by Type 1
 ,,

4. a) WORKS CLASSIC DESIGN 2

b.i) copperplate gothic heading 1
any font for other parts 1
ii) rectangle page size option 1
iii) Any 5 sections of template appropriately customized 5

PRESENTATION

5. a)i) Title slide showing THE SCHOOL NAME &2020 '0' 1

results
ii) Table created 1
Table heading merged across all the columns as 1
shown
All text entered accurately 1
iii) Column graph 1
X and Y axis labelling 1
Legend displaying MALE and FEMALE 1
iv Student photograph • 1
Student name in text box 1
v) Printout of all slides on one page 1
 'Practical Test TERM2

. QUESTION 1

Q1 a) Type the passage below as it is and save it as comp1 and print [4]

Computer graphics

Computer graphics is the generation of images through computer. It includes simple text displays as
well as images that appear to be in three dimensions.

An important part of the computer graphics is computer visualization, which attempts to pictorially
display data in a way that is most understandable for the user. For instance, visualization can allow
surgeons to preview a surgical procedure before actually performing it. Other forms of visualization
involve data that have no natural pictorial form. As a result, these must be displayed in a form that tells
a story or makes a point. If you've seen a graph or chart with a computer program that seemed to have
~ no clear meaning, you know why this area is important.

Like many areas in computer science, computer visualization is as much human psychology as
machine capability. The computer visualization expert asks, "How do we as human beings process
visuals?"

As computer graphics become more advanced, they termin.ate at a point called virtual reality, in which
graphics and sensory feedback are all-encompassing. This can be seen, for example, a room in which
every surface is covered with synchronized computer displays. It's important to note that virtual reality
does not promise an experience understandable from the "real world", although that may be a goal for
some researchers. Rather, it is an experience in which the outside world is temporally blocked from our
senses.

Retrieve comp1 and do the following

b) Centre the heading and underline it. [2]

c) Insert a border covering the heading only [2]

d) Insert a drop cap on paragraph 2 and 4 dropped to 4 lines [2]

e) Fully justify the document, save it as comp2 and print [2]

o Put a watermark with text on the heading of the document [2]

g) Apply an art page border of your choice [3]

h) Below the last paragraph put a word art [3]

i) Insert a picture below the heading of a clip art relevant to the heading. [3]

j) Replace the occurrence of the word "computer graphics" with the word "PC art" excluding the
heading. [3]
 ". k) . Change the line spacing of the document to 1.5, format the whole document to italics. Save it as
comp3 and print. [4]

QUESTION 2

Part of a spreadsheet below holds a table of product details.

Selling price= Cost Price + Mark up (Mark up = 1.2%)

a) Enter the details shown in a spreadsheet and print. [5]

CHIMUTI COMPUTER ACCESSORIES
Product Part Cost Mark Selling Profit
number Price up price
Bar Code Reader 1000 BCR123 105
CD ROM DRIVE 12 speed CD1286 210
Color Scanner 24/600 CS24600 450
Ink Jet Printer 100 IP100 120
Keyboard 11 KB185 43
LaserWriter 4040 LW4040 675
Total

b) Use appropriate formulae to calculate the following·

i) Mark-up for each product. [3]
ii) Selling Price for each Product. [3]
iii) Profit for each Product. [3]
iv) Totals for Cost Prices, Selling Price and Profit. [3]
c) Format all values except Mark-up to currency with 2 decimal places. [3]
d) Create a pie chart for the columns product and profit. [5]
.~ QUESTION 3

Show manufacturing company wishes to keep records of its customers and type of shoes purchased.
Design a database and a form with the following fields: Date of purchase, Type of shoes, Colour of
shoes, Quantity bought and Customer name. Save and print the database [5]

(a) Print a tabular form sorted by type of shoes in descending order for the database [5]
12 June 1999 Tommy Brown 300 TM
13 July 1999 Tommy Black 250 OK
01 May 1999 Moccasin Black 200 Express
22 April 1999 Moccasin Brown 300 Edgars
17 August 1999 Tommy Brown 250 Express
21 October 1999 Weinbrener Black 275 TM
17 September 1999 Weinbrener Tan 400 OK
04 September 1999 Weinbrener Brown 500 Express
03 August 1999 Marie Clair Black 450 Edgars
14 October 1999 Marie Clair White 425 Edgars
13June1999 Marie Clair Brown 430 OK
10July1999 Tommy Black 290 Express
 ALL REPORTS SHOULD BE ON LANSCAPE
(b) Giving appropriate titles, print:
i) A report of all brown shoes from Express Stores [5]
ii) A list of all Moccasin shoes [5]
iii) A report of all Edgars orders made after July 1999 [5]

QUESTION 4

Your school is having an inter house competition. You have been tasked to create a brochure to be
distributed to special invited guests as well as parents. The brochure should show the following and
some items of your choice.

Include the following

i) Message about the event

ii) Relevant image
iii) Programme of events
iv) Record set before by sporting houses
v) Officials and duties/responsibilities

(a) Correct publication style and template [3]

(b) Appropriate image placement [3]
(c) Correct order [3]
(d) Eye catching creativity [3]
(e) Use of text or other formatting styles [3]

QUESTION 5

(a) You are a mentor at a COMPUTER college. You are required to create a presentation
entitled, "BUSINESS TODAY"'. [3]
(b) Create a second slide with a clip art in relation to business. [3]
(c) Display the following information on a relevant slide [4]

Manual System Automated system

Slow on data retrieval fast
Requires a lot of labour requires less labour
Prone to errors high level of accuracy

(d) Insert a centre aligned footer of your name [2]

(e) Print all slides on one page in portrait [3]
Practical test marking guide

1. (a) Typing a complete passage 1

Accuracy (no errors) 1
Paragraphing 1
Printing 1
(b) Centre heading 1
Underline heading 1
(c) Border on heading text 2
(d) Drop cap on the appropriate paragraphs 1
4 lines dropped 1
(e) Whole document justified 1
Printing 1
(f) Inserting watermark 1
Correct text watermark (computer graphics) 1
(g) Inserting a page border 1
Art page border 1
Border not disturbing text visibility 1
(h) Position of word art (after last paragraph) 1
Inserting word art 2
(i) inserting a picture 1
Below the heading position 1
Relevant to the heading 1
(j) "Computer Graphics" replaced within the document (3 occurances excluding
heading) 3
(k) Changing line spacing to 1.5 1
Formatting whole document to italics 1
Saving 1
Printing 1

2. (a) Title of spread sheet as it is 1

Column headings bold 1
Subheadings wrapped 1
Entering text 1
Worksheet borders 1
(b) (i) One mark for two products 3
(ii) One mark for two products 3
(iii) One mark for two products 3

1
 (iv) Totals: cost price, selling price, Profit 3
(c) Formatting correct columns (except markup) 1
Each column changed to currency 1
Each column values charged to two decimal places 1
(d) Correct range selection 1
Labelled sectors 1
Chart title 1
Legend 1
Chart Displayed separately from the worksheet 1

3. (a) Table All field names 1

All records displayed 1
Correct order of records 1
Save 1
Print 1
Form form created 1
Tabular form 1
All field names 1
All records 1
Sorted by shoe type (descending) 1
(b) (i) Report creation 1
Appropriate report title 1
Report on landscape 1
»<. All field names displayed 1
Brown shoes from Express stores 1
(ii) Query for Mocasin shoes only 2
Query appropriate title 1
All field names displayed 1
Printed query 1
(iii) Report creation on Edgars orders after July 1999 2
Appropriate report title 1
Report on landscape 1
All field names displayed 1

4. (a) Choosing brochure 2

Appropriate template 1
(b) Relevant image 1

2
 Reasonable image scaling 1
Appropriate position 1
(c) Appropriate layout 2
Correct printout layout 1
(d) Clear and attractive headings 1
Easy to read 1
Not too much text 1
(e) Varied font size 1
Varied font type 1
Varied font style 1

5. (a) Title slide 1

Heading (Business Today) 1
Inserting the first slide 1
(b) Inserting a slide 1
Relevant clip art 2
(c) Inserting relevant slide 3 • 2
Bold subheadings 1
Text in two columns 1
(d) Inserting footer 1
Centre aligned 1
(e) Handout format(slides on one page) 2
Printed on portrait 1

3
THEORY TEST TERM 2

1. (a) Explain the following terms as they are used in computers giving examples.
I. data [2]
II. Information [2]
III. Storage [2]
IV. Input device [2]
V. output device [2]

b. Distinguish between the following

i. RAM and ROM [2]

ii. Primary storage and secondary storage [2]

2. Put the following devices in their correct groups as Input, Output or Storage devices
Scanner, light pen, magnetic tape, daisy wheel, papertape, barcode reader, actuator[6]

3. Define the following terms

i. Internet [1]
ii. E-commerce [1]
lii.E-banking [1]
iv.e-mail [1]

4. State any three advantages of using E-mail [3]

4. Explain the following file organization methods

i. Serial file [2]
ii. Sequential file [2]
iii. Direct! Random file [2]

5. Classify the following printers as either impact or non impact printers

Thermal printer, dot matrix printer, ink jet printer, daisy wheel printer, drum printer, laser jet
printer [6]
6. State the difference between physical security and software security [2]
ii. What is computer virus [1]
iii. List any three ways how viruses can be avoided [3]

7. Write the following in full

i. OCR [1]
ii. MICR [1]
iii. OMR [1]

8. Name the packages that you use for the following applications

i. Word processor [1]

II. Spreadsheet [1]

Total 50 marks
, .....

,,

THEORY TEST MARKING GUIDE

1. Explain the following terms as they are used in computers giving examples.
i. data [2]
-raw facts and figures
ii. Information [2]
-processed data/meaningful facts
iii. Storage [2]
-keeping data for futu re use
iv. Input device [2]
-used to enter data into the computer system
v. output device [2]
-displays processed data

b. distinguish between the following •

i. RAM and ROM [2]

-ram -contents can be changed
-it is volatile
-contalns instructions under execution
-rom -cannot be changed
-lts non volatile

ii. Primary storage and secondary storage [2]

-primary -stores data temporarily
- e.g ram and rom
-secondary - stores data permanently
-ed magnetic disks,tapes etc

2. Put the following devices in their correct groups as Input,Output or Storage devices
Scanner,light pen,magnetic tape,daisy wheel,paper tape,actuator [6]

Input output storage

Scanner daisy wheel magnetic tape
Light pen actuator paper tape
3. Define the following terms
i. internet [1]
-global connection of networks
-a worldwide computer network of networks

ii. E-commerce [1]

- E-commerce (electronic commerce or Ee) is the buying and selling of goods and
services, or the transmitting of funds or data, over an electronic network, primarily
the Internet.

lii.E-banking [1]
-a method of banking in which the customer conducts transactions electronically via
the Internet.

iv.e-mail [1]
- Messages distributed by electronic means from one computer user to one or more
recipients via a network.

4.cite any three advantages of using E-mail [3]

- Advantages. Emails are delivered extremely fast when compared to traditional post.
Emails can be sent 24 hours a day, 365 days a year. Webmail means emails can be
sent and received from any computer, anywhere in the world, that has an Internet
connection.

4. Explain the following file organization methods

i. Serial file [2]
- A serial file is a type of file that contains information, which is recorded in the file in
the order it occurred. It can also contain files, in which case the files information
would be listed in the order they were saved in the serial file. The information or files
are essentially recorded in chronological order.

ii. Sequential file [2]

- Data is stored in the order of the keyfield
.•••. •.,t.
.... - •.

- install Anti-Virus/Malware Software ....

- Keep Your Anti-Virus Software Up to Date....

- Run Regularly Scheduled Scans with Your Anti-Virus Software ....
- Keep Your Operating System Current. ...
-Secure Your Network ....

7. Write the following in full

i. OCR [1]
-optical character reader

ii. MICR [1]

-magnetic ink character reader

iii. OMR [1]

-optlcal mark reader

8. Name the packages that you use for the following applications

i. Word processor [1]

-Ms word

II. Spreadsheet [1]

-Ms Excel

Total 50 marks
· ;,.

iii. Direct! Random file [2]

Data is stored without any order

5. Classify the following printers as either impact or non impact printers

Thermal printer,dot matrix printer,ink jet printer,daisy wheel printer,drum printer,laser jet
printer [6]

Impact non-impact
Daisywheel thermal printer
Drum laser jet
Dot matrix inkjet

6. State the difference between •

physical security
- Physical security is the protection of hardware, programs, networks, and data from
physical circumstances and events that could cause serious losses or damage to
computer systems and data. This includes protection from fire, natural disasters,
burglary, theft, vandalism, and terrorism.
software security
- The definition of computer security software refers to programs installed on the
computer that protect against hackers or viruses. A program that prevents someone
from hacking into a computer, stealing data or releasing a virus, is an example of
computer security software [2]

ii. What is computer virus [1]

1. - A piece of code which is capable of copying itself and typically has a

detrimental effect, such as corrupting the system or destroying data.

iii. List any three ways how viruses can be avoided [3]