Class 12 Informatics PracticesChapter Summaries

7 chapters · Quick revision in under 3 minutes per chapter

Ch 1

Data Handling with Pandas — I

Introduces Pandas Series and DataFrame. Covers creation from lists, dictionaries and CSV, attributes (index, values, dtype, shape), and basic operations (head, tail, describe, info).

Topics covered

Series: creation from list, dictionary, ndarrayDataFrame: creation, shape, size, dtypeshead(), tail(), info(), describe() methodsAccessing elements: loc[], iloc[], at[], iat[]DataFrame: adding, deleting columns and rows

Ch 2

Data Handling with Pandas — II

Covers data filtering (boolean indexing), sorting (sort_values, sort_index), groupby and aggregation, merging DataFrames (merge, join, concat), and handling missing values (isnull, dropna, fillna).

Topics covered

Boolean indexing for row filteringsort_values(by='col', ascending=True/False)groupby('col').agg({'col2': 'sum/mean/count'})pd.merge(df1, df2, on='key', how='inner/left/right/outer')pd.concat([df1, df2], axis=0/1)Handling NaN: isnull(), fillna(), dropna()

Ch 3

Data Visualisation using Matplotlib

Covers drawing line, bar, stacked bar, horizontal bar, scatter, and pie charts using Matplotlib. Covers adding titles, labels, legends, and saving figures.

Topics covered

import matplotlib.pyplot as pltplt.plot() → line chart | plt.bar() → bar chartplt.scatter() → scatter | plt.pie() → pie | plt.hist() → histogramLabels: plt.xlabel(), plt.ylabel(), plt.title()plt.legend(), plt.show(), plt.savefig()Customisation: color, marker, linestyle, width

Ch 4

Database Management using MySQL

Covers SQL DDL (CREATE TABLE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), DQL (SELECT with WHERE, ORDER BY, GROUP BY, HAVING), aggregate functions, and JOIN operations.

Topics covered

DDL: CREATE DATABASE, CREATE TABLE, ALTER TABLE, DROP TABLEDML: INSERT INTO, UPDATE SET WHERE, DELETE FROM WHEREDQL: SELECT, WHERE, ORDER BY, DISTINCTAggregate: COUNT, SUM, AVG, MAX, MIN with GROUP BY and HAVINGINNER JOIN, LEFT JOIN — syntax and usePrimary Key, Foreign Key, NOT NULL, UNIQUE constraints

Ch 5

Networking and Internet

Covers network types (LAN, MAN, WAN), topologies (bus, star, ring, mesh, tree), protocols (HTTP, FTP, SMTP, POP3), IP addressing (IPv4, IPv6), DNS, and cloud computing types (IaaS, PaaS, SaaS).

Topics covered

LAN, MAN, WAN — definitions and examplesNetwork topologies: bus, star, ring, mesh — advantages and disadvantagesIP address: IPv4 (32-bit) and IPv6 (128-bit)DNS: Domain Name System — converts domain to IPProtocols: HTTP/HTTPS, FTP, SMTP, POP3, TCP/IPCloud computing: IaaS, PaaS, SaaS with examples

Ch 6

Emerging Trends

Covers Artificial Intelligence, Machine Learning, Data Science, Internet of Things, blockchain, Big Data, robotics, and 5G technology — at awareness and conceptual level.

Topics covered

Artificial Intelligence: strong AI vs weak AI, applicationsMachine Learning: supervised, unsupervised, reinforcement learningIoT: sensors, actuators, connectivity — smart devicesBlockchain: distributed ledger, decentralised, uses in finance and supply chainBig Data: 3Vs (Volume, Velocity, Variety)5G technology: speed, applications, difference from 4G

Ch 7

Societal Impacts of IT

Covers digital footprint, cyber threats (phishing, identity theft, cyberbullying), e-waste, health impacts (screen time, posture), intellectual property, plagiarism, privacy, and gender/disability issues in technology.

Topics covered

Digital footprint: active vs passiveCyber threats: phishing, vishing, identity theft, cyberbullyingSafe online practices: strong passwords, two-factor authenticationE-waste: generation, recycling, environmental impactIntellectual property: copyright, patents, trademarksPrivacy and data protection concepts

More resources for Class 12 Informatics Practices

NCERT Solutions →Important Questions →Deleted Topics →Revision Checklist →

Class 12 Informatics PracticesChapter Summaries

Data Handling with Pandas — I

Data Handling with Pandas — II

Data Visualisation using Matplotlib

Database Management using MySQL

Networking and Internet

Emerging Trends

Societal Impacts of IT

More resources for Class 12 Informatics Practices

Appearing for the May Phase 2 Board Exam? Practice with AI-ranked questions.

Mathematics

Science

Maths and Science

Maths and Science