Downloaded from hlayiso.com
SENIOR CERTIFICATE EXAMINATION
COMPUTER APPLICATIONS TECHNOLOGY P2
2015
MARKS: 150
TIME: 3 hours
This question paper consists of 15 pages.
Copyright reserved Please turn over
Skip to contentAll 2015 papers 





View all





Computer Applications Technology Grade 12 P2 2015 QP (Eng)
Grade 12 Computer Applications Technology Paper 2 question paper from the NSC June Exam 2015 (English), 15 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · NSC June Exam · 2015. Question paper, 15 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2015
- Exam period
- NSC June Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 15
- File size
- 279.8 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 15
This exam
NSC June Exam 2015
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Computer Applications Technology/P2 2 DBE/2015
SCE
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 (QUESTION 1, 2, 3, et cetera) on a NEW page.
5. Do NOT write in the right-hand margin of the ANSWER BOOK.
6. Leave a blank line after EACH subquestion.
7. In general, a mark is allocated per fact. A 2-mark question would therefore
generally require TWO facts, et cetera.
8. Write neatly and legibly.
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 3 DBE/2015
SCE
SECTION A
QUESTION 1: MATCHING ITEMS
Choose a term/concept from COLUMN B that matches the description in COLUMN A.
Write only the letter (A–S) next to the question number (1.1–1.10) in the
ANSWER BOOK, for example 1.11 T.
COLUMN A COLUMN B
1.1 A website that allows users to keep A metadata
an online diary
B absolute cell referencing
1.2 A device built into a laptop that can
be used as a keyboard and a C validation text
mouse
D file extension
1.3 Transferring data from a database
to a spreadsheet without retyping E conditional formatting
or copying and pasting the data
F pharming
1.4 An operating system typically used
on a tablet G speech recognition
1.5 The error message displayed if a H formatting
user enters invalid data in a
database field I bandwidth
1.6 Software that allows the computer J podcast
to change spoken words into text
K blog
1.7 A way to make sure that cell
addresses do not change when a L Firefox
formula is copied
M phishing
1.8 A term used to describe any type
of high-speed Internet connection N exporting
1.9 A technique used to take a user to O OCR
a fake website even if the correct
address was entered in the P touch screen
browser
Q broadband
1.10 Additional information about a
document, such as the name of the R validation rule
author
S Android
(10 x 1) [10]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 4 DBE/2015
SCE
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 D.
2.1 Which ONE of the following refers to a new program being added to a
computer?
A Hibernation
B Installation
C Application
D Fragmentation (1)
2.2 Which ONE of the following file extensions shows that it is an image file?
A .bmp
B .exe
C .pdf
D .rar (1)
2.3 Which ONE of the following is a program that seems to be useful but really
contains malware such as a virus?
A Cookie
B Spam
C Trojan
D Hoax (1)
2.4 Which ONE of the following protects legal ownership of electronic material?
A File size
B Properties
C URL
D Copyright (1)
2.5 Which ONE of the following is a set of guidelines for proper behaviour, such
as not using only capital letters in an electronic message?
A EULA
B AUP
C Netiquette
D Law (1)
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 5 DBE/2015
SCE
2.6 Which ONE of the following types of graph is the most appropriate for
presenting trends over a period of time?
A Line chart
B Column chart
C Bar chart
D Pie chart (1)
2.7 Which ONE of the following is a spreadsheet function used to highlight cells
that satisfy specific criteria?
A IF
B Text wrapping
C Conditional formatting
D VLOOKUP (1)
2.8 Which ONE of the following is the most suitable data type for storing
cellphone numbers in a database table?
A Text
B Number
C Yes/No
D Hyperlink (1)
2.9 Which ONE of the following appears at the bottom of the page providing an
explanation/giving more detail about text contained on that page?
A Page numbering
B Styles
C Headers and footers
D Footnotes (1)
2.10 Which ONE of the following is an example of a web browser?
A Yahoo!
B WhatsApp
C Access
D Chrome (1)
[10]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 6 DBE/2015
SCE
QUESTION 3: TRUE/FALSE ITEMS
Indicate whether each of the following statements is TRUE or FALSE. Write 'true' or
'false' next to the question number (3.1–3.5). If the statement is FALSE, change the
underlined word(s) to make the statement TRUE. Write only the appropriate word(s)
next to the question number.
EXAMPLE:
QUESTION ANSWER
The digital divide is characterised True
by unequal access to ICT by
different groups of people.
Computer program instructions False – CPU
are executed by the RSS.
3.1 Icons, toolbars and buttons are all typical components of a GUI. (1)
3.2 A port is software that monitors and controls access between a computer and
the Internet. (1)
3.3 A scanner is an output device. (1)
3.4 The content of the RAM will be lost if there is a power outage. (1)
3.5 The shortcut Ctrl+S is commonly used for pasting text that you have copied or
cut. (1)
[5]
TOTAL SECTION A: 25
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 7 DBE/2015
SCE
SECTION B
QUESTION 4: SYSTEMS TECHNOLOGIES
4.1 State TWO advantages of using a wireless keyboard as opposed to a wired
keyboard. (2)
4.2 Name TWO devices necessary for video conferencing besides the actual
computer or computer device being used. (2)
4.3 A multifunction printer saves space in an office.
4.3.1 State TWO functions, other than printing, that this device can
perform. (2)
4.3.2 State ONE potential disadvantage of a multifunction printer. (1)
4.4 Explain why a computer power user, such as an architect, would need a
computer with higher specifications. (2)
4.5 Give TWO ways in which computers can be used to benefit the environment. (2)
4.6 Give TWO hardware specifications that need to be considered when buying a
printer. (2)
4.7 Explain what the term convergence means by referring to a suitable example. (2)
4.8 A keyboard has stopped responding.
State TWO possible ways in which this problem can be solved without
replacing the keyboard. (2)
4.9 The free space left on a flash drive is less than the size of the document you
need to copy to it.
Suggest a solution to copy the document to the flash drive without changing
the contents of the document or removing any files from the flash drive. (1)
4.10 Purchasing a computer requires comparing various needs against computer
specifications.
4.10.1 Which TWO components in general have a significant effect on the
performance of a computer? (2)
4.10.2 What name is given to the fast electronic device that can replace
a hard drive? (1)
4.11 Give TWO uses for text-to-speech software. (2)
4.12 Give TWO reasons why it may be better to run tasks such as defragmentation
or virus scans while you are not doing anything else on the computer. (2)
[25]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 8 DBE/2015
SCE
QUESTION 5: INTERNET AND NETWORK TECHNOLOGIES
5.1 Which component in a computer allows you to connect to a network? (1)
5.2 Give TWO examples of where the government provides services via the
Internet. (2)
5.3 Give TWO reasons why a school should not use Twitter to send learners'
examination results to parents. (2)
5.4 Why is it important to have different user accounts on a network? (1)
5.5 Give TWO advantages of using VoIP instead of a normal telephone call. (2)
5.6 What is the major difference between a LAN and a WAN? (1)
5.7 Suggest TWO ways to make a website user-friendly. (2)
5.8 State TWO ways in which you can transfer files between a smartphone and a
computer. (2)
5.9 How can you send a file electronically to another person if it is too large to
send as an attachment to an e-mail? (2)
[15]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 9 DBE/2015
SCE
QUESTION 6: INFORMATION MANAGEMENT
6.1 Word processors are valuable tools for creating reports.
6.1.1 What is the general term used to describe the process where a
graph is added to a document so that it updates (automatically)
when the original data is changed or updated?
NOTE: Do NOT give a description of the process. (1)
6.1.2 Give TWO advantages of using form fields in an electronic
questionnaire. (2)
6.1.3 Name the feature in a word processor that is used to point a
hyperlink to a place within the same document. (1)
6.2 State TWO possible sources of information besides the Internet. (2)
6.3 Describe TWO ways in which you would establish the objectivity of a source. (2)
6.4 Give ONE advantage of asking users to fill out a survey form electronically as
opposed to handing out printed questionnaires. (1)
6.5 What is meant by the term plagiarism? (1)
[10]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 10 DBE/2015
SCE
QUESTION 7: SOCIAL IMPLICATIONS
7.1 Name TWO potential physical health problems caused by frequent use
of ICTs. (2)
7.2 Study the screenshot below and answer the questions that follow.
7.2.1 Which TWO elements in this e-mail may have been the reason why
the service provider identified the e-mail as spam? (2)
7.2.2 Why can this e-mail also be regarded as phishing? (1)
7.2.3 Suggest THREE ways in which you should deal with e-mails of this
nature. (3)
7.3 State TWO advantages of telecommuting. (2)
[10]
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 11 DBE/2015
SCE
QUESTION 8: SOLUTION DEVELOPMENT
8.1 What is the purpose of the Thesaurus function in a word processor? (1)
8.2 Give TWO advantages of using the Track Changes feature in a word
processor. (2)
8.3 Give TWO benefits of using styles when formatting a word processing
document. (2)
8.4 Which feature of a spreadsheet would you use to copy a function down to the
cells below it without copying and pasting it? (1)
8.5 Give ONE reason for using the 'Paste Special' option in a spreadsheet
instead of the normal 'Paste' option. (1)
8.6 What is the purpose of a comment in an HTML file? (1)
8.7 Give TWO possible reasons for hyperlinks not working on a saved HTML
page. (2)
8.8 Explain what a primary key is in a database table. (2)
8.9 Explain what a wizard is by referring to ONE suitable example from a
database. (2)
8.10 Why would it not be appropriate to use a default value in a field that stores a
person's surname in a database table? (1)
[15]
TOTAL SECTION B: 75
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 12 DBE/2015
SCE
SECTION C
QUESTION 9: INTEGRATED SCENARIO
The principal of your school will be interviewing Mr Dell with the intention of appointing
him as an IT support technician. The school principal has asked the CAT class to help
him set up a list of questions to use during the interview.
9.1 Mr Dell would have to be able to install computers in the school.
State THREE ergonomic (health and safety) issues to think of when
preparing the classroom before choosing and installing computers. (3)
9.2 Study the specifications of a computer below and answer the questions that
follow.
Intel Core i3 1.9 GHz
4 GB RAM
500 GB hard drive
DVD writer
21.5" LED touch screen
2 GB dedicated graphics card
802.11 b/g/n
1 x VGA port
1 x HDMI port
9.2.1 The VGA port and the HDMI port can both be used to connect
monitors to the computer.
Give ONE advantage of using the HDMI port instead of the
VGA port. (1)
9.2.2 How much permanent storage space is available on the computer? (1)
9.2.3 Explain how using a dedicated graphics card can improve the
performance of a computer. (1)
9.2.4 How much primary memory does the computer have? (1)
9.2.5 Which ONE of the devices in the specifications can be described
as both an input and an output device? (1)
9.2.6 Which specification indicates that the computer will be able to
connect to a wireless network? (1)
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 13 DBE/2015
SCE
9.3 Mr Dell will need to regularly update or replace software on the computers.
9.3.1 Give TWO reasons why it is a good idea to update software
regularly. (2)
9.3.2 What is a patch? (1)
9.3.3 Mr Dell would like to install shareware on the computers.
Explain what shareware is and what the advantage would be of
using it. (2)
9.3.4 The school principal would like to install a program that converts
documents to PDF files.
Why would the school convert circular letters to PDF format before
e-mailing them to parents? (1)
9.4 Mr Dell will have to create a blog to communicate important events and
sports results to parents.
Give TWO ways in which he can increase the likelihood that people read the
blog regularly. (2)
9.5 State ONE way to prevent advertisements from appearing when browsing the
Internet. (1)
9.6 Explain what is meant by the term disk fragmentation. (1)
9.7 Learners need to make printouts.
Explain what the specifications below would mean with reference to printers.
Do NOT simply write down what the abbreviations stand for.
9.7.1 ppm (1)
9.7.2 dpi (1)
9.8 The school wishes to install entry-level computers.
What is an entry-level computer? (1)
9.9 Mr Dell would like to use biometric security to log on to the server.
Give TWO advantages of using biometric security. (2)
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 14 DBE/2015
SCE
9.10 The computers in the school are all linked to a single network.
9.10.1 Give TWO advantages of connecting computers in a network. (2)
9.10.2 Mr Dell has the option of installing a wireless network.
Give TWO potential disadvantages of a wireless network compared
to a cabled network. (2)
9.11 Mr Dell will be responsible for creating a list of backup tips for the school.
9.11.1 Give TWO useful tips to consider regarding the backing up of data. (2)
9.11.2 Mr Dell wishes to store data in the cloud.
Give TWO advantages of cloud storage. (2)
9.12 Explain the possible cause of each of the following problems:
9.12.1 A wireless mouse is not moving the cursor on the screen, even
though the computer has not frozen. Mr Dell is sure that the mouse
is not broken. (1)
9.12.2 A page sent to the printer did not print, even though the printer is
plugged in, connected correctly and the power is switched on. (1)
9.13 The school principal wishes to ask Mr Dell some questions about using the
Internet.
9.13.1 Explain the difference between a web browser and a search
engine. (2)
9.13.2 Give TWO advantages of using e-banking from a client's
perspective. (2)
9.13.3 Mr Dell wants to install software to prevent malicious programs
(malware) from infecting any of the computers.
Give ONE suitable example of a program that could be used for
this purpose. (2)
9.13.4 Explain what a keylogger is and why it is dangerous. (2)
9.14 Mr Dell would be responsible for the enforcement of the school's AUP
(acceptable use policy).
Name TWO items that may appear in the AUP of a school. (2)
Copyright reserved Please-turn-over
Downloaded from hlayiso.com
Computer Applications Technology/P2 15 DBE/2015
SCE
9.15 The staff may need Mr Dell's assistance.
One of the teachers created the following spreadsheet for recording marks:
9.15.1 Which feature of the spreadsheet application did she use to place
the words underneath each other within the same cell in row 1? (1)
9.15.2 The formula below was used in cell E3 and then copied down to
the rest of the column. The formula worked correctly in cell E3, but
displays incorrect marks for the rest of the column.
=D3/$D$2*E2
Rewrite the function to correctly calculate the term mark if it were
copied down to the whole column again. (1)
9.15.3 What function should be used to find the number of marks in
column E that are greater than 75? (1)
9.15.4 What function should be used to determine the total of all the
marks above 75? (1)
9.15.5 Give TWO reasons why a spreadsheet is the best program for a
teacher to store and process marks. (2)
TOTAL SECTION C: 50
GRAND TOTAL: 150
Copyright reserved *
Study this subject
Recommended for this subject

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

Question paper
Computer Applications Technology Grade 12 P1 2015 QP (Afr)

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

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

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

Question paper
Computer Applications Technology Grade 12 P2 2021 QP (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)

Question paper