MARKING GUIDELINE

NATIONAL CERTIFICATE (VOCATIONAL)

OFFICE DATA PROCESSING

NQF LEVEL 3

13 November 2024

This marking guideline consists of 22 pages.

CONCESSION:

(1) Do not allocate marks for Question 3.3 (3 marks)

(2) The total of 300 marks to be reduced by 3 marks to 297 for all candidates
(3) Mark all candidates out of a total of 297 marks
(4) Convert the mark achieved out of 297 per candidate to a percentage
(5) Record the percentage achieved on the mark sheet

Copyright reserved Please turn over

MARKING GUIDELINE -2-
OFFICE DATA PROCESSING L3

INSTRUCTIONS TO MARKERS

To facilitate marking and moderation, the following must be adhered to:

TIMED ACCURACY TEST:

• The TIMED ACCURACY TEST is marked according to the schedule for
QUESTION 1.
• A candidate that fails the TIMED ACCURACY TEST but obtains 50% or more for the
entire examination paper, passes the examination.
• A candidate that passes the TIMED ACCURACY TEST but fails the examination
paper, fails the examination papers as well as the TIMED ACCURACY TEST.

Manipulation:
• Use a blue pen for all manipulation commands carried out.
• Use a tick/s (✓) and the question number for every correct manipulation carried out
as indicated in the marking guideline.
• Use an X (cross) to mark manipulation done incorrectly.
• The question number must be written next to every tick or X (e.g. 1.3✓✓)

Accuracy:
• Use a red ✓ to indicate all accuracy marks.
• Use a red X to indicate all accuracy errors.
• For each command, the question number must be written next to every tick or X
(e.g. 1.4 ✓✓✓✓XX)

Copyright reserved Please turn over

MARKING GUIDELINE -3-
OFFICE DATA PROCESSING L3

QUESTION 1: TIMED ACCURACY TEST

MARK SCHEDULE

Margin of errors 5% 5%
WPM 30 35
Maximum errors permitted 7 8
Marks per error deducted 1.2 1
Possible marks 20
Number of errors/marks deducted
0 20 20
1 19 19
2 18 18
3 16 17
4 15 16
5 14 15
6 13 14
7 12 13
8 [Passed 30 wpm] 10 12
9 9 11
10 [Passed 35 wpm] 8 10
11 7 9
12 6 8
13 5 7
14 4 6
15 2 5
16 1 4
17 0 3
18 2
19 1
20 0
21
22
23
24
25

Copyright reserved Please turn over

MARKING GUIDELINE -4-
OFFICE DATA PROCESSING L3

NOTE: The TIMED ACCURACY TEST must be marked carefully as it impacts on the
results. Mark accuracy only.

1. Use the mark schedule attached to allocate marks.

2. When the same word is repeatedly keyed in incorrectly, it is penalised the first
time only (once) per question and encircled thereafter.

3. Omission of words: Count the first FIVE strokes (spaces included); thereafter
every 10 strokes constitute ONE error each.

4. Should a whole line or paragraph be left out and keyed in at the bottom of the
answer, only ONE accuracy error is deducted, and it is not penalised as an
omission of words.

5. Should a whole line or paragraph be repeated, only ONE accuracy error is

deducted for the entire line or paragraph.

6. If 35 wpm is not reached , count back as indicated in the marking guideline.

7. The highest marks obtained is indicated. The highest speed obtained (12/30 or
more) is indicated.

8. Indicate the speed obtained with a P/S (pass speed) 30 wpm/35 wpm or F/S
(fail speed) on the COVER PAGE next to the mark for the speed and indicate
the speed obtained next to the percentage obtained.

9. Indicate at the end of the TIMED ACCURACY TEST:

Pass/Fail speed P/S
No. of errors 3
Mark achieved 16/20
WPM achieved 30

10. The speed reached is endorsed on the COVER of the EXAMINATION FOLDER
next to the percentage obtained (within a circle), for example:

58% 30 wpm

11. No marks should be deducted for:

• Incorrect casing (upper/lower case)

• Incorrect letter spacing
• Incorrect hyphenation
• Incorrect line spacing
• Incorrect paragraphing
• Incorrect justification

Copyright reserved Please turn over

MARKING GUIDELINE -5-
OFFICE DATA PROCESSING L3

QUESTION 1 EXAMINATION NUMBER

NSFAS is a bursary scheme that is funded by the Department of 62

