This thoroughly revised book, Informatics Practices with Python (065), for Class XII fully meets the 2021-22 syllabus requirements and strictly adheres to the guidelines laid down by the CBSE. The book deals with detailed concepts of Python pandas, data visualisations, computer networks, relational database management system (SQL) and societal impacts. 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 emphasis on principles of good programming, such as clarity, legibility and efficiency in program design. Thus, an interactive programming style has been emphasized and expressed throughout the book. The hallmark of this book is that it teaches Python pandas concepts in detail as well as usage of several other Python libraries, such as plotting graphs and charts using Python pyplot. Ample case studies to understand the basic concepts of computer networks with a student-centred approach have also been provided in the book. With easy-to-understand examples, practical implementations and other tools, students will learn how to create and implement Python series and DataFrames, perform advanced associated operations 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 br> br>Chapter provides tested, debugged and error-free codes with screenshots. Based on the CBSE curriculum, The book has been divided into four units: br> br>Unit I: data Handling using pandas and data visualisations - chapters 1 to 3: This br> br>Unit contains three chapters covering fundamentals of pandas including series and DataFrames 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 data visualisations using pyplot in terms of line chart, bar chart, pie chart, scatter plot, histograms, frequency Polygons and boxplot have also been thoroughly discussed. Br> br>Unit II: database query using SQL - br> br>Chapter 4: This br> br>Unit covers complete SQL, its implementation and concepts, mathematical and string functions and Aggregate functions along with important SQL clauses such as group by, having and order by. This br> br>Unit also covers operations on relations such as Union, intersection, minus, Cartesian product and join. Br> br>Unit III: introduction to Computer networks - br> br>Chapter 5: This br> br>Unit covers concepts of computer Networking, types of networks, network devices, network topologies, introduction to internet and its applications, and detailed concepts of a web page, website and web browsers. Br> br>Unit IV: societal impacts - br> br>Chapter 6: This br> br>Unit deals with digital footprints, netiquettes, intellectual property rights, plagiarism, licensing, open source and standards, cybercrime and Cyber laws, hacking, phishing, Cyber bullying, along with the Indian it Act. This br> br>Unit also includes topics on e-waste management and awareness about health concerns related to the usage of technology. The book has four appendices containing a sample project on dataframe-csv connectivity, viva voce questions, Sample Question Paper (Solved) and a model Test Paper.
