12TH IP-PYTHON  MATERIALS

                                 

                                       ACADEMIC YEAR 2024-25

​

     * Python 3.7 version(download): Click Here

​

 

CBSE SYLLABUS: Click Here

​​

SPLIT UP SYLLABUS: Click here

​​​

​​​​

12th IP Practical list 2024-25 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-2024

​

Revision List:

     List(slides) :  Click Here(python)

    Reference Video: List ( ) : Click Here(python)  

Revision Dictionary : 

       Dictionary(slides) :  Click Here​ (python)

       Reference Video: Dictionary( ) : Click Here (python)

Revision of numpy: click here   (Reference video: Click Here)

​

Unit-1

​

Data Handling using Pandas and Data Visualization

 

Data Handling using Pandas -I

​

Introduction to Python libraries- Pandas, Matplotlib.

● Data structures in Pandas - Series and data frames

 

* Series: Creation of series from dictionary, scalar value; 

mathematical operations; series attributes, head and tail functions; selec

​

Chapter-1:  Series    (Reference Video) Click Here

____________________________________________________________________________________________

June & July 2024tion, indexing and slicing.

​

* Data Frames: creation of data frames from dictionary of series, list of dictionaries, text/CSV files, display, iteration. Operations

on rows and columns: add ( insert /append) , select, delete (drop column and row), rename, Head and Tail functions, indexing using labels,

Boolean indexing.

 

Importing/Exporting Data between CSV files and

Data Frames.

 

* Data Visualization : Purpose of plotting, drawing and saving of plots using Matplotlib (line plot, bar graph, histogram).

* Customizing plots:; adding label, title, and legend in plots.

​

Chapter-2: DataFrame:  (Reference Video) Click Here

​

                    DataFrame: (Refernce Video) Click Here​

​

Chapter-3: Data Visualisation: (ReferenceVideo) Click Here

____________________________________________________________________________________________

  August 2024

​

Database Query using SQL
Revision of database concepts and SQL commands covered in class XI:
Database Concepts: Introduction to database concepts and its need, Database
Management System. Relational data model: Concept of domain, tuple, relation, candidate
key, primary key, alternate key Advantages of using Structured Query Language, Data
Definition Language, Data Query Language and Data Manipulation Language, Introduction
to MySQL, creating a database using MySQL, Data Types Data Definition: CREATE
DATABASE, CREATE TABLE, DROP, ALTER Data Query: SELECT, FROM, WHERE with relational
operators, BETWEEN, logical operators, IS NULL, IS NOT NULL Data Manipulation: INSERT,
DELETE, UPDATE​​​​​​​​​

​​

____________________________________________________________________________________________

September   October-2024

UNIT 2

Database Query using SQL

Math functions: POWER (), ROUND (), MOD (). Text functions: UCASE ()/ UPPER (), LCASE ()/
LOWER (), MID ()/ SUBSTRING () /SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (),
RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (),
DAY (), DAYNAME (). Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using
COUNT (*). Querying and manipulating data using Group by, Having, Order by. Working
with two tables using equi-join

​​

Date Function and Aggregate Function notes: click here

Reference video: Click Here​

​​​

Group by, Having and order by: Click Here

Reference video: Click Here

​​​____________________________________________________________________________________________

October-2024

UNIT 3

Introduction to Computer Networks

Introduction to networks, Types of networks: LAN, MAN, WAN. Network Devices: modem,
hub, switch, repeater, router, gateway Network Topologies: Star, Bus, Tree, Mesh.
Introduction to Internet, URL, WWW, and its applications- Web, email, Chat, VoIP. Website:
Introduction, difference between a website and webpage, static vs dynamic web page, web
server and hosting of a website. Web Browsers: Introduction, commonly used browsers,
browser settings, add-ons and plug-ins, cookies.

​

Chapter- Computer Network-1 Notes ppt slides Click Here

Reference: Computer Network-1 Video :Click Here

​

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

 Reference: Computer Network-2 Video :Click Here

____________________________________________________________________________________________​

November 2024

Unit-4 

Societal Impacts

*Digital footprint, net and communication etiquettes, 

● Data protection, intellectual property rights (IPR), plagiarism, licensing and copyright, 

● Free and open source software (FOSS), 

● Cybercrime and cyber laws, hacking, phishing, cyber bullying, overview of Indian IT Act.

● E-waste: hazards and management. 

Awareness about health concerns related to the usage of technology

​Courtesy ; Reference video: Click here​

​

 Revision for November-24  Ist Pre-board, practical practice and Project work

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

Revision for December-24 IInd Pre-board​,Practical practice and Project work

___________________________________________________________________________________________

Revision for January-25  IIIrd Pre-board​, Practical Examination

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

 February-25 Revision for Board Examination

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

March-25  Board Examination

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

Projects:

  1. 12 IP Project : Banking Management : Click Here

​​​​

   2, 12 IP Project: Employee Management: Click Here

