Computer Application Technology Memo 1 (English)

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

Memo 2017 Grade 12 English

↓ Download PDF 📄 437.3 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 180 marks 📄 14 pages 📝 80 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.

Q1— Section header —

1.1Abstract Language set to ONLY English South Africa

1.1.2Abstract alignment Text of a bstract justified

1.2Image Image cropped to any shape Sharpness set to 50% or any other besides 0% Subtitle

1.4Table of content Table of content inserted with ' Classic ' style 'Water' style used a first heading style/

1.5Page numbers Automatic page numbering inserted in the footer Formatted as 'Page 1' 'page 1' style Numbering starts as 1 on the 'Contents' page Odd page numbers aligned on the left Even page numbers aligned on the right

1.7Cross reference Cross reference added on text 'table 1' (Ref475517156\ Link s to

1.8Table heading Repeat Header Rows checked for first row

1.8Footnote Footnote inserted on text 'Grootwinterhoek' check 'Grootwinterhoek' text on other pages Reads as 'Strategic water sources' (accept any text\ '*'

1.9Caption (WESTERN CAPE WATER SOURCE AREAS\ Any a utomatic caption added to image Label reads as ' Image (or mage1

1.10Bullets Bullets below 'Boland Mountains' changed to Wingdings character number 165

1.11WordArt WordArt applied to ' Did you know? Text wrapping set to 'Top and Bottom'

1.12Chart/Graph (MPUMALANGA DRAKENSBERG\ Any d ata of chart/graph changed Two changes correctly made to any graph (Cultivated 2%, Natural 48%\

1.13Citation Any automatic citation inserted Report source created Correct fields: Title: The effects of water, Year: 2015 entered (accept if only one field was entered\

1.14Table of figures Table of figures added to show image able of figures displaying tables

1.15Page layout Last page changed to portrait Other pages remain in landscape (award only if attempt was made for first bullet\

Q1— Section header —

Q2— Section header —

2.1Date field Any d ate added Field will a utomatically update

2.2Textbox fill Second text box filled with 2Drops image All/some t ext bolded in text

2.3Drop down field: Gender 'Femail' spelling changed to 'Female'

2.4Check box: 'Older than 60' Any c heck box inserted to the left of text or in any other position

2.5

2.6

2.7Tabs Leader tabs/ ab set to approximately 6 cm , 10 cm and Left tab

2.8Mail merge Data source 2 Det_Bes used Any sorting in ascending order Name Surname fields

Q2— Section header —

3.1.1Row Merged cell changed to A1:

3.1.2Row 1 fill: Any f ill effect applied Thin diagonal stripe pattern style fill effect applied (accept any diagonal stripes\

3.2Freeze panes: Freeze panes effect applied Correct columns and row (row , columns

3.3Cell D3: =VALUE(C3\ (Not to marker: After sorting =VALUE(C6\ Cell G48: =MODE (G3:G46\ Cell H49: =ROUNDUP(AVERAGE(H3:H46\,0\

3.10Sorting: First sorted by year smallest to largest Second sorted by city A to Z P1

3.11Cell C6: =SUBTOTAL($A$6,C10:C53\ =SUBTOTAL($A$6,C9:C53\ Cell range C10:C53 Absolute cell reference

3.1Filter: Filter set on Durban Bloemfontein worksheet Graph Area chart/graph displays rainfall per month per year for Bloemfontein range

Q3— Section header —

Q4— Section header —

4.1Hyperlink: Hyperlink removed from heading 'Water Games

4.2Cell (TODAY(\ D3\7 =(NOW(\ D3\7 =DAYS(NOW(\D3\7 =DAYS(TODAY(\D3\7 TODAY(\ function

4.3Data validation Black removed from the list Applied to the whole column G

4.4Cell =LEFT(C ,2\&" "&RANDBETWEEN(0,99\&LOWER(F =CONCATENATE(LEFT(C ,2\," ",RANDBETWEEN(0,9 9\ LOWER(F = MID(C ,1,2\&"

Q4— Section header —

Q5— Section header —

5.1.1Field: Name or Location Set as primary key

5.1.2Field: Town > inserted in ormat property

5.1.3Field: Province Combo box created Row source: Province

5.1.4Field: Completed Input Mask: 00/>LLL/0000 Two compulsory digits: 00 Uppercase: Three compulsory letters: LLL Four compulsory digits: 00 Divider

5.1.5Field: Capacity Validation Rule OR NOT

5.1.6Field: Illustration Data type changed to OLE bject/ Hyperlink 5AlbertFalls image inserted for the Albert Falls Dam

5.2Town field inserted Criteria in Province field: Limpopo (Note to marker: 1 records expected.\ P1

5.3Fields displayed: Province Avg Of Capacity Capacity Criteria on Province : "Free State" "North West" AVG

5.4Only Name Town fields display Criteria on Surface: IS NOT NULL OR Like

5.5Calculated field called Volume has been created Calculation: [ Surface ]*[Height]*

0.3Format changed to Fixed/Standard and one decimal place Form: frm 5_6

5.65AlbertFalls image added as form background image Hyperlink inserted next to

5.7Illustration label AND field removed Report grouped according to Province Report sorted Town Function in Province

Q5— Section header —

Q6— Section header —

6.1Title title> Examination number </title> Examination number inserted inside title tags

6.2Table cell and image <td><img src="6Life.jpg"></td> Additional cell inserted anywhere 6Life.jpg image inserted Image tags correctly inserted

6.3Horizontal line <hr size="5"> Horizontal line inserted Size set to 5

6.4Alignment and font <h2 align="center"><font face="Arial"> Are you water wise? </font> </h2> Alignment set to cent Font changed to '

6.5Table border <table border="1" cellpadding="12" Border set to 1 Cellpadding set to 12 P1 13

6.6Table columns <td colspan= <font size="3"> <i>The kitchen Here are some suggestions: </i> /font>

6.7Alternative text <tr> <th><img src="6House.jpg" alt = "Inside" >Inside the house</th> Alternative text 'Inside' added on 6House image Unordered list

6.9Link <a href=mailto:" waterwize@water.co.za "> waterwize.co.za</a> Link created on the text 'waterwize.co.za (accept any

Q6— Section header —

Q7— Section header —

7.1.1Header Worksheet name added As field In the left section of the header

7.1.2Named range Named range changed to 'Name_River' (Note to marker: Accept if a named range 'Name_River' was inserted.\

7.1.3Protection Columns A to C locked Password 123 used 7River_Rivier database

7.2Import table Data from the 7Rivers_Riviere spreadsheet imported in 7River_Rivier database Saved as a new database table called Rivers 7Answ_Antw

7.3.1Gutter position of the document

7.3.2Number of paragraphs in the document

7.3.3Number of occurrences of the letter 'm' in the document

7.3.4First word that appears on line 100 ates crop

7.3.5Line weight of the 'Intense Quote' style

0.5

7.3.6Word marked as an index SHARPS

7.3.7Title of the citation source that appears in the document Water Savers

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total180 marks

Sections15 = 15 marks

Key Information

Email Addresswaterwize@water.co.za

Paper information

SubjectComputer Application Technology

Year2017

SessionFeb-March

TypeMemo

PaperPaper 1

LanguageEnglish

Pages14

Downloads3

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 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 size437.3 KB

Pages14

Archived on7 September 2026

File age46d

ContributorFreeMode

Fingerprint6ECDBAB2A22C

Questions and learner discussion

No questions or discussions have been posted yet.