Computer Aplication Technology Memo 1 (English)

November 2013 — Grade 12 / Matric — Computer Aplication Technology

Memo 2013 Grade 12 English
↓ Download PDF Facebook X 📄 335.8 KB View Exam Paper
Preparing document

📋 Document Analysis

🎯 200 marks 📄 20 pages 📝 60 items found 📚 1 topics
See full analysis

Questions — A Preview of What to Expect in the Document

60
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 ize Paper size is set to A5 or any other siz
1.2Page orientation Page orientation i s landscape
1.3Page order Page border appears pt shadowed page border Note to marker: Accept if the page border obscures the table slightly.
1.4Text rapping Text wrapping of the layout (in the Format AutoSh ape dialog box is set to 'behind text' 'sen
1.5Grouping Four circles are grouped as one object
1.6Text Text box is inserted 2 pt dashed border line The text 'Don't be part of the problem! Be part of the solution!' appears in the text box Note to marker: Accept any non
1.7'Treat others as ... when socialising online' appears in italic Note to marker: Accept the 6 words above o r whole sentence.\ P1
1.1Column Table has a third column Heading 'What do you ... being bullied online?' appears in heading/ first row of the third column Text ' Don't forward messages ...' to '... report the
1.1Cell lignment Cell alignment of the first row of the table is set to Align Centre (vertically and horizontally centred\
1.1Hyperlink Hyperli nk inserted on text which links to website Screen tip (MSO\ 'Internet
Q1— Section header —
2.2WordArt /Fontwork 'Cyberbullying' placed in WordArt /Fontwork extured fill (Note to marker: MSO 2010 Acc
2.4Table of Contents Automatic Table of Contents inserted 2 levels of headings appear (Heading 1 and Heading Page numbers with no tab leader
0.5cm /14 pt from text Note to marker: Accept position of Drop Cap as Dropped or In margin.
2.10Page numbering Automatic page numbe ring has been inserted (in any format\ In the footer of the document First page is not numbered Second page starts at number 1
2.11Paragraph pacing of paragraph under the sub heading Cyberbullying can take m any forms: Paragraph spacing set to 10 pt /0.35 cm
2.12Bookmark Bookmark Stats links to text ' How do I deal with it?' (Note to marker: lick on bookmark an d Go To to c heck that
2.13Endnote Endnote set on main heading of 'Cyber Bullying Statistics' The web address is used as the text mouse over
2.14Bullets Bullets changed to Webdings #151 (MSO U+F097 (LO symbol
Q2— Section header —
3.1Sheet deleted Sheet1 has been deleted/does not appear Policy_Beleid worksheet
3.2Cell colour Merged cell A1: 1 filled with a red dish colour
2.2Merge Cells A2: 2 me rged Note to marker: Accept if cells A1: H2 are merged.
2.3Font olour Row 2 Font colour of the merged cells A2:H2 white Heading is left aligned
3.2.4Cell order (Cells A1: Double line Outside border only Around cells A1: Note to marker:
2.5Column width Column is 8 or 61 pixels wi
1.6cm (Calc\ Cell G4 =2013 Correct cells Sub raction sign Note to marker: Also accept: =2013
3.8Cell M8 = COUNTIF(F4:F51, "Yes"\ = COUNTIF(C4:C51,"Yes"\ = COUNTIF(H4:H51,"*"\ = COUNTA(H4:H51\ ward 3 marks\ = COUNTIFS(C4:C51,"Yes", F4:F51, "Yes"\ Function
3.9Chart/Graph ource: Cells L1:M2\ D bevel /realistic format (on chart/chart area, top/bottom\ Doughnut chart/graph created placed
3.10
3.11Cell C4 = LEFT(A4,2\ Cell C4 = MID (A4, Function LEFT Cell and characters
3.12Cell D4 = MID(B4,3,2\ Function MID Correct cell B4 Start at character 3 and copy 2 characters
3.13Cell 5 = UPPER(CONCATENATE(C Function U Function CONCATENATE OR & between elements Correct cells: C
Q3— Section header —
4.1Tab colour Tab colour applied to Learners_Leerders worksheet other than the default
4.2Conditional ormatting : Column G Conditional formatting applied To cells ontaining the text 'Y' Light grey ish
4.3Nested IF cell = IF(D2>17,"C",IF(D2 < 15,"A","B"\\ =IF(AND(D2>=15,D2<=17\,"B",IF(D2<15, ondition <15 is in group A Condition 17 or >=17 is in group C Condition:
4.4VLOOKUP Cell J2 =VLOOKUP(H2, Data Data 51,6 LOOKUP Value: H2 Table array: Data
4.5Cell M4 M3/M2*100 = M3/M2% = M3/M2 and then f ormat as % Correct cells (M3 and M2\ Division sign Multipl
Q4— Section header —
Q5— Section header —
5.1.1ield Schoolnum_Skoolnom Required /Entry required property is set to "Yes" (Note to marker: Do not accept Primary Key.\
5.1.2New field Visit_Besoek field inserted After the Province_Provinsie field Data type changed to Date/Time Date/Time format
5.1.3Field: NumLearners_GetalLeerders Validation Rule >249 and <2501 OR >=250 and <=2500 or Between 250 and 2500
5.1.4Field size /type Ratio_Verhouding Double Decimal places set to 1 P1 15
5.7StatsID_StatsID field d eleted Page orientation changed to landscape 'Name_Naam' heading resized to display all text Name_Naam field resized to display all text In group footer
Q6— Section header —
6.1Numbered list Items below the question appear as a n automatic numbered list , i.e. numbers 1 to 4 Note to marker: Accept numbering in any format with
6.2Field Age_Ouderdom Text form field control inserted ext to in line with Age_Ouderdom field Data type set to number
6.3Drop down field control Gender_Geslag 'Select one _Kies een added as an additional option Appears as the default
6.8.1Bullying Statistics Cyberbullying Statistics appears as two tables Note to marker: The second table could appear on the second page. 6Spre adsheet_ Sigblad
6.8.26Spreadsheet_ Sigblad contains the Bullying Statistics table Pasted as a link (Red font changes from Q6.8.3 reflect/updated in
6.8.3The non percentage data appears in a red font in the 6Statistics_Statistiek document. P1
6.8.4Table with primary school statistics app ears in 6Statistics_Sta stiek Accept 1 or 2 primary schools
Q7— Section header —
7.1The folder called Exam_Eks amen appears Note to marker: Do not allocate the mark if MyFolder_MyLeergids still appears
7.2Note to marker: Ignore this question 7Count_Tel ling document
7.3Doc2_Dok2 Size on disk: 188 KB /192 512 bytes (Note to marker: Check the size on disk on the candidate's actual file.\
7.4.1Word 'bully' in all word forms is highlighted (in any colour\
7.4.2times Total for QUESTION 6] GRAND TOTAL [200]200

Topics Identified

1
Business Plan

Mark Allocation

Total200 marks
Sections200 = 200 marks

Paper information

SubjectComputer Aplication Technology
Year2013
SessionNovember
TypeMemo
PaperPaper 1
LanguageEnglish
Pages20
Downloads5

Examination context

Decade2010s
Years ago13y
SeasonSpring (SH)
Start dayTuesday
Exam periodNovember 2013
Days since exam4,737

About Computer Aplication 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 Aplication Technology P1 LibreOffice_DATA →

File details

File size335.8 KB
Pages20
Archived on8 September 2026
File age47d
ContributorFreeMode
FingerprintFD72615A5676

Questions and learner discussion

Log in to ask a question or leave a review.

No questions or discussions have been posted yet.

About this resource: FreeMode is an independent South African education platform. The Department of Basic Education maintains the official NSC examination-paper archive. Learners can use the DBE past examination paper archive to verify examination resources.