
The CBSE Class 11 Informatics Practices Syllabus 2026-27 covers important topics such as computer systems, Python programming, databases, SQL and emerging technologies.
The subject includes both theory and practical work. Students can check the complete syllabus, unit-wise topics, marks distribution and practical details to plan their preparation.
Students can use the official syllabus PDF to check the complete Class 11 Informatics Practices syllabus 2026-27. It contains the unit-wise topics, marks distribution and practical requirements.
The theory paper carries 70 marks and practical work carries 30 marks. The total marks for Informatics Practices are 100.
|
Unit |
Unit Name |
Theory Marks |
|
Unit 1 |
Introduction to Computer System |
10 |
|
Unit 2 |
Introduction to Python |
25 |
|
Unit 3 |
Database Concepts and the Structured Query Language |
30 |
|
Unit 4 |
Introduction to Emerging Trends |
5 |
|
Practical |
30 |
|
|
Total |
100 |
Unit 3 has the highest weightage with 30 marks, followed by Unit 2 with 25 marks.
The Class 11 IP chapters 2026-27 are divided into four units. Each unit covers a different area of computer science and Information Technology.
This unit introduces students to computers, their components, memory and software.
Topics include:
Introduction to computers and computing
Evolution of computing devices
Components of a computer system
Interconnection of computer components
Input and output devices
Units of memory
Primary and secondary memory
Data deletion and recovery
Security concerns related to deleted data
System software
Application software
Generic purpose software
Specific purpose software
Students should understand the basic functions of computer hardware and software before moving to programming and databases.
Python is the largest theory unit in the CBSE 11th IP syllabus. Students learn basic programming concepts and use them to write simple programs.
The topics include:
Basics of Python programming
Interactive and script modes
Structure of a Python program
Indentation
Identifiers
Keywords
Constants
Variables
Operators
Precedence of operators
Data types
Mutable and immutable data types
Statements
Expression evaluation
Comments
Input and output statements
Data type conversion
Debugging
Students will study:
if-else
if-elif-else
while loop
for loop
The list section covers:
Creating lists
Initialising lists
Traversing lists
Manipulating lists
List methods
Built-in functions
Important functions and methods include:
len()
list()
append()
insert()
count()
index()
remove()
pop()
reverse()
sort()
min()
max()
sum()
Students will learn about key-value pairs and different operations on dictionaries.
Topics include:
Creating dictionaries
Initialising dictionaries
Traversing dictionaries
Updating elements
Deleting elements
Dictionary methods and functions
Important functions and methods include:
dict()
len()
keys()
values()
items()
update()
del()
clear()
The syllabus also introduces students to NumPy.
The main topic is:
Introduction to NumPy
Creating NumPy arrays from lists
Unit 3 carries 30 marks, making it the highest-weighted unit in the Class 11 IP syllabus.
Students will learn:
Introduction to database concepts
Need for databases
Database Management System
Relational data model
Domain
Tuple
Relation
Candidate key
Primary key
Alternate key
Students will learn why SQL is used for working with databases.
The syllabus covers:
Data Definition Language
Data Query Language
Data Manipulation Language
Introduction to MySQL
Creating a database using MySQL
Data types
Important SQL commands include:
CREATE DATABASE
CREATE TABLE
DROP
ALTER
Students will practise:
SELECT
FROM
WHERE
Relational operators
BETWEEN
Logical operators
IS NULL
IS NOT NULL
The syllabus includes:
INSERT
DELETE
UPDATE
Students should practise SQL queries regularly because this unit carries the highest marks in theory.
This unit carries 5 marks and introduces students to new technologies in Information Technology.
The topics include:
Artificial Intelligence
Machine Learning
Natural Language Processing
Augmented Reality
Virtual Reality
Immersive experience
Robotics
Big Data
Characteristics of Big Data
Internet of Things
Sensors
Smart cities
Cloud Computing
Cloud Services
SaaS
IaaS
PaaS
Grid Computing
Blockchain technology
Students should understand the basic meaning and uses of these technologies.
The Class 11 IP exam pattern is divided into theory and practical assessment.
Theory: 70 marks
Practical: 30 marks
Total: 100 marks
The theory syllabus is divided into four units. Introduction to Computer System carries 10 marks, Python carries 25 marks, Database Concepts and SQL carries 30 marks and Emerging Trends carries 5 marks.
Practical work carries 30 marks. Students will work mainly with Python programming and MySQL queries.
|
S. No. |
Unit |
Marks |
|
1 |
Problem solving using Python programming language |
11 |
|
2 |
Creating database using MySQL and performing queries |
7 |
|
3 |
Practical file |
7 |
|
4 |
Viva-Voce |
5 |
|
Total |
30 |
The practical file should contain a minimum of 14 Python programs and 14 SQL queries.
Students can practise programs based on the following tasks:
Find the average and grade for given marks.
Calculate the sale price of an item using cost and discount.
Calculate the perimeter, circumference and area of different shapes.
Calculate simple and compound interest.
Calculate profit or loss using cost price and selling price.
Calculate EMI for a given amount, period and interest.
Calculate GST or income tax.
Find the largest and smallest numbers in a list.
Find the third largest and smallest number in a list.
Find the sum of squares of the first 100 natural numbers.
Print the first n multiples of a given number.
Count vowels in a user-entered string.
Print words beginning with a particular alphabet.
Count occurrences of a given alphabet in each string.
Create a dictionary containing states and their capitals.
Create a dictionary containing student names and marks in five subjects.
Find the highest and lowest values in a dictionary.
The SQL practical work includes creating databases and tables and performing different queries.
Students should practise tasks such as:
Create a database.
Create a student table with student ID, class, section, gender, name, date of birth and marks.
Insert details of at least 10 students.
Display the complete table.
Display the roll number, name and marks of students scoring more than 50.
Display the roll number, name and date of birth of students born between 1 January 2005 and 31 December 2005.
Start with the basic concepts and gradually move towards programming and SQL.
Learn Python syntax before solving programs.
Practise lists and dictionaries with small programs.
Write Python programs instead of only reading them.
Practise SQL commands regularly.
Understand the difference between database terms such as tuple, relation and keys.
Revise computer system concepts before the exam.
Make short notes for emerging technologies.
Complete the practical file on time.
Practise viva questions from your Python and SQL practicals.
Since Python and SQL together carry a major portion of the syllabus, give them enough practice throughout the academic year.
The CBSE Class 11 Informatics Practices Syllabus 2026-27 covers four major areas: computer systems, Python, databases and emerging technologies. Python carries 25 marks while Database Concepts and SQL carry 30 marks in the theory paper. Practical work adds another 30 marks.
Students should understand the concepts and practise Python programs and SQL queries regularly. Keeping the syllabus PDF handy can also help you track the topics and plan your preparation.