CLASS 12 INFORMATICS PRACTICES

TOPICS

UNIT - 1: Data Handling using Pandas

1. Introduction to Python libraries
1. Pandas
2. Matplotlib
2. Data structures in Pandas - Series and Data Frames.
1. Series
1. Creation of Series from – ndarray, dictionary, scalar value
• Series - index Parameter
• Series - dtype Parameter
2. Mathematical operations on Series
3. Head and Tail functions
4. Accessing Series Elements
1. Accessing Single Elements
2. Accessing Series Slices
5. Modifying Series Elements
6. Series Attributes
7. Series Methods
2. Data Frames
1. Creation - from the dictionary of Series, list of dictionaries, Text/CSV files
2. Display the DataFrame
3. Iteration over DataFrame
4. Operations on rows and columns of DataFrame - add, select, delete, rename
5. Head and Tail functions
6. Indexing using Labels
7. Boolean Indexing
8. Importing/Exporting Data between CSV files and Data Frames
9. Dataframe Methods
3. NaN Values in Python Pandas
3. Data Visualization
1. Introduction - Purpose of plotting
2. Line Plot
3. Bar graph
4. Histogram
5. Customizing plots: adding label, title, and legend in plots
6. subplot() Function

UNIT - 2: Database Query using SQL

1. Math functions
2. Text functions
3. Date Functions
4. Aggregate Functions
5. Group by, Having
6. Order by

UNIT - 3: Introduction to Computer Network

1. Computer Network LAN, MAN, WAN
2. Network Devices
3. Network Topology
4. Introduction to the Internet
5. website Introduction
6. Web Browser

UNIT - 5: Societal Impacts

1. Digital Footprint
2. Net and communication etiquette
3. Data protection
4. intellectual Property Rights (IPR)
5. plagiarism
6. free and open-source software (FOSS),
7. cybercrime and cyber laws
8. hacking, phishing, cyberbullying
9. overview of the Indian IT Act.
10. E-waste: hazards and management.

Practical List 2020-21

Practical List Download