Computer Application Technology Paper 2 (English)

Feb-March 2017 — Grade 12 / Matric — Computer Application Technology

Past Paper 2017 Grade 12 English

↓ Download PDF 📄 394.8 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 150 marks 📄 21 pages 📝 97 items found 📚 6 topics 🔑 1 key info

See full analysis

Questions — A Preview of What to Expect in the Document

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.

1.1.10\, choose the answer and make a cross (X\ over the letter (A D\ of your choice in the ANSWER BOOK. XAMPLE

1.1Which ONE of the following applications does NOT logically belong with the others ( in other words, the odd one out\? Mozilla Firefox Adobe Reader Google Chrome Microsoft Edge (1\

1.2Which ONE of the following is NOT a wireless Internet connection? LTE ADSL WiMAX (1\

1.3

1.4Which ONE of the following is NOT a security measure used with online banking? Password Pin code OTP ( one time password\ Fingerprint recognition

1.5Which ONE of the following functions will calculate the number of cells in the range A1:A13 that has a value of 5 or more? =COUNTIF(A1:A13, ''<5''\ =COUNTIF(A1:A13, ''>5''\ =COUNTIF(A1:A13, ''>=5''\ =COUNTIF(A1:A13, ''<>5''\

1.6Which ONE of the following is NOT an example of a multipurpose device/ computer? Webcam Phablet Netbook Tablet (1\

1.7

1.8Which ONE of the following is the most likely to cause compatibility problems or to have compatibility problems when upgrading to a new version of an operating system? Word processing files Firewall

1.9Which of the following will always be TRUE regard ing source software? (i\ (ii\ (iii\

1.10Which ONE of the following specifications is the most likely to indicate that a computer is a notebook? 1 TB HDD Touchpad Windows 10 Home (64 bit\ USB 3.0 (1\ [10]10

2.10\ in the ANSWER BOOK, for example 2.11 T.

2.10An accessibility option that allows a user to press key combinations such as Ctrl+Alt+Delete one key at a time A device that can be used to illustrate the concept of convergence A type of software that recognises

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 sta tement. NO mark will be awarded if only FALSE is written down.\

3.2Distributed computing refers to the process where money is raised via numerous small donations using the Internet. The COUNTA spreadsheet function counts how many cells in a given range contain numerical values.

3.4SATA is a type of interface that connect computers to monitors/ data projectors. The contrast ratio of a display device is the relationship between the width

3.5The correct spreadsheet function to determine the second fastest time run by a group of 100 metre sprinters is the SMALL function. (1\ [5] TOTAL SECTION5

4.1Many new cars and taxis have GPS systems and webcams fitted to the dashboards of the vehicle. Data, including the video, is often saved to an SSD.

4.1.2What is the main reason taxi drivers would use a GPS system? Give ONE reason why the GPS system should be updated regularly, besides removing bugs and improving the security of the software. (1\ (1\

4.1.4Give THREE reasons why a company would install and use a webcam AND a GPS in a bus or taxi to record the journey Why would the bus or taxi company install an SSD rather than an HDD (hard disk drive\ to save the video and data within the

4.2Explain why you can still use graphics on your computer even if you take out the graphics card you purchased (1\ Study the following specifications of a smartphone

4.3.3What is a possible disadvantage of the high MP value on the camera on this smartphone? Give ONE setting that can be changed to make the battery of the smartphone last longer. State TWO advantages of having a touch screen on a smartphone.

4.4State TWO potential disadvantages of file synching. (2\

4.5POS ( point of sale \ systems are used in most shops.

4.5.2What other input device can be used by the cashier if the barcode scanner is broken? Where will the price need to be corrected if it is noted that the price of a product that has been scanned on a POS system is incorrect?

5.5'' LED touch screen MP camera 4 GB on board storage Android 6.0.1

4.8What does a site licence allow a user to do? Why would a user open the Task Manager if his computer is 'running very slowly'? What does the term volatile mean when referring to RAM? (2\ (2\ (1\

4.10State TWO ways in which user authentication can take place on a smartphone. Give TWO reasons why e mail attachments are often not set to automatically download on mobile devices such as smartphones. (2\

4.11What is the easiest way to make more USB ports available on a computer? (1\ [25]25

5.2State TWO advantages of purchasing from an online shop, other than potentially lower prices. Explain the significance of the text 'mobi' in the URL 'www.vicbayfm.mobi'. (2\ (1\ Consider the following adv

5.3.1The advertisement indicates that the maximum speed is 'up to Mbps'. Give TWO possible reasons for an ADSL line not performing at its maximum speed. (2\

5.3.2What is the purpose of the router mentioned above? (1\

5.4Why do you think cloud storage is not used as much in South Africa other countries Give TWO reasons NOTE One

5.5State TWO ways in which a user can convey emotions in an IM ( instant messaging \. (2\

5.6Teachers at a local school post assignments on the intranet for learners to access.

5.6.2What type of application would be used to access the assignments on the intranet? Explain how learners could still access their assignments on the intranet using their home computers AND motivate your answer.

5.7What are FTP servers and services used for? (1\

5.8Which hardware or software technology is often used to control and monitor access between a network and the Internet? (1\ [15] ADSL up to 10 Mbps free e mail15

6.1art of form that was designed to capture data for a poll on the matric farewell is shown below. Matri

6.1.3Explain why the control(s\ used to get the user's response for the theme was a poor choice. Give ONE reason why the button control ('Final'\ on this form may be confusing to a user. Explain why a list box would have been a better choice to select

6.2The caching of web pages can mean that previously accessed web pages might be displayed in a web browser. Explain how this might affect the quality of information on the web page What can one do if one

6.3A teacher wishes to analyse the performance of the 27 le ers in h class according to the levels that they achieved in the exam ination, using the data below

6.3.1Give the name of the function cell that could have been used determine the number learners who

6.3.2The teacher wants to use a graph to analyse the performance of the learners Chart Chart The teacher knows the graph should look like Chart 1 on the left\, but

7.1Why would keylogger software not have any harmful effects if it is installed on a computer that is never networked or connected to the Internet? (1\

7.2Green computing is every user's concern.

7.2.2What is meant by the term green computing Give TWO reasons why unwanted or disused ICT devices should NOT be thrown into a rubbish bin. (1\ (2\

7.4State TWO potential ways in which telecommuting can be of benefit to an employer (a business owner\. Explain what phishing is AND why updating your antivirus program will not prevent you from becoming a victim of phishing.

7.5State TWO ethical considerations to keep in mind when connecting to someone else's Internet connection. (2\ [10] 1310

8.1The following error message appears when trying to insert an automatic table of contents in a word process ing document even though styles have been added to the headings: No table of contents entries found

8.4What is the best way to move a heading that appears in a column of text to the top of the next column in a word processing document? Name TWO word processing features that can be used to position text 'away

8.5Study the extract from a spreadsheet below and answer the questions that follow

8.5.1The employee code in column is created by combining the initials of the employee with a random number smaller than 30. Name any TWO spreadsheet functions that could possibly have been used to create the employee codes.

8.5.2Column E should show the number of years that an employee has worked at the company. The following formula was used in cell E2 , but it gives the wrong

8.6Reports allow one to summarise and present data in a database.

8.6.1Explain what the result of or answer the following function in the report footer of a database report represents: =Count([Pay]\ NOTE: Pay is a field in the database table that the report is

8.6.2What would the function =Now(\ in the page footer of a database report display? (1\

8.7In an HTML document the <b> tag was used to display the heading in bold. Give the most likely reason why the rest of the text below the heading also in bold. (1\

8.8What is the most likely reason for a picture not to display in a browser even if the correct HTML code was used? (1\ [15] TOTAL SECTION 1515

9.1The most important part of the expo setup will be to share Internet access provided by an ISP with all the devices that will be used in the venue using the Wi Fi facilities of the school

9.1.1State TWO advantages of using Wi Fi to connect the devices in this situation. (2\

9.1.2Some participants are too far away from the main venue to pick up the Wi Fi signal. Suggest ONE technology they could use to still have 'wireless' Internet a ccess without using Wi (1\

9.1.5Name TWO hardware components that might be needed to increase or expand the Wi Fi coverage to all the locations used for the expo. Name TWO services an ISP can provide

9.1.6People anywhere in the world can follow the expo by watching a live stream on a website. State TWO potential disadvantages of using live streaming. (2\

9.2The organisers have been offered free use of online applications for the duration of the expo. Explain TWO advantages of online applications compared to applications installed on the computers. (2\

9.3The school has implemented a BYOD policy to allow participants to bring their own devices to access the network. Outline ONE of the most likely technical problems that the school may encounter when the participants connect their devices.

9.4Participants and guests will vote for the projects at the expo. The IT department has found an Android app to manage the voting This can be downloaded from the school's network server to cellphones and

9.4.2What is the general role of a server in any network? State TWO advantages for the guests of downloading the app from the school 's network server as opposed to having to download the app from the app store.

9.4.3Many guests are concerned that the app may be a potential Trojan What is a Trojan AND how is it typically installed? (2\

9.5The organisers of the expo will use a computer to receive the votes from all the devices and to collect and process all data the expo. Study the following specifications for the computer which will be used for

9.5.1How much permanent storage is available on the computer? (1\

9.5.2The Windows 10 operating system was not installed on the 1 TB HDD. On which device in the list above was the operating system loaded? (1\

9.5.3Which component must be added to the list of specifications to enable the computer to connect to the school's network without using Wi (1\

9.5.4What change in specifications in the list above will have the biggest effect in terms of improving the overall performance of the computer? (1\ Intel i5 3.1 GHz GB RAM GB SSD

9.6The following statement was made by one of the participants at the expo: 'Windows 10 has no option to turn off automatic system updates.'

9.6.2Give TWO reasons for a software developer to release updates. Why would a software developer NOT give a user the choice to disable automatic updates? (2\ (1\

9.6.3State ONE potential disadvantage of not being able to disable automatic updates. (1\ [26] 1826

10.1State ONE potential disadvantage of using WhatsApp to promote the expo. (1\

10.2One of the participants in the expo has done a study o information overload.

10.2.2What is information overload State TWO ways in which information overload can be reduced. (1\ (2\

10.3Each participant in the expo needs to pay a registration fee a week before the expo starts

10.3.2Suggest TWO technologies that participants can use to pay the registration fee if they cannot get to the school or bank during office hours. How could the organisers of the expo confirm that the registration

10.4An entry form for the expo is shown below Surname: Initials: Cell N Expo Type: XP1

10.4.2Explain why using a table format for the user to enter the cell phone number is a good idea. Suggest TWO ways in which to improve the layout of the form.

10.5All the data on the administration computer must be kept strictly confidential. State TWO ways in which the organisers can be sure that the data on this computer cannot be stolen or accessed illegally,

10.6A database table was created to store the votes received. The table definition is shown below. Field Name Data Type Description Name Text Name of the person voting

10.6.1Why is the DOB field not suitable to act as a primary key? (1\

10.6.2Each project will receive a unique code which voters will use to vote in the Favourite Project field, e.g. Sci312. Which database feature can be used to ensure that a user will have to enter three letters followed by three digits?

10.6.4Which database feature can be used to ensure that the Name and Surname fields are NOT left blank? Which database feature can be used to ensure that typing errors

10.7A participant asked the organiser to make a printout of a document which he brought in on his flash drive. When trying to open the file with the 'Open With' option the following dialog box appeared:

10.7.1Explain why or when one would generally try to use the 'Open With' option to open a file. (1\

10.7.2One of the options provided is the Adobe Acrobat Reader which reads PDF files. Give TWO reasons for using the PDF file format. (2\

10.7.3Why would one tick the check box towards the bottom left hand corner of the dialog box? (1\ 21

10.8The following spreadsheet was created to keep track of paid registration fees The following function was used in cell and then copied down to the rest of the cells in column F =IF(D2="Yes",0,C2*B9\ The function should multiply the number of stands in

10.8.1Why is it better to use the cell reference in the function instead of just the value of 250? (1\

10.8.2The function returns the correct answer in cell Explain why the function is not calculating the correct amounts for some cells in column F AND rewrite the function so that it would copy down correctly.

10.8.3Explain if it would be possible to create a meaningful graph from the data in the range B2:B7 (1\ [24] TOTAL SECTION AND24

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Sections10 + 5 + 25 + 15 + 10 + 10 + 15 + 26 + 24 = 140 marks

Key Information

Websitewww.vicbayfm.mobi

Paper information

SubjectComputer Application Technology

Year2017

SessionFeb-March

TypePast Paper

PaperPaper 2

LanguageEnglish

Pages21

Downloads6

Examination context

Decade2010s

Years ago9y

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 size394.8 KB

Pages21

Archived on7 September 2026

File age46d

ContributorFreeMode

FingerprintEB0E5135C441

Questions and learner discussion

No questions or discussions have been posted yet.