NATIONAL CERTIFICATE

COMPUTER PRACTICE N6
(6030196)

9 September 2020 (X-paper)

09:00–12:00

THE QUESTION PAPER INCLUDES THE INSTRUCTIONS TO CANDIDATES AND

INVIGILATORS AND MUST BE HANDED TO CANDIDATES 30 MINUTES BEFORE THE
COMMENCEMENT OF THE EXAMINATION SESSION.

This question paper consists of 35 pages and 4 answer sheets.

Copyright reserved Please turn over

(6030196) -2-

DEPARTMENT OF HIGHER EDUCATION AND TRAINING

REPUBLIC OF SOUTH AFRICA
NATIONAL CERTIFICATE
COMPUTER PRACTICE N6
TIME: 3 HOURS
MARKS: 200

INSTRUCTIONS TO INVIGILATORS AND CANDIDATES

READ THE FOLLOWING INSTRUCTIONS CAREFULLY BEFORE ANSWERING THE

QUESTION PAPER. ASK THE INVIGILATOR TO EXPLAIN IF THERE IS SOMETHING
THAT YOU DO NOT UNDERSTAND.

1. The question paper comprises the following THREE sections:

SECTION A: Theory (50 marks)

SECTION B: Word processing (150 marks)
SECTION C: Spreadsheet (150 marks)
SECTION A is COMPULSORY.

Candidates must answer either SECTION B or SECTION C.

SECTION A must be answered on the ANSWER SHEET.

SECTION B is done on the computer with the aid of a word processing

program.

SECTION C is done on the computer with the aid of a spreadsheet program.

ALL the PRINTOUTS must be numbered correctly and both the QUESTION
NUMBER and EXAMINATION NUMBER (COMPUTER NUMBER) must be
printed as instructed. EXAMINATION NUMBERS in writing are NOT
acceptable.

2. The time allocated for the question paper is THREE hours. NO additional time
will be allowed for the printing of answers after the completion of the
examination.

3. In the event of a power failure or a computer or printer breakdown, the

invigilator must make the necessary arrangements for the candidates to
continue and the actual time lost must be added.

4. ASCII codes may be used as well as the spelling checker.

Copyright reserved Please turn over

(6030196) -3-

5. Each answer must be printed on a separate sheet of paper and on ONE side
of the paper only. ALL PRINTOUTS must be placed in the EXAMINATION
FOLDER.

6. PRINTOUTS must be printed on A4 paper unless a specific paper size is

required.

7. Only ONE PRINTOUT per question or subsection of a question may be handed

in for marking. If more than ONE is handed in, only the top one will be marked.

8. At the conclusion of the examination session ALL PRINTOUTS to be marked

must be placed in the correct sequence in the EXAMINATION FOLDER and
handed to the invigilator.

9. PRINTOUTS NOT submitted for marking must be collected at the end of the
session by the invigilator and must be destroyed at the end of the day. NO
PRINTOUTS whatsoever may be removed from the examination room or put
in wastepaper bins.

10. In SECTIONS B and C only a 12 pt font size may be used, unless a specific
size is required, or in the case of a spreadsheet when a smaller font size is
required to fit the answer on ONE page. In SECTION B margins of 2,54 cm/1"
should be used unless otherwise instructed.

11. Candidates must remember that ALL work on the computer should be saved at
regular intervals to prevent loss of work in the event of a power failure.
NO additional time may be allowed for such loss of work. It is the candidates'
responsibility to protect their answers against deletion.

12. In order to print the original as well as the edited answers candidates are
reminded to save the work after each separate question before it is printed.

