Class 12 Computer Science Video Lectures

CBSE SYLLABUS

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)

RECURSION IN PYTHON FUNCTIONS (Not in Term-Wise Syllabus)

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)

1. Idea of Algorithmic Efficiency (Time Complexity)

DATA STRUCTURE IN PYTHON

1. Introduction (List, Stack, Queue)
2. Data Structure - List (Not in Term-Wise Syllabus)
3. Data Structure - Stack
4. Data Structure - Queue (Not in Term-Wise Syllabus)
5. Infix to Postfix Conversion
   

UNIT-2 COMPUTER NETWORK

1. Introduction to COMPUTER NETWORK | PAN, LAN, MAN, WAN
2. Networking Devices (Switch, Bridge, Router, Gateway etc.)
3. Networking Topologies (BUS, RING, STAR, MESH, TREE, HYBRID)
4. Introduction to Internet and Its History
5. WWW (World Wide Web)
6. URL (Uniform Resource Locator)
7. Website, Webpage (Static vs Dynamic)
8. Intellectual Property Rights (Copyrights, Patents, Trademarks, Trade secrets)
9. Cyber Crime (Phishing, Hacking, Cyber Bullying)
10. Cyber Law (IT Act 2000)

UNIT - 3 DATABASE MANAGEMENT

1. Database Concepts | Introduction, Advantages, Disadvantages, DBMS
2. Relational Data model || Relation, Attribute, Tuple, Domain, Cardinality, Degree
   
3. DBMS KEYS || Candidate Key || Primary Key || Alternate Key
   
4. MySQL Aggregate Functions (MAX,MIN,SUM,AVG,COUNT)
   
5. MySQL GROUP BY and HAVING
6. MySQL ORDER BY
7. MySQL JOIN | Equi Join | Natural Join (Not in Term-Wise Syllabus)

INTERFACING PYTHON WITH MYSQL

1. How to Install MySQL on Windows
2. Python-MySQL Connector (Download, Install, Use)
3. Extracting Data from MySQL