Informatics Practices with Python: A Textbook for CBSE Class XI
Information and Communication Technology has permeated every walk of life impacting technology fields such as launching satellites, managing businesses across the globe and enabling social networking. The convergence of computer, communication and content technologies, known as ICT, has drawn the attention of the academia, business, government and communities to use it for innovative profitable propositions. The syllabus of Informatics Practices has been revisited accordingly with focus on generic concepts with domain-specific practical experiments and projects to ensure conceptual knowledge with practical skills.
The book, Informatics Practices with Python, aims at providing an in-depth understanding of the CBSE curriculum. 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 (Chapter 1)
Basic computer organisation: Computer system — I/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 (Chapter 9)
Numpy 1D array, 2D array; Arrays: slices, joins and subsets; Arithmetic operations on 2D arrays.
Unit IV: Data Management (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 (Chapter 11)
Cyber safety, appropriate usage of social networks and specific usage rules. Safely accessing websites 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.
Pane 2 Content
and so on ...