CBSE Class 11 Informatics Practices Syllabus 2025-26: A Complete Guide

Welcome to your complete guide to the CBSE Class 11 Informatics Practices (IP) syllabus for the academic year 2025-26. Whether you're a student just starting your +2 journey or a parent looking to understand the curriculum, this detailed breakdown will provide you with all the essential information you need. The Informatics Practices (Subject Code: 065) curriculum is designed to give students a foundational understanding of computer systems, programming with Python, and database management using SQL.

Course Objectives: What Will You Learn?

By the end of this course, you will have gained the skills to:

• Identify and understand the core components of a computer system.
• Develop programs using Python, including lists and dictionaries.
• Grasp fundamental database concepts and the principles of Relational Database Management Systems (RDBMS).
• Use Structured Query Language (SQL) to manage and retrieve data.
• Recognize key emerging trends shaping the future of Information Technology.

Theory: Distribution of Marks (Total 70 Marks)

The theory portion of the syllabus is divided into four distinct units, each with a specific focus and weightage.

---

Unit-wise Syllabus Breakdown

Unit 1: Introduction to Computer System

This introductory unit lays the groundwork for the entire course.

• Computer Fundamentals: You'll explore the evolution of computers, understand the various components of a computer system, and learn about input/output devices.
• Computer Memory: This section covers memory units, the differences between primary (RAM) and secondary (HDD, SSD) memory, and touches upon data deletion, recovery, and security.
• Software Concepts: Learn the distinction between system software (like operating systems) and application software (like web browsers or office suites).

Unit 2: Introduction to Python

This is a core unit where you will dive into programming.

• Python Basics: You will learn the fundamentals, including program structure, variables, data types (mutable and immutable), operators, and debugging.
• Control Flow: Master conditional statements (if-else, if-elif-else) and loops (for, while) to control the flow of your programs.
• Data Structures:
  • Lists: Get comfortable with creating, manipulating, and traversing lists using built-in functions like append(), sort(), pop(), and more.
  • Dictionaries: Understand the key-value pair concept and learn to manage data in dictionaries.
• Introduction to NumPy: A brief introduction to the powerful NumPy library for creating arrays.

Unit 3: Database Concepts and the Structured Query Language (SQL)

This high-weightage unit focuses on managing data.

• Database Fundamentals: Learn why databases are essential and understand the basics of a Database Management System (DBMS).
• Relational Data Model: Key concepts like relation, tuple, primary key, and candidate key will be covered.
• Structured Query Language (SQL):
  • DDL (Data Definition Language): Use commands like CREATE DATABASE, CREATE TABLE, DROP, and ALTER.
  • DML (Data Manipulation Language): Learn to INSERT, UPDATE, and DELETE records.
  • DQL (Data Query Language): Master the SELECT statement with WHERE, BETWEEN, and logical operators to retrieve data.

Unit 4: Introduction to the Emerging Trends

Get a glimpse into the future of technology.

• Key Technologies: This unit covers a wide array of modern tech, including Artificial Intelligence (AI), Machine Learning (ML), Internet of Things (IoT), Cloud Computing (SaaS, IaaS, PaaS), Big Data, Robotics, and Blockchain.

---

Practical Syllabus (Total 30 Marks)

The practical component is crucial for applying the concepts you've learned.

Suggested Practical Exercises Include:

• Python Programming: Writing programs to calculate profit/loss, EMI, taxes, find the largest/smallest number in a list, and manipulate strings and dictionaries.
• SQL Commands: Creating databases and tables, inserting student records, and performing queries to filter and display data based on specific conditions.

This comprehensive syllabus for Class 11 Informatics Practices ensures students build a strong and practical foundation in computer science, preparing them for more advanced topics in Class 12 and beyond.

---

Here is the complete syllabus for Informatics Practices (Subject Code - 065) Class XI (2025-26):

1. Prerequisite

None

2. Learning Outcomes

At the end of this course, students will be able to:

• Identify the components of a computer system.
• Create Python programs using different data types, lists, and dictionaries.
• Understand database concepts and Relational Database Management Systems.
• Retrieve and manipulate data in RDBMS using Structured Query Language.
• Identify the Emerging trends in the fields of Information Technology.

3. Distribution of Marks and Periods

4. Unit Wise syllabus

Unit 1: Introduction to Computer System

• Introduction to computer and computing: evolution of computing devices, components of a computer system and their interconnections, Input/output devices.
• Computer Memory: Units of memory, types of memory – primary and secondary, data deletion, its recovery and related security concerns.
• Software: purpose and types – system and application software, generic and specific purpose software.

Unit 2: Introduction to Python

• Basics of Python programming: execution modes (interactive and script mode), the structure of a program, indentation, identifiers, keywords, constants, variables, types of operator, precedence of operators, data types, mutable and immutable data types, statements, expression evaluation, comments, input and output statements, data type conversion, debugging.
• Control Statements: if-else, if-elif-else, while loop, for loop.
• Lists: list operations - creating, initializing, traversing and manipulating lists, list methods and built-in functions – len(), list(), append(), insert(), count(), index(), remove(), pop(), reverse(), sort(), min(), max(), sum().
• Dictionary: concept of key-value pair, creating, initializing, traversing, updating and deleting elements, dictionary methods and built-in functions – dict(), len(), keys(), values(), items(), update(), del(), clear().
• Introduction to NumPy: Introduction, Creation of NumPy Arrays from List.

Unit 3: Database concepts and the Structured Query Language

• Database Concepts: Introduction to database concepts and its need, Database Management System.
• Relational data model: Concept of domain, tuple, relation, candidate key, primary key, alternate key.
• Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, creating a database using MySQL, Data Types.
• Data Definition: CREATE DATABASE, CREATE TABLE, DROP, ALTER.
• Data Query: SELECT, FROM, WHERE with relational operators, BETWEEN, logical operators, IS NULL, IS NOT NULL.
• Data Manipulation: INSERT, DELETE, UPDATE.

Unit 4: Introduction to the Emerging Trends

• Artificial Intelligence, Machine Learning, Natural Language Processing, Immersive experience (AR, VR), Robotics, Big data and its characteristics, Internet of Things (IoT), Sensors, Smart cities, Cloud Computing and Cloud Services (SaaS, IaaS, PaaS), Grid Computing, Block chain technology.

Practical Marks Distribution

5. Suggested Practical List

5.1 Programming in Python

1. To find average and grade for given marks.
2. To find sale price of an item with given cost and discount (%).
3. To calculate perimeter/circumference and area of shapes such as triangle, rectangle, square and circle.
4. To calculate Simple and Compound interest.
5. To calculate profit-loss for given Cost and Sell Price.
6. To calculate EMI for Amount, Period and Interest.
7. To calculate tax - GST / Income Tax.
8. To find the largest and smallest numbers in a list.
9. To find the third largest/smallest number in a list.
10. To find the sum of squares of the first 100 natural numbers.
11. To print the first ‘n’ multiples of given number.
12. To count the number of vowels in user entered string.
13. To print the words starting with an alphabet in a user entered string.
14. To print number of occurrences of a given alphabet in each string.
15. Create a dictionary to store names of states and their capitals.
16. Create a dictionary of students to store names and marks obtained in 5 subjects.
17. To print the highest and lowest values in the dictionary.

5.2 Data Management: SQL Commands

1. To create a database.
2. To create student table with the student id, class, section, gender, name, dob, and marks as attributes where the student id is the primary key.
3. To insert the details of at least 10 students in the above table.
4. To display the entire content of table.
5. To display Rno, Name and Marks of those students who are scoring marks more than 50.
6. To display Rno, Name, DOB of those students who are born between ‘2005- 01-01’ and ‘2005-12-31’.

Suggested Material

NCERT Informatics Practices - Text book for class - XI (ISBN- 978-93-5292-148-5)