13. At the end of the examination session each candidate must hand in the
PRINTOUTS of the answers as well as a disk with the saved answers (properly
marked with the candidate's EXAMINATION NUMBER). If the candidate's work
is saved on a hard drive/network, the invigilator must copy the work to a
compact disk/memory stick and the answers must immediately be deleted from
the hard drive/network. These memory sticks/compact disks must be handed
to the examination section for safekeeping for at least SIX months. The disks
must NOT be included for marking.

14. NO question paper may be taken out of the examination room until at least
ONE hour after the commencement of the last session. All papers must
consequently be handed in. These may be returned to candidates on
completion of the examination.

Copyright reserved Please turn over

(6030196) -4-

15. In the event of a question paper being written in more than ONE session
invigilators must ensure that ALL answers of candidates are removed from the
hard disks or the network before candidates for the next session are allowed
into the room.

16. NO candidate may print his/her work for another candidate, make his/her
disk/memory stick available to another candidate or access another candidate's
work on the network. Any attempt to access information from or transfer
information to another candidate in whatever manner is a contravention of the
examination rules and regulations and will be viewed in a serious light.

WAIT FOR THE INSTRUCTION FROM THE INVIGILATOR

BEFORE YOU TURN THE PAGE.

Copyright reserved Please turn over

(6030196) -5-

SECTION A: THEORY (COMPULSORY)

INSTRUCTIONS

1. THIS SECTION MUST BE ANSWERED ON THE ANSWER SHEETS.

REMEMBER TO WRITE YOUR EXAMINATION NUMBER ON THE ANSWER
SHEETS AND TO PLACE IT IN YOUR EXAMINATION FOLDER. Remove the
ANSWER SHEET from your QUESTION PAPER and place it in your
EXAMINATION FOLDER once completed.

2. Read all instructions carefully.

3. Answer all FOUR questions.

4. Use only a blue or black pen.

5. Write neatly and legibly.

QUESTION 1: INFORMATION SYSTEMS

1.1 Name the FIVE steps, in the correct order, when buying computer hardware for
business concerns. (5)

1.2 Name any FIVE controls that can be implemented to guard against the
destruction of hardware and data. (5)

1.3 Identify the network topology as displayed below. Write the correct answer next
to the question number (A–C) on the ANSWER SHEET:

(3)

Copyright reserved Please turn over

(6030196) -6-

1.4 A metropolitan area network (MAN) is an example of a network type. Name any
TWO other types of networks in full (do not use abbreviations). (2)
[15]

QUESTION 2: OPERATING SYSTEMS

Use the print screen below and answer the questions.

2.1 What is the name of this folder? (1)

2.2 How many files and how many folders does this folder contain? (2)

2.3 When (date) and at what time was the folder created? (2)

2.4 On which drive is the folder stored? Name the TWO pre-subfolders preceding
this folder. (1)

2.5 What are the attributes of this folder? (1)

2.6 What does this attribute provide for? (1)

Copyright reserved Please turn over

(6030196) -7-

2.7 Name the system tool that one will use to ensure that the data in this folder is
safe and kept elsewhere as well. (1)

2.8 Which system tool can help to restore files that one has lost? (1)
[10]

QUESTION 3: VIRUSES

3.1 Name the FIVE stages in which viruses can be. (5)

3.2 Name any FIVE measures one can take to prevent virus infection of one's
computer. (5)

3.3 Indicate whether the following statements are TRUE or FALSE. Choose the
answer and write only 'True' or 'False' next to the question number (3.3.1–3.3.5)
on the ANSWER SHEET.

3.3.1 Computer viruses are actually computer programs designed to

corrupt data.

3.3.2 File viruses are designed to attack executable files.

3.3.3 Boot-sector viruses are design to attack the boot sectors of hard
drives.

3.3.4 A common symptom of computer virus infection is that one's

computer becomes slow in performing tasks.

3.3.5 Another common symptom of computer virus infection is that the

number of files on a portable hard drive increases without one
adding these files.
(5 × 1) (5)
[15]

Copyright reserved Please turn over

(6030196) -8-

QUESTION 4: TROUBLESHOOTING

Various options are given as possible answers to the following questions. Choose the
correct answer and write only the letter (A–D) next to the question number (4.1–4.10) on
the ANSWER SHEET.

4.1 If the printer does not print, you need to check the following:

A Check the power plug and ensure that the printer is switched on.
B Check that the cable from the computer to the printer makes good contact.
C Ensure that the printer is switched on.
D All of the above.

4.2 When a monitor is 'dead', it might be due to the following:

A The cable between the computer and monitor might be loose.

B The brightness might be set to zero.
C The video adapter might be faulty.
D All of the above.

4.3 If the keyboard is not functional, it might be due to the following:

A It might be full of dust and dirty.

B The keyboard cable might be loose.
C Check for any fluids that might have been spilled on the keyboard.
D All of the above.

4.4 If the mouse is not working, one can try the following:

A Clean the mouse pad.

B Ensure that the cable is connected to the computer.
C Check the little ball and clean the rollers.
D All of the above.

4.5 If your computer is running out of memory and becomes very slow, you can do
the following:

A Close some programs and run fewer programs at a time.

B Decrease the virtual memory size.
C Decrease the computer's RAM.
D All of the above.

4.6 The error message, Data reading drive F, implies that …

A F: is too full to read.

B there are bad sectors on the disk in F:
C you need to rename the files on F:
D All of the above.

Copyright reserved Please turn over

(6030196) -9-

4.7 The error message, General failure error reading drive F:, implies that …

A There are too many files on the disk.

B You need to rename the files on F:
C The disk in drive F: is not formatted.
D All of the above.

4.8 The error message, Non-system disk or disk error, implies that …

A The computer has been booted with a data diskette in drive A:.
B The computer cannot find the system files.
C The system files are damaged.
D All of the above.

4.9 The error message, The program is not responding, appears due to too many
programs running. One fixes this by doing the following:

A Press CTRL + ALT + DEL and close some of the programs.

B You need to rename the files on F:
C The disk in drive F: is not formatted.
D All of the above.

4.10 The error message, The file being copied is too large for the destination drive,
appears. Ones fixes this by doing the following:

A Zip the file to reduce the size of the file to be copied.

B Buy a portable disk with more storage space.
C To make additional space available, ensure that you have deleted all files
on the destination drive that you do not need.
D All of the above.
(10 × 1) [10]

TOTAL SECTION A: 50

Copyright reserved Please turn over

(6030196) -10-

CANDIDATES MUST ANSWER EITHER SECTION B OR SECTION C.

SECTION B: WORD PROCESSING

INSTRUCTIONS

1. Read the instructions for each question carefully before answering the
questions.

2. Use Courier New 12 pt, except when instructed differently.

3. The following information must appear as a header on each page:

Align the QUESTION NUMBER Align your EXAMINATION NUMBER

against the left-hand margin and COMPUTER NUMBER
against the right-hand margin

4. Use the date function to insert all dates.

5. Place all PRINTOUTS in your EXAMINATION FOLDER in the correct order.

6. Hand in only one PRINTOUT per question.

Copyright reserved Please turn over

(6030196) -11-

QUESTION 5

1. Retrieve the file, RUGBY WORLD CUP 2019, that was saved in the folder,
COMPUTER PRACTICE N6\STUDENT FILES. A copy of this file appears on
the next four pages.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Margins must be 1,27 cm/0,5".

4. Edit the document below and on the next pages as indicated in the instructions
and according to the proofreading signs.

5. Change the font of the entire document to Lucida Sans 12 pt.

6. Insert the equation where indicated. Centre the equation and insert a single line
textbox around the text of the equation only (not from the left- to the right-hand
margin).

7. Insert the following footnote in 10 pt, bold and italics as and where indicated:
The 2019 Rugby World Cup was the ninth edition of the Rugby World Cup, the
quadrennial world championship for men's rugby union teams. It was hosted in
Japan from 20 September to 2 November in 12 venues all across the country.
South Africa was crowned as the World Champions.

8. Create a style, RUGBY, for all level 1 paragraph headings by doing the
following: upper case, left-align, italics and bold. Apply this style to all level 1
paragraph headings.

9. Use the automatic paragraph numbering function to number the paragraphs as

indicated in the text.

Paragraphs marked with a * are main paragraph headings (level 1), ** indicate
subparagraph headings (level 2), etc.

Use the following paragraph numbering style for the four levels, 1 to 4:
1) (Indent on 1 cm/0,39")
a) (Indent on 1,25 cm/0,49")
i) (Indent on 1,75 cm/0,69")
(1) (Indent on 2,25 cm/0,89")

10. Insert the following endnote as and where indicated:

With a capacity of over 50 000 spectators, the Shizuoka Ogasayama sports
park is the second biggest rugby stadium in Japan.

11. Insert the four page breaks as and where indicated.

12. Use the search and replace function, find the word, football, and replace it with
the word, RUGBY, in bold, italics, double underlined and capital letters.

13. Save the file as RUGBY.

Copyright reserved Please turn over

(6030196) -12-

QUESTION 5 (CONTINUED)

14. Print the document and place the PRINTOUTS in the correct order in your
EXAMINATION FOLDER. Insert a footnote after 2019 – use 2
as the footnote number

Centre the heading, 16 pt, bold, insert a textbox around the

heading from the left- to the right margin with a double
border, add 10% grey shading
Football World Cup 2019 Venues in Japan
Leave one line after the heading and insert the equation here as displayed below, centred. Insert a
textbox with a single line border around the text of the equation.
4 𝐺𝑟𝑜𝑢𝑝𝑠 𝑇𝑜𝑝 2 𝑡𝑒𝑎𝑚𝑠 𝑝𝑟𝑜𝑔𝑟𝑒𝑠𝑠𝑒𝑠
𝐽𝑎𝑝𝑎𝑛 2019 = √5 𝑡𝑒𝑎𝑚𝑠 𝑖𝑛 𝑒𝑎𝑐ℎ 𝑔𝑟𝑜𝑢𝑝 −
𝐼𝑛 𝑘𝑛𝑜𝑐𝑘𝑜𝑢𝑡 𝑝ℎ𝑎𝑠𝑒𝑠 𝑜𝑛𝑙𝑦 𝑤𝑖𝑛𝑛𝑒𝑟𝑠 𝑝𝑟𝑜𝑔𝑟𝑒𝑠𝑠𝑒𝑠

*FUKUOKA – Hakatanomori Stadium

**Capacity: 22 563 spectators

**Finished: 1995

**Uses: Football (Avispa Fukuoka) and rugby

***Did you know? The ground hosted four games during the 2009 Junior World
Championship.

****Matches played at this stadium:

****Thursday 26 September Italy 48-7 Canada
****Wednesday 2 October France 33-9 USA
****Saturday 12 October Ireland 47-5 Samoa
---------- Insert a page break ----------

*KOBE – Kobe City Misaki Park

Column 3
**Capacity: 30 132 spectators

**Finished: 2001 Change this page

to landscape.
Insert three
*KUMAGAYA – Kumagaya Rugby Ground columns with a
line between
Column 2 them.
**Capacity: 24 000 spectators Centre page
vertically
**Finished: 1991

*SAPPORO – Sapporo Dome

Column 1
**Capacity: 41 410 spectators

**Finished: 2001
---------- Insert a page break ----------

Copyright reserved Please turn over

(6030196) -13-

QUESTION 5 (CONTINUED)

*KAMAISHI – Kamaishi Recovery Memorial Stadium

**Capacity: 16 187 spectators

**Finished: 2018

***Did you know? Kamaishi was left devastated by the 2011 tsunami and this stadium was
built in memory of those who died.

****Matches played at this stadium:

****Wednesday 25 September Fiji 27-30 Uruguay
****Sunday 13 October Namibia 0-0 Canada (match cancelled)

*KUMAMOTO – Kumamoto Stadium

**Capacity: 32 000 spectators

**Finished: 1998

*OITA – Oita Stadium

**Capacity: 40 000 spectators

**Finished: 2001

**Uses: Football (Oita Trinita) and athletics

***Did you know? The stadium was designed by leading Japanese architect, Kisho
Kurokawa.

****Matches played at this stadium:

****Wednesday 2 October New Zealand 63-0 Canada
****Saturday 5 October Australia 45-10 Uruguay
****Wednesday 9 October Wales 29-17 Fiji
****Saturday 19 October QF1 England 40-16 Australia
****Sunday 20 October QF3 Wales 20-19 France
---------- Insert a page break ----------

*OSAKA – Higashiosaka City Hanazono Rugby Stadium

**Capacity: 30 000 spectators Insert an endnote after Park, use B

as the endnote number

**Finished: 1929

*SHIZUOKA – Ogasayama Sports Park

**Capacity: 50 889 spectators

Copyright reserved Please turn over

(6030196) -14-

QUESTION 5 (CONTINUED)

**Finished: 2001

*TOKYO – Tokyo Stadium

**Capacity: 49 970 spectators

**Finished: 2000

**Uses: Football (FC Tokyo and Tokyo Verdy), athletics and rugby

***Did you know? It was used as shelter for survivors of the 2011 Tohoku earthquake and
tsunami.

****Matches played at this stadium:

****Friday 20 September Japan 30-10 Russia
****Saturday 21 September France 23-21 Argentina
****Sunday 29 September Australia 25-29 Wales
****Saturday 5 October England 39-10 Argentina
****Sunday 6 October New Zealand 71-9 Namibia
****Saturday 19 October QF2 New Zealand 46-14 Ireland
****Sunday 20 October QF4 Japan 3-26 South Africa
****Friday 1 November Third-place Play-off: New Zealand 40-17 Wales
---------- Insert a page break ----------

*TOYOTA CITY – Toyota Stadium

**Capacity: 45 000 spectators

**Finished: 2001

**Uses: Football (Nagoya Grampus) and rugby (Toyota Verblitz)

***Did you know? The retractable roof folds like an accordion and takes about 50 minutes to
open.

****Matches played at this stadium:

****Monday 23 September Wales 43-14 Georgia
****Saturday 28 September South Africa 57-3 Namibia
****Saturday 5 October Japan 38-19 Samoa
****Saturday 12 October New Zealand 0-0 Italy (match cancelled)

*YOKOHAMA – International Stadium

**Capacity: 72 327 spectators

**Finished: 1997

**Uses: Football (Yokohama F Marinos) and athletics

Copyright reserved Please turn over

(6030196) -15-

QUESTION 5 (CONTINUED)

***Did you know? This is the largest-capacity stadium in Japan and it hosted the 2002 World
Cup final.

****Matches played at this stadium:

****Saturday 21 September New Zealand 23-13 South Africa
****Sunday 22 September Ireland 27-3 Scotland
****Saturday 12 October England 0-0 France (match cancelled)
****Sunday 13 October Japan 28-21 Scotland
****Saturday 26 October SF1 England 19-7 New Zealand
****Sunday 27 October SF2 Wales 16-19 South Africa
****Saturday 2 November RWC 2019 Final: England 12-32 South Africa
[35]

Copyright reserved Please turn over

(6030196) -16-

QUESTION 6

1. Retrieve the file, RUGBY.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Margins must be 1,27 cm/0,5".

4. Change the font of the entire document to Lucida Fax 12 pt.

5. Edit the document as indicated below:

MANIPULATION OF PAGE 1:

5.1 Edit the heading, RUGBY World Cup 2019 Venues in Japan, as
follows:

Remove the textbox and shading.

5.2 Delete the footnote in the heading.

5.3 Leave TWO line spaces and key in the following headings:
TABLE OF CONTENTS in 16 pt, bold, italics, left-aligned.
PAGE NUMBER in 16 pt, bold, italics, right-aligned.

5.4 Suppress the display of page numbers on this, the first page.

5.5 Leave TWO line spaces and generate a table of contents by

including the following headings:
Mark all level 1 headings
Mark only the first level 2 headings
Mark the level 4 headings in the last paragraph (YOKOHAMA –
International Stadium)

Manipulate the table of contents as follows: delete the level 2

headings at the main paragraph headings 1) to 3).

