Computer Application Technology Memo 1 (English)

November 2017 — Grade 12 / Matric — Computer Application Technology

Memo 2017 Grade 12 English

↓ Download PDF 📄 433 KB View Exam Paper

Preparing document

📋 Document Analysis

📄 16 pages 📝 65 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.1Cover page Text 'Rio Carnival' or any other text inserted in 'Title' control Text 'Rio Carnival is the Mother of All Brazil ian Carnival Parties' moved (not copied\ into 'Subtitle' control (ignore formatting but no

1.3Table of contents Table of contents updated The Carnival Original does not appear\ Page numbers Section break inserted Page number from 'Table of Contents' page removed Page after 'Table of Contents' page numbered as 1

1.6Line spacing Paragraph 'Carnival is on line spacing changed to 'Multiple' At 1.

1.7Footnote Footnote removed from the word 'Portuguese' P1

1.1Find and replace All occurrences (5 changes/6 occurrences (accept 7 occurrences if original is still in document\ replaced with

1.1Hyperlink screentip creentip 'Read more' inserted on hyperlink Accept any text for the screentip Source Website source inserted

1.1Bibliography Automatic bibliography inserted

Q1— Section header —

Q2— Section header —

2.1Page f ooter File p ath inserted as a field (File name will be included\ Appear page

2.2

2.3Caption utomatic caption inserted on picture either above or below 'Figure 1: Orguestra' (accept any text

2.4Indentation Number position set at 0 cm Text indent set at 1. cm

2.5Antonym 'Successor ' replaced with 'predecessor

2.6Comment omment inserted on '2010' with text 'Since 2000'

2.7Cross reference Cross reference added on ' ref Moves to ' 9.Other Blocos

2.8Bullets Bullets changed To 2Maraca.jpg

2.9Table Table style changed to any other table style Repeat row header selected (not for whole table\ Textbox form control t ype changed to 'Date' Displays in date format 'dd Mmm'

2.10Spreadsheet inserted Data from s preadsheet 2Carnival inserted as table As linked object (Verify by checking 'Edit Links to Files'

2.11Table to text Table converted to text Character used to separate '#' Total

Q2— Section header —

Q3— Section header —

3.3Cell E =SUM(E :E8 changed to E

3.4Cell F =LARGE(F :F8 LARGE function :F8 P1

3.5Cell G =RIGHT(A ,3\&LEN(B \&RANDBETWEEN(100,200\ OR CONCATENATE( RIGHT(A ,3\ LEN(B

3.6Conditional formatting: Conditional formatting applied to cells B88 Format all unique values Font colour set to red Summary _Opsom

3.8Graph/Chart: Graph/Chart title inserted 'Visitors' Column graph/chart created for 'National' and 'Foreign' and line graph with or without markers for 'Total' Legend displayed on left of chart/graph Brazil set as

78.75to 135 pt .2.2 Picture Picture stretched to approximately fit into cell Cell A2:K2 Headings appear in bold

4.4Cell DATE(2018,2,1 Year: 2018 Month: 2 Day: 1 Custom format: MMMM yyyy (Accept dd

4.5Cell G4: E4\*24 *24 Cell umber format changed to number or general P1

4.6.1Cell N3: =ROUNDDOWN(AVERAGE(H3:H80\,0\ =INT(AVERAGE(H3:H80\ =INT(AVERAGE(H:H\ ROUND DOWN function AVERAGE function Range: (H3:H80\

4.6Cell IF(H3>= ,IF( 3<= "TRUE","FALSE"\,"FALSE"\ =IF(AND(H3>= 3<= \,"TRUE","FALSE"\ =(H3

4.7Cell K3: =VLOOKUP(I3,Places_Plekke!A2:C7,3 ,False \H3 =VLOOKUP(I3,Places_Plekke!A2:C7,3\*H3 =VLOOKUP(I3,Places_Plekke! 7,3\*H3 VLOOKUP function Lookup value: I3

Q5— Section header —

5.1Field: Entry Field size changed to 15

5.1Field PerformanceDay Input Mask: >L?

5.1Field Class Validation rule "A" or "B" or "C" or "D" or "E" or "F" AND operator changed to OR operator Suitable validation text entered that refers to characters to be

5.1New field New field added with suitable name (should refer to sound clips\ Data type set to OLE ob ject /attachment /hyperlink

5.1Field: Year Moved to appear last in field list Check in datasheet view and design view\

5.1Sorting Database sorted according to school names Check in datasheet view and design view\ P1

5.2Form created with all fields from Comp table Heading 'Entries' inserted in form header (May appear with default heading\ Class field changed to combo box Row source: " A";"B";"C";"D";"E";"F"

5.3Sorted first by Surname then by School Criteria on Position : 1 School Surname

5.4Criteria in PerformanceDay Between #2017/03/02# AND #2017/03/03# >=#2017/03/02# AND <=#2017/03/03# #2017/03/02# OR #2017/03/03# OR

5.5riteria in Entry: Like "??" LEN([Entry]\2 (correct character or use of LEN function\ Two characters (Note to marker: 15 recor

5.6Fields inserted Performa ceDay Class Surname Name Title School Ignore sequence

5.7Report exported PDF Total for

Q5— Section header —

Q6— Section header —

6.1Title <title>Examination number</title> Examination number added as title

6.2Body background colour <body text= #ecf8a4 bgcolor= green Background of web page (bgcolor\ Changed to green (ignore if text tags removed\

6.3Image <img src= 6Redeem.jpg width= height= <img src= 6House.jpg width= height=

6.4Alignment <h3 align= center >SAMBA DANCERS | FREE PAINT | FREE CARNIVAL MASKS</h <center> <h3>SAMBA DANCERS | FREE PAINT | FREE CARNIVAL MASKS</h3>

6.5Horizontal line hr size Horizontal line tag corrected Size set to 4

6.6Font size <font size= It starts on Friday </font> Font size tags inserted Font size set to

6.7Table <table border="2" <th colspan= Facts about Brazil </th> <tr> <td> OFFICIAL NAME: </td>

Q6— Section header —

Q7— Section header —

7.1Page border age border inserted Any d ouble line border

7.1.2Footnote Footnote (or endnote\ added on the 'Redeemer' picture Any f ootnote text added

7.1.3Picture formatting Alt Text Title inserted Alt Text Description changed to 'Photo of Hotel'

7.1.4Hyperlink Hyperlink removed Handout

7.2Handouts Slides exported to w ord processing document As h andouts Provision for notes next to slides 7Tickets

7.3Tickets table Table created (6\ fields added Date set to Date data type Date

Q7— Section header —

Topics Identified

Word ProcessingSpreadsheetsDatabasesPresentationsProgrammingNetworking

Key Information

Websitewww.dobrazilrigth.com · www.riotickets.com

Paper information

SubjectComputer Application Technology

Year2017

SessionNovember

TypeMemo

PaperPaper 1

LanguageEnglish

Pages16

Downloads6

Examination context

Decade2010s

Years ago9y

SeasonSpring (SH)

Start daySunday

Exam periodNovember 2017

Days since exam3,276

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 size433 KB

Pages16

Archived on11 October 2026

File age13d

ContributorFreeMode

Fingerprint07EDC7CFDB68

Questions and learner discussion

No questions or discussions have been posted yet.