12TH CS-PYTHON MATERIALS: 2025-26
​
CBSE Syllabus: Click here
​​
Split-Up syllabus 2025-26 Click Here
​
12th CS Python Practical list 2025-26: 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-2025
​​
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 2025 Assignment (Summer Holiday Homework): Click here
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
​​​
June-July 2025
*∙ 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-2025
​​
-
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
courtesy : write ,read and search a record for CSV file video: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-2025
​​
-
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-2025
​
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-2025
​​
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).
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-25 Ist Pre-board, practical practice and Project work
---------------------------------------------------------------------------------------------------------------------------------------------
Revision for December-25 IInd Pre-board​,Practical practice and Project work
​​
---------------------------------------------------------------------------------------------------------------------------------------------
Revision for January-26 IIIrd Pre-board​, Practical Examination
​​
--------------------------------------------------------------------------------------------------------------------------------------------
February-26 Revision for Board Examination
​​​
---------------------------------------------------------------------------------------------------------------------------------------------
​
March-26 Board Examination
---------------------------------------------------------------------------------------------------------------------------------------------
Projects:
1. Payroll mangement python and mysql connectivity(courtesy swathi) video : click here
​​​
2.Milano Bakery Management (python and Mysql connectivity) 12-C Melvin-Shamith and Naveen
(source code) :click Here Report: click
3. Element Hotel Management (python and mysql connectivity) 12-C- Likhith-Harsh verma and Kshitij
(source code): Click Here Report: Click Here
​
4. KV Hebbal Library Management(python and Mysql connectivity 12-C-Yuva sakthi and Poshenisree
Source code :click here Report: Click Here
5. Sharma Vegetable shop(python & Mysql Connectivity 12-C Parveen, Khushi & M. Divya)
source code :click Here
​
6. KV Hebbal Fee Management(python & mysql connectivity 12-C Jasmitha, Jaagruthi & Preet)
source code : click here Report: Click Here
7. Food Portal (python and Mysql connectivity) 12-C - Medhansh, Yashaswi & Mehak source code: click here
Report: Click Here
​
8. Guest House Management: (python & mysql connectivity 12-C Ananya jha,Diksha & Dipti)
source code : click here Report: click Here
-----------------------------------------------------------------------------------------------------------------------------------------------
* CBSE Sample Paper class XII Session 2025-2026 Computer Science(code: 083) Click Here
​
​
​
----------------------------------------------------------------------------------------------------------------------------------------------
*CBSE Sample Question Paper Class: XII Session: 2024-2025 Computer Science (Code 083): click here
​
*CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2024-25 Computer Science
(Code 083):click here
*Courtesy: Reference video: Computer Science CBSE Sample paper Year 2024-25: Click here
​
Region Bamgalore:
​​
* II Pre-Bard Question with answer 2024-25: Click Here (password : ​325498 )
​
* I Pre-Board Question with answer 2024-25 : Click Here
​​​---------------------------------------------------------------------------------------------------------------------------------------
*CBSE Board question Paper with answer Class: XII Session: 2023-24 Computer Science (Code 083): Click Here
*CBSE Sample Question Paper Class: XII Session: 2023-2024Computer Science (Code 083): Click Here
*CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2023-24 Computer Science
(Code 083):Click here
*Courtesy: Reference video: (swathi) Computer Science CBSE Sample paper Year 2023-24: Click Here
___________________________________________________________________________________________
*CBSE Board question Paper with answer Class: XII Session: 2022-23 Computer Science (Code 083): Click Here
*CBSE Sample Question Paper Class: XII Session: 2022-23 Computer Science (Code 083): Click Here
*CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2022-23 Computer Science
(Code 083):Click here
*Courtesy: Reference video:(swathi) Computer Science CBSE Sample paper Year 2022-23: Click Here
_________________________________________________________________________________________________________________
​
*CBSE Board question Paper with answer Class: XII Session: 2021-22 Term -2 Computer Science (Code 083): Click Here
*CBSE Sample Question Paper Class: XII Session: 2021-22 Term-2 Computer Science (Code 083): click here
*CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 Term-2 Computer Science
(Code 083):Click here
*Courtesy: Reference video: Computer Science CBSE Sample paper Year 2021-22 Term2: Click Here
​​
​​
*CBSE Board question Paper with answer Class: XII Session: 2021-22 Term -1 Computer Science (Code 083): Click Here
​​
*CBSE Sample Question Paper Class: XII Session: 2021-22 Term-1 Computer Science (Code 083): Click Here​
​
*CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 Term-1 Computer Science
(Code 083):Click here
​
*Courtesy: Reference video: Computer Science CBSE Sample paper Year 2021-22 Term-1 : Click Here
​​​​​​​_________________________________________________________________________________________________________________
​
Projects:
1.Pythontrends
https://pythontrends.wordpress.com/
​
2.pythonmykvs
http://python.mykvs.in/index.php
​
-----------------------------------------------------END------------------------------------------------------------------------------------