5.6 Use leader dots – page numbers must be right-aligned.

5.7 Insert a page break after the table of contents.

MANIPULATION OF PAGE 2 (THE PAGE FOLLOWING THE TABLE OF

CONTENTS):

5.8 Insert a page number top centred, between the QUESTION

NUMBER and EXAMINATION NUMBER in the same line. The page
number must start with number 6 and must be bold and italics.

5.9 Centre ONLY this page vertically.

Copyright reserved Please turn over

(6030196) -17-

QUESTION 6 (CONTINUED)

5.10 Delete the equation and the textbox.

MANIPULATION OF THE LAST PAGE:

5.11 Insert a page break after the last paragraph (YOKOHAMA –

International Stadium), after the words, South Africa.

5.12 Key in the word, INDEX, in 16 pt, bold, italics left-aligned.

5.13 Key in the words, WORDS AND PAGE NUMBERS WHERE TO

FIND THEM, in 16 pt, bold, italics, right-aligned. Leave TWO line
spaces after the headings and generate the index with the following
words:

Capacity, Matches, Namibia, Rugby, Saturday, South Africa, Wales,

Wednesday

5.14 Use three columns. Page numbers must be right-aligned with leader
dots. Manipulate the page number not to show the page number of
the table of contents where the words might appear.

5.15 Centre the content of this page vertically.

