CBSE Class 12 Informatics Practices Syllabus 2021-22 For Term 1 & Term 2: Informatics Practices is the study of computer terminologies and operation handling. With the latest CBSE Class 12 Informatics Practices Syllabus, you will get to know the chapters and concepts to be covered in all topics. You will also have an in-depth concept in every topic of Class 12 Informatics Practices to score better marks CBSE Class 12 Board exam.
CBSE Class 12 Informatics Practices Syllabus For Term 1 & Term 2 2021-22
To prepare the right way for Informatics Practices class 12 board exam, you must have the latest Class 12 Syllabus along with books and other study materials.
You already know that CBSE updates the Class 12 Syllabus every year to provide the most updated curriculum to students. You can check and download the late st CBSE Informatics Practices Syllabus and Exam Pattern from below.
Download 12th Informatics Practices Latest Syllabus For Term 1 & Term 2 PDF
CBSE Class 12 Informatics Practices Marks Distribution 2021-22
|
Unit No |
Unit Name |
Marks |
|
1 |
Data Handling using Pandas and Data Visualization |
30 |
|
2 |
Database Query using SQL |
25 |
|
3 |
Introduction to Computer Networks |
7 |
|
4 |
Societal Impacts |
8 |
|
Project |
– |
|
|
Practical |
30 |
|
|
Total |
100 |
Detailed CBSE Class 12 Informatics Practices Syllabus For Term 1 & Mark Distribution 2021-22
The theory syllabus for Class 12 Informatics Practices Term 1 for the academic year 2021-22, as well as the mark distribution for each unit. The marking scheme and time duration for each unit are also included in CBSE 12th Informatics Practices Term 1 Syllabus.
CBSE Syllabus For Class 12 Informatics Practices Term 1 2021-22
Here you can check CBSE Class 12 Informatics Practices Syllabus For Term 1 2021-22.
| Unit 1:Data Handling using Pandas and Data Visualization Data Handling using Pandas -I |
|
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, head and tail functions; 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: add ( insert /append) , select, delete (drop column and row), rename, Head and Tail functions, indexing using labels, Boolean indexing.
|
|
Data Visualization
|
|
Data Visualization : Purpose of plotting, drawing and saving of plots using Matplotlib (line plot, bar graph, histogram). Customizing plots:; adding label, title, and legend in plots.
|
| 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 Awareness about health concerns related to the usage of technology.
|
CBSE Class 12 Informatics Practices Mark Distribution For Term 1 2021-22
Here you can check CBSE Class 12 Informatics Practices Mark Distribution For Term 1 2021-22.
|
Unit No |
Unit Name |
Marks |
|
1 |
Data Handling using Pandas and Data Visualization |
25 |
|
4 |
Societal Impacts |
10 |
|
Total |
35 |
CBSE Class 12 Informatics Practices Syllabus For Pratical Term 1 2021-22
Here you can check CBSE Class 12 Informatics Practices Syllabus For Pratical Term 1 2021-22.
| Data Handling |
|
Create a panda’s series from a dictionary of values and a ndarray
|
|
Given a Series, print all the elements that are above the 75th
|
|
Create a Data Frame quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by the category and print the total expenditure per category.
|
|
Create a data frame for examination result and display row labels, column labels data types of each column and the dimensions
|
|
Filter out rows based on different criteria such as duplicate
|
|
Importing and exporting data between pandas and CSV file
|
| Visualization |
|
Given the school result data, analyses the performance of the students on different parameters, e.g subject wise or class wise.
|
|
For the Data frames created above, analyze, and plot appropriate charts with title and
|
|
Take data of your interest from an open source (e.g. gov.in), aggregate and summarize it. Then plot it using different plotting functions of the Matplotlib library.
|
CBSE Class 12 Informatics Practices Syllabus For Project Synopsis Term 1 2021-22
Here you can CBSE Class 12 Informatics Practices Syllabus For Project Synopsis Term 1 2021-22.
- The synopsis should cover the brief description about the project along with reasons for selection of the dataset. The learner should write the source of the dataset whether created or taken from any reliable source. The learner should write what analytics can be done on the project.
CBSE Class 12 Informatics Practices Syllabus Term 2 & Mark Distribution 2021-22
The theory syllabus for Class 12 Informatics Practices Term 2 for the academic year 2021-2022, as well as the mark distribution for each unit. The marking scheme and time duration for each unit are also included in this CBSE 12th Informatics Practices Term 2 Syllabus 2021-22.
CBSE Syllabus For Class 12 Informatics Practices Term 2 2021-22
Here you can check CBSE Class 12 Informatics Practices Syllabus For Term 2 2021-22.
|
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
|
|
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.
|
CBSE Class 12 Informatics Practices Mark Distribution For Term 2 2021-22
Here you can check CBSE Class 12 Informatics Practices Mark Distribution For Term 2 2021-22.
|
Unit No |
Unit Name |
Marks |
|
2 |
Database Query using SQL |
25 |
|
3 |
Introduction to Computer Networks |
10 |
|
|
Total |
35 |
CBSE Class 12 Informatics Practices Syllabus For Pratical Term 2 2021-22
Here you can check CBSE Class 12 Informatics Practices Syllabus For Pratical Term 2 2021-22.
|
Data Management
|
|
Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
|
|
Insert the details of a new student in the above table.
|
|
Delete the details of a student in the above table.
|
|
Use the select command to get the details of the students with marks more than 80.
|
|
Find the min, max, sum, and average of the marks in a student marks table.
|
|
Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.
|
|
Write a SQL query to order the (student ID, marks) table in descending order of the marks.
|
CBSE Class 12 Informatics Practices Syllabus For Project Work Term 2 2021-22
Here you can CBSE Class 12 Informatics Practices Syllabus For Project Work Term 2 2021-22
- The aim of the Class 12 IP Project is to create a tangible and useful IT application. The learner may identify a real-world problem by exploring the environment. e.g. Students can visit shops/business places, communities, or other organizations in their localities and enquire about the functioning of the organization, and how data are generated, stored, and managed.
- The learner can take data stored in CSV or database files and analyze using Python libraries and generate appropriate charts to visualize. If an organization is maintaining data offline, then the learner should create a database using MySQL and store the data in tables. Data can be imported in Pandas for analysis and visualization.
- Learners can use Python libraries of their choice to develop software for their school or any other social good. Learners should be sensitized to avoid plagiarism and violation of copyright issues while working on projects. Teachers should take necessary measures for this. Any resources (data, image, etc.) used in the project must be suitably referenced.
- The project can be done individually or in groups of 2 to 3 students. The project should be started by students at least 6 months before the submission deadline.
Other Important Links For CBSE Class 12 Informatics Practices
You should have the following study materials to boost your exam preparation for the Class 12 Informatics Practices exam. Click on the link to access the study materials.
- 12th Informatics Practices NCERT Solutions
- 12th Informatics Practices Sample Papers
- 12th Informatics Practices Previous year Papers
- 12th Informatics Practices Revision Notes
We have covered the detailed guide on CBSE Class 12 Informatics Practices Syllabus. Feel free to ask any questions related to CBSE Class 12 Informatics Practices in the comment section below.
FAQs on CBSE Class 12 Informatics Practices Syllabus 2022
Here are the most frequently asked quesions for CBSE Class 12 Informatics Practices Syllabus 2022.
From where can we download the CBSE Class 12 Informatics Practices Syllabus 2022?
You can download the CBSE Class 12 Informatics Practices Syllabus 2022 from the above article.
How much does it cost to do Informatics Practices Class 12 NCERT Textbook PDF download?
It is free of cost.
What is the IP Class 12 syllabus for the Practical Exam?
The CBSE Class 12 Informatics Practices Syllabus for the Practical Exam is available in the above blog.
Do we have to study Introduction to Computer Networks?
Yes. As per the latest CBSE Class 12 Informatics Practices Syllabus, you have to study Introduction to Computer Networks.
Kindly clear one doubt that in class XII IP project can students use my SQL as backend in place of CSV files
No! For More Details, Keep checking CBSE Class 12 Syllabus Related Blogs Here: https://www.kopykitab.com/blog/cbse-syllabus-for-class-12/