# Comprehensive guide Deleted Portion IP class 12 term wise syllabus 2021-22

In this article, we will discuss Deleted Portion IP class 12 term wise syllabus 2021-22. CBSE has released a term-wise syllabus for all subjects recently. In this term-wise syllabus, few topics were removed by CBSE. So lets we discuss!

Topics Covered

## Deleted Portion IP class 12 term wise syllabus 2021-22

We will see the Deleted Portion IP class 12 term wise syllabus 2021-22 according to topics and units. Informatics Practices is one of the subjects offered by CBSE. Here we go!

## Deleted portion from Data Handling Using Pandas I

In this part of term wise syllabus of class 12 Informatics Practices following topics remained the same:

• Introduction to Python libraries-
• Pandas
• Matplotlib.
• Data structures in Pandas
• Series and data frames
• Series:
• Creation of series from dictionary, scalar value
• mathematical operations
• series attributes
• selection, indexing and slicing.
• Data Frames:
• creation of data frames from dictionary of series, list of dictionaries,
• text/CSV files
• display
• iteration
• Operations on rows and columns:
• select
• delete (drop column and row)
• rename
• indexing using labels
• Boolean indexing.

The deleted topics from this section are:

• Joining, merging and concatenation of data frames
• Importing/Exporting Data Between CSV files and dataframes

## Deleted portion from Data Handling Using Pandas II

This portion is entirely removed from the term-wise syllabus. The deleted concepts are as following:

• Data Handling using Pandas – II
• Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance
• Data Frame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivotin
• Handling missing values â€“ dropping and filling.
• Importing/Exporting Data between MySQL database and Pandas

## Deleted portion from Data Visualization

This portion remained the same in term wise syllabus for class 12 IP for session 2021-22. Nothing has been deleted from this section. the topics are as following:

• Purpose of plotting
• Drawing and saving of plots using Matplotlib (line plot, bar graph, histogram)
• Customizing plots: adding label, title, and legend in plots

## Deleted portion from Societal Impacts

This portion also remained the same as earlier in term wise syllabus for class 12 IP. Nothing has been deleted from this section. It needs to be completed in Term I. the topics are:

• Digital footprint
• Net and communication etiquettes
• Data protection
• Intellectual property rights (IPR) plagiarism
• 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.

In the next section of Deleted Portion IP class 12 term wise syllabus 2021-22, we will discuss the deleted portion from the term wise syllabus of Class 12 IP for Term II.

## Deleted Portion from Database Query using SQL

From this section, the following topics remained the same in the term wise syllabus IP class 12 for 2021-22. The topcis are:

• 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

The following topics are deleted from the syllabus:

• Operations on Relations
• Union
• Intersection
• Minus
• Cartesian Product
• JOIN (Cartesian Join, Equi Join, Natural Join)

In next section of Deleted Portion IP class 12 term wise syllabus 2021-22 we will talk about deleted portion from the next unit.

## Deleted portion from Introduction to Computer networks

This section has no changes in term wise syllabus. it remains intact as given earlier.

• 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

Watch this video for more understanding about term wise syllabus for 2021-22.

If you are looking for comprehensive notes, questions, and a practical guide, you landed on the perfect website. Follow the below-given link for the same:

I hope you are clear with the Deleted Portion IP class 12 term wise syllabus 2021-22. If you have any doubts or queries related to Deleted Portion IP class 12 term wise syllabus 2021-22, feel free to type in the comment section.