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.
This book, Informatics Practices with Python for Class XI (065), has been prepared
in accordance with the latest CBSE syllabus. 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. Besides tested, debugged and
error-free codes with screenshots, ample concise and practical example programs
derived from real-life situations have been provided in the book. 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 four 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, Indentation; Process of writing a program, running it and
print statements; Data Types; Data Type Conversion; Tokens—Keywords, Identifiers,
Constants, Variables; Operators—Types of Operators, Precedence of Operators;
Debugging; Conditional Statements, Looping Constructs, Operations and Functions
in Lists and Dictionaries.
PREFACE
Unit III: Database Concepts and SQL (Chapters 7 & 8)
Introduction to Database concepts and the need for Database; Database Management
System; Relational Data Model: Concept of Domain, Tuple, Attribute, Relation,
Candidate key, Primary key, Alternate key; Advantages of using Structured Query
Language, Data Definition Language, Data Query Language and Data Manipulation
Language; Introduction to MySQL, Creating a Database using MySQL; Data
Types; Data Definition: CREATE TABLE; Data Query: SELECT, FROM, WHERE;
Data Manipulation: INSERT.
Unit IV: Introduction to Emerging Trends (Chapter 9)
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 includes four appendices containing a Sample Question Paper (Solved)
based on the Board Sample Paper, a Model Test Paper for practice, ample Viva Voce
questions and a brief description about NumPy library. Besides, Presentation on
Python, Chapter-wise Program Codes, Practical File, Sample Question Papers, Model
Test Papers and Python Software Dump are available online and can be accessed at
sultan-chand.com/ws/ipp11.