PROVINCIAL EXAMINATION

COMPUTER APPLICATIONS TECHNOLOGY

PAPER 2

NOVEMBER 2015

GRADE 10

MARKS: 120

TIME: 2½ HOURS

This paper consists of 11 pages

INSTRUCTIONS AND INFORMATION

1. This question paper consists of THREE sections: Answer ALL questions.

Section A Short questions [25]
Section B Questions per topic [62]
Section C Integrated scenario [33]
2. Answer ALL the questions
3. Number the answers correctly according to the numbering system used in
this paper.
4. Start EACH question on a NEW page.
5. Do NOT write in the right-hand margin.
6. Read ALL the questions carefully
7. In general, a mark is allocated per fact. A 2-mark question would therefore
require two facts, etc.
8. Write neatly and legibly.
 Computer Application Technology/P2 3 Gr 10 November 2015

SECTION A – SHORT QUESTIONS [25]

QUESTION 1 – MULTIPLE CHOICE QUESTIONS [10]

Various options are given as possible answers to the following questions.
Choose the most appropriate answer and write only the letter (A–D) next to the
question number (1.1–1.10), for example 1.11 D

1.1.
1.1 Which one of the following is an example of input and an output 1
device?
A. Keypad
B. Digital Camera
C. Touch Screen
D. Stylus

1.2 Which one of the following is NOT an example of system software? 1

A. Microsoft Office
B. Windows 8
C. Android
D. iOS

1.3 Which one of the following mouse actions will give you options like 1
move, size, minimize, close and etc?
A. Scrolling
B. Right Clicking
C. Double Clicking
D. Clicking

1.4 The standard layout of the keyboard is known as......? 1

A. Alphabetic keys
B. Numeric keys
C. Special keys
D. QWERTY

1.5 Which ONE of the following categories of system software can you 1
download from the internet free of charge with fully functionality?
A. Shareware
B. Freeware
C. Open source software
D. Proprietary software

Copyright reserved Please turn the page

Computer Application Technology/P2 4 Gr 10 November 2015

1.6 Which ONE of the following does NOT form part of dedicated devices? 1
A. GPS
B. Microwave
C. Washing machine
D. Smartphone

1.7 Which of the following printers can be used to produce high quality 1
images?
A. Laser Printer
B. Inkjet Printer
C. Dot-matrix Printer
A. Thermal printer

1.8 Which one of the following does NOT logically belongs together? 1
A. HAN
B. Intranet
C. Internet
D. Extranet

1.9 Which one of the following would be the result if the following function 1
is typed in a Spread sheet: =SQRT(A5) where A5 is equals to “25”
A. 10
B. 25
C. 5
D. 15

1.10 Which one of the following is not needed to set up a computer network? 1
A. UTP
B. Switch
C. Network Software
D. Graphics Card

Copyright reserved Please turn the page

Computer Application Technology/P2 5 Gr 10 November 2015

QUESTION 2 – MODIFIED TRUE AND FALSE [5]

The following statements are either TRUE OR FALSE.

State whether each statement is TRUE OR FALSE. If the statement is false
then rewrite the statement to make it true. In other words, replace the bold-
printed, underlined portion to correct term.
For example:
E-mailis the electronic equivalent of „junk mail‟.
False: Spamis the electronic equivalent of „junk mail‟.
Note: No marks will be awarded for simply negating the false statement.

2.1 Site licence is a license agreement that allows user to install only one 1
copy of the software.
2.2 The way in which a slide is made to appear on the screen is called 1
transition.
2.3 #NUM is an error message that occurs if an invalid numerical value is 1
used in a function.
2.4 Data is the results of the processing of raw facts and it is meaningful. 1
2.5 Bar graph is a graph that is designed to show how much is each 1
percentage contributing to the total percentage.

Copyright reserved Please turn the page

Computer Application Technology/P2 6 Gr 10 November 2015

QUESTION 3 – MATCHING ITEMS [10]

Match the explanation/ description in column A with the term/word in column B

Column A Column B

3.1 Special plug-in programs are needed to allow the user to A. =SUM(A1:A2)
view special effect.

3.2 Program that is used to access and view web pages on the B. Cap
internet.

3.3 Application software that can allow user to perform tasks C. Driver
that are based on calculations.

3.4 A malicious program that is intended to disrupt the normal D. Plug-in

functioning of a computer.

3.5 The sum of cells A1 and A2(function) E. Fax to e-mail

3.6 An area where there is Wireless Internet access. F. Web browser

