This is Informatics Practices — A Textbook for Class XII by Sumita Arora, published by Dhanpat Rai & Co., Edition 2026-27. It is an English medium (Roman script) book — the complete text, code listings, output and exercises are in English, and there is no Hindi content in it. It is prepared for the CBSE Class 12 Informatics Practices course (Code 065), following the latest CBSE syllabus.
The Class 12 Informatics Practices course has four units and this book is organised along them. Data handling using Pandas covers the Series and DataFrame objects — creation, indexing, selection, adding and deleting rows and columns, head and tail, descriptive statistics, handling missing values, importing and exporting data as CSV, and plotting with Matplotlib. Database query using SQL covers relational database concepts, math, text and date functions, aggregate functions, grouping, ordering, and joins across tables. Computer networks covers network types, topologies, devices, protocols and web services. Societal impacts covers digital footprint, net etiquette, data protection, intellectual property rights, cybercrime, cyber law, e-waste and health concerns.
Sumita Arora's books are the standard classroom text for this subject, and the reason is the code. Informatics Practices is examined by asking a student to write a working Pandas statement or an SQL query, not to describe one, and this book prints complete, tested code with its output alongside — so a student can compare their own result rather than debug blind. The Pandas unit in particular is where marks are lost, because the difference between loc and iloc, or between a slice on a Series and one on a DataFrame, only becomes clear when the output is visible.
Each chapter carries solved examples, in-chapter checkpoints and exercises with practical assignments, and there is a project and practical component in the subject that these programs are suitable for.
Key Features:
English medium book — complete content written in English (Roman script), no Hindi content
Published by Dhanpat Rai & Co.
Informatics Practices — A Textbook for Class XII (Class 12) by Sumita Arora
Edition 2026-27, as per the latest CBSE syllabus
For CBSE Informatics Practices (Code 065)
Covers Data Handling Using Pandas — Series and DataFrame
Covers indexing, selection, adding and deleting rows and columns
Covers descriptive statistics, handling missing data, CSV import and export
Covers data visualisation with Matplotlib — line, bar and histogram plots
Covers Database Query Using SQL — math, text, date and aggregate functions
Covers grouping, ordering and joins across tables
Covers Computer Networks — types, topologies, devices, protocols and web services
Covers Societal Impacts — digital footprint, IPR, cybercrime, cyber law, e-waste
Complete code listings with output printed alongside
Solved examples, in-chapter checkpoints and chapter-end exercises
Practical assignments suitable for the practical file and project work
For the CBSE Class 12 Informatics Practices board examination and practical
यह पुस्तक धनपत राय एंड कं. द्वारा प्रकाशित Informatics Practices — A Textbook for Class XII है, लेखिका सुमिता अरोड़ा; संस्करण 2026-27। ध्यान दें: यह पुस्तक पूर्णतः अंग्रेज़ी भाषा एवं रोमन लिपि में है — इसमें हिन्दी भाषा का प्रयोग नहीं है। यह CBSE Informatics Practices (कोड 065) के नवीनतम पाठ्यक्रम के अनुसार है। इसमें चार इकाइयाँ सम्मिलित हैं — पांडास द्वारा डेटा हैंडलिंग (Series एवं DataFrame, इंडेक्सिंग एवं चयन, पंक्ति-स्तंभ जोड़ना-हटाना, वर्णनात्मक सांख्यिकी, अनुपस्थित मान, CSV आयात-निर्यात तथा Matplotlib द्वारा आरेखण), SQL द्वारा डेटाबेस क्वेरी (गणितीय, टेक्स्ट, दिनांक एवं समुच्चय फलन, ग्रुपिंग, ऑर्डरिंग एवं जॉइन), कंप्यूटर नेटवर्क तथा सामाजिक प्रभाव (डिजिटल फुटप्रिंट, बौद्धिक संपदा अधिकार, साइबर अपराध एवं साइबर कानून, ई-कचरा)। इस विषय में प्रश्न कोड अथवा क्वेरी लिखने के रूप में पूछे जाते हैं, वर्णन के रूप में नहीं — इसीलिए पुस्तक में पूर्ण प्रोग्राम कोड उनके आउटपुट सहित दिए गए हैं, जिससे विद्यार्थी अपने परिणाम की तुलना स्वयं कर सके। प्रत्येक अध्याय में हल किए गए उदाहरण, चेकपॉइंट प्रश्न तथा प्रायोगिक असाइनमेंट सम्मिलित हैं, जो प्रैक्टिकल फाइल एवं प्रोजेक्ट कार्य हेतु उपयुक्त हैं।