Technical

1- Python downloading & Installation step-by-step

2- MySQL downloading & installation procedure step-by-step

___________________________________________

XII CS Videos:-

> Function: Part-1  & Part2

> Tokens in Python

> Basic Concept (Output Base Problem)

> List Manipulation

> String Palindrome/ Manipulation of String

> Type Conversion

> Conditional Statements

> Basic Program (Searching Palindrome)

> For Loop and While Loop

> Searching (Linear and Binary Searching)

> Local and Global Variable

> Output problems

>  STACK in PYTHON

> PALINDROME PROGRAM / STRING PALINDROME IN PYTHON / PALINDROME OF STRING /REVERSE OF THE STRING

> Random Module in Python || Python Random Number Generator || randrange() || randint() || random()

> Output Problems of random Library || randrange() || randint() || random()

> Revision Tour of SQL

> Networking For Class 12 | CLASS 12 XII COMPUTER SCIENCE| 4 Marks Question from Networking

> One word | One Liner Computer Network| Basic Terms of Networking | Class XII Computer Science | CS

>  ONE LINER QUESTION ON CYBER SAFETY | MCQ Types Question | Class XII CS with Python

> Network topology types (Bus, Star, Ring, Mesh, Hybrid,Tree)

> Python for Class 12 Board Exam | Society, Law and Ethics|Computer Science with Python (Part-I)

> Python for Class 12 Board Exam | Society, Law and Ethics|Computer Science with Python (Part-II)

> One Liner Question on Cyber Safety

> Database Concept : MYSQL Commands|Basic Command of mysql | Computer Science With Python| Part-I

> Database Concept : MYSQL Commands|Basic Command of mysql | Computer Science With Python| Part-II

> Random Module in Python (Theory)

> Random Module in Python(Output Problem)

> Operation on Binary File

> Lab Activity on Binary File Part-1

> Lab Activity on Binary File Part-2

>  Text File in Python

> CBSE Problem on Text File

> Operation on Binary File

>. Lab Activity on Binary File Part-1

>  Lab Activity on Binary File Part-2

> Operation on CSV File

> Lab Activity on CSV File

> Recursion

> Python Library

> String in Python | Working with String in Python | String Indexing |String slicing in Python

> String in Python | Working with String in Python | String Indexing |String slicing in Python |Part-1

> String in Python | Working with String in Python | String Indexing |String slicing in Python |Part-2

Courtesy: Mr. M L Meena

______________________________________________________________________________

1. Local and Global Variable

2.  Function Introduction Part-I

3.  Function Introduction Part-II

4.  Function Introduction Part-III

5. File Handling (Writing in Text Files ) Part I

6. File Handling (Writing in Text Files ) Part II

7. File Handling (Reading from Text Files ) Part II

8. File Handling (Question on Text Files ) Part III

9. File Handling (Question on Text Files ) Part IV

10. File Handling (Question on Text Files ) Part V

11. Binary Files (Reading and Writing) Part-I 

12. Binary Files (Searching and Updating the records) Part II

13. Binary Files (Deleting, Appending and Sorting the records) Part III 

14. CSV Files 

15. CSV Files Practice 

16. Binary search using Arrays

17. Data Structure – Stacks implementation using List

18. Creating Modules in Python 

19. Recursion in Python (Part-I)

20. Recursion in Python (Part-II) Examples

21. Recursion in Python (Part-III) Binary Search and Linear Search

22. Database connectivity in Python using mysql.connector

23. Database connectivity using mysql connector part-2

Courtesy: Mrs. Sarika Kaushal

_________________________________________________________________

Playlist Links:

Python Revision Tour

Functions in Python

random module

Mathematical and String Functions

Using Python Libraries

Data Structures: Stack and Queue

File Handling

Recursion

Idea of Algorithmic Efficiency

Interface Python with MYSQL

MYSQL