3.7 They are identified as 1, 2, 3 … G. Virus

3.8 An ability to send a fax to a fax machine using your H. Spreadsheet

computer and your email system and vice versa.

3.9 The amount of data a person can download and upload in I. Hotspot
a month.

3.10 Software that allows your computer to communicate with J. Function

the hardware or devices connected in your computer.
K. Rowsin Excel
L. Formula
M. Resolution
N. Columns in
Excel

Copyright reserved Please turn the page

Computer Application Technology/P2 7 Gr 10 November 2015

SECTION B [80]

SCENARIO

Your father, Paul has started a transport business to help the community of Mpumalanga
in trying to intervene in the transport problem caused by the Mpumalanga scholar
transport. He asked you as a CAT learner to assist with any computer related issues in
his business.

QUESTION 4 – SYSTEMS TECHNOLOGIES [20]

R 13 897 .89
R 6 589.99

Computer A Computer B

Lenovo ThinkPadX130e Dell SPX 13Core i7 touch screen 2015

version
500 GB 72 rmp Hard disk 256 GB Solid State Drive
4GB RAM (1 4 GB + 1 Slot Free, 16 GB 8GB DDR3L RAM
max)
5th gen Intel Core i5 – 5200u (2.2 GHz) 5th gen Intel Core i7 – 5500u (2.4 GHz)
16.0 inch HD Display (1366 × 768) 13.3 – inch QHD + (3200 × 1800) infinity
display
Wireless + Bluetooth Wireless – AC 7260 + Bluetooth
AMD Radeon R7 M265 2GB graphics Intel HD Graphic 5500
Windows 8.1 Pro 64- Bit Windows 8.1 Pro 64-Bit
1Computer
Year Carry-in warranty 3 years on-site warranty

4.1. What is the speed of the processors for computer A and Computer B? (2)

4.2. Which computer has the best primary memory? Specify the size. (2)

4.3. Give the specification of the highest pixels in the two advertised (1)
computer by referring to the screen resolution

Copyright reserved Please turn the page

Computer Application Technology/P2 8 Gr 10 November 2015

4.4. Your father wants to buy one computer from the two advertised
computers for his office.

4.4.1. Explain to your father what the specification "16-inch" refers (2)
to.

4.5. Mention the company manufactured the graphics card of Computer A (1)

4.6. Which specification refers to the operating system in the adverts? (1)

4.7. Explainto your father what the specification “on-site warranty” refers (2)
to in computer B?

4.8. Your father would like to buy a printer to print only office invoices. He
overheard some people talking about a wireless laser printer.

4.8.1. Is this the best option? Motivate your answer. (2)

4.8.2. Tell your father what would be the advantages of buying a (2)
wireless printer over the wired printer. Mention 2

4.9. Tell your father about the advantages of a touch screen as indicated (3)
in computer B, by referring to at least Three gestures for the touch
screen.

4.10. Would it be possible for one to transfer files from Computer A to (2)
Computer B in the advert? Motivate your answer by referring to the
specifications in the advert.

QUESTION 5 - INTERNET AND NETWORK TECHNOLOGIES [12]

5.1 Your father would like to set up a smallnetwork in his office to connect to all
his clients‟ schools in Mpumalanga.
5.1.1. Define a network (2)
5.1.2. Help your father to identify the FOUR resources needed to set up a (4)
small network.
5.1.3. Distinguish between TWO types of small networks. (2)
5.1.4. Mention TWO advantages of each of the two small networks (4)
mentioned in 5.1.3.

Copyright reserved Please turn the page

Computer Application Technology/P2 9 Gr 10 November 2015

QUESTION 6 -SOCIAL IMPLICATIONS [5]

Your father has joined Face book and he is worried about a lot of notifications
from Face book telling him about people he may know.
6.1. Mention 1 serious danger that your father might be exposed to by using (1)
social networking sites such as Face book.
6.2. Advise him about TWO guidelines to help him to protect himself while he is (2)
using a networking site such as Face book.
6.3. A pop up appeared on your father‟s laptop saying that he should download (2)
an anti-virus program from the Internet. What is an anti-virus program?

QUESTION 7 - INFORMATION MANAGEMENT [10]

7.1. Define the following concepts

7.1.1. Task Definition (2)
7.1.2. Survey (2)
7.1.3. Data (2)
7.1.4. Information (2)
7.1.5. Plagiarism (2)

Copyright reserved Please turn the page

Computer Application Technology/P2 10 Gr 10 November 2015

