NCERT syllabus for Class 11 Informatics Practices 2022-2023, Download PDF

Safalta Expert Published by: Noor Fatima Updated Mon, 19 Sep 2022 05:00 PM IST

Highlights

Here is the information about NCERT Syllabus for Class 11 Informatics Practices. You can give a read to this blog and get all the information about the NCERT Curriculum for Class 11 Informatics Practices. 

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. The curriculum consists of concepts such as Introduction to the computer system, Introduction to Python, Database concepts and the Structured Query Language, Introduction to Emerging Trends, etc. This article will provide you with a thorough description of the NCERT Syllabus for Class 11 Informatics practices. For the convenience of the students, we have also attached a link to download the PDF of the curriculum. The syllabus outlines the learning outcomes, course content, practical details, practical marks distribution, and the recommended list for practical work. Once you are well-versed with the syllabus, you can prepare your study schedule and prepare for the exams effectively and efficiently. Therefore, we advised the students to go through and understand the NCERT syllabus Class 11 Informatics practices 2022 2023.

Free Demo Classes

Register here for Free Demo Classes

Please fill the name
Please enter only 10 digit mobile number
Please select course
Please fill the email
 

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
NCERT CBSE syllabus for Class 11 Informatics practices: Marks Distribution
NCERT syllabus for Class 11 Informatics practices: Course Content
NCERT syllabus for Class 11 Informatics practices: Practical Marks Distribution
Recommended Practical List
NCERT syllabus for Class 11 Informatics practices 2022-2023 PDF Download
 

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

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. 

Free E Books