Informatics Practices with Python: Textbook for CBSE Class 11

The book, Informatics Practices with Python: textbook for CBSE Class 11, aims at providing an in-depth understanding of the CBSE curriculum for the 2019-20 academic session. It focuses on teaching Python language to help students learn programming concepts and develop problem-solving skills and RDBMS operations. With easy-to-understand examples, flow charts, 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 code with screenshots. Strictly adhering to the CBSE curriculum for Informatics Practices (065) for Class XI, the book has been divided into five units:

Unit I: introduction to Computer system (br>Chapter 1) Basic computer organisation: computer system — I/br>o devices,

cpu, memory, hard disk, battery, power, transition from a calculator to a computer and further to smart devices; troubleshooting with parts of computer and basic operations of Operating system; basic concept of data representation: Binary, ASCII, Unicode.

unit II: introduction to Python programming (chapters 2 to 8) familiarization with the basics of Python programming: a simple “Hello world” program, process of writing a program, running it, and print statements; simple data-types; tokens — Keywords, operators, conditional statements,

looping constructs, flow charts, strings handling, lists, dictionaries and modules.

unit III: data Handling (br>Chapter 9) NumPy 1D array, 2D array; arrays: slices, joins and subsets; Arithmetic operations on 2D arrays.

unit IV: data management (br>Chapter 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, modify table, drop table, keys, and Foreign keys; to view content of a table: select-from-where-order by along with between, in, like (queries only on single table) and Aggregate functions.

unit V: society, law and ethics (br>Chapter 11) Cyber safety, appropriate usage of social networks and specific usage rules. Safely accessing web sites and safely communicating data. The book includes three appendices comprising installation guide to Python, detailed built-in string methods and viva voce questions. Besides, presentation on Python, Chapter-wise program codes, practical file, Sample Question Paper, model test papers for practice and Python software dump are available online and can be accessed at sultan-chand.Com/Ws/IPP11.