Programming Corner

  1. Introduction of Functions

  1. Functions returning values and difference between Arguments and Parameters

  1. Local Scope and Global Scope , Mutable and Immutability properties

  1. Error Finding Questions in Python (MOST IMPORTANT – for 2 marks)

  1. Output Finding Part 1 (Most Important for 2 or 3 marks)

  1. Output Finding Part 2 (Most Important for 2 or 3 marks)

  1. Output Finding Part – 3 (Most Important for 2 or 3 marks)

  1. Function Definition Questions (Part – 1)

  1. Function Definition Questions (Part – 2)

  1. Function Definition Questions (Part – 3)

  1. Introduction of Data Structures – Stack and Queue

  1. Implementation of Stack and Queue using List in Python

  1. How to solve Questions based on Stack and Queue (MOST IMPORTANT – 4 MARKS)

  1. Functions of random module

  1. How to solve questions based on random module Part – 1 (MOST IMPORTANT – 2 MARKS)

  1. How to solve questions based on random module Part – 2 (MOST IMPORTANT – 2 MARKS)

  1. Using Python Libraries

  1. How to create our own modules in Python

  1. LEGB rule in Python

  1. How to create our own packages in Python

  1. Mathematical Functions

  1. String Functions (Part – 1)

   23. String Functions (Part – 2) Interface Python with MYSQL (Part – 1)

  1. Interface Python with MYSQL (Part – 1)

  1. FETCHALL( ) , FETCHONE( ) , FETCHMANY() , ROWCOUNT

  1. Parameterized Queries (How to take input from user)

  1. Performing Insert, Update and Delete Operations, while connecting Python with MYSQL

  1. Introduction of Data File handling , Types of Files , Access Modes..

  1. How to read data from a text file using read( ), readline( ) and readlines ( )

  1. How to write data in a file using write and writelines( ) ? How to append data ?

  1. Most Important Questions Based On Text File (Part – 1)

  1. Most Important Questions Based On Text File (Part – 2)

  2. Introduction of Binary Files, Pickle module , load( ) and dump( )

  3. How to write and read multiple records from a binary file? Taking input from user.

  4. How to search record in a Binary File?

  5. seek ( ) and tell ( ) in File Handling

  6. How to update a record in a Binary File?

  7. Most Important Questions based on Binary Files

  8. Introduction of CSV Files … How to write data in a CSV File using writerow( ) and writerows( ) functions?

  9. How to read data from a CSV file?

  10. Introduction of Recursion

  11. Program in Python to find factorial of a Number using Recursion.

  12. Program in Python to print Fibonacci series using Recursion.

  13. Program in Python to print sum of first N natural numbers using Recursion.

  14. Program to search an element using Binary Search recursively

  15. Solving Output – based Questions of Recursion

  16. Idea of Algorithmic Efficiency (Introduction)

  17. Calculating Complexity of an algorithm

  18. Download and Install MYSQL Server (Complete Step – by – Step Guide)

  19. Database Concepts: Introduction to database concepts and its need. Relational data model: Concept of domain, relation, tuple, attribute, degree, cardinality, key, primary key, candidate key, alternate key and foreign key

  1. Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands

  2. Create Database, Use Database, Show Databases, Show Tables, Create Table, char v/s varchar , data types in MYSQL

  3. Desc Command, Insert Into and Select Command

  4. WHERE Clause, Relational Operators, Logical Operators, Putting Text in Query, Scalar Expressions

  5. DISTINCT BETWEEN NOT BETWEEN IS NULL IS NOT NULL LIKE NOT LIKE (PART-4)

  6. ALTER , UPDATE , DELETE , DROP Commands (PART-5)

  7. Aggregate Functions (PART-6)

  8. Order By , Group By , Having Clause (PART-7)

  9. Joins in MYSQL (Equi Join Natural Join) (Part – 8)

  10. Important Question of MYSQL (Part – 1)

  11. Important Questions Of MYSQL (Based On Two Tables) – (Part – 2)

  12. Constraints in MYSQL

Computer Networks

  1. Computer Networks and its Advantages , Types of Networks, Switching Techniques

  2. Network Topologies

  3. Transmission Media

  4. Network Devices

  5. Network Protocols

  6. Abbreviations

  7. Internetworking Terms

  8. Network Security Concepts

72. Tips to solve Case Study Based Questions

Courtesy: Ms. Swati Chawla

__________________________________________________

