Skip to content

Computer Applications Technology Grade 12 P1 2024 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12202415 pages

Grade 12 Computer Applications Technology Paper 1 memorandum from the November 2024 NSC (English), 15 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
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
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

More from Grade 12 Computer Applications Technology

View all