CBSE Class 12 Informatics Practices Syllabus 2022-23
The CBSE Class 12 Informatics Practices Syllabus 2022-23 has been released by the central board of Secondary Education (CBSE) for the academic year 2022-23 on the official website cbseacademic.nic.in. We have given the CBSE Class 12 Informatics Practices Syllabus 2022-23 in detail on this page to save students’ efforts. Students who will appear for CBSE Class 12 Exams 2023 must read the complete CBSE Class 12 Informatics Practices Syllabus 2022-23.
CBSE Class 12 Syllabus 2022-23 |
CBSE Class 12 Physics Syllabus 2022-23 PDF Download |
CBSE Class 12 Mathematics Syllabus 2023 |
CBSE Class 12 Biology Syllabus 2023 |
CBSE Class 12 Chemistry Syllabus 2023 |
Class 12 Informatics Practices Syllabus 2022-23
CBSE Class 12 Informatics Practices Syllabus 2022-23 describes the mark distribution, course material, project details, test structure, and other important information. The Informatics Practices Syllabus for Class 12 CBSE is organized into four parts, each of which is further broken down into themes and sub-topics. The syllabus for Informatics Practices for Class 12 is tabulated here.
Informatics Practices Syllabus Class 12 CBSE
|
|||||
Unit | Unit Name | Marks Distribution | Periods (Theory) | Periods (Practical) | Total Periods |
1 | Data Handling using Pandas and Data Visualization | 25 | 25 | 25 | 50 |
2 | Database Query using SQL | 25 | 20 | 17 | 37 |
3 | Introduction to Computer Networks | 10 | 12 | 0 | 12 |
4 | Societal Impacts | 10 | 14 | – | 14 |
Project | – | – | 7 | 7 | |
Practical | 30 | – | – | – | |
Total | 100 | 71 | 59 | 120 |
CBSE Class 12 Informatics Practices Syllabus 2022-23 Pdf Download
CBSE Class 12 Informatics Practices Syllabus 2022-23 is available on the official website of CBSE i.e cbseacademic.nic.in. Candidates can download the CBSE Class 12 Informatics Practices Syllabus 2022-23 pdf from the official site. For the benefits, here have provided the CBSE Class 12 Informatics Practices Syllabus 2022-23 in the below link.
Class 12 Informatics Practices Syllabus 2023 Unit Wise
The CBSE Class 12 Informatics Practices Syllabus 2022-23 consists of 4 units . These 4 units of the CBSE Class 12 Informatics Practices Syllabus 2022-23 are again broken into several subunits. Check all the units and subunits included in the CBSE Class 12 Informatics Practices Syllabus 2022-23 below:
Unit 1: Introduction to Computer System
Introduction to computer and computing: evolution of computing devices, components of a computer system and their interconnections, and 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.
Class 12 Informatics Practices Syllabus 2023 for Practical
Below we have provided the Suggested Practical List for CBSE Class 12 Informatics Practices Syllabus 2023:
Programming in Python
1. Determine the average and grade for a set of marks.
2. Determine the sale price of an item given its cost and a percentage discount (%).
3. Determine the perimeter/circumference and area of shapes such triangles, rectangles, squares, and circles.
4. Determine simple and compound interest.
5. Determine profit and loss for a given cost and sell price.
6. Determine the EMI based on the amount, period, and interest rate.
7. To compute tax (GST / Income Tax).
8. To identify the highest and lowest integers in a list.
9. To find the third highest/lowest number in a list.
10. Determine the sum of the first 100 natural numbers’ squares.
11. Display the first ‘n’ multiples of a given number.
12. Count the number of vowels in the string entered by the user.
13. To print the words in a user-entered string that begin with an alphabet.
14. Print the number of times a specific alphabet appears in each string.
15. Construct a dictionary to record state and capital names.
16. Build a student dictionary to record names and grades from five subjects.
17. To print the dictionary’s highest and lowest values.
Data Management: SQL Commands
18. Making a database
19. To build a student table with the characteristics student id, class, section, gender, name, dob, and marks, with the student id serving as the primary key.
20. Enter the information for at least ten students in the preceding table.
21. To display the complete table’s information.
22. To display the Rno, Name, and Marks of students scoring more than 50.
23. Calculate the average of the student table’s grades.
24. Determine the number of pupils from Section ‘A’.
25. Display information for all students whose names begin with ‘AN’ (for example, ANAND, ANGAD, etc.).
26. Display Rno, Name, and DOB of students born between ‘2005-01-01’ and ‘2005-12-31’.
27. To display the Rno, Name, DOB, Marks, and Email of those male students in alphabetical order.
28. Show Rno, Gender, Name, DOB, Marks, and Email in descending order of their marks.
29. To highlight the table’s one-of-a-kind segment.
Marks distribution for CBSE Class 12 Informatics Practices Syllabus 2023
S.No. | Unit name | Marks |
1 | Problem solving using Python programming language | 11 |
3 | Creating database using MySQL and performing Queries | 7 |
4 | Practical file (minimum of 14 python programs, and 14 SQL queries) | 7 |
5 | Viva-Voce | 5 |
Total | 30 |
CBSE Class 12 Informatics Practices Syllabus 2022-23 : Prescribed Books
Check out the Prescired books for CBSE Class 12 Informatics Practices Syllabus 2022-23.
- NCERT Informatics Practices – Textbook for class – XI (ISBN- 978-93-5292-148-5 )
Excluded topics - Nested loop(Chapter -3, Section – 3.13)
- Loading and saving NumPy array in text files (Chapter-6, Sections- 6.10 and
6.11)