Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2018
COMPUTER APPLICATIONS TECHNOLOGY P2
MARKS: 150
TIME: 3 hours
*catne2*
This question paper consists of 18 pages.
Skip to contentAll 2018 papers 





View all





Computer Applications Technology Grade 12 P2 2018 QP (Eng)
Grade 12 Computer Applications Technology Paper 2 question paper from the Eastern Cape Mock Exam 2018 (English), 24 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2018 · English. Question paper, 24 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Language
- English
- Document type
- Question paper
- Year
- 2018
- Exam period
- Eastern Cape Mock Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 24
- File size
- 420.6 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 24
This exam
Eastern Cape Mock Exam 2018
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
INSTRUCTIONS AND INFORMATION
1. This question paper consists 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 on a NEW page.
5. Do NOT write in the right-hand margin.
6. Leave a line after EACH subquestion.
7. In general, one mark is allocated per fact. A 2-mark question would
therefore require TWO facts, et cetera.
8. Write neatly and legibly.
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 3
SECTION A
QUESTION 1: MULTIPLE-CHOICE QUESTIONS
Various options are provided as possible answers to the following questions. Choose
the answer and write only the letter (A–D) next to the question number (1.1–1.10) in
the ANSWER BOOK, for example 1.11 D.
1.1 Which ONE of the following is a component of the CPU?
A NIC
B GNU
C ALU
D SCSI (1)
1.2 Which ONE of the following interfaces is used to power a peripheral device?
A SCSI
B USB
C Parallel
D Infra-red (1)
1.3 With what is the icon shown here associated?
A OCR
B RSS
C XTML
D OSS (1)
1.4 Which ONE of the following is a protocol which provides a measure of
protection to users of websites where banking is done?
A HTML
B HSDPA
C HTTP
D HTTPS (1)
1.5 Which ONE of the following terms refers to a method of publishing audio
files to the Internet, allowing users to receive these files automatically,
usually at no cost?
A HDTV
B Blogging
C Webcasting
D Podcasting (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
4 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
1.6 Which ONE of the following icons represents a network drive?
A
B
C
D
(1)
1.7 A small picture that provides a preview of a file without opening the file.
A Thumbnail
B Spyware
C Wizard
D Microwave (1)
1.8 Firmware is ...
A software that has been debugged and is stable.
B software that is embedded and cannot be updated.
C software programmed by a large multi-national firm.
D software that is embedded and can be updated. (1)
1.9 Which ONE of the following represents access speed in descending order?
A Magnetic tape, hard disk, RAM, cache
B RAM, cache, magnetic tape, hard disk
C Cache, RAM, hard disk, magnetic tape
D RAM, cache, hard disk, magnetic tape (1)
1.10 Multi-processing is when …
A the computer has more than one processor present.
B many programs are running on one processor.
a program is broken into different parts to be executed
C
separately.
D the processor switches rapidly between applications. (1)
[10]
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 5
QUESTION 2: MATCHING ITEMS
Choose a term/concept from COLUMN B that matches the description in COLUMN
A. Write only the letter (A–P) next to the question number (2.1–2.10) in the
ANSWER BOOK, for example 2.11 Q.
COLUMN A COLUMN B
2.1 A hardware device used to protect a computer against A encryption
power surges and spikes
2.2 The ‘scrambling’ of text or data using a specified set B freeware
of rules to ensures the privacy of data during
communication, or for security purposes
2.3 A type of computer interface designed to be used with C LTE
devices like a touch pad
2.4 A policy which outlines the rights and responsibilities of D URL
computer users in an organisation
2.5 A legal contract between a computer user and a E overheating
software company
2.6 Gaining unauthorised access to and making use of a F overclocking
connection in an unsecured Wi-Fi network
2.7 The type of software provided at no cost by a company G protocol
where the company retains all rights to the software
2.8 Increasing the speed of the system bus, hence H UPS
increasing the speed of all components of a computer
system to enhance the performance
2.9 Enables users to watch videos, stream a radio I EULA
station, play online games and browse the Internet in
real time
2.10 Unit in which the resolution of a scanner is measured. J CPU
K GUI
L DPI
M AUP
N piggybacking
O DIMM
P filter
(10 x 1) [10]
Copyright reserved Please turn over
Downloaded from hlayiso.com
6 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
QUESTION 3: TRUE/FALSE
Indicate whether the following statements are TRUE or FALSE. 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. NO mark will be
awarded if only FALSE is written down.)
EXAMPLES:
QUESTION ANSWER
Google is the world’s most popular search engine. True
A NIC has slots for hardware components such as False – motherboard
the CPU.
3.1 Companies often release shareware versions of their software for testing
purposes, before the software is released for sale. (1)
3.2 Broadband refers to the total amount of data transferred over an Internet
connection in a given period of time. (1)
3.3 The term DDR is associated with the RAM of a computer. (1)
3.4 The OLE object data type can be used to add an image to a record in an
Access table. (1)
3.5 The image below is an example of a PIN code:
(1)
[5]
TOTAL SECTION A: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 7
SECTION B
QUESTION 4: SYSTEM TECHNOLOGIES
4.1 Computers are made up of many parts.
4.1.1 What is the term used to describe computers in which the box and the
screen come as a single unit? (1)
4.1.2 State TWO reasons why it is easier for computers to be made up of
many parts, rather than being one functioning unit. (2)
4.2 The CPU does almost all the work in a computer.
4.2.1 There are TWO factors of the CPU that can influence the performance
of a computer. Name these TWO factors and describe each briefly. (4)
4.2.2 Briefly explain why the CPU needs cache memory. (2)
4.3 Study the image of an SSD below, which was part of an advertisement, and
answer the questions that follow. (2)
4.3.1 What does the abbreviation SSD stand for? (1)
4.3.2 Explain why the following will be features of an SSD:
(a) Silent operation (1)
(b) Faster performance (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
8 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
4.4 Every now and then your computer displays the following message:
4.4.1 Explain what virtual memory is. (1)
4.4.2 When will the operating system use virtual memory? (1)
4.5 There are many economic considerations when using computers in a travel
agency. (1)
4.5.1 Besides switching off all computers at night, state TWO other ways
in which the electricity usage of computing devices can be
decreased. (2)
4.5.2 Explain TWO ways in which the use of computers will be financially
beneficial for the travel agency. (2)
4.6 An incorrect statement was made that the use of an effective backup
maintenance program will prevent the hard drive from becoming fragmented.
4.6.1 Describe TWO aspects of an effective backup maintenance
program. (2)
4.6.2 What kind of storage device would be used when backing up files
from a server? (1)
4.6.3 Define the term disk fragmentation. (1)
4.7 Give THREE reasons why it is necessary to have an operating system
installed on a computer by referring to the functions of an operating system. (3)
[25]
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 9
QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES
Phishing against banks hits
all time high
Anti-Phishing Working Group warns of relentless
increase
5.1 More and more criminals are making use of the Internet and phishing is
becoming a worrying problem.
5.1.1 Write down the URL in the example above. (1)
5.1.2 Explain, by giving an example, how phishing is used to commit a
crime. (2)
5.2 Today most computer devices are connected to some type of network, from
a Personal Area Network (PAN) to Wide Area Network (WAN).
5.2.1 Explain what a Personal Area Network (PAN) is by referring to its
characteristics. (2)
5.2.2 Briefly explain what a Virtual Private Network (VPN) is. (2)
5.2.3 Wi-Fi networks are targets for hackers. Suggest ONE effective way
of protecting a Wi-Fi network. (1)
5.3 Web browsers use a technology called web caching.
5.3.1 State TWO possible advantages of using web caching. (2)
5.3.2 Describe TWO ways in which available bandwidth plays a role when
watching videos online from services like YouTube. (2)
5.3.3 Define the term protocol in a network. (1)
5.3.4 What protocol will be used to send files between remote computers
that have an Internet connection? (1)
5.4 What type of network would use a 3G modem? (1)
[15]
Copyright reserved Please turn over
Downloaded from hlayiso.com
10 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
QUESTION 6: INFORMATION MANAGEMENT
6.1 The school has to gather information about why so many learners want to
change their subjects in Grade 11.
Study the questionnaire below and answer the questions that follow.
6.1.1 Identify any ONE closed question in the questionnaire.
Simply write down the question number as your answer. (1)
6.1.2 Why might the answers given for Question 2 on the questionnaire be
difficult to analyse in a spreadsheet? (1)
6.1.3 Explain why Question 4 on the questionnaire is not a good survey
question. (1)
6.1.4 The questionnaire does not have an introduction.
Give ONE element that should be included in the introduction of a
survey. (1)
6.2 Give ONE disadvantage of conducting a survey online; that is by using a
website for people to post their responses. (1)
6.3 What is metadata? Also give a suitable example of metadata in your answer. (2)
6.4 Quality data is needed for useful information to be extracted from a database.
List THREE characteristics of quality data. (3)
[10]
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 11
QUESTION 7: SOCIAL IMPLICATONS
7.1 Sea Shepherd Conservation Society (SSCS) is considering creating a
website to help market the safeguarding of ocean ecosystems.
Give ONE potential advantage and ONE potential disadvantage of using a
website for marketing. (2)
7.2 The website created for safeguarding ocean ecosystems has a Privacy
Policy. Below is an extract from it.
Kids and Privacy
For children, who visit our site, special rules apply. We do not request
personal information about children, such as first and last name or street
address and city. When kids send e-mail to us, their online contact
information (e-mail address) is not used to re-contact them and is not
maintained in retrievable form.
Discuss the dangers for children if their ʽprivacy’ is not guaranteed (2)
7.3 The Sea Shepherd Conservation Society (SSCS) purchased an antivirus
program. Can they install it on all the computers, seeing that the computers
all belong to the same business?
Motivate your answer briefly. (2)
7.4 State TWO negative implications of 3D printers, which are becoming more
common. (2)
7.5 Many cameras have the capability to ‘geotag’ photographs. (1)
7.5.1 Explain the term geotagging. (1)
7.5.2 Why do the SSCS discourage children from placing geotagged
photographs of whales on social media? (1)
[10]
Copyright reserved Please turn over
Downloaded from hlayiso.com
12 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
QUESTION 8: SOLUTION DEVELOPMENT
8.1 The electronic form below was designed to be used for online registration of
exhibitors.
8.1.1 Critically comment on the layout of the components of the form, by
indicating TWO ways in which the layout can be improved. (2)
8.1.2 Critically evaluate the components on the form that are used to
obtain data from the user. Identify ONE poorly chosen component
and suggest a more suitable component. (2)
8.2 Study the spreadsheet below and answer the questions that follow.
8.2.1 Give only the name of the function that was used in column B to
obtain the position of the space between the first name and the
surname. (1)
8.2.2 Give the most likely reason for obtaining the position of the space
between the first name and the surname. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 13
8.3 The function below was used in a spreadsheet to count the number of cells
in the range B3:B10 that contain amounts less than R100.00.
=COUNTA(B3:B10,>R100)
Give TWO reasons why this function will NOT work correctly, and give the
correction in each case. (2)
8.4 Study the screenshot extract of a database table below and answer the
questions that follow.
8.4.1 Which criterion would you enter in a query to extract suburbs starting
with ‘A’? (2)
8.4.2 State which data type was used for the field DwellingNumber. (1)
8.4.3 Which criterion would you enter in a query to find those records that
do not have a value entered in the DwellingNumber field? (1)
8.5 A learner created a web page using hypertext markup language (HTML).
When he double-clicked the file in Windows Explorer to view the page in a
browser, the file opened in Notepad.
Briefly explain what mistake was made in saving the file, and how to fix the
mistake so that the web page may be viewed in a browser. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
14 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
8.6 Examine the screenshot below of a table on a web page that was created
using HTML and answer the question that follows.
Only the word ‘malware’ (in the second column) should be in italics.
However, all the text after this word is italicised as well.
What is the most likely cause of this error? (1)
[15]
TOTAL SECTION B: 75
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 15
SECTION C
QUESTION 9: INTEGRATED SCENARIO
The school will host a website and be a part of a social network to allow for players
to register and to play games online.
9.1 For the current gaming event gamers were informed that they can configure
the settings on their computers to optimise game play.
Explain what can be done to save bandwidth while streaming. (1)
9.2 The CAT learners will make gamers aware of the NFC (near field
communication) feature that is available on their tablets and other hand-held
devices.
9.2.1 Give TWO examples of what NFC (near field communication) can be
used for. (2)
9.2.2 NFC originated from a communication standard that uses radio
waves. What is this communication standard called? (1)
9.3 Separate versions of some of the gaming software applications have been
developed to provide for different operating systems, such as Android and
IOS.
9.3.1 Motivate why the same application needs to be programmed
differently for different operating systems. (2)
9.3.2 An important feature of an operating system is backward
compatibility.
Use an example to explain the concept of backward compatibility. (2)
9.3.3 To customise the mouse icon for the gamers, where would you go to
change the icon to a horse?
(1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
16 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
9.4 One of the gamers will use the headset in the illustration below.
[Source: http://www.bestbuy.com/site/video-games-accessories/gaming-headset]
9.4.1 The headset supports plug-ins. Explain what a plug-in is. (1)
9.4.2 How does the fact that the headset supports plug-ins benefit the
gamer? (1)
9.5 These types of devices normally contain sensors.
Name TWO possible types of sensors found on gaming devices. (2)
9.6 Gamers will be required to locate at least one Pokémon at some stage
during the gaming event. To take part in the Pokémon GO location-based
augmented reality (AR) game, a mobile device with GPS
technology is required.
9.6.1 What does the abbreviation GPS stand for? (1)
9.6.2 Name TWO disadvantages of Augmented Reality (AR). (2)
9.7 Some gamers are unable to use their hands. Alternative measures have
been investigated. Motivate TWO alternative input devices, for gamers who
are physically handicapped, to make use of the games. (2)
9.8 Some of the gamers are not comfortable with using computers or do not
have computers at home, while the other are very comfortable and have
been working on computers from a very young age.
What is this ‘gap’ called? (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2018) COMPUTER APPLICATIONS TECHNOLOGY P2 17
9.9 The Internet of Things (IoT) is one solution for information overloading.
9.9.1 Briefly explain the term Internet of Things. (2)
9.9.2 Name TWO advantages of the Internet of Things. (2)
9.9.3 What is meant by information overloading and what is the effect on
the user? (2)
[25]
QUESTION 10
The school hosts an exhibition that will showcase a variety of topics and new
technologies. A separate help desk will be available to assist with any queries.
10.1 Each exhibitor will be issued with a wrist band containing an RFID tag to
allow the exhibitor access to the canteen for lunch.
Motivate the use of RFID tags instead of tickets with bar codes. (2)
10.2 One of the exhibitors will do a presentation on the capabilities of intelligent
self-driven vehicles.
10.2.1 State ONE essential intelligent task that the software designed for
a self-driven vehicle should be able to perform. (1)
10.2.2 Self-driven vehicles use GPS devices.
Name TWO other hardware devices that this type of vehicle should
have in order to perform the intelligent tasks required. (2)
10.2.3 It has been stated that there will be fewer accidents with self-driven
vehicles as human error will be eliminated.
State ONE disadvantage of self-driven vehicles. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
18 COMPUTER APPLICATIONS TECHNOLOGY P2 (EC/SEPTEMBER 2018)
10.3 A cybercrime expert will compile a poster about computer crimes committed
by means of ICT as a tool.
10.3.1 Discuss TWO ways in which cybercrime can have a negative
influence on a business. (2)
10.3.2 Explain what a denial-of-service attack is. (2)
10.4 An environmental agency requested a stand to promote the responsible use
of computers in the environment.
Suggest TWO ways in which the negative effects of computers on the
environment can be minimised. (2)
10.5 There are several free Wi-Fi hotspots with limited data per day that the
exhibitors can use.
10.5.1 What is a public Wi-Fi hotspot? (2)
10.5.2 Motivate the reason for limiting the data per day for the exhibitors
of these Wi-Fi hotspots. (1)
10.6 The school has hired security consultants to advise on many security
aspects to help protect exhibitors from computer theft.
10.6.1 Name THREE items of personal information that should NOT be
posted on a social networking site. (3)
10.6.2 Name TWO types of computer criminals. (2)
10.7 All registration information for the exhibitors has been captured in a database
table. Which field properties of the data types need be changed to:
10.7.1 Limit the First Name field to 15 characters. (1)
10.7.2 Set the status as “Finished” for all exhibitors. (1)
10.7.3 Restrict input in the Gender field to “male” and “female” only. (1)
10.7.4 Allow only two letters and two numbers to be used as the
registration number. (1)
10.7.5 Ensure that the ExhibitorsID field cannot be left blank. (1)
[25]
TOTAL SECTION C: 50
GRAND TOTAL: 150
Copyright reserved Please turn over
Downloaded from hlayiso.com
Downloaded from hlayiso.com
Downloaded from hlayiso.com
Downloaded from hlayiso.com
Downloaded from hlayiso.com
Downloaded from hlayiso.com
Study this subject
Recommended for this subject

Question paper
Computer Applications Technology Grade 12 P2 2022 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2022 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2021 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2020 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2018 QP (Afr)

Memorandum
Computer Applications Technology Grade 12 P2 2019 Memo (Eng)
More from Grade 12 Computer Applications Technology

Memorandum
Computer Applications Technology Grade 12 P1 2025 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2025 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2025 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2024 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P2 2024 Memo (Eng)

Errata