5.16 Save the file as MATCHES.

5.17 Print ONLY PAGES 1 (TABLE OF CONTENTS), the second page

(numbered page 6) and the last page (INDEX).

5.18 Place the PRINTOUTS in the correct order in your EXAMINATION

FOLDER.
[35]

Copyright reserved Please turn over

(6030196) -18-

QUESTION 7

Create a letterhead in which the 2019 Rugby World Cup is marketed.

1. Retrieve the file, ORGANISING COMMITTEE, that is saved in the folder,

COMPUTER PRACTICE N6\STUDENT FILES.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Margins must be 1,27 cm/0,5".

4. Edit the document below and on the next page as indicated in the instructions
and according to the proofreading signs.

5. Change the font of the entire document to Arial 12 pt.

6. Insert a horizontal line, 1 pt from the left- to the right-hand margin at the top of
the page after the header.

7. Leave TWO line spaces and key in the heading as indicated below.

8. Leave TWO line spaces and insert THREE columns as indicated below:
Column 1: 10,16 cm/4"
Column 2: 3,81 cm/1,5"
Column 3: 3,55 cm/1,4"
Space between the columns: 0,76 cm/0,3"

Centre the heading, 16 pt, upper case, bold. Insert a textbox

Rugby World Cup 2019 Organising Committee around the heading only with a single border, add 10% grey
shading.

Members: Heading in column 1

Previous Rugby World Cup Winners: Heading in column 2

Logo: Column 3: Picture, Logo

Column 1:
Leave TWO line spaces after the heading, Members, and key in the following text:
Chairman: Fujio Mitarai – CEO of Canon Inc.
Vice-Chairman: Yoshiro Mori – Paralympic Games President Change the heading to upper case, bold
Honorary Executive Consultant: Fumiaki Watari Right-align text in column 1, 10 pt

Japan Rugby President: Shigetaka Mori

Japan Olympic President: Yamashita Yasuhiro

Copyright reserved Please turn over

(6030196) -19-

QUESTION 7 (CONTINUED)

Column 2:
Leave TWO line spaces after the heading, Previous Rugby World Cup Winners, and
key in the following text:
Australia (twice)
England (once) Change the heading to upper case, bold
Left-align all text in column 2, 10 pt
South Africa (twice)
New Zealand (thrice)

Column 3:
Insert the picture, Logo, in column 3, right-aligned. Insert a double line border around
the picture. Change the size of the picture to 2,54 cm/1" wide and 3,81 cm/1,5" high.

9. Leave TWO line spaces after the picture and change back to one column. Insert
a horizontal line, 1 pt from the left- to the right-hand margin.

10. Add a footer as follows:

10.1 Insert a double horizontal line, 1½ pt from the left- to the right-hand
margin.

10.2 Leave TWO line spaces and insert the following text in 8 pt, centred,
bold and italics: WORLD RUGBY STAFF: CEO: Brett Gosper;
Partnership Manager: Meg Mitchell; Head of Communications:
Dominic Rumbles

11. Save the file as RWC2019.