LINKS OF VIDEOS OF CLASS XII (CBSE)

Topic: Working with Functions Part 1 | Computer Science Class XII (CBSE)

Working with Functions Part 2 | Computer Science Class XII (CBSE)

Working with Functions Part 3 | Computer Science Class XII (CBSE)

Working with Functions Part 4 | Computer Science Class XII (CBSE)

Working with Functions Part 5 | Computer Science Class XII (CBSE)

Working with Functions Part 6 | Computer Science Class XII (CBSE)

Working with Functions Part 7 | Computer Science Class XII(CBSE)

Working with Functions Part 8 | Computer Science Class XII (CBSE)

Working with Functions Part 9 | Computer Science Class XII (CBSE)

Working with Functions Part 10 | Computer Science Class XII (CBSE)

Using Python Libraries Part 1 | Computer Science Class XII (CBSE)

Using Python Libraries Part 2 | Computer Science Class XII (CBSE)

Using Python Libraries Part 3 | Computer Science Class XII (CBSE)

Using Python Libraries Part 4 | Computer Science Class XII (CBSE)

 Using Python Libraries Part 5 | Computer Science Class XII (CBSE)

 File Handling Part 1| Computer Science Class XII (CBSE) | Working with Text Files

File Handling Part 2| Computer Science Class XII (CBSE) | Working with Text File

 File Handling Part 3 | Computer Science Class XII (CBSE)| Working with Text Files

 File Handling Part 4 | Computer Science Class XII (CBSE) | Working with Text Files

 File Handling Part 5| Computer Science Class XII (CBSE) | Text File Examples

File Handling Part 6 | Computer Science Class XII (CBSE) |Text File Examples

 File Handling Part 7 | Computer Science Class XII (CBSE) | Text File Examples

 File Handling Part 8 | Computer Science Class XII (CBSE) | Binary Files

File Handling Part 9 | Computer Science Class XII (CBSE) | Binary File examples

 File Handling Part 10 | Computer Science Class XII (CBSE) | Working with CSV File

Recursion Part 1 | Computer Science Class XII (CBSE)

 Recursion Part 2 | Computer Science Class XII (CBSE)

 Recursion Part 3 | Computer Science Class XII (CBSE)

Idea of Algorithmic Efficiency Part 1 | Class XII (CBSE) | Big-O Notation

Idea of Algorithmic Efficiency Part 2 | Class XII (CBSE) | Best, Average and Worst-case complexity

Idea of Algorithmic Efficiency Part 3 | Class XII (CBSE) | Calculating complexity

Data Structure – Part 1 | Class XII (CBSE) | Working of Linear list

Data Structure – Part 2 | Class XII (CBSE) | Stack Operations

Data Structure – Part 3 | Class XII (CBSE) | Queue Operations

Project Work Part 1 | Class XII (CBSE) | Using Tkinter

Project Work Part 2 | Class XII (CBSE) | Using Tkinter

Project Work Part 3 | Class XII (CBSE) | Using Radio buttons in Tkinter

Project Work Part 4 | Class XII (CBSE) | Using Check buttons & image in Tkinter

Interface Python with MYSQL – Part 1 | Class XII (CBSE) | Retrieving rows from MYSQL table

Project Work Part 6 | Class XII (CBSE) | Using GUI Calendar in Tkinter

Relational Databases Part 1 | Computer Science |Class XI & XII

Relational Databases Part 2 | Computer Science |Class XI & XII |Datatypes & Introduction to MYSQL

MYSQL Part 1 | Computer Science |Class XI & XII | MYSQL Queries I INSERT INTO, SELECT Command

MYSQL Part 2 | Computer Science |Class XI & XII | MYSQL Queries I NULL, WHERE Clause, BETWEEN

Courtesy: Ms. Shilpi Saxena

_____________________________________________________________________________

Courtesy: Ms. Meenu Kapoor

___________________________________________

DATA VISUALIZATION PART-1 : Introduction to Data visualization, matplotlib, installing matplotlib, types of charts, steps to draw chart, introduction to Line chart.

XII IP Videos

Unit-1 (Data Handling using Pandas and Data Visualization) – 25 Marks

