Overview
This chapter introduces Information and Communication Technology (ICT) skills essential for the modern workplace and everyday life. It explains basic concepts of hardware, software and operating systems; shows how to create, organise and manage digital information using file management, word processing, spreadsheets and presentations; and covers effective digital communication using email, instant messaging and online collaboration tools. The chapter emphasises safe, ethical and responsible use of technology — including cybersecurity, privacy, digital footprint, netiquette and accessibility — and introduces e-governance, digital payments and cloud services that citizens and employees commonly use. Practical, hands-on tasks develop productivity, problem-solving and troubleshooting skills that improve employability across sectors. Overall, students learn to use ICT tools confidently and responsibly to communicate, create, collaborate and solve real-world problems.
Learning Objectives
- Define common ICT terms such as hardware, software, data, information, and peripherals.
- Explain the functions of an operating system and perform basic file and folder management tasks.
- Demonstrate installation and uninstallation of simple application software and driver updates.
- Apply word-processing skills to create, format, edit, save, and print structured documents.
- Use spreadsheet features—cells, formulas, functions, sorting, filtering, and charts—to organize and analyze data.
- Create effective presentation slides incorporating text, images, tables, animations, and speaker notes.
- Explain principles of safe and responsible ICT use, including digital footprint, privacy settings, and netiquette.
- Identify common cyber threats (phishing, malware, ransomware) and implement basic security measures such as strong passwords and antivirus updates.
Topics in this chapter
16 topics · tap a topic title to jump straight to it.
Introduction to ICT
Introduction to ICT
Key Point: Data size conversions: 1 Byte = 8 bits; 1 KB = 1024 Bytes ≈ 10^3 Bytes; 1 MB = 1024 KB; 1 GB = 1024 MB.
What is ICT? Information and Communication Technology (ICT) is the set of tools, systems and processes used to create, store, process, transmit and present information. ICT combines computing (hardware and software) with telecommunications (networks, internet and broadcasting) to enable communication and information access.
Core components of ICT
- Hardware: physical devices — computers, smartphones, routers, servers, sensors, printers.
- Software: operating systems, applications, web browsers, databases.
- Networks: LAN, WAN, the Internet, mobile networks connecting devices.
- Data: digital information (text, audio, image, video) to be processed or communicated.
- People & Procedures: users, administrators, policies and workflows that govern ICT use.
Main functions and services
- Communication: email, messaging, VoIP, video conferencing.
- Information access: web search, digital libraries, online news.
- Commerce and transactions: online banking, e-commerce, digital payments.
- Education & training: e-learning platforms, virtual classrooms.
- Entertainment & media: streaming audio/video, social media.
Benefits: faster communication, easy access to information, automation of tasks, improved collaboration, remote working and learning, cost savings through digital processes.
Challenges & concerns: digital divide (unequal access), cybersecurity risks (malware, phishing), privacy issues, misinformation, dependency on infrastructure, need for digital literacy.
Security and ethics (brief): use strong passwords, update software, back up data, apply encryption where required, respect copyright, follow privacy laws and ethical guidelines when sharing information.
How ICT works in simple terms: Input & capture (keyboard, sensors) → Processing (CPU, software) → Storage (hard disk, cloud) → Transmission (networks) → Output & presentation (monitor, printer, speakers).
Role in daily life: ICT underpins online banking, telemedicine, smart classrooms, navigation (GPS), online shopping, social interaction and many government services (e‑governance).
- Online banking: using a bank website or app to transfer money, check balance and pay bills.
- Video conferencing for remote classes or meetings (Zoom, Google Meet).
- E‑commerce: buying goods from an online marketplace and tracking delivery.
- Telemedicine: doctor consultations over a video call and sharing medical reports electronically.
- Smart home: controlling lights and thermostat with a smartphone app (IoT).
- Cloud storage: saving photos or documents to Google Drive or OneDrive for access from any device.
- \[Data size conversions: 1 Byte = 8 bits\]\[1 KB = 1024 Bytes ≈ 10^3 Bytes\]\[1 MB = 1024 KB\]\[1 GB = 1024 MB.\]
- \[Throughput (average) = Total data transferred (bits or bytes) / Time taken\]\[Example: 50 MB transferred in 10 s → throughput = (50×8) Mb / 10 s = 40 Mbps.\]
- \[Bandwidth (capacity) measured in bits per second (bps)\]\[Example units: kbps\]\[Mbps\]\[Gbps.\]
- \[Latency (approx) = propagation delay + transmission delay + processing delay + queueing delay (measured in ms).\]
- \[Compression ratio = Original size / Compressed size\]\[Higher ratio means better compression.\]
- \[Availability (%) = (Uptime / Total time) × 100\]\[Example: 86340 minutes up in a 30‑day month (43200 minutes) → calculate accordingly.\]
Computer Hardware and Peripherals
Computer Hardware and Peripherals
Key Point: Data unit conversions: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB (binary convention commonly used in OSes); decimal sometimes uses 1 KB = 1000 B.
What is Computer Hardware? Computer hardware comprises the physical components of a computer system you can touch — the central processing unit (CPU), memory, storage devices, motherboard, power supply, input and output devices, and expansion cards. Together with software, hardware enables computation, storage and communication.
Major internal components and their roles
- CPU (Processor): Executes instructions. Key attributes: clock speed (Hz), cores, and cache.
- Motherboard: Main circuit board that connects CPU, memory, storage, expansion slots and I/O ports.
- RAM (Random Access Memory): Volatile memory used for running programs and active data. Faster but temporary.
- ROM / BIOS / Firmware: Non-volatile memory containing boot firmware and basic hardware control.
- Storage: Long-term data storage. Types: HDD (mechanical), SSD (flash), NVMe (PCIe-based SSD).
- GPU (Graphics Processing Unit): Renders images and video; integrated or discrete.
- Power Supply Unit (PSU): Converts AC mains to regulated DC voltages for components.
Peripherals (Input / Output / Input-Output)
- Input devices: Keyboard, mouse, scanner, microphone, webcam, barcode reader.
- Output devices: Monitor, printer, speakers, projectors.
- IO devices: External storage (USB drives), touchscreens, multifunction printers (scan/print).
Interfaces and Connectors — how peripherals communicate with the computer: USB (2.0/3.x/Type‑C), HDMI/DisplayPort (video), VGA (legacy), Ethernet (network), audio jacks, SATA (internal drives), PCIe (expansion cards), NVMe (high-speed storage on PCIe).
Classification: Internal (installed inside case: GPU, sound card, SSD), External (connected outside: keyboard, monitor), and Networked (printers/servers on LAN).
Performance factors: CPU frequency, number of cores, RAM size and speed, storage type (HDD vs SSD vs NVMe), bus and interface bandwidth (USB, SATA, PCIe). Bottlenecks occur when a component is much slower than others (e.g., slow HDD with fast CPU).
Installation and basic troubleshooting
- Ensure power off and grounded before opening case. Check connections: power cables, SATA/PCIe cables, RAM seating, CPU cooler seating.
- POST/BIOS checks: Beep codes, motherboard LEDs, display output to detect faulty components.
- Peripheral issues: Try different ports/cables, check drivers, test on another system.
Maintenance and safety
- Keep dust-free, use antistatic precautions when handling components.
- Use surge protectors or UPS for power protection.
- Regularly update firmware/drivers and back up important data.
Practical note for schools and small businesses: Choose components based on use—word processing and browsing need modest CPU/RAM; video editing/gaming require powerful CPU/GPU and fast NVMe storage; point-of-sale and kiosks prioritize reliability and peripherals like barcode scanners and receipt printers.
- Home desktop for study: CPU (quad-core), 8 GB RAM, 256 GB SSD, 1 TB HDD for media, monitor, keyboard, mouse and printer.
- School computer lab: mid-range desktops with integrated graphics, 4–8 GB RAM, networked printers and shared NAS for student files.
- Retail POS: Small form-factor PC or terminal + touchscreen, barcode scanner, receipt printer, cash drawer, Ethernet/Wi‑Fi connection.
- Graphic-design workstation: High-core-count CPU, 32+ GB RAM, discrete GPU, NVMe SSD for project files and fast scratch space.
- External backup: USB 3.1 external SSD for fast backups; or NAS (Network Attached Storage) for shared storage across multiple devices.
- \[Data unit conversions: 1 KB = 1024 B, 1 MB = 1024 KB, 1 GB = 1024 MB (binary convention commonly used in OSes)\]\[decimal sometimes uses 1 KB = 1000 B.\]
- \[Storage bytes calculation: bytes = capacity × (1024^n)\]\[e.g., 4 GB = 4 × 1024^3 bytes ≈ 4,294,967,296 bytes.\]
- \[CPU execution time (approx): Execution time = Number of cycles / Clock frequency\]\[If instructions take C cycles and there are I instructions\]\[time = (I × C) / f.\]
- \[Data transfer time: Transfer time = Data size / Transfer rate\]\[Example: 10 GB file over 500 MB/s SSD takes ~20 seconds (10,000 MB / 500 MB/s).\]
- \[Bandwidth relation: Bandwidth (bits/s) = Data size (bits) / Time (s)\]\[Convert bytes to bits by multiplying by 8.\]
- \[Electrical power: P (watts) = V (volts) × I (amps)\]\[Use to estimate PSU requirements: add component power draws and include safety margin (~20–30%).\]
Software and System Software
Software and System Software
Key Point: CPU Utilization (%) = (CPU busy time / Total time) × 100
What is Software? Software is a set of instructions, programs and data that tell computer hardware what to do. It is intangible and controls the behaviour and operations of a computer system.
Two broad categories
- System software — software that manages and controls computer hardware and provides a platform for running application software.
- Application software — programs designed to perform specific user-oriented tasks (e.g., word processing, web browsing, accounting).
System software: main components and functions
- Operating System (OS): kernel and services that manage processes, memory, file systems, devices and user interfaces. Core OS functions include process management, memory management, file management, device management, security and user interface (CLI/GUI).
- Device drivers: small programs that translate OS requests into device-specific commands (printer, graphics card, network adapter drivers).
- Utility programs: maintenance tools that support system operation (antivirus, disk cleanup, backup, defragmenter, system monitor).
- Firmware: low-level software programmed into hardware (BIOS/UEFI, embedded controllers, router firmware) that initializes hardware and provides basic services.
How they interact
User → Application software → System software (OS & drivers) → Hardware. Applications request services from the OS via system calls; the OS schedules CPU, assigns memory, accesses disk and talks to devices using drivers.
Key characteristics
- System software: runs continuously or when system boots, manages resources, must be stable, often privileged access to hardware.
- Application software: built for end-user tasks, installed/removed more frequently, interacts with users and relies on system software.
Installation, updates and licensing
System software (especially OS and firmware) receives periodic updates for security and features. Software may be licensed as proprietary (paid, closed source), free, or open-source (code available). Proper licensing and regular updates are essential for security and performance.
Practical importance
Understanding system software helps troubleshoot performance (e.g., why programs slow down), install correct drivers, choose the right utilities, and ensure secure and reliable computing in real-life contexts like schools, offices and embedded devices.
- Operating systems: Microsoft Windows 10/11, macOS, Linux (Ubuntu), Android, iOS
- Device drivers: Printer driver (HP/Canon), Graphics/GPU driver (NVIDIA, AMD), Network adapter drivers
- Utility programs: Antivirus (Windows Defender, Avast), Backup tools (Acronis, Windows Backup), Disk Cleanup/Defragmenter
- Firmware: BIOS/UEFI on PCs, firmware in routers (OpenWrt), embedded firmware in smart appliances
- Application software: MS Office (Word, Excel, PowerPoint), LibreOffice, VLC media player, Google Chrome, WhatsApp, Tally (accounting), GeoGebra (education)
- \[CPU Utilization (%) = (CPU busy time / Total time) × 100\]
- \[Throughput = Number of processes completed / Unit time\]
- \[Turnaround Time = Completion time − Arrival time\]
- \[Response Time = Time of first response − Arrival time\]
- \[Availability = MTBF / (MTBF + MTTR) (Mean Time Between Failures ÷ (MTBF + Mean Time To Repair))\]
File and Folder Management
File and Folder Management
Key Point: Storage unit conversions: 1 KB = 1024 bytes; 1 MB = 1024 KB; 1 GB = 1024 MB
File and Folder Management refers to organizing, storing, locating and maintaining digital files and folders on a computer, removable drives or cloud storage. Good management keeps data safe, easy to find and reduces wasted storage.
Basic concepts
- File: A unit of stored information (document, image, audio, video, program). Files have names and extensions (e.g., report.docx, photo.jpg) that indicate type.
- Folder (Directory): A container used to group files and other folders, forming a hierarchical tree (root > subfolders).
- Path: The address of a file or folder in the hierarchy (e.g., C:\Users\Priya\Documents\project.docx or /home/priya/documents/project.docx).
- Attributes: Properties such as size, type, date created/modified/accessed, read-only or hidden.
Common operations
- Create/New folder or file
- Open / Edit
- Rename
- Copy / Move (cut & paste)
- Delete (goes to Recycle Bin/Trash or permanent removal)
- Search / Sort / Filter
- Compress (zip) / Extract
- Backup and Restore
Best practices
- Use clear, consistent naming (e.g., YYYY-MM-DD_subject_version).
- Organize by topic, project or date; limit folder depth for ease of access.
- Keep one master copy and use version numbers instead of duplicates.
- Regularly back up important files (cloud, external HDD).
- Use compression for sharing large files; use appropriate file formats (lossless vs lossy).
- Check permissions before sharing; empty Recycle Bin to free space.
Platform notes
- Windows shows drive letters (C:, D:) and uses backslashes in paths; common GUI operations via File Explorer.
- Linux/Unix uses a single-rooted filesystem with forward slashes (/home/user) and many operations can be done via commands (mkdir, cp, mv, rm).
- Cloud storage (Google Drive, OneDrive) provides syncing, version history and remote backup.
- School project: Create a folder named '2025_Maths_Project' with subfolders 'Research', 'Drafts', 'Final', and place images in 'Images' so you can quickly find the final report.
- Photo backup: Move all phone photos to a folder '/Photos/2024-Trip', then copy that folder to an external HDD and a cloud service to avoid data loss.
- Compressing before emailing: You have a 30 MB folder. Zip it to reduce size (e.g., to 12 MB) before attaching to an email to meet attachment limits.
- Cleaning disk space: Use a disk usage report to find that the 'Videos' folder uses 45% of the drive; move old videos to external storage to free up space.
- Transfer time calculation: Copying a 4 GB file over a 40 MB/s USB connection takes roughly (4 × 1024 MB) / 40 MB/s ≈ 102.4 seconds (~1.7 minutes).
- \[Storage unit conversions: 1 KB = 1024 bytes\]\[1 MB = 1024 KB\]\[1 GB = 1024 MB\]
- \[Folder size: Size(folder) = sum of sizes of all files and subfolders inside\]
- \[Compression ratio = Compressed size / Original size (e.g., 0.4 means 60% size saved)\]
- \[Percentage space used = (Used space / Total space) × 100\]
- \[Copy/transfer time ≈ File size (in MB) / Transfer rate (in MB/s)\]
Word Processing Skills
Word Processing Skills
Key Point: Words per minute (WPM) estimate: WPM = (Total words typed) / (Time in minutes).
What is Word Processing? Word processing is the creation, editing, formatting, saving and printing of text documents using software such as Microsoft Word, LibreOffice Writer or Google Docs. It helps produce letters, reports, essays, resumes, certificates, newsletters and other professional documents quickly and consistently.
Key Components
- Document structure: title, headings, paragraphs, lists, tables, header/footer, page numbers.
- Formatting: fonts, font size, style (bold/italic/underline), alignment, line spacing, indentation, margins and page orientation.
- Styles & Templates: predefined formatting for headings, normal text and special blocks; templates save time and ensure uniformity.
- Editing tools: cut/copy/paste, find & replace, undo/redo, spell check and grammar check.
- Advanced tools: tables, images, text wrapping, columns, mail merge, footnotes/endnotes, references and citations, track changes and comments for collaboration.
- Saves & Exports: save in DOC/DOCX/ODT/PDF formats; print settings and page setup for physical copies.
Good Practices
- Use styles instead of manual formatting for consistent headings and easy navigation.
- Keep templates for recurring document types (letters, reports, certificates).
- Use headers/footers for document title, date and page numbers.
- Use tables for structured data and lists for ordered/unordered items.
- Use spell check and proofread manually; track changes when collaborating.
Accessibility & Compatibility — choose readable fonts (e.g., Arial, Times New Roman), sufficient contrast and use alt text for images. Save copies in common formats (PDF for sharing, DOCX for editing) to ensure compatibility.
Practical Workflow
- Create a new document from a template or blank file.
- Set page layout (paper size, margins, orientation) and styles.
- Write content in logical sections using headings.
- Insert tables/figures and apply captions if needed.
- Proofread, use review tools (track changes, comments), and finalize formatting.
- Save in required format and print/export as PDF.
- Writing a school project report: use heading styles for title/chapters, insert a table of contents, and include images with captions.
- Creating a resume (CV): use a professional template, consistent font sizes and bullet lists to highlight skills and experience.
- Preparing invitation letters for an event using mail merge to personalize names and addresses for many recipients.
- Producing a newsletter: use columns, images, text wrapping and consistent styles to create a clean layout.
- Making certificates: use templates, insert logos and use formatted text boxes to place names and titles precisely.
- \[Words per minute (WPM) estimate: WPM = (Total words typed) / (Time in minutes).\]
- \[Characters to words estimate: Words ≈ Characters (without spaces) / 5 (average word length ≈ 5).\]
- \[Pages estimate: Pages ≈ Total words / 250 (single-spaced\]\[standard font and margins) — adjust by font size and spacing.\]
- \[Printable area: Printable Width = Paper Width − (Left Margin + Right Margin)\]\[Printable Height = Paper Height − (Top Margin + Bottom Margin).\]
- \[Line spacing in points: Leading (pt) ≈ Font size (pt) × Line spacing multiplier (e.g., 1.15 or 1.5).\]
Spreadsheet Skills
Spreadsheet Skills
Key Point: =SUM(range) — adds numbers in a range, e.g., =SUM(B2:B11)
A spreadsheet is an electronic sheet made of rows and columns used to store, organise, calculate and analyse data. Each box is a cell identified by a cell address (column letter + row number, e.g., A1). Spreadsheets (like Microsoft Excel, Google Sheets) let you enter different data types (text, numbers, dates), perform calculations with formulas (begin with =), use built-in functions, format cells, sort and filter data, and visualise results with charts.
Key concepts:
- Cells, rows, columns and ranges (e.g., A1, B2:C10).
- Formulas and functions: formulas begin with =. Functions are predefined operations like SUM(), AVERAGE(), IF().
- Relative vs absolute references: A1 (relative), $A$1 (absolute). Use absolute references when copying formulas that must refer to a fixed cell (e.g., tax rate).
- Common data operations: sorting, filtering, conditional formatting and data validation to ensure correct entries.
- Charts and graphs: convert tables into visual forms (bar, column, pie, line, scatter) to interpret data quickly.
- Autofill and fill-handle: quickly copy formulas or extend series (dates, numbers).
Practical workflow:
- Plan the table structure (columns as fields, rows as records).
- Enter raw data consistently (same units, date format).
- Use formulas with ranges rather than writing repeated arithmetic.
- Format numbers and alignment for readability (currency, percent, decimals).
- Create charts to summarise findings and use filters/sorting to explore the data.
Tips: double-check formulas, use named ranges for clarity, protect cells with important formulas, and keep a backup copy of important spreadsheets.
- Student marksheet: Columns for subject marks, formula for Total =SUM(B2:G2), Percentage = (Total / MaximumMarks) * 100, Grade using IF (e.g., =IF(H2>=90,"A+",IF(H2>=75,"A",IF(H2>=60,"B",IF(H2>=50,"C","D"))))). Create a bar chart to compare students' totals.
- Household monthly budget: Columns for categories (Rent, Food, Utilities, Transport), actual and planned amounts. Use SUM to get total expenses, Percentage formula =Actual/Planned*100, and a pie chart to show expense share by category.
- Inventory register: Columns for Item, Opening Stock, Purchases, Sales, Closing Stock formula =Opening+Purchases-Sales. Use IF to flag reorder: =IF(ClosingStock<=ReorderLevel,"Reorder","OK"). Use conditional formatting to highlight low stock.
- Attendance tracker: Mark P/A for each day. Use COUNTIF to count present days: =COUNTIF(B2:AF2,"P"). Calculate attendance percentage =PresentDays/TotalWorkingDays*100 and filter students below 75%.
- Sales report and trend: Date, Product, Units Sold, Unit Price, Revenue =Units*UnitPrice. Use pivot table (or SUMIFS) to summarise sales by product/month and a line chart to show monthly sales trend.
- \[=SUM(range) — adds numbers in a range\]\[e.g., =SUM(B2:B11)\]
- \[=AVERAGE(range) — calculates mean\]\[e.g., =AVERAGE(B2:B11)\]
- \[=COUNT(range) — counts numeric cells, =COUNTA(range) counts non-empty cells\]
- \[=COUNTIF(range\]\[criteria) — counts cells that meet a condition\]\[e.g., =COUNTIF(C2:C31,">=75")\]
- \[=IF(condition\]\[value_if_true\]\[value_if_false) — conditional result\]\[e.g., =IF(D2>=40,"Pass","Fail")\]
- \[=VLOOKUP(lookup_value\]\[table_range\]\[col_index, [range_lookup]) — vertical lookup to fetch corresponding value\]
Presentation Skills
Presentation Skills
Key Point: Effective Presentation = Clear Objective + Organized Content + Engaging Delivery + Relevant Visuals + Practice
What are Presentation Skills? Presentation skills are the abilities used to plan, design and deliver information clearly and engagingly to an audience. They combine content organisation, visual design, vocal delivery and body language so that the audience understands and remembers the message.
Why they matter: Good presentation skills help you explain ideas, persuade others, teach, report results and perform well in school projects, interviews, debates and digital meetings.
Steps to prepare an effective presentation
- Analyse the audience – age, prior knowledge, expectations and time available. Tailor language, examples and depth accordingly.
- Define the objective – what should the audience learn, feel or do after your talk? Keep one clear central message.
- Organise content – use a clear structure: Introduction → Body → Conclusion. Use logical sequence (chronology, cause–effect, problem–solution or compare–contrast).
- Design slides or visuals – keep slides simple: one idea per slide, short text, meaningful images, consistent fonts and colours. Follow the 5×5 rule (max 5 bullet points, ~5 words each) as a guideline.
- Plan timing – allocate time (rule of thirds: 10% introduction, 80% main content, 10% conclusion) and rehearse with a timer.
Structure details
- Introduction – open with a hook (question, fact, short story), state the purpose and outline the main points.
- Body – present 3–5 key points, each with explanation, example/evidence and a transition to the next point (use PEEL: Point, Evidence, Explanation, Link).
- Conclusion – summarise main points, restate the takeaway, and include a closing remark or call to action.
Delivery techniques
- Voice – speak clearly, vary pitch and pace, pause for emphasis, and control volume to suit the room or microphone.
- Body language – maintain open posture, make eye contact, use natural hand gestures and move purposefully.
- Pacing – avoid rushing; use pauses to let ideas sink in. Match speech rate to audience comprehension.
- Handling questions – listen fully, repeat or rephrase the question if needed, answer concisely; if you don’t know, admit it and offer to follow up.
Design and visual aids
- Use contrast (dark text on light background or vice versa), readable font sizes (title ~36–44 pt, body ~24–32 pt for screen), and consistent templates.
- Prefer meaningful visuals (charts, diagrams, photos) over decorative images. Label axes and keep charts simple.
- Limit animation and transitions; use them only to support clarity.
Practice and technical checks
- Rehearse aloud, time yourself, and practise with your slides and any equipment (projector, microphone, webcam).
- Prepare backups: a PDF copy of slides, a USB drive and access to cloud storage. For remote presentations check internet, camera framing and lighting.
Accessibility and engagement
- Ensure text is readable (large fonts, high contrast), speak clearly for listeners with hearing needs, and describe important visuals for visually impaired audience members.
- Use questions, short activities or polls to keep the audience involved.
Common mistakes to avoid: reading slides word-for-word, overloading slides with text, speaking too fast, poor time management, ignoring audience reactions, and inadequate rehearsal.
- Class project: A student presents a science-project poster at the school exhibition, using a short slide deck, a demonstration and Q&A.
- School debate/seminar: A presenter explains a topic to classmates, using clear structure, examples and confident delivery.
- Online class presentation: A student shares slides over a video call, checks audio/video, uses screen sharing and interacts via chat or polls.
- Job interview or college admission talk: Delivering a short presentation about personal achievements and future goals, focused and well-rehearsed.
- Sales pitch or fundraiser: Presenting a product or idea to persuade an audience to buy or support by following AIDA (Attention, Interest, Desire, Action).
- Science fair demonstration: Combining spoken explanation, visual display and practical demo while managing the allotted time.
- \[Effective Presentation = Clear Objective + Organized Content + Engaging Delivery + Relevant Visuals + Practice\]
- \[Time allocation (rule of thirds) = 10% Introduction + 80% Body + 10% Conclusion\]
- \[5×5 Slide guideline = max 5 bullet points × ~5 words per point (keeps slides concise)\]
- \[PEEL for each point = Point + Evidence + Explanation + Link (to next point)\]
- \[AIDA (for persuasive talks) = Attention → Interest → Desire → Action\]
Databases and Data Management
Databases and Data Management
Key Point: Basic SQL operations (templates): INSERT: INSERT INTO table_name (columns) VALUES (values); SELECT: SELECT columns FROM table_name WHERE condition; UPDATE: UPDATE table_name SET column = value WHERE condition; DELETE: DELETE FROM table_name WHERE condition;
What is a database? A database is an organized collection of related information (data) stored so it can be easily accessed, managed and updated. A DBMS (Database Management System) is software that lets you create, read, update and delete data in a database (examples: MySQL, SQLite, MS Access).
Basic terms:
- Table: Collection of records (rows) and fields/columns (attributes).
- Record (row): One item or entity in a table (e.g., one student).
- Field/Attribute (column): One type of information stored about each record (e.g., name, roll no.).
- Primary Key: A column (or set) that uniquely identifies each record (e.g., student_id).
- Foreign Key: A column that links a record to a primary key in another table (enforces relationships).
- Schema: Structure/blueprint of the database (tables, fields, types, relationships).
Operations (CRUD): Create (INSERT), Read (SELECT), Update (UPDATE), Delete (DELETE). These are the basic operations on data.
Data integrity & consistency: Rules and constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY) ensure correctness. ACID properties of transactions describe reliable processing: Atomicity, Consistency, Isolation, Durability.
Relationships between tables: One-to-One, One-to-Many, Many-to-Many. Use foreign keys to implement relationships. Many-to-many uses a junction table.
Normalization: Process of organizing tables to reduce redundancy and improve integrity. Typical normal forms taught at basic level:
- 1NF (First Normal Form): Each field contains atomic (single) values; no repeating groups.
- 2NF (Second Normal Form): In 1NF and every non-key attribute is fully functionally dependent on the primary key (applies when composite keys exist).
- 3NF (Third Normal Form): In 2NF and no transitive dependency (non-key attributes depend only on primary key).
Indexing: Indexes are data structures that speed up search queries on large tables (like an index in a book). They trade off extra storage and slower writes for faster reads.
Backups and security: Regular backups protect against data loss. Access control (users/roles/permissions) and encryption protect data privacy.
How a simple database is designed (steps):
- Identify entities (e.g., Students, Courses, Teachers).
- List attributes for each entity (e.g., student_name, roll_no, DOB).
- Choose primary keys for each table.
- Identify relationships and add foreign keys.
- Normalize tables up to 3NF where needed.
- Create indexes on columns used in WHERE/JOIN clauses for performance.
Example SQL snippets: Use these as templates when working with a relational DBMS:
CREATE TABLE Students (student_id INT PRIMARY KEY, name TEXT, class INT, dob DATE);INSERT INTO Students VALUES (101, 'Rita', 10, '2010-04-12');SELECT name, class FROM Students WHERE class = 10;UPDATE Students SET name = 'Rita K' WHERE student_id = 101;DELETE FROM Students WHERE student_id = 999;
Practical tips for students: Use meaningful table and column names, enforce primary keys, avoid duplicate data, make periodic backups, and test queries on a small dataset first.
When to use a database? Use a database when you must store structured information that needs searching, sorting, reporting, enforcing rules and supporting multiple users (e.g., school records, inventory systems, bank accounts).
- School management: Tables for Students, Teachers, Classes, and Exams. Use student_id as primary key and class_id as foreign key to link student to class.
- Library system: Books table (book_id, title, author), Members table (member_id, name), Borrowings table (borrow_id, book_id, member_id, borrow_date) to track which member borrowed which book.
- Inventory for a shop: Products table (product_id, name, price, stock), Sales table (sale_id, product_id, quantity, sale_date) to update stock and compute daily revenue.
- Bank accounts: Customers table, Accounts table (account_no as primary key), Transactions table to record deposits/withdrawals. Transactions must be ACID-compliant to avoid inconsistent balances.
- Hospital records: Patients, Doctors, Appointments tables. Appointments links patient_id and doctor_id and stores date/time and status.
- \[Basic SQL operations (templates): INSERT: INSERT INTO table_name (columns) VALUES (values)\]\[SELECT: SELECT columns FROM table_name WHERE condition\]\[UPDATE: UPDATE table_name SET column = value WHERE condition\]\[DELETE: DELETE FROM table_name WHERE condition\]
- \[Estimated storage for a table: Estimated size ≈ SUM over columns (average_bytes_per_column) × number_of_rows + index_overhead + DBMS_overhead. (Use measured column sizes for accuracy.)\]
- \[Aggregate queries (common computations): COUNT: SELECT COUNT(*) FROM table WHERE condition\]\[SUM: SELECT SUM(amount) FROM sales WHERE date = 'yyyy-mm-dd'\]\[AVG: SELECT AVG(mark) FROM exams WHERE subject = 'Math'\]
- \[Normalization rule (informal): If attribute B depends on attribute A (A → B)\]\[then store B with A's table\]\[avoid storing B multiple places\]\[Remove partial or transitive dependencies to reach 2NF/3NF.\]
- \[Referential integrity rule (constraint): For every foreign key value f in child table\]\[there must exist a matching primary key value p in parent table\]\[Enforced as: FOREIGN KEY (f) REFERENCES Parent(p).\]
Networking and Internet Fundamentals
Networking and Internet Fundamentals
Key Point: Bits = Bytes × 8 (example: 5 MB = 5 × 1024 × 1024 bytes = bytes × 8 bits)
Overview: A computer network is a collection of computers and devices linked to share resources and information. The Internet is a global network of networks that uses standard protocols to exchange data.
Why networks matter: They enable communication (email, chat), resource sharing (printers, files), remote services (cloud, web), and multimedia (video calls, streaming).
Types of networks:
- LAN (Local Area Network): small area such as a home, school or office.
- WAN (Wide Area Network): covers large geographic areas; often built from multiple LANs.
- PAN (Personal Area Network): very short range around a person (Bluetooth).
- MAN (Metropolitan Area Network): spans a city or campus.
Topologies: physical or logical layout of nodes. Common topologies: star, bus, ring and mesh. Choice affects performance, reliability and cost.
Network devices:
- NIC (Network Interface Card): connects a device to a network.
- Hub: broadcasts incoming data to all ports (rare now).
- Switch: forwards data only to the destination port using MAC addresses.
- Router: connects different networks and routes packets (often the device provided by your ISP).
- Modem: converts digital signals to/from analog for transmission over phone or cable lines.
- Firewall: blocks or allows traffic based on security rules.
Addresses and identifiers:
- IP address: unique logical address for a device on IP networks. IPv4 uses 32 bits (example 192.168.1.10). IPv6 uses 128 bits (hexadecimal).
- MAC address: hardware address on the network interface, 48-bit, shown in hex (example 00:1A:2B:3C:4D:5E).
- Domain name: human-readable name (example example.com) resolved to an IP by DNS (Domain Name System).
Protocols: Rules that govern communication. Important ones:
- TCP/IP: core protocol suite of the Internet. TCP provides reliable delivery; IP handles addressing and routing.
- HTTP/HTTPS: used for web traffic. HTTPS uses TLS/SSL encryption (secure).
- FTP: file transfer.
- SMTP, POP3, IMAP: email sending and retrieval.
- DNS: resolves domain names to IP addresses.
How data moves: The Internet uses packet switching. Large messages are split into packets. Packets travel independently and are reassembled at the destination. Each packet contains headers with source/destination addresses.
Performance terms:
- Bandwidth: maximum data rate of a link (bits per second, bps).
- Throughput: actual achieved data rate (bps).
- Latency (delay): time taken for a packet to travel from source to destination.
- Jitter: variation in packet delay (important for voice/video).
Security basics: Use strong passwords, keep systems updated, use HTTPS, enable firewalls and antivirus, be cautious with links/attachments. VPNs create encrypted tunnels for privacy.
Everyday Internet components: ISP (Internet Service Provider) supplies Internet access; browser accesses web pages; URL (Uniform Resource Locator) points to web resources; search engines help find information.
Common classroom/real-life uses: online research, cloud storage, email, e-learning platforms, video conferencing, IoT devices at home.
- Home Wi-Fi network: a router connects multiple devices (phones, laptops, smart TV) to the Internet via an ISP using a single public IP; devices have private IPs such as 192.168.0.x.
- School LAN: computers and a printer are connected by switches; teacher shares files from a local server.
- Video call: many small packets of audio/video travel over the Internet; low latency and sufficient bandwidth are needed for good quality.
- Email exchange: your mail client uses SMTP to send mail to a mail server and POP3/IMAP to retrieve messages.
- Cloud storage: files are uploaded to remote servers via HTTP/HTTPS and can be accessed from any device with credentials.
- \[Bits = Bytes × 8 (example: 5 MB = 5 × 1024 × 1024 bytes = bytes × 8 bits)\]
- \[Throughput = Total data (bits) / Total time (seconds) (gives bps)\]
- \[Transmission delay = Packet size (bits) / Bandwidth (bps)\]
- \[Propagation delay = Distance (meters) / Propagation speed (m/s) (propagation speed in copper/fiber ≈ 2 × 10^8 m/s)\]
- \[End-to-end delay ≈ Transmission delay + Propagation delay + Queuing delay + Processing delay\]
Email and Online Communication
Email and Online Communication
Key Point: Email address format: local-part@domain (example: student@school.edu)
Overview
Email and online communication cover digital methods for exchanging information over the Internet — primarily email, instant messaging, forums, and video conferencing. These tools are used for personal, educational and professional communication and require understanding of structure, protocols, security and etiquette.
Email: Components and Workflow
- Parts of an email: To (recipient), Cc (carbon copy), Bcc (blind carbon copy), Subject, Body, Attachments, Signature.
- Sending/Receiving process: Compose → Mail client forwards message to SMTP server → SMTP delivers to recipient's mail server → Recipient fetches with POP3 or IMAP (IMAP keeps mail on server; POP3 downloads it).
- Common protocols: SMTP (sending), IMAP and POP3 (receiving), HTTPS for webmail access.
Online Communication Tools
- Instant Messaging / Chat: Real-time text, often with presence indicators (online/offline).
- Video Conferencing: Audio + video + screen sharing for remote meetings (e.g., Zoom, Google Meet).
- Forums and Discussion Boards: Asynchronous threaded discussions for classes or communities.
- Collaborative Platforms: Shared documents, comments, version history (e.g., Google Docs, Microsoft 365).
Security and Privacy
- Use strong passwords, enable two-factor authentication (2FA).
- Beware of phishing: check sender address, do not click suspicious links or open unexpected attachments.
- Use secure connections (HTTPS, TLS for email) and, when needed, end-to-end encryption.
- Keep software and antivirus updated.
Netiquette (Online Etiquette)
- Write clear, polite subject lines and concise bodies.
- Use proper salutations and signatures in formal emails.
- Reply promptly to important messages; use Reply All sparingly.
- Respect privacy: use Bcc for large recipient lists to hide addresses.
Practical Tips
- Organize with folders/labels and use filters to automate sorting.
- Compress large attachments or share cloud links to avoid mailbox limits.
- Proofread before sending; include contact details in signature for formal emails.
Example Formal Email Template
Subject: Request for Project Extension Dear Ms. Sharma, I hope you are well. I am writing to request a two-day extension for submitting my ICT project due to illness. I have completed most of the work and will submit by Friday, 10 October. Thank you for your consideration. Sincerely, A. Kumar Class 10B
Key Differences Between Tools
- Email: best for formal, asynchronous, long-form communication and records.
- Chat/IM: quick, informal, synchronous short messages.
- Video calls: verbal/nonverbal interaction for meetings and teaching.
Summary
Email and online communication tools are essential skills: know structure and protocols, follow security practices, apply netiquette, organize content, and choose the appropriate medium for the message.
- Student submits assignment to teacher by email with subject 'Math Assignment - Rahul Sharma - Class 10'.
- A job applicant sends resume and cover letter to HR using an email with proper salutation and attachment in PDF format.
- A group of students uses a shared Google Doc and email threads to coordinate a class project; they use comments and version history to track changes.
- Teacher schedules an online parent-teacher meeting using video conferencing (Google Meet) and sends the invite link via email.
- A company newsletter sent by email to subscribers using Bcc to protect recipient privacy and a clear unsubscribe link for compliance.
- \[Email address format: local-part@domain (example: student@school.edu)\]
- \[URL format: protocol://domain/path (example: https://www.example.com/assignments)\]
- \[Download time (seconds) = File size (MB) × 8 / Bandwidth (Mbps) — converts MB to Mb by ×8\]
- \[Total mailbox usage (MB) = sum of sizes of all emails + attachments\]
- \[Throughput = Data transferred / Time taken (useful to estimate sending large attachments)\]
Cyber Security and Safety
Cyber Security and Safety
Key Point: Risk = Likelihood × Impact (used to prioritize security actions)
What is Cyber Security and Safety?
Cyber security is the practice of protecting computers, networks, programs and data from unauthorized access, attack, damage or theft. Cyber safety focuses on safe and responsible use of the internet and digital devices by individuals to protect privacy, identity and wellbeing.
Core principles (CIA)
- Confidentiality – ensure information is accessible only to those authorized.
- Integrity – ensure information is accurate and untampered.
- Availability – ensure information and systems are available when needed.
Common threats
- Malware: viruses, worms, trojans, ransomware that damage or lock data.
- Phishing: fraudulent emails or messages tricking users into revealing credentials or clicking malicious links.
- Social engineering: manipulation to extract confidential info.
- Man-in-the-middle: interception of communication between two parties.
- DDoS: distributed denial-of-service attacks making services unavailable.
- Password attacks: guessing, brute-force, or credential stuffing.
Safe practices (how to stay secure)
- Use strong, unique passwords and a password manager.
- Enable two-factor authentication (2FA) wherever possible.
- Keep operating systems, apps and antivirus software up to date.
- Be cautious with email links and attachments; verify senders.
- Use secure Wi‑Fi (WPA2/WPA3) and avoid public Wi‑Fi for sensitive tasks without a VPN.
- Back up important data regularly and test restores.
- Limit personal information shared on social media and check privacy settings.
- Install apps only from trusted stores and review app permissions.
- Educate family and peers about scams, especially children and elderly users.
What to do after an incident
- Isolate the affected device (disconnect from network).
- Change compromised passwords from a secure device.
- Run antivirus scans and restore data from backups if needed.
- Report serious incidents to school/organization IT and to appropriate authorities.
Role of encryption and authentication
Encryption converts readable data (plaintext) into unreadable form (ciphertext) so only authorized parties can read it. Authentication methods (passwords, biometrics, 2FA) confirm a user’s identity.
Importance for students and everyday life
Cyber security and safety help protect personal photos and schoolwork, prevent identity theft, keep online accounts secure, and ensure safe use of social media and online learning platforms.
- Phishing email pretending to be the school admin asking students to ‘confirm’ login details — result: credentials stolen. Safe action: verify sender address, do not click links, report to admin.
- Ransomware encrypts files on a family computer and demands payment. Safe action: disconnect from network, use clean backup to restore, report to authorities.
- Using public Wi‑Fi at a café to access a bank account without VPN — risk of data interception. Safe action: use mobile data or VPN, enable HTTPS.
- Weak password like 'password123' on an email account leads to unauthorized access. Safe action: create a long, unique password or use a password manager and enable 2FA.
- A student overshares personal location and schedule on social media, enabling stalking or burglary. Safe action: tighten privacy settings and avoid posting real-time location.
- \[Risk = Likelihood × Impact (used to prioritize security actions)\]
- \[Password entropy (approx) = L × log2(R) where L = password length\]\[R = size of character set (e.g., 26 lowercase + 26 uppercase + 10 digits + symbols)\]
- \[Encryption notation: C = E_k(P)\]\[P = D_k(C) where P = plaintext\]\[C = ciphertext\]\[E_k = encryption with key k\]\[D_k = decryption with key k\]
- \[Hash property (conceptual): H = hash(M)\]\[small change in M ⇒ large\]\[unpredictable change in H\]\[Hashes are one-way: cannot retrieve M from H.\]
- \[Shannon-Hartley (advanced\]\[conceptual) channel capacity: C = B × log2(1 + S/N) where B = bandwidth\]\[S/N = signal-to-noise ratio\]
Multimedia and Digital Media
Multimedia and Digital Media
Key Point: Image file size (uncompressed) = width × height × color_depth (bits) / 8 → bytes. Example: 1920×1080×24 / 8 ≈ 6,220,800 bytes (≈ 5.93 MB).
Definition
Multimedia combines two or more content forms — text, images/graphics, audio, video and animation — into a single interactive application or presentation. Digital media is any media encoded in binary form (0s and 1s) so it can be created, stored, transmitted and processed by computers (examples: JPEG, MP3, MP4, PNG, PDF).
Components of Multimedia
- Text: Titles, captions, descriptions.
- Images/Graphics: Photographs, icons, illustrations (PNG, JPEG, SVG).
- Audio: Speech, music, sound effects (WAV, MP3).
- Video: Moving images with or without sound (MP4, AVI, MKV).
- Animation: Frame-by-frame or programmatic motion (GIF, CSS/JS animations).
- Interactivity: Buttons, quizzes, hyperlinks, navigation controls.
How digital media is represented
All digital media is stored as binary. Different formats and codecs determine how content is encoded and compressed. Important ideas:
- Resolution (images/video) — pixels across width × height.
- Color depth — bits per pixel (e.g., 24-bit color = 8 bits per R,G,B channel).
- Sampling rate (audio) — samples per second in Hz (e.g., 44.1 kHz).
- Bit depth (audio) — bits per sample (e.g., 16-bit).
- Frame rate (video) — frames per second (fps).
File size basics (concept)
Uncompressed file size grows with resolution, color depth, sampling rate, frame rate and duration. Compression (lossless or lossy) reduces file size at cost of processing time or quality loss.
Creation pipeline
- Capture (camera, microphone, scanner)
- Editing (cutting, color correction, adding text/audio)
- Encoding/Compression (choose codec/format)
- Distribution (web, streaming, storage)
- Playback (player software, browsers, devices)
Common formats and uses
- Images: JPEG (photo, lossy), PNG (transparency, lossless), SVG (scalable vector)
- Audio: MP3 (lossy, small files), WAV (uncompressed), AAC (efficient lossy)
- Video: MP4/H.264 (widely used, efficient), WebM, AVI
- Animation: GIF (short animations), HTML5/CSS/JS for interactive animation
Advantages
- Engaging — combines senses (sight, hearing)
- Flexible — reusable, searchable, easy to distribute
- Interactive learning — simulations, quizzes, multimedia lessons
Limitations / Challenges
- Large file sizes and bandwidth demands
- Compatibility and codec issues
- Accessibility needs (captions, alt text) and copyright concerns
Best practices
- Choose appropriate formats (PNG for lossless images with transparency, JPEG for photos)
- Optimize for web (compress, resize, use responsive media)
- Include captions/transcripts for accessibility
- Use metadata and descriptive filenames for searchability
Simple example calculations (conceptual)
Image: an uncompressed 1920×1080 image at 24-bit color size = 1920×1080×24 bits = 49,766,400 bits ≈ 6.0 MB (divide by 8 to get bytes, then by 1024² for MB). Audio: 44.1 kHz × 16-bit × 2 channels for 60 seconds = 44,100×16×2×60 bits = 846,720,000 bits ≈ 100.8 MB uncompressed.
Educational / Real-life uses
Digital classrooms, e-books with embedded audio/video, advertisements, streaming services, podcasts, interactive museum kiosks, virtual tours and augmented reality learning tools.
- A teacher creates an interactive lesson with text, images, short videos and quizzes (PowerPoint/HTML5).
- A photographer exports web photos as JPEG (smaller, lossy) and prints as PNG or TIFF (lossless/high quality).
- A podcast recorded in WAV is edited and exported as MP3 to reduce file size for distribution.
- YouTube videos are uploaded in MP4 (H.264) for streaming; the platform re-encodes to different bitrates for adaptive streaming.
- An e-commerce site uses SVG logos (scalable) and compressed PNG product images to balance quality and page load time.
- \[Image file size (uncompressed) = width × height × color_depth (bits) / 8 → bytes\]\[Example: 1920×1080×24 / 8 ≈ 6,220,800 bytes (≈ 5.93 MB).\]
- \[Audio file size (uncompressed) = sampling_rate (Hz) × duration (s) × bit_depth × channels / 8 → bytes\]\[Example: 44,100 × 60 × 16 × 2 / 8 ≈ 100,800,000 bytes (≈ 96.2 MB).\]
- \[Video file size (approx\]\[uncompressed) = width × height × color_depth × frame_rate × duration / 8 → bytes. (Usually huge\]\[use codecs.)\]
- \[Compressed file size = uncompressed_size / compression_ratio\]\[Compression ratio depends on codec and settings.\]
- \[Nyquist sampling rule (audio) → sampling_rate > 2 × maximum_audio_frequency to avoid aliasing\]\[Example: for 20 kHz audio\]\[sampling_rate > 40 kHz.\]
Cloud Computing and Online Services
Cloud Computing and Online Services
Key Point: Availability (%) = (Uptime / Total time) × 100
What is Cloud Computing?
Cloud computing is the delivery of computing services—servers, storage, databases, networking, software, analytics and intelligence—over the Internet (“the cloud”) to offer faster innovation, flexible resources and economies of scale. Users access these services on demand without owning or managing the underlying physical infrastructure.
Key Characteristics
- On-demand self-service: Users can provision services as needed without human interaction with the service provider.
- Broad network access: Services are available over the network and accessed through standard mechanisms (web browsers, mobile apps).
- Resource pooling: Provider’s resources serve multiple users dynamically.
- Rapid elasticity: Resources scale up or down quickly according to demand.
- Measured service: Usage is monitored, controlled and reported (pay-as-you-go).
Service Models
- IaaS (Infrastructure as a Service): Rent virtual machines, storage, and networks (e.g., AWS EC2, Google Compute Engine).
- PaaS (Platform as a Service): Provide platforms for developing and deploying apps without managing OS (e.g., Google App Engine, Heroku).
- SaaS (Software as a Service): Ready-to-use applications accessed through a browser (e.g., Gmail, MS 365).
Deployment Models
- Public cloud: Services offered over the public internet by providers to multiple customers.
- Private cloud: Cloud infrastructure dedicated to a single organization.
- Hybrid cloud: Combination of public and private clouds, allowing data and application portability.
Benefits
- Cost savings (no large capital expenditure on hardware)
- Scalability and flexibility
- Improved collaboration and remote access
- Automatic updates, backups and disaster recovery options
Risks and Considerations
- Security and data privacy concerns (data stored off-site)
- Dependence on internet connectivity
- Possible vendor lock-in
- Variable costs if usage not monitored
Online Services (Common Examples)
Online services are cloud-hosted applications that users access via a web browser or app. They include:
- Email services (Gmail, Outlook.com)
- File storage and sharing (Google Drive, Dropbox, OneDrive)
- Office productivity suites (Google Workspace, Microsoft 365)
- Streaming services (Netflix, Spotify)
- Communication and meetings (Zoom, Microsoft Teams)
- Educational platforms (Google Classroom, Coursera)
- Business applications (Salesforce CRM)
How Schools and Students Use Cloud Services
Students and schools use cloud services for email, collaborative documents, online assignments, virtual classrooms, backup of student work, and hosting school websites. Benefits include easy collaboration, access from anywhere, and minimal IT maintenance for schools.
Best Practices
- Use strong passwords and multi-factor authentication (MFA).
- Understand provider’s data location and backup policies.
- Monitor usage and set budgets to avoid unexpected costs.
- Keep local copies of critical data where needed.
Summary
Cloud computing and online services transform how computing resources and applications are delivered and consumed. They enable flexible, cost-effective solutions for individuals, schools and businesses but require attention to security, privacy and cost management.
- Gmail (email accessed via browser/mobile) — SaaS for communication
- Google Drive / OneDrive — cloud storage for files and automatic backups
- Microsoft 365 / Google Workspace — cloud-based office applications (documents, sheets, slides) allowing real-time collaboration
- AWS S3 / Azure Blob Storage — object storage for websites, backups and big data (IaaS)
- Zoom / Microsoft Teams — video conferencing and remote classrooms
- Netflix / Spotify — streaming media delivered from cloud servers
- \[Availability (%) = (Uptime / Total time) × 100\]
- \[Availability (MTBF/MTTR) = MTBF / (MTBF + MTTR) — where MTBF = mean time between failures\]\[MTTR = mean time to repair\]
- \[Estimated Monthly Cost = (Compute hours × compute rate) + (Storage GB × storage rate) + (Data transfer GB × transfer rate)\]
- \[Throughput = Total data transferred (GB) / Time (s or hours)\]
- \[Response Time ≈ Network latency + Server processing time + Queuing delay\]
- \[Downtime per year (hours) = (1 - Availability) × 8760\]\[Example: For 99.9% availability\]\[downtime ≈ 0.001 × 8760 ≈ 8.76 hours/year\]
ICT in Society and e-Governance
ICT in Society and e-Governance
Key Point: Internet Penetration Rate (%) = (Number of Internet Users / Total Population) × 100 — measures digital access in society.
Overview
Information and Communication Technology (ICT) in society refers to the use of digital tools (computers, internet, mobile devices, software) to access, process, store and share information. e-Governance is the application of ICT by government agencies to deliver information and public services to citizens (G2C), businesses (G2B), other government departments (G2G) and employees (G2E).
Key Components
- Infrastructure: networks, data centres, broadband, mobile networks.
- Applications & Services: portals, mobile apps, e-payments, databases.
- Human resources: skilled IT staff, digital literacy for users.
- Legal & Policy Framework: data protection, IT laws, standards.
- Content & Interoperability: open data, standardized formats, APIs.
Principles of e-Governance
- Transparency — public access to information and processes.
- Accountability — audit trails and traceability of decisions.
- Accessibility — services available to all (including differently-abled).
- Efficiency & Speed — faster service delivery and reduced paperwork.
- Participation — enabling citizen feedback and engagement.
Advantages
- Faster, cheaper delivery of public services (e.g., online forms, certificates).
- Reduced corruption through automation and audit logs.
- Improved access to information across remote areas.
- Better decision-making using digital data and analytics.
Social Impacts
ICT and e-Governance can bridge information gaps, improve education and health access, boost financial inclusion (digital payments) and support economic activities. However, they can also widen the digital divide if infrastructure and digital skills are unequal, and raise privacy and security concerns.
Common e-Governance Service Types
- G2C (Government to Citizen): e-citizen portals, online tax filing, social benefit disbursement.
- G2B (Government to Business): business registrations, e-procurement, licenses.
- G2G (Government to Government): inter-department data sharing, central registries.
- G2E (Government to Employee): payroll, training, HR systems.
Challenges
- Digital divide (connectivity and literacy gaps).
- Cybersecurity risks and data privacy concerns.
- Resistance to change and need for capacity building.
- Interoperability and legacy system integration.
Best Practices & Success Factors
- User-centric service design and mobile-first approaches.
- Open standards and APIs for interoperability.
- Strong legal frameworks for privacy and cybersecurity.
- Promotion of digital literacy and inclusive access (public kiosks, community centres).
- Aadhaar-based authentication for subsidies and welfare payments (reduces duplication and leakages).
- Income Tax e-filing portal — citizens file returns online, get faster refunds.
- GST portal — unified online tax filing and return reconciliation for businesses.
- UMANG app — single mobile app for many Indian government services (pay, apply, track).
- e-Health / telemedicine — remote consultations, electronic medical records.
- e-Procurement platforms — transparent bidding and procurement for government tenders.
- \[Internet Penetration Rate (%) = (Number of Internet Users / Total Population) × 100 — measures digital access in society.\]
- \[Service Uptime (%) = (Total Uptime ÷ Total Time Period) × 100 — indicates reliability of an e-service.\]
- \[Transaction Success Rate (%) = (Successful Transactions ÷ Total Transactions Attempted) × 100 — gauges e-service effectiveness.\]
- \[Average Response Time = (Sum of Response Times for all Requests) ÷ (Number of Requests) — used to measure user experience.\]
- \[Cost Savings = Cost(manual process) − Cost(automated ICT process) — simple measure of financial benefit.\]
- \[Return on Investment (ROI) (%) = ((Net Benefit − Cost) ÷ Cost) × 100 — economic evaluation of ICT projects.\]
Emerging Technologies and Trends
Emerging Technologies and Trends
Key Point: Moore's Law (empirical): transistor_count ≈ transistor_count_0 × 2^(t/2 years) — transistors roughly double every ~2 years (historical observation).
Emerging technologies are new or rapidly improving digital, physical and biological tools and systems that change how people live, work and learn. For Class 10 ICT Skills, understanding these technologies helps students become aware of future workplaces and required skills.
Major technologies and short descriptions:
- Artificial Intelligence (AI) and Machine Learning (ML): Systems that learn from data to make predictions or decisions. Examples: virtual assistants, recommendation engines.
- Internet of Things (IoT): Network of connected devices (sensors, appliances) that collect and exchange data. Example: smart homes, wearable health trackers.
- 5G and Advanced Connectivity: Faster, lower-latency mobile networks enabling real-time services like remote surgery, high-quality AR/VR streaming.
- Cloud and Edge Computing: Cloud provides centralized scalable processing and storage; edge computing processes data near the source to reduce latency (important for autonomous vehicles, industrial control).
- Augmented Reality (AR) and Virtual Reality (VR): Immersive technologies used in gaming, training simulations and virtual labs.
- Blockchain: Distributed ledger technology for secure, tamper-evident records; used in supply chains and digital identity.
- Robotics and Automation: Robots and software automation (RPA) that perform repetitive or precise tasks in manufacturing, agriculture and services.
- 3D Printing (Additive Manufacturing): Layer-by-layer fabrication for rapid prototyping, custom medical devices and small-scale manufacturing.
- Quantum Computing (emerging research area): Uses quantum phenomena to solve certain problems faster than classical computers; still largely experimental.
Key trends shaping how these technologies spread and affect society:
- Convergence: Multiple technologies combine (e.g., AI + IoT = smart predictive systems).
- Democratization: Tools and platforms make technology accessible to more people (low-code/no-code, cloud services).
- Edge-to-cloud continuum: Workloads split between cloud and edge for performance, cost and privacy reasons.
- Focus on privacy, security and ethics: As data use grows, laws, security measures and ethical AI become crucial.
- Green computing and sustainability: Energy-efficient designs and circular-economy thinking to reduce environmental impact.
- Lifelong learning and upskilling: Demand for digital, data and critical-thinking skills increases; soft skills remain important.
Impact for students and practical skills to learn:
- Basic programming and computational thinking
- Data literacy: collect, clean, visualize and interpret data
- Digital citizenship: privacy, safe online behaviour and ethics
- Familiarity with cloud tools, collaboration platforms and simple IoT kits
Summary: Emerging technologies are not isolated — they form ecosystems that transform industries and daily life. Awareness and foundational skills (coding, data handling, cyber hygiene and problem-solving) prepare students for future opportunities.
- AI: Virtual assistants like Google Assistant and recommendation systems on Netflix or YouTube.
- IoT: Smart thermostats (Nest), wearable fitness trackers (Fitbit) and smart agriculture sensors that monitor soil moisture.
- 5G: High-quality mobile video calling, remote learning with interactive AR content, and industrial automation with low latency.
- Cloud computing: Google Drive, Microsoft OneDrive and AWS hosting school websites and online classrooms.
- Edge computing: Self-driving cars processing sensor data locally to make instant decisions.
- AR/VR: Pokémon Go (AR) and VR labs used for virtual chemistry experiments or history tours.
- \[Moore's Law (empirical): transistor_count ≈ transistor_count_0 × 2^(t/2 years) — transistors roughly double every ~2 years (historical observation).\]
- \[Metcalfe's Law (network value): Value ∝ n^2\]\[where n is number of connected users/devices (approximation of network effect).\]
- \[Shannon–Hartley Theorem (communication capacity): C = B × log2(1 + S/N) where C is channel capacity in bits/sec\]\[B is bandwidth in Hz\]\[S/N is signal-to-noise ratio.\]
- \[CAGR (Compound Annual Growth Rate): CAGR = (EndingValue / StartingValue)^(1/years) - 1 — used to express growth of devices\]\[users or revenue over time.\]
- \[Exponential growth model: P(t) = P0 × e^(r × t)\]\[where P0 is initial size\]\[r is growth rate\]\[t is time (useful for forecasting rapid adoption phases).\]
Practical ICT Skills and Professional Practice
Practical ICT Skills and Professional Practice
Key Point: File size conversions: 1 KB = 1024 bytes, 1 MB = 1024 KB, 1 GB = 1024 MB.
Overview: Practical ICT Skills and Professional Practice covers hands‑on use of information and communication technologies in everyday and workplace situations. It teaches how to create, manage, share and protect digital information while following professional norms and ethics.
Core areas:
- Productivity tools: Word processing (documents, templates, mail merge), spreadsheets (formulas, functions, charts), and presentations (slides, multimedia, slide design).
- File & data management: Naming conventions, folder structures, backup and recovery, file formats (DOCX/PDF/CSV/JPG), and basic data organization.
- Internet & communication: Effective email use (subject lines, attachments, etiquette), online collaboration (cloud drives, shared documents), and virtual meeting best practices.
- Security & digital citizenship: Strong passwords, two‑factor authentication, recognising phishing, safe browsing, intellectual property and proper citation.
- Basic networks & hardware awareness: Understanding bandwidth, Wi‑Fi basics, peripheral setup and routine troubleshooting.
- Professional practice: Creating CVs/portfolios, maintaining e‑portfolios, version control (file versions/track changes), workplace communication standards, accessibility and inclusion.
Skills emphasised: accuracy, clarity, time management, collaboration, data privacy, and ethical behaviour. Students learn to produce clear professional documents, use spreadsheets to analyse data, present findings visually, protect digital assets, and collaborate online.
Assessment tasks (typical): prepare a professional resume (PDF), make a budget spreadsheet with formulas and charts, design a slide deck for a project, set up a shared folder and manage file versions, and write a formal email with attachments.
Best practices:
- Use descriptive filenames and dates (e.g., "ProjectReport_2025-10-11_v1.pdf").
- Keep backups (local + cloud) and test restores periodically.
- Apply least privilege: share only necessary files and grant minimal access rights.
- Follow accessible design: use readable fonts, alt text for images, and sufficient contrast.
- Document work and keep version notes when collaborating.
- Create a monthly expenses spreadsheet using SUM and AVERAGE, add a pie chart showing expense categories, and export it as PDF to share with parents.
- Write a formal email to a school coordinator with subject line, greeting, concise body, attachment (project report), and a polite closing; include a professional signature.
- Prepare a resume in a word processor, convert it to PDF, and upload to a cloud folder with restricted sharing for job/internship applications.
- Calculate how long a video will take to download: if video = 500 MB and internet = 5 Mbps, compute download time (see formula list).
- Set up a shared Google Drive folder for a group project, use shared editing, track changes, and keep versions by naming iteratively (v1, v2).
- Secure personal accounts with strong passwords, enable two‑factor authentication, and recognise a sample phishing email by checking sender address and links.
- \[File size conversions: 1 KB = 1024 bytes, 1 MB = 1024 KB, 1 GB = 1024 MB.\]
- \[Download time (seconds) = (file size in bits) / (bandwidth in bits per second)\]\[Example: 500 MB = 500×1024×1024×8 bits.\]
- \[Download time (seconds) = (file size in MB × 8) / (bandwidth in Mbps)\]\[Example: (500 × 8) / 5 = 800 seconds ≈ 13.3 minutes.\]
- \[Compression ratio = original size / compressed size. (Higher ratio = more compression.)\]
- \[Pixel count = image width (pixels) × image height (pixels).\]
- \[Physical image size (in inches) = pixels / PPI\]\[Example: width_in_inches = pixel_width ÷ PPI.\]
Key Concepts
- ICT (Information and Communication Technology)
- The combined use of computer hardware, software and communication technologies to store, process, transmit and retrieve information.
- Hardware
- The physical components of a computer system that you can touch and see.
- Software
- A set of instructions or programs that tell the hardware what to do.
- Operating System
- System software that manages hardware and software resources and provides a user interface.
- Application Software
- Programs designed to help users perform specific tasks or activities.
- Input Device
- Hardware used to enter data or control signals into a computer.
- Output Device
- Hardware that presents processed data to the user.
- Storage Device
- Hardware used to save and retrieve digital data for short or long term.
- Network
- A group of two or more interconnected computers that share resources and information.
- LAN (Local Area Network)
- A network that connects devices within a limited area like a building or campus.
- WAN (Wide Area Network)
- A network that covers large geographic areas, connecting multiple LANs.
- Internet
- A global network of networks that provides services like the World Wide Web, email and file transfer.
- Intranet
- A private network within an organization that uses internet technologies for internal communication and services.
- Modem
- A device that converts digital signals from a computer into analog signals for transmission and vice versa.
- Router
- A network device that forwards data packets between different networks and often provides Wi‑Fi.
- Browser
- Software used to access, retrieve and display web pages on the World Wide Web.
- Search Engine
- An online tool that helps locate information on the internet using keywords.
- A method to send and receive electronic messages over computer networks.
- Cloud Computing
- Provision of computing services (storage, servers, applications) over the internet on demand.
- Database
- An organized collection of structured information stored electronically for easy access and management.
Practice Questions
-
Define ICT and name its core components. / ICT को परिभाषित कीजिए और इसके मुख्य घटकों के नाम बताइए।
Show answer
ICT (Information and Communication Technology) is the set of tools, systems and processes used to create, store, process, transmit and present information; its core components are hardware, software, networks, data, and people & procedures. / ICT (सूचना एवं संचार प्रौद्योगिकी) उन उपकरणों, प्रणालियों और प्रक्रियाओं का समूह है जिनसे सूचना को बनाया, संग्रहीत, संसाधित, प्रेषित और प्रस्तुत किया जाता है; इसके मुख्य घटक हार्डवेयर, सॉफ्टवेयर, नेटवर्क, डेटा, तथा लोग एवं प्रक्रियाएँ हैं।
-
Differentiate between system software and application software with one example each. / सिस्टम सॉफ्टवेयर और एप्लिकेशन सॉफ्टवेयर में एक-एक उदाहरण सहित अंतर बताइए।
Show answer
System software manages and controls hardware and provides a platform for other programs, e.g., the Windows operating system; application software performs specific user tasks, e.g., MS Word. / सिस्टम सॉफ्टवेयर हार्डवेयर को प्रबंधित और नियंत्रित करता है तथा अन्य प्रोग्रामों के लिए मंच प्रदान करता है, जैसे विंडोज ऑपरेटिंग सिस्टम; एप्लिकेशन सॉफ्टवेयर विशिष्ट उपयोगकर्ता कार्य करता है, जैसे एमएस वर्ड।
-
Name any four functions of an operating system. / ऑपरेटिंग सिस्टम के कोई चार कार्य बताइए।
Show answer
An operating system performs process management, memory management, file management and device management, and also provides security and a user interface. / ऑपरेटिंग सिस्टम प्रक्रिया प्रबंधन, स्मृति प्रबंधन, फ़ाइल प्रबंधन और डिवाइस प्रबंधन करता है, तथा सुरक्षा और उपयोगकर्ता इंटरफ़ेस भी प्रदान करता है।
-
What is phishing, and state two ways to protect yourself from it. / फिशिंग क्या है, और इससे बचने के दो उपाय बताइए।
Show answer
Phishing is a fraudulent attempt using fake emails or messages to trick users into revealing passwords or clicking malicious links; protect yourself by verifying the sender's address and not clicking suspicious links or opening unexpected attachments. / फिशिंग नकली ईमेल या संदेशों द्वारा किया गया धोखाधड़ीपूर्ण प्रयास है जो उपयोगकर्ताओं को पासवर्ड बताने या दुर्भावनापूर्ण लिंक पर क्लिक करने के लिए छलता है; इससे बचने हेतु प्रेषक का पता सत्यापित करें और संदिग्ध लिंक पर क्लिक न करें या अप्रत्याशित अटैचमेंट न खोलें।
-
Write the spreadsheet formula to calculate the total of marks in cells B2 to G2, and explain the difference between a relative and an absolute cell reference. / B2 से G2 कोशिकाओं में अंकों का योग निकालने के लिए स्प्रेडशीट सूत्र लिखिए, तथा सापेक्ष और निरपेक्ष कोशिका संदर्भ में अंतर समझाइए।
Show answer
The formula is =SUM(B2:G2); a relative reference like A1 changes when the formula is copied, while an absolute reference like $A$1 stays fixed even when copied. / सूत्र है =SUM(B2:G2); A1 जैसा सापेक्ष संदर्भ सूत्र कॉपी करने पर बदल जाता है, जबकि $A$1 जैसा निरपेक्ष संदर्भ कॉपी करने पर भी स्थिर रहता है।
-
State the three core principles of cyber security (the CIA triad) and explain each briefly. / साइबर सुरक्षा के तीन मुख्य सिद्धांत (CIA त्रयी) बताइए और प्रत्येक की संक्षेप में व्याख्या कीजिए।
Show answer
Confidentiality ensures information is accessible only to authorised people, Integrity ensures information is accurate and untampered, and Availability ensures information and systems are available when needed. / गोपनीयता सुनिश्चित करती है कि सूचना केवल अधिकृत व्यक्तियों को मिले, अखंडता सुनिश्चित करती है कि सूचना सही और बिना छेड़छाड़ वाली हो, और उपलब्धता सुनिश्चित करती है कि सूचना और प्रणालियाँ आवश्यकता पड़ने पर उपलब्ध हों।
-
A 4 GB file is copied over a USB connection with a transfer rate of 40 MB/s. Calculate the approximate time taken (take 1 GB = 1024 MB). / 40 MB/s स्थानांतरण दर वाले USB कनेक्शन पर 4 GB की फ़ाइल कॉपी की जाती है। लगभग लगने वाले समय की गणना कीजिए (1 GB = 1024 MB मानें)।
Show answer
Transfer time ≈ File size ÷ Transfer rate = (4 × 1024) MB ÷ 40 MB/s = 4096 ÷ 40 ≈ 102.4 seconds (about 1.7 minutes). / स्थानांतरण समय ≈ फ़ाइल आकार ÷ स्थानांतरण दर = (4 × 1024) MB ÷ 40 MB/s = 4096 ÷ 40 ≈ 102.4 सेकंड (लगभग 1.7 मिनट)।
-
List the parts of an email and explain the difference between Cc and Bcc. / ईमेल के भागों की सूची दीजिए और Cc तथा Bcc में अंतर समझाइए।
Show answer
An email's parts are To, Cc, Bcc, Subject, Body, Attachments and Signature; Cc (carbon copy) shows the additional recipients to everyone, while Bcc (blind carbon copy) hides those recipients' addresses to protect their privacy. / ईमेल के भाग हैं To, Cc, Bcc, विषय, मुख्य भाग, अटैचमेंट और हस्ताक्षर; Cc (कार्बन कॉपी) अतिरिक्त प्राप्तकर्ताओं को सभी को दिखाता है, जबकि Bcc (ब्लाइंड कार्बन कॉपी) उन प्राप्तकर्ताओं के पते छिपाकर उनकी गोपनीयता की रक्षा करता है।