MP Board Class 12th Informatics Practices Syllabus
माध्यमिक शिक्षा मण्डल, मध्यप्रदेश भोपाल - हायर सेकंडरी परीक्षा 2026-27
Chapter 1: Database Query using SQL
- Revision of database concepts and SQL commands covered in Class XI
- Mathematical 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 multiple tables using equi-join
- Study Material PDF: Download PDF
Chapter 2: Data Handling using Pandas and 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 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
- Study Material PDF: Download PDF
Chapter 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
- Study Material PDF: Download PDF
Chapter 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, cyber bullying
- Overview of Indian IT Act
- E-waste: hazards and management
- Awareness about health concerns related to the usage of technology
- Study Material PDF: Download PDF