Madhya Pradesh MP Board Class 12 Informatics Practices Syllabus And Marking Scheme 2024-25: Download The PDF For Free!

Database Query using SQL - Revision of database concepts and SQL commands covered in class XI Math functions: POWER (), ROUND (0), MOD (). Text functions: UCASE (UPPER 0. LCASE(/LOWER (0), MID (SUBSTRING()/SUBSTR (). LENGTH (0), LEFT (), RIGHT 0, INSTR (0), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (0), DATE (0), MONTH 0. MONTHNAME 0, YEAR (0), DAY 0, DAYNAME 0. Aggregate Functions: MAX (), MIN 0. AVG 0, SUM (0), COUNT 0; using COUNT (*). Querying and manipulating data using Group by, Having, and Order by. Working with multiple tables using equi-join

Data Handling using Pandas I and Plotting Data Using Matplotlib - 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, and histogram Customizing plots: adding labels, titles, and legends in plots.

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, the difference between a website and a 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.

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, an overview of Indian IT Act. E-waste: hazards and management. Awareness about health concerns related to the usage of technology.

S.no. 

Topic

Marks

1. 

Database Query using SQL

16

2. 

Data Handling using Pandas -I and Plotting

Data using Matplotlib

17

3. 

Introduction to Computer Network

19

4. 

Societal Impacts

18

Total

70