QUESTION 8 – SOLUTION DEVELOPMENT [15]

(2)
(2)
(2)
(2)
(2)
8.1 NOTE. Supply a function that can be typed in the cells numbered from
8.1.1 to cell 8.1.5
8.1.6 Supply a function we would use to determine the shortest trip (2)
8.1.7 Supply a function we would use to determine the longest trip in the (2)
invoice above
8.1.8 Write down the function to determine the average kilometres (Km) (1)

SECTION C

QUESTION 9 - INTEGRATED SCENARIO [33]

9.1. Your father finds it very interesting to computerise his work and keep his
offices clean and paperless.
9.1.1. What is the name given to the process of making a paperless (1)
environment?
9.1.2. Mention TWO health issues that he may suffer from when using (2)
his computer for too long.
9.1.3. Give him at least TWO tips that he needs to know when using (2)
computers to prevent health risks.
9.2. Your father is a person who likes to go out on vacations and would like to
buy himself a digital camera to take pictures.
9.2.1. Briefly describe the term digital camera (2)

Copyright reserved Please turn the page

Computer Application Technology/P2 11 Gr 10 November 2015

9.2.2. Mention at least THREE advantages of a digital camera (3)

9.3 Your father would also want to connect to the Internet and communicate
through e-mail with other schools in Mpumalanga.
9.3.1 Briefly explain what an ISP is as one of the components your (2)
father would need to connect to the Internet. Do not just expand
the acronym.
9.3.2 What are the other THREE components needed to connect to the (3)
Internet?
9.3.3 Mention Two things that your father should be aware of that would (2)
be the indicators if the fact that his computer is affected with a
virus.
9.3.4 Advice your father about THREE types of anti-virus programs (3)

9.3.5 Give your father THREE tips to set up a good password. (3)

9.3.6 Differentiate between a website and a webpage (2)

9.4

9.4.1 Study the screenshot above. Who is the main recipient of this (1)
email?
9.4.2 From the above screenshot, explain the abbreviation Bcc? (2)
9.4.3 Define the concept netiquette. (2)
9.4.4 Give THREE netiquette rules ignored in this email (3)

GRAND TOTAL 120

Copyright reserved Please turn the page

 PROVINCIAL EXAMINATION

COMPUTER APPLICATIONS TECHNOLOGY

PAPER 2

MEMORANDUM

NOVEMBER 2015

GRADE 10

MARKS: 120

TIME: 2½ HOURS

This paper consists of 8 pages

1
SECTION A – SHORT QUESTIONS [25]

QUESTION 1 – MULTIPLE CHOICE [10]

1.1. =C
1.2. =A
1.3. =B
1.4. =D
1.5. =B
1.6. =D
1.7. =B
1.8. = A
1.9. =C
1.10. =D

QUESTION 2 – MODIFIED TRUE AND FALSE [5]

2.1 False Single user licence is a licence agreement that allows user
to installed only one copy software.
2.2 True The way in which a slide is made to appear on the screen is
called transition.
2.3 True #NUM is an error that occurs if an invalid numerical value is
used in a function.
2.4 False Information is the results of the processing of raw facts and
it is meaningful.
2.5 False Pie graph is a graph that is designed to show how much is
each percentage contributing to the total percentage.

QUESTION 3 – MATCHING ITEMS [10]

3.1 D 1
3.2 F 1
3.3 H 1
3.4 G 1
3.5 A 1
3.6 I 1
3.7 K 1
3.8 E 1
3.9 B 1
3.10 C 1

2
SECTION B [62]

QUESTION 4 – SYSTEM TECHNOLOGIES [20]

4.1. Computer A: 5th gen Intel Core i5 – 5200u (2.2 GHz) 2

Computer B: 5th gen Intel Core i7 – 5500u (2.4 GHz)
4.2. Computer B , 8GB DDR3L RAM 2
4.3. Computer B: 3200 × 1800 1
4.4. It refers to the size of the monitor measured diagonally, from top 2
left to bottom right and vice versa
4.5. AMD 1
4.6. Windows 8.1 Pro 64- Bit 1
4.7. It means that if the computer is faulty, the father can just inform the
supplier and they would come and pick it up for fixing from site. 2
4.8. 4.8.1. No, He needs only a dot matrix printer for this purpose. 2
4.8.2 No cord to get tangled 2
You are not restricted by cable length to use it.
It is easy to use
Any Two
4.9. Swipe, pinch, Expand, drag 3
Any Three
4.10. Yes, file transferred by Bluetooth 2

3
QUESTION 5 – INTERNET AND NETWORK TECHNOLOGIES [12]

5.1. Computer networks

5.1.1. Network is a collection of computers or computing devices such 2
as smart phones that are connected by some sort of
communication media.
5.1.2. Computer devices 4
Switch
Cable or wireless technology
Network software
Network interface controller
Any FOUR
5.1.3. Personal Area Network, is a computer network organised 2
around an individual with a small range
Home Area Network is a small network within a person's home
environment and connects devices such as computers, printers,
cell phones and smart phones
5.1.4. Advantages Personal Area Network 4
Files can be backed up from a cell phone or a smartphone
to a laptop and vice versa.
A user can e-mail and browse the internet by connecting
the PAN to the internet whilst on the move.
Small files can be transferred easily.
Any Two.

Advantages Home Area Network

Efficient communication between devices in the HAN,
which leads to flexibility.
Resources such as printers can be shared among all
users.
Data saved on different computers can be shared and
transferred easily.
Games can be played with other people using the network.
Any Two

4
 QUESTION 6 - SOCIAL IMPLICATIONS [5]

6.1.1. Facebook
6.1.1. He might talk to people who are not whom they claim to be. 1
His personal information might be stolen to commit fraud.
Any relevant answer
6.1.2. Never to give out his personal information. 2
Never arrange to meet in person with strangers.
Newer upload pornographic pictures.
Any Two
6.1.2. Software that is intended to protect the computer by scanning 2
viruses and eliminating them.

QUESTION 7 – INFORMATION MANAGEMENT [10]

7.1.1. Task definition is a detailed explanation and description of the most 2

important aspects of a problem
7.1.2. A survey is data collection tool used to gather information about 2
individuals
7.1.3. A report is a document about a specific task that presents findings of 2
an investigation.
7.1.4. Information is the results of the processing of data. 2
7.1.5. Plagiarism is the process of taking someone else’s work and presents 2
it as your own.

5
QUESTION 8 – SOLUTION DEVELOPMENT [15]

8.1.1 =C14 *D14 2

Or
=(C14 *D14 )
8.1.2 =SUM (G13:G15) 2
Or
=(G13+G14+G15)

8.1.3 =G16 * 0.14 2

Or
=(G16*14)/100
8.1.4 =G16 + G17 2
Or
=SUM(G16:G17)
8.1.5 =(C15* D15) * F15 2
Or
=E15*F15
8.1.6 =MIN (C13:C15) 2
Or
=SMALL (C13:C15,1)
8.1.7 =MAX (C13:C15) 2
=LARGE (C13:C15,1)
8.1.8 =AVERAGE (C13:C15) 1

6
SECTION C [33]

QUESTION 9.- INTEGRATED SCENARIO [33]

9.1
9.1.1. Green Computing 1
9.1.2. Eye strain 2
Finger strain or wrist
Back pain
Headache
Any Two
9.1.3. He must take regular breaks 2
Use spectacles
Adjust the chair correctly
Take relaxation drill
Any Two
9.2
9.2.1. Digital camera is an input device that is capable to capture 2
image and save it into memory.
9.2.2. Advantages: 3
Capture and view photos immediately
Photos can be edited
Photos can be deleted
Pictures can be transfer to another computing devices
Any Three
9.3. Internet
9.3.1 Internet service Provider is a company that has a 2
permanent and fast connection to the internet
9.3.2 Computing device 3
Internet connection (Wired or wireless)
Modem/router
Any Two
9.3.3 Computer slow down dramatically 2
Files suddenly disappearing
Computer no longer boots up
Any Two
9.3.4 AVG, Avast, Bid Defender , Norton 3
Any Three
9.3.5 Password must be a combination of text, symbol and
numbers
Do not use your birthday as password
Your password must be at least 8 characters long
Any Two

7
 9.3.6 A website consists of web pages where as a web page is 2
a single electronic document in a web.
9.4. Email
9.5.1. Smith J. 1
9.5.2. Blind Carbon Copy is a field that is used to type the email 2
addresses of the other recipients of the message.
A copy of the message will still be sent to these people, but
their address will NOT be visible to other recipients in the
To fields
9.5.3. Netiquette is a name given to the use of good manners and 2
showing respect for other users when using internet
9.5.4. The user of capital letters 3
The use of slang: using pls instead of please
Incorrect spelling confim instead of confirm.
Informal Language i.e the use of a smile
Any Three

GRAND TOTAL: 120