top of page

                                           

                                                  12TH CS-PYTHON MATERIALS: 2022-23   

 

CBSE Syllabus: Click here

​

Split-Up syllabus 2022-23 Click Here

​

12th CS Python Practical list 2022-23: Click Here 

​

--------------------------------------------------------------------------------------------------------------

​

Courtesyy Reference: Inasllation of python video: Click here

​

Courtesy (Refernce: pandas installation reference video: click here

 

Courtesy (Reference: matplotlib installation reference video: click here

​

Courtesy (Refernce: Mysql connector 8.0 installation video: Click Here

​

Courtesy (Reference: Video: Interface python with SQL Database (Windows 10) :Click Here 

​

-----------------------------------------------------------------------------------------------------------------

April & May-2022 

​

Unit I: Computational Thinking and Programming – 2

​

∙ Unit I: Computational Thinking and Programming – 2

  • Revision of Python topics covered in Class XI.

  • Functions: types of function (built-in functions, functions defined in module, user defined functions), creating user defined function, arguments and parameters, default parameters, positional parameters, function returning value(s), flow of execution, scope of a variable (global scope, local scope)

 

* Chapter: Revision Tour of Python class 11th :click here(slides)

       Reference video(swathi) Revision Tour of Python class 11th(1.25 min):Click here

                               

 * Chapter:  Function in Python: Click Here(slides)

         Reference  Video:(49 min-pythontrends): Click Here     

 
    May & June 2022 Assignment (Summer Holiday Homework):  Click here
--------------------------------------------------------------------------------------------------------------------------------------------------
​
June-July 2022
*∙ Introduction to files, types of files (Text file, Binary file, CSV file), relative and absolute paths

  • Text file: opening a text file, text file open modes (r, r+, w, w+, a, a+), closing a text file, opening a file using with clause, writing/appending data to a text file using write() and writelines(), reading from a text file using read(), readline() and readlines(), seek and tell methods, manipulation of data in a text file 

∙ Binary file: basic operations on a binary file: open using file open modes (rb, rb+, wb, wb+, ab, ab+), close a binary file, import pickle module, dump() and load() method, read, write/create, search, append and update operations in a binary file

​
* Chapter:  Data File Handling in Python :
​
Topic: Introduction of File Handling And Types of Files ppt notes- Click here
  Reference Video Of Introduction: Click here   
​
Topic: Standard Input, Output, Error Streams & Absolute and Relative path ppt notes- Click Here 
  Reference video: Click here 
​
Topic: Write(), writelines() in a text file ppt notes- Click Here 
  Reference video: Click here
​
Topic: read(), readline(), readlines() in a text file ppt notes- Click Here 
  Reference video: Click here
​
Topic: Opening file using with clause(2 types) ppt notes- Click Here 
  Reference video: Click here
​
Topic: Random access in files: seek() and tell() methods ppt notes- Click Here 
  Reference video: Click here  
​
Topic: Import Pickle module, dump() and load() methods ppt notes- Click Here 
  Reference video: Click here  
​
Topic: try and exception methods ppt notes- Click Here 
   Reference video: Click here  
​
Topic: read, write/create, search, append, update & delete methods in Binary file program- Click Here 
   Reference video: Click here 
___________________________________________________________________________________________________
August-2022
​

  • CSV file: import csv module, open / close csv file, write into a csv file using csv.writerow() and read from a csv file using csv.reader( )

 Unit I: Computational Thinking and Programming – 2 Data Structure: Stack, operations on stack (push & pop), implementation of stack using list.

Unit II: Computer Networks

  •  Evolution of networking: introduction to computer networks, evolution of networking (ARPANET, NSFNET, INTERNET)

  • Data communication terminologies: concept of communication, components of data communication (sender,receiver, message, communication media, protocols), measuring capacity of communication media (bandwidth, data transfer rate), IP address, switching techniques (Circuit switching, Packet switching) 

  • Transmission media: Wired communication media (Twisted pair cable, Co-axial cable, Fiber-optic cable), Wireless media (Radio waves, Micro waves, Infrared waves 

 Network devices (Modem, Ethernet card, RJ45, Repeater, Hub, Switch, Router, Gateway, WIFI card)

​
Topic: CSV Files ppt notes- Click Here    

Chapter: Data Structure: Implement a stack using list: notes. Click Here  (Reference Video: Click Here)

Unit II: Computer Networks
Chapter- Computer Network-1 Notes ppt slides(RKS):Click Here

Reference: Computer Network-1 Video :Click Here

_______________________________________________________________________

 

September-2022

  • Network topologies and Network types: types of networks (PAN, LAN, MAN, WAN), networking topologies (Bus, Star, Tree) 

  •  Network protocol: HTTP, FTP, PPP, SMTP, TCP/IP, POP3, HTTPS, TELNET, VoIP 

 Introduction to web services: WWW, Hyper Text Markup Language (HTML), Extensible Markup Language (XML), domain names, URL, website, web browser, web servers, web hosting

​

 Chapter-Computer Network-2 Notes ppt slides(RKS):Click Here

 Reference: Computer Network-2 Video :Click Here

___________________________________________

October-2022

Unit III: Database Management

  • Database concepts: introduction to database concepts and its need 

  •  Relational data model: relation, attribute, tuple, domain, degree, cardinality, keys (candidate key, primary key, alternate key, foreign key)

  •  Structured Query Language: introduction, Data Definition Language and Data Manipulation Language, data type (char(n), varchar(n), int, float, date), constraints (not null, unique, primary key), create database, use database, show databases, drop database, show tables, create table, describe table, alter table (add and remove an attribute, add and remove primary key), drop table, insert, delete, select, operators (mathematical, relational and logical), aliasing, distinct clause, where clause, in, between, order by, meaning of null, is null, is not null, like, update command, delete command 

​

  • Aggregate functions (max, min, avg, sum, count), group by, having clause, joins

  • Cartesian product on two tables, equi-join and natural join 

 Interface of python with an SQL database: connecting SQL with Python, performing insert, update, delete queries using cursor, display data by using fetchone(), fetchall(), rowcount, creating database connectivity applications

​

Unit III: Database Management

Refernce: Mysql connector 8.0 installation video: Click Here

​​

 Chapter:  Data Base, RDBMS & SQL ppt slides(RKS):Click Here

  Reference: Data Base, RDBMS & SQL Video: Click Here

​​

 Chapter:  Mysql Revision Tour ppt slides(RKS):Click Here

 Reference: Mysql Revision Tour   Video: Click Here

​

 Reference: Video: Interface python with SQL Database (Windows 10) : Click Here 

Chapter- Joins, Equi join, Natural join & order on Mysql ppt slides(RKS):Click Her​e

 Reference: Joins on Mysql Video: Click Here

__________________________________________

November-2022

Chapter- fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL) ppt slides (RKS): Click Here

Reference: fetchall(), fetchone(), fetchmany() and rowcount( python interface through MYSQL video: Click Here

​

Chapter- INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH MYSQL)ppt slides(RKS):Click Her​e

 Reference: INSERT, UPDATE, AND DELETE (PYTHON INTERFACE THROUGH  MYSQL)video: Click Here

​

Chapter- Find the min, max, sum, and average of the marks in a student marks table( python interface through MYSQL). Click here  

 

Chapter- Find the total number of customers from each country in the table (customer ID, customer name, country) using group by( python interface through MYSQL).

Click Here

​

​

Revision for November monthly test and Ist Pre-board

---------------------------------------------------------------

​

CBSE Sample Question Paper Class: XII Session: 2022-23 Computer Science (Code 083): Click Her

​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2022-23 Computer Science (Code 083):Click here

​

​

 Courtesy: Reference video: Computer Science CBSE Sample paper Year 2022-23: Click Here 

​

______________________________________________________________________________________________

​

​

Projects:

1.Pythontrends

https://pythontrends.wordpress.com/

​

2.pythonmykvs

http://python.mykvs.in/index.php

​

​

​
bottom of page