COPA Trade Practical: Assembly, Installation, Office Tasks and Configuration
What the practical paper checks
Trade Practical tests procedures you can describe step by step: PC assembly and disassembly, operating-system installation, productivity-software tasks, internet and email configuration, and fault finding. Answers are judged on the order of steps, correct menu and tool names, and safety practice.
Procedures worth memorising
- Assembly: unplug the SMPS and discharge static; seat the CPU by its alignment notch, apply thermal paste, fit the heatsink; press RAM until the clips click; connect the 24-pin ATX, 4/8-pin CPU, SATA data and SATA power; power on and watch POST.
- OS install: set boot order in BIOS/UEFI, boot from media, partition, format NTFS, install, then drivers and updates.
- Word: styles for headings, page setup, and mail merge as main document plus data source plus merge fields.
- Excel: every formula starts with =; functions SUM, AVERAGE, COUNT, IF, VLOOKUP; the $ sign fixes a reference.
- Email client: incoming IMAP 993 or POP3 995, outgoing SMTP 587 (STARTTLS) or 465 (SSL).
Worked example
A result sheet holds theory marks in B2 and practical marks in C2. Enter =IF(AND(B2>=33,C2>=33),"PASS","FAIL"). Read inside out: with B2 = 41 and C2 = 28, B2>=33 is TRUE while C2>=33 is FALSE; AND needs both TRUE, so it returns FALSE; IF therefore prints FAIL. Text results need double quotes, and the formula is copied down, never retyped.
Marks lost here
Omitting the leading = so the entry stays text; dragging a formula without locking the lookup range with $; starting a mail merge before the data-source headers match the merge fields; forgetting to save the data source; naming SATA where the question asks about power connectors; skipping the static-discharge step before touching RAM.