DOWNLOADED FROM WWW.TUTORIALAICSIP.

COM
SYLLABUS BREAK UP FOR 2023-2024
SUBJECT :INFORMATICS PRACTICES CLASS : XII SUBJECT COORDINATOR : _____________________

PRACTICALS/
PT DURATION UNIT/CHAPTERS PROJECTS
Working Days

PERIODIC TEST - I APRIL Unit I – Data Programs based on 21

Series
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

Page 1 of 5
 DOWNLOADED FROM WWW.TUTORIALAICSIP.COM
SYLLABUS BREAK UP FOR 2023-2024
SUBJECT :INFORMATICS PRACTICES CLASS : XII SUBJECT COORDINATOR : _____________________
Slicing
Unit I – Data
handling using
pandas – I
Data Frames:
creation - from
dictionary of Series, list
Programs based on
JUNE
of dictionaries, DataFrames
Text/CSV files; display;
iteration;
17
Operations on rows
and columns: add,
select, delete, rename;

Unit I – Data handling using pandas – I

Data Frames:
Programs based Dataframes 25
JULY
Head and Tail functions; Indexing using Labels, Boolean Indexing; and CSV PT 1
Importing/Exporting Data between CSV files and Data Frames

Page 2 of 5
 DOWNLOADED FROM WWW.TUTORIALAICSIP.COM
SYLLABUS BREAK UP FOR 2023-2024
SUBJECT :INFORMATICS PRACTICES CLASS : XII SUBJECT COORDINATOR : _____________________
UNIT/CHAPTERS Working
PT DURATION PRACTICALS/PROJECTS
Days
Data Visualization:
Purpose of plotting; drawing and saving following types of plots using
Programs based on
AUGUST Matplotlib – line plot, bar graph, histogram Data Visualization 23
Customizing plots: Project Synopsis Basics

adding label, title, and legend in plots

Unit II: Database Query using SQL
Math functions:
PERIO POWER (), ROUND (), MOD ()
DIC
Text functions:
TEST -
II UCASE ()/UPPER (), LCASE ()/LOWER (),
(MID
MID ()/ SUBSTRING() /SUBSTR (),
TERM) MySQL Queries
SEPTEMBE LENGTH (), LEFT (), RIGHT (), Project Documentations 20
R
INSTR (), LTRIM (), RTRIM (), TRIM () Begins

Unit III: 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

Page 3 of 5
 DOWNLOADED FROM WWW.TUTORIALAICSIP.COM
SYLLABUS BREAK UP FOR 2023-2024
SUBJECT :INFORMATICS PRACTICES CLASS : XII SUBJECT COORDINATOR : _____________________
Working
PT DURATION UNIT/CHAPTERS PRACTICALS/PROJECTS
Days

- 15-13= 2
OCTOBER REVISION FOR PT 2
PT 2
Unit II: Database Query using SQL
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY MySQL Queries with
(), DAYNAME (), Functions
NOVEMBER 8
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); COUNT (*).
Querying and manipulating data using Group by, Having, Order by. Project work documentation
Working with two tables using equi-join
Unit III: Introduction to Computer Networks
Introduction to Internet, URL, WWW, and its applications- Web, email,
PT-3 Chat, VoIP.
/(PRE- Website: Introduction, difference between a website and webpage, static
BOARD vs dynamic web page, web server and hosting of a website.
) Unit III : Introduction to computer networks MySQL Queries with
Web Browsers: Introduction, commonly used browsers, browser settings,
DECEMBER Functions 24
add-ons and plug-ins, cookies.
Unit IV: Societal Impacts: Digital footprint, net and communication Project work coding starts
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

Page 4 of 5
 DOWNLOADED FROM WWW.TUTORIALAICSIP.COM
SYLLABUS BREAK UP FOR 2023-2024
SUBJECT :INFORMATICS PRACTICES CLASS : XII SUBJECT COORDINATOR : _____________________
PRACTICALS/PROJECTS Working
PT DURATION UNIT/CHAPTERS Days
Thorough Revision for the Final Examinations

Note :

1. The manner of taking the above mentioned practical and project

PRE-
JANUARY
BOARD 23
2024 word may differ as per the subject teacher.
S
2. The syllabus for the Periodic Test will be discussed prior to all

the respective examinations as usual.

HEAD OF DEPARTMENT: ______________________

Subject Co-ordinators:
1. Sanjay Parmar: _________________

2. _______________________________

Page 5 of 5