Informatics Practices XII Class

Data Handling:

Python Pandas

Advanced operations on Data Frames: pivoting, sorting, and aggregation

Descriptive statistics: min, max, mode, mean, count, sum, median, quartile, var

Create a histogram, and quantiles.

Function application: pipe, apply, aggregation (group by), transform, and apply map.

Reindexing, and altering labels.


1D array, 2D array

Arrays: slices, joins, and subsets

Arithmetic operations on 2D arrays

Covariance, correlation and linear regression

Plotting with Pyplot:

Plot bar graphs, histograms, frequency polygons, box plots, and scatter plots.

Unit 2: Database Query using SQL:

Math 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.

Unit 3: Introduction to Computer Networks:

Introduction to networks, Types of network: 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.

Unit 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.