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
23. String Functions (Part – 2) Interface Python with MYSQL (Part – 1)
-
Most Important Questions Based On Text File (Part – 2)
-
Introduction of Binary Files, Pickle module , load( ) and dump( )
-
How to write and read multiple records from a binary file? Taking input from user.
-
How to search record in a Binary File?
-
seek ( ) and tell ( ) in File Handling
-
How to update a record in a Binary File?
-
Most Important Questions based on Binary Files
-
Introduction of CSV Files … How to write data in a CSV File using writerow( ) and writerows( ) functions?
-
How to read data from a CSV file?
-
Introduction of Recursion
-
Program in Python to find factorial of a Number using Recursion.
-
Program in Python to print Fibonacci series using Recursion.
-
Program in Python to print sum of first N natural numbers using Recursion.
-
Program to search an element using Binary Search recursively
-
Solving Output – based Questions of Recursion
-
Idea of Algorithmic Efficiency (Introduction)
-
Calculating Complexity of an algorithm
-
Download and Install MYSQL Server (Complete Step – by – Step Guide)
-
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
-
Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands
-
Create Database, Use Database, Show Databases, Show Tables, Create Table, char v/s varchar , data types in MYSQL
-
Desc Command, Insert Into and Select Command
-
WHERE Clause, Relational Operators, Logical Operators, Putting Text in Query, Scalar Expressions
-
DISTINCT BETWEEN NOT BETWEEN IS NULL IS NOT NULL LIKE NOT LIKE (PART-4)
-
ALTER , UPDATE , DELETE , DROP Commands (PART-5)
-
Aggregate Functions (PART-6)
-
Order By , Group By , Having Clause (PART-7)
-
Joins in MYSQL (Equi Join Natural Join) (Part – 8)
-
Important Question of MYSQL (Part – 1)
-
Important Questions Of MYSQL (Based On Two Tables) – (Part – 2)
-
Constraints in MYSQL
Computer Networks
-
Computer Networks and its Advantages , Types of Networks, Switching Techniques
-
Network Topologies
-
Transmission Media
-
Network Devices
-
Network Protocols
-
Abbreviations
-
Internetworking Terms
-
Network Security Concepts
72. Tips to solve Case Study Based Questions
Courtesy: Ms. Swati Chawla
__________________________________________________
Courtesy: Ms. Shilpi Saxena
_____________________________________________________________________________
Courtesy: Ms. Meenu Kapoor
___________________________________________
XII IP Videos
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
Syllabus-
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
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
________________________________________________________________
MYSQL
-
MySQL Simple Queries
-
MySQL – Table Creation
-
MySQL – Table creating with existing table
-
MySQL – Handling NULL Values
-
MySQL – Structure, Order by clause
-
MySQL Queries – Where Clause with condition
-
MySQL Queries – clause in, between, pattern matching
-
MySQL Functions in Queries
-
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 OperationsCourtesy: Ms. Shilpi Saxena |