Class 12 informatics Practices Video Lectures

CBSE SYLLABUS

1. XII IP Term-Wise Syllabus 2021-22

UNIT - 1 (Data Handling using Pandas and Data Visualization)

Data Handling using Pandas -I

Pandas Series

1. Pandas Introduction, Pandas Data Structure, Creating Series Object
2.  Create Series Object
3.  Creating Series Object (index parameter)
4.  dtype parameter, Creating Series with numpy Data types
5.  Series Attributes
6.  Series Methods [List of Methods][Video]
7.  NaN (Not a Number) in Python Pandas
8.  Python Pandas Series with Duplicate Data Labels/Indexes
9.  Accessing Elements of Series (Accessing Individual Element )
10.  Extracting Pandas Series Slices
11.  Operations on Series Data Structure

Pandas DataFrame

1.  Introduction to DataFrame
2.  DataFrame creation (List of Lists)
3.  DataFrame creation (dict of ndarray/list/series. list of dict)
4.  Variable Memory assignment in Python
5.  Creating DataFrame using CSV
6.  DataFrame Attributes
7.  Accessing DataFrame Columns
8.  Finding Slices of DataFrame || loc , iloc Explained
9.  Add/Modify/Delete Column & Rows from DataFrame
10.  DataFrame Methods [List of Methods] [Video]
11.  Iterating over a DataFrame
12.  Column/Index Rename
13.  Operations on DatFrame
14.  concat() method in Pandas (Not in Term Wise Syllabus)
15.  join() method in Pandas (Not in Term Wise Syllabus)
16.  merge() method in Pandas (Not in Term Wise Syllabus)
17.  concat() vs join() vs merge() (Not in Term Wise Syllabus)

Data Visualization

1. Introduction
2. Line Chart
3. Bar Chart
4. Histogram
5. Customizing the plot
6. subplot() Function

Unit 4: Societal Impacts

1. Digital Footprints
2. Net communication etiquettes
3. Intellectual Property Rights (Copyrights, Patents, Trademarks, Trade secrets)
4. Plagiarism
5. FOSS (Free and Open Source Software)
6. Cyber Crime (Phishing, Hacking, Cyber Bullying)
7. Cyber Law (IT Act 2000)

UNIT - 2 Database Query using SQL

1. How to install MySQL on Windows 10
2. MySQL Math Functions
3. MySQL Text Functions 
4. MySQL Date Functions (NOW, DATE, MONTH, MONTHNAME, YEAR, DAY, DAYNAME)
   
5. MySQL Aggregate Functions (MAX,MIN,SUM,AVG,COUNT)
6. MySQL GROUP BY and HAVING
7. MySQL ORDER BY

Unit 3: Introduction to Computer Networks

1. Introduction to COMPUTER NETWORK | PAN, LAN, MAN, WAN
2. Networking Devices (Modem, Hub, Switch, Bridge, Router, Gateway etc.)
3. Networking Topologies (BUS, RING, STAR, MESH, TREE, HYBRID)
4. Networking Protocols(TCP/IP Model, IP, FTP, PPP, HTTP, SMTP, POP3/ IMAP, TelNet)
5. Introduction to Internet and Its History
6. WWW (World Wide Web)
7. URL (Uniform Resource Locator)
8. Website, Webpage (Static vs Dynamic)
9. Web browser ad-ons, plug-ins, extensions