Class 11 Informatics Practices (IP) Syllabus

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

Unit 1: Introduction to Computer System (10 Marks)

1. Computer Components

   • CPU, Memory (RAM, ROM), Storage Devices (HDD, SSD, Pen Drive)

   • Input & Output Devices

   • Software (System Software, Application Software, Open Source vs Proprietary)

2. Networking Basics

   • Types of Networks: LAN, MAN, WAN

   • Network Devices: Modem, Router, Switch

   • Internet, Web Browsers, WWW, Websites

Unit 2: Introduction to Python Programming (25 Marks)

1. Basics of Python

   • Installing Python, Writing First Program

   • Data Types: Numbers, Strings, Lists, Tuples, Dictionaries

   • Operators: Arithmetic, Relational, Logical

2. Conditional & Looping Statements

   • if, if-else, elif

   • Loops: for, while

3. Functions & Modules

   • Creating Functions, Importing Modules (math, random)

4. File Handling in Python

   • Reading and Writing files (.txt files)

Unit 3: Database Management System (20 Marks)

1. Database Concepts

   • Data, Field, Record, Table

   • Need for a Database

2. Introduction to MySQL

   • Creating and Using a Database

   • SQL Commands: CREATE, INSERT, SELECT, DELETE, UPDATE

   • Operators: Arithmetic, Comparison, Logical

   • Functions: COUNT(), SUM(), AVG(), MAX(), MIN()

Unit 4: Societal Impacts of IT (15 Marks)

1. Digital Footprint & Privacy Issues

   • Cybercrime, Phishing, Hacking, Identity Theft

2. Social Media & Ethics

   • Fake News, Misinformation, Cyberbullying

3. IT Applications

   • Role of IT in Healthcare, Education, E-Governance

Practical Assessment (30 Marks)

1. Python Programming (8 Marks) – Writing small programs

2. SQL Queries Execution (5 Marks) – Basic SQL commands

3. Practical Notebook & Viva (7 Marks)

4. Mini Project (10 Marks) – Small project using Python and MySQL

ELIGIBILITY:- 10TH PASS