​​​

   3. YSD Medical store Management (Yogesh, Suraj & Druv python & Mysql connectivity with Graphs(pie,bar,line))

        Source code : click Here      Report :

 

    4. Hogwarts Hotel Management system(12-D Pruthvija and Karunya)(python, mysql connectivity with graphs:line chart

        bargraph, pie chart): source code : click Here    Report :click Here 

     

    5. Cookies & Crumbl Co. project- Bhargavi, Nandini & Spurthi  (python, mysql connectivity with graphs:

        bargraph,): source code : click Here    Report :click Here
    

    6. Shetty Luxury Car Rentals project- Ruhaim, Nihant & Shashank(python, mysql connectivity with graphs:

        bargraph,pie chart & line chart): source code : click Here    Report :click Here

​​​

    7 Medical Store-Anivi-Mahi singh- Diya Ujwal(python, csv file with graph) source code : click Here   Report: click here

​​

    8. Employee Managememt Shivangi, Aarushi & Vijendra  (python, csv file with graph-Line, bar, Histogra, hbar)

     source code : click Here   Report: click here

​​

     9, Koramangala star Hotel Management Jothish, Prajwal  & charan  (python, mysql connectivity with graph-Line, bar, pie)

       source code : click Here   Report: click here

​​

     10. sweet shop : Shravya, Diya & Simran  (python, CSV file with graph-Line, bar, pie)

       source code : click Here   Report: click here

​

      11. Genetic Nutrition shop :  Manish, Rumith & Parishith  (python, CSV file with graph-Line, bar, pie)

       source code : click Here   Report: click here

​

      12. Tia Beauty shop: Arka, Gayatri & Misba  (python, CSV file with graph-Line, bar, pie)

       source code : click Here   Report: click here

​

      13 Grace View shop: Amrutha, Chandana & Pragathi   (python, CSV file with graph-Line, bar, pie)

       source code : click Here   Report: click here 

 

      14 Jockey shop: Deepak, Pooja & Bhavana   (python, CSV file with graph-Line, bar, pie)

       source code : click Here Report: click here   

​

      15 Yasu Hotel: Arunima & Vaishnavi   (python, CSV file with graph-Line, bar, pie)

       source code : click Here Report: click here   

​

__________________________________________________________________________________________

​​​

CBSE Board paper Class XII Session : 2024-25 Informatics practices(Code 065):Click Here

​

CBSE Sample Question Paper Class: XII Session: 2024-25 Informatics Practices (Code 065): Click Her

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2024-25 Informatics Practices (Code 065): Click Here

​​

Courtesy Reference Video: CBSE Sample Question Paper Class: XII Session:

2024-25 INFORMATICS PRACTICES (Code : 065) (Theory: Click Here)

​

Bengaluru Region:

​

 * 2nd Pre-Board Question with Answer 24-25 :  Click Here (password: 265924 )

​

* Ist Pre-Board Question with Answer 24-25 : Click Here

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

CBSE Board paper Class XII Session : 2023-24 Informatics practices(Code 065):click Here

​​

CBSE Sample Question Paper Class: XII Session: 2023-24 Informatics Practices (Code 065): Click Her

​​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2023-24 Informatics Practices (Code 065) Click Here

 

Courtesy Reference Video: CBSE Sample Question Paper Class: XII Session:

2023-24 INFORMATICS PRACTICES (Code : 065) (Theory: Click Here)

​​___________________________________________________________________________________________

​

CBSE Sample Question Paper Class: XII Session: 2022-23 Informatics Practices (Code 065): Click Her

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2022-23 Informatics Practices (Code 065):Click here

​​

Courtesy Reference Video: CBSE Sample Question Paper Class: XII Session:

2022-23 INFORMATICS PRACTICES (Code : 065) (Theory: Click Here)

​​___________________________________________________________________________________________

CBSE Sample Question Paper Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065) (Theory: Term-1:Click Here)

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065) (Theory: Term-1: Click Here)

​

CBSE Sample Question Paper Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065) (Theory: Term-2:Click Here)

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065) (Theory: Term-2:Click Here)

​______________________________________________________________________________________________

​​

1st Pre-Board Marking scheme IP (Bengaluru Region) 2023: Click Here

​​

2nd Pre-Board Marking scheme IP(Bengaluru Region) 2023: Click Here

​​​​

Pre-Board Question Paper IP (Ahmadabad Region) 2023: Click Here

​​

Pre-Board Marking Scheme IP (Ahmadabad Region) 2023: Click Here

--------------------------------------------------------------------------------------------------------------------------------​

​Projects:

1.Pythontrends

https://pythontrends.wordpress.com/

​​

2.pythonmykvs

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

​

___________________________________________________________________________________________

​

​

​

​​

​​

​​

​​

​​

​​

​​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Unit 1:

 

Data Handling using Pandas and Data Visualization

 

Data Handling using Pandas -I

 

● Introduction to Python libraries- Pandas, Matplotlib. 

         Reference Video: Click Here

​

 

 

​

​

​

​

​

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

CBSE Sample Question Paper Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065)

(Theory: Term-1:Click Here)

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065)

(Theory: Term-1: Click Here)

​

CBSE Sample Question Paper Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065)

(Theory: Term-2:Click Here)

​​

CBSE Sample Question Paper: Marking Scheme Class: XII Session: 2021-22 INFORMATICS PRACTICES (Code : 065)

(Theory: Term-2: Click Here)

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

*************************************************************************

    

​