Скачать или смотреть Informatics Practices (IP) Full Syllabus 2025-26 📘 Complete Details & Exam Guide पूरी जानकारी

Informatics Practices (IP) Full Syllabus 2025-26 📘 Complete Details & Exam Guide
Unit
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 dictionary of Series list of dictionaries, Text/CSV files,
d isplay; 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.
Unit 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, DAYDAYNAME.
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.
Unit 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, addons and plug ins, cookies.
Unit 4: Societal Impacts Digital footprint, net and communication etiquettes, data protection, intellectual property rights plagiarism, licensing and copyright, free and open source software
cybercrime and cyber laws, hacking, phishing, cyber bullying, overview of Indian IT Act. Ewaste: hazards and management. Awareness about health concerns related to the usage of technology.
Practical Marks IP = 30 Marks
#informaticspractices #dataframe #pandas #series #sql #dbms #networking #societalimpact #DDl#DML#Sqldatatype