NATIONAL
SENIOR CERTIFICATE
GRADE 11
COMPUTER APPLICATIONS TECHNOLOGY P2
JUNE 2019
NOVEMBER 2011
MARKS: 150
TIME: 3 hours
This question paper consists of 15 pages
Computer Applications Technology/P2/Gr 11 2 NW/June 2019
NCS
INSTRUCTIONS AND INFORMATION
1. This question paper consists out of:
Section A (25 marks)
Section B (75 marks)
Section C (50 marks)
2. Answer ALL the questions.
3. Number the answers correctly according to the numbering system used in this question
paper.
4. Start EACH question (Question 1, 2, 3 etc.) on a NEW page.
5. Do NOT write in the right-hand margin of the ANSWER BOOK.
6. Leave a line between sub questions.
7. In general, a mark is allocated per fact. A 2-mark question would therefore generally
require TWO facts, etc.
8. Write neatly and legibly.
Computer Applications Technology/P2/Gr 11 3 NW/June 2019
NCS
SECTION A
QUESTION 1: MATCHING ITEMS
Choose a term/concept from COLUMN B that matches a description in COLUMN A.
Write only the letter (A–R) next to the question number (1.1–1.10) in the ANSWER
BOOK, for example 1.11 V.
COLUMN A COLUMN B
1.1 Electronic waste that pollutes the environment A MP
B Keylogging
1.2 A powerful computer at a large organisation that
has lots of hard drive space to store files and C Intranet
controls that network D E- waste
1.3 When a formula in Excel refers back to its own E Network
cell, either directly or indirectly F Circular cell reference
1.4 Medical diagnosis of RSI G Green computing
H DPI
1.5 A method of capturing and recording user
keystrokes in an attempt to find out what your I Survey
username and password are J Hyperlink
1.6 A data type that refer to an object that has been K Carpal Tunnel Syndrome
created in another program and is linked to and L OLE Object
included in a database
M File server
1.7 Environmentally friendly computer products and N Power scheme
protocols
O Spyware
1.8 A data collection tool consisting of a set of P Relative cell reference
questions used to obtain data and information
from individuals Q 3G
R DIMM
1.9 Unit or specification used to indicate the
resolution of a printer or a scanner S OCR
T Discussion
1.10 The specification in an advert for a digital
U PPI
camera that refers to its maximum resolution
(10 x 1) [10]
Computer Applications Technology/P2/Gr 11 4 NW/June 2019
NCS
QUESTION 2: MULTIPLE-CHOICE QUESTIONS
Various options are given as possible answers to the following questions. Choose the
answer and write only the letter (A–D) next to the question number (2.1–2.10) in the
ANSWER BOOK, for example 2.11 E.
2.1 A USB port is used to connect peripherals to a computer. If you
have a limited number of USB ports you can use a USB _________
to extend the number of ports
A hub
B flash
C extension cable
D modem (1)
2.2 Which of the following statements are CORRECT with regard to
smartphones: Smartphones ______
a) function without an operating system
b) can load extra programs, e.g. games
c) have a camera
d) can be used to browse the Internet
e) can be used as a modem
f) can only be connected by USB cable to other devices
g) can send and receive emails
A All of the above
B a, b, c and f
C c, d, e and g
D b, c, d, e and g (1)
2.3 Which element will you use for the main heading of your web page?
A <heading>
B <h1>
C <head>
D <h6> (1)
2.4 This device is also known as a laptop although it is slightly smaller
A PIM
B PDA
C Notebook
D iPod (1)
Computer Applications Technology/P2/Gr 11 5 NW/June 2019
NCS
2.5 Which ONE of the following does NOT contain a battery of some type
A Portable printer
B Wired keyboard
C Wireless mouse (1)
D Phablet
2.6 Which ONE of the following fields in a database table storing pupil
records are the most likely to set a default value on?
A Address
B Surname
C Gender
D ID number (1)
2.7 Which ONE of the following will NOT make a web page easier to read?
A Separating unrelated items
B Typing the text in all upper case
C Using numbered or bulleted lists
D Using columns and short paragraphs (1)
2.8 In Word processing, Harvard and APA are styles associated with
A Headings
B Captions
C Bibliography
D Footnotes and endnotes (1)
2.9 Which ONE of the following Access objects is specifically designed to
print information from a database?
A From
B Table
C Report
D Query (1)
2.10 Which ONE of the following series can NOT be created using the Auto
Fill option in Excel?
A week 1, week 2, week 3, week 4
B 2, 5, 8, 11
C 24-05-2017, 25-05-2017, 26-05-2017, 27-05-2017
D a, b, c, d (1)
(10 x 1) [10]
Computer Applications Technology/P2/Gr 11 6 NW/June 2019
NCS
QUESTION 3: TRUE/FALSE ITEMS
Indicate whether the following statements are TRUE or FALSE. Choose the answer and
write 'true' or 'false' next to the question number (3.1-3.5) in the ANSWER BOOK. Correct
the statement if it is FALSE. Change the underlined word(s) to make the statement TRUE.
(You may not simply use the word 'NOT' to change the statement.)
3.1 Aspect ratio is common both to monitors and to printer's specifications. (1)
3.2 Hybrid laptops come with a touchscreen. (1)
3.3 Form is a document that contains the basic layout and sections needed
for a particular type of document. (1)
3.4 AutoFill can be used to create automatic series. (1)
3.5 It is best to use optical zoom on a digital camera to ensure that
magnified images do not become blurry and pixelated. (1)
(5x1) [5]
TOTAL SECTION A: [25]
Computer Applications Technology/P2/Gr 11 7 NW/June 2019
NCS
SECTION B
QUESTION 4: SYSTEMS TECHNOLOGIES
4.1 Your computer has slowed down in recent days. Explain TWO actions
you can take to improve the speed with which files are retrieved. (4)
4.2 Give ONE example of how ICT can assist your father in the workplace
specifically in terms of information processing. (1)
4.3 Dedicated devices and general purpose computers all play a key role in
the field of ICT.
4.3.1 Briefly explain the difference between these two types of
computers. (2)
4.3.2 Give an example of each one. (2)
4.4 Explain what it means to zip files and why this is a good idea when
performing a backup. (2)
4.5 How many gigabytes (GB) does 4096 MB represent? (1)
4.6 Name TWO disadvantages that one should keep in mind when using a
scanner. (2)
4.7 Briefly explain what a RFID tag is and how it works. (2)
4.8 How would one measure the size and quality of a monitor? (2)
4.9 Many people who are computer illiterate battle to understand the
difference between memory and storage.
4.9.1 Clearly explain the difference in function between memory and
storage. (2)
4.9.2 Give TWO differences between memory and storage other
than their functions. (2)
4.10 Plug and Play technology has largely removed the need for a user to
have to install drivers.
4.10.1 Explain what a driver is. (1)
4.10.2 Does using Plug and Play technology do away with the need
for drivers? Motivate your answer. (2)
[25]
Computer Applications Technology/P2/Gr 11 8 NW/June 2019
NCS
QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES
5.1 A website has been designed for the school shop.
Give THREE criteria the manager can use to evaluate the website, in (3)
terms of navigating the website.
5.2 One advantage of fibre cable over the ‘normal’ type of cable used to
connect computers in a LAN is that fibre can span longer distances.
5.2.1 Name the 'normal' type of cable referred to above i.e. that is (1)
usually used to connect computers in a LAN.
5.2.2 Give TWO other advantages of fibre cable over the 'normal' type (2)
of cable, besides the fact that it can span longer distances.
5.2.3 Fibre is mainly used as a backbone in a network. What is a (1)
backbone in this context?
5.3 List TWO advantages of a LAN. (2)
5.4 Give ONE reason why it is sometimes necessary to increase the number (1)
of access points in a wireless network (for example in a school).
5.5 What is the meaning of typography? (1)
5.6 Give TWO reasons why it is not a good idea to have many animations (2)
on a web page?
5.7 The main goal of a network is sharing.
Give TWO broad types of resources that networks allow one to share. (2)
[15]
Computer Applications Technology/P2/Gr 11 9 NW/June 2019
NCS
QUESTION 6: INFORMATION MANAGEMENT
6.1 Explain why many academic institutions do not allow students to
include Wikipedia as a source in their research tasks. (1)
6.2 Give TWO advantages of conducting a survey online, as opposed to
approaching people individually (e.g. by phone or in shopping malls).
Exclude from your answer the speed and ease with which data may
be collected. (2)
6.3 Study the questionnaire below and answer the questions that follow
below the questionnaire.
Name: .......................................... Age: ............ Gender: ..........
Class: ………………….
1. Who is your favourite TV personality? ………………………………………
2. Do you sometimes watch the news on TV? YES / NO (Circle your answer)
3. How many hours do you spend watching TV? ……………
6.3.1 Explain why question 1 is a closed question. (1)
6.3.2 Why should the word 'sometimes' be removed from
question 2? (1)
6.3.3 Question 3, as it currently stands, will not result in good (1)
quality information. Explain what is wrong with this question
(You may reword the question appropriately).
6.3.4 Suggest a way in which the questionnaire could be changed,
so that respondents would be more likely to complete the
questionnaire honestly. (1)
6.4 Explain why it is sometimes a good idea to save a file in a previous
version of the software before sharing the file with others. (1)
6.5 Give TWO disadvantage of using closed questions in a survey. (2)
[10]
Computer Applications Technology/P2/Gr 11 10 NW/June 2019
NCS
QUESTION 7: SOCIAL IMPLICATIONS
7.1 Explain to Mr. Gobig how to enhance accessibility on the computer under each of
the following headings by naming TWO examples of each:
7.1.1 Screen settings. (2)
7.1.2 Keyboard settings. (2)
7.2 Briefly explain to Mr. Gobig what the difference is between a screen reader
and a screen magnifier. (2)
7.3 Name TWO ways in which Mr. Gobig can save on electricity usage without
investing in new hardware. (2)
7.4 How could Mr Gobig prevent any health related issues when working in front of a
computer? (2)
[10]
Computer Applications Technology/P2/Gr 11 11 NW/June 2019
NCS
QUESTION 8: SOLUTION DEVELOPMENT
8.1 Give ONE advantage of printing a document in draft mode. (1)
8.2 Give ONE advantage and ONE disadvantage of saving word processing
document as a file with an extension of TXT before distributing it. (2)
Indicate in your answer which one is the advantage and which one the
disadvantage.
8.3 Explain why, when performing a Find and Replace operation in Word, it is
sometimes necessary to use the ‘Find whole words only’ option. (You may
use an example to illustrate your answer). (1)
8.4 The current date was added as a field to a word processing document,
with the date format: MMM DD.
(1)
How will the date be displayed if the document is opened on Sunday 05
April 2017.
8.5 Name the type of indent that was used to position the word ‘Tips’, in the
following screenshot of a Word document, one centimetre to the left of the
main body of the paragraph:
(1)
8.6 The operator ^ can be used in Excel to return the result of the
expression 2 x 2 x 2 (i.e. =2^3).
Give the name of an Excel function that can be used, instead of the ^ (1)
operator, to return the same result.
8.7 Study the following function that was entered in cell H25 of a
spreadsheet, and answer the questions that follow:
=IF(G1>=90,distinction,"")
8.7.1 Suppose the value 80 is entered in cell G1, what result will the if- (1)
function return?
8.7.2 Explain why the function will give an error message, if the value 90 (1)
is entered in cell G1.
8.8 Give ONE feature of a database table that can be used to display just (1)
certain records, besides using a query.
Computer Applications Technology/P2/Gr 11 12 NW/June 2019
NCS
8.9 The following Access query is supposed to show the names and the
number of cans collected by learners in classes 11A and 11B, who
collected at least 50 cans each in a recycling exercise:
Give THREE reasons why this query will not produce the desired (correct)
results by indicating in each case how the design of the query must be (3)
changed in order to obtain the correct results.
8.10 Give ONE reason why setting a field as primary key in a database can help (1)
to improve the quality of data in a database.
8.11 Give ONE suitable example to show that, however well a database is
designed to ensure that the data is always valid, it can never ensure that
the data is always correct. (1)
TOTAL [15]
SECTION B [75]
Computer Applications Technology/P2/Gr 11 13 NW/June 2019
NCS
SECTION C
QUESTION 9: INTEGRATED SCENARIO
Your school will be hosting a Computer Olympiad. An information desk has been set
up to allow people to see what projects are available, and where they are located in the
lab. The computers at various displays need to be linked to a file server at the
information desk
9.1 Give TWO general advantages of connecting computers and devices (2)
wirelessly, besides any cost factors.
9.2 What type of communication device would you have to install to give (1)
everyone wireless access in this situation.
9.3 The organiser would like an Intranet to be set up for the Olympiads.
9.3.1 Explain what an intranet is. (2)
9.3.2 Give TWO possible reasons why it would be better to use an (2)
intranet instead of a website on the internet at this Olympiad.
9.4 Name TWO disadvantages of using an interactive whiteboard. (2)
9.5 Give TWO functions of a UPS that make a good idea to purchase or hire (2)
for the day.
9.6 It is critical that a backup copy of all the information on the file server is
kept.
9.6.1 Briefly explain why they should not create a backup of the (1)
information in another folder on the same server.
9.6.2 Give TWO advantages of using a 2.5" external hard drive to back (2)
up these files.
9.7 Give ONE practical way of preventing ('stopping') the theft of portable (1)
computers at the Olympiads.
9.8 One of the exhibitors has a laptop with a hard drive that is rapidly running
out of free hard drive space. Someone suggested that they defragment the
hard drive to solve this problem, or perform archiving.
9.8.1 Explain why defragmenting the hard drive would not solve the (2)
problem, by describing what defragmenting actually does.
9.8.2 Explain what archiving means in this context and how it could (2)
help free up disk space.
Computer Applications Technology/P2/Gr 11 14 NW/June 2019
NCS
9.8.3 Give TWO other methods of freeing up disk space besides (2)
archiving.
9.9 One of the exhibitors complained that her flash drive ended up with a
computer virus after someone took it and inserted it in their computer.
9.9.1 Someone suggested she format the flash drive to remove the
virus.
Explain what formatting is in this context and explain what the
problem is with this approach (of getting rid of the virus). (2)
9.9.2 How might a biometric flash drive have helped in this situation? (3)
9.10 There has been some discussion as to whether those people attending the
expo should be given a printed document with all the details of the
Olympiads, or whether they should find the information on a touch screen
computer at the information desk.
9.10.1 Give TWO potential benefits of using a touchscreen as opposed (2)
to a printed document in this situation.
9.10.2 Give TWO potential benefits of using printed documents as (2)
opposed to a touch screen in this situation.
9.11 Propriety software, OSS software and shareware are installed on the
computers.
9.11.1 Give TWO disadvantages of open source software (OSS). (2)
9.11.2 Explain what is meant by shareware. (2)
9.12 It is important to ensure that the network is not affected by spyware or
adware, which often comes 'bundled' with free software downloaded from
the Internet.
9.12.1 Briefly explain what spyware is, and what it does on a computer (2)
once it is installed.
9.12.2 Give TWO ways in which you can prevent adware from appearing (2)
on your computer.
9.13 In setting up the network the organisers need a strong password. Give (3)
THREE characteristics or properties of a strong password.
Computer Applications Technology/P2/Gr 11 15 NW/June 2019
NCS
9.14 The computer network will be implemented as WLAN. Explain briefly what (2)
a WLAN is. (Do not expand the abbreviation).
9.15 The organisers would need NICs and a switch.
Explain why they would need NICs and a switch to establish the network (4)
by referring to what each of them does (their function).
9.16 A NIC was indicated with an 803.11n specification. (1)
What does 802.11 specification indicates?
9.17 They were encouraged to make use of an online service such as SkyDrive (2)
or Dropbox for backing up their data.
Give TWO disadvantages of using an online storage service for backing up
data.
TOTAL [50]
TOTAL SECTION C: [50]
GRAND TOTAL: 150
