The NCERT Syllabus for Class 11 Informatics practices 2022-2023 is released by the National Council of Educational Research and Training (NCERT). The curriculum is prepared under the guidelines of the National Curriculum Framework (NCF), along with keeping the latest CBSE guidelines into consideration.
Recommended: Study for your Exams with Safalta School online.
We provide Preparation materials for Classes 9-12 that can boost your preparations.
Table of Content
NCERT syllabus for Class 11 Informatics Practices 2022-2023: Learning Outcomes
With the help of the NCERT Syllabus for Class 11 Informatics practices 2022-2023, candidates may be able to:
- Determine the components of the computer system.
- Construct Python programs using different data types, lists, and dictionaries.
- Comprehend database concepts and Relational Database Management Systems.
- Recover and control data in RDBMS using Structured Query Language
- Recognize the Emerging trends in the fields of Information Technology.
NCERT CBSE syllabus for Class 11 Informatics Practices: Marks Distribution
| Unit No. | Unit Name | Marks | Periods (Theory) | Periods (Practical) | Total Period |
| 1 | Introduction to computer system | 10 | 10 | - | 10 |
| 2 | Introduction to Python | 25 | 35 | 28 | 63 |
| 3 | Database concepts and the Structured Query Language | 30 | 23 | 17 | 40 |
| 4 | Introduction to Emerging Trends | 05 | 07 | - | 07 |
| Practical | 30 | - | - | - | |
| Total | 100 | 75 | 45 | 120 |
NCERT syllabus for Class 11 Informatics Practices: Course Content
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, Python interpreter – interactive and script mode, the structure of a program, indentation, identifiers, keywords, constants, variables, types of operators, precedence of operators, data types, mutable and immutable data types, statements, expressions, evaluation and comments, input and output statements, data type conversion, debugging.
- Control Statements: if-else, for loop
- Lists: list operations – creating, initializing, traversing and manipulating lists, list methods and built-in functions.
- Dictionary: concept of key-value pair, creating, initializing, traversing, updating and deleting elements, dictionary methods and built-in functions.
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 TABLE
- Data Query: SELECT, FROM, WHERE.
- Data Manipulation: INSERT
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.
Also read:
NCERT Syllabus for Class 11 Physics
NCERT Syllabus for Class 11 Chemistry
NCERT Syllabus for Class 11 Biology
NCERT Syllabus for Class 11 English
NCERT Syllabus for Class 11 Hindi
NCERT Syllabus for Class 11 Accountancy
NCERT Syllabus for Class 11 Business Studies
NCERT Syllabus for Class 11 Economics
NCERT Syllabus for Class 11 Computer Science
NCERT Syllabus for Class 11 History
NCERT Syllabus for Class 11 Political Science
NCERT Syllabus for Class 11 Geography
NCERT Syllabus for Class 11 Home Science
NCERT Syllabus fror Class 11 Sanskrit
NCERT Syllabus for Class 11 Human Rights and Gender Studies
NCERT Syllabus for Class 11 Legal Studies
NCERT Syllabus for Class 11 Hindustani Music
NCERT Syllabus for Class 11 Biotechnology
NCERT Syllabus for Class 11 Psychology
NCERT Syllabus for Class 11 Philosophy
NCERT Syllabus for Class 11 Sociology
NCERT syllabus for Class 11 Informatics Practices: Practical Marks Distribution
| Unit No. | Unit Name | Marks |
| 1 | Problem solving using Python programming language | 11 |
| 3 | Creating database using MySQL and performing Queries | 07 |
| 4 | Practical file (minimum of 14 python programs, and 14 SQL queries) | 07 |
| 5 | Viva voce | 05 |
| Total | 30 |
Recommended Practical List
Programming in Python
- To see average and grade for given marks.
- To discover the sale price of an item with a given cost and discount (%).
- To compute perimeter/circumference and area of shapes such as triangle, rectangle, square, and circle
- To compute Simple and Compound interest.
- To calculate profit-loss for given Cost and Sell Price.
- To estimate EMI for Amount, Period, and Interest.
- To estimate tax – GST / Income Tax.
- To discover the largest and smallest numbers in a list.
- To see the third largest/smallest number in a list.
- To discover the sum of squares of the first 100 natural numbers.
- To print the initial ‘n’ multiples of a assigned numeral.
- To count the number of vowels in the user-entered string.
- To print the words starting with an alphabet in a user-entered string.
- To print the number of occurrences of a given alphabet in each string.
- Construct a dictionary to store the names of states and their capitals.
- Build a dictionary of students to store names and marks obtained in 5 subjects.
- Print the maximum and minimum numerals in the dictionary.
Data Management: SQL Commands
- To construct a database
- To make a student table with the student id, class, section, gender, name, dob, and marks as attributes where the student id is the primary key.
- To put in the details of at least 10 students in the above table.
- To show the entire content of the table.
- To exhibit the Rno, Name, and Marks of those students who are scoring marks more than 50.
- To see the average of marks from the student table.
- To discover the number of students, who are from section ‘A’.
- To indicate the information to all the students, whose name starts with ‘AN’ (Examples: ANAND, ANGAD,)
- To show Rno, Name, DOB of those students who are born between ‘2005- 01-01’ and ‘2005-12-31’.
- To demonstrate Rno, Name, DOB, Marks, and Email of those male students in ascending order of their names.
- To show Rno, Gender, Name, DOB, Marks, and Email in descending order of their marks.
- To exhibit the peculiar area available in the table.
NCERT syllabus for Class 11 Informatics practices 2022-2023 PDF Download
NCERT syllabus for Class 11 Informatics practices PDF
How many units are there in the NCERT Syllabus for Class 11 Informatics Practices?
There are four units in the NCERT Syllabus for Class 11 Informatics Practices.
How can I download NCERT Syllabus for Class 11 Informatics Practices PDF?
You can easily download the NCERT Syllabus for Class 11 Informatics Practices PDF from the blog. Link is also given below.
NCERT syllabus for Class 11 Informatics practices PDF
NCERT syllabus for Class 11 Informatics practices PDF
How many marks does Informatics Practices (Theory) holds in Class 11?
The theory section holds 70 marks where as practical section includes 30 marks.
What is Safalta School Online?
Safalta school online is an initiative of Safalta Pvt Ltd to help students score well in their exams by sitting in their homes. We provide online lectures that are very beneficial for the students.
What is the fee of Safatla School Online?
The fee for Safalta School Online is very affordable. It ranges between 6999 to 9999.
