Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2024
COMPUTER APPLICATIONS TECHNOLOGY P1
MARKING GUIDELINE
NAME OF CANDIDATE: GRADE:
SIGNATURE OF EDUCATOR:
QUESTION Q1 Q2 Q3 Q4 Q5 Q6 Q7 TOTAL
POSSIBLE MARKS 36 13 27 16 34 13 11 150
CANDIDATE’S MARK
MODERATED MARK
This marking guideline consists of 14 pages.
Hosted by www.ecexams.co.za.
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 Eastern Cape Prelim Exam 2024 (English), 14 pages. Read online or download the free PDF.
Computer Applications Technology · Grade 12 · Eastern Cape Prelim Exam · 2024 · English. Memorandum, 14 pages. Read online or download the PDF.
- Subject
- Computer Applications Technology
- Grade
- Grade 12
- Language
- English
- Document type
- Memorandum
- Year
- 2024
- Exam period
- Eastern Cape Prelim Exam
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 14
- File size
- 1.3 MB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 14
This exam
Eastern Cape Prelim Exam 2024
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
QUESTION 1 File Name: Q1_Overview Total Q1: 36
Maximum Candidate
No. Criteria
Mark Mark
1.1 Text:
LET THE GAMES BEGIN 1
• All caps font effect applied ✓ 2
(Do not accept font changed to uppercase.)
1
• Outer offset bottom right shadow text effect applied ✓
1.2 Table of content:
Style Esport1 used in Table of content. ✓
1
1
1 5
• Table of content formal style ✓
• Solid line for page number ✓ 1
• Esport1 Style applied to multiplayer ✓
• Page break/next page section break inserted before
Dota 2 so that page number reflects page 3 ✓
1
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 3
1.3.1 First row of the table:
1
1 3
• Row added above the table ✓
• All cells merged ✓
• Heading Top Dota 2 Teams in the world moved (not 1
copied) into merged cell and centre aligned ✓
1.3.2 Last row of the table:
1
• Border inserted Thin inside line, thick outside line ✓ 2
(Note to marker: Must be thin inside and thick outside
right around.) 1
• Formula = Average (Above) ✓
1.4 Columns:
• Two columns with a line in between ✓
(Must do both to get 1 mark.)
1
• Inserted a column break before the heading “Each” ✓
2
1
1.5 Footnote to endnote:
1
Steam under the heading development
2
• Footnote converted to endnote ✓
1
• Number format set to A, B, C, ... ✓
1.6 Citation:
• Citation under the heading international inserted ✓
1 1
(Note to marker: Must be the source Gwabeni, 2022.)
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
1.7 Picture:
• Picture under the heading Carry
Reset ✓
1 1
(Note to marker: no mark if the picture AND size is reset.)
1.8 Index:
• Highlight remove from the index ✓
Original:
Correct:
1 1
(Note to marker: Update index and see if highlight is still
removed; learner must remove highlight in document not on
the index itself.)
1.9 Index sub entry:
• WarcraftIII subentry Blizzard added (Ignore spelling) ✓
1
• Index update on the last page. ✓
2
1
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 5
1.10 Find and Replace:
• Replaced all the IceFrog words with Gabe ✓ 1
• Gabe format Red underline ✓ and Bold ✓
• Match Case ✓
(Page 9 Below the heading Development.)
(4 Words replaced.) 1
(7 Words if match case was not selected.)
4
1
1
1.11 Caption:
• New caption Label Hero created and added to the correct 1
picture ✓
• Caption read as follows: Crystal Maiden ✓
1 3
• Updated in the table of figures on page 2/3 ✓
1
1.12.1 Smart Art:
• The None bullet is added to 2005 by adding the text below 1 1
it and demoting it to the correct level. ✓
1.12.2 • Any colourful style applied ✓
1 1
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
1.13 Multiple level list:
1
• Level 1 A) ✓
• (Note to marker: Must have ')' in
order to get this mark.) 1
• Level 2 Bullet windings character 4
code 176 ✓
1
• 2nd bullet aligned at 1cm ✓
• 2nd bullet 2 cm hanging indent ✓
1
1.14 Source:
• Film source added ✓ 1
• Content added correctly ✓
2
1
Total for QUESTION 1 [36]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 7
QUESTION 2 File Name: Q2_Application Total Q2: 13
Maximum Candidate
No. Criteria
Mark Mark
2.1 Drop down form field: 1
• Blue Team added ✓ 2
• In the correct order ✓ 1
2.2 Game title field:
1 1
• Text format of Game Title field changed to UPPERCASE ✓
2.3 Name field:
1 1
• Name field size 20 ✓
2.4 Check box field:
1 1
• Check box form field is checked ✓
2.5 Instructions to the signer:
• Please ensure this information is accurate ✓
1 1
2.6 Text watermark:
1
• Text watermark inserted ✓
(Accept horizontal and diagonal.) 1 3
• Text read Registration form ✓
• Must be on the 1st page only ✓ 1
2.7 Tab stops:
• Centre tab inserted on 7 cm ✓ 1
• Right tab 24 cm with leader a solid leader line ✓
• Tab key applied to last line in two places ✓
1
4
1
• Tabs applied to 11 Lines ✓
(Note to the marker: A learner must insert the tab AND 1
insert it in the right place (CM) in order to get one mark.)
Total for QUESTION 2 [13]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
QUESTION 3 File Name: Q3_IDplayer Total Q3: 27
Maximum Candidate
No Criteria
Mark Mark
Q3_IDplayer
Players Worksheet
3.1 Column A:
1 1
• Autofill column A 1 to 50 ✓
3.2 Merged Cell:
• Merged cell includes row 3 ✓ 1 1
(Merged A1:P3)
3.3 Cell D4:
• =MAX(D8:D57) ✓
OR 1 1
• =LARGE(D8:D57,1)
Expected answer: 3961
3.4 Cell G4:
1
=COUNTIFS(H8:H57,">1000",I8:I57,"<=2000")
• Countifs ✓ 1
• Range 1: H8:H57 ✓
1 5
• Criteria 1: “>1000” ✓
• Range 2: I8:I57 ✓ 1
• Criteria 2: “<=2000” ✓
Expected answer: 16 1
3.5 Cell 08:
1
=IF(M8<"20/01/01",IF(E8>=2000,IF(F8<1500,"Yes",""),""),"")
=IF(M8<DATE(2020,1,1),IF(E8>=2000,IF(F8<1500,"Yes",""),""),"") 1
=IF(AND(M8<DATE(2020,01,01),E8>=2000,F8<1500),"Yes","")
1
• 1st Condition ✓ 6
• 2nd Condition ✓ 1
• 3rd Condition ✓
• If true Yes ✓ 1
• If false blank "" ✓
• Used nested if as a AND or Used the AND function ✓ 1
3.6 Cell P8:
1
• Column index number changed from 3 to 2 ✓
• False Changed to True or removed ✓ 1 3
• Sort Lookup Table from small to large according to column A ✓
1
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 9
Travel worksheet
3.7 Cell E4:
1
=IF(C4="Yes",D4+$D$2,D4)
=IF(C4="No",D4,D4+$D$2) 1
• C4="Yes" ✓ 4
• True: D4+$D$2 ✓ 1
• Absolute Cell reference ✓
• False: D4 ✓ 1
Graph Worksheet
3.8 Graph:
• Heading Win vs Losses added ✓ 1
• Vertical (Value) Axis: major units changed to 400.0 ✓
• Fill the highest data label with a red colour ✓
• Q3Chart Picture inserted in the chart area ✓ 1
• 70% Transparency applied to the picture ✓
• Horizontal axis rotated to “Rotate all text 90°” ✓
1
6
1
1
1
Total for QUESTION 3 [27]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
QUESTION 4 File Name: Excel: Q4_Players Total Q4: 16
Maximum Candidate
No. Criteria Mark
Mark
Q4_Players
Ranking Worksheet
4.1 File Header:
• Ranking Worksheet Filename inserted in the centre of 1 1
the header ✓ Field: &[File] Output: Q4_Players
4.2 Conditional Formatting:
1
• Applied to range A4:A26 ✓
• Formula: D4<=5 ✓
1
Or =$D4<=5
Or =$D4:$D26<=5 4
Or =$D4:$D26<6 1
Or =$D4<6
• Absolute cell reference removed, i.e. NOT $D$4 ✓ 1
• Colour fill blue ✓
4.3 Cell E3: 1
=CONCATENATE(MID(A4, FIND(" ", A4)+1 ,1), MID(B4
1
,2,1), C4)
• CONCATENATE ✓ (No mark for &) 1
• MID and A4 ✓
1
• Find the space ✓
1 8
• A4 + 1 ✓ (both for 1 mark)
• 1st Character of the surname ✓ 1
• MID(B4) ✓
• 2nd Character of ID number ✓ 1
• C4 ✓ (Pro or Amateur)
1
Check for building blocks.
4.4 Details worksheet:
1
• Untick locked for cells B2:B4 ✓
• Sheet protected ✓
2
(Note to marker: no password added.
If password added, learner loses second 1
mark)
4.5 Renamed sheet1 to Game ✓ 1 1
Total for QUESTION 4 [16]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 11
QUESTION 5 File Name: Q5_GameStats Total Q5: 34
Maximum Candidate
No. Criteria
Mark Mark
5_1Table
5.1 Table 5_1Table in datasheet view:
1
• Sunken cell effect ✓ 2
• Alternative back colour green ✓ 1
5.2.1 Player ID Field:
1 1
• Primary key added to the Player ID field ✓
5.2.2 PlayerName Field:
1 1
• PlayerName field size 50 ✓
5.2.3 GamesPlayed Field:
• GamesPlayed required field ✓ 1 1
Or Validation rule: Is NOT Null
5.2.4 Distance traveled Field:
1
Validation rule added:
• Between 30 ✓ And ✓ 500 ✓ 1 3
or >=30 And <=500
or >29 And <501 1
5.2.5 Skins Field:
• Skins format changed to true/false ✓ 1 1
(default was yes/no)
Qry5_3 Query
5.3 • Totals activated in Design view ✓ 1
• Avg Frequency of logins ✓ 1 3
• Formatted to 0 decimal places ✓
1
Qry5_4 Query
5.4 AccountAge:(Date()-[Date of account creation])/30 1
Or AccountAge: (Date()-[Date of account
creation])/365.25*12 1
• Calculated field called AccountAge Added. ✓ 1
5
• Date() ✓
1
• Subtraced and used [Date of account creation]. ✓
• Correct use of brackets ✓
1
• /30 ✓ Or /365.25*12.
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
12 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
Qry5_5 Query
5.5 • >30000 on the followers column ✓
• Display only the username ✓ 1
• Sort username in decending order ✓
• [Experience]< [Score] ✓ on correct fields ✓
1
OR 1 5
OR 1
1
Frm5_6 Form
5.6 • Geographic location text box 1
changed to a combo box ✓
• Q5_6 table used as row source ✓ 1
• Button inserted ✓
1 5
• Operation to close the
form ✓ 1
• Used 5_6Close picture for button ✓
1
Rpt5_7 Report
5.7 • Heading changed in the report header to "Total followers 1
per country" and centred across the page ✓
• Grouped according to geographical location ✓ 1
• Moved the field geographical location to the group 1
header ✓
• Calculated field added to the group footer of geographical 1 7
location ✓ 1
• =Sum ✓ ([Followers]) ✓
1
• Formatted the field geographical location to any grey
background colour ✓ 1
Total for QUESTION 5 [34]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
(EC/SEPTEMBER 2024) COMPUTER APPLICATIONS TECHNOLOGY P1 13
QUESTION 6 File Name: Q6_1ESport, Q6_2Ranking Total Q6: 13
Maximum Candidate
No Criteria
Mark Mark
6.1.1 Tab Name:
<title> Esport </title> 1 1
• Both <title> and </title> added on the correct place ✓
6.1.2 Dota 2 TI10 heading:
<font size="10" color="red"><marquee>Dota 2 1
TI10</marquee> </font> 2
• Added font size of 10 ✓
1
• Changed colour to color ✓
6.1.3 List of events of 2023 heading:
<font face = "arial"> 1 1
• Changed type to face ✓
6.1.4 Bullet list:
<ol type="A">..</ol> 1
• Changed the <ul> to <ol> and </ul>
to </ol> ✓ 1 3
• Type = "A" ✓
• Closing tag of first list item changed
from <li> to </li> ✓ 1
6.1.5 Name No Tail:
<td valign = "Middle" align = "center">No 1
Tail</td> 2
• <td valign = "Middle" ✓
1
• align = "center" ✓>No Tail</td>
6.2.1 Team Liquid picture:
<img src ="Q6PIC/TL.jfif" 1 1
• TL.png changed to TL.jfif ✓
6.2.2 Stats heading:
<th colspan="4">Stats</th> 1
2
• Colspan = 4 ✓
1
• Correct position: inserted in the <th> tag ✓
Closing tags, nesting done correctly ✓ 1 1
Total for QUESTION 6 [13]
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Downloaded from hlayiso.com
14 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2024)
QUESTION 7 File Name: Q7_Cardtype, Q7_Data, Q7_MergeLetter Total Q7: 11
Maximum Candidate
No Criteria
Mark Mark
7.1.1 Q7_MergeLetter:
1 1
• Both track changes accepted ✓
7.1.2 Q7_MergeLetter:
• Correct source “Q7_CardType.docx” used ✓ 1
• Only the visa card type ✓
• Replaced the name and surname fields ✓
1
4
1
• Merged completed & Saved as Q7Merged ✓
1
9 completed letters expected in Q7Merged.
7.2.1 Q7_Data file IP worksheet:
• Data validation applied to Colum E gender ✓
• Only male and female accepted ✓ 1
2
1
7.2.2 Dup worksheet:
1 1
• All dup removed 50 records left ✓
7.2.3 Company worksheet:
1
• At each change in: Type of company ✓
• Use function: Count used ✓ 1 3
• Add subtotal to: Type of company ✓
1
Total for QUESTION 7 [11]
TOTAL: 150
Copyright reserved Please turn over
Hosted by www.ecexams.co.za.
Study this subject
Recommended for this subject

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

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

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

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

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

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

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

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

Errata
Computer Applications Technology Grade 12 P1 2022 Errata

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

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

Question paper