Computer Application Technology Memo 1 (English)

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

Memo 2013 Grade 12 English

↓ Download PDF 📄 423.2 KB View Exam Paper

Preparing document

📋 Document Analysis

🎯 200 marks 📄 14 pages 📝 70 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.

1.1Paper settings and page orientation Paper size i s set to A4 Page orientation is portrait

1.2: 'Contestant's Personal Data orm' White font Bold Italic Black background highlight /paragraph fill

1.3Tab ettings Tab set at 15 cm Solid line leader tab Applied create 2 lines

1.4Shape Block (square\ added consistent with the ' ' option (Note to marker: Do not allocate the mark if the shape is different from the 'No' option.\

1.5ext to t able Text converted to table wit h four columns (Note to marker: Accept different

1.6Line spacing Single line spacing applied to paragraph

1.7Justification and p aragraph shading Full justification Orange paragraph shading applied to both the agraphs Note to marker: Accept orange shading applied to both or part of the

1.8

Q1— Section header —

2.1.1Header Examination number is highlighted in a yellowish colour (Note to marker: Ignore the alignment of the examination number as the left alignment is the default.\

2.1.2The text 'Rules' right aligned in the header

2.1Horizontal line added below the text of the header Note to marker: Ignore spelling. Ignore the weight/position of the horizontal line.\

2.2WordArt/Fontw ork Any wave shape applied (MSWord\ Favorite 2 style applied (LibreOffice\ WordArt/Fontwork is a blu ish colour WordArt/Fontwork reads from bottom to top (90

2.3Images Absolute Position set to exactly 8 cm below the top margin Excess red background of photo is removed Photo is resized and fits inside the picture frame

2.4Style: Title Title style applie to Table of Contents at the top of page 2 P1

2.5Style : Contest Contest style is modified to a\, b\, c\ numbering format All 8 instances (sub paragraph headings\ updated

2.7Page ooter Page number inserted in Page footer from third page onwards (Section break appears second page

2.8Customised b ullets Bullets applied Heart shaped symbols Green ish colour

2.8.2Bul let position and Text distance Indent at/Text distance 1.5 cm Bullet position/aligned at 0.5 cm

2.9Font effect Emboss effect is applied to 'Who may enter?'

2.10Indent paragraph First line indent is set ibre ffice irst line indent 2 cm

2.11Paragraph spacing 15 pt after spacing 'Don't add space between paragraphs of the same style' is unchecked P1

2.12Bookmark : CD Bookmark CD created (on the fourth pa ge\

2.13Hyp erlink : on Fantastic Evening Creation Hyperlink inserted on Fantastic Evening Creation Links to the bookmark Fantastic

2.14First table: Table borders No table borders appear

2.15.1Second t able : First row First row merged

2.15.2Second t able : Text in first row The text 'Order of appearance of contestants' has been moved to top row of the table Text

2.15.3Second table: Table border 3 pt dotted outside border only (Note to marker: Do not allocate the 3rd mark if the inside borders were changed.\

2.16Line and page breaks Widow/orphan control is unchecked Line and page break > keep with next is checked Line and page break > keep lines together is checked

Q2— Section header —

3.1Heading: Cells A1:G1 eading is fully visible (Row height is adjusted\

3.2Column H Is hidden

3.3Cells : Alignment and Fill Vertical lignment is set to Distributed Patterned fill is a pplied Not e to marker:

3.6Cell K10: = COUNTIF( 41,"> G43 Function: COUNTIF Cell range 41 Criterion: G43 or

3.7Chart/Graph: Cells J4:K7 Chart/graph created 3D column chart/graph type Title 'Top Scores' appears above the chart/graph Note to marke r: Ignore spelling

Q3— Section header —

4.1Delete a worksheet Sheet 1 deleted 4Winners_Wenners worksheet

4.2Cell E4: =ROUNDUP(( D4/$D$2 *100,0\ ROUNDUP function used Division operator used correct cells, i.e. D4/D2

4.3Cell =(SUM(E5:H5\H5\5 =(SUM (E5: 5\+2*H5\/5 Add the final marks SUM( E5,F5,G5,H5 E5+F5+G5+H5 SUM(E5:H5\

3.2Cell : =IF( ,"Introd uction",IF( ,"Dance ostume",IF( ,"Evening ear","Interview"\\\ IF Function

4.5Cell O9: =AVERAGE(J4:J41\ Function: AVERAGE Correct range: J4:J41

4.6Find and Replace (Column C\ The letter 'S' is replaced by 'School' For all the records (Expect 38 occu rences nfo_Inlig worksheet

4.9Cell L3: =IF(K3<=9,CONCATENATE("0",K3\,K3\ To determine whether a 0 should be added: IF function Condition: K3 or <10 (Accept any other valid conditions\ Value

4.10Cell B3: =SUMIF('4Info_Inlig'!F :F40,"District _Distrik 4", '4Info_Inlig'!G :G40\ =SUMIF('4Info_Inlig'!F :F40, '

4.11Chart/graph Dark brown border appears around the tit le Data labels appear for each bar Major vertical gridlines appear The l ongest bar (District 4\ s a different colour

Q4— Section header —

Q5— Section header —

5.1New table called 51Tbl created field exists Table: 52Planning_Beplanning

5.2.1Primary key Primary key is set the Code_Kode field

5.2.2Field: Leader_Leier Required property is set to Yes

5.2.3Field: Task_Taak Data type changed to Memo LibreOffice: Accept OTHER

5.2.4Field: Date_Datum New field called Date_Datum inserted Data type set to ate format Note to marker: Accept any placement of the Date_Datum field in the

5.2.5Field: Cost_Koste The data type is set to urrency format

5.2.6Field: Cost_Koste: Validation Rule and <500 Or any other valid response, e.g. Between 1 and 499 >=1 and <=499 LibreOffice Mark allocation shown as Filter is applied

5.3ecord deleted Record of Bonisile Xhasa does not exist

5.4Insert (Copy and aste Values from 5Final_Finaal appear in the Score_Punt field

5.5Query called MyQry created District_Distrik, Name_Naam Surname_Van fields are displayed District_Distrik field is sorted in ascending order

Q5— Section header —

5.7The IDnumber_IDnommer field does not display Picture Type property of image control is set to 'stretch' (LibreOffice: The scale property of the image button control is set to Keep Ratio/Fit to size.\ The heading reads 'Contest_Kompetisie'

5.8Name_Naam field moved next to Surname_Van field Grouped by District_Distrik field Sorted by

5.9Report named MyRpt and not QryAge_Ouderdom Report based on QryAge_Ouderdom query Background colour of report header is yellow sh

Q6— Section header —

6.2Link Link to the 6Scores_Punte spreadsheet appears Link appears as an spreadsheet icon 6Scores_Punte, 6Envelope_Koevert, 6Merge_Sa mvoeg

Q6— Section header —

Q7— Section header —

7.1The sub folder called Today_Vandag has been deleted/removed from the Old

7.2Shortcut created to 7Beauty_Skoonheid file Shortcut appears in the Old_Oud folder 7Password_Wagwoord

7.37Password_Wagwoord has been saved with the password '123'. Note to ma rker: Accept any pass word. 7Doc_Dok document

7.5Number of paragraphs paragraphs

5.2

Topics Identified

Word ProcessingSpreadsheetsDatabasesProgrammingNetworkingHardware

Mark Allocation

Total200 marks

Paper information

SubjectComputer Application Technology

Year2013

SessionFeb-March

TypeMemo

PaperPaper 1

LanguageEnglish

Pages14

Downloads6

Examination context

Decade2010s

Years ago13y

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 P1 LibreOffice_DATA →

File details

File size423.2 KB

Pages14

Archived on8 September 2026

File age46d

ContributorFreeMode

Fingerprint38D4E94195DD

Questions and learner discussion

No questions or discussions have been posted yet.