CBSE Class 12 Informatics Practices Syllabus - Free PDF Download
CBSE Syllabus 2026-27 Class 12: The CBSE Class 12 Informatics Practices Syllabus for the examination year 2026-27 has been released by the Central Board of Secondary Education, CBSE. The board will hold the final examination at the end of the year following the annual assessment scheme, which has led to the release of the syllabus. The 2026-27 CBSE Class 12 Informatics Practices Board Exam will entirely be based on the most recent syllabus. Therefore, students must thoroughly understand the new CBSE syllabus to prepare for their annual exam properly.
The detailed CBSE Class 12 Informatics Practices Syllabus for 2026-27 is below.
Academic year:
CBSE Class 12 Informatics Practices Revised Syllabus
CBSE Class 12 Informatics Practices Course Structure 2026-27 With Marking Scheme
| # | Unit/Topic | Weightage |
|---|---|---|
| 1 | Querying and SQL Functions | 25 |
| 2 | Data Handling using Pandas - I | 9 |
| 3 | Data Handling using Pandas - II | 8 |
| 4 | Plotting Data using Matplotlib | 8 |
| 5 | Internet and Web | 10 |
| 6 | Societal Impacts | 10 |
| 7 | Project Based Learning | |
| Total | - |
Advertisements
Advertisements
Advertisements
Syllabus
1 Querying and SQL Functions [Revision]
- Introduction of Database Query Using SQL
- The following four relations:
- Inventory
- Customer
- Sale
- Employee
- Functions in SQL
- Introduction to Function in SQL
- Single Row Functions
- Aggregate Functions
- GROUP BY Clause in SQL
- Operations on Relations
- Introduction to Operations on Relations
- UNION (∪)
- INTERSECT (∩)
- MINUS (−)
- Cartesian Product (X)
- Using Two Relations in Query
- Cartesian product on two tables
- JOIN on two tables : equi-join and natural join
2 Data Handling using Pandas - I [Revision]
- Introduction to Python Libraries
- NumPy, Pandas and Matplotlib
- Installing Pandas
- Data Structure in Pandas - Series and DataFrame
- A Series
- Creation of Series
(A) Creation of Series from Scalar Values
(B) Creation of Series from NumPy Arrays
(C) Creation of Series from Dictionary - Accessing Elements of a Series
(A) Indexing
(B) Slicing
(C) Selection - Attributes of Series
- Methods of Series: Head and Tail functions
- Mathematical Operations on Series
(A) Addition of two Series
(B) Subtraction of two Series
(C) Multiplication of two Series
(D) Division of two Series
- Creation of Series
- DataFrame
- DataFrame
- Creation of DataFrame
(i) Creation of an empty DataFrame
(ii) Creation of DataFrame from NumPy ndarrays
(iii) Creation of DataFrame from List of Dictionaries
(iv) Creation of DataFrame from Dictionary of Lists
(v) Creation of DataFrame from Series
(vi) Creation of DataFrame from Dictionary of Series - Operations on rows and columns in DataFrames
(i) Adding a New Column to a DataFrame
(ii) Adding a New Row to a DataFrame
(iii) Selecting Rows or Columns from a DataFrame
(iv) Deleting Rows or Columns from a DataFrame
(v) Renaming Row Labels of a DataFrame
(vi) Renaming Column Labels of a DataFrame - Accessing DataFrames Element through Indexing
(i) Label Based Indexing
(ii) Boolean Indexing - Accessing DataFrames Element through Slicing
i) Filtering Rows in DataFrames - Joining, Merging and Concatenation of DataFrames
i) Joining - Attributes of DataFrames
- Head and Tail Functions
- Styling and formatting data
- Importing and Exporting Data between CSV Files and DataFrames
- Importing a CSV file to a DataFrame
- Exporting a DataFrame to a CSV file
- Pandas Series Vs NumPy ndarray
3 Data Handling using Pandas - II [Revision]
- Introduction of Data Handling Using Pandas – II
- Case Study
- Descriptive Statistics
- Descriptive Statistics
- Calculating Maximum Values
- Calculating Minimum Values
- Calculating Sum of Values
- Calculating Number of Values
- Calculating Mean
- Calculating Median
- Calculating Mode
- Calculating Quartile
- Calculating Variance
- Calculating Standard Deviation
- Data Aggregations
- Sorting in Data Structure
- GROUP BY Functions
- Altering the Index
- Other DataFrame Operations
- Reshaping Data
(A) Pivot
(B) Pivoting by Multiple Columns
(C) Pivot Table
- Reshaping Data
- Handling Missing Values
- Checking Missing Values
- Dropping Missing Values
- Estimating Missing Values
- Import and Export of Data between Pandas and MySQL
- Importing Data from MySQL to Pandas
- Exporting Data from Pandas to MySQL
4 Plotting Data using Matplotlib [Revision]
- Introduction of Plotting Data Using Matplotlib
- Plotting Using Matplotlib
- Customisation of Plots
- Marker
- Colour
- Linewidth and Line Style (Dashed, dotted)
- Width
- Add label, title, and legend in plots
- The Pandas Plot Function (Pandas Visualisation)
- Plotting a Line chart
- Plotting Bar Chart
- Plotting Histogram
- Plotting Scatter Chart
- Plotting Quartiles and Box plot
- Plotting Pie Chart
5 Internet and Web [Revision]
- Concept of Computer Network
- Introduction to Computer Network
- Types of Network
- Network Configuration
- Network Devices
- Modem
- Ethernet Card
- RJ45
- Repeater and Hub
- Switch
- Router
- Gateway
- Networking Topologies
- Introduction to Networking Topologies
- Mesh Topology
- Ring Topology
- Bus Topology
- Star Topology
- Tree or Hybrid Topology
- Internet, Web and the Internet of Things
- Introduction to Internet, Web and the Internet of thIngs
- The World Wide Web (WWW)
- Applications of Internet
- The World Wide Web (WWW)
- Electronic mail (Email)
- Chat
- Voice Over Internet Protocol (VoIP)
- Key Concepts of Web Technology
- World Wide Web (WWW)
- Web Page
- Website
- Web Browser
- Web Client
- Web Server
- Web Address/URL
- Website Hosting
- Introduction to Website Hosting
- Web Hosting and Web Host
- Types of Web Hosting
- Browsers
- Browser Settings
- Add-Ons and Plug-ins
- Cookies
6 Societal Impacts [Revision]
- Introduction of Societal Impacts
- Digital Footprints
- Digital Society and Netizen
- Data Protection
- Introduction to Data Protection
- Intellectual Property Right (IPR)
- Violation of IPR
- Public Access and Open Source Software
- Software Licensing
- Creative Commons
- Cyber Crimes
- Key Points: Cyber Crimes
- IT Act of India 2000
- E-waste: Hazards and Management
- Impact of e-waste on the environment
- Impact of e-waste on humans
- Management of e-waste: Reduce, Reuse, Recycle
- E-waste Management in India
- Impact on Health
7 Project Based Learning [Revision]
- Introduction of Project Based Learning
- Approaches for Solving Projects
- Teamwork
- Project Description