12. Print the document on one page and place the PRINTOUT in your
EXAMINATION FOLDER.
[30]

QUESTION 8

QUESTION 8A

Prepare the following data document for merging with other documents:

LETTER 1 LETTER 2 LETTER 3

COUNTRY England New Zealand South Africa
COACH Eddie Jones Steve Hansen Rassie Erasmus
CAPTAIN Owen Farrel Kieran Read Siya Kolisi
POOL POOL C QUESTION 8A EXAMINATION NUMBER
DATE 1 22 September 2019 22 September 2019 22 September 2019
STADIUM Sapporo Yokohama Yokohama
CITY Kumamoto Kumaishi Kumaishi
FIRST OPPONENT Tonga South Africa New Zealand

Copyright reserved Please turn over

(6030196) -20-

QUESTION 8A (CONTINUED)

1. Use Calibri 11 pt for the entire document.

2. You may use either a word processing program or a database program to

create this file.

3. Change the page orientation to landscape.

4. Ensure that all the information in the table is visible and appears in one row.
Ensure that the text in the fields do not wrap.

5. Ensure that the QUESTION NUMBER and EXAMINATION NUMBER appear

in the POOL field of LETTER 2 and LETTER 3 as indicated on the previous
page. Do not insert your EXAMINATION NUMBER and QUESTION NUMBER
as header.

6. Margins must be 1,27 cm/0,5".

7. Save the file as TEAMS.

8. Print the document on one page. Ensure that no additional information other
than the table is printed and place the PRINTOUT in your EXAMINATION
FOLDER.
(10)

QUESTION 8B

Use the file, RWC2019, that you created in QUESTION 7 to create a primary document
for merging with the data source, TEAMS, that you created in QUESTION 8A.

1. Retrieve the letterhead, RWC2019.

2. Change the QUESTION NUMBER in the header to QUESTION 8B.

3. Leave TWO line spaces below the letterhead and change the font to Bookman
Old Style 12 pt for all text downwards. Leave the font of the letterhead as Arial.

4. Key in the document below and on the next page as indicated in the instructions
and according to the proofreading signs.

5. Insert the field names in bold as indicated in the letter. Do not key in the
brackets ([ ]). They are only there to indicate the field names.

6. Insert the following footnote in bold at the end of the first paragraph after the
word, Cup: The Rugby World Cup is a men's rugby union tournament contested
every four years between the top international teams. Use 1 as the format of
the footnote.

Copyright reserved Please turn over

(6030196) -21-

QUESTION 8B (CONTINUED)

7. Ensure that the letterhead and the letter fits on one A4 portrait page.

8. Save the file as TEAMS8B.

9. Print the document on one page and place the PRINTOUT in your
EXAMINATION FOLDER.

Insert system date, right-aligned

‡
Dear [COACH], [COUNTRY]
‡
It will be a great honour if you, Mr [COACH], [CAPTAIN] and the rest of your team can join
us for the 2019 Rugby World Cup.
Insert a footnote after the word, Cup
‡
Here is the honour role for this prestigious event:
‡ Insert the file, TEAMS, here. Sort the text ascending
according to the years, and insert bullets of your choice.
‡
The 2019 Rugby World Cup will be the ninth edition of the Rugby World Cup. It will be
hosted in Japan from 20 September 2019 to 2 November 2019 in 12 venues all across the
country.
‡
[COUNTRY] will be in [POOL]. The opening match for [CAPTAIN] and his men will be
played [DATE_1] in [STADIUM], [CITY] against [FIRST OPPONENT].
‡
We look forward to hearing from you shortly.
‡
Kind regards
‡
Fujio Mitarai
Honorary President of Japan Business Federation
(24)

QUESTION 8C

1. Use the merge function in the word processing program to merge the invitations
to the different coaches. Use the data source that you created in QUESTION
8A and the primary document that you created in QUESTION 8B.

2. After having merged the three letters, change the QUESTION NUMBER of the
merged letters to QUESTION 8C.

3. Ensure that the footnote number is retained as 1 on all three letters.

Copyright reserved Please turn over

(6030196) -22-

QUESTION 8C (CONTINUED)

4. All merged fields must be in bold.

5. Save the merged letters as TEAMS8C.

6. Print the merged letters and place the PRINTOUTS in your EXAMINATION
FOLDER.
(6)

QUESTION 8D

1. Open a new document and create labels for the different teams.

2. Create 12 labels, 2 columns and 6 rows. You may use the following label:
LABEL VENDOR: A - ONE
PRODUCT NUMBER: 28171

3. Ensure that you use portrait orientation.

4. Use Berlin Sans FB 10 pt as font for the entire document.

5. Display the borders of all the labels.

6. Insert the following heading on all the labels in 16 pt, bold, italics and centred:
SOUTH AFRICA RWC 2019 CHAMPIONS

7. Use the data source that you created in QUESTION 8A to merge the following
fields onto the labels, right-aligned, in the following order:
[CAPTAIN]
[COACH]
[COUNTRY]
[POOL]

8. After having completed the merge, ensure that the QUESTION NUMBER and
your EXAMINATION NUMBER are displayed in label 2 and 3 respectively.

9. Save the labels as TEAMS8D.

10. Print the labels on ONE portrait page and place the PRINTOUT in your
EXAMINATION FOLDER.
(10)
[50]

TOTAL SECTION B: 150

OR

Copyright reserved Please turn over

(6030196) -23-

SECTION C: SPREADSHEET

INSTRUCTIONS

1. Read the instructions for each question carefully before answering the
questions.

2. Use Arial 10 pt, except where instructed differently.

3. The following information must appear as header on each page:

Align the QUESTION NUMBER Align your EXAMINATION NUMBER

against the left-hand margin and COMPUTER NUMBER
against the right-hand margin

4. Use the date function to insert all dates and time.

5. Refer to all values to be repeated by using absolute cell references.

6. All PRINTOUTS must fit on ONE A4 page. If a spreadsheet does not fit on one
portrait page, you may use landscape orientation or adjust the margins, except
where instructed differently.

