CBSE Class XI Informatics Practices
Complete Chapter-wise Syllabus 2025-26 | Subject Code: 065
Course Overview
Theory Paper
70
Marks
Practical Work
30
Marks
Duration
3
Hours
Total Units
4
Units
Learning Objectives
- Understanding computer system components and their interconnections
- Learning Python programming fundamentals including data types, control structures, and functions
- Working with Python data structures like lists, dictionaries, and NumPy arrays
- Understanding database concepts and relational database management systems
- Learning SQL commands for database creation, manipulation, and querying
- Exploring emerging technologies like AI, IoT, Cloud Computing, and Blockchain
- Developing practical programming skills through hands-on laboratory sessions
- Building foundational knowledge for advanced computer science studies
Unit-wise Marks Distribution
| Unit No. | Unit Name | Theory Marks | Percentage | Focus Area |
|---|---|---|---|---|
| 1 | Introduction to Computer System | 10 | 14.3% | Hardware & Software |
| 2 | Introduction to Python | 25 | 35.7% | Programming Fundamentals |
| 3 | Database Concepts and SQL | 30 | 42.9% | Database Management |
| 4 | Introduction to Emerging Trends | 5 | 7.1% | Latest Technologies |
| Total Theory | 70 | 100% | 4 Units | |
Note: Python Programming and Database Management carry maximum weightage (55 marks combined - 78.6%)
Unit 1: Introduction to Computer System (10 Marks)
NCERT Chapter 1: Computer System
Comprehensive introduction to computer hardware, software, and system architecture
Computer System Components Focus
Introduction to Computer and Computing
- Evolution of computing devices from mechanical to electronic
- Components of a computer system
- Interconnections between system components
- Input and output devices functionality
- System unit and processing components
Computer Memory
- Units of memory measurement (Bit, Byte, KB, MB, GB, TB)
- Types of memory - Primary and Secondary
- RAM, ROM, Cache memory characteristics
- Storage devices - HDD, SSD, Optical drives
- Data deletion, recovery, and security concerns
- Memory hierarchy and access speeds
Software Concepts Important
Software Types and Purpose
- Purpose and classification of software
- System software vs Application software
- Operating systems and their functions
- Device drivers and utility programs
- Generic vs Specific purpose software
- Programming languages and translators
- Software licensing and distribution models
Unit 2: Introduction to Python (25 Marks)
HIGHEST WEIGHTAGE - 35.7% of Theory Marks
NCERT Chapters 3 & 4: Python Programming and Data Structures
Complete Python fundamentals with practical programming concepts and data structures
Python Programming Basics 15 Marks
Chapter 3: Brief Overview of Python
- Introduction to Python programming language
- Execution modes: Interactive and Script mode
- Program structure and indentation importance
- Python keywords and identifiers
- Constants, variables, and naming conventions
- Input and output statements (input(), print())
- Comments and documentation practices
Data Types and Operators
- Data types: int, float, string, boolean
- Mutable vs Immutable data types
- Operators: Arithmetic, Relational, Logical
- Assignment and Identity operators
- Operator precedence and associativity
- Data type conversion and type casting
- Expression evaluation and debugging
Control Structures & Functions 10 Marks
Control Flow Statements
- if-else conditional statements
- if-elif-else multiple conditions
- while loop implementation
- for loop with range() function
- Nested loops and loop control
- break and continue statements
Chapter 4: Working with Lists and Dictionaries
- Introduction to lists and list operations
- Creating, initializing, and traversing lists
- List methods: append(), insert(), remove(), pop()
- Built-in functions: len(), min(), max(), sum()
- List manipulation and sorting
- Dictionary concepts and key-value pairs
- Dictionary methods: keys(), values(), items(), update()
- Traversing and manipulating dictionaries
NumPy Introduction Advanced
Chapter 6: Introduction to NumPy
- NumPy library introduction and installation
- Creating NumPy arrays from lists
- Array operations and mathematical functions
- Indexing and slicing operations
- Array concatenation and reshaping
- Statistical operations on arrays
- Loading and saving arrays from files
Data Handling Concepts Foundation
Chapter 5: Understanding Data
- Introduction to data and its importance
- Data collection methods and sources
- Data storage formats and structures
- Data processing techniques
- Statistical techniques for data analysis
- Data visualization basics
Unit 3: Database Concepts and Structured Query Language (30 Marks)
MAXIMUM WEIGHTAGE - 42.9% of Theory Marks
NCERT Chapters 7 & 8: Database Management and SQL
Complete database fundamentals with MySQL implementation and SQL command mastery
Database Fundamentals 15 Marks
Chapter 7: Database Concepts
- Introduction to database concepts and necessity
- File system vs Database Management System
- DBMS advantages and characteristics
- Relational data model concepts
- Domain, tuple, and relation terminology
- Keys in relational database: Primary, Candidate, Alternate
- Database design principles
SQL Implementation 15 Marks
Chapter 8: Introduction to SQL
- Structured Query Language overview
- Introduction to MySQL database system
- Creating databases using MySQL
- SQL data types and constraints
- Data Definition Language (DDL) commands
- Data Manipulation Language (DML) commands
- Data Query Language (DQL) commands
SQL Command Categories
- DDL: CREATE DATABASE, CREATE TABLE, DROP, ALTER
- DML: INSERT, UPDATE, DELETE operations
- DQL: SELECT with WHERE, FROM clauses
- Relational operators and logical operators
- BETWEEN, IS NULL, IS NOT NULL conditions
- Data updation and deletion techniques
Unit 4: Introduction to Emerging Trends (5 Marks)
NCERT Chapter 2: Emerging Trends
Overview of cutting-edge technologies shaping the future of information technology
Artificial Intelligence & Big Data 3 Marks
AI and Machine Learning
- Artificial Intelligence (AI) fundamentals
- Machine Learning concepts and applications
- Natural Language Processing (NLP)
- Immersive experiences: AR and VR
- Robotics and automation
Big Data and Analytics
- Big Data characteristics (Volume, Velocity, Variety)
- Data analytics and processing techniques
- Internet of Things (IoT) concepts
- Sensors and smart devices
- Smart cities implementation
Cloud & Distributed Computing 2 Marks
Cloud Computing Services
- Cloud Computing fundamentals
- Cloud service models: SaaS, IaaS, PaaS
- Grid Computing architecture
- Blockchain technology basics
- Distributed computing benefits
- Technology trends and future scope
Practical Work (30 Marks)
HANDS-ON ASSESSMENT - 30% of Total Marks
Practical Requirements
Laboratory Sessions: Regular programming practice
Practical File: Minimum 14 Python + 14 SQL programs
Software: Python 3.x, MySQL, Text Editor/IDE
Assessment: Continuous evaluation throughout the year
Practical Marks Distribution
Python Programming
11 Marks
Problem solving using Python concepts
MySQL Database
7 Marks
Database creation and SQL queries
Practical File
7 Marks
Complete program documentation
Viva-Voce
5 Marks
Oral examination on concepts
Suggested Python Programming List
Basic Calculations
- Find average and grade for given marks
- Calculate sale price with cost and discount percentage
- Calculate perimeter and area of geometric shapes
- Simple and compound interest calculations
- Profit-loss calculation for given cost and sell price
- EMI calculation for amount, period, and interest
- Tax calculations (GST/Income Tax)
List Operations
- Find largest and smallest numbers in a list
- Find third largest/smallest number in a list
- Sum of squares of first 100 natural numbers
- Print first 'n' multiples of given number
- List manipulation and sorting programs
- Search and count operations on lists
String Processing
- Count number of vowels in user entered string
- Print words starting with specific alphabet
- Count occurrences of given alphabet in string
- String manipulation and formatting
- Pattern matching and replacement
Dictionary Operations
- Create dictionary to store state names and capitals
- Student dictionary with names and marks in 5 subjects
- Print highest and lowest values in dictionary
- Dictionary manipulation and updating
- Data processing using dictionaries
Suggested SQL Programming List
Database Creation
- Create a database for school management
- Create student table with proper attributes
- Define primary keys and constraints
- Create tables with different data types
Data Manipulation
- Insert details of at least 10 students
- Update student information
- Delete specific student records
- Modify table structure using ALTER
Data Querying
- Display entire content of table
- Display students with marks more than 50
- Show students born between specific dates
- Use WHERE clause with different conditions
- Apply relational and logical operators
- Use IS NULL and IS NOT NULL conditions
Practical Work Guidelines
- Maintain proper documentation for all programs
- Include algorithm, code, and output for each program
- Test programs with different input values
- Follow proper coding standards and conventions
- Use meaningful variable names and comments
- Practice debugging and error handling
- Understand the logic behind each program
- Be prepared for viva-voce examination
- Keep backup of all practical work
- Submit practical file as per schedule
Examination Pattern (March 2026)
Question Paper Design
Total Marks: 70 | Duration: 3 Hours
Subject Code: 065
| Question Type | Cognitive Level | Marks | Percentage |
|---|---|---|---|
| Remembering and Understanding | Knowledge & Comprehension | 28 | 40% |
| Applying | Application | 21 | 30% |
| Analysing, Evaluating and Creating | Higher Order Thinking | 21 | 30% |
| Total Theory + Practical | 100 | 100% | |
Assessment Features
- Programming questions with algorithm and code writing
- SQL query writing and database design problems
- Conceptual questions on computer systems and emerging technologies
- Error detection and debugging in Python programs
- Output prediction for given code snippets
- Database normalization and relationship questions
- Practical application of programming concepts
- Integration of theoretical knowledge with practical implementation
Key Success Tips
Preparation Strategy
- Master Python programming fundamentals through regular practice
- Focus on database concepts and SQL command mastery
- Understand computer system components and software types
- Stay updated with emerging technology trends
- Practice writing algorithms before coding
- Learn to debug programs and handle errors effectively
- Complete all practical assignments throughout the year
- Maintain well-documented practical file with proper formatting
- Practice SQL queries on real databases
- Understand the theory behind practical implementations
- Work on additional programming projects for better understanding
- Prepare thoroughly for viva-voce examination
Career Connections
Programming & Development
- Computer Science Engineering
- Software Development
- Web Development
- Mobile App Development
- Game Development
- Python Programming Specialist
- Full Stack Development
Database & Analytics
- Database Administrator (DBA)
- Data Analyst
- Data Scientist
- Business Intelligence Analyst
- SQL Developer
- Database Designer
- Data Engineer
Emerging Technologies
- Artificial Intelligence Engineer
- Machine Learning Specialist
- Cloud Computing Professional
- IoT Developer
- Blockchain Developer
- Cybersecurity Analyst
- AR/VR Developer
IT Services & Management
- IT Project Manager
- System Administrator
- Technical Support Specialist
- IT Consultant
- Network Administrator
- Quality Assurance Tester
- Technical Writer
Higher Education
- Bachelor of Computer Applications (BCA)
- B.Tech Computer Science
- B.Sc Information Technology
- Bachelor of Information Systems
- Diploma in Computer Science
- Certification Courses in Programming
- Professional Development Programs
Entrepreneurship
- Tech Startup Founder
- Software Product Development
- Mobile App Business
- E-commerce Platform
- Digital Marketing Agency
- Online Education Platform
- Technology Consulting
Important Resources
Official CBSE Resources
- NCERT Informatics Practices Textbook Class XI
- CBSE Sample Papers 2025-26
- Previous Year Question Papers
- CBSE Marking Schemes
- Practical Assessment Guidelines
- Laboratory Manual for IP
Programming Resources
- Python Official Documentation
- NumPy Library Reference
- Python Programming Practice Sites
- Code Repository and Examples
- Interactive Python Tutorials
- Programming Challenge Platforms
Database Resources
- MySQL Official Documentation
- SQL Tutorial and Practice
- Database Design Guidelines
- MySQL Workbench Installation
- SQL Query Practice Platforms
- Database Management Tools
Development Tools
- Python IDLE (Integrated Development Environment)
- PyCharm Community Edition
- Visual Studio Code
- MySQL Workbench
- Jupyter Notebook
- Git Version Control
Online Learning
- Python Programming Courses
- Database Management Tutorials
- Interactive Coding Platforms
- Video Lectures and Demonstrations
- Programming Forums and Communities
- Technical Blog Posts and Articles
Follow Us
Stay updated with latest syllabus updates, exam tips, and educational content:
Follow @menturox.inAcademic Timeline 2025-26
| Month | Academic Activity | Focus Area |
|---|---|---|
| April - May 2025 | Unit 1: Computer Systems | Hardware, Software, Memory concepts |
| June - July 2025 | Unit 2: Python Basics | Programming fundamentals, data types |
| August - September 2025 | Python Data Structures | Lists, dictionaries, functions |
| October - November 2025 | Unit 3: Database Concepts | DBMS, SQL commands |
| December 2025 | Unit 4: Emerging Trends | AI, IoT, Cloud Computing |
| January - February 2026 | Revision & Practical Completion | Mock tests, practical file submission |
| March 2026 | Board Examinations | Theory and practical assessment |