Who releases the Informatics Practices Class 12 Syllabus 2024-25?
Every year CBSE releases syllabus for Informatics practices on their official website (www.cbseacademic.nic.in) . Informatics Practices syllabus 2024-25 is published before the start of an academic year. Informatics practices subject is offered to class 11 and 12 students of CBSE affiliated schools in India and the subject is very scoring and easy and those who love to solve problems, have good logical reasoning ability and love to learn basics of programming , must opt for this subject.
Units in Informatics practices Class 12 Syllabus 2024-25
There are a total of 4 units in Informatics practices Class 12 Syllabus 2024-25. There unit wise marks distribution is as follows:
- Unit 1 : Data Handling using Pandas -I (Marks : 25 )
- Unit 2 : Database Query using SQL (Marks : 25)
- Unit 3 : Introduction to Computer Networks (Marks : 10)
- Unit 4 : Societal Impacts (Marks : 10)
- Theory Exam : 70 Marks , Practical Exam : 30 Marks
Since this is a practical-oriented subject, there will be a theory exam as well as a practical exam. The CBSE final or session-ending theory exam will be of 70 marks and will be conducted at the Centre allotted by CBSE and is mentioned in students admit card and the practical exam will be of 30 marks and will be conducted by subject teacher at the school level along with external examiner appointed by CBSE.
Topics in Unit 1 of Informatics practices Class 12 Syllabus 2024-25
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 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 following types of plots using Matplotlib – line plot, bar graph, histogram
Customizing plots: adding label, title, and legend in plots.
Topics in Unit 2 of Informatics practices Class 12 Syllabus 2024-25
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
Topics in Unit 3 of Informatics practices Class 12 Syllabus 2024-25
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.
Topics in Unit 4 of Informatics practices Class 12 Syllabus 2024-25
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, cyber bullying, overview of Indian IT Act.
E-waste: hazards and management.
Awareness about health concerns related to the usage of technology.