7. Place all PRINTOUTS in the correct order in your EXAMINATION FOLDER.

Hand in only ONE PRINTOUT PER QUESTION.

QUESTION 9

QUESTION 9A

You are required to give a visual presentation of the 2019 Rugby World Cup statistics in
the form of graphs.

1. Retrieve the file, POOLA, that has been saved in the folder, COMPUTER
PRACTICE N6\STUDENT FILES.

2. Create a pie graph to display the FINAL POOL POINTS for POOL A in the 2019
World Cup. Display the pie chart as an object below the spreadsheet. Resize
the chart from Cells A10 to H30.

3. Display the data on the graph as follows:

Graph title

3.1 Line 1: FINAL SUMMARY POOL A POINTS

Line 2: QUESTION 9A
Line 3: EXAMINATION NUMBER
Display the titles in Agency FB 16 pt, upper case, bold and italics.
Insert a textbox around the graph title.
Align the chart titles top left of the graph.
Do not insert your EXAMINATION NUMBER, QUESTION
NUMBER and COMPUTER NUMBER as header.

Copyright reserved Please turn over

(6030196) -24-

QUESTION 9A (CONTINUED)

3.2 Display the category names and the percentages as data label
percentages on the graph as outside end.

3.3 Display the legend left of the graph.

3.4 Explode the Japan segment.

4. Save the graph as Q9APOOLA.

5. Print the graph and the data on ONE page. Centre the PRINTOUT vertically
and horizontally in portrait orientation with row and column headings and place
the PRINTOUT in your EXAMINATION FOLDER.
(15)

QUESTION 9B

Create a mixed graph to analyse the points in POOL A.

1. Retrieve the file, POOLA, that was saved in the folder, COMPUTER PRACTICE
N6\STUDENT FILES. (This is the same file that you used in QUESTION 9A).

2. Create a mixed graph to display the data of the POINTS FOR TEAM and
POINTS AGAINST TEAM. Display the data of POINTS FOR TEAM as a
column graph and the data of POINTS AGAINST TEAM as a line graph.

3. Display the data on the graph as follows:

3.1 Chart title: POOL A COMPARISON RWC 2019 in Tahoma 16 pt,

upper case, bold and italics. Insert a textbox around the chart title.
Align the chart title top right of the graph.

3.2 Display all the data label values on the graph. Display the data labels
of POINTS FOR TEAM as inside end and the data labels of POINTS
AGAINST TEAM, above.

3.3 Display the legend above the graph.

3.4 Insert the following X-axis titles:

Line 1: Five countries in Pool A
Line 2: QUESTION 9B
Line 3: EXAMINATION NUMBER

3.5 Insert the Y-axis title: Points scored for/against each team.

3.6 The X-axis must display the countries and the Y-axis must display
the points scored.

Copyright reserved Please turn over

(6030196) -25-

QUESTION 9B (CONTINUED)

3.7 Do not insert your EXAMINATION NUMBER and QUESTION

NUMBER as header.

3.8 Insert vertical and horizontal grid lines.

3.9 Save the graph as Q9BPOOL.

3.10 Print the graph as a new sheet on ONE landscape page and place
the PRINTOUT in your EXAMINATION FOLDER.
(18)
[33]

QUESTION 10

QUESTION 10A

You need to do an analysis of the countries in Pool B of the 2019 Rugby World Cup.

1. Retrieve the file, POOLB, that was saved in the folder, COMPUTER PRACTICE
N6\STUDENT FILES.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Change the page layout to landscape orientation.

4. Edit the document on page 27 as indicated in the instructions and/or according

to the proofreading signs. Insert all additional text as indicated.

5. Do not display the row and column headings. These are simply provided to
ensure that you use the correct cell addresses. Ensure that you key in any
additional text in the cells as displayed. Do not insert any additional rows or
columns unless specifically asked to do so in the instructions.

6. Insert formulae/functions for the following calculations where the alphabet

letters appear.

A Use a formula to number the countries in Pool B.

B Use the appropriate function to determine whether the countries

qualified for the elimination rounds. If the POOL POINTS are more
than two, display the country's name, otherwise the answer should
be ELIMINATED.

C Use the appropriate function to determine the HIGH SCORING

TEAMS. If the POINTS FOR TEAM is more than one hundred the
answer must display HIGH SCORING TEAM, otherwise the answer
should be LOW SCORING TEAM.

Copyright reserved Please turn over

(6030196) -26-

QUESTION 10A (CONTINUED)

D Use the appropriate function to determine if the country's campaign

was successful. If the POINTS FOR TEAM is more than the POINTS
AGAINST TEAM, the answer should display SUCCESSFUL,
otherwise the answer should display NOT SUCCESSFUL.

E Use the appropriate function to determine the total number of teams

in POOL B. Display the answer as an integer.

F Use the appropriate function to determine the HIGHEST POOL

POINTS.

G Use the appropriate function to determine the LOWEST POOL

POINTS.

H Use the appropriate function to determine the AVERAGE POOL

POINTS. Display the answer with one decimal.

7. Copy the formulae/functions to the other cells where indicated.

8. Sort the spreadsheet alphabetically according to the countries with all

corresponding data.

9. Insert all vertical and horizontal borders as indicated.

10. Save the spreadsheet as Q10APOOLB.

11. Print the spreadsheet without row and column headings on one landscape
page and place the PRINTOUT in your EXAMINATION FOLDER.
(26)

Copyright reserved Please turn over

(6030196) -27-

QUESTION 10A (CONTINUED)

A B C D E F G H I J
1 FINAL POOL STANDINGS POOL B 16 pt, right-align
2
3 The teams finishing in the top two of each pool advance to the quarter-finals.
Upper case, centre (USE A
4 The top three teams of each pool received automatic qualification to the 2023 Rugby World Cup
5 Number the countries 1 to 5, use a formula Key in all additional text Centre column headings horizontally and vertically, wrap
6 headings as displayed, bold, italics

MATCHES MATCHES POINTS FOR POINTS AGAINST POOL HIGH SCORING CAMPAIGN
7 NUMBER COUNTRY PLAYED WON TEAM TEAM POINTS QUALIFIED TEAMS SUCCESSFUL?
8 1 NEW ZEALAND 4 0 14 177 2 B C D
9 A SOUTH AFRICA 4 2 98 78 12
10 ITALY 4 0 34 175 2
11 NAMIBIA 4 3 157 22 16
12 CANADA 4 3 185 36 15
13 NUMBER OF TEAMS: HIGHEST POINTS: F
14 E LOWEST POINTS: G
15 AVERAGE POINTS: H
16 Sort spreadsheet alphabetically Right-align
17 according to countries

(26)

Copyright reserved Please turn over

(6030196) -28-

QUESTION 10B

The purpose of this question is to display the formulae/functions that you used in
QUESTION 10A.

1. Retrieve the file, Q10APOOLB.

2. Change the question number in the header to 10B.

3. Display the formulae/functions. Ensure that all columns are wide enough to
display formulae/functions in full.

4. Display row and column headings.

5. Hide columns C, D, E and F.

6. Centre the spreadsheet horizontally and vertically on the page.

7. Save the spreadsheet as Q10BPOOLB.

8. Print the spreadsheet with row and column headings in landscape orientation
on one page and place the PRINTOUT in your EXAMINATION FOLDER.
(16)
[42]

Copyright reserved Please turn over

(6030196) -29-

QUESTION 11

QUESTION 11A

You are using key Rugby World Cup statistics.

1. Retrieve the file, RWCSTATS, that was saved in the folder, COMPUTER
PRACTICE N6\STUDENT FILES.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Change the page layout to landscape orientation.

4. Edit the document on page 31 as indicated in the instructions and/or according

to the proofreading signs. Key in all additional text as indicated.

5. Do not display the row and column headings. These are displayed to ensure
you use the correct cell addresses. Ensure that you key in any additional text
in the cells as displayed. Do not insert any additional rows or columns unless
specifically instructed to do so.

6. Insert the picture, Logo, in cell J1. Insert a double-line border around the
picture, change the size of the picture to 2,54 cm/1" wide and 3,81 cm/1,5" high.

7. Insert formulae/functions for the following calculations where alphabet letters

appear:

A Assign the name, TEAMS, to the reference table in cells A19:B25.

Use this reference table and the appropriate function to calculate
and display the CAPTAIN column based on the TEAM column.

B Calculate the DAYS STAYED of each team by using the dates keyed
in in cell D4 (use absolute values).

C Calculate WEEKS STAYED by using DAYS STAYED. Display the

answer with one decimal.

D Assign the name, POINTS, to the reference table in cells D15:J17.

Use this reference table and the appropriate function to calculate
and display the TEAM column based on the PLAYER column.

E Use the reference table, POINTS, and the appropriate function to

calculate and display the TOTAL POINTS SCORED column based
on the PLAYER column.

Copyright reserved Please turn over

(6030196) -30-

QUESTION 11A (CONTINUED)

F Use the appropriate function to determine the total number of

CAPTAINS. Display the answer as an integer.

8. Copy the formulae/functions to other cells where indicated.

9. Insert all vertical and horizontal borders as indicated.

10 Insert the following footer, 16 pt, centred, bold and italics: 2019 RWC was held
in Japan from 20 September to 2 November.

11. Save the spreadsheet as Q11ASTATS.

12. Print the spreadsheet without row and column headings in landscape
orientation on one page and place the PRINTOUT in your EXAMINATION
FOLDER.

Copyright reserved Please turn over

(6030196) -31-

QUESTION 11A (CONTINUED)

A B C D E F G H I J
1 2019 World Cup statistics Main heading: 16 pt, centre Insert the picture, Logo, in cell J1

Centre column headings in row 5 horizontally and vertically.

2
Wrap headings as displayed, bold
3 Use date function TEAM DATE OF DEPARTURE:
4 04-Nov-19 TOP TEN POINT SCORERS IN 2019 RWC
TEAM CAPTAIN DATE DAYS STAYED WEEKS STAYED PLAYER TEAM TOTAL POINTS
ARRIVED IN SCORED
JAPAN
5
6 Australia A 27-Aug-19 B C Dan Bigger D E
7 England 29-Aug-19 Handre Pollard
8 New Zealand 15-Aug-19 Josh Adams
9 Scotland 03-Sep-19 Owen Farrel
10 South Africa 20-Aug-19 Richie Mo'unga
11 Wales 02-Sep-19 Yu Tamura
NUMBER OF
12 CAPTAINS: F
13
14 Right-align
15 Range name: POINTS PLAYER Dan Wigger Handre Pollard Josh Adams Owen Farrel Richie Mo'unga Yu Tamura
16 SPAN Wales South Africa England England New Zealand Japan
Range name: TEAMS TOTALE POINTS
17 SCORED 41 69 35 58 54 51
18
19 TEAM CAPTAIN
20 Australia Michael Hooper
21 England Owen Farrel
22 New Zealand Kieran Read
23 Scotland Greig Laidlaw
24 South Africa Siya Kolisi
25 Wales Dan Bigger
(27)

Copyright reserved Please turn over

(6030196) -32-

QUESTION 11B

The purpose of this question is to display the formulae/functions that you used in
QUESTION 11A.

1. Retrieve the file, Q11ASTATS.

2. Change the question number in the header to 11B.

3. Display the formulae/functions. Ensure that all columns are wide enough to
display formulae/functions in full.

4. Display row and column headings.

5. Hide columns A and F.

6. Delete the picture and the footer.

7. Centre the spreadsheet horizontally and vertically on the page.

8. Save the spreadsheet as Q11BSTATS.

9. Print the spreadsheet with row and column headings in landscape orientation
on one page and place the PRINTOUT in your EXAMINATION FOLDER.
(15)
[42]

QUESTION 12

QUESTION 12A

You are planning your finances for attending the Rugby World Cup.

1. Key in the spreadsheet exactly as given on page 34 and do the questions

below.

2. Insert the QUESTION NUMBER and your EXAMINATION NUMBER and

COMPUTER NUMBER as header as indicated in the instructions.

3. Change the page layout to landscape orientation.

4. Edit the document below and on page 34 as indicated in the instructions and/or
according to the proofreading signs. Do not display the row and column
headings. These are displayed to ensure that you use the correct cell
addresses. Do not insert any additional rows or columns unless specifically
instructed to do so.

Copyright reserved Please turn over

(6030196) -33-

QUESTION 12A (CONTINUED)

5. Insert formulae/functions for the following calculations where the alphabet

letters appear:

A Calculate the AIRFARE QUOTATION. Display your answer in

currency with two decimals.

B Calculate the TOTAL PRICE. Display your answer in currency with

two decimals.

C Calculate the FLIGHT DURATION. Format the answer to display

hours, minutes and seconds.

D FLIGHT TICKET (LOAN AMOUNT): COPY the value of cell C10 to

cells A18:A20. Use an absolute value.

E Calculate the MONTHLY PAYMENT by using the appropriate

function.

F Calculate the ANNUAL PAYMENT.

G Calculate the TOTAL AMOUNT THAT WILL BE PAID OVER FOUR

YEARS.

H Calculate the TOTAL INTEREST COST THAT WILL BE PAID.

I Calculate the FUTURE VALUE OF SAVING (PROJECTION) by

using the appropriate function.

Display all monetary values as currency with two decimals.

Display all of the above answers in bold.

6. Copy the formulae/functions to other cells where indicated.

7. Save the spreadsheet as Q12APMT.

8. Print the spreadsheet without row and column headings in landscape

orientation on one page and place the PRINTOUT in your EXAMINATION
FOLDER.

Copyright reserved Please turn over

(6030196) -34-

QUESTION 12A (CONTINUED)

A B C D E F G H I
1 RUGBY WORLD CUP FINANCIAL PLANNING
2 Centre column headings in row 7 horizontally
3 SECTION A: TRAVEL EXPENSES (FLIGHTS) QUOTATIONS and vertically, wrap headings as displayed Use date function and format as
4 displayed
5 PENTRAVEL QUOTATION NUMBER OF PERSONS: 2
6
7 AIRFARE QUOTATION TOTAL PRICE FLIGHT NUMBER DATE ROUTING DEPARTURE ARRIVAL FLIGHT DURATION
8 PRICE R7 687,50 B VS 462 19-Aug-19 Johannesburg/Hong Kong 8/24/2019 22:20 8/25/2019 16:15 C
9 TAXES R7 032,00 VS 461 01-Nov-19 Hong Kong/Johannesburg 11/3/2019 22:20 11/4/2019 17:20 C
10 TOTAL A
11
12 SECTION B:
13 FIRST OPTION FOR FLIGHT EXPENSES: PERSONAL LOAN Centre column headings in row 17 horizontally
14 and vertically, wrap headings as displayed
15 Calculations for a loan for flight tickets to Hong Kong:
16
FLIGHT TICKET ANNUAL PERIOD OF MONTHLY PAYMENT ANNUAL TOTAL AMOUNT THAT WILL BE TOTAL INTEREST
(LOAN AMOUNT) INTEREST LOAN PAYMENT PAID OVER FOUR YEARS COST THAT WILL
RATE OF IN YEARS BE PAID
17 LOAN
18 D 18% 4 E F G H
19 18% 5
20 18% 6
21
22 SECTION B:
23 FIRST OPTION FOR FLIGHT EXPENSES: PERSONAL LOAN Centre column headings in row 27 horizontally
24 and vertically, wrap headings as displayed
25 Projections to calculate minimum monthly saving
26
PERIOD OF SAVING IN ANNUAL MONTHLY FUTURE VALUE OF
MONTHS INTEREST AMOUNT SAVING (PROJECTION)
27 RATE SAVED
28 48 6% R1 000,00 I
29 60 6% R1 000,00 I
(16)

Copyright reserved Please turn over

(6030196) -35-

QUESTION 12B

The purpose of this question is to display the formulae/functions you used in QUESTION
12A.

1. Retrieve the file, Q12APMT.

2. Change the question number in the header to 12B.

3. Display the formulae/functions, ensure that all columns are big enough to
display formulae/functions in full.

4. Display row and column headings.

5. Centre the spreadsheet horizontally and vertically on the page.

6. Save the spreadsheet as Q12BPMT.

7. Print the spreadsheet with row and column headings in landscape orientation
on one page and place the PRINTOUT in your EXAMINATION FOLDER.
(17)
[33]

TOTAL SECTION C: 150

GRAND TOTAL: 200

Copyright reserved Please turn over

(6030196) -1-

COMPUTER PRACTICE N6

ANSWER SHEET EXAMINATION NUMBER:

SECTION A: THEORY

QUESTION 1:
QUESTION 2:
QUESTION 3:
QUESTION 4:

QUESTION 1: INFORMATION SYSTEMS

1.1

(5 × 1) (5)

1.2

(5 × 1) (5)

Copyright reserved Please turn over

(6030196) -2-

ANSWER SHEET EXAMINATION NUMBER:

1.3 A

C
(3 × 1) (3)

1.4

(2 × 1) (2)
[15]

QUESTION 2: OPERATING SYSTEMS

2.1 (1)

2.2

(2)

2.3

(2)

2.4 (1)

2.5 (1)

2.6 (1)

2.7 (1)

2.8 (1)
[10]

Copyright reserved Please turn over

(6030196) -3-

ANSWER SHEET EXAMINATION NUMBER:

QUESTION 3: VIRUSES

3.1

(5 × 1) (5)

3.2

(5 × 1) (5)

3.3 3.3.1

3.3.2

3.3.3

3.3.4

3.3.5
(5 × 1) (5)
[15]

Copyright reserved Please turn over

(6030196) -4-

ANSWER SHEET EXAMINATION NUMBER:

QUESTION 4: TROUBLESHOOTING

4.1

4.2

4.3

4.4

4.5

4.6

4.7

4.8

4.9

4.10
(10 × 1) [10]

TOTAL SECTION A: 50

Copyright reserved