Higher Education and Training for people who lack finance and 124
cannot afford study loans or bursaries. 163
The main objective of NSFAS is to make sure that South African 226
citizens have a chance to afford higher education. It also provides 285
financial assistance to eligible students at public universities 346
and TVET colleges in South Africa. NSFAS administers these 400
bursaries and loans. Once a student works, they then pay back the 461
loan. 489
For one to qualify for an NSFAS bursary they have to be a South 553
African citizen. Most importantly, they must either be SASSA grant 613
recipients; their household income should not be more than R350 683
000 pa and a person with a disability stands a chance. In a case 747
where there’s combined income it shouldn’t be more than R600 000. 812
NSFAS provides not only the fees but also an allowance for 871
transportation, living, study materials needed, and others. 929
Students need more than just fees to be paid for, that is why the 997
allocation of funds would consider other aspects of students’ 1059
needs. They need groceries, toiletries, accommodation as well. 1121
Once a student qualifies according to the means test, NSFAS 1181
supports them for at least 5 years. This is based on the 1238
availability of funds. When a student changes courses and takes 1302
more than 5 years to finish a qualification, they then have to 1365
pay for themselves until they graduate. It is vital that students 1431
choose courses they can handle so they can pass easily. It is 1493
30 words
evident that if students fail even just one of their subjects 1555
then funding is stopped. Creating a good record makes it easy for 1621
them as they would be funded until they are done. NSFAS advocates 1687
35 words
hard work and determination for students. Returning students must 1753
demonstrate proven and accepted academic performance in line with 1819
the College’s progression policy. 1852
[20]

Copyright reserved Please turn over

MARKING GUIDELINE -6-
OFFICE DATA PROCESSING L3

QUESTION 2 EXAMINATION NUMBER

2.1 • The internet is a decentralized global network of computers that enables

people all over the globe to communicate electronically.
• It is an enormous network with millions of computers connected together
across the world.
• Connecting computers to other computers anywhere in the world using
routers, servers and modems.
• The Web is an information system that makes the retrieval and distribution
of information from or via the internet possible. (4)

2.2 • Ananzi
• Google South Africa (2)

2.3 • Keep it simple

• Use web-friendly words that are most likely to appear on websites.
• Do not worry too much about spelling, capitalisation or punctuation.
• If you do not find what you are looking for, refine the search by being more
specific. (4)

2.4 • Search the internet, or select parts of it, based on important words.
• Keep an index of the words they find and where they find them.
• Allow users to look for websites containing the words in that index.
(3)

2.5 • Open the website and/or a specific web page

• Click the star icon at the top right of the screen
• Depending on the browser, the bookmark or add bookmark or favorites
dialogue box will open, showing the web address.
• Click Save or Done. (4)

2.6 Ctrl Shift O (1)

2.7 2.7.1 Wikipedia

2.7.2 Google Scholar
2.7.3 Dreamstime
2.7.4 Reddit
(4 × 1) (4)

2.8 • Previewing prevents wasting of paper.

• It allows one to adjust the margins and other printing options to ensure that
the web page prints as required.
• It allows one to return to the document and delete unnecessary information. (3)
[25]

Copyright reserved Please turn over

MARKING GUIDELINE -7-
OFFICE DATA PROCESSING L3

QUESTION 3

3.1

3.1 The folder called Travel and

accommodation form must be
ignored because in the student files
is not appearing (1)

NSFAS folder✓
Large icons✓
Screen print✓ (2)

3.2

Proof of annual household income Excel file✓

Screen print✓ (2)

3.3 DO NOT MARK

3.4

Parents ID duplicate✓
Screen print✓ (2)

Copyright reserved Please turn over

MARKING GUIDELINE -8-
OFFICE DATA PROCESSING L3

3.5

Deleted file✓
Recycle Bin screen print✓
(2)

3.6

Restored files✓
Screen print✓ (2)

3.7-
3.9

Compressed STUDENT FILES folder✓

Zipped folder – ODP LEVEL 3✓
Screen print ✓ (3)

Copyright reserved Please turn over

MARKING GUIDELINE -9-
OFFICE DATA PROCESSING L3
3.10

Right click NSFAS folder✓ properties and hidden

selected✓
Screen print ✓ (3)
[17]

QUESTION 4A

4.1 MS WORD
4.2
4.2 Header✓ (EXAMINATION NUMBER and QUESTION 4A)
4.3
4.1 Columns (4) rows (5)✓
4.1 Letter spacing✓ upper case/lower
case✓
4.1 Accuracy✓✓✓✓✓✓✓

(11)

Copyright reserved Please turn over

MARKING GUIDELINE -10-
OFFICE DATA PROCESSING L3

4.2 (Mark file name if using MS Access)

4.3 Print portrait page✓
(1)

QUESTION 4B

4.4 4.4 Retrieve ✓ 4.4.8 Can shape✓ Position✓