Unit-4 (Societal Impacts) – 10 Marks

Courtesy: A. K. Pandey

______________________________________________________________

1. XII IP Pie Plot-Data Visualization

2. Histogram and Frequency Polygon

______________________________________________________________________________

3. Panda Series

4. Data Visualisation’ series

Courtesy: Mrs Archana Jain

_________________________________________________________________

CLASS 12 ( INFORMATICS PRACTICES CODE-065)

DESCRIPTION AND LINK

Notes: Kindly ignore if a particular topic is not in your syllabus. Study as per your reduced syllabus

Channel Link : Computer Concepts -A.K. Pandey

Term wise Syllabus Term-2(2021—22)

Unit-2 (Database Query using SQL) – 25 Marks

Unit-3 (Introduction to Computer Networks) – 10 Marks

Technical

______________________________________________________________

Syllabus of Term-I:

1- Complete Reduced Syllabus Class 12 IP 2020-21

Data Handling using Pandas-I

1- Series Part-1 (Introduction,Features and installation of Pandas,  Series Creation

2- Series Part-2 (Attributes,Slicing,loc,iloc,head(),tail(),Conditional retrieval, arithmetic & vector operation)

3- DataFrame-1(Introduction,Features,Creation from List, Dictionary and Series)

4- DataFrame-2(Attributes,Slicing Rows & Columns, loc and iloc, head() and tail() functions)

5- DataFrame-3 (Set/reset index,rename column,adding  and deleting column/row)

6- DataFrame-4(Iterration-iterrows,iteritems,Binary operations-Arithmetic)

7- DataFrame-5(Broadcasting,matching,Boolean indexing & reduction, Handling missing values(Removed)

8- DataFrame-6(DataFrame Concatenation, Merge and Join operations) –Removed

9- DataFrame-7(Descriptive Statistics in Pandas and Aggregate Functions)-Removed    

10-DataFrame-8 ( Descriptive Statistics(Removed), reindexing and renaming columns)

11- DataFrame-9(Pivoting, Data Aggregation and group by) – Removed

12- DataFrame-10 ( Reading data from csv file to DataFrame and vice-versa)

13- DataFrame-11(Importing and Exporting Data to/from MySQL) – Removed

Exercises on Pandas-I

14- Adding New Columns in a DataFrame using different methods

15- Important Questions on Pandas Series and DataFrame

 

Data Visualization using matplotlib

16-Data Visualization-1(Introduction,installing matplotlib,Rules,Nomenclature,Steps for Line chart)

17- Data Visualization-2(Drawing various kinds of Line chart, and its attributes)

18- Data Visualization-3(Practical implementation of customizing a Line chart)

19- Data Visualization-4(Drawing and customizing Bar chart)

20- Data Visualization-5(Drawing and customizing Scatter chart)- Removed

21- Data Visualization-6(Drawing and customizing Pie Chart) – Removed

22- Data Visualization-7(Drawing and customizing Histogram)

23- Data Visualization-8(Drawing and customizing Box-Plot) – Removed

24- Data Visualization-9(Drawing Line Chart using Pandas and matplotlib)

25- Data Visualization-10( Drawing Bar Chart using Pandas and matplotlib)

26- Viva Questions from Data Visualization

Database Query using SQL (for Class 11 and 12 IP and CS Students)

Notes: Kindly ignore if a particular topic is not in your syllabus. Study as per your reduced syllabus

27- MySQL Part-1(Database & its hierarchy, database system,dbms )

28- MySQL Part-2(Data Models & their characteristics, relational model & Basic Terminology)

29- MySQL Part-3(SQL and MySQL, Classification of SQL-DDL,DML,DCL,TCL),Advantages of MySQL)

30- MySQL Part-4(SQL Data types, diff. b/w char & varchar,SQL commands-create database, show database,use, create table)

31- MySQL Part-5( DDL-Insert Command with practical implementation)

32- MySQL Part-6(DML-update and Delete command with practical implementation)

33- MySQL Part-7(DML- select command- from, where and order by clause, between, like, in,and or, not operator, column alias, distinct etc)

34- MySQL Part-8(SQL Constraints- primary key, not null, check, unique,default,foreign key)

35- MySQL Part-9(DDL- Alter Table, Drop Table commands with practical examples)

36- MySQL Part-10(SQL Functions-Numeric,String,Data & Time with practical examples)

37- MySQL Part-11(Multi-Row/group/aggregate functions, group by and having clause) – 12 IP

38- MySQL Part-12(Table Joins- Queries from multiple tables)

Exercises on SQL

  1. a) Important SQL Exercise for Board

