Skip to content

Computer Applications Technology Grade 12 P1 2024 Memo (Eng)

MemorandumComputer Applications TechnologyGrade 12202414 pages

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.

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.
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.
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

More from Grade 12 Computer Applications Technology

View all