This book, Informatics Practices with Python for Class XI (065), has been preparedin accordance with the syllabus for the academic year 2020-21. The book focuses on teaching Python language to help students learn programming concepts and develop problem-solving skills and RDBMS operations. With easy-to-understand examples, self-explanatory diagrams and other such tools, the student learns to design the logic for a program and then implement that program using Python. In addition, the book contains ample concise and practical example programs along with diagrams and instances from real-life situations. Each chapter consists of tested, debugged and error-free codes with screenshots. CTM (Commit to Memory), Learning Tips and Points to Remember for easy recall of important terms and concepts are other notable features of the book. Strictly adhering to the CBSE curriculum and guidelines, the book has been divided into five units:

Unit I: Introduction to Computer System (Chapter 1)

Introduction to computer and computing: Evolution of computing devices, components of a computer system and their interconnections, Input/Output devices; Concept of computer memory, units of memory, types of memory primary and secondary; Data deletion, its recovery and related security concerns; Software: purpose and types system and application software, generic and specific-purpose software.

Unit II: Introduction to Python (Chapters 2 to 6)

Basics of Python programming; Python interpreter interactive and script mode; Structure of a program, process of writing a program, running it and print statements; Simple data types; TokensKeywords, Operators, Conditional Statements, Looping Constructs, Lists and Dictionaries.

Unit III: Data Handling using NumPy (Chapters 7 & 8)

Data and its purpose; Importance of data; Structured and unstructured data; Data processing cycle; Basic statistical methods for understanding data mean, median, mode, standard deviation and variance. Introduction to NumPy library; NumPy arrays and their advantages; Creation of NumPy arrays; Indexing, slicing and iteration; Concatenating and splitting array; Arithmetic operations on one-Dimensional and two-Dimensional arrays.

PREFACE

Unit IV: Database Concepts and the SQL (Chapters 9 & 10)

Relational databases: Concept of a database, relations, attributes and tuples; Keys candidate key, primary key, alternate key, foreign key; Degree and Cardinality of a table; Use of SQL DDL/DML commands to CREATE TABLE, INSERT INTO, UPDATE TABLE, DELETE FROM, ALTER TABLE, DROP TABLE, to view content of a table: SELECT-FROM-WHERE.

Unit V: Introduction to Emerging Trends (Chapter 11)

Artificial Intelligence; Machine Learning; Natural Language Processing; Immersive experience (AR, VR); Robotics; Big data and its characteristics; Internet of Things (IoT); Sensors; Smart cities; Cloud Computing and Cloud Services (SaaS, IaaS, PaaS); Grid Computing and Blockchain technology.The book also includes ample Viva Voce questions. Besides, Presentation on Python, Chapter-wise Program Codes, Practical File, Sample Question Papers, Model Test Papers for practice and Python Software Dump are available online and can be accessed at sultan-chand.com/ws/ipp11.