Sultan Chand CBSE Informatics Practices with Python Textbook for Class 12 | 2024-25 |

This book provides an in-depth understanding of the CBSE Class XII curriculum of Informatics Practices (065). It strictly adheres to the new curriculum guidelines laid down by the CBSE. The book deals with advanced concepts of Python Pandas, NumPy, Data Visualization, Django, Relational Database Management System (SQL), Python-MySQL connectivity, Basic Software Engineering, and Cyber Ethics. Python is a popular object-oriented language used both for stand-alone programs and scripting applications in a variety of domains. This book adopts a contemporary approach to the most popular Python library, Pandas, with stress on principles of good programmings, such as clarity, legibility, and efficiency in program design. Thus, an interactive programming style has been emphasized/expressed throughout the book. The hallmark of this book is that it teaches advanced Python Pandas concepts and usage of several other Python libraries, such as plotting graphs and charts using Python Pyplot, and establishing Python-MySQL connectivity. Ample case studies to understand the basic concepts of Software Engineering with a student-centred approach have also been provided in the book. With easy-to-understand examples, practical implementations and other tools, the student will learn how to create and implement Python data frames and develop GUI applications based on it. The text of the book has been presented in a friendly and easy-to-comprehend language. The book contains example programs that are concise and practical besides diagrams and examples from real-life applications. Each chapter provides tested, debugged and error-free codes with screenshots. Based on the CBSE curriculum, the book has been divided into four units:

• Unit I: Data Handling (DH-2) – Chapters 1 to 3:- This unit contains three chapters covering review of Pandas studied in Class XI. Advanced concepts of Pandas such as Pivoting, Sorting, Aggregation, Function Applications, Reindexing, and Quantiles have been explained in detail with ample examples and associated codes. Apart from the above, detailed concepts of NumPy (arrays) and their implementation, Data Visualization using Pyplot in terms of Line chart, Bar chart, Scatter plot, Histograms, Frequency Polygons, and Boxplot have also been thoroughly discussed.
• Unit II: Basic Software Engineering (BSE) – Chapters 4 and 5:- This unit has been divided into two chapters—4 and 5—and covers Software Engineering concepts such as Software process models, Delivery models, Agile methods, business-use diagrams, and some practical aspects and their implementation.
• Unit III: Data Management (DM-2) – Chapters 6 to 8:- This unit covers the development of Django web application, Interface Python with an SQL database and SQL commands, Aggregation functions along with important SQL clauses such as group by, having and order by.
• Unit IV: Society, Law and Ethics (SLE-2) – Chapter 9:- This unit deals with intellectual property rights, plagiarism, digital rights management, licensing, open-source and standards, privacy laws, frauds and cyber crimes such as phishing, illegal downloading, child pornography, cyber scams and frauds, cyber forensics, IT Act, 2000, and Unique Id and Biometrics. It also explains related concepts of technology and society, e-waste management, and gender and disability issues while teaching and using computers and the role of new media in society with case studies.

The book has four appendices containing installation guide to Django, Viva Voce questions, Sample Question Paper (Solved) and Model Test Paper (Unsolved). As part of our Web Support, Presentation on the advanced concept of Python Pandas, Chapter-wise Program Codes, Projects based on Python-MySQL connectivity using Pandas, Practical File, Sample Papers, Model Test Papers for practice and Viva Voce questions are available online and can be accessed at sultan-chand.com/ws/ipp12

Besides, exam-related updates, if any, will also be made available online in due course.