Table of Contents
CBSE Class 12 Informatics Practices Syllabus 2023-24: Students who are enrolled in the senior secondary programme offered by the CBSE Board often refer to Informatics Practises (or IP for short) as IP. The paper focuses on the CBSE Board’s curriculum for the 12th class in Informatics Practises, which aims to enable candidates to create series, and data frames, and apply various operations; visualise data using relevant graphs; design SQL queries using aggregate functions; import/export data between SQL database and Pandas; understand terminologies related to networking and the internet; recognise internet security issues and configure browser settings; and understand the impact that technology has.
CBSE Class 12 Informatics Practices Syllabus 2023-24
The CBSE Class 12 Informatics Practises Syllabus 2023-24 covers a wide variety of subjects, such as data processing through the use of Pandas and data visualisation, database querying through the use of SQL, an introduction to computer networks, and societal consequences. The first lesson will teach students about the several data structures that may be created using Pandas, such as Series and DataFrames.
In addition to this, they will learn how to produce, modify, and visualise data with the help of the Pandas and Matplotlib libraries. The second lesson covers how to query databases by using the SQL language. Students will learn how to establish and administer databases, as well as how to write SQL queries to access and alter data. In addition, students will learn how to write SQL queries. Students are given an introduction to computer networks in the third unit. They will get knowledge regarding the many kinds of networks, the topologies of networks, as well as the internet.
The effects of information technology on society are investigated in the fourth and final unit. Students will gain knowledge on a variety of subjects, including cybercrime, data protection, internet and communication etiquette, protecting intellectual property rights, and leaving a digital imprint. In addition, the course will contain a practical component, during which time the students will have the opportunity to put the ideas that they have acquired in the theoretical units to use in real-world situations. Students will be better prepared to meet the challenges of the 21st-century workforce after completing the CBSE Class 12 Informatics Practises Syllabus 2023-24, which offers a curriculum that is both thorough and current.
CBSE Class 12 Informatics Practices Syllabus 2023-24 Marks distribution
The CBSE Class 12 Informatics Practises Syllabus 2023-24 is broken down into two parts: theory and practise. The theory portion is worth 80 points, while the practical portion is worth 20 points. The subject’s final grade is calculated as the sum of the theory and practical grades. The table below consists of CBSE Class 12 informatics practices syllabus 2023-24 marks distribution.
Unit No. | Unit Name | Marks |
1 | Data Handling using Pandas and Data Visualization | 25 |
2 | Database Query using SQL | 25 |
3 | Introduction to Computer
Networks |
10 |
4 | Societal Impacts | 10 |
Project | – | |
Practical | 30 | |
Total | 70 |
CBSE Class 12 Informatics Practices Syllabus 2023-24 Unit-wise syllabus
The table below consists of CBSE Class 12 informatics practices syllabus 2023-24 unit-wise syllabus.
Unit | Name | Description |
1 | Data Handling using Pandas -I | Introduction to Python libraries- Pandas, Matplotlib.Data structures in Pandas – Series and Data Frames.
Series: Creation of Series from – ndarray, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection, Indexing and Slicing. Data Frames: creation – from the dictionary of Series, list of dictionaries, Text/CSV files; display; iteration; Operations on rows and columns: add, select, delete, rename; Head and Tail functions; Indexing using Labels, Boolean Indexing; Importing/Exporting Data between CSV files and Data Frames. Data Visualization Purpose of plotting; drawing and saving the following types of plots using Matplotlib – line plot, bar graph, histogram Customizing plots: adding labels, titles, and legends in plots. |
2 | Database Query using SQL | Revision of database concepts and SQL commands covered in class XI
Math functions: POWER (), ROUND (), MOD (). Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME (). Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*). Querying and manipulating data using Group by, Having, Order by. Working with two tables using equi-join |
3 | Introduction to Computer Networks | Introduction to networks, Types of network: PAN, LAN, MAN, WAN.
Network Devices: modem, hub, switch, repeater, router, gateway Network Topologies: Star, Bus, Tree, Mesh. Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP. Website: Introduction, difference between a website and webpage, static vs dynamic web page, web server and hosting of a website. Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies. |
4 | Societal Impacts | Digital footprint, net and communication etiquettes, data protection, intellectual property rights (IPR), plagiarism, licensing and copyright, free and open source software (FOSS), cybercrime and cyber laws, hacking, phishing, cyberbullying, overview of Indian IT Act.
E-waste: hazards and management. Awareness about health concerns related to the usage of technology. |
CBSE Class 12 Informatics Practices Syllabus 2023-24 Pdf
The CBSE Class 12 Informatics Practices Syllabus 2023-24 PDF is a comprehensive document that outlines the topics and learning outcomes for the Informatics Practices subject in the 12th grade. The pdf is given below.
CBSE Class 12 Informatics Practices Syllabus 2023-24
Also, check other syllabi.
CBSE Class 12 Syllabus 2023-24 | |
CBSE Class 12 Maths Syllabus 2023-24 | CBSE Class 12 Physics Syllabus 2023-24 |
CBSE Class 12 Chemistry Syllabus 2023-24 | CBSE Class 12 Economics Syllabus 2023-24 |