12 INFORMATICS PRACTICES VIDEO LINKS

S.NO.TOPIC STUDY MATERIAL/VIDEO

HOLIDAY HW
1 REVISION(LIST, DICTIONARY, etc.) https://www.youtube.com/playlist?list=PLEpRPHYH815qLZx9u-eTrqYqyz7sknrCo
DIFFERENCE BETWEEN LIST AND DICTIONARY
2 PYTHON PANDAS SERIES https://www.youtube.com/watch?v=7XXDCxkMQfs
What is PYTHON PANDAS SERIES
3 HOW TO RUN PYTHON PANDAS IN MOBILE VS LAPTOP https://youtu.be/boad8P8QLMw
HOW TO RUN PYTHON PANDAS IN MOBILE VS LAPTOP
4 ACCESSING ELEMENTS IN SERIES https://youtu.be/8-wc7IvHITM
How to ACCESSING ELEMENTS IN SERIES
5 NCERT BOOK PANDAS SERIES https://youtu.be/iS55b6lIy4E
What is PANDAS SERIES? Write syntax
6 MATHEMATICAL OPERATION IN SERIES https://youtu.be/RPlMULtQ4Ng
Explain different MATHEMATICAL OPERATION IN SERIES
7 SLICING, SELECTION, ACCESSING IN SERIES https://youtu.be/dq40m2BUQkQ
Explain SLICING, SELECTION, ACCESSING IN SERIES
8 HEAD, TAIL, COUNT FUNCTION https://youtu.be/UK1S6AypN7E
Explain HEAD, TAIL, COUNT FUNCTION
9 SERIES ATTRIBUTES https://youtu.be/ZFI5zBR9Wco
Explain SERIES ATTRIBUTES
10 PANDAS SERIES IMPORTANT QUESTION https://youtu.be/vbFW8-6Dwoc
Write a program to create PANDAS SERIES
11 CBSE QUESTION BANK PANDAS SERIES https://youtu.be/4YTf9PRNoG0
Write output of PANDAS SERIES
12 PANDAS IMPORTANT BOARD QUESTIONS https://youtu.be/vrkKLCEzw3w
Who developed PANDAS ?
13 DATAFRAME PART 1 https://youtu.be/0c-IS70nCA0
Explain DATAFRAME .
14 DATAFRAME CREATION https://youtu.be/Z9tTND_o-1o
Write syntax for DATAFRAME CREATION
15 OPERATIONS ON DATAFRAME https://youtu.be/2QC4Wx7lF_8
Write different OPERATIONS ON DATAFRAME
16 ACCESSING DATAFRAME ELEMENTS https://youtu.be/-1YsA3IbWjw
How to ACCESS DATAFRAME ELEMENTS?
17 DATAFRAME ATTRIBUTES https://www.youtube.com/watch?v=pWj2xUSAqeM
Explain DATAFRAME ATTRIBUTES
18 DATAFRAME TO CSV https://youtu.be/CDSmAkvIZBg
Explain DATAFRAME TO CSV
19 CSV TO DATAFRAME https://youtu.be/ffEn5zN1go8
Explain CSV TO DATAFRAME
20 DATAFRAME IMPORTANT BOARD QUESTIONS https://youtu.be/XXI1jW_9yGk Write syntax to create DATAFRAME
21 Mathematical operations https://www.youtube.com/watch?v=IPSxKd6HfQo
Explain different Mathematical operations
22 Data Visualization(Matplotlib) MATPLOTLIB TUTORIALS
Explain| Data
DATAVisualization(Matplotlib)
VISUALIZATION USING PYPLOT | CLASS 12 INFORMATICS PRACTICES - YouTube
23 MYSQL IMPORTANT QUESTIONS https://youtu.be/fT2IUHODmGI
Explain MYSQL
24 NETWORKING BOARD QUESTIONS https://youtu.be/9zXFapVrftU
-
25 12 IP PRACTICAL FILE https://youtu.be/QHgK1Tt3eK4
-
26 12 IP PROJECT E-GOV https://www.youtube.com/watch?v=TqxcsSokSa4
-
27 12 IP PRACTICAL BOARD QP https://youtu.be/F5r-Ik4FRV4
-
28 CBSE SQP COMPLETE SOLUTION https://youtu.be/lwVCqYFUjms
-
29 All topics https://www.youtube.com/channel/UCOK0IlsbqY_x0kubDCOYUkA
-
30 12 IP NEW REVISED PLAYLIST https://www.youtube.com/playlist?list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt
-
31 CBSE SQP SOLVED COMPLETE SOLUTION PLAYLIST https://www.youtube.com/playlist?list=PLEpRPHYH815r1sG1swY_2RwwwTAv9QOaB
-
32 CBSE SQP SOLVED COMPLETE SOLUTION-1 https://www.youtube.com/watch?v=lwVCqYFUjms
-
33 CBSE SQP SOLVED COMPLETE SOLUTION-2 https://www.youtube.com/watch?v=GXFA-mjK6JY&list=PLEpRPHYH815r1sG1swY_2RwwwTAv9QOaB
-
34 CBSE SQP SOLVED COMPLETE SOLUTION-3 https://www.youtube.com/watch?v=XXI1jW_9yGk&list=PLEpRPHYH815r1sG1swY_2RwwwTAv9QOaB&index=3
-
35 CBSE SQP SOLVED COMPLETE SOLUTION-4 https://www.youtube.com/watch?v=fT2IUHODmGI&list=PLEpRPHYH815r1sG1swY_2RwwwTAv9QOaB&index=7
-
36 CBSE SQP SOLVED COMPLETE SOLUTION-5 https://www.youtube.com/watch?v=vrkKLCEzw3w
-
37 CBSE SQP SOLVED COMPLETE SOLUTION-6 -
38 PRACTICAL FILE https://www.youtube.com/playlist?list=PLEpRPHYH815qbtc1VhPtmywRwm93eYGnu
-
39 PROJECT https://www.youtube.com/playlist?list=PLEpRPHYH815pvHmM0wYjiE4OpUfW1iOK0
-
40 Lists https://www.youtube.com/watch?v=Bj3I5QiGCJ0&t=13s
-
41 Data Handling using Pandas PANDAS part1 - YouTube
-
42 Data structures in Pandas https://www.youtube.com/watch?v=Mt2e0Rs5Mas&t=108s
-
43 Series-Creation of Series https://www.youtube.com/watch?v=8F45svjEAc4
-
44 Python Pandas -
https://www.youtube.com/watch?v=7XXDCxkMQfs
45 Create series using List,Dictionary and ndarrays https://www.youtube.com/watch?v=boad8P8QLMw
-
46 Head and tail function https://www.youtube.com/watch?v=LZX1D39cp2s
-
47 Selection, Indexing and Slicing. https://www.youtube.com/watch?v=-BlV37OFEuk
-
48 Dataframe https://www.youtube.com/watch?v=cjKpCXviZaM
-
49 Data Frames-creation(menu driven) https://www.youtube.com/watch?v=hSMB2Zx1-tg
-
50 Dataframe slicing https://www.youtube.com/watch?v=gfRai17K6gQ
-
51 Text/CSV files https://www.youtube.com/watch?v=MaN-yCv0sxU
-
52 Mathematical operations https://www.youtube.com/watch?v=IPSxKd6HfQo
-
53 Importing/Exporting Data between CSV files andhttps://www.youtube.com/watch?v=8CBZNlxEHcc
Data Frames. -
54 Descriptive Statistics: max, min, count, sum, mean,
https://www.youtube.com/watch?v=F5b1mVGncts&t=87s
median, mode,-
55 prac.-3 largest no https://www.youtube.com/watch?v=4Vn1NM-4YAQ
-
56 Data Visualization(Matplotlib) MATPLOTLIB TUTORIALS
- | DATA VISUALIZATION USING PYPLOT | CLASS 12 INFORMATICS PRACTICES - YouTube
57 Database Query using SQL https://www.youtube.com/watch?v=nwZfQDfd9KY&t=7s
-
58 Interface of Python with MySQL https://www.youtube.com/watch?v=8RuoN5uTbqY&t=13s
-
59 MYSQL https://www.youtube.com/watch?v=nwZfQDfd9KY&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=5&t=8
-
60 MYSQL BOARD QUESTIONS 2020 https://www.youtube.com/watch?v=InbHxeVkEvM&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=24
-
61 COMPUTER NETWORKS(BOARD QUESTIONS 2020) https://www.youtube.com/watch?v=9zXFapVrftU&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=31
-
62 COMPUTER NETWORKS https://www.youtube.com/watch?v=vbcxKYwUgtQ&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=20
-
63 SOCIETY, LAW AND ETHICS https://www.youtube.com/watch?v=SB9qsAVBzXE&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=29
-
64 CBSE 12 IP PRACTICALS https://www.youtube.com/playlist?list=PLEpRPHYH815qbtc1VhPtmywRwm93eYGnu
-
65 Create series using Dictionary and ndarrays https://www.youtube.com/watch?v=Ydj_reCaFRI&t=16s
-
66 prac.-3 largest no https://www.youtube.com/watch?v=4Vn1NM-4YAQ
-
67 CBSE SQP SOLVED PART A SECTION 1(1 MARK) https://www.youtube.com/watch?v=0KgJnfzj0R4&t=35s
-
68 CBSE SQP SOLVED PART A SECTION 2(CASE STUDY)https://www.youtube.com/watch?v=jjmA6zFErdE&t=7s
-
69 CBSE SQP SOLVED PART B SECTION 3(2 MARK) https://www.youtube.com/watch?v=Is2Wz836PQ8
-
70 CBSE SQP SOLVED PART B SECTION 4(3 MARK) https://www.youtube.com/watch?v=k3M-fJtXK5A
-
71 CBSE SQP SOLVED PART B SECTION 5(5 MARK) https://www.youtube.com/watch?v=DAupdAuzG3k
-
72 MYSQL PLAYLIST https://www.youtube.com/playlist?list=PLEpRPHYH815rzyUQ2c7qhHo6vF4JY1vtk
-
73 MYSQL IN MOBILE https://www.youtube.com/watch?v=pMajGPgoN4w&list=PLEpRPHYH815rzyUQ2c7qhHo6vF4JY1vtk&index=1
-
74 DATABASE CONCEPTS https://www.youtube.com/watch?v=nwZfQDfd9KY&list=PLEpRPHYH815rzyUQ2c7qhHo6vF4JY1vtk&index=2&t=25s
-
75 TUPLE,ATTRIBUTE,DEGREE,CARDINALITY https://www.youtube.com/watch?v=uksuLKicZ6A
-
76 KEYS(PRIMARY,CANDIDATE,ALTERNATE,FOREIGN https://www.youtube.com/watch?v=ausxAEmLY6w
KEY) -
77 DATA TYPES-char,varchar,int,float,date https://youtu.be/wJQKCHI1OVA
-
78 DDL-CREATE, DROP, ALTER https://www.youtube.com/watch?v=nwZfQDfd9KY&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=5&t=8
-
79 ARTITHMETIC,LOGICAL,RELATIONAL OPERATORS, https://www.youtube.com/watch?v=BV3bblCFM6w
-
80 CREATE TABLE,SHOW TABLES,DESCRIBE,ALTER,DROPhttps://www.youtube.com/watch?v=InbHxeVkEvM&list=PLEpRPHYH815r6X3eyOc4YmfMQ_HkaWnZt&index=24
-
81 MYSQL-PYTHON CONNECTIVITY(JUPYTER) https://www.youtube.com/watch?v=_ZHPQ_FxKzU&list=PLEpRPHYH815rzyUQ2c7qhHo6vF4JY1vtk&index=21&t=23
-
82 CASE BASED QP MYSQL https://www.youtube.com/watch?v=Gb3mRtmcue8
-
83 MYSQL PRACTICAL EXAM PRESENTATION https://youtu.be/j4oxv9HhSgQ
-
84 CASE BASED QP MYSQL https://youtu.be/z0f6LhhZd6U
-
85 MYSQL TERM 2 QP SOLVED https://youtu.be/nmCsCmDni5w
-
86 MYSQL PRACTICAL FILE https://youtu.be/o-BHkMyO8Ng
-
87 MYSQL PRACTICAL LIST https://youtu.be/VEZBSBemuBs
-
88 Computer Networks PLAYLIST https://www.youtube.com/playlist?list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6
-
89 TERM 2 COMPUTER NETWORK https://youtu.be/t1JYFvtC-Uc
-
90 Computer Networks https://www.youtube.com/watch?v=vbcxKYwUgtQ&list=PLEpRPHYH815qqa9us8L9DVOKyVf1zLEih&index=22
-
91 Transmission media: Wired communication media https://www.youtube.com/watch?v=mLFVgmJxKq8&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=4&t=6s
(Twisted pair cable,-Co-axial cable, Fiber-optic cable),
92 Network topologies/networking topologies (Bus, Star, Tree)
https://www.youtube.com/watch?v=2TEhSnOAOVo&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=3&t=463s
-
93 Network types/ types of networks (PAN, LAN, MAN,https://www.youtube.com/watch?v=snIUMMwa94U&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=6
WAN), -
94 Introduction to networks, Types of network: LAN, MAN, WAN.
https://www.youtube.com/watch?v=snIUMMwa94U&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=6
-
95 Network Devices: modem, hub, switch, repeater, router, gateway.
https://www.youtube.com/watch?v=yaHcZf5PiVQ&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=5&t=3s
-
96 Network Topologies: Star, Bus, Tree, Mesh. https://www.youtube.com/watch?v=2TEhSnOAOVo&list=PLEpRPHYH815oEClo5ADqNZbv-akBd3OA6&index=3&t=463s
-
INFORMATICS PRACTICES CLASS 12 CBSE CURRICULUM
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 ndarray, 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 add ( insert /append
Importing/Exporting Data between CSV files and Data Frames. (for practicals only)
Data handling using Pandas – II
Descriptive Statistics: max, min, count, sum, mean, median, mode, quartile, Standard deviation, variance.
Data Frame operations: Aggregation, group by, Sorting, Deleting and Renaming Index, Pivoting.
Handling missing values – dropping and filling.
Importing/Exporting Data between MySQL database and Pandas.
Data Visualization : Purpose of plotting, drawing and saving of plots using Matplotlib (line plot, bar graph, histogram, pie chart, frequency polygon, box plot and scatter plot).
Customizing plots: color, style (dashed, dotted), width; 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.
Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN (Cartesian Join, Equi Join, Natural Join)
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 (FO
E-waste: hazards and management.
Awareness about health concerns related to the usage of technology.
 and columns: add add ( insert /append) , select, delete (drop column and row), rename, Head and Tail functions, indexing using labels, Boolean indexing; joining, merging and concatenation

ncy polygon, box plot and scatter plot).

RTRIM (), TRIM ().

ght, free and open source software (FOSS), cybercrime and cyber laws, hacking, phishing, cyber bullying, overview of Indian IT Act.
g; joining, merging and concatenation of data frames.