Comprehensive Informatics Practices Study Guide (Class XI NCERT)

Administrative and Publication Details

Textbook Identity: The document is the First Edition (August 2019/Shravana 1941) of the "Informatics Practices Textbook for Class XI," reprinted in June 2021 (Ashadha 1943).
Publication Metadata: - ISBN: $978-93-5292-148-5$ - PD Code: 30T BS - Price: $140.00$ - Paper Quality: Printed on $80\,GSM$ paper with the NCERT watermark. - Publisher: Secretary, National Council of Educational Research and Training (NCERT), Sri Aurobindo Marg, New Delhi 110016. - Printer: Sagar Offset Printer India (P.) Ltd., Greater Noida (U.P.).
Publication Team: - Head, Publication Division: Anup Kumar Rajput - Chief Editor: Shveta Uppal - Chief Production Officer: Arun Chitkara - Chief Business Manager: Vipin Dewan - Production Officer: A.M. Vinod Kumar - Editor: Bijnan Sutar
Copyright and Rights: All rights reserved; no part of the publication may be reproduced, stored, or transmitted without prior permission. Sale is subject to the condition of no resale or hiring out in different bindings.

Foreword and Educational Objectives

Context of Technology: Information Technology (IT) has broken communication barriers, with India seeing a massive rise in internet users. Growth in computer science, telecommunications, and IT has led to automation and enhanced "ease of living."
Data Generation: The high volume of ICT users generates huge data volumes at unprecedented rates. Business models now use this data for targeted customer reach, and government agencies use it for service delivery, accountability, and informed decision-making.
Curricular Focus: The textbook aims to develop skill sets for handling data while introducing emerging ICT developments. It addresses the challenge of reducing curricular load while maintaining modern relevance.
Leadership: The foreword is provided by Hrushikesh Senapaty, Director of NCERT (July 2019).

Chapter 1: Computer System

Definition: A computer is an electronic device programmable to accept data (input), process it, and generate results (output). A "computer system" involves the computer plus additional hardware and software.
Alan Turing Quote: "A computer would deserve to be called intelligent if it could deceive a human into believing that it was human."
Components of a Computer System: - Central Processing Unit (CPU): Considered the "brain," consisting of electronic circuitry on integrated circuits (IC). - Arithmetic Logic Unit (ALU): Performs arithmetic and logic operations. - Control Unit (CU): Interprets instructions and guides data flow. - Registers: Local memory inside the CPU for storing data and instructions during processing. - Input Devices: Convert data into digital form. Examples: Keyboard, Mouse, Scanner, Touch Screen, and specialized Braille keyboards for the visually impaired. - Output Devices: Convert digital information into human-understandable form. Examples: Monitor, Projector, Speaker, Printer (Inkjet, Laserjet, Dot Matrix), and 3D Printers for physical replicas.
Evolution of Computing: - Abacus ( $500\,BC$ ): Simple mechanical arithmetic. - Pascaline ( $1642$ ): Mechanical calculator by Blaise Pascal for addition, subtraction, and repeated multiplication/division. - Analytical Engine ( $1834$ ): Charles Babbage's foundation for modern computers. - Tabulating Machine ( $1890$ ): Herman Hollerith's use of punched cards for data summarization. - Turing Machine ( $1937$ ): General-purpose programmable machine concept. - Von Neumann Architecture ( $1945$ ): Introduced stored-program computers (EDVAC/ENIAC). - Transistor ( $1947$ ): Replaced vacuum tubes, leading to miniaturization. - Integrated Circuit ( $1970s$ ): Enabled LSI, VLSI, and SLSI technology.
Moore’s Law: Predicted that the number of transistors on a chip would double every two years while costs halve.
Computer Memory: - Units: - Bit: Single binary digit (0 or 1). - Nibble: $4\,bits$ . - Byte: $8\,bits$ . - Calculations: $1\,KB = 1024\,Bytes$ ; $1\,MB = 1024\,KB$ ; $1\,GB = 1024\,MB$ ; $1\,TB = 1024\,GB$ ; $1\,PB = 1024\,TB$ . - Primary Memory: Essential for CPU interaction. - RAM (Random Access Memory): Volatile; stores data temporarily during work. - ROM (Read Only Memory): Non-volatile; stores permanent startup programs (boot loader). - Cache Memory: High-speed memory placed between CPU and RAM to reduce access time. - Secondary Memory: Permanent, larger capacity, non-volatile (HDD, SSD, Pen Drive, CD/DVD).
Data Life Cycle: - Data Capturing: Gathering digital data from sources (e.g., barcodes, social media). - Data Storage: Process of saving captured data for future use. Small organizations may struggle with the high cost of maintaining data servers. - Data Deletion and Recovery: Deleting data typically marks the address as free rather than erasing bits. Recovery is possible unless overwritten. Shredding/shredder tools are needed for data confidentiality before disposing of devices.
Software Classification: - System Software: Direct hardware interaction (OS, System Utilities, Device Drivers). - Programming Tools: For creating software. - Application Software: Task-specific tools (General Purpose like MS Word or Customized like school management software). - FOSS (Free and Open Source Software): Source code is public (e.g., Python, Ubuntu). - Freeware: Free to use but source code is private (e.g., Skype, Adobe Reader). - Proprietary: Must be purchased (e.g., Windows, Tally).

Chapter 2: Emerging Trends

Artificial Intelligence (AI): Simulating human intelligence (learning, decision-making, problem-solving). - Machine Learning (ML): Statistical techniques for computers to learn from data without explicit programming. - Natural Language Processing (NLP): Interaction via human languages (text-to-speech, speech-to-text). - Immersive Experiences: VR (Virtual Reality) creates a computer-generated 3D environment; AR (Augmented Reality) superimposes digital data over the physical world. - Robotics: Programmable machines using sensors. Includes Humanoids (Sophia), MER (Mars Rover), and Drones (unmanned aircraft).
Big Data: Massive data sets ( $2.5\,quintillion\,bytes$ generated daily) that cannot be processed by traditional DBMS. - Characteristics (5 Vs): Volume, Velocity, Variety, Veracity (trustworthiness), and Value. - Data Analytics: Examining data sets to draw conclusions.
Internet of Things (IoT): Network of devices with embedded software/hardware for data exchange. - Web of Things (WoT): Using web services to connect physical objects. - Sensors: Accelerometers (orientation) and Gyroscopes (rotation) in smartphones are key examples. - Smart Cities: Leveraging IoT for efficient resource distribution (land, water, waste, traffic).
Cloud Computing: On-demand computing services (servers, storage) over the internet. - Service Models: - IaaS: Infrastructure (hardware, VMs). - PaaS: Platforms for developers (OS, databases). - SaaS: Software for end-users (Google Docs).
Grid Computing: A network of geographically dispersed nodes that pool resources to act as a virtual supercomputer.
Blockchain: A decentralized, shared, and immutable ledger where every node has a copy of the database. Useful for digital currency, health records, and voting transparency.

Chapter 5: Understanding Data

Data Types: - Structured Data: Organized in tabular formats (rows and columns). - Unstructured Data: No fixed pattern (emails, social media posts, newspapers). - Metadata: "Data about data" (e.g., image resolution, email subject).
Statistical Techniques: - Measures of Central Tendency: - Mean: Average value. Computed as: $Mean = \frac{\sum_{i=1}^{n} x_i}{n}$ . - Median: Central value in a sorted list. If $n$ is odd, it is the middle value. If even, it is the average of the two middle values. - Mode: The most frequent value in a dataset. - Measures of Variability: - Range: Difference between Maximum ( $M$ ) and Minimum ( $S$ ) values. Calculation: $Range = M - S$ . - Standard Deviation ( $\sigma$ ): Measure of spread calculated as the square root of the average of squared differences from the mean: $\sigma = \sqrt{\frac{\sum (X - \bar{X})^2}{n}}$ .

Chapter 6: Introduction to NumPy

Definition: NumPy stands for "Numerical Python." It provides a multidimensional array object ( $ndarray$ ).
Array Characteristics: Elements are of the same type; stored contiguously in memory for speed; zero-based indexing.
Array Attributes: - ndim: Number of axes/dimensions. - shape: Tuple indicating size in each dimension (e.g., $(3, 2)$ for $3\,rows$ , $2\,columns$ ). - size: Total number of elements in the array. - dtype: Data type of elements (int32, float64, etc.). - itemsize: Memory size in bytes of each element.
Array Creation functions: - np.array(): From a list. - np.zeros((r,c)): Array of zeros. - np.ones((r,c)): Array of ones. - np.arange(start, stop, step): Sequence of numbers.
Slicing and Operations: Standard arithmetic ( $+$ , $-$ , $\times$ , $/$ , $\%$ ) is element-wise. Matrix multiplication uses the @ operator. Transpose is the .transpose() method.
Loading/Saving: np.loadtxt() and np.genfromtxt() load data from text/CSV files. np.savetxt() saves data to disk.

Chapter 7 & 8: Database Concepts and SQL

DBMS vs. File System: File systems suffer from redundancy (duplication), inconsistency (mismatch), isolation (no link), and dependence. DBMS provides a centralized, shared, and controlled environment.
Relational Data Model Terms: - Attribute: A column in a table (field). - Tuple: A row in a table (record). - Domain: Set of permissible values for an attribute. - Degree: Number of attributes. - Cardinality: Number of tuples.
Keys: - Candidate Key: Any attribute that uniquely identifies a record. - Primary Key: The specific candidate key chosen to identify records. - Composite Primary Key: A primary key made of multiple columns. - Foreign Key: An attribute that refers to a primary key in another table.
SQL (Structured Query Language): - DDL (Data Definition Language): CREATE DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLE. - DML (Data Manipulation Language): INSERT INTO, UPDATE, DELETE. - DQL (Data Query Language): SELECT. - Clauses: FROM (table source), WHERE (condition), DISTINCT (unique values), BETWEEN (range), IN (list match), ORDER BY (sort), LIKE (pattern match with % for multiple characters and _ for single).

Questions & Discussion

Think and Reflect (Memory): "Suppose there is a computer with RAM but no secondary storage. Can we install software on that computer?" - Response context: Software requires permanent storage to exist after power-off; RAM is volatile, so installation wouldn't persist.
Activity 2.2 (Robots): "Find out what role are robots playing in the medical field?" - Response context: They are used in surgery (accuracy), bionics, and patient care.
Activity 8.3 (SQL): "Type the statement show database;. Does it show the name of StudentAttendance database?" - Response context: Yes, once created, it appears in the list of available schemas in the MySQL environment.