CBSE Class 12 Informatics Practices Syllabus 2023 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 2023
To prepare the right way for the 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 below.
Download 12th Informatics Practices Latest Syllabus For Term 1 & Term 2 PDF
CBSE Class 12 Informatics Practices Marks Distribution 2023
|
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 2023
The theory syllabus for Class 12 Informatics Practices Term 1 for the academic year 2023, 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 2023
Here you can check CBSE Class 12 Informatics Practices Syllabus For Term 1 2023.
| 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: the creation of data frames from the dictionary of series, list of dictionaries, text/CSV files, display, and 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 plots using Matplotlib (line plot, bar graph, histogram). Customizing plots: adding labels, titles, and legends in plots.
|
| Unit 4: Societal Impacts |
|
Digital footprint, net, and communication etiquette,
|
|
Data protection, intellectual property rights (IPR), plagiarism, licensing, and copyright,
|
|
Free and open source software (FOSS),
|
|
Cybercrime and cyber laws, hacking, phishing, cyberbullying, an 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 2023
Here you can check CBSE Class 12 Informatics Practices Mark Distribution For Term 1 2023.
|
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 Practical Term 1 2023
Here you can check CBSE Class 12 Informatics Practices Syllabus For Practical Term 1 2023.
| 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 for quarterly sales where each row contains the item category, item name, and expenditure. Group the rows by category and print the total expenditure per category.
|
|
Create a data frame for examination results 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, analyze 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 titles 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 2023
Here you can CBSE Class 12 Informatics Practices Syllabus For Project Synopsis Term 1 2023.
- The synopsis should cover a brief description of the project along with reasons for the 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 2023
The theory syllabus for Class 12 Informatics Practices Term 2 for the academic year 2023, 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 2023.
CBSE Syllabus For Class 12 Informatics Practices Term 2 2023
Here you can check CBSE Class 12 Informatics Practices Syllabus For Term 2 2023.
|
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 networks: 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, the difference between a website and a 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 2023
Here you can check CBSE Class 12 Informatics Practices Mark Distribution For Term 2 2023.
|
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 Practical Term 2 2023
Here you can check CBSE Class 12 Informatics Practices Syllabus For Practical Term 2 2023.
|
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 2023
Here you can CBSE Class 12 Informatics Practices Syllabus For Project Work Term 2 2023
- 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 into 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 the necessary measures for this. Any resources (data, images, 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 2023
Here are the most frequently asked questions for CBSE Class 12 Informatics Practices Syllabus 2023.
From where can we download the CBSE Class 12 Informatics Practices Syllabus 2023?
You can download the CBSE Class 12 Informatics Practices Syllabus 2023 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/