CERTIFICATE IN 12 CBSE ( S-12CBSE )

Class 12 Informatics Practices (IP) Syllabus

Total Marks: 100 (Theory: 70, Practical: 30)

Unit 1: Data Handling using Pandas and Data Visualization (30 Marks)

1. Introduction to Python Libraries

   • NumPy: Arrays and basic operations

   • Pandas: Series & DataFrames, importing/exporting data

   • Data handling: Selecting, filtering, sorting, grouping

2. Data Visualization using Matplotlib

   • Line, bar, histogram, scatter plots

   • Customization of plots

Unit 2: Database Query using SQL (15 Marks)

1. Relational Databases

   • Concept of Database Management System (DBMS)

   • RDBMS concepts: Tables, keys (Primary & Foreign)

2. SQL Queries

   • Creating, modifying, deleting tables

   • SQL commands: SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOIN

   • Aggregate functions: SUM, COUNT, AVG, MAX, MIN

Unit 3: Introduction to Computer Networks (10 Marks)

1. Networking Basics

   • Types: LAN, MAN, WAN

   • Devices: Hub, Switch, Router, Gateway

   • Protocols: HTTP, FTP, SMTP, POP, IMAP

2. Internet Technologies

   • Web servers, HTML, DNS, Cloud Computing

   • Cybersecurity concepts: Firewalls, HTTPS, Encryption

Unit 4: Societal Impacts (15 Marks)

1. Digital Footprints and Privacy

   • Safe browsing, phishing, identity theft

2. Ethical Issues in Technology

   • Cyber ethics, plagiarism, digital divide

3. E-Governance and E-Commerce

   • Role of IT in governance and business

Practical Assessment (30 Marks)

1. Python Programming using Pandas & Matplotlib (8 Marks)

2. SQL Queries Execution (5 Marks)

3. Networking Basics & Internet Technologies (2 Marks)

4. Project Work (8 Marks) – Data analysis project using Python

5. Viva and Practical Notebook (7 Marks)

ELIGIBILITY:- 11TH PASS