Computer Application Technology Memo 1 (English)

November 2018 — Grade 12 / Matric — Computer Application Technology

Memo 2018 Grade 12 English

↓ Download PDF 📄 417.1 KB View Exam Paper

Preparing document

📋 Document Analysis

📄 15 pages 📝 70 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.1Font ('Welcome to Impressionism'\ Font changed to 'Wide Latin'

1.2.1Justification First paragraph justified

1.2.2Paragraph spacing Paragraph spacing after changed (not 12 pt\ Set to 0 pt

1.3Bookmark Bookmark inserted on text 'history' Bookmark named 'Monet'

1.4Indents Left indent set to 2 cm Right indent set to 2 cm (15 cm on the ruler\

1.5SmartArt 'Futurism' shape added Sub art form 'Analytical' added to 'Cubism' shape (demoted\ (mark from text pane\ 'Post mpressionism' shape appears after

1.6Find and Replace Text 'colo rs' replaced with symbol: In a red font Symbol correct (or 11\

1.7'Artistic' style Font changed to small caps Border width set to 3 pt (or 5\ instances updated (only if attempted\ P1

1.8Image Second image' s height 5.5 cm and width 8. cm Second image moved to the right of the first image

1.9Page layout /columns Orientation changed to Landscape of selected text only emaining text in Portrait Text displays in two columns

1.10Page numbering Section breaks inserted after text Automatic page numbering added in footer Page number format a, b, c, etc. Page number restarted at 'a'

1.11Table of figures Automatic t able of figures inserted

1.12Index Index updated entries\

Q1— Section header —

Q2— Section header —

2.1Text direction Text direction changed to 270 (bottom to top\

2.2Footnote Footnote inserted on text 'works' 'Impression.org' as footnote text

2.3Bullets Bullets replaced with 2Pic image

2.4Form fields 'Name' text form field format set to uppercase Text 'Current date here' replaced with text form field (date\ Current date set as data type

2.6Tables Two tables merged into one table (hard return removed\ Shading applied to first row

Q2— Section header —

Q3— Section header —

3.1Cells A1:J1: Border colour changed to red Fill colour set to black

3.2

3.3Cell G4: =COUNTBLANK(G9:G120\ OR COUNTIF(G9:G120, COUNTBLANK/COUNTIF (...,""\ function Range: (G9:G120\

3.4Cell G5: =ROUNDUP( AVERAGE(F9:F120\ ROUNDUP ,1

3.5Cell G6: =SUMIFS(J9:J120,C9:C120,"<1900",I9:I120,"Chicago"\ =SUMIFS(J9:J120,I9:I120,"Chicago",C9:C120,"<1900"\ SUMIFS( J9:J120 Criteria range: C9:C120 Criteria: "<1900" Criteria range: I9:I120 Criteria: "

3.6Conditional formatting: Cells B9:B120 Conditional formatting applied to cells B9:B120 Unique value rule Any fill colour applied

3.7Cell D9: =YEAR(TODAY(\ C9 OR YEAR(NOW(\ YEAR function correctly used TODAY(\ NOW(\ function

3.8Duplicates removed from list (45 artists remain\ Chart_Grafiek worksheet

3.9Chart/Graph Data from L to P display (15 locations\ Vertical axis display units displayed in billions Horizontal axis title displays 'Location' Any trendline inserted

Q3— Section header —

Q4— Section header —

4.1Row Vertical alignment ext vertically centred (ignore if horizontal alignment is changed\

4.2Cell H3: SUM (K8:K57\ SUM function Range: K8:K57

4.3Cell H4: CHECK FOR BUILDING BLOCKS =COUNTIF(H8:H57,"<>French"\/ COUNTA(H8:H57\*100 (COUNTA(H8:H57\ COUNTIF(H8:H57,"French"\\/ (COUNTA(H8:H57 \100 Count

4.4Cell J8 CHECK FOR BUILDING BLOCKS =VLOOKUP(LEFT(I8,1\,Code _Kode A$2 B$7 ,2\ =VLOOKUP( MID

4.5Cell N8: CHECK FOR BUILDING BLOCKS =IF(L8>=LARGE($L$8:$L$57,3\,"Top3",""\ =IF(L8> LARGE($L$8:$L$57,4\,"Top3",""\ =IF(L ARGE($L$8:$L$57,3\<=L8,"Top3"," =IF(L8 =LARGE($L$8:$L$57,1\,"

Q4— Section header —

Q5— Section header —

5.1.1Field: Painting Format set to

5.1.2Field: YearPainted Validation ule >=1494 AND <=1970 >1493 AND <1971 OR

5.1Field: Input ask: IMP IMP >imp

5.1.4Field: Area New field added: Area Data type: Calculated Expression: [Height] [Width]

5.1.5Field: Age Age field unhidden and displays in atasheet view Form: frm5_2

5.25Girl image displayed in form header Image size mode property set to stretch Detail background shaded to any colour Rating c

5.3Total row : Group By applied Gender riteria: Male NumberOfPaintings : Total: Sum

5.4criteria: Like "??????*" OR LEN([ OR Like "??????" Like "???????" (1 criteria\

5.5Calculated field and Nationality criteria Diff: [For] Against] New field Diff For Against

5.6Fields inserted: Born and/or Born by Year BirthCountry ArtistName ArtistSurname Grouping on Born field

Q5— Section header —

Q6— Section header —

6.1Font face <h1 align="center"><font color="IndianRed" face="Vivaldi" >Weird Personal Quirks of Historical Artists</font></h1> Font face set to 'Vivaldi'

6.2Horizontal line <hr width="60%" align="right" color="Crimson"/> Line width set to 60% Line aligned right

6.3Heading 2 and italics <h2><i> Believe it or Not!!! i></h2> Heading 2 added Heading 2 in italics

6.4Link to target location <a href="#Weird"> ECCENTRICITY </a> Link on text ECCENTRICITY Link href added correctly

6.5Ordered list <ol type="A"> <li> Stealing pens </li> <li> Carrying around guns </li> <li>

6.6

6.7Closing table tag and bold </table> <p><a name="Weird"> <b> SHOCKING BUT TRUE </b> </a></p> Closing table tag added Text display

Q6— Section header —

Q7— Section header —

7.1.1WordArt WordArt applied to hea ding 'Lecture on Impressionism' Comment removed

7.1.2Track changes All track changes rejected ('Love to see you there!!!' should not display at the end of the document

7.1.3Mail merge 7Lecture linked to data source 7Guests (tblGuests\ Data source: ArtForm criteria 'Painting' (ArtForm Painting Data source:

7.1.4Merge completed Mail merge completed (Not e to marker: 4 letters expected; Africa, Hageman, Sabelo, Viljoen 7ArtForm

7.2Convert text to columns Text divided into more than one column Text appears correctly in 3 columns 7Summary

7.3Subtotal feature Subtotal feature used Group Birth Country _Geboorteland Function: MAX SUBTOTAL (4,...\

7.4Cell D5: =IF(B5=B4,IF( =1,"True","False"\,"False"\ =IF(B5<>B4,FALSE,IF( =1,"True","False"\\ =IF(AND(B5=B4, =1\,"True","False"\ =IF(B5=B4,IF((C5 1\=C4,"True","False"\,"False"\

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworking

Mark Allocation

Sections36 + 28 + 20 + 20 = 104 marks

Paper information

SubjectComputer Application Technology

Year2018

SessionNovember

TypeMemo

PaperPaper 1

LanguageEnglish

Pages15

Downloads5

Examination context

Decade2010s

Years ago8y

SeasonSpring (SH)

Start dayMonday

Exam periodNovember 2018

Days since exam2,912

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 size417.1 KB

Pages15

Archived on7 September 2026

File age48d

ContributorFreeMode

Fingerprint92D100E3E6BA

Questions and learner discussion

No questions or discussions have been posted yet.