Introduction to Computer Networks

38- Computer Networking Part-1(Networking and Various Types of Networks)

39- Computer Networking Part-2(Networking Topologies-Structure, advantages/disadvantages)

40- Computer Networking Part-3(Networking devices-modem,hub,switch,repeater,bridge,router, gateway, RJ-45)

41- Internet Basics Part-1(Introduction, WWW, Web servers, Domain Names)

42- Internet Basics Part-2(URL, Application of www-Email, Chat, Voip)

43- Internet Basics Part-3(Website Concepts- Website, web page, web hosting)

44- Internet Basics Part-4(Web Browsers-features, tools, search engines, add-ons, plug-ins, cookies etc.)

Societal Impacts

45- Societal Impacts Part-1( Digital Footprints, Netiquette)

46- Societal Impacts Part-2(Intellectual Property Rights-IPR, Plagiarism)

47- Societal Impacts Part-3(Licensing and Copyrighting)

48- Societal Impacts Part-4(Data Protection, Various types of Cyber Crimes & IT Act-2000 )

49- Societal Impacts Part-5(Various types of free and Open Source Software)

50- Societal Impacts Part-6(E-waste Hazards and E-waste Management)

Courtesy: A.K. Pandey

_________________________________________________________________

Courtesy: Mr. Vivek Giri

______________________________________________________________________________

> Pandas introduction

> Pandas Series

> Pandas Data Frame part 1

> Boolean Indexing in Pandas Dataframe and Series

> Join, Merge and Concat functions in Pandas DataFrame

Courtesy: Mrs. Sarika Kaushal

_________________________________________________________________

XII IP COMPLETE SYLLABUS PYTHON VIDEOS

NumPy

Introduction to Numpy

Creating 1D Array  

Creating 2D Array from 1D Array 

Array Indexing  

Array Slicing,Array Joining  

Array iteration  

Python Pandas I

Head and Tail functions 

loc and iloc 

Pandas Dataframe  

iterrows(),iteritems()   

Python Pandas II

Python Pandas:group by

Combining DataFrames

Sorting,Pivoting

pivot_table()

Exporting/Importing Data

Python Pandas part-II descriptive statistics

Line chart

Scatter chart and Bar chart 

Histogram 

Boxplot

Courtesy: Ms. Jyoti

________________________________________________________________

  1.   Introduction : What is Python

  1. Fundamental of Python

  1. String Manipulation in Python

  1. List in Python

  1. Built in function in Python

  1. Random number in Python

  1. User defined functions in Python

 

  1. Data File in Python

 

  1. Program – Occurance of any word in Python

 

MYSQL

 

  1. MySQL basics / Fundamental

  1. How to Install MYSQL

  1. MySQL Simple Queries

 

  1. MySQL – Table Creation

 

  1. MySQL – Table creating with existing table

 

  1. MySQL – Handling NULL Values

 

  1. MySQL – Structure, Order by clause

 

  1. MySQL Queries – Where Clause with condition

 

  1. MySQL Queries – clause in, between, pattern matching

 

  1. MySQL Functions in Queries

 

  1. MySQL Queries in two tables

Courtesy: Manish Gupta

_________________________________________________________________

Introduction to Python Pandas Part 1| Class XII (CBSE) | Informatics Practices| Working with Series

Introduction to Python Pandas Part 2| Class XII (CBSE) | Informatics Practices| Working with Series

Python Pandas Part 3| Class XII (CBSE) | Informatics Practices| Creating Series | loc, iloc

Python Pandas Part 4| Class XII (CBSE) | Informatics Practices| Series Attributes| Vector Operations

Courtesy: Ms. Shilpi Saxena