Computer Application Technology Paper 2 (English)

May-June 2018 — Grade 12 / Matric — Computer Application Technology

Past Paper 2018 Grade 12 English

↓ Download PDF 📄 379.8 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 150 marks ⏱️ 3h 📄 16 pages 📝 111 items found 📚 6 topics

See full analysis

Questions — A Preview of What to Expect in the Document

111

This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.

Q1— Section header —

1.1\ in he ANSWER BOOK, for example 1. 11 D. HDD is used in a phablet. desktop computer mobile phone ablet (1\

1.2A spreadsheet error where the function is spelt incorrectly is called a value error (#VALUE!\ reference error (#REF!\ division by zero error

1.3Which ONE of the following terms does NOT logically belong with the other terms? Spyware Shareware Worm Trojan (1\

1.4The relational operator <> is used to ... a value exclude include decrease increase (1\

1.5A wireless keyboard can NOT be connected to a computer using a/an ... infrared adapter. Bluetooth adapter. 3G adapter. Fi adapter. (1\ Message rules in e

1.8

1.9The letters a/b/g/n refer to data transmission over a/an ... connection. ADSL Fibre (1\

1.10What would the result if the formula =ROUNDDOWN(B2 A2,0\ was used in cell C2 below?

14.5(1\ [10] SC10

Q2— Section header —

2.10\ in the ANSWER BOOK, for example 2.11 U. COLUMN A COLUMN B

2.10An aspect of web design that refers to moving between pages in a website A legal agreement between a software author and a user An optical storage medium with a capacity larger than that of a DVD An audio output device

Q3— Section header —

3.5\ in the ANSWER BOOK. Correct the statement if it is FALSE. Change the underlined word(s\ to make the statement TRUE. ( NOT simply use the word NOT to change the statement. NO mark will be awarded if only FALSE is w

3.1Patches are unintended flaws in software. (1\

3.2OCR enables a user to unlock a protected smartphone without having to type in a password. (1\

3.3=VLOOKUP(E10,A1:B10,2,FALSE\ The FALSE parameter will cause the VLOOKUP function above to return exact match (1\

3.4A computer that has been taken over by a hacker is called a pirate (1\

3.5Cell formatting will display the result as rounded number AFTER changing the value. (1\ [5]5

Q4— Section header —

4.1Name ONE computer application that can be used to edit text files.

4.2Give TWO GUI elements on an electronic form that can be used to present list of options to a user.

4.3Suggest TWO methods that could be used to repair a flash drive that has been infected with a virus.

4.4Assume that you have downloaded software from the internet but you cannot run it because there is not enough space on the hard drive. Suggest TWO ways in which you can run the software.

4.5Why would one have to use the System Restore utility? (2\

4.6Give TWO advantages of using an interactive whiteboard.

4.7A folder contains documents that were created over a number of years. State TWO ways in which to display ONLY the documents that were created LAST WEEK

4.8State TWO ways in which to improve the following password: Y5Y5Y

4.9Explain TWO ways in which RAM differs from SSD storage. (2\

4.10Briefly explain the function of a client and a server in a network. (2\

4.11The vertical and horizontal scrolling feature of a touchpad has stopped working. Suggest a reason why this could have happened. NOTE: Assume that the hardware is working properly. (1\

4.12State TWO advantages of 3D printing. (2\

4.13Explain the concept of VR ( virtual reality (2\

Q5— Section header —

5.1Voice calling is used in many IM apps. What network communications protocol makes this feature possible? (1\

5.2NFC is a communication medium available on many mobile devices.

5.2.1How would one transfer files using NFC between two devices that have the NFC setting switched on? (1\

5.2.2State TWO uses of NFC. (2\

5.3Give TWO possible reasons why mail delivered to some recipients on a distribution list. (2\

5.4With reference to online shopping, what is the purpose of a shopping cart? (2\

5.5A smartphone can be used as a Wi Fi hotspot. State TWO disadvantages of using a smartphone as a Wi Fi hotspot. (2\

5.6How can you make your own website a vailable to the public on the internet (1\

5.7Fi hotspots are used by shops and businesses to attract customers. Give TWO reasons why a shop would ask customers to log on using a password. (2\

5.8Give TWO reasons why it is necessary to limit the access rights of users on a LAN. (2\ [15]15

Q6— Section header —

6.1Give TWO tips for setting high quality question to be used in a survey. (2\

6.2How would one transfer data collected electronic ally to another application without re typing the data? (2\

6.3Assume that you have one spreadsheet that uses data from another spreadsheet. Give ONE reason why it would be better to insert a cell reference instead of using the copy paste method to return the required data.

6.4Study t he graph below and answer the questions that follow

6.4.1How many categories (series of data\ are shown in this graph/chart? (1\

6.4.2Explain the problem that exists in the Marketing department according to the graph/chart. (1\

6.4.3Which department underspent by the largest percentage on their allocated budget? (1\

6.4.4Suggest THREE improvements that could be made to this graph/chart to make it easier to interpret. (3\ 10

Q7— Section header —

7.1State TWO uses of AR ( augmented reality (2\

7.2Give TWO examples of how social engineering is done. (2\

7.3Discuss TWO benefits of using Bitcoin. (2\

7.4virtual private network (VPN\ allows a user to remain anonymous while on the internet Give TWO reasons why some governments are blocking VPN access for their citizens. (2\

7.5Give TWO tips for the responsible use of social media in order to prevent offending other people. (2\ [10] 1110

Q8— Section header —

8.1What does the key symbol to the left of the database field show in the screenshot below? (1\

8.2After the Show/Hide feature was activated, the following is displayed in a word processing document:

8.2.1How did the user try to align the numbers in the screenshot above? (1\

8.2.2Give TWO other word processing features that can be used to align the data above. (2\

8.3Explain the purpose of a hyperlink in a document or web page. (1\

8.4The numbers in the spreadsheet below need to be arranged from the smallest to the largest. Describe how this can be done without re typing each number. (2\

8.5Consider the screenshot below. Name the combination of spreadsheet functions that were used in the cells in column B to extract the first word from the data in the cells in column A. NOTE: The formula in cell B1 was copied down to the rest of the cells

8.6Draw the table rep resented by the HTML code below. <table border=10> <tr> <td> A </td> <td> B </td> </tr> <tr> <td colspan=2> C </td>

Q9— Section header —

9.1The traffic officers have to record traffic offences at the roadside and communicate them to the traffic department.

9.1.1What communications technology is most likely to be used to connect to the internet in this case? Motivate your answer. (2\

9.1.2Barcodes are used on car licence disks. State TWO advantages of scanning barcodes as opposed to manually writing information down. (2\

9.1.3Suggest a device that can be used to scan barcodes ther than barcode scanners (1\

9.1.4Give the term used to describe data that can be collected from offenders to uniquely identify them based on their physical features. (1\

9.2The traffic officers would like to prevent traffic offenders from sharing information about speed traps and road blocks on social media

9.2.1State TWO ways in which traffic offenders can determine and share the location of a mobile speed camera after passing it. (2\

9.2.2State TWO ways in which people try to hide social media posts from the authorities. (2\

9.2.3While driving our friend uses his smartphone to photograph people committing traffic offences with the aim of assist

9.3The traffic department wants to implement an electronic filing system to establish a paperless office. There will be no need for a dedicated flatbed scanner to scan documents.

9.3.1Explain the term dedicated device (1\

9.3.2Why is it possible to use certain printers for scanning? (1\

9.3.3State TWO benefits of a paperless office. (2\

9.3.4Suggest TWO ways in which the traffic department can make off site backups of their data. (2\

9.3.5The information from the documents will be captured in a database. State TWO advantages of storing data in a database. (2\

9.4The traffic department would like to send letters to remind traffic offenders to pay their traffic fines.

9.4.1What word processing feature can be used to create multiple personalised letters to all traffic offenders? (1\

9.4.2State TWO ways to send electronic payment reminders using ICTs, other than using social media. (2\

9.5Special cameras are used to monitor all traffic.

9.5.1Name TWO types of internal storage media that can be used in the camera to store pictures and videos. (2\

9.5.2Which camera setting affects the quality of the pictures and videos? (1\ [25] 1525

Q10— Section header —

10.1You want to promote the employment centre using a YouTube video.

10.1.1Why is it not a good idea for a user to repeatedly stream a YouTube video? (1\

10.1.2How could a user watch the video without streaming it? (1\

10.1.3People who upload videos to YouTube always track the number of views of the video Give TWO reasons why one would track the number of views, other than finding out whether the video is popular or not. (2\

10.1.4YouTube has different video resolution options to select from. Give TWO reasons for using a low resolution option when watching videos on YouTube. (2\

10.1.5Which device would enable you to take a smartphone video of yourself without holding the smartphone in your hand? (1\

10.1.6A computer used to edit videos has 16 GB RAM which is the maximum amount of RAM that this computer can have. The computer is extremely slow. Give TWO reasons with regard to hardware why this could happen.

10.2The employment centre wishes to invite companies to advertise vacancies on their website.

10.2.1Give TWO e mail netiquette guidelines when communicating with these companies. (2\

10.2.2Give TWO reasons why some jobseekers cannot view certain content on the employment website. (2\

10.2.3How can jobseekers get regular updates about vacancies without having to visit the website? (1\

10.2.4State TWO ways in which the employment centre can stop unwanted advertisements from appearing while browsing. (2\

10.2.5Suggest TWO ways in which jobseekers can refer to vacancies at a later stage without having to go online again. (2\

10.2.6When viewing a website on a small screen, even maximising the browser window does not allow a user to see the full web page. Suggest TWO ways in which this problem could address (2\

10.3An image such as the one below will be generated for every vacancy on the website

10.3.1What is this image called? (1\

10.3.2State the function of this image. (1\

10.3.3You have used your smartphone to download a brochure with th type of image. State how you could wirelessly connect your smartphone to a printer in order to print the brochure. (1\

10.425

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Sections10 + 10 + 5 + 15 + 10 + 15 + 25 + 25 = 115 marks

Paper information

SubjectComputer Application Technology

Year2018

SessionMay-June

TypePast Paper

PaperPaper 2

LanguageEnglish

Pages16

Downloads6

Examination context

Decade2010s

Years ago8y

Season—

Start day—

Exam period—

Days since exam—

About Computer Application Technology examination preparation

This Grade 12 examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.

How to use this resource for revision

A past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?

For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.

understanding question requirements

applying subject knowledge

working under time constraints

checking answers

identifying revision priorities

A practical revision approach

Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.

Grade 12 subject hubs

Each matric subject has its own dedicated hub on Freemode with every past paper and marking memorandum we have archived for that subject.

➗ Mathematics View papers → 📊 Mathematical Literacy View papers → ⚗️ Physical Sciences View papers → 🧬 Life Sciences View papers → 📒 Accounting View papers → 💼 Business Studies View papers → 📈 Economics View papers → 🌍 Geography View papers → 🏛️ History View papers → 📖 English View papers → 🇿🇦 Afrikaans View papers → 🗣️ IsiNdebele View papers → 🗣️ IsiXhosa View papers → 🗣️ IsiZulu View papers → 🗣️ Sepedi View papers → 🗣️ Sesotho View papers → 🗣️ Setswana View papers → 🌾 Agricultural Sciences View papers →

Corresponding marking memorandum

Marking memorandum available

Use the corresponding memorandum after completing the paper to review your answers and identify areas that require further revision. The memorandum shows the marking approach used by DBE examiners, including method-mark allocations.

Computer Application Technology Memo 2 (English) →

File details

File size379.8 KB

Pages16

Archived on7 September 2026

File age48d

ContributorFreeMode

FingerprintE946E805473B

Questions and learner discussion

No questions or discussions have been posted yet.