# Computer Applications Technology Grade 12 P1 2023 Memo (Eng) > Grade 12 Computer Applications Technology Paper 1 memorandum from the Eastern Cape Mock Exam 2023 (English), 10 pages. Read online or download the free PDF. - Page: https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2023-english/c051da94-a46b-4633-9775-ef502f51eafe - Updated: 2026-09-27 - Subject: Computer Applications Technology - Grade: Grade 12 - Language: English - Document type: Memorandum - Year: 2023 - Exam period: Eastern Cape Mock Exam - Paper: 1 - Curriculum: CAPS - Pages: 10 Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Computer Applications Technology](https://www.hlayiso.com/library/grade-12/computer-applications-technology) › [Computer Applications Technology Grade 12 P1 2023 Memo (Eng)](https://www.hlayiso.com/library/cat-p1-memo-gr12-sept-2023-english/c051da94-a46b-4633-9775-ef502f51eafe) ## About this document Computer Applications Technology · Grade 12 · Eastern Cape Mock Exam · 2023 · English. Memorandum, 10 pages. Read online or download the PDF. Read it free online on the page above; download the PDF from there. ## Document text Text extracted from the PDF. Layout, diagrams and tables may not survive extraction. ### Page 1 NATIONAL SENIOR CERTIFICATE GRADE 12 SEPTEMBER 2023 COMPUTER APPLICATIONS TECHNOLOGY P1 MARKING GUIDELINE NAME OF CANDIDATE: GRADE: SIGNATURE OF EDUCATOR: TOTAL Q1 Q2 Q3 Q4 Q5 Q6 MARKS: 150 27 13 44 31 21 14 This marking guideline consists of 10 pages. ### Page 2 2 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 1 File Name: 1_10 biggest dams in South Africa Total Q1: 27 Maximum Candidate No. Criteria Mark Mark 1.1.1 Textbox • Text box inserted. ✓ 1 3 • Filled with gradient fill. ✓ 1 • Linear down fill used. ✓ 1 1.1.2 Textbox/Size • Height = 3 cm and width = 15 cm ✓ 1 1 1.1.3 Textbox/Border 1 • Textbox border red ✓ 2 1 • and 3pt ✓ 1.2 Find and replace • All occurrences of ‘Mzansi’ replaced by South Africa 1 2 (2 occurrences) ✓ 1 • South Africa is in small caps ✓ 1.3 Captions • Caption inserted ✓ 1 • New label ‘Picture’ created. ✓ 1 4 • Caption displays below the picture. ✓ 1 • The other two pictures have captions with label 1 Picture 2 and Picture 3 ✓ 1.4 Style 1 • Style modified to be bold ✓ 2 1 • Style modified to font size 19 ✓ 1.5 Paragraphs • Heading, image and paragraph together moved to 1 2 next page. ✓ 1 • Keep with next checked ✓ 1.6 Citation 1 • Website source used ✓ 1 3 • Name of website added ✓ 1 • URL added ✓ 1.7 Synonym • Beach, shore, coastline, seashore or oceanfront 1 1 replaced shoreline ✓ 1.8 Watermark 1 • ‘Top dams in SA’ changed to any WordArt ✓ 1 3 • Button (Curve) shape used ✓ • Font type changed to Arial Narrow. ✓ 1 1.9 Page numbering ` • Circle page numbering used ✓ 1 • On the footer ✓ 1 4 • Odd pages set on left ✓ 1 • Even pages set on right ✓ 1 Total for QUESTION 1 [27] Copyright reserved Please turn over ### Page 3 (EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 3 QUESTION 2 File Name: 2_Brochure Total Q2: 13 Maximum Candidate No. Criteria Mark Mark 2.1 Page Colour 1 • Brochure filled with any colour ✓ 1 3 • Brochure filled with two colour gradient fill ✓ 1 • Red and Orange are colours used ✓ 2.2 Picture 1 • The other picture is deleted/replaced. ✓ 1 3 • Picture replaced with ‘2_Logo’ picture. ✓ • The image is stretched to fill the space provided. ✓ 1 2.3 Controls 1 • SA Dams inserted in the company name control ✓ 1 2.4 Date 1 • Date field inserted ✓ 2 1 • Formatted MMMM yyyy ✓ 2.5 SmartArt • SmartArt inserted ✓ 1 • Basic Pie Relationship SmartArt used ✓ 1 3 • The three names of the dams inserted in the 1 SmartArt ✓ 2.6 Font • Font of ‘3 Sterkfontein Dam’ paragraph is changed 1 1 to be like the first two paragraphs ✓ Total for QUESTION 2 [13] Copyright reserved Please turn over ### Page 4 4 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 3 File Name: 3_Dams Total Q3: 44 Maximum Candidate No. Criteria Mark Mark 3 _Dams Worksheet 3.1 Cells A1:N2 1 • Cell A1 to N2 merged and ✓ 2 1 • data centred vertically ✓ 3.2 Cell A3 1 1 • =Now() ✓ 3.3 Cell A5: =CONCATENATE(D5;LEFT(B5;3);RANDBETWEEN 1 (100;999)) • Concatenate function ✓ 1 5 • D5 ✓ 1 • Left(B5;3) ✓ • Randbetween function ✓ 1 • (100;999) ✓ 1 3.4 Cell C56 =SMALL(C5:C54;1) 1 3 • Correct function used. Small ✓ 1 • Correct range used – C5:54 ✓ ;2 ✓ 1 3.5 Cell F58: =COUNTIF(F5:F54; "Eastern Cape") 1 3 • Correct function used ‘Countif’ ✓ 1 • Correct range (F5:F54) ✓ 1 • Correct criteria ‘Eastern Cape’ ✓ 3.6 Cell H6 Countifs 1 =COUNTIFS(F5:F54;"Free State";H5:H54;">500") 1 • Function: Countifs ✓ • Criteria range 1 : F5:F54 ✓ 1 5 • Criteria 1 : “Free State” ✓ 1 • Criteria range 1 : H5: H54 ✓ • Criteria 2 : ‘>500” ✓ 1 3.7 Cell J62 Sumif =SUMIF(F5:F54;"Eastern Cape";J5:J54) 1 • Sumif function used ✓ 4 1 • Criteria range : F5 : F54 ✓ • Criteria : “Eastern Cape” ✓ 1 • Sum range : J5:J54 ✓ 1 Copyright reserved Please turn over ### Page 5 (EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 5 3.8 Cell J64 Nestedif statement 1 =IF(J5>4000000;"BIG DAM";IF(J5<1000000;"SMALL DAM";"NORMAL DAM")) 1 • Nested if function used ✓ 1 5 • Criteria 1: J5>4000000 ✓ • Criteria 2: J5<1000000 ✓ 1 • Correct output: for both criteria ✓ • Criteria output if false ✓ 1 3.9 Conditional formatting 5 • Conditional formatting feature use ✓ 1 1 • Correct formatting style: Icon Sets ✓ 1 • Correct Icon style: 3 Symbol uncircled indicator ✓ 1 • Icon if value greater than 80 ✓ 1 • Icon if value less than 40 ✓ 3.10 Subtotal • Applied to “Province” ✓ 1 3 1 • Function: Average ✓ 1 • Add subtotal to Capacity field ✓ 3.11 Graph • Correct data used ✓ 1 • 3D Column Clustered graph used ✓ 1 • Column Shape cone used ✓ 1 • Axis title named correctly ✓ 1 8 • Chart title named correctly ✓ 1 • Chart area fill done ✓ 1 • Correct picture (3_Map of SA Dams) used to fill 1 chart area ✓ 1 • Moved to new sheet called My Graph ✓ Total for QUESTION 3 [44] Copyright reserved Please turn over ### Page 6 6 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 4 File Name: 4_SA Top 50 Dams Total Q4: 31 Maximum Candidate No. Criteria Mark Mark Table: Magazine Compilers 4.1.1 • Field size for Surname field set to 50 ✓ 1 1 4.1.2 • Vertical gridlines are visible. ✓ 1 1 4.1.3 • IDNO field set to required Yes ✓ 1 1 4.1.4 • E-mail field set to < in format field ✓ 1 1 4.1.5 Input mask on the Password field: LL-009-"WORD" • LL ✓ 1 • -✓ 1 • 00 ✓ 1 6 1 • 9✓ 1 • -✓ 1 • “WORD” ✓ 4.2.1 • Conditional formatting ✓ 1 • Applied to the Capacity field ✓ 1 3 • All values less than 3 Million display in a red font ✓ 1 4.2.2 • Function inserted in the form footer ✓ 1 2 • Displays the current date =date() ✓ 1 4.3 Qry4_3 • Date field inserted ✓ 1 4 • Date field does not show ✓ 1 • Criteria for Date field – “<1970” ✓ 1 • Criteria Eastern Cape in Province field ✓ 1 Expected answer: 3 records 4.4 Qry4_4 1 • Add a totals function ✓ 1 3 • Group by Dam field ✓ 1 • Sum by Capacity field ✓ Copyright reserved Please turn over ### Page 7 (EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 7 4.5 Report 1 • Report created called rpt4_5 ✓ 1 • Dam, Province, River and Capacity fields ✓ 1 • Grouped according to the Province field ✓ 1 • Sort according to River field ✓ 1 9 • Calculation in the Province footer ✓ • =sum ([Capacity_10³ m³]) ✓ 1 • In report footer ✓ 1 • =count(*) ✓ 1 • Labels removed ✓ 1 Total for QUESTION 4 [31] Copyright reserved Please turn over ### Page 8 8 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 5 File Name: 5_Dams Total Q5: 21 Maximum Candidate No. Criteria Mark Mark 5.1 Big dams in South Africa 1 1 • Title tag inserted ✓ 5.2

The Big Dams

• Heading 1 applied to the text ✓ 1 2 1 • Text centred ✓ 5.3 Background colour 1 1 • Entire web page background is pink ✓ 5.4
• hr/ tag used ✓ 1 2 • Colour of the line set to green ✓ 1 5.5 • Correct picture used ✓ 3 1 • Both height and width set at 200 ✓ 1 • Picture aligned to the right ✓ 1 5.6 List • Change the unordered list tag (ul) to ordered list 1 1 tag (ol) ✓ Copyright reserved Please turn over ### Page 9 (EC/SEPTEMBER 2023) COMPUTER APPLICATIONS TECHNOLOGY P1 9 5.7 Table 6
1 No Name of Dam Town Capacity 10³ m³
1 Free State dam Norvals Point 5342932
5 PongolapoortPongola 2267068
• Table border = 3 ✓ 1 • Table width set at 100% ✓ 1 1 • Cellspacing = 5 ✓ 1 1 • Free state dam replaced with Gariep ✓ 1 • Header row filled with green and ✓ • rest of table filled with yellow ✓ 5.8 Links About the picture • Hyperlink inserted ✓ 1 4 • Hyperlink tag used – a href ✓ 1 1 • To correct text – About the picture ✓ 1 • Links to the correct picture 5_Dam Picture.jpg ✓ Closing tag(s) and nesting correctly used ✓ 1 1 Total for QUESTION 5 [21] Copyright reserved Please turn over ### Page 10 10 COMPUTER APPLICATIONS TECHNOLOGY P1 (EC/SEPTEMBER 2023) QUESTION 6 File Name: 6_Certificate of Achievement Merge’ document ‘6_Merge Spreadsheet Total Q6: 14 Maximum Candidate No. Criteria Mark Mark 6.1.1 Shapes • Wave shape replaced ✓ 1 1 • Replaced by basic sun shape ✓ 1 4 • Alt text of picture is Shape ✓ 1 • Alt description is Basic Sun Shape ✓ 6.1.2 Tabs stops • First tab stop o Position at 4 cm and alignment right ✓ • Second tab stop 1 5 o Position at 19 cm and alignment left ✓ 1 • Third tab stop 1 1 o Position at 24 cm and no alignment right ✓ 1 • Leader for first ✓ and second stops : Solid line ✓ 6.1.3 Merge letters • Mail Merge feature used ✓ • Surname and name fields replaced ✓ 1 1 • Only learners who were regulars in attending 1 meetings received letters. ✓ 5 1 • Correct data source used – ‘6_Merge Spreadsheet’ ✓ 1 • Merged letters saved as 6_Merged ✓ (8 certificates) Total for QUESTION 6 [14] TOTAL: 150 Copyright reserved Please turn over ## Related documents - [CAT P1 GR12 MEMO SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2020-english/fe852a1d-d162-4072-a9a0-fa24c6d26774) — Computer Applications Technology · Memo · 2020 · Eng - [CAT P1 GR12 MEMO SEPT 2019 English](https://www.hlayiso.com/library/cat-p1-gr12-memo-sept-2019-english/ef2df5b1-6950-4769-9979-f22d14b986c1) — Computer Applications Technology · Memo · 2019 · Eng - [CAT P1 QP GR12 SEPT 2022 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2022-english/2c41f16c-52dc-4d98-a4a4-e3296512bace) — Computer Applications Technology · QP · 2022 · Eng - [CAT P1 GR12 QP SEPT 2020 English](https://www.hlayiso.com/library/cat-p1-gr12-qp-sept-2020-english/6e7f27db-454b-4095-a4e8-522ceffa7412) — Computer Applications Technology · QP · 2020 · Eng - [CAT P2 GR12 MEMO SEPT2019 English](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2019-english/be90bdf5-3d2f-40b0-8dfd-16e7142e74e6) — Computer Applications Technology · Memo · 2019 · Eng - [CAT P2 GR12 MEMO SEPT2017 (English)](https://www.hlayiso.com/library/cat-p2-gr12-memo-sept2017-english/c01cc76d-6be5-4f8e-b0dd-c7487e06934f) — Computer Applications Technology · Memo · 2017 · Eng ## More from Grade 12 Computer Applications Technology - [CAT P2 GR12 QP September 2025 ENG watermark](https://www.hlayiso.com/library/cat-p2-gr12-qp-september-2025-eng-watermark/fd63d968-a454-409d-9293-0862b56232b1) — QP · 2025 · Eng - [CAT P1 QP GR12 SEPT 2024 English](https://www.hlayiso.com/library/cat-p1-qp-gr12-sept-2024-english/bf2518c3-ae79-4251-8145-1b062895b12f) — QP · 2024 · Eng - [CAT P2 GR12 QP SEPT 2024 English](https://www.hlayiso.com/library/cat-p2-gr12-qp-sept-2024-english/b8b0a9f3-f8c6-4f0a-8ddf-30b58008b603) — QP · 2024 · Eng - [Computer Applications Technology P1 Nov 2024 Afr](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2024-afr/502fe6df-4d11-41d1-8e23-b219565e715b) — QP · 2024 · Afr - [Computer Applications Technology P1 Nov 2023 Eng](https://www.hlayiso.com/library/computer-applications-technology-p1-nov-2023-eng/60311585-04c7-46dc-bcf6-87da09dc1ea5) — QP · 2023 · Eng - [ERRATA CAT P1](https://www.hlayiso.com/library/errata-cat-p1/363f4b7e-98be-46d4-9d47-fcfea8705198) — Errata · 2022 ## Collection - [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers) --- Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.