CLASS 12 IP (3 MARKS QUESTIONS)

TOPICS

ACCORDING TO THE SYLLABUS 2020-21

1. Revision to Basics of Python (XI-IP)

Unit 1: Data Handling using Pandas and Data Visualization

Data Handling using Pandas -I

1. Introduction to Python libraries
2. Series
3. Data Frames
4. Importing/Exporting Data between CSV files and Data Frames

Data handling using Pandas – II

1. Descriptive Statistics
2. DataFrame operations (Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting)
3. Importing/Exporting Data between MySQL database and Pandas
4. Data Visualization

Unit 2: Database Query using SQL

1. Math functions 
2. Text functions
3. Date Functions
4. Aggregate Functions
5. Querying and manipulating data using Group by, Having, Order by
6. Operations on Relations (Union, Intersection, Minus, Cartesian Product, JOIN)

Unit 3: Introduction to Computer Networks

1. Introduction to networks
2. Types of network (LAN, MAN, WAN)
3. Network Devices (modem, hub, switch, repeater, router, gateway)
4. Network Topologies (Star, Bus, Tree, Mesh)
5. Introduction to Internet, URL, WWW and its applications
6. Website
7. Web Browsers

Unit 4: Societal Impacts

1. E-waste