WBCHSE HS Vocational IT & ITeS cheat sheet

IT is the use of computers, storage, networking and software to create, process, store, secure and exchange data; ITeS is the delivery of business processes as a service using IT infrastructure.

Data is raw unprocessed facts; information is processed data with context; knowledge is interpreted information applied to decisions - the DIKW hierarchy (Data, Information, Knowledge, Wisdom).

Core IT-enabled services sectors in India: BPO (voice and non-voice), KPO (knowledge-intensive analysis), software development, IT infrastructure management, and digital content/transcription services.

BPO = Business Process Outsourcing (routine, rule-based processes such as call handling, data entry, payroll); KPO = Knowledge Process Outsourcing (research, analytics, legal drafting, medical coding, equity research).

Front-office services are customer-facing (call centres, help desks); back-office services are internal (accounting, HR processing, claims processing, record management).

Outsourcing benefits for a client: cost reduction, 24x7 coverage via time-zone difference, access to specialised skill, scalability; risks: data leakage, loss of direct control, dependency on vendor.

India's ITeS advantage rests on English proficiency, lower labour cost, large engineering talent pool, government SEZ/STPI incentives and time-zone overlap with US/UK shifts.

IT and ITeS careers in the vocational stream include data entry operator, desktop support/helpdesk, junior web designer, back-office executive, and CRM/customer-support associate.

Block diagram of a computer: input unit → CPU (ALU + Control Unit + registers) → output unit, with memory (primary and secondary) and buses connecting them.

ALU performs arithmetic (+, −, ×, ÷) and logical (AND, OR, NOT, comparison) operations; the Control Unit fetches, decodes and directs execution of instructions; registers are the fastest storage inside the CPU.

Primary memory is directly addressable by the CPU: RAM (volatile, read/write) and ROM (non-volatile, read-only: PROM, EPROM, EEPROM). Secondary memory is non-volatile: HDD, SSD, optical disc, pen drive.

Memory units ascend by 1024: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB, 1 PB = 1024 TB.

Number systems: binary base 2, octal base 8, decimal base 10, hexadecimal base 16. 1 byte = 8 bits; n bits represent 2^n distinct values.

Hardware is the physical component; software is the set of instructions. Software classes: system software (OS, drivers, utilities) and application software (general-purpose and customised).

Generations: 1st vacuum tubes, 2nd transistors, 3rd integrated circuits, 4th microprocessors (VLSI), 5th artificial intelligence and parallel processing.

Input devices: keyboard, mouse, scanner, microphone, webcam, OMR/OCR/barcode reader; output devices: monitor, printer (impact and non-impact), plotter, speaker.

Motherboard carries the CPU socket, RAM slots, chipset, BIOS/UEFI chip, and expansion slots (PCIe); ports include USB, HDMI, VGA, RJ-45 (Ethernet) and audio jacks.

CPU speed is measured in hertz (GHz); cores allow parallel execution; cache levels L1 (smallest, fastest) to L3 (largest, slowest) reduce memory latency.

Storage interfaces: SATA (up to about 6 Gbps), NVMe over PCIe (much higher throughput); SSD has no moving parts, so it is faster, quieter and more shock-resistant than HDD.

SMPS converts AC mains to regulated DC voltages for the motherboard and drives; UPS provides battery backup and protects against power failure and spikes.

An operating system manages processes, memory, files, devices and users. Functions: process scheduling, memory allocation, file management, I/O control, security and user interface.

OS types: batch, multiprogramming, multitasking, time-sharing, real-time (hard/soft), distributed and mobile. Windows, Linux, macOS are general-purpose; Android and iOS are mobile.

A file system organises storage: FAT32 (max file size 4 GB), NTFS (permissions, journaling, large volumes), ext4 (Linux). File path = drive/folder/subfolder/file.

Key OS utilities: disk defragmenter (HDD only), disk cleanup, Task Manager (processes and performance), Device Manager (drivers), backup and restore, antivirus.

Word processor elements: character formatting (font, size, bold, italic), paragraph formatting (alignment, indent, line spacing), page setup (margins, orientation, size), headers/footers.

Word features: Find and Replace (Ctrl+H), spell/grammar check (F7), track changes, comments, mail merge (main document + data source), table of contents from heading styles, section breaks.

Spreadsheet structure: workbook → worksheet → cell addressed as column letter + row number (e.g., B7); a range is written A1:C10; absolute reference uses $ ($A$1), relative does not.

Formula must begin with = ; operators follow precedence: ^ then * and / then + and −, overridden by parentheses. Functions: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, IF, VLOOKUP, ROUND.

Common error values: #DIV/0! (divide by zero), #VALUE! (wrong data type), #REF! (invalid reference), #NAME? (unrecognised name), #N/A (lookup value not found).

Cell references: relative (A1) adjusts on copy; absolute ($A$1) stays fixed; mixed ($A1 or A$1) fixes one part. Chart types: column, line (trend), pie (parts of a whole), scatter (correlation).

Presentation software: slide, slide master, layout, placeholder, transition (between slides) versus animation (within a slide), Slide Show (F5), Presenter View, speaker notes.

Slide design rules: one idea per slide, readable font size (roughly 24 pt and above for body), high contrast, minimal text, consistent theme, alt text for images.

Internet = global network of networks using TCP/IP; the World Wide Web is a service on it. TCP is connection-oriented and reliable; UDP is connectionless and faster.

IP address identifies a device; IPv4 is 32-bit (four dotted octets), IPv6 is 128-bit. DNS translates domain names to IP addresses; DHCP assigns IP addresses automatically.

URL anatomy: protocol://domain/path?query. HTTP is stateless; HTTPS adds TLS encryption on port 443 versus HTTP port 80.

Web technologies: HTML (structure), CSS (presentation), JavaScript (behaviour on the client). A web browser renders pages; a web server (Apache, Nginx) serves them.

Email fields: To, Cc (visible copy), Bcc (hidden copy), Subject, Body, Attachment. Protocols: SMTP sends, POP3/IMAP retrieve; IMAP keeps mail synchronised on the server.

Digital communication channels: email, instant messaging, VoIP, video conferencing, SMS, social media, blogs and wikis; asynchronous (email, forum) versus synchronous (chat, video call).

Networking devices: hub (broadcasts to all ports), switch (forwards by MAC address), router (forwards between networks by IP), modem, access point, firewall.

Search techniques: quoted phrase for exact match, site: to restrict a domain, minus sign to exclude a term, filetype: to limit to a file format; evaluate sources for authority, currency and bias.

Data entry accuracy is measured by error rate = (records with errors ÷ total records) × 100; speed is measured in keystrokes per hour (KPH) or words per minute (WPM).

Standard touch-typing home row: left hand A S D F, right hand J K L ; - the raised bumps on F and J guide finger placement without looking.

Common data-entry errors: transcription error, transposition (swapping adjacent digits), omission, duplication, wrong-field entry, and inconsistent formatting.

Double entry (key verification) means entering the same data twice by different operators and comparing; it detects keystroke errors that proofreading alone may miss.

Data validation at entry prevents bad input: drop-down lists, input masks, range checks, mandatory (required) fields, and format checks such as a 10-digit mobile number or 6-digit PIN code.

Source document is the original record (form, invoice, receipt); entry must be verified against it, and the source should be retained for audit.

Ergonomics for data entry: feet flat, back supported, wrists neutral, monitor top near eye level, 20-20-20 rule for eye breaks, adequate lighting to reduce fatigue.

Confidentiality rules: do not copy data to personal devices, lock the workstation when leaving, and follow the organisation's data-handling policy; screens should not face public areas.

Database = organised collection of related data; DBMS = software to create, store, retrieve and control it (e.g., MySQL, Oracle, SQL Server, LibreOffice Base, MS Access).

Relational model terms: relation = table, tuple = row/record, attribute = column/field, degree = number of columns, cardinality = number of rows.

Keys: primary key uniquely identifies a row and cannot be null; foreign key references a primary key in another table and enforces referential integrity; candidate key is any minimal unique key.

SQL command families: DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), DQL (SELECT), DCL (GRANT, REVOKE), TCL (COMMIT, ROLLBACK).

Basic queries: SELECT columns FROM table WHERE condition ORDER BY column ASC|DESC; aggregate functions COUNT, SUM, AVG, MIN, MAX combine with GROUP BY and HAVING.

Normalisation reduces redundancy and update anomalies: 1NF removes repeating groups (atomic values), 2NF removes partial dependency on part of a composite key, 3NF removes transitive dependency on non-key attributes.

Data warehouse stores historical, integrated data for analysis (OLAP); operational databases support day-to-day transactions (OLTP). Backup types: full, incremental (changes since last backup), differential (changes since last full).

Data quality dimensions: accuracy, completeness, consistency, timeliness, uniqueness and validity - each is checked during data cleaning before analysis.

BPO service lines: customer support (inbound/outbound voice), technical support, telemarketing, collections, back-office processing (data entry, indexing, claims), and HR/payroll outsourcing.

KPO service lines: market and equity research, business analytics, legal process outsourcing, medical coding and transcription, patent research, animation and engineering design.

BPO delivery models: onshore (same country as client), nearshore (nearby country), offshore (distant country) and hybrid; captive (client-owned centre) versus third-party vendor.

Key performance indicators: AHT (average handling time), first-call resolution, SLA adherence, shrinkage (absenteeism plus attrition), occupancy, CSAT, NPS, quality score and TAT (turnaround time).

Inbound call flow: greeting with the organisation name and self-identification, authentication, problem identification, resolution, confirmation, documentation, closing.

Escalation matrix defines levels (L1 agent → L2 specialist → L3 technical/manager) and when to escalate: beyond authority, repeated failure, or customer request.

Process documentation tools: SOP (standard operating procedure), process map/flowchart, knowledge base and call scripts; version control keeps documents current.

Service Level Agreement (SLA) is a contract stating measurable service targets such as response time, resolution time, uptime and penalty clauses for misses.

Communication process elements: sender, message, encoding, channel, receiver, decoding, feedback, and noise (any interference that distorts the message).

Types: verbal (words), non-verbal (body language, gestures, posture, eye contact), paraverbal (tone, pitch, pace, volume); written communication is asynchronous and recordable.

The 7 Cs of effective communication: clear, concise, concrete, correct, coherent, complete and courteous.

Active listening steps: pay attention, avoid interrupting, paraphrase to confirm, ask clarifying questions, and summarise before responding.

Telephone etiquette: answer within about three rings, greet with organisation and name, speak clearly at moderate pace, ask permission before placing on hold, thank the caller and summarise the action.

Email etiquette: specific subject line, one topic per message, professional salutation and sign-off, no ALL CAPS (read as shouting), proofread before sending, reply-all only when necessary.

Barriers to communication: physical noise, semantic/jargon difference, language barrier, emotional state, cultural difference, information overload and perceptual bias.

Giving feedback: describe the observed behaviour and its impact, avoid personal attack, be specific and timely; receiving feedback: listen, clarify, thank, act.

Customer service fundamentals: greet promptly, listen actively, empathise, take ownership, resolve or escalate, and follow up until closure.

LEARN model for complaints: Listen, Empathise, Apologise (for the experience), Resolve, Notify/thank the customer.

Service recovery paradox: a well-handled complaint can raise loyalty above the pre-failure level; unresolved complaints spread faster than praise.

Types of difficult customers: angry, impatient, talkative, silent, demanding, confused; response is calm tone, no argument, acknowledge feeling, then move to facts and options.

Soft skills portfolio: communication, teamwork, problem solving, time management, adaptability, emotional intelligence, critical thinking and work ethic.

Time management tools: priority matrix (urgent/important), to-do list, task batching, and time-blocking; Pareto principle notes roughly 80% of results from 20% of effort.

Teamwork roles: leader, facilitator, contributor, challenger; conflict handled by focusing on the issue, not the person, and seeking a win-win outcome.

CSAT is measured by a post-interaction survey (often a 1–5 scale); NPS uses the 'would you recommend us' 0–10 question; both differ from internal quality scores.

Malware types: virus (attaches to files), worm (self-replicates across networks), trojan (disguised as legitimate), ransomware (encrypts data for payment), spyware (secretly collects data), adware.

Phishing is fraudulent email/site to steal credentials; spear phishing targets a specific person; vishing uses voice calls; smishing uses SMS; pharming redirects to a fake site via DNS or hosts manipulation.

Password hygiene: long passphrase, unique per account, never shared, changed after suspected compromise, combined with multi-factor authentication (something you know, have, are).

Encryption converts plaintext to ciphertext using a key; symmetric uses one shared key, asymmetric uses a public/private key pair; hashing is one-way and used to store passwords.

Firewall filters network traffic by rules; antivirus uses signatures and heuristics; both must be updated; patching closes known vulnerabilities.

Indian legal framework: Information Technology Act, 2000 (amended 2008), with sections covering unauthorised access, identity theft and privacy; Digital Personal Data Protection Act, 2023 governs personal data processing.

Data privacy principles: lawful purpose, consent, data minimisation, purpose limitation, storage limitation, accuracy, security safeguards, and the data principal's rights to access and correction.

Cyber ethics: no unauthorised access, no software piracy, respect copyright and licences, no plagiarism, no cyberbullying, no sharing others' personal data without consent.

Practical task in a word processor: create a document with a title, heading styles, bulleted and numbered lists, a table, page border, header/footer with page numbers, and print preview.

Practical spreadsheet task: enter data, apply formulas with relative and absolute references, use SUM/AVERAGE/IF, sort and filter, insert a chart with title and axis labels, and set print area.

Practical presentation task: build at least five slides using a theme, insert text and image, apply a transition, apply custom animation, add speaker notes, and run the slide show.

Practical internet task: create an email account, compose with Cc/Bcc and attachment, reply and forward, create a folder and filter/rule, and download an attachment safely.

Practical database task: create a table with a primary key, enter records, run a SELECT query with WHERE and ORDER BY, and produce a simple report or form.

File management discipline: meaningful file names without special characters, correct extension (.docx, .xlsx, .pptx, .odt, .ods), organised folders, and Save As versus Save.

Keyboard shortcuts worth practising: Ctrl+C/V/X copy/paste/cut, Ctrl+Z/Y undo/redo, Ctrl+S save, Ctrl+P print, Ctrl+F find, Alt+Tab switch windows, Ctrl+Shift+N new folder.

Before submitting practical work: verify spelling, check formulas recalculate correctly, confirm all images render, test the file opens, and export to PDF when the format must be fixed.

Project report structure: title page, certificate, acknowledgement, index, introduction, objectives, methodology, work done/screenshots, results, conclusion, limitations, future scope, bibliography.

A measurable objective is specific and testable (e.g., 'reduce data-entry error rate on 200 sample forms by 20% using validation rules'), not vague ('improve data entry').

Viva answers should define the term, state why the choice was made, and give an example from the project: e.g., 'I used a primary key because duplicate roll numbers must be prevented'.

Common viva topics: difference between hardware and software, RAM versus ROM, relative versus absolute reference, primary versus foreign key, HTTP versus HTTPS, virus versus worm, BPO versus KPO.

Cite sources honestly: list books, websites and dates accessed; avoid plagiarism; acknowledge any assistance received in the certificate or acknowledgement.

Demonstrate, do not just describe: keep the project file and sample data ready to open, and be prepared to explain any single cell formula or line of code shown.

Evaluation criteria typically include relevance, technical correctness, originality, presentation quality, depth of understanding and response to questions.

Anticipate the 'why' questions: why this tool, why this formula, why this data source, what would you change if data volume grew tenfold, and what were the limitations.