UNIT - 2: Computational Thinking and Programming - 1

1. XII IP Term-Wise Syllabus 2021-22

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

1. XII CS Term-Wise Syllabus 2021-22 (CBSE)

UNIT - 1 Computational Thinking and Programming-2

INTRODUCTION TO PYTHON FUNCTIONS

1.  Introduction to python functions
2.  def, return, advantages of functions
3.  Parameter Passing, Types of Arguments/Parameters
4.  Types of Formal Arguments (Positional , Default, Keyworded Arguments)
5.  Types of Formal Arguments (Variable length Argument)
6.  Multiple argument types together
7.  Nested Functions in Python
8.  Polymorphism in Python Functions
9.  Variable Scope (Global & Local Variables)
10.  Variable Memory assignment in Python
11.  Mutability & Immutability of Argument/Parameter

PYTHON MODULE, PACKAGES, LIBRARIES (Not in Term-Wise Syllabus)

1.  MODULES, PACKAGES, LIBRARIES & FRAMEWORK
2.  Creating your Own Modules and Packages in Python
3.  help(), dir() Functions in Python || Docstring in Module
4.  What is Namespace for an Object in Python
5.  Different Types Of Import Statements in Python

FILE HANDLING

1.  File Handling Introduction
2.  Absolute Path, Relative Path
3.  read, write, append in a file
4.  All file Opening Modes introduction
5.  encode() and decode() string functions in python
6.  read modes [r,r+,rb,rb+]
7.  write modes [w,w+,wb,wb+]
8.  append modes [a,a+,ab,ab+]
9.  File Object Attributes and Method Introduction
10.  File Object Methods
11.  read, readline, readlines()
12.  write(), writelines()
13.  seek(), tell()
14.  Reading a file Character by Character
15.  Reading a file Word by Word
16.  Reading a file Line by Line
17.  python standard streams - stdin,stdout,stderr
18.  Pickle Module in Python (load(), dump())
19.  Search and Update in Python Binary File and Pickle File
20.  CSV file handling (reader, writer)

1.  Recursion in Python - Types, Base Case, Recursive Case
2.  How to Solve Recursive Problems
3.  Recursion Example-1 (Sum of First N Natural Numbers)
4.  Recursion Example-2 (How to Find Factorial using Recursion)
5.  Recursion Example-3 (Fibonacci Series in Python) 
6.  Recursion Example-4 (Binary Search in Python)

IDEA OF ALGORITHMIC EFFICIENCY (Not in Term-Wise Syllabus)