# Informatics Practices Commerce (English Medium) Class 12 CBSE Syllabus 2023-24

CBSE Syllabus 2023-24 Class 12: The CBSE Class 12 Informatics Practices Syllabus for the examination year 2023-24 has been released by the Central Board of Secondary Education, CBSE. The board will hold the final examination at the end of the year following the annual assessment scheme, which has led to the release of the syllabus. The 2023-24 CBSE Class 12 Informatics Practices Board Exam will entirely be based on the most recent syllabus. Therefore, students must thoroughly understand the new CBSE syllabus to prepare for their annual exam properly.

The detailed CBSE Class 12 Informatics Practices Syllabus for 2023-24 is below.

## CBSE Class 12 Informatics Practices Revised Syllabus

CBSE Class 12 Informatics Practices and their Unit wise marks distribution

## Syllabus

1 Querying and SQL Functions
• Introduction of Database Query Using SQL
• The following four relations:
1. Inventory
2. Customer
3. Sale
4. Employee
• Functions in SQL
• Single Row Functions
1. Math/ Numeric Functions: POWER(), ROUND(), MOD().
2. String Functions/ Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().
3. Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().
• Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT
• GROUP BY Clause in SQL
• Querying and manipulating data using Group by, Having, Order by.
• Operations on Relations
• UNION (∪)
• INTERSECT (∩)
• MINUS (-)
• Cartesian Product (X)
• Using Two Relations in Query
• Cartesian product on two tables
• JOIN on two tables : equi-join and natural join
2 Data Handling using Pandas - I
• Introduction to Python Libraries
• NumPy, Pandas and Matplotlib
• Installing Pandas
• Data Structure in Pandas - Series and DataFrame
• A Series
• Creation of Series
(A) Creation of Series from Scalar Values
(B) Creation of Series from NumPy Arrays
(C) Creation of Series from Dictionary
• Accessing Elements of a Series
(A) Indexing
(B) Slicing
(C) Selection
• Attributes of Series
• Methods of Series: Head and Tail functions
• Mathematical Operations on Series
(B) Subtraction of two Series
(C) Multiplication of two Series
(D) Division of two Series
• DataFrame
• DataFrame
• Creation of DataFrame
(i) Creation of an empty DataFrame
(ii) Creation of DataFrame from NumPy ndarrays
(iii) Creation of DataFrame from List of Dictionaries
(iv) Creation of DataFrame from Dictionary of Lists
(v) Creation of DataFrame from Series
(vi) Creation of DataFrame from Dictionary of Series
• Operations on rows and columns in DataFrames
(i) Adding a New Column to a DataFrame
(ii) Adding a New Row to a DataFrame
(iii) Selecting Rows or Columns from a DataFrame
(iv) Deleting Rows or Columns from a DataFrame
(v) Renaming Row Labels of a DataFrame
(vi) Renaming Column Labels of a DataFrame
• Accessing DataFrames Element through Indexing
(i) Label Based Indexing
(ii) Boolean Indexing
• Accessing DataFrames Element through Slicing
i) Filtering Rows in DataFrames
• Joining, Merging and Concatenation of DataFrames
i) Joining
• Attributes of DataFrames
• Styling and formatting data
• Importing and Exporting Data between CSV Files and DataFrames
• Importing a CSV file to a DataFrame
• Exporting a DataFrame to a CSV file
• Pandas Series Vs NumPy ndarray
3 Data Handling using Pandas - II
• Introduction of Data Handling Using Pandas – II
• Case Study
• Descriptive Statistics
• Descriptive Statistics
1. Calculating Maximum Values
2. Calculating Minimum Values
3. Calculating Sum of Values
4. Calculating Number of Values
5. Calculating Mean
6. Calculating Median
7. Calculating Mode
8. Calculating Quartile
9. Calculating Variance
10. Calculating Standard Deviation
• Data Aggregations
• Sorting a DataFrame
• GROUP BY Functions
• Altering the Index
• Other DataFrame Operations
• Reshaping Data
(A) Pivot
(B) Pivoting by Multiple Columns
(C) Pivot Table
• Handling Missing Values
• Checking Missing Values
• Dropping Missing Values
• Estimating Missing Values
• Import and Export of Data between Pandas and MySQL
• Importing Data from MySQL to Pandas
• Exporting Data from Pandas to MySQL
4 Plotting Data using Matplotlib
• Introduction of Plotting Data Using Matplotlib
• Plotting Using Matplotlib
• Customisation of Plots
• Marker
• Colour
• Linewidth and Line Style (Dashed, dotted)
• Width
• Add label, title, and legend in plots
• The Pandas Plot Function (Pandas Visualisation)
• Plotting a Line chart
• Plotting Bar Chart
• Plotting Histogram
• Plotting Scatter Chart
• Plotting Quartiles and Box plot
• Plotting Pie Chart
5 Internet and Web
• Introduction to Computer Networks
• Types of Computer Networks
1. Personal Area Network (PAN)
2. Local Area Network (LAN)
3. Metropolitan Area Network (MAN)
4. Wide Area Network (WAN)
5. Wired/ wireless communication, Wi-Fi, Bluetooth, cloud computers
• Network Devices
• Modem
• Ethernet Card
• RJ45
• Repeater
• Hub
• Switch
• Connector
• Router
• Gateway
• Wifi Card
• Networking Topologies
1. Mesh Topology
2. Ring Topology
3. Bus Topology
4. Star Topology
5. Tree or Hybrid Topology
• Internet
• Applications of Internet
• The World Wide Web (WWW)
• Electronic mail (Email)
• Chat
• Voice Over Internet Protocol (VoIP)
• Website
• Purpose of a Website
• Web Page
• Static and Dynamic Web Pages
• Web Servers
• Website Hosting
• Web hosting
• Web Hosting
• Types of Web hosting
1. Shared hosting
2. Free hosting
3. Dedicated hosting
• Browsers
• Browser Settings
6 Societal Impacts
• Introduction of Societal Impacts
• Digital Footprints
• Digital Society and Netizen
• Etiquettes for Net surfing and for communicating through social media
• Net Etiquettes
(A) Be Ethical
(B) Be Respectful
(C) Be Responsible
• Communication Etiquettes
(A) Be Precise
(B) Be Polite
(C) Be Credible
• Social Media Etiquettes
(A) Be Secure
(B) Be Reliable
• Data Protection
• Intellectual Property Right
2. Patent
• Software Licensing
• Violation of Intellectual Property Right (IPR)
1. Plagiarism
• Public Access and Open Source Software
• Creative Commons
• Cyber Crimes
• Cyber Crime
1. Hacking
2. Phishing and Fraud Emails
(A) Identity Theft
3. Ransomware
4. Combatting and Preventing Cyber Crime
• Indian Information Technology Act (IT Act)
• E-waste: Hazards and Management
• Impact of e-waste on the environment
• Impact of e-waste on humans
• Management of e-waste: Reduce, Reuse, Recycle
• E-waste Management in India
• Impact on Health
• Awareness about health concerns related to the usage of technology like effect on eyesight, physiological issues, and ergonomic aspects.
7 Project Based Learning
• Introduction of Project Based Learning
• Approaches for Solving Projects
• Teamwork
• Components of Teamwork
1. Communicate with others
2. Listen to others
3. Share with others
4. Respect for others
5. Help others
6. Participate
• Project Description

#### Textbook SolutionsVIEW ALL [1]

• 1
more
Textbook Solutions For All Subjects