Computer Application Technology Memo 1 (English)

November 2022 โ€” Grade 12 / Matric โ€” Computer Application Technology

Memo 2022 Grade 12 English
โ†“ Download PDF Facebook X ๐Ÿ“„ 694.9 KB View Exam Paper
Preparing document

๐Ÿ“‹ Document Analysis

๐ŸŽฏ 1 marks ๐Ÿ“„ 13 pages ๐Ÿ“ 56 items found ๐Ÿ“š 5 topics ๐Ÿ”‘ 2 key info
See full analysis

Questions โ€” A Preview of What to Expect in the Document

56
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.1Small caps: Extract from Report Font: mall caps
1.2Text Effect (inside shape\ KWAZULU NATAL Text Fill: Gradient fill ype: Rectangular
1.3Style AND Indentation (Showcasting style\ Paragraph i ndentation: Left set as
1.5cm
1.4Citatio (Department of Statistics South Africa\ Citation in rd paragraph
1.5SmartArt SmartArt: Circle Relationship Level 1: Tourism Text 'Tourism': 14 pt Level 2: Employment, Transport, Food Note to marker: Accept if SmartArt graphic appears below
Q1โ€” Section header โ€”
1.6Find: 'tourism' Match case + Find whole words only Format: Highlight Accept any colour
1.7Columns AND Page Orientation: PUBLIC RELATIONS effects of the pandemic. Required text in 2 c olumns
Q2โ€” Section header โ€”
2.1Drop Cap: Position: Dropped (Not n margin
0.5cm
2.2Paragraph bo rder Please share via the number of shares
2.3Hyperlink: Win! Win! Win! Hyperlink inserted to: https://go afari .co .za/
2.4.1 Form Control: Age field Form control: Drop down form field /Combo/List box content control Options: <35
2.4.2Form Control: Cell Number field Type: Regular ext Maximum length: 1 (Accept values
2.4.3Form Control: Extra entries field Type: Calculation Expression: =Share *2 Alt+F9: FORMTEXT
2.5Table anipulation /Text to table Table appears (3 rows 3 columns\
2.6Signature L ine feature Signature ine feature applied
Q2โ€” Section header โ€”
3.1Cell A : Format Format of cell A1 9 applied to cell A
3.2Cells A4 to G4: Vertically Centred and Border lines /Column Width Vertically Centred Thick
3.3Cell B18: =ROUNDUP((B17/100000\*8,0\ OR =ROUNDUP((SUM(B5:B16\/100000\*8,0\ ROUNDUP B17 OR SUM(B5:B16\ /100000
3.4Cell G5: =IF(COUNT( B5 F5 \=5,SUM( B5 F5
3.5Cells F20:F31: Conditional Formatting This orksheet dit ule
3.6Chart/Graph Data series for 2021: Series Value: Data!$C$20:$C$31 Data series for 2020: Series Name: 2020 Legend: below Axis: Number format : 'Use 1000 Separator'
Q4โ€” Section header โ€”
4.1Cell 3: MAX(G7:G 105\ OR =LARGE(G7:G105,1\ Function:
4.2Cell D4 =SUMIFS(G7:G105,C7:C105,"Mpila Camp",H7:H105, "TRUE"\ OR =SUMIFS(G7:G105,H7:H105,"TRUE",C7:C105,"Mpila Camp"\ Sum range: G7:G105 Criteria range 1: C
4.3Cell A7: =VLOOKUP(B 7,Rangers!$B$2:$E $22,3\ Lookup value: B7 Table array: Rangers!$B$2:$E $22 OR
4.4Cell D7: Nested IF function modification =IF(E7<$O$2,"Morning",IF(E7>=$O$3,"Night", "Afternoon"\\ OR =IF(E7>=$O$3,"Night",IF(E7<$O$2,"Morning", "Afternoon"\\ OR =IF(E7>=$O$3,"Night",IF(E7>=$O$2,"Afternoon",
4.5Cell F 7: =E7+TIME(2,45,0\ OR =TIME(HOUR( 7\+2,MINUTE( 7\+45,
Q5โ€” Section header โ€”
5.1.1Field: Surname Required Yes
5.1.2Field: MemberNo (Input Mask\ 00000 "@tv l"
5.1.3Field: TravelDate Format: Medium Date Show Date Picker: Never
5.1.4Field: Accommodation (Lookup\ Row Source Type Table/Query
5.1.5Field: IDCopy Field ID Copy inserted Position: Below Surname field
5.2Image Logo inserted in the form header Image size : 9 cm wide x 4 cm high Date field:
5.3Transport criteria: Taxi OR Private BookingAgent criteria: EasyStay GroupSize criteria: >
5.4BookingAgent Total Group By Cost: Total: SUM Query: qry5_5
5.5Calculated field: DOB : [ ar ] & Left([ ID ],6\
5.6Fields displayed: Surname Name GroupSize Accommodation and
Q5โ€” Section header โ€”
Q6โ€” Section header โ€”
6.1.1Body tag: Text attribute <body text=" lue" </body> Attribute:
6.1.2Heading 2 tags: Did you know? <h2> Did you know? </h2> Heading 2 tags inserted
6.1.3Bold tags he Dolphin Coast year
6.1.4Link tags </p>For more information e mail: <a href = mailto:
6.2<img src="6_2Flamingo. jpg " width="500"/> <table bgcolor="beige" border="5" height="10" > <tr> <td colspan
Q6โ€” Section header โ€”
Q7โ€” Section header โ€”
7.1.2Table calculation and Textbo Cell calculation: KwaZulu Natal: 100
7.3Cell M2: (Note to marker: OR function not IF statement\ =OR(F2=$B$11,F2=$B$12,F2=$B$13,F2=$B$14,F2=$B$15\ Versioning: Candidate and Marker MSO 365 Marker in MSO 2016/2019/2021 Cell reference: F2 Reference to all 5 options in the OR function
Q7โ€” Section header โ€”

Topics Identified

5
Word ProcessingSpreadsheetsDatabasesProgrammingNetworking

Mark Allocation

Total150 marks
Sections21 + 19 + 35 + 15 + 15 = 105 marks

Key Information

APS Score1 points
Email Addressdolphincoast@gmail.com

Paper information

SubjectComputer Application Technology
Year2022
SessionNovember
TypeMemo
PaperPaper 1
LanguageEnglish
Pages13
Downloads4

Examination context

Decade2020s
Years ago4y
SeasonSpring (SH)
Start daySaturday
Exam periodNovember 2022
Days since exam1,449

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.

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 size694.9 KB
Pages13
Archived on7 September 2026
File age47d
ContributorFreeMode
Fingerprint343358FDD7EF

Questions and learner discussion

Log in to ask a question or leave a review.

No questions or discussions have been posted yet.