Computer Application Technology Memo 1 (English)

November 2020 — Grade 12 / Matric — Computer Application Technology

Memo 2020 Grade 12 English

↓ Download PDF 📄 618.9 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 180 marks 📄 5 pages 📝 72 items found 📚 6 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.1Picture Picture width changed to 21 cm Picture positioned over top edge and across width of page All e mpty paragraphs below picture removed

1.2Heading Strikethrough removed from whole heading Character spacing expanded by

1.5pt Heading horizontally centred

1.3Source Website source added Author Nina Sen added Accept

1.4Find and replace Nonbreaking spaces replaced with a single normal space (some replacements\ All 14

1.5Indent First line indent Left or hanging ndent s et at 2 cm Right indent set at exactly 14 cm on ruler

1.92cm in dialog box\

1.6Line and Paragraph spacing Paragraph spacing after changed to 8 pt Line spacing set to Multiple At 1.

1.7Paragraph settings : 'Insert here' Page break before selected on text Insert here

1.8File inserted as icon File 1Structure inserted (Alt + F9\ As icon Icon named as 1Structure

1.9Caption Picture cropped to remove only text below

1.10Watermark Text watermark inserted Text Ancient Watermark displays only on first page

Q1— Section header —

Q2— Section header —

2.1Cover page Exam number inserted in Author form control Abstract form control removed

2.2Page border Page border removed from document

2.3Table of C ontents {TOC t"Heading

2.4Page numbering Any utomatic page number ing inserted Page numbers inserted anywhere

2.5Table to text Table converted to text with tabs at 4 cm Hanging indent set to tab position Text alignment set to justify (No mark if table\ Any solid

2.6Citation Citation displays only author (Year suppressed Ignore if Title NOT

2.7Picture Picture background removed Text wrapping set to Tight Through

2.8Cross reference Cross reference to ForEver' bookmark inserted (Alt + F9 , {PAGEREF ForEver

Q2— Section header —

Q3— Section header —

3.1ow 1 Cells A1: 1 merged and centred Font size increased to 1 (All text\

3.2Cell C3 MONTH(A3 MONTH function (A3\ Cell format changed to

3.3Cell C4: =AVERAGE(H8:H19\ AVERAGE function (Ignore if divided by 5\ Range: H8:H19 Cell formatted to show

3.4Cell C5 =SUMIF(B8:B19, eak ,G8:G19

3.5Cell (Check for building blocks\ =IF(SUM(C8:G8\H8,"Correct","Error"\ OR =IF( H8=

3.6Conditional formatting (Check for building blocks\ Conditional formatting applied to range C8: 19 To check for below average Below average

3.7Chart type for 2015 data changed to column Legend series 'Year' changed to '2018' Legend appears to the right of the chart 1000 separator applied to vertical axis Check Axis

Q3— Section header —

Q4— Section header —

4.1Page layout Page orientation set to landscape Row 2 set to repeat at top of each page

4.2Cell D3 (Check for building blocks\ =RIGHT(C3,LEN(C3\ FIND("@",C3\ OR =RIGHT(C3,LEN(C3\

4.3Cell F4: =VLOOKUP(E4,Code_Kode!$A$2:$C $43 ,3\ OR =VLOOKUP(E4,Code_Kode!$A$1:$C$43 ,3\ OR =XLOOKUP(E4,Code_Kode!$A$2:$A$43,Code_Kode!$

4.4Cell H5 (Check for building blocks\ =ROUNDDOWN(((TODAY(\ G5\5.25\ OR =ROUNDDOWN(DAYS360(G5,TODAY(\/36 ,0\

4.5Cell 14 (Check for building blocks\ =IF(H 14 <60,IF( F14

Q4— Section header —

Q5— Section header —

5.1.1Field: TSurname Allow for duplicates (Yes (Duplicates OK\

5.1.2Field: TBirthDate Date displays in Short Date format

5.1.3Field: TAge Decimal places set to 0

5.1.4Field: EContact Validation rule: Like *@*

5.1.5Field: TType Field size changed to 4

5.1.6Input Mask : <.LL? OR .<LL (Accept in combination with /,

5.1Field: Pyramid Code Text align is set to 'Center'

5.1Field: PyramidSite Combo box created Row source: tblSites (14 options in combo box

5.1Field: TPhoto Any picture inserted for 'Peter Andrews' 5Andrews picture inserted Accept linked icon

5.2ields are in order Surname, Name, EContact and TPhoto

5.3Total row switched on Pyramid : COUNT Site criteria: "Giza"

5.4Surname field moved to before Name field Criteria in BirthDate field: < #1960/01/01# OR <=#1959/12/31#

0.85Calculated field name: Payable Correct field VisitorsCost

5.5Report saved as rpt5_5 based on tblVisitors Pyramid Name Surname

Q5— Section header —

Q6— Section header —

6.1.1Centre <center> <h1><font face="Papyrus">PYRAMIDS</font></h1> complex mortuary temple. </p> </center> Center

6.1.2Heading <h1><font face= Papyrus PYRAMIDS </font></h1>

6.1.3Image <img src 6Group.jpg Image tags inserted Image 6

6.1.4Hyperlink <a href www.crystal .com

6.2<font size= ><b>TOP 3 Egyptian Pyramid Facts</b></font> <hr/> <table

Q6— Section header —

Q7— Section header —

7.1.1Transpose Correct data appears in Data worksheet Column A is right aligned

7.1.2Chart nly the data series 2017 to 2019 is displayed Data labels added Vertical a xis major units changed to 0.2

7.1.3Chart saved as image (7Chart.jpg\ Chart saved as a file Saved as 7Chart.jpg Visitors worksheet

7.1.4Cell J3: =COUNTIF(AmountSpent,">14000"\ COUNTIF function Named Range: AmountSpent OR cell F2:F194\ Criteria:

7.1.5Data alidation : Column E In Validation List Option 'ord' changed to 'org' OR

7.2.1Mail Merge (14 records expected\ 7Invitation linked to data source 7Mail Data source: DomainType criteria edu Data source:

7.2.2Merged Document Merged docu ment saved as 7Invitation Merge

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections29 + 21 + 27 + 23 + 40 + 20 + 20 = 180 marks

Paper information

SubjectComputer Application Technology

Year2020

SessionNovember

TypeMemo

PaperPaper 1

LanguageEnglish

Pages15

Downloads9

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 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 size618.9 KB

Pages15

Archived on7 September 2026

File age47d

ContributorFreeMode

Fingerprint51FE666FBEAC

Questions and learner discussion

No questions or discussions have been posted yet.