RBSE VU IT and ITeS cheat sheet
RBSE VU IT and ITeS · Keep the key ideas within reach.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.
Information Technology Fundamentals and Computer Systems
CPU cycle: fetch → decode → execute → store; clock speed (GHz) sets cycles per second, cores allow parallel instruction streams.
Primary memory is volatile (RAM, cache, registers); secondary storage (HDD, SSD, optical, flash) is non-volatile and retains data without power.
Storage units scale by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB.
Input devices send data to the computer (keyboard, mouse, scanner, mic); output devices present results (monitor, printer, speaker, projector).
System software = operating system, device drivers, utilities; application software = word processor, spreadsheet, browser, media player.
OS functions: process management, memory management, file system management, device management, and user interface (CLI or GUI).
Open-source software publishes source code under licences such as GPL or MIT; proprietary software restricts modification and redistribution.
IPOS cycle describes any task: Input → Processing → Output → Storage; identify the stage to diagnose where a fault occurs.
Hardware vs software fault rule: if the same file fails on two machines it is likely software/data; if one machine fails on all files, suspect hardware.
Office Productivity Software (Word Processing, Spreadsheets, Presentations)
Word processor file formats: .docx (editable document), .pdf (fixed layout), .txt (plain text, no formatting), .rtf (cross-platform rich text).
Styles in a word processor apply consistent fonts and enable automatic table of contents, headings navigation, and cross-references.
Track Changes plus Comments support review cycles; Accept/Reject each change before finalising the document.
Spreadsheet cell reference types: relative (A1) shifts on copy; absolute ($A$1) is fixed; mixed ($A1 or A$1) fixes only row or column.
Core spreadsheet functions: SUM(range), AVERAGE(range), COUNT (numbers only), COUNTA (non-empty), IF(condition, value_if_true, value_if_false), VLOOKUP(value, table, col_index, FALSE).
Chart choice rule: column/bar for comparison, line for trend over time, pie for parts of a whole (few categories), scatter for correlation between two variables.
Presentation design rule: roughly one idea per slide, minimum readable font size about 24 pt, high contrast text, consistent theme and slide master.
Slide Show shortcuts: F5 starts from beginning, Shift+F5 starts from current slide, Esc ends the show; transitions apply to slides, animations to objects.
Print preparation: set print area, fit to one page wide, repeat header rows, and preview before printing spreadsheets.
Internet, Web Browsing, and Email Communication
URL anatomy: protocol (https://) + domain (example.com) + path (/page) + optional query string (?id=5); HTTPS encrypts traffic via TLS.
DNS resolves a domain name to an IP address; a browser then requests the page from the web server using HTTP/HTTPS.
Browser controls: address bar, back/forward, refresh, bookmarks/favourites, history, downloads, private/incognito window, clear cache and cookies.
Search operators narrow results: quotation marks for exact phrase, site: to restrict domain, minus sign to exclude a term, filetype:pdf for file type.
Email fields: To (primary recipients), Cc (informational copy, visible to all), Bcc (hidden copy, protects recipient privacy), Subject (topic line), Body, Attachment.
Email etiquette: reply within a reasonable time, use Reply All only when all recipients need the answer, keep subject lines accurate when topic changes, avoid ALL CAPS.
Attachments have size limits set by the provider; large files are shared via cloud links with appropriate access permissions.
Phishing indicators: mismatched sender domain, urgency, unexpected attachments, requests for credentials or payment, and links whose visible text differs from the target URL.
Database Concepts and Data Management
DBMS = software that stores, retrieves, and secures data; RDBMS stores data in related tables of rows (records) and columns (fields).
Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table to enforce referential integrity.
Normalisation reduces redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composite key, 3NF removes transitive dependencies.
SQL categories: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).
SELECT syntax order: SELECT columns FROM table WHERE condition GROUP BY columns HAVING group_condition ORDER BY columns ASC|DESC.
WHERE filters rows before grouping; HAVING filters groups after aggregation; aggregate functions are COUNT, SUM, AVG, MIN, MAX.
JOIN types: INNER returns matching rows only; LEFT returns all left rows plus matches; RIGHT the reverse; FULL returns all rows from both tables.
Backup rule: a backup is only valid if restore has been tested; keep copies offline or off-site and define recovery point and recovery time objectives.
ITeS Industry Overview
ITeS (IT-enabled Services) delivers business processes and IT support remotely using technology; segments include BPO, KPO, LPO, and IT services.
BPO covers routine, rule-based processes (customer support, data entry, payroll); KPO covers knowledge-intensive work (research, analytics, legal, financial analysis).
Delivery models: onshore (same country as client), nearshore (nearby country), offshore (low-cost distant country), and hybrid or captive versus third-party.
Common engagement types: transactional (per-transaction pricing), FTE-based (dedicated staff), and outcome-based (payment linked to results).
Industry drivers: cost advantage, 24x7 coverage across time zones, skilled English-speaking workforce, and scalable infrastructure.
Service Level Agreement (SLA) defines measurable targets such as response time, resolution time, accuracy, and availability; penalties or credits apply on breach.
Career roles: associate/agent, team leader, quality analyst, process trainer, subject matter expert, operations manager, transition and process-improvement roles.
Domain certifications and frameworks commonly referenced: ISO 9001 (quality), ISO 27001 (information security), COPC and Six Sigma for process performance.
BPM/BPO Processes and Service Delivery
Process mapping symbols: oval = start/end, rectangle = task/activity, diamond = decision, arrow = flow, parallelogram = input/output, circle = connector.
SIPOC view: Suppliers, Inputs, Process, Outputs, Customers; use it to define process boundaries before detailed mapping.
BPM lifecycle: design → model → execute → monitor → optimise; repeat the cycle for continuous improvement.
DMAIC (Six Sigma): Define, Measure, Analyse, Improve, Control; used for improving an existing process; DMADV for designing a new one.
Lean waste acronym TIMWOOD: Transport, Inventory, Motion, Waiting, Overproduction, Overprocessing, Defects.
Key delivery metrics: AHT (average handling time), TAT (turnaround time), first contact resolution, SLA adherence, shrinkage, utilisation, occupancy, quality score.
Queueing rule: if arrival rate approaches service capacity, waiting time rises sharply; add capacity, reduce handling time, or smooth arrivals.
Root cause tools: 5 Whys, fishbone (Ishikawa) diagram, Pareto analysis (focus on the ~20% of causes producing ~80% of issues).
Escalation rule: follow the matrix - resolve at agent level, escalate to team leader, then process owner, documenting steps and timestamps at each level.
Communication Skills, Customer Service, and Workplace Etiquette
Communication process: sender → encoding → channel → decoding → receiver → feedback; noise is any interference at any stage.
Active listening steps: attend, do not interrupt, paraphrase to confirm, ask clarifying questions, summarise before responding.
Phone etiquette: answer within three rings, greet with name and organisation, speak clearly, confirm the caller's name, summarise actions, thank and close.
Email tone rule: state purpose in the first two lines, use short paragraphs and bullets, proofread, and match formality to the recipient.
Customer service sequence: greet → listen → empathise → clarify → resolve or escalate → confirm satisfaction → document.
Handling an angry customer: let them finish, acknowledge the feeling, avoid blame and defensiveness, state what you can do, give a timeframe.
Body language basics: open posture, appropriate eye contact, nodding, and a calm tone; avoid crossing arms, checking devices, or interrupting.
Workplace etiquette: be punctual, respect confidentiality, keep shared spaces clean, use professional language, and give credit to colleagues.
Assertive versus aggressive: assertiveness states your need respectfully using "I" statements; aggression blames or attacks the other person.
Digital Safety, Security, and Ethical Practices
CIA triad: Confidentiality (only authorised access), Integrity (data unaltered and accurate), Availability (accessible when needed).
Authentication factors: something you know (password/PIN), something you have (token/OTP device), something you are (biometrics); MFA combines two or more.
Strong password rule: length of at least 12 characters, mixed character types, unique per account, stored in a password manager, never shared.
Malware types: virus (attaches to files), worm (self-replicates over networks), trojan (disguised as legitimate), ransomware (encrypts and demands payment), spyware (collects data).
Social engineering: phishing (email), vishing (voice), smishing (SMS), pretexting (fake scenario), tailgating (physical entry); verify identity through an independent channel.
Data protection principles: collect only what is needed, state the purpose, obtain consent, keep it secure, retain only as long as necessary, allow access and correction.
Intellectual property: copyright protects original expression automatically; trademarks protect brand identifiers; patents protect inventions; licences define permitted use.
Ethical computing rules: no unauthorised access, no data misuse, respect privacy, report vulnerabilities responsibly, disclose conflicts of interest.
Incident response order: detect → contain → eradicate → recover → document and review lessons learned.
Entrepreneurship, Employability Skills, and Career Pathways in IT/ITeS
Business plan components: value proposition, target customer, market analysis, product/service, operations, marketing, team, financial projections, risk assessment.
Break-even point (units) = fixed costs ÷ (price per unit − variable cost per unit); it is the sales volume at which profit is zero.
Startup cost categories: fixed (rent, licences, equipment), variable (materials, per-unit fees), and working capital for day-to-day operations.
Funding sources: self-financing, bank loan, government schemes, angel investors, venture capital, crowdfunding; each trades control, cost, or risk.
Employability skills: technical/digital literacy, communication, teamwork, problem solving, time management, adaptability, and continuous learning.
Resume rules: one to two pages, reverse-chronological experience, action verbs, quantified achievements, tailored keywords, no spelling errors.
Interview structure: research the role, prepare STAR examples (Situation, Task, Action, Result), rehearse questions to ask, follow up with a thank-you note.
IT/ITeS career paths: service desk/technical support, network and system administration, software testing and development, data analysis, cybersecurity, process quality, and pre-sales.
Portfolio evidence: a project with problem statement, tools used, your specific contribution, outcome or metric, and a link or screenshot - not just a certificate.
Practical Work, Project, and Portfolio Assessment
Project report structure: title page, introduction and problem statement, objectives, scope, methodology, tools used, results/screenshots, testing, conclusion, references.
SMART objectives: Specific, Measurable, Achievable, Relevant, Time-bound; each objective must be testable against evidence.
Spreadsheet practical checklist: correct formulas with absolute references where needed, sorted/filtered data, at least one chart, formatted headers, print-ready layout.
Document practical checklist: heading styles, automatic table of contents, page numbers, header/footer, table with applied style, spell-checked text.
Presentation practical checklist: consistent theme, readable fonts, minimal text per slide, relevant visuals, speaker notes, working hyperlinks or embedded media.
Database practical checklist: normalised tables, defined primary and foreign keys, valid data types, queries using WHERE and aggregate functions, a report or form view.
Portfolio evidence types: source files, screenshots with captions, test logs, user feedback, reflection note on what you would improve.
Assessment rubric dimensions typically include accuracy, completeness, use of tools, documentation quality, presentation, and originality; check weights before submitting.
Version control habit: save iterations as project_v1, project_v2 with a change log noting date, change made, and reason.