RBSE VU IT and ITeS study materials
RBSE VU IT and ITeS study resources

RBSE VU IT and ITeS cheat sheet

RBSE VU IT and ITeS · Keep the key ideas within reach.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.

Quick reference

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.