4.4.1 Header✓Exam No left✓ Q4B right✓
4.4.9 NSFAS image✓ and resized✓

4.4.2 Comic Sans MS✓ 12 pt✓

4.4.12 Student names✓
4.4.12 Student ID✓
4.4.12 Course✓
4.4.12 Level✓
4.4.13 Bold✓merge field italics✓

4.4.3 Font size 14 pt✓

4.4.10 Image moved and adjusted✓
4.4.4 u/c✓ und✓ left-aligned✓ 4.4.11 Picture effect to Subtle✓

4.4.5 Find & Replace SARS✓ bold✓

4.4.6 Insert text✓ Accuracy✓✓✓✓✓✓

4.4.7 Double border✓

4.4.14 Portrait page✓

(33)

Copyright reserved Please turn over

MARKING GUIDELINE -11-
OFFICE DATA PROCESSING L3

QUESTION 4C

4.5
4.6
4.5 QUESTION 4C for both printouts✓
4.7

4.6 Letter merged for both printouts✓✓

4.7 Motsamai B printed✓

Copyright reserved Please turn over

MARKING GUIDELINE -12-
OFFICE DATA PROCESSING L3

4.7 Maseko YM printed✓

A M T
14 36 50
(5)
[50]

Copyright reserved Please turn over

MARKING GUIDELINE -13-
OFFICE DATA PROCESSING L3

5.3.1 Century Gothic, 11 pt✓

5.1 Retrieve File NSFAS✓

5.3.2 Move image✓position-centre✓

5.2 Header✓
5.3.3 U/C✓ bold✓ double underline✓

5.3.4 Line spacing after the heading✓

5.3.5 Paragraph numbering✓ indentation✓

5.3.7 Page break✓

5.3.8 Page 1 changed to landscape✓
5.3.9 Three columns✓ line in between✓ 5.3.6 Paragraph 2 spacing 1.5 ✓
5.3.10 Column break✓ Paragraph 3 double line spacing✓
5.3.11 Automatic hyphenation inserted to the entire document✓
(19)

Copyright reserved Please turn over

MARKING GUIDELINE -14-
OFFICE DATA PROCESSING L3

5.3.12 Heading inserted✓ Correct WordArt style✓Accuracy✓

5.3.14 Merge and centre✓

5.3.13 Table✓ Accuracy ✓✓✓✓✓✓✓✓✓(9)

5.3.15 Rows height col.2 ✓

5.3.16 Bold text✓
5.3.17 Split table✓ NSFAS
image✓ position✓
5.3.18 Table design✓

5.3.19 Text centred horizontally and vertically ✓

5.3.20 3 pt border✓
5.3.21 Top and bottom margin✓
5.3.22 Page break✓ (24)

Copyright reserved Please turn over

MARKING GUIDELINE -15-
OFFICE DATA PROCESSING L3

5.3.23 Heading inserted✓ Accuracy✓

5.3.24 Insert Correct SmartArt graphic✓
Accuracy✓✓✓✓✓✓ (6)
5.3.25 Colour effect✓

5.3.26 Page number✓ bottom centre✓

5.3.27 Footnote✓ bold✓ italics✓ accuracy✓
5.3.28 Print✓

A M T
18 42 60

(17)
[60]

Copyright reserved Please turn over

MARKING GUIDELINE -16-
OFFICE DATA PROCESSING L3

QUESTION 6: SPREADSHEET

6.1 Retrieve Q6✓ 6.1.1 Header✓position✓

6.1.2 Century✓ 11 pt✓ (entire document)

6.1.3 Heading 16 pt✓ merge and centre✓
6.1.4 Date format✓ 14 pt✓ right aligned✓
6.1.5 Open row✓
6.1.6 Upper case✓ bold✓ centre column
headings✓
6.1.7 15% shading✓

6.1.10 Single inside✓ & any thick border outside✓

6.1.8 Column A left aligned✓ 6.1.11 Sort with corresponding figures✓
6.1.9 Worksheet centred both 6.1.12 Student cell number column deleted✓
vertically✓ and horizontally✓ 6.1.13 Column width✓
6.1.14 Printed in ONE page✓ landscape page✓
(25)
Copyright reserved Please turn over
MARKING GUIDELINE -17-
OFFICE DATA PROCESSING L3

6.2.1 Columns correctly inserted✓accuracy✓ 6.2.12 Display all figures as currency✓ 2 decimals✓
6.2.13 Display %✓ with 0 decimals✓
6.2.14 Print without gridlines✓

6.2.3 Calculate TOTAL ✓

6.2.4 Autofill E6:E16✓
6.2.6 Calculate % OF TOTAL (F6) Absolute
cell address✓
6.2.7 Autofill F6:F16✓

10%
10%
7%
7%
9%
10%
7%
12%
10%
8% 6.2.5 Calculate GRAND TOTAL✓
10% 6.2.8 Calculate Average (C18)✓
6.2.9 Calculate COUNTA/COUNT
(B19)✓
6.2.10 Calculate HIGHEST✓ (B20)
6.2.11 Calculate LOWEST✓(C21)

6.2.2 Rows correctly inserted✓ accuracy✓✓✓✓

(21)

Copyright reserved Please turn over

MARKING GUIDELINE -18-
OFFICE DATA PROCESSING L3

6.3 Header changed to Q6C✓

6.3.1 Correct formula in E6✓

6.3.1 Correct formulae in F6✓
=E6/$E$17 6.3.1 Correct formula in B17✓
=E7/$E$17 6.3.1 Correct formula in C18✓
=E8/$E$17 6.3.1 Correct formula in B19✓
=E9/$E$17 6.3.1 Correct formula in B20✓
=E10/$E$17
6.3.1 Correct formula in C21✓
=E11/$E$17
=E12/$E$17
=E13/$E$17
=E14/$E$17
=E15/$E$17
=E16/$E$17 Only 4 marks for
formulae

6.3.2 Columns adjusted✓ (8)

6.3.3 Landscape page✓ printed with row & column headings✓

Copyright reserved Please turn over

MARKING GUIDELINE -19-
OFFICE DATA PROCESSING L3

6.4 Header changed to Q6D✓

6.4.1 Pie chart✓ correct data range✓

6.4.2 Chart title✓ format✓right-aligned✓ accuracy✓
6.4.3 Data labels✓ outside end✓

A M T
5 60 65

6.4.4 Legend removed✓

6.4.5 Printed as new sheet✓

(11)
[65]

Copyright reserved Please turn over

MARKING GUIDELINE -20-
OFFICE DATA PROCESSING L3

QUESTION 7

7.1 Create presentation✓

7.2 Title slide✓
7.2.1 Heading Bodoni MT Black✓ font size✓
shadow✓Accuracy✓

MyNSFAS status
check
www.nsfas.org.za
7.2.2 Sub-heading Broadway 40 pt✓ Centre✓ Accuracy✓

EXAMINATION NUMBER and QUESTION NUMBER 1

(9)

7.3 Title and content✓

7.3.1 Upper case✓ underlined✓ accuracy✓ 7.3.2 Accuracy✓✓✓✓

(8)

Copyright reserved Please turn over

MARKING GUIDELINE -21-
OFFICE DATA PROCESSING L3

PROTECTING YOUR CREDENTIALS AND

CRUCIAL INFORMATION 7.4 Two Content Slide✓
7.4.1 Heading italics✓ Accuracy✓

I. Applicants do not need to pay fee

to apply.
II. Remember to not share your
myNSFAS login details with
anyone.
III. NSFAS employees will never ask
for your login details.
IV. NSFAS urges all applicants to
protect their personal information.
V. Keep your details up to date.
7.4.2 Left placeholder✓
7.4.4 Image inserted✓ right placeholder✓
Text accuracy✓✓✓✓✓✓✓✓
7.4.5 Image adjusted✓
7.4.3 Capital Roman numbering✓
EXAMINATION NUMBER and QUESTION NUMBER 3

7.5 Screen print✓ Paste in Word✓ Accuracy✓

(19)

STEPS TO ACTIVATE MYNSFAS DETAILS

▪ Click on the forgot password tab and enter your ID number.

▪ Choose whether you have forgotten your username and password and click submit.
▪ You will receive an OTP via email and SMS.
▪ Type in the OTP and click submit
▪ You will then be required to create a new password.

7.6 Imported as Slide 4✓✓

7.6.2 Replaced numbering
7.6.1 3 pt border✓ right-aligned✓
Filled square bullets✓✓

EXAMINATION NUMBER and QUESTION NUMBER 4

(6)

Copyright reserved Please turn over

MARKING GUIDELINE -22-
OFFICE DATA PROCESSING L3

7.7 Title only✓

7.7.1 Accuracy✓✓

7.7.2 Rectangular callout shape✓ centre✓ fill colour blue✓

7.7.3 Text inserted✓ accuracy✓
7.7.4 Text Arial/bold✓ font size✓
7.7.5 Shape height/width✓✓
7.8 Crop design/theme✓✓
7.9 Slide numbers✓
7,10 Footer inserted✓
7.11 Handouts✓ TWO slides per page✓
(18)
[60]

TOTAL: 297

Copyright reserved