Computer Application Technology Memo 1 (English)

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

Memo 2021 Grade 12 English

↓ Download PDF 📄 656.4 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 180 marks 📄 15 pages 📝 49 items found 📚 5 topics

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.

Q1— Section header —

1.1.1ordArt Any WordArt pplied Text Box containing text

1.1.2Wrap Text Wrapping of WordArt/ ext Box that places text in front of the image/Image wrapping set to behind text Heading stretches across the top of image

1.2Footnote/Endnote Endnote changed to footnote

1.3Indent 'First line indent' applied Set at 2 cm on the ruler (Accept by 1 cm in the Special Indentation of the dialog box\

1.4Style (Mark in the dialog box\ New style created (Display OR Style1\ New style named 'Display' Character spacing set to

1.5Find and Replace: 'care' Replace ('care' not found in the document\ A symbol or appears in the place of the word 'care' Correct symbol displays 'Find Whole words only' selected

1.7Columns (Mark in dialog box\ Text appears in two columns Vertical line between columns Column Break inserted before 'MEDICAL

1.8Last page Clipboard image flipped horizontally (Tick appears correctly\ Right aligned tab inserted At 13 cm otted

Q1— Section header —

Q3— Section header —

3.1Cell C2: Border changed to thick er border Border line is red

3.2Cell P9: =AVERAGE(C5:C75\ OR =C76/COUNTA(C5:C75\ OR =SUM(C5:C75\NTA(C5:C75\ Average determined in cell P9 Cell range:

3.3Cell P11: =COUNT(C20:L20\ OR =COUNTA(C20:L20\ Function: COUNT func ion in cell

3.4Cell P13: heck for building blocks\ =COUNTIFS(B5:B75,">=1980", B5:B75 ,"<=1989"\ OR =COUNTIF(B5:B75,"> =1980"\

3.5Cells M5:M75 : Data Validation Validation a pplied to cell range: M5:M75 Validation criteria

3.6Cell P15: =H32/H76 OR H32/SUM(H5:H75\ Treatments in India H3

3.7Cell 17 Computer Applications Technology/P1

Q3— Section header —

Q4— Section header —

4.1Cell F3: =MODE(D :D10 MODE function in cell F3 Cell range: D

4.2Cell F4: heck for building blocks\ =SUMIF( D8:D107 ,MAX( D8:D107

4.4Cell H8 Check for building blocks\ =IF(C8="Monthly",IF(G8<$H$4,"Expired","Remind"\,"#"\ OR =IF(C8="Monthly", IF

4.5Cell C3 (Check for building blocks\ =RIGHT(A3,LEN(A3\ 2\LEFT(A3,2\ OR =MID(A3,3,LEN(A3\&LEFT(A3,2\ OR =MID(A3,3,LEN(A3\

Q4— Section header —

Q5— Section header —

5.1.1Field Region New field RegionId

5.1.2Field: RegionCode Field size: 6 Input Mask: >LL0 99 LL

5.1Field: StaffAvailable Default value set to 10 Form: frm5_2

5.2Label with examination number added to Form He ader Label's Visible

5.3ReturnVolunteer criteria "Yes" NumberofWeeks criteria : >= 20 Surname

5.4Fields displayed: Name, Surname, CountryToVolunteer and MedicalService (Ignore order of fields.\ MedicalService Criteria

5.5Total feature activated NumberofWeeks function inserted: SUM Sorted on MedicalService Criteria in StartingDate

5.6Image 5Rescue inserted and 'Size Mode' property set to 'Stretch' Resized to 2 cm wide by 1.6 cm high Grouping applied to ReturnVolunteer field Function inserted in the footer

Q5— Section header —

Q6— Section header —

6.1.1 Background colour body bgcolor ="linen" Background colour is changed to

6.1.2Font colour : text 'Ebola' <font color="red"> Ebola </ font Red font colour applied

6.1.3Hyperlink to a target location <h3> <a href="#Data2020"> 2020 Status </a> </h3> Hyperlink inserted: <a href></a> On text '2020 Status'

6.1.4Table row and data <tr align="center"> <td colspan="2"> 2020 Status Pending! </td> </tr> Table row /cell centred <

6.2Web page duplication <h1 align="center"> WASH PROJECT IN SIERRA LEONE /h1> OR <h1><center>

Q6— Section header —

Q7— Section header —

7.1.1Mail Merge Link to 7Prospects spreadsheet Filter applied: Prestige_ Aansien = Yes AND Amount_Bedrag >=800

7.1.2Merge Document Mail merge completed erged to

7.2Subtotal Total appears at each change:Category_ Kategorie ward this mark only

7.3.1 Cell =VLOOKUP( 4, Order !$

7.3.2Cell C5 =IF(Stock!D5 Stock!C5>0,Stock!D5 Stock!C5&" "&Stock!B5," "\

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworking

Mark Allocation

Total180 marks

Sections30 = 30 marks

Paper information

SubjectComputer Application Technology

Year2021

SessionMay-June

TypeMemo

PaperPaper 1

LanguageEnglish

Pages15

Downloads4

Examination context

Decade2020s

Years ago5y

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 examination paper

Examination paper available

Open the corresponding examination paper to practise the questions before reviewing the marking memorandum on this page. Attempt every question under timed conditions for the most realistic preparation.

Computer Application Technology Paper 1 (English) →

File details

File size656.4 KB

Pages15

Archived on7 September 2026

File age48d

ContributorFreeMode

FingerprintC9C4D966E2CF

Questions and learner discussion

No questions or discussions have been posted yet.