Informatics Practices (IP) Class 11 & 12, Complete CBSE Board Exam Mastery Program

Topics Covered

• Evolution of computing devices, from Abacus to modern AI-powered computers
• Generations of computers: First (vacuum tubes) to Fifth (AI)
• Computer system components: Input Unit, CPU, Memory, Output Unit
• Block diagram of a computer, data flow from input to output
• CPU components: ALU (Arithmetic Logic Unit), Control Unit (CU), Registers
• Types of processors: single core, dual core, quad core, octa core
• Clock speed and its effect on processing: GHz explained
• Input devices: keyboard, mouse, scanner, webcam, microphone, touchscreen, stylus
• Biometric devices: fingerprint scanner, iris scanner, face recognition
• Output devices: monitor (CRT, LCD, LED, OLED, AMOLED), printer (inkjet, laser, 3D), speaker, projector, plotter
• Combined devices: touchscreen (both input and output)
• How a computer processes data: Input → Process → Output cycle

Topics Covered

• Computer memory: why it's needed, role in processing
• Primary memory (volatile): RAM, SRAM vs DRAM, speed, cost
• ROM, PROM, EPROM, EEPROM, non-volatile, stores firmware
• Cache memory: L1, L2, L3, speeds up CPU access to frequently used data
• Memory hierarchy: Registers → Cache → RAM → SSD → HDD (speed vs capacity trade-off)
• Units of memory: bit, nibble (4 bits), byte (8 bits), KB, MB, GB, TB, PB, EB
• Secondary storage: HDD (magnetic), SSD (flash), USB drive, memory card
• Optical storage: CD (700MB), DVD (4.7GB), Blu-ray (25-50GB)
• Cloud storage: Google Drive, OneDrive, iCloud, advantages and concerns
• Data deletion and recovery: when you delete, data isn't immediately gone

• Data security concerns: unauthorized access, data corruption, backup importance
• Software: definition, need for software, software vs hardware
• System software: OS, language processors, device drivers, utility programs
• Application software: general purpose (MS Office, browser) vs specific purpose (Tally, AutoCAD)
• Open source software: Linux, LibreOffice, GIMP, Python, MySQL
• Proprietary software: Windows, MS Office, Adobe Photoshop
• Operating system: functions, process management, memory management, file management, device management, user interface
• Types of user interface: CLI (Command Line) vs GUI (Graphical)

Topics Covered

• Why Python for IP?, simple syntax, data analysis libraries, industry standard
• Python in the real world: Instagram, YouTube, Spotify, Netflix use Python
• Installing Python 3.12+ on Windows, downloading from python.org
• Python IDLE: Interactive mode (>>> prompt) vs Script mode (.py files)
• Difference between Interactive and Script mode, when to use which
• Setting up VS Code with Python extension (optional, IDLE is sufficient for IP)
• First program: print('Hello, World!'), both in interactive and script mode
• Saving and running .py files
• Python tokens: keywords, identifiers, literals, operators, punctuators/delimiters
• Python keywords: 35 reserved words, False, True, None, and, or, not, if, else, elif, for, while, def, return, import, etc.
• Identifiers: rules, must start with letter or underscore, case-sensitive, no keywords, no spaces
• Valid vs invalid identifiers, practice exercises

Topics Covered

• Variables: named storage locations in memory
• Variable assignment: x = 10, name = 'Riya'
• Dynamic typing: Python infers data type automatically
• Multiple assignment: a, b, c = 1, 2, 3 and a = b = c = 0
• Data types in Python:
• int, integers: 10, -5, 0, 1000000 (unlimited precision)
• float, decimal numbers: 3.14, -0.5, 2.0
• complex, complex numbers: 3+4j (not in board exams but good to know)
• str, strings: 'hello', "world", '''multi-line'''
• bool, boolean: True, False (capital T and F!)

• None, absence of value: x = None
• type() function: checking data type of any variable
• Mutable vs Immutable types: lists are mutable, strings/tuples/int/float are immutable, IMPORTANT CONCEPT
• Type conversion (casting): int(), float(), str(), bool()
• Implicit type conversion: int + float → float (automatic)
• Explicit type conversion: int('25'), float('3.14'), str(100)
• Input function: input(), ALWAYS returns a string
• Converting input: int(input()), float(input())
• print() function: sep parameter, end parameter
• Formatted output: f-strings, f'Hello {name}, age {age}'
• Comments: # single line, '''multi-line docstrings'''
• Debugging basics: reading error messages, common beginner mistakes

Topics Covered

• Arithmetic operators: + (add), - (subtract), * (multiply), / (true division), // (floor division), % (modulus), ** (exponent)
• / vs //, 7/2 gives 3.5 (float), 7//2 gives 3 (integer), EXAM FAVORITE
• Modulus operator: 17%5 = 2 (remainder), -17%5 = 3 (Python's floor modulus!)
• Exponent: 2**10 = 1024, 9**0.5 = 3.0 (square root)
• Relational/comparison operators: == (equals), != (not equals), <, >, <=, >=
• Comparing strings: lexicographic order based on ASCII/Unicode values
• Logical operators: and, or, not
• Truth tables for and, or, not
• Short-circuit evaluation: False and X → False (X not evaluated), True or X → True
• Assignment operators: =, +=, -=, *=, /=, //=, %=, **=

• Identity operators: is, is not, checks if same object in memory (not just equal)
• Membership operators: in, not in, checks presence in sequence
• 'a' in 'apple' → True, 5 in [1,2,3,4,5] → True
• Operator precedence (PEMDAS for Python):
• ** → unary +x -x ~x → * / // % → + - → == != < > <= >= → not → and → or
• Associativity: most operators left-to-right, ** is right-to-left
• Expression evaluation: step-by-step breakdown practice
• Common exam traps: precedence gotchas, integer vs float division

Topics Covered

• Program flow types: sequential, selection (conditional), iteration (loops)
• if statement: if condition: (note the colon and indentation!)
• if-else statement: two-way decision making
• if-elif-else ladder: multi-way branching, checking multiple conditions
• Nested if: if inside if, complex decision trees
• Ternary expression: result = 'Pass' if marks >= 40 else 'Fail'
• Common programs: largest of 2/3 numbers, even/odd, positive/negative/zero
• Grade calculator, leap year checker, vowel/consonant detector
• for loop: for variable in sequence:, iterating over range, string, list
• range() function: range(stop), range(start, stop), range(start, stop, step)

• range(5) → 0,1,2,3,4; range(2,8) → 2,3,4,5,6,7; range(10,0,-1) → 10,9,...,1
• while loop: while condition:, repeat until condition becomes False
• while loop with counter, controlled repetition
• Infinite loop: while True, use with break for exit
• Loop control: break (exit loop immediately), continue (skip to next iteration)
• Nested loops: outer loop controls rows, inner loop controls columns
• Pattern printing: *, numbers, alphabets, basic patterns
• Accumulator patterns: sum of n numbers, factorial, counting
• Common programs: sum of digits, reverse number, palindrome check, Fibonacci
• Board exam focus: tracing loop output, counting iterations, break/continue effects

Topics Covered

• What are lists?, ordered, mutable, indexed collection of items
• List creation: [] empty list, [1,2,3], list() constructor, list('hello')
• Lists can contain mixed types: [1, 'hello', 3.14, True, None]
• Indexing: positive (0-based) and negative (-1 for last element)
• Slicing: list[start:stop:step], extracting sublists
• List is MUTABLE, elements can be changed: list[0] = 'new_value'
• List operations: + (concatenation), * (repetition), in (membership)
• List traversal: for item in list:, for i in range(len(list)):
• List methods, MUST KNOW for exams:
• append(x), add x to end

• insert(i, x), add x at position i
• extend(iterable), add all items from another list
• remove(x), remove first occurrence of x (ValueError if not found)
• pop(), remove and return last item, pop(i), remove at position i
• clear(), remove all items
• index(x), return position of first occurrence
• count(x), count occurrences of x
• sort(), sort in ascending order, sort(reverse=True), descending
• reverse(), reverse the list in place
• copy(), create shallow copy
• Built-in functions: len(), min(), max(), sum(), sorted(), list()
• del statement: del list[i], del list[start:stop]
• List comprehension basics: [x*2 for x in range(5)] → [0, 2, 4, 6, 8]
• Common programs: linear search, finding max/min without built-in, removing duplicates
• Board exam: output prediction with list operations and methods

Topics Covered

• What are dictionaries?, unordered collection of key-value pairs
• Dictionary creation: {} empty, {'name': 'Riya', 'age': 16}, dict()
• Keys must be immutable (string, int, tuple), lists cannot be keys
• Values can be any type, including lists, other dictionaries
• Accessing values: d['key'] (raises KeyError if not found), d.get('key', default)
• Adding/updating: d['new_key'] = value (adds if new, updates if exists)
• Removing: del d['key'], d.pop('key'), d.popitem() (removes last), d.clear()
• Dictionary methods:
• dict(), constructor
• len(d), number of key-value pairs

• d.keys(), view of all keys
• d.values(), view of all values
• d.items(), view of all (key, value) tuples
• d.get(key, default), safe access with default
• d.update(other_dict), merge/update from another dictionary
• d.copy(), shallow copy
• d.clear(), remove all items
• Traversing dictionaries: for key in d:, for key, value in d.items():
• Nested dictionaries: student records with multiple attributes
• in operator with dictionaries: checks keys (not values)
• Dictionary comprehension basics: {x: x**2 for x in range(5)}
• Common programs: character frequency, word counter, student database
• Board exam focus: output prediction with dictionary operations

Topics Covered

• What is data?, raw facts and figures vs information (processed data)
• What is a database?, organized collection of related data
• Need for databases: data redundancy reduction, data integrity, data security
• File system vs DBMS: why databases replaced flat files
• DBMS examples: MySQL, PostgreSQL, Oracle, MongoDB, SQL Server
• Relational Database Model: data stored in tables (relations)
• RDBMS terminology:
• Relation = Table (collection of rows and columns)
• Attribute = Column = Field (a property of the entity)
• Tuple = Row = Record (a single entry in the table)

• Domain = Set of valid values for an attribute
• Degree = Number of attributes (columns) in a relation
• Cardinality = Number of tuples (rows) in a relation
• Keys, identifying rows uniquely:
• Candidate Key: attribute(s) that can uniquely identify each tuple, there can be multiple
• Primary Key: the chosen candidate key, only ONE per table, no NULL values
• Alternate Key: candidate keys that were not chosen as primary key
• Example: Student table, RollNo and AdmissionNo are both candidate keys; if RollNo is primary key, AdmissionNo is alternate key
• Referential integrity concept basics

Topics Covered

• What is SQL?, Structured Query Language, communicating with databases
• SQL is NOT a programming language, it's a query language
• MySQL: free, open-source RDBMS, used in CBSE IP
• Installing MySQL on Windows, MySQL Community Server + MySQL Workbench
• Accessing MySQL: command line client, MySQL Workbench GUI
• SQL command categories: DDL, DML, DQL
• SQL data types:
• CHAR(n), fixed-length string (padded with spaces), VARCHAR(n), variable-length
• INT, integer, SMALLINT, smaller range, BIGINT, larger range
• FLOAT, decimal with approximate precision, DOUBLE, higher precision

• DATE, format 'YYYY-MM-DD', DATETIME, 'YYYY-MM-DD HH:MM:SS'
• DDL (Data Definition Language), structure commands:
• CREATE DATABASE db_name;, create new database
• USE db_name;, select active database
• SHOW DATABASES;, list all databases
• SHOW TABLES;, list all tables in current database
• CREATE TABLE table_name (col1 datatype constraint, col2 datatype, ...);
• Constraints: NOT NULL, UNIQUE, PRIMARY KEY, DEFAULT
• DESCRIBE table_name; / DESC table_name;, show table structure
• ALTER TABLE: ADD column, MODIFY column, DROP column
• DROP TABLE table_name;, delete entire table (structure + data)
• DROP DATABASE db_name;, delete entire database
• DML (Data Manipulation Language), data commands:
• INSERT INTO table VALUES (val1, val2, ...);, insert all columns
• INSERT INTO table (col1, col2) VALUES (val1, val2);, insert specific columns
• INSERT multiple rows in one command
• UPDATE table SET col1=val1 WHERE condition;, modify data
• DELETE FROM table WHERE condition;, remove specific rows
• WARNING: UPDATE/DELETE without WHERE affects ALL rows!

Topics Covered

• SELECT, the most important SQL command for IP exams
• SELECT * FROM table;, retrieve all columns, all rows
• SELECT col1, col2 FROM table;, specific columns only
• SELECT DISTINCT col FROM table;, remove duplicate values
• Column aliases: SELECT col AS alias_name
• WHERE clause, filtering rows based on conditions:
• Comparison operators: = <> (or !=) < > <= >=
• Logical operators: AND, OR, NOT
• Operator precedence: NOT > AND > OR (use parentheses for clarity)
• BETWEEN operator: WHERE marks BETWEEN 60 AND 90 (inclusive!)

• NOT BETWEEN: marks NOT BETWEEN 60 AND 90
• IN operator: WHERE city IN ('Delhi', 'Mumbai', 'Kolkata')
• NOT IN: WHERE city NOT IN ('Delhi', 'Mumbai')
• LIKE operator, pattern matching:
• %, matches zero or more characters: 'A%' (starts with A), '%ing' (ends with ing)
• _, matches exactly one character: '_a%' (second letter is a), '___' (exactly 3 chars)
• LIKE patterns: '%an%' (contains 'an'), 'S____' (S followed by exactly 4 chars)
• IS NULL: WHERE commission IS NULL, checking for missing values
• IS NOT NULL: WHERE phone IS NOT NULL
• NULL arithmetic: anything + NULL = NULL, NULL = NULL is UNKNOWN (use IS NULL!)
• ORDER BY clause, sorting results:
• ORDER BY col ASC, ascending (default, A-Z, 0-9)
• ORDER BY col DESC, descending (Z-A, 9-0)
• ORDER BY col1 ASC, col2 DESC, multi-column sorting
• NULL values in ORDER BY, appear first in ASC, last in DESC

Topics Covered

• Aggregate functions, operating on groups of rows:
• COUNT(*), count all rows (including NULLs)
• COUNT(column), count non-NULL values in column
• COUNT(DISTINCT column), count unique non-NULL values
• SUM(column), total of numeric column (ignores NULLs)
• AVG(column), average of numeric column (ignores NULLs)
• MAX(column), maximum value (works with numbers, strings, dates)
• MIN(column), minimum value
• Aggregate functions IGNORE NULL values (except COUNT(*))
• Using aggregate functions with WHERE: SELECT AVG(marks) FROM student WHERE class=12;

• Aliases with aggregates: SELECT COUNT(*) AS total_students FROM student;
• GROUP BY clause: grouping rows for aggregate calculations
• SELECT city, COUNT(*) FROM student GROUP BY city;
• GROUP BY with multiple columns
• HAVING clause: filtering groups after GROUP BY
• WHERE vs HAVING, WHERE filters rows BEFORE grouping, HAVING filters AFTER grouping
• Complete query with all clauses: SELECT ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY ...
• Class 11 SQL complete revision, all DDL, DML, DQL commands
• SQL query writing strategy for exams
• Common mistakes in SQL and how to avoid them

Topics Covered

• Artificial Intelligence (AI): machines that simulate human intelligence
• Types of AI: Narrow AI (Siri, Alexa), General AI (future), Super AI (theoretical)
• Applications of AI: healthcare, education, autonomous vehicles, chatbots (ChatGPT)
• Machine Learning (ML): subset of AI, computers learn from data without explicit programming
• Types of ML: supervised, unsupervised, reinforcement learning
• Natural Language Processing (NLP): AI understanding human language, Google Translate, voice assistants
• Augmented Reality (AR): digital content overlaid on real world, Pokémon Go, Instagram filters
• Virtual Reality (VR): fully immersive digital environment, Oculus, VR gaming
• Mixed Reality (MR): combination of AR and VR
• Robotics: programmable machines performing tasks, manufacturing, surgery, exploration

• Types of robots: industrial, service, humanoid, drone
• Internet of Things (IoT): everyday objects connected to internet, smart home, wearables
• IoT architecture: sensors → connectivity → data processing → user interface
• IoT examples: smart thermostat, fitness tracker, smart fridge, traffic management
• Smart Cities: technology-driven urban management, traffic, waste, energy, safety
• Big Data: extremely large datasets requiring special tools to process
• Big Data characteristics: 5 V's, Volume, Velocity, Variety, Veracity, Value
• Cloud Computing: accessing computing resources over internet instead of local machines
• Cloud service models: SaaS (Gmail), PaaS (Google App Engine), IaaS (AWS EC2)
• Cloud deployment: public, private, hybrid, community cloud
• Grid Computing: distributed computing, combining many computers for complex tasks
• Blockchain technology: decentralized, immutable digital ledger, cryptocurrency, supply chain
• How blockchain works: blocks, hashing, consensus mechanism

Topics Covered

• Practical file requirements for Class 11 IP:
• Minimum 14 Python programs covering all topics
• Minimum 14 SQL queries covering DDL, DML, DQL
• Python programs for practical file:
• P1: Input two numbers, perform all arithmetic operations
• P2: Find largest of three numbers
• P3: Check if number is even/odd, positive/negative
• P4: Grade calculator using if-elif-else
• P5: Print multiplication table using for loop
• P6: Print patterns using nested loops (3 patterns)

• P7: Check prime number, palindrome, Armstrong number
• P8: Calculate factorial using while loop
• P9: List operations, create, append, insert, remove, sort, search
• P10: Find max, min, sum, average from a list
• P11: Count vowels, consonants in a string
• P12: Dictionary operations, create, add, update, delete, traverse
• P13: Character/word frequency counter using dictionary
• P14: Menu-driven program combining multiple concepts
• SQL queries for practical file:
• Q1-Q3: CREATE TABLE, INSERT INTO, DDL and DML
• Q4-Q6: SELECT with WHERE, BETWEEN, IN, LIKE
• Q7-Q9: UPDATE, DELETE with conditions
• Q10-Q11: Aggregate functions, COUNT, SUM, AVG, MAX, MIN
• Q12-Q14: GROUP BY, HAVING, ORDER BY
• Class 11 final exam revision, unit-wise important questions
• Sample paper solving, 3 complete papers with solutions
• Viva voce preparation, 30 Q&A

Topics Covered

• What are Python libraries?, pre-written code modules for specific tasks
• NumPy: Numerical Python, arrays, mathematical operations (foundation for Pandas)
• Pandas: Python Data Analysis Library, data manipulation and analysis
• Matplotlib: plotting and visualization library
• Installing libraries: pip install pandas numpy matplotlib
• Importing: import pandas as pd, import numpy as np
• Pandas data structures: Series (1D) and DataFrame (2D)
• Series: one-dimensional labeled array, like a column in a table
• Creating Series from a list: pd.Series([10, 20, 30, 40])
• Default index: 0, 1, 2, 3... (RangeIndex)

• Custom index: pd.Series([10, 20, 30], index=['a', 'b', 'c'])
• Creating Series from a dictionary: pd.Series({'Maths': 90, 'Science': 85})
• Creating Series from a scalar value: pd.Series(5, index=['a', 'b', 'c']) → all values are 5
• Creating Series from NumPy ndarray: pd.Series(np.array([1, 2, 3]))
• Series attributes: dtype, shape, size, nbytes, ndim, index, values, name
• Checking data type: s.dtype → returns data type of elements
• Series is like a fixed-size dictionary, index acts as keys

Topics Covered

• Accessing elements: s[0] (positional), s['a'] (label-based)
• Slicing Series: s[1:4] (positional), s['b':'d'] (label, inclusive on both ends!)
• s.head(n), first n elements (default 5), s.tail(n), last n elements
• Mathematical operations on Series, element-wise:
• s + 10 → adds 10 to each element
• s1 + s2 → adds corresponding elements (NaN for unmatched indices)
• s * 2, s / 3, s ** 2, all element-wise operations
• Comparison operations: s > 50, s == 100 → returns Boolean Series
• Boolean indexing / filtering: s[s > 50] → elements greater than 50
• NaN (Not a Number): result of mismatched index operations

• Handling NaN: s.isnull(), s.notnull(), s.dropna(), s.fillna(value)
• Series methods for board exams:
• s.sum(), s.mean(), s.median(), s.mode(), s.std(), s.var()
• s.min(), s.max(), s.count() (non-NaN count)
• s.describe(), summary statistics (count, mean, std, min, 25%, 50%, 75%, max)
• s.value_counts(), frequency count of each unique value
• s.unique(), array of unique values, s.nunique(), count of unique values
• s.sort_values(ascending=True/False), sort by values
• s.sort_index(), sort by index labels
• Vectorized string operations: s.str.upper(), s.str.lower(), s.str.len()
• Board exam focus: output prediction with Series operations, NaN handling

Topics Covered

• DataFrame: 2-dimensional labeled data structure, like a spreadsheet/SQL table
• DataFrame = collection of Series sharing the same index
• Creating DataFrame from dictionary of lists:
• pd.DataFrame({'Name': ['A', 'B'], 'Marks': [90, 85]})
• Creating DataFrame from dictionary of Series
• Creating DataFrame from list of dictionaries
• Creating DataFrame from 2D list/array with columns parameter
• Creating DataFrame from CSV file: pd.read_csv('file.csv'), VERY IMPORTANT
• Custom index: pd.DataFrame(data, index=['row1', 'row2', ...])
• DataFrame attributes: shape, size, ndim, dtypes, columns, index, values, T (transpose)

• Selecting columns: df['column'], df[['col1', 'col2']] (single vs multiple)
• Adding a new column: df['new_col'] = values
• Deleting a column: del df['col'], df.drop('col', axis=1), df.pop('col')
• Renaming columns: df.rename(columns={'old': 'new'})
• Selecting rows by label: df.loc['row_label'], df.loc['r1':'r3']
• Selecting rows by position: df.iloc[0], df.iloc[0:3]
• loc vs iloc, label-based vs integer position-based, EXAM CRITICAL
• Selecting specific cell: df.loc['row', 'col'], df.iloc[row_idx, col_idx]
• df.at['row', 'col'], fast scalar access by label
• df.iat[row_idx, col_idx], fast scalar access by position
• df.head(n), df.tail(n), view first/last n rows

Topics Covered

• Adding a new row: df.loc['new_index'] = [values], pd.concat()
• Deleting rows: df.drop('row_label'), df.drop([indices])
• Boolean indexing with DataFrame: df[df['Marks'] > 80]
• Multiple conditions: df[(df['Marks'] > 80) & (df['City'] == 'Delhi')]
• Note: use & instead of 'and', | instead of 'or' for DataFrame filtering
• Sorting: df.sort_values('column'), df.sort_values(['col1', 'col2'])
• df.sort_values('column', ascending=False), descending sort
• df.sort_index(), sort by index
• DataFrame iteration: df.iterrows(), iterate row by row
• Aggregate operations: df['col'].sum(), .mean(), .max(), .min(), .count()

• df.describe(), statistical summary for all numeric columns
• df.info(), overview of DataFrame structure
• df.isnull(), check for NaN values, df.notnull()
• df.dropna(), remove rows with NaN, df.fillna(value), fill NaN
• df.drop_duplicates(), remove duplicate rows
• Exporting DataFrame to CSV: df.to_csv('output.csv', index=False)
• DataFrame arithmetic: df1 + df2, df * scalar, element-wise operations
• Pivot tables basics: df.pivot_table(values, index, aggfunc)
• Groupby basics: df.groupby('column').mean()
• Board exam focus: complete DataFrame operation chains, output prediction

Topics Covered

• What is data visualization?, representing data graphically for insights
• Why visualize?, patterns, trends, comparisons are easier to see in charts
• Matplotlib library: most popular Python plotting library
• Importing: import matplotlib.pyplot as plt
• Basic plot workflow: create figure → plot data → customize → show/save
• Line Chart / Line Plot: plt.plot(x, y)
• plt.plot() with just y values, x defaults to 0, 1, 2, ...
• Multiple lines on same plot: call plt.plot() multiple times
• Line customization:
• color: plt.plot(x, y, color='red') or color='r' or color='#FF0000'

• Line style: linestyle='-' (solid), '--' (dashed), '-.' (dash-dot), ':' (dotted)
• Line width: linewidth=2 or lw=2
• Markers: marker='o' (circle), 's' (square), '^' (triangle), 'D' (diamond), '*' (star)
• Marker size: markersize=10 or ms=10
• Combined format string: plt.plot(x, y, 'r--o') → red dashed line with circles
• Chart elements, MUST add for full marks:
• plt.title('Chart Title'), chart title
• plt.xlabel('X-Axis Label'), plt.ylabel('Y-Axis Label'), axis labels
• plt.legend(['Line 1', 'Line 2']) or label='name' in plot + plt.legend()
• plt.grid(True), add grid lines
• plt.xticks(rotation=45), rotate x-axis labels
• plt.show(), display the chart
• plt.savefig('chart.png'), save chart as image
• Bar Graph: plt.bar(x, height), vertical bars
• Horizontal bar: plt.barh(x, width)
• Bar customization: color, width, edgecolor, align
• Multiple bar groups: side-by-side bars using width offset
• Stacked bars: plt.bar(x, y1); plt.bar(x, y2, bottom=y1)

Topics Covered

• Histogram: plt.histogram(data, bins), frequency distribution chart
• Histogram vs Bar graph: histogram for continuous data, bar for categorical
• Histogram parameters: bins (number of intervals), range, edgecolor, color, alpha
• bins parameter: bins=10 (10 equal intervals), bins=[0,20,40,60,80,100] (custom)
• alpha parameter: transparency, alpha=0.7 (0=invisible, 1=opaque)
• Using histograms: exam marks distribution, age distribution, salary distribution
• Advanced customization for all chart types:
• Figure size: plt.figure(figsize=(10, 6))
• Font sizes: fontsize parameter in title, xlabel, ylabel, legend
• Font weight: fontweight='bold'

• Color options: named colors, hex codes, RGB tuples
• Grid customization: plt.grid(axis='y', linestyle='--', alpha=0.7)
• Setting axis limits: plt.xlim(0, 100), plt.ylim(0, 50)
• Annotations: plt.annotate('text', xy=(x,y), xytext=(tx,ty), arrowprops=dict(arrowstyle='->'))
• Adding text: plt.text(x, y, 'text')
• Subplots: plt.subplot(rows, cols, position), multiple charts in one figure
• plt.tight_layout(), avoid overlapping in subplots
• Complete chart for board exam: title + labels + legend + grid + colors + markers
• Board exam pattern: write code to create a specific chart from given data
• Chart type selection: when to use line vs bar vs histogram
• Practical exam: creating charts from Pandas DataFrame data

Topics Covered

• Plotting directly from DataFrame: df.plot(), integrates Pandas with Matplotlib
• df.plot(kind='line'), line chart from DataFrame columns
• df.plot(kind='bar'), bar chart, df.plot(kind='barh'), horizontal bar
• df.plot(kind='hist'), histogram from DataFrame data
• df['column'].plot(), plot a single column as Series
• Complete CSV workflow:
• Step 1: pd.read_csv('data.csv'), import data into DataFrame
• read_csv parameters: sep, header, index_col, usecols, nrows, na_values
• Step 2: df.head(), df.info(), df.describe(), explore the data
• Step 3: df[condition], filter and clean data

• Step 4: df.groupby().agg(), aggregate and summarize
• Step 5: df.plot() or plt.plot(), visualize insights
• Step 6: df.to_csv('output.csv', index=False), export results
• Real-world data analysis workflow using CSV files
• Handling large CSV files: chunking, selecting columns
• Common Pandas + Matplotlib patterns for board exams

Topics Covered

• Complete Pandas revision: Series creation, operations, methods
• DataFrame revision: creation, selection, filtering, sorting, groupby
• CSV read/write revision
• Matplotlib revision: line, bar, histogram with full customization
• 15 Pandas programs for practical file:
• P1: Create Series from list, dict, ndarray, display attributes
• P2: Series arithmetic operations and NaN handling
• P3: Series statistical functions, mean, median, mode, std
• P4: Create DataFrame from dict, list of dicts, CSV
• P5: DataFrame column operations, add, delete, rename

• P6: DataFrame row selection with loc and iloc
• P7: Boolean indexing, filter DataFrame rows by condition
• P8: Sorting DataFrame by column values
• P9: DataFrame aggregate functions, sum, mean, count
• P10: GroupBy operations, group by category and aggregate
• P11: Handling missing data, isnull, dropna, fillna
• P12: Import CSV into DataFrame and display statistics
• P13: Export DataFrame to CSV file
• P14: DataFrame describe() and info(), data exploration
• P15: Integrated program, CSV → filter → aggregate → export
• 4+ Matplotlib programs for practical file:
• M1: Line chart with title, labels, legend, grid, colors
• M2: Bar graph (vertical/horizontal) with customization
• M3: Histogram with bins, color, edgecolor
• M4: Multiple charts comparison using subplots

Topics Covered

• Revision of Class 11 SQL: CREATE, INSERT, SELECT, WHERE, operators
• SQL Functions: two categories, single row functions & aggregate functions
• Single row functions work on each row individually
• Mathematical functions:
• POWER(base, exponent), POWER(2, 3) = 8
• ROUND(number, decimals), ROUND(15.678, 1) = 15.7, ROUND(15.678, 0) = 16
• ROUND(1256, -2) = 1300, rounding to nearest hundred
• MOD(dividend, divisor), MOD(17, 5) = 2 (remainder)
• TRUNCATE(number, decimals), TRUNCATE(15.678, 1) = 15.6 (no rounding!)
• ABS(number), absolute value

• CEIL(number) / CEILING(number), smallest integer >= number
• FLOOR(number), largest integer <= number
• String/Text functions:
• UCASE(str) / UPPER(str), convert to uppercase
• LCASE(str) / LOWER(str), convert to lowercase
• MID(str, start, length) / SUBSTRING(str, start, length) / SUBSTR(str, start, length)
• Note: MySQL string positions start from 1 (not 0 like Python!)
• LENGTH(str), number of characters including spaces
• LEFT(str, n), first n characters, RIGHT(str, n), last n characters
• INSTR(str, substr), position of first occurrence of substr (returns 0 if not found)
• LTRIM(str), remove leading spaces, RTRIM(str), remove trailing spaces
• TRIM(str), remove both leading and trailing spaces
• CONCAT(str1, str2), join strings together
• REPLACE(str, old, new), replace occurrences
• Date functions:
• NOW(), current date and time
• DATE(datetime), extract date portion
• MONTH(date), month number (1-12)
• MONTHNAME(date), month name ('January', 'February', ...)
• YEAR(date), year number
• DAY(date), day of month (1-31)
• DAYNAME(date), day name ('Monday', 'Tuesday', ...)
• DAYOFWEEK(date), 1=Sunday, 2=Monday, ... 7=Saturday
• Using functions in SELECT and WHERE clauses
• Nested functions: UPPER(LEFT(name, 3)), combine functions

Topics Covered

• Aggregate functions (revision and deep dive):
• COUNT(*), total rows, COUNT(column), non-NULL count
• SUM(column), total, AVG(column), average
• MAX(column), maximum, MIN(column), minimum
• COUNT(DISTINCT column), unique value count
• All aggregates ignore NULL except COUNT(*)
• GROUP BY clause, advanced usage:
• Grouping by single column: SELECT city, COUNT(*) FROM student GROUP BY city;
• Grouping by multiple columns: GROUP BY class, section
• GROUP BY with all aggregate functions

• Rules: columns in SELECT must be in GROUP BY or inside aggregate functions
• HAVING clause, filtering groups:
• HAVING COUNT(*) > 5, show only groups with more than 5 members
• HAVING AVG(marks) >= 80, show groups with average marks >= 80
• WHERE vs HAVING, the definitive comparison (EXAM CRITICAL):
• WHERE: filters ROWS before grouping, cannot use aggregate functions
• HAVING: filters GROUPS after grouping, CAN use aggregate functions
• WHERE is for conditions on individual rows
• HAVING is for conditions on grouped results
• Complete query with all clauses:
• SELECT col, AGG(col) FROM table WHERE condition GROUP BY col HAVING agg_condition ORDER BY col;
• Execution order: FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
• Complex queries combining WHERE + GROUP BY + HAVING + ORDER BY
• Board exam: write query for given output, find errors, output prediction

Topics Covered

• Why joins?, real databases have multiple related tables
• Foreign key: column in one table referencing primary key of another
• Example: Student(RollNo, Name, ClassID) and Class(ClassID, ClassName, Teacher)
• Cartesian Product / Cross Join: every row of Table1 × every row of Table2
• If Table1 has 5 rows and Table2 has 3 rows → result has 15 rows
• Cartesian product is rarely useful, need to filter with conditions
• Equi-Join: Cartesian product + WHERE condition matching common columns
• SELECT s.Name, c.ClassName FROM student s, class c WHERE s.ClassID = c.ClassID;
• Table aliases: student s, class c, shorter names for readability
• Using dot notation: s.Name, c.ClassName, specify which table's column

• Why aliases are needed: when both tables have same column name
• Natural Join: automatically joins on columns with same name
• SELECT * FROM student NATURAL JOIN class;, auto-matches ClassID
• Natural join removes duplicate columns in result
• Equi-join vs Natural Join: equi-join gives you control, natural join is automatic
• Join with additional conditions: WHERE s.ClassID = c.ClassID AND s.Marks > 80
• Joining with aggregate functions: SELECT c.ClassName, AVG(s.Marks) FROM student s, class c WHERE s.ClassID = c.ClassID GROUP BY c.ClassName;
• Board exam join patterns: 2-table queries with conditions, aggregates, sorting
• Practice: identifying which tables to join and on which columns

Topics Covered

• Complete SQL revision, all commands:
• DDL: CREATE DATABASE/TABLE, ALTER TABLE, DROP TABLE/DATABASE
• DML: INSERT INTO, UPDATE, DELETE
• DQL: SELECT with WHERE, BETWEEN, IN, LIKE, IS NULL/IS NOT NULL
• Functions: Math (POWER, ROUND, MOD), String (UPPER, LOWER, MID, LENGTH, LEFT, RIGHT, INSTR, TRIM, CONCAT), Date (NOW, DATE, MONTH, MONTHNAME, YEAR, DAY, DAYNAME)
• Aggregates: COUNT, SUM, AVG, MAX, MIN
• Clauses: GROUP BY, HAVING, ORDER BY, DISTINCT
• Joins: Cartesian product, Equi-join, Natural join
• 15+ SQL queries for practical file:
• Q1: CREATE TABLE with constraints (PRIMARY KEY, NOT NULL)

• Q2: INSERT INTO, multiple rows
• Q3: SELECT with WHERE using comparison operators
• Q4: SELECT with BETWEEN and IN
• Q5: SELECT with LIKE and wildcards
• Q6: SELECT with IS NULL / IS NOT NULL
• Q7: SELECT with ORDER BY (ASC and DESC)
• Q8: UPDATE records with WHERE condition
• Q9: DELETE records with WHERE condition
• Q10: ALTER TABLE, add and modify column
• Q11: Aggregate functions, COUNT, SUM, AVG, MAX, MIN
• Q12: GROUP BY with aggregate functions
• Q13: GROUP BY with HAVING clause
• Q14: SQL functions, UPPER, LOWER, MID, LENGTH, ROUND, MOD
• Q15: Equi-join on two tables with conditions

Topics Covered

• What is a computer network?, interconnected devices sharing resources
• Types of networks based on geographical area:
• PAN (Personal Area Network): Bluetooth headset, smartwatch, within 10 meters
• LAN (Local Area Network): within a building, school lab, office, home WiFi
• MAN (Metropolitan Area Network): across a city, cable TV network, city WiFi
• WAN (Wide Area Network): across countries/continents, Internet is the largest WAN
• Networking devices:
• Modem: MOdulator-DEModulator, converts digital to analog and vice versa
• Hub: broadcasts data to ALL connected devices, dumb device, creates traffic
• Switch: intelligent hub, sends data ONLY to intended device using MAC addresses

• Repeater: amplifies/regenerates weak signals, extends cable distance
• Router: connects different networks, directs traffic using IP addresses
• Gateway: connects networks with DIFFERENT protocols, translates between them
• NIC (Network Interface Card): hardware for network connectivity, has MAC address
• WiFi adapter: wireless NIC for WiFi connectivity
• Network topologies:
• Star topology: all devices connect to central hub/switch
• Advantages: easy to add/remove, failure of one device doesn't affect others
• Disadvantage: central hub failure takes down entire network
• Bus topology: all devices on single backbone cable with terminators
• Advantages: cheap, easy to install
• Disadvantages: cable failure affects all, difficult troubleshooting
• Tree/Hierarchical topology: combination of star and bus, like a tree structure
• Mesh topology: every device connected to every other device
• Advantage: maximum redundancy, Disadvantage: very expensive

Topics Covered

• Internet: global network of networks, largest WAN
• How internet works: ISP, DNS, routers, data packets
• Internet services:
• WWW (World Wide Web): system of interlinked hypertext documents, uses HTTP
• Email: electronic mail, SMTP (sending), POP3/IMAP (receiving)
• Chat/Instant Messaging: WhatsApp, Telegram, Slack
• VoIP (Voice over IP): voice calls over internet, Zoom, Google Meet, Skype
• Video conferencing: audio + video communication over internet
• URL (Uniform Resource Locator): address of a web resource
• URL structure: protocol://domain_name:port/path/page?query#fragment

• Domain name: human-readable website address (google.com, example.org)
• DNS (Domain Name System): translates domain names to IP addresses
• Domain extensions: .com, .org, .edu, .gov, .in, .co.in
• Websites: collection of related web pages
• Static web pages: fixed content, created with HTML/CSS, same for all users
• Dynamic web pages: content changes based on user, time, interaction, uses server-side processing
• Web server: computer that hosts websites and serves web pages
• Web hosting: storing website on a server for internet access
• Types of hosting: shared, VPS, dedicated, cloud hosting
• Web browser: software to access websites, Chrome, Firefox, Edge, Safari
• Browser features: tabs, bookmarks, history, extensions/add-ons, plug-ins
• Cookies: small data files stored by websites on your browser
• First-party cookies: set by the website you visit
• Third-party cookies: set by advertisers/trackers, privacy concern

Topics Covered

• Digital footprint: trail of data you leave on the internet
• Active digital footprint: intentional, social media posts, emails, comments
• Passive digital footprint: unintentional, browsing history, cookies, IP logs
• Managing your digital footprint: privacy settings, thinking before posting
• Communication etiquette (netiquette): proper online behavior
• Email etiquette: professional subject lines, proper greeting, no ALL CAPS
• Social media etiquette: respect others, verify before sharing, no cyberbullying
• Data protection: safeguarding personal and organizational data
• Personal data: name, address, phone, email, financial info, biometric data
• Consent: permission before collecting/using personal data

• Intellectual Property Rights (IPR):
• Copyright: legal right over creative works, books, music, software, art
• Patent: protection for inventions, machines, processes, formulas
• Trademark: protection for brand identity, logos, names, slogans
• Plagiarism: using someone else's work without proper credit, academic dishonesty
• How to avoid plagiarism: cite sources, paraphrase properly, use quotation marks
• Software licensing:
• Proprietary: paid, closed source, Windows, Adobe, MS Office
• Free and Open Source Software (FOSS): free to use, modify, distribute
• FOSS examples: Linux, Firefox, LibreOffice, Python, MySQL, Android, WordPress
• Creative Commons: flexible copyright licenses, CC-BY, CC-BY-SA, CC-BY-NC
• GPL (GNU General Public License): must keep derivatives open source
• Cybercrime: criminal activities using computers/internet
• Hacking: unauthorized access to computer systems
• Phishing: fraudulent emails/websites to steal login credentials
• Cyberbullying: harassment, threats, humiliation online
• Identity theft: stealing personal information for fraud
• Ransomware: malware that encrypts data and demands payment
• Indian Information Technology Act 2000 (amended 2008):
• Section 43: penalty for unauthorized access, data theft
• Section 66: computer-related offences, hacking, identity theft
• Section 67: publishing obscene material electronically
• Section 72: breach of confidentiality and privacy
• E-waste: discarded electronic devices, hazards and management
• E-waste hazards: toxic materials (lead, mercury, cadmium), soil/water pollution
• E-waste management: reduce, reuse, recycle, proper disposal at certified centers
• Health concerns from technology: digital eye strain, back/neck pain, carpal tunnel syndrome
• Ergonomics: proper posture, screen distance, break intervals (20-20-20 rule)
• Technology addiction: social media addiction, gaming disorder, awareness and balance

Topics Covered

• Complete practical file requirements verification:
• 15+ Pandas programs, Series and DataFrame operations
• 4+ Matplotlib programs, line chart, bar graph, histogram with customization
• 15+ SQL queries, DDL, DML, DQL, functions, aggregates, joins
• Project work (5 marks): data analysis project using Pandas + Matplotlib
• Suggested projects:
• COVID-19 data analysis, cases, recoveries, deaths by country/state
• Weather data analysis, temperature, rainfall trends over years
• Student performance analyzer, class-wise, subject-wise analysis with charts
• IPL/cricket statistics analysis, batting, bowling averages with visualization

• E-commerce sales analysis, product category wise, monthly trends
• Project documentation: cover page, certificate, acknowledgement, introduction, source code, output, bibliography
• Viva voce preparation, 50 most-asked questions:
• What is Pandas? What is a DataFrame? What is a Series?
• Difference between loc and iloc?
• What is matplotlib? How to create a bar chart?
• What is GROUP BY? What is HAVING?
• Difference between WHERE and HAVING?
• What is a primary key? What is a foreign key?
• What is an equi-join?
• What is a digital footprint?

Topics Covered

• Pandas Series revision: creation, indexing, slicing, operations, methods, NaN handling
• Pandas DataFrame revision: creation, selection, filtering, sorting, groupby, CSV operations
• DataFrame vs Series, comparison table
• loc vs iloc, 20 practice problems
• Boolean indexing revision, complex condition filtering
• Aggregate functions on DataFrame: sum, mean, max, min, count, describe
• Matplotlib revision: line chart, bar graph, histogram
• Chart customization checklist: title, xlabel, ylabel, legend, grid, color, marker, linestyle
• Format strings revision: 'r--o', 'b-s', 'g:^'
• Common Pandas output prediction patterns
• Quick reference card for Pandas methods and Matplotlib functions

Topics Covered

• SQL complete revision: DDL, DML, DQL
• SQL functions revision: POWER, ROUND, MOD, UPPER, LOWER, MID, LENGTH, LEFT, RIGHT, INSTR, TRIM, CONCAT, NOW, DATE, MONTH, YEAR, DAY, MONTHNAME, DAYNAME
• Aggregate functions revision: COUNT, SUM, AVG, MAX, MIN
• GROUP BY + HAVING revision, 20 practice queries
• Joins revision: Cartesian product, equi-join, natural join
• Complete SQL query writing, from WHERE to JOIN
• Computer networks revision: PAN, LAN, MAN, WAN, devices, topologies
• Internet and web concepts revision: URL, DNS, HTTP/HTTPS, static/dynamic, cookies
• Societal impacts revision: digital footprint, IPR, cybercrime, IT Act, e-waste
• Case study practice, network design scenarios (CBSE board favorite)

Topics Covered

• Full-length Mock Exam 1: 70 marks, 3 hours, strict exam conditions
• CBSE IP paper structure:
• Section A: 21 questions × 1 mark = 21 marks (MCQ, True/False, Fill-in-blanks)
• Section B: 7 questions × 2 marks = 14 marks (Very Short Answer)
• Section C: 4 questions × 3 marks = 12 marks (Short Answer)
• Section D: 2 questions × 4 marks = 8 marks (Case Study based)
• Section E: 3 questions × 5 marks = 15 marks (Long Answer)
• Detailed solution discussion with CBSE marking scheme
• Full-length Mock Exam 2: different question set, same structure
• Common mistakes analysis and correction

• Time management strategy:
• Section A (21 marks): 30-35 minutes
• Section B (14 marks): 20 minutes
• Section C (12 marks): 20 minutes
• Section D (8 marks): 15 minutes
• Section E (15 marks): 25 minutes
• Review time: 10-15 minutes
• How to write Pandas/Matplotlib code in board exams
• How to write SQL queries in board exams, formatting tips

Topics Covered

• 3 more full-length mock exams (Set 3, 4, 5)
• CBSE IP Previous Year Papers solved:
• 2020, 2021, 2022, 2023, 2024, 2025, complete solutions with marking scheme
• CBSE IP Sample Paper 2026-27, official sample paper solved
• Frequently repeated question analysis, top 30 topics that appear every year
• Most important Pandas questions: Series operations, DataFrame creation, loc/iloc, groupby
• Most important SQL questions: GROUP BY + HAVING, aggregate functions, joins, functions
• Most important theory questions: network devices, topologies, cybercrime, IPR, IT Act
• Case study question patterns, how to approach and answer
• Assertion-Reason question strategy, understanding the format
• Partial marks strategy, how to get step marks even if you don't know complete answer

Topics Covered

• One-shot revision: entire IP syllabus in 2 days, key points only
• Pandas cheat sheet: all methods, attributes, operations on one page
• Matplotlib cheat sheet: plot types, customization options, format strings
• SQL command reference: all DDL, DML, DQL, functions on 2 pages
• Network concepts summary: devices, topologies, protocols on 1 page
• Societal impacts summary: key terms, IT Act sections on 1 page
• Top 30 most important Pandas output prediction problems
• Top 20 SQL queries you must know by heart
• Top 15 theory questions with model answers
• Board exam day strategy: reading time, question selection, presentation
• How to handle unfamiliar questions, partial answer strategies
• Confidence building: you've practiced more than 95% of students
• Practical exam preparation: Pandas program + SQL queries + project viva