CBSE Class 12 Informatics Practices Syllabus 20222-2023, Download PDF

Candidates who are in Class 12 should refer to the CBSE Class 12 Informatics Practices Syllabus 2022-2023. The curriculum is released by CBSE on its official website. However, you can find all the important details about Informatics Practices syllabus for Class 12 here at Safalta. Knowing the curriculum will help them prepare according to the guidelines of CBSE and score good marks. Most CBSE-affiliated schools prefer NCERT Syllabus as it offers a number of benefits. It explains the marks distribution, course content, project details, exam pattern, and other necessary information. We have also provided the link to download the PDF.  Read the blog to get yourself familiarized with the CBSE Class 12 Informatics Practices Syllabus 2022-2023. 

Recommended: Study for your Exams with Safalta School online. We provide Preparation materials for Classes 9-12 that can boost your preparations.

Table of Content

CBSE Class 12 Informatics Practices Syllabus 2022-2023

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Learning outcomes

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Exam Structure

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Unit-wise Details

CBSE Class 12 Informatics Practices Syllabus 2022-2023: PDF Download

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Practical Details

Recommended Topics for Practicals

 

CBSE Class 12 Informatics Practices Syllabus 2022-2023

Informatics Practices Syllabus for Class 12 CBSE is divided into 4 units, which are further explained in topics and sub-topics. The curriculum explains all the concepts, practical details, exam pattern, and other essential things included in the CBSE Class 12 Informatics Practices Syllabus. 
 

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Learning outcomes

The expected learning outcomes from Informatics Practices syllabus for Class 12 are briefed below. Let's have a look. 

• Make Series, Data frames and apply different operations.
• Imagine data using relevant graphs.
• Make SQL queries using aggregate functions.
• Import/Export data between SQL database and Pandas.
• Fetch terminology associated with networking and internet.
• Recognize internet security issues and arrange browser settings.
• Learn the influence of technology on society including gender and disability problems. 

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Exam Structure

The Exam Structure for Informatics Practices syllabus for Class 12 is tabulated below. Let's have a look and try to understand the same. 

Unit	Unit Name	Marks Distribution	Periods (Theory)	Periods (Practical)	Total Periods
1	Data Handling using Pandas and Data Visualization	25	25	25	50
2	Database Query using SQL	25	20	17	37
3	Introduction to Computer Networks	10	12	00	12
4	Societal Impacts	10	14	-	14
	Project	-	-	07	07
	Practical	30	-	-	-
	Total	100	71	59	120

 

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Unit-wise Details

As discussed above, there are four units in the Informatics Practices syllabus for Class 12, which are further divided into sub-topics. Here are the chapter details-

Unit 1: Data Handling using Pandas -I

• Introduction to Python libraries- Pandas, Matplotlib.
• Data structures in Pandas – Series and Data Frames.
• Series: Creation of Series from – ndarray, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection, Indexing and Slicing.
• Data Frames: creation – from dictionary of Series, list of dictionaries, Text/CSV files; display; iteration; Operations on rows and columns: add, select, delete, rename; Head and Tail functions; Indexing using Labels, Boolean Indexing; Importing/Exporting Data between CSV files and Data Frames.
• Data Visualization
• Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram
• Customizing plots: adding label, title, and legend in 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.

Also read:
CBSE Class 12 Philosophy Syllabus
CBSE Class 12 Psychology Syllabus
CBSE Class 12 Sociology Syllabus
CBSE Class 12 Chemistry Syllabus
CBSE Class 12 Economics
CBSE Class 12 Biology Syllabus
CBSE Class 12 Physics Syllabus
CBSE Class 12 Biotechnology Syllabus
CBSE Class 12 Accountancy Syllabus
CBSE Class 12 Business Studies Syllabus
CBSE Class 12 Geography Syllabus
CBSE Class 12 Hindi Syllabus 
CBSE Class 12 Political Science Syllabus
CBSE Class 12 History Syllabus

 

CBSE Class 12 Informatics Practices Syllabus 2022-2023: PDF Download

CBSE Class 12 Informatics Practices Syllabus 2022-2023 PDF 
 

CBSE Class 12 Informatics Practices Syllabus 2022-2023: Practical Details

• The Practical Details for Informatics Practices syllabus are explained below. Candidates should go through it to understand the project work. 
• The major goal of the class project is to make tangible and helpful IT applications.
• The students may recognize a real-world issues by analyzing the surroundings.
• The candidates can collect data stored in csv or database file and examine using Python libraries and generate suitable charts to imagine.
• If an organization is keeping data safe offline, the learner should make a database using MySQL and keep them in tabulated form. Data can be taken from Pandas for inspection and visualization.
• Students can make use of Python libraries of their selection to make software for their school or any other social good.
• Candidates should avoid plagiarism and contravention of copyright problems during the project. Teachers should take important stpes for the same. Any resources that can be any image or any form of data used in the project work must be appropriately acknowleged.
• Students can prepare the project individually or in groups of 2 to 3 students. They should start the project at least 6 months before the submission date ends. 

Marks distribution for Practical Work

Recommended Topics for Practical Work

Down below are some recommended topics for project work for Informatics Practices. 

Data Handling

• Make a panda’s series from a dictionary of values and a ndarray.
• Given a Series, print all the components which are above 75%.
• Prepare a data frame quarterly sales where each row includes the item segment, name of the item, and expenses. Group the rows by the segmentation and print the total expenses as per categorization.
• Make a data frame for examination result and show row labels, column labels data types of every column and the extents.
• Scrutinize rows based on distant parameters like duplicate rows.
• Importing and exporting data between pandas and CSV file.

Visualization

• Given the school result information, evaluate the students' performances on diverse parameters. These can be subject wise or class wise details.
• For the details created above, examine, and make suitable charts with title and legend.
• Take details of your own interest from an open source (e.g. data.gov.in), find an average and synopsize it. Then frame it using distant plotting functions of the Matplotlib library.

Data Management

• Make a student table with deatils including student id, name, and marks as descriptions. Here, the student id is the major or primary key.
• Put in the information of a new student in the above table.
• Eliminate the information of a student in the above table.
• Use the select command to get the information of the students who have score more than 80 marks.
• Look for the minimum, maximujm, total, and average marks in a student marks table.
• Search the total number of customers from every country in the table. You can use descriptions like customer ID, customer Name, and country to group them. 
• Frame a SQL query to arrange details like student ID and marks in the table. Keep the details in descending order.