NATIONAL
SENIOR CERTIFICATE
GRADE 12
COMPUTER APPLICATIONS TECHNOLOGY P1
NOVEMBER 2024
MARKING GUIDELINES
MARKS: 150
CENTRE FINAL MARK
NUMBER
EXAMINATION
NUMBER
QUESTION 1 2 3 4 5 6 7 TOTAL
POSSIBLE MARK 25 20 21 19 35 15 15 150
CANDIDATE
MARK
MARKER CODE/
SIGNATURE
MODERATED
MARK
These marking guidelines consist of 15 pages.
DBE Stamp
Copyright reserved Please turn over
Skip to contentAll 2024 papers 





View all





Computer Applications Technology Grade 12 P1 2024 Memo (Eng)
Grade 12 Computer Applications Technology Paper 1 memorandum from the November 2024 NSC (English), 15 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · November 2024 NSC · 2024. Memorandum. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Document type
- Memorandum
- Year
- 2024
- Exam period
- November 2024 NSC
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 15
- File size
- 542.4 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 15
This exam
November NSC 2024
Questions in this paper
Document textSearch extracted text and jump to a page.
Computer Applications Technology/P1 2 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
Check the accuracy and skill required before awarding a mark throughout.
QUESTION 1 File name: 1Solar Total Q1: 25
Maximum Candidate
No. Criteria
Mark Mark
1.1 Author properties 1
• Author: Examination number ✓ 1
1.2 Style modified: Solar 3
• Style Solar: Text effects: Shadow effect changed ✓ 1
• Shadow colour: Any blue ✓ 1
• Shadow distance: 50 pt ✓ 1
1.3 Pagination: '4. The Solar System …' 1
• Keep with next ✓ 1
1.4 Cross-reference: 'Question/Vraag 1.4' 2
• Cross-reference inserted on Question/Vraag 1.4 ✓ 1
• Bookmark text: Venus ✓ 1
Alt+F9: { REF Venus \h }
1.5 Endnote: 'NASA' 3
• Endnote inserted on 'NASA' ✓ 1
• Number format: a, b, c, … ✓ 1
• Endnote text: America ✓ 1
1.6 Image: Below 'Planets' 4
• Caption label created: Space ✓ 1
• Caption text: Planets ✓ 1
• Border size: 3 pt ✓ 1
• Border style: Dash style ✓ 1
1.7 Text to table: Below 'Difference between the …' 2
• Correct text converted to table ✓ (2 columns x 6 rows) 1
• Table style: Any List Table style ✓ 1
1.8 Multilevel list (Planets): 3
'1. Mercury … 14 known moons'
• Multilevel list: 2nd level applied to correct text ✓ 1
• Number Style: Bullet: ⬧ ✓ 1
• Bullet added: Mercury's one year … ✓ 1
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 3 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
1.9 Page number 4
• Any automatic page numbering in the footer ✓ 1
• Format: Page X of Y ✓ 1
• Different odd and even selected ✓ 1
• Alignment: Odd numbers left AND even numbers
right ✓ 1
1.10 Watermark 2
• 1Back image inserted ✓ 1
• On the last page only ✓ 1
Total for QUESTION 1 [25]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 4 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
Check the accuracy and skill required before awarding a mark throughout.
QUESTION 2 File name: 2Moon Total Q2: 20
Maximum Candidate
No. Criteria
Mark Mark
2.1 Cover page 2
• Cover page: Slice (Dark) inserted ✓ 1
• Additional content control deleted ✓ 1
2.2 Line spacing and indentation 3
• Correct text: Line spacing: Exactly: 20 pt ✓ 1
• Indentation: Special: Hanging ✓ By: 1 cm ✓ 2
2.3 Find and replace: 'planet' 3
• Font: Effects: Small Caps ✓ 1
• Character Spacing: Position: Raised ✓ (By: 3 pt) 1
• 4 replacements made ✓ (Find whole words) 1
2.4 Bibliography 2
• Bibliography inserted ✓ 1
• Style: APA ✓ 1
2.5 Tab stops 4
Second tab stop:
• Position: 8.5 cm ✓ 1
• Alignment: Centre ✓ 1
• Leader: 2. ……… ✓ 1
Third tab stop: (11 cm)
• Alignment: Left ✓ 1
2.6 Page orientation: Last page 2
• Orientation: Landscape ✓ 1
• All other pages in portrait ✓ 1
2.7 Watermark 3
• Text Moon replaced ✓ 1
• Symbol: Moon symbol (Webdings 224) ✓ 1
• Size: 800 pt ✓ 1
2.8 File path 1
• File path field inserted in footer ✓ 1
(Note to marker: Right click → Update field)
Total for QUESTION 2 [20]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 5 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 3 File names: 3Sales; 3Target Total Q3: 21
• Mark the questions from the formulae and not the values/answers in the cell.
• Check against candidate's actual work (Cell references may differ, depending on the
candidate's response).
• Candidates may use multiple formulae, cells or 'building blocks' to reach answers.
• Named ranges can be used instead of cell references.
• The answers must still be correct even if changes are made to the existing data.
Maximum Candidate
No. Criteria
Mark Mark
Target worksheet
3.1 Target worksheet: 2
• Target worksheet moved (not copied) ✓ 1
• New workbook saved: 3Target ✓ 1
(Note to marker: Target worksheet must not appear in
3Sales)
Sales worksheet
3.2 Cell A1: Comment 1
• Comment inserted: Popular ✓ 1
3.3 Cell D3: 1
=MIN(E10:E49)
• Function: MIN(E10:E49) ✓ 1
3.4 Cell D5: 4
=COUNTIFS(G10:G49,"Delivery",H10:H49,">=1000")
OR
=COUNTIFS(H10:H49,">=1000",G10:G49,"Delivery")
Criteria 1:
Count the cells if the criteria is "Delivery" ✓ and appears 1
in the cell range: G10:G49 ✓ 1
AND
Criteria 2:
Count the cells if the criteria is ">=1000" ✓ and appears 1
in the cell range: H10:H49 ✓ 1
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 6 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
3.5 Cell A12: 5
=DAY(B12)&LEFT(C12,3)&"@SO"
OR
=DAY(B12)&MID(C12,1,3)&"@SO"
OR
=CONCATENATE(DAY(B12),LEFT(C12,3),"@SO")
OR
=CONCAT(DAY(B12),LEFT(C12,3),"@SO")
• Function: CONCATENATE ✓ OR CONCAT OR & 1
• Function: DAY(B12) ✓ 1
• Function: LEFT(C12,…) ✓ OR MID(C12,...) 1
• Position: 3 ✓ 1
• Text: "@SO" ✓ 1
3.6 Cell F11: 3
=D11*E11*15%
OR
=D11*E11*0.15
OR
=D11*E11*15/100
OR
=H11*15/115
OR
=H11-(E11*D11)
• The quantity per product: D11 ✓ 1
• Multiplied by the price of the product: *E11 ✓ 1
• Multiplied with VAT: *15% ✓ 1
3.7 Column G: Conditional formatting 5
• Conditional formatting applied to column G ✓ 1
• Determine if:
o Cell value ✓ = $H$3 ✓ 2
OR
Formula: $G10 = $H$3
o Correct use of absolute cell reference ✓ 1
• Fill colour: Any Yellow ✓ 1
Total for QUESTION 3 [21]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 7 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 4 File name: 4Shows Total Q4: 19
• Mark the questions from the formulae and not the values/answers in the cell.
• Check against candidate's actual work (Cell references may differ, depending on the
candidate's response).
• Candidates may use multiple formulae, cells or 'building blocks' to reach answers.
• Named ranges can be used instead of cell references.
• The answers must still be correct even if changes are made to the existing data.
Maximum Candidate
No. Criteria
Mark Mark
Total worksheet
4.1 Rename: Sheet 1 1
• Sheet1: Renamed to Shows ✓ 1
4.2 Cell D3: 2
=LARGE(G10:G62,4)
• Function: LARGE(G10:G62, …) ✓ 1
• Value: 4 ✓ 1
4.3 Cell D5: 3
=SUMIF(B10:B62,"Milky Way",G10:G62)
• Criteria range: B10:B62 ✓ 1
• Criteria: "Milky Way" ✓ 1
• Sum range: G10:G62 ✓ 1
4.4 Cell C10: 4
=VLOOKUP(F10,Session!$A$1:$B$4,2)
OR
=XLOOKUP(F10,Session!$A$1:$A$4,
Session!$B$1:$B$4)
• Function: VLOOKUP ✓ 1
• Lookup value: F10 ✓ 1
• Table array: Session!$A$1:$B$4 ✓ OR 1
Session!$A$2:$B$4 OR
Session!A1:B4 OR
Session!A2:B4
• Column index: 2 ✓ 1
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 8 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
4.5 Cell D12: 2
=E12-TODAY()
• Date: E12 subtracted from ✓ 1
• Current date: TODAY() ✓ 1
4.6 Cell J10: 7
=IF(AND(H10="School",C10="Morning"),
(I10*G10)*0.95,IF(H10="Business",(I10*G10)*0.97,
I10*G10))
OR
=IF(AND(H10="School",C10="Morning"),
(I10*G10)-(I10*G10)*5/100,IF(H10="Business",
(I10*G10)-(I10*G10)*3/100,I10*G10))
OR
=IF(H10="School",IF(C10="Morning",(I10*G10)*0.95,
I10*G10),IF(H10="Business",(I10*G10)*0.97,
I10*G10))
Concepts:
Determine if shows are booked by schools AND in
the morning
If TRUE: Subtract 5% from total cost
(*0.95 OR 95/100 OR subtract 5/100)
Determine if shows are booked by businesses
If TRUE: Subtract 3% from total cost
(*0.97 OR 97/100 OR subtract 3/100)
If both conditions are FALSE, determine total cost
• Correct syntax/logic applied ✓ 1
• Criteria : AND ✓ (H10="School",C10="Morning") ✓ 2
• Value if both criteria is TRUE: (I10*G10)*0.95 ✓ 1
• Criteria : H10="Business" ✓ 1
• Value if TRUE: (I10*G10)*0.97 ✓ 1
• Value if all criteria is FALSE: (I10*G10) ✓ 1
Total for QUESTION 4 [19]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 9 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 10 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 5 File name: 5Inventory Total Q5: 35
Maximum Candidate
No. Criteria
Mark Mark
Table: tbI5_1
5.1.1 Field: Name 1
• Format: > ✓ 1
5.1.2 Field: IDNo 2
• Primary key ✓ OR Indexed: Yes (No Duplicates) 1
• Field size: 13 ✓ 1
5.1.3 Field: StartDate - Validation rule 4
Between #2021/06/01# AND Date()
OR
>=#2021/06/01# AND <=Date()
OR
[StartDate] >=#2021/06/01# AND [StartDate]<=Now()
• Start date: #2021/06/01# ✓ 1
• AND ✓ 1
• Current date: Date() ✓ OR Now() 1
• Validation Text: Any appropriate text with reference
to the validation rule (of candidate) ✓ 1
5.1.4 Field: Designation 2
• Row Source Type: Value list ✓ 1
• Row Source: Assistant added correct position ✓ 1
Table: tblEvent
5.1.5 Import: 5Events to tblEvents 3
• 5Events spreadsheet imported ✓ 1
• As tblEvents ✓ 1
• No primary key ✓ 1
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 11 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
Form: frm5_2
5.2 Image 6
• 5Logo inserted in the form header ✓ 1
• Width: 5 cm ✓ 1
• Height: 3 cm ✓ 1
Field CellNo
• Input mask:
1
• "+27" ✓
1
• 000000000 ✓
Field StartDate
• Moved to appear next to Name field ✓ 1
Query: qry5_3
5.3 New calculated field: Profit: [SellingPrice]-[Cost] 3
• New field: Profit ✓ 1
• [SellingPrice] ✓ - [Cost] ✓ 2
Query: qry5_4
5.4 • Product criteria: "Like* ✓ T-Shirt*" ✓ (both wildcards) 2 5
• InStock criteria: <5 ✓ 1
• InStock criteria: >=15 ✓ 1
• AND+OR logic correct ✓ 1
(Expected records: 25)
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 12 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
Query: qry5_5
5.5 • Product field removed ✓ 1 5
• Category field moved to appear first ✓ 1
• Category field: Totals row: Group by ✓ 1
• InventoryValue field: Totals row: Sum ✓ 1
• InventoryValue field: Sorted: Ascending ✓ 1
Report: rpt5_6
5.6 • Heading replaced with 'Stock' ✓ 1 4
• Function added:
• Category footer ✓ 1
• Function: =Count(*) ✓ OR =Count(any field 1
name)
• Suitable label ✓ 1
Total for QUESTION 5 [35]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 13 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 6 File names: 6_1Star; 6_2Mars Total Q6: 15
• This question should be marked from the HTML code.
• Numerical attribute values and single words do not need to be in inverted commas.
Maximum Candidate
No. Criteria
Mark Mark
6Advert
6.1.1 Comment 1
<!--1234567989-->
• Examination number inserted in comment ✓ 1
6.1.2 Image 2
<img src="6_1Gift.png">
1
• Image tag inserted ✓
1
• Image: 6_1Gift.png ✓
6.1.3 Table spacing 2
<table border="1" cellpadding="15">
1
• Attribute: Cellpadding ✓
1
• Size: 15 ✓
Table data 2
<td rowspan="3">These Package…</td>
1
• Attribute: Rowspan ✓
1
• Size: 3 ✓
Unordered list 2
<ul type="circle">
1
• <ol> changed to <ul> ✓
1
• Attribute: type ✓
6.1.4 Link 2
<a href="https://shrturl.app/z2JRr8"><img
src="6_1Button.png"></a>
• Anchor tags inserted ✓ 1
• Attribute: href ✓ 1
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 14 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
6.2 6_2Mars
3
<body text="black" bgcolor="lightgrey">
….
<hr width="200" align="left" size="6" color="Red"/>
<i>"You want to … among the stars."</i><br/>
Body tag:
• Text: black ✓ 1
Horizontal line:
• <hr> inserted ✓ 1
Italics:
• Italic tags inserted ✓ 1
Closing tag(s) or triangular brackets and nesting 1
correctly used. ✓ .......... 1
Total for QUESTION 6 [15]
DBE Stamp
Copyright reserved Please turn over
Computer Applications Technology/P1 15 DBE/November 2024
NSC – Marking Guidelines
EXAMINATION
NUMBER
QUESTION 7 File names: 7Envelope; 7Chart; 7Inventory; 7Merged Total Q7: 15
Maximum Candidate
No. Criteria
Mark Mark
7Envelope; 7Merged
7.1 Mail merge 5
• Mail merge used: 7Members linked to 7Envelope ✓ 1
• Filter: New member: 'Yes' ✓ 1
• Merge field inserted: Address ✓ 1
• Mail merge completed ✓ 1
• Saved as 7Merged ✓ 1
(Expected pages: 9)
7Chart
7.2 Chart 4
• Chart type changed: Column chart ✓ 1
• Y-Axis options: Bounds: Minimum: 5000 ✓ 1
• X-Axis options: Alignment: Text direction:
Rotate all text 270° ✓ 1
• Data labels: Number: Decimal places: 0 ✓ 1
7.3 Linked Object 2
• 7Stock inserted as link ✓ 1
• Icon displays ✓ 1
ALF+F9:
{ LINK Excel.Sheet.12 "...7Stock.xlsx" "" \...\p }
7Inventory
7.4 Subtotal 4
• Column B: sorted in alphabetical order ✓ 1
• At each change in: Category/Kategorie ✓ 1
(Function: Sum – Displays: Category Total)
• Add subtotal to: Inventory value/Voorraadwaarde ✓ 1
• Page break between groups selected ✓ 1
Total for QUESTION 7 [15]
TOTAL 150
DBE Stamp
Copyright reserved
Study this subject
Recommended for this subject

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P1 2024 QP (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2022 Memo (Eng)

Memorandum
Computer Applications Technology Grade 12 P1 2021 Memo (Afr)

Memorandum
Computer Applications Technology Grade 12 P1 2021 Memo (Eng)
More from Grade 12 Computer Applications Technology

Question paper
Computer Applications Technology Grade 12 P1 2025 QP (Afr)

Question paper
Computer Applications Technology Grade 12 P2 2025 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P2 2024 QP (Eng)

Question paper
Computer Applications Technology Grade 12 P1 2023 QP (Eng)

Errata
Computer Applications Technology Grade 12 P1 2022 Errata

Question paper