Informatics Practices

This page contains the details of the chapters in class 12 Informatics Practices. The links take you to the NCERT solutions page for the corresponding chapter.
NCERT solutions for the following chapters are available for class 12 Informatics Practices. The solutions for NCERT class 12 Informatics Practices are provided in detail and can be viewed by clicking on the links provided. This page gives an overview of the lessons.
The following are the various units available.
Informatics Practices
Chapter 1: Querying and SQL Functions: This chapter contains the following sections:
1.1
Introduction
1.2
Functions in SQL
1.3
GROUP BY in SQL
1.4
Operations on Relations
1.5
Using Two Relations in a Query
Chapter 2: Data Handling using Pandas – I: This chapter contains the following sections:
2.1
Introduction to Python Libraries
2.2
Series
2.3
DataFrame
2.4
Importing and Exporting Data between Files and DataFrames
2.5
Pandas Series Vs NumPy ndarray
Chapter 3: Data Handling using Pandas – II: This chapter contains the following sections:
3.1
Introduction
3.2
Descriptive Statistics
3.3
Data Aggregations
3.4
Sorting a DataFrame
3.5
Group by Functions
3.6
Altering the Index
3.7
Other DataFrame Operations
3.8
Handling Missing Values
3.9
Import and Export of Data between Pandas and MySQL
Chapter 4: Plotting Data using Matplotlib: This chapter contains the following sections:
4.1
Introduction
4.2
Plotting using Matplotlib
4.3
Customisation of Plots
4.4
The Pandas Plot Function (Pandas Visualisation)
Chapter 5: Internet and Web: This chapter contains the following sections:
5.1
Introduction to Computer Networks
5.2
Types of Networks
5.3
Network Devices
5.4
Networking Topologies
5.5
The Internet
5.6
Applications of Internet
5.7
Website
5.8
Web Page
5.9
Web Server
5.10
Hosting of a Website
5.11
Browser
Chapter 6: Societal Impacts: This chapter contains the following sections:
6.1
Introduction
6.2
Digital Footprints
6.3
Digital Society and Netizen
6.4
Data Protection
6.5
Creative Commons
6.6
Cyber Crime
6.7
Indian Information Technology Act (IT Act)
6.8
E-waste: Hazards and Management
6.9
Impact on Health
Chapter 7: Project Based Learning: This chapter contains the following sections:
7.1
Introduction
7.2
Approaches for Solving Projects
7.3
Teamwork
7.4
Project Descriptions