Computer Applications Technology Grade 12 P1 NSC June 2024 Memo

SENIOR CERTIFICATE EXAMINATIONS/ NATIONAL SENIOR CERTIFICATE EXAMINATIONS COMPUTER APPLICATIONS TECHNOLOGY P1 MAY/JUNE 2024 MARKING GUIDELINES MARKS: 150 CENTRE- FINAL MARK NUMBER [Grab your reader’s attention with a EXAMINATION great quote from the document or NUMBER use this space to emphasize a key point. To place this text box anywhere on the page, just drag it.] QUESTION 1 2 3 4 5 6 7 TOTAL POSSIBLE MARK 26 19 19 21 35 15 15 150 CANDIDATE'S MARK MARKER'S CODE/ SIGNATURE MODERATED MARK These marking guidelines consists of 15 pages. Copyright reserved Please turn over

Computer Applications Technology/P1 2 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER Check the accuracy and skill required before awarding a mark throughout. QUESTION 1 File name: 1Zoo Total Q1: 26 Maximum Candidate No. Criteria Mark Mark 1.1 Hyphenation 1 • Automatic hyphenation applied ✓ 1 1.2 Cover Page 2 • Cover page inserted: Slice (Light) ✓ 1 • Only Title and Subtitle controls display AND other controls removed ✓ 1 1.3 Heading 1: Text effect and Character spacing 3 • Character spacing: Expanded by 3 pt ✓ 1 • Text effect: 3-D format: Top bevel: ✓ 5 pt height ✓ 2 1.4 Header: Date field 3 • Date field inserted in the header ✓ 1 • Header: Year right aligned ✓ 1 • Format: YYYY ✓ (Accept yyyy) 1 Alt+F9: { DATE \@ "YYYY" \* MERGEFORMAT } 1.5 Footnote 2 • Layout: 3 columns ✓ 1 • Numbering format: i, ii, iii, … ✓ 1 1.6 Paragraph setting: Pagination Page Break: Did you 1 know? • Pagination: Page break before ✓ 1 (Note to marker: Do NOT accept a forced Page Break) 1.7 Table: Below Prices start from 4 • Text modified to display in one table ✓ 1 • Appear as the example ✓ 1 • Last row merged with correct text ✓ 1 • Cell spacing: 1 cm ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 3 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 1.8 Track changes: Above Emergency contact info 1 • Track changes: Accepted ✓ 1 (Note to marker: No text appears between the table, ending with '…, first served basis' and the heading 'Emergency contact info') 1.9 Tab settings: All life threatening … 2000 ext. 230 3 • Tab stop position: 7 cm ✓ 1 • Alignment: Bar ✓ 1 • Tabs applied to text as shown below ✓ 1 1.10 Table of Figures 2 • Table of Figures inserted ✓ 1 • No page numbers ✓ 1 Alt+F9: { TOC \n \h \z \c "Figure" } 1.11 Find and Replace: 'Johannesburg Zoo' replaced with 4 'JHB ' • Replacement text: 'JHB' ✓ 1 • Red ✓ Webdings symbol: 246 () ✓ 2 • Only Johannesburg Zoo replaced ✓ 1 (Note to marker: 6 occurrences) Total for QUESTION 1 [26] DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 4 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER Check the accuracy and skill required before awarding a mark throughout. QUESTION 2 File name: 2Adoption Total Q2: 19 Maximum Candidate No. Criteria Mark Mark 2.1 Page layout: Margins 2 • Top margin: 2 cm ✓ 1 • Gutter position: Left ✓ 1 2.2 Page Numbering in footer 3 • Format: Outline circle ✓ 1 • 'Different Odd & Even Pages' selected ✓ 1 • Position of even page numbers: Right side ✓ 1 2.3 Synonym: Endangered 1 • Endangered changed a one-word synonym to: rare ✓ /scarce/threatened/vanishing/imperilled 1 2.4 Drop Cap: List 2 • Drop cap applied: In margin ✓ 1 • Distance from text: 0.5 cm ✓ 1 2.5 Multi-level list: Below Type of adoption … 3 • First level • Numbering Style: 1st, 2nd, 3rd, … ✓ 1 • Text indent at: 1 cm ✓ 1 • Second level • Numbering: 1, 2, 3, …✓ 1 2.6 Hyperlink: E-mail address 1 • Linked to e-mail address: mailto:anna@cityzoo.org.za ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 5 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 2.7 Tiger Picture and Callout Shape 3 • Callout shape appears (modified and white fill) ✓ 1 • Text 'Adopt Me!' inserted ✓ (and visible) 1 • Callout shape and image grouped ✓ as one object 1 2.8 Form Controls 4 • Drop down item added: Blank option ✓ 1 • Blank option appears as the first item in option list ✓ 1 • Payment Amount field: Number format: R ✓ 1 • Cellphone Number field: Default: +27 ✓ 1 Total for QUESTION 2 [19] DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 6 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 3 File name: 3Budget Total Q3: 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). • Candidate 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 values are changed in the existing data. Maximum Candidate No. Criteria Mark Mark Budget worksheet 3.1 Tab colour 1 • Tab colour: Any orange colour ✓ 1 3.2 Page Setup: Page and Sheet 2 • Correct area: A1:I59 ✓ 1 • Scaling: Fit to: 1 page wide by 1 page tall ✓ 1 3.3 Cell E3: 5 =SUMIFS(G7:G59,D7:D59,"Mammals",F7:F59, ">=2016/01/01") OR =SUMIFS(G7:G59, F7:F59,">=2016/01/01", D7:D59,"Mammals") OR =SUMIFS(G7:G59,D7:D59,"Mammals",F7:F59, ">2015/12/31") OR =SUMIFS(G7:G59, F7:F59,">2015/12/31", D7:D59,"Mammals") • SUM range: G7:G59 ✓ 1 • Criteria range 1: D7:D59 ✓ 1 • Criteria 1: "Mammals" ✓ 1 • Criteria range 2: F7:F59 ✓ 1 • Criteria 2: ">=2016/01/01" ✓ OR ">2015/12/31" 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 7 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 3.4 Column H: Conditional formatting 3 • Icon: Flag order: Red, Yellow, Green ✓ 1 • Second condition value: >=10000 ✓ 1 • Second condition type: Number ✓ 1 Red Yellow Green 3.5 Cell I7: 4 =SUM(G7*12,H7)*0.0225+SUM(G7*12,H7) OR =SUM(G7*12,H7)*2.25/100+SUM(G7*12,H7) OR =SUM(G7*12,H7)*1.0225 OR =(((G7*12)+H7)*2.25/100)+(G7*12)+H7 OR =SUM(G7*12,H7)*2.25%+SUM(G7*12,H7) • Determine annual amount of Food budget (G7*12) ✓ 1 • Add Grooming budget to Food budget (H7) ✓ 1 • Calculate 2.25% of existing amount ✓ 1 • Add percentage to existing amount ✓ 1 Totals worksheet 3.6 • Data labels: 4 • Percentage ✓ 1 • Separator: (space) ✓ 1 • Grass/Hay slice: • Angle of first slice: ± 80° ✓ (70° - 90°) 1 • Explosion ✓ (accept any %) 1 Total for QUESTION 3 [19] DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 8 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 4 File name: 4Excursions Total Q4: 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). • Candidate 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 values are changed in the existing data. Maximum Candidate No. Criteria Mark Mark 4.1 Worksheet moved 1 • Trip worksheet appears before Q4_6 worksheet ✓ 1 Trip worksheet 4.2 Cell C3: 3 =COUNTIF(E7:E153,"EC") • Function: COUNTIF ✓ 1 • Cell range: E7:E153 ✓ 1 • Criteria: "EC" ✓ 1 4.3 Cell G3: 1 =MODE(H7:H153) • Function and cell range: MODE(H7:H153) ✓ 1 4.4 Cell D7: 5 =CONCATENATE("+27 ",RIGHT(C7,9)) OR =CONCATENATE("+27"," ",RIGHT(C7,9)) OR ="+27 "&(RIGHT(C7,9) OR ="+27"&" "&MID(C7,2,LEN(C7)) OR =CONCATENATE("+27 ",VALUE(C7)) • Strings combined: CONCATENATE OR & ✓ 1 • Text: "+27" ✓ 1 • Two spaces added: " " OR "+27 " ✓ 1 • Text copied from column C using MID and LEN OR the RIGHT OR VALUE function ✓ 1 • All characters copied from character 2 ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 9 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 4.5 Cell F13: 3 =ROUNDUP(G13/30,0) • Function: ROUNDUP(…,0) ✓ 1 • G13 ✓ 1 • /30 ✓ 1 4.6 Column H: Data Validation 3 • Data validation setting: Start Date: 2023/12/01 ✓ 1 • Screenshot of cells H5:H30 pasted in worksheet Q4_6 ✓ 1 • Circle invalid data feature applied✓ 1 4.7 Cell I12: 5 =IF(OR(Day(H12)=9,DAY(H12)=16),"Badge","") OR =IF(OR(H12=DATE(2023,12,9), H12= DATE(2023,12,16)),"Badge" ,"") • Correct syntax/logic used: =IF(OR(…), ... , …) ✓ 1 • Criteria 1: H12=DATE(2023,12,9) ✓ 1 • Criteria 2: H12=DATE(2023,12,16) ✓ 1 • Output if Date is TRUE: "Badge" ✓ 1 • Output if both criteria is FALSE: "" ✓ 1 Total for QUESTION 4 [21] DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 10 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 5 File name: 5Animals Total Q5: 35 Maximum Candidate No. Criteria Mark Mark Table: tbI5_1 5.1.1 Field: KeeperName 1 • Required: Yes ✓ 1 5.1.2 Field: Time 2 • Data type: Date/Time ✓ 1 • Format: Short Time/00\:00 ✓ 1 5.1.3 Field: Enclosure: Validation Rule AND Text 3 • Validation Rule: "Habitat" Or "Exhibit" • Habitat ✓ 1 • Or Exhibit ✓ 1 • Validation Text: Only Habitat or Exhibit ✓ 1 5.1.4 Field: AccessCode: Input mask 4 L"@"0000C OR L\@0000C • L✓ 1 • @✓ 1 • 0000 ✓ 1 • C✓ 1 5.1.5 Field: NextFeed 1 • Field deleted ✓ 1 Form: frm5_2 5.2.1 Field: Group 5 • Row Source: "Carnivore", "Herbivore", "Omnivore" ✓ 1 • Row Source Type: Value list ✓ 1 5.2.2 Calculation • Formula: =[Lifespan] ✓ >25 ✓ 2 • Format: Yes/No ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 11 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER Query: qry5_3 5.3 • Only Animal and Status fields display ✓ 1 3 • Origin criteria: Africa ✓ 1 • Group criteria: Carnivore ✓ 1 (Expected number of records: 8) Query: qry5_4 5.4 • Status criteria: 'Endangered'✓ / '*Endangered' 1 4 • Lifespan criteria: <20 ✓ OR <=19 1 • Population criteria: Is Null ✓ 1 • OR+AND logic correctly used ✓ 1 (Expected number of records: 38) Query: qry5_5 5.5 • Fields: Lifespan and Group ONLY ✓ 1 5 • Group field Totals row: Group by ✓ 1 • Lifespan field Totals Row: Avg ✓ 1 • Format: Standard ✓ /Fixed (Property Sheet) 1 • Decimal Places: 1 ✓ (Property Sheet) 1 Report: rpt5_6 5.6 • Report named rpt5_6 created ✓ 1 7 • Fields: Animal, Origin, Status, Behaviour, Adapt, Group ✓ 1 • Layout: Columnar ✓ 1 • Group field: • Label removed ✓ 1 • Textbox moved ✓ and border added ✓ 2 • 5ZooLogo image inserted in Details section ✓ 1 Total for QUESTION 5 [35] DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 12 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 6 File names: 6_1Advert, 6_1Nav, 6_2Fees 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 6_1Advert 6.1.1 Title tags 1 <title>Membership</title> • Title tags inserted ✓ 1 6.1.2 Background colour 1 <body bgcolor="bisque"> • Attribute: bgcolor="bisque" ✓ 1 6.1.3 Horizontal line 1 <hr width="70%"/> • <hr> tag inserted ✓ 1 6.1.4 Italic tags 1 <i>Zoo animals are … </i> • Italic tags inserted ✓ 1 6.1.5 Hyperlink 3 <a href ="6_1Nav.html">Map</a> • Anchor tags inserted: <a href …> … </a> ✓ 1 • Links to 6_1Nav.html file ✓ 1 • Link to the word 'Map' ✓ 1 6_1Nav 6.1.6 Image 2 <br/><br/><br/><br/>   <img src="6Map.gif" alt ="Zoo-map"> </center>  File extension of the image: gif ✓ 1  Attribute: alt="Zoo-map" ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 13 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 6_2Fees Table 5 <head> <title>Membership</title> </head> <body> <center>  <br/> <br/> <p><font size="+3">Membership Fees</font></p> <table border="3"> <tr>  <th colspan="2">Prices</th> </tr> <tr> <td>Adult</td> <td>R820</td> </tr> <tr> <td>Child:4 years and older</td>  <td>R300</td> </tr> <tr> <td>Child:3 years and younger</td> <td>FREE</td> </tr> <tr>  <td>Pensioner</td> <td>R500</td> </tr> <tr> </table> </center> </body>  Contents centred: <center> …</center> OR 1 <p align="center"…> and <table align="center"…> ✓  Border size: "3" ✓ (Accept "4" or "5") 1  Colspan="2" ✓ 1  Text: R300 inserted ✓ 1  Open and close cell tags: <td> … </td> ✓ 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 14 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER QUESTION 7 File names: 7Reproduction, 7AccessCard, 7Merged Total Q7: 15 7Pics (folder) Maximum Candidate No. Criteria Mark Mark 7Pics 7.1 File management 2 • Q7_1 file renamed to Lions ✓ 1 • Folder compressed ✓ 1 7Reproduction: Q7_2 7.2 Filter: Filter according to different criteria 2 • Species: Text Filter: Contains: bear ✓ 1 • Reproduction in Captivity: Filter: Very Easy ✓ 1 (Expected number of results: 2) 7Reproduction: Q7_3 7.3 Unique values display 1 • Remove Duplicates applied ✓ 1 (Expected results: 10 unique mating systems) 7Reproduction: Q7_4 7.4 Subtotal 4 • Reproduction in captivity: Sorted alphabetically ✓ 1 • At each change in: Reproduction in captivity Voorplanting in aanhouding ✓ 1 • Function used: Max ✓ 1 • Subtotal added to: Max.Maks. ✓ 1 DBE Stamp Copyright reserved Please turn over

Computer Applications Technology/P1 15 DBE/May/June 2024 SC/NSC – Marking Guidelines EXAMINATION NUMBER 7AccessCard, 7MemAccess and 7Merged 7.5.1 Mail merge 5 SELECT * FROM "Info" WHERE "DateJoined">= #2000/01/01# And "DateJoined"<=#2020/12/31# OR >#2019/12/31# And <#2021/01/01 • 7AccessCard linked to data source 7MemAccess ✓ 1 • Data source DateJoined Greater than or equal to: 2000/01/01 ✓ 1 (Greater than 2019/12/31) AND ✓ 1 DateJoined Less than or equal to: 2020/12/31 ✓ 1 (Less than 2021/01/01) • Fields inserted: <<Name>> <<Surname>> <<ID Number>> ✓ 1 (Expected number of records: 37) 7.5.2 Merged document 1 • Merged document saved as 7Merged ✓ 1 (Note to marker: Ignore blank access card at the end of the merged document) Total for QUESTION 7 [15] TOTAL 150 DBE Stamp Copyright reserved