Computer Application Technology Paper 2 (English)

November 2020 — Grade 12 / Matric — Computer Application Technology

Past Paper 2020 Grade 12 English

↓ Download PDF 📄 495.5 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 150 marks ⏱️ 3h 📄 6 pages 📝 104 items found 📚 7 topics

See full analysis

Questions — A Preview of What to Expect in the Document

104

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.4possible reason why a program will not install

Q2— Section header —

2.10\in the ANSWER BOOK, e.g.

2.11COLUMN A COLUMN

2.10A field property that automatically inserts a value in a field for each new record in a database table Malware that is often associated with Bitcoin A technology that is used to produce an editable soft copy from a scanned

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. ( Do NOT simply use the word 'NOT' to change the statement.\mark will be awarded if only FALSE is written.

3.1Grid computing is a system where resources of many computers in different locations are used at the same time to complete a single task (1\

3.2site licen e allows a company to install only one copy of the software (1\

3.3An attachment is a file that can be sent together with an mail message

3.4The AVERAGE function will give the average of a set of values in a database (1\

3.5Information overload is the process of replacing analogue technolog ies used for

15.6" screen (1920 x 1080\ 128 GB SSD 3 x USB ports VGA port Webcam with microphone 802.11 b/g/n SD card eader

Q4— Section header —

4.1Study the notebook computer (laptop\ specifications in the advert isement below and answer the questions that follow

4.1.1Which broad software category does Office 365 belong to (1\

4.1.2Give TWO possible reasons why screen resolution is indicated in addition to screen size in the specifications above

4.1.3Give TWO reasons why newer model s of notebook computer do not

4.1.4Give ONE possible reason why an SSD s specified for this computer

4.1.5Give TWO features of USB port that ma

4.1.6Discuss why you would not expect to find a VGA port included in the specifications of this notebook computer AND state which other port you would rather expect

4.1.7Name TWO specifications in the advertisement that would make it possible to set up biometric security on this notebook computer. (2\

4.1.8Name an essential specification affecting performance that is NOT listed in this advert isement

4.2State TWO benefits of using online banking as opposed to physically visiting a bank (2\

4.3Suggest ONE way in which to ensure that documents created in new software versions are compatible with older software versions. (1\ Comp

4.4Give TWO reasons why you may decide to buy a desktop computer rather than a notebook computer. (2\

4.5Give TWO reasons why a computer may prompt a user to start up the operating system, e.g. Windows in safe mode. (2\

4.6printer does not print the document sent to it even though it is working switched on and properly

4.7Name the utility program that rearranges parts of files scattered all over the hard drive, so that they are stored next to each other. (1

4.8Give TWO reasons for using the Task S cheduler utility (2 [25] Comp uter Applications Technology/P225

Q5— Section header —

5.1What is the main purpose of an ISP? (1

5.2State TWO function of a router as used in a home network (2

5.3State TWO advantages of a fibre connection over a wired ADSL connection

5.4Why would a user prefer to have an unshaped connection instead of shaped connection to the internet? (1

5.5State TWO advantages of using a browser based online application for editing documents rather than a stand

5.6State TWO disadvantages of using browser plug ins and extension s. (2

5.7Why would you get 'Page Not Found' or 'Not Found' error message while

5.8Many p ublic places often offer free internet access.

5.8.1What is this type of connection called? (1\

5.8.2State ONE problem with this kind of free internet connection , other than security risks. (1\

5.9What is the main function of a firewall? (1

5.10How would an employee securely access his/her company network from a remote location? (1\ [15] Comp uter Applications Technology/P2 1015

6.1Give TWO reasons why a task definition is necessary when planning the research for your practical assessment task (PAT\ (2

6.2Explain how you can avoid getting many different or unrelated results from web browser when you are searching for a particular topic on the internet. (1

6.3When setting a questionnaire, it is important to consider the expected format of the answers to closed questions as this would assist you in processing and analysing the data

6.3.1 Give TWO types/formats of answers that would return values that could be exported to a .csv file

6.3.2 How could this data be presented visually in a spreadsheet? (1

6.4Explain why it is important that researchers do NOT include biased sources in their research or reports. (2\

6.5Give TWO ways in which database queries are helpful when analysing data (2\ [10] QUESTION10

7.1Describe a situation that would qualify as online harassment. (1\

7.2Suggest TWO ways in which computer users can prevent RSI to their hands and wrists

7.3State TWO ways in which to avoid becoming a victim of mail phishing.

7.4Driverless cars Self driving cars may become more common in the future

7.5State ONE disadvantage of crowd funding for a person who invests in a new business

7.6State TWO disadvantages of using free cloud storage services (2\ [10]10

Q8— Section header —

8.1You typed the word 'text' but appeared. How do you ensure that the word 'text' is displayed instead of the symbols (1\

8.2Name ONE setting that can be adjusted by using the ruler of a word processor. (1

8.3What must you do before you can insert a n automated citation in a word processing document? (1\

8.4Data appears in cells A1: W100 in a spreadsheet Which spreadsheet option would you use to print only

8.5You wish to paste a graph from a spreadsheet into a word processing document. Which Paste Special option would you use to enable the graph in the word processing document to update when the data in the spreadsheet changes

8.6Why do the letters C and D not appear in the spreadsheet as shown in the screenshot below? (1\

8.7Explain the concept of a circular reference in a sprea sheet (1\

8.8The LOOKUP function used in ell C5 attempts to display the mark for specific learners from the lookup table

8.9Microsoft Access allows you to insert a text box when you design a database form. Give TWO reasons for using a text box in a database form.

8.10The following message appeared when you ran a database query: Give TWO reasons why the database requires you to enter a parameter value.

8.11While view ing a web page in the browser, you decide that you would like to examine the HTML code. What would you do to display the HTML code of that web page? (1\

8.12Give TWO tips or hints that will help you to prevent errors or that will assist you with troub leshooting when coding in HTML.

Q9— Section header —

9.1You will require notebook computer and a data projector to show the movies in the school hall.

9.1.1Name TWO features, ot her than the resolution , that you will consider when buying a data projector. (2\

9.1.2Explain why it will NOT be necessary for the notebook computer to have a dedicated raphics card for showing movies

9.2Give ONE reason why you do NOT have to use a mouse with

9.3Instead of downloading all the movies you want to show during the movie night, one of your friends suggested streaming the movies from services like Netflix or YouTube.

9.3.1Name the type of software needed to play movies. (1\

9.3.2Explain how bandwidth influences the streaming of movies. (2\

9.3.3Discus s TWO limitations of using a 4G cellular connection to stream movie. (2\

9.4Identify TWO risks that your notebook computer could be exposed to by being connected to the internet AND suggest a way to prevent harm from EACH

9.5After the movie night , the principal requires you to create a report with main and subheadings

9.5.1What steps must you take before an automatic Table of C ontents can be added to a word processing document (2\

9.5.2The report will be published on a web page. Name TWO possible locations that hyperlinks in the report can point to.

9.5.3You will use the mail merge feature of the word processor to send the report to other teachers.

9.6To evaluate the success of the movie night, the organisers require the parents to fill in an electronic form that will be published on the school's blog.

9.6.1Give TWO benefits for the organisers of publishing the online form on the school's blog. (2\

9.6.2Name TWO web based spreadsheet programs as opposed to default spreadsheet program installed on the notebook computer.

9.6.3The data from the electronic form was exported to a spreadsheet. The organisers wish to determine how many parents gave a rating of more than 7 for all three criteria , i.e. Movie rating, Venue rating and

10.1A link to the invitation will be sent to each former learner. The responses will be captured in a database.

10.1.1The GPS coordinates of the venue are included on the invitation. Explain the concept GPS . (Do NOT merely write the acronym in words .\

10.1.2Which e mail feature can be used to send the link to all the former learners simultaneously? (1\

10.1.3Which type of application can be used to solve the problem of a link address that is very long? (1\

10.1.4Name the database object that could be used to give a printed summary of the number of men and women expected. (1\

10.1.5Give TWO security measures to ensure confidentiality of the data of the guests listed in the database. (2\

10.2Former learners can be located on social media and a social media page will be used to share information regarding the reunion.

10.2.1Give TWO reasons why people do NOT want to have social media accounts. (2\

10.2.2State TWO guidelines that could be included in a school policy on the use of social media. (2\

10.2.3Discuss TWO ways in which to locate former learners using social media. (2\

10.3A dinner followed by a dance will be held for the former learners.

10.3.1Name TWO technologies that can be used to identify and allow the guests to enter the dance, other than biometric technology. (2\

10.3.2The guests will be able to choose food from a menu app that is installed on a tablet. Give TWO reasons why managing the meal choices from a menu app

10.5There will be a presentation on the use of the Internet of Things (IoT\ at the school. Explain the concept Internet of Things (IoT\ (2\

10.6The guests will take photographs with their smartphones. 10. .1 Photographs

10.6.3 The PowerPoint presentation will be uploaded to the cloud. How can this presentation be made available to former learners who do not have access to the internet? (1\ [25] TOTAL25

Topics Identified

Word ProcessingSpreadsheetsDatabasesPresentationsProgrammingNetworkingHardware

Mark Allocation

Total150 marks

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

Paper information

SubjectComputer Application Technology

Year2020

SessionNovember

TypePast Paper

PaperPaper 2

LanguageEnglish

Pages16

Downloads7

Examination context

Decade2020s

Years ago6y

SeasonSpring (SH)

Start dayThursday

Exam periodNovember 2020

Days since exam2,180

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 size495.5 KB

Pages16

Archived on7 September 2026

File age48d

ContributorFreeMode

FingerprintAE0CC10B7E03

Questions and learner discussion

No questions or discussions have been posted yet.