PREETI ARORA

PREETI ARORA

DOEACC `A' level, M.Sc?IT, M.Tech?IT Sr. Computer Science Teacher

SULTAN CHAND & SONS (P) LTD

Educational Publishers

4859/24, Darya Ganj, New Delhi-110 002

Phones

: 4354 6000 (100 Lines), 2324 3939

Fax

: (011) 4354 6004, 2325 4295

E-mail

: scs@

Buy books online at : sultan-

ISBN: 978-93-89174-84-7

First Edition 2019 Second Thoroughly Revised and Enriched Edition 2020

All rights reserved.

No part of this book may be reproduced or copied in any form or by any means (graphic, electronic or mechanical, including photocopying, recording, taping, or information retrieval system) or reproduced on any disc, tape, perforated media or any other information storage device, etc., without the prior written permission of the publishers. Breach of this condition is liable for legal action. Anyone who brings information regarding any such reproduction will be handsomely rewarded. Publication of Key to this book is strictly prohibited. Every effort has been made to avoid errors or omissions in this publication. In spite of this, some errors might have crept in. Any mistake, error or discrepancy noted may be brought to our notice which shall be taken care of in the next edition. It is notified that neither the publishers nor the author or seller will be responsible for any damage or loss of action to anyone, of any kind, in any manner, therefrom. For faulty binding, misprints or for missing pages, etc., the publishers' liability is limited to replacement within one month of the purchase by a similar edition. All expenses in this connection are to be borne by the purchaser.

All disputes are subject to Delhi jurisdiction only.

Printed at: Goyal Offset Works (P) Limited

PREFACE

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 codes with screenshots. CTM (Commit to Memory), Learning Tip and Point to Remember for easy recall of important terms and concepts are other notable features of the book.

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 organization: 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 datatypes; 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 (Chapters 10 & 11) 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 12) Cyber safety, appropriate usage of social networks and specific usage rules. Safely accessing websites and safely communicating data. 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 ws/ipp11. We are sure the book will prove to be of immense benefit to the teachers and students alike. Constructive feedback for the improvement of the book will be highly appreciated and gratefully acknowledged. My special thanks are due to Mrs. Rinku Kumari for her value additions to the book.

Last but not the least, I take this opportunity to thank my esteemed publishers, Sultan Chand & Sons (P) Ltd, for their encouragement, assistance and patience in bringing out this book.

AUTHOR

This book has been prepared strictly in accordance with the latest available syllabus for CBSE Class XI. Any subsequent change in the syllabus will be duly taken care of and a printed supplement incorporating all the changes will be provided to students. Also, a soft copy of the supplement will be available at ws/ipp11 for FREE download.

Syllabus

Distribution of Marks

INFORMATICS PRACTICES CLASS XI Code No. 065

Unit No.

Unit Name

1. INTRODUCTION TO COMPUTER SYSTEM 2. INTRODUCTION TO PYTHON PROGRAMMING 3. DATA HANDLING 4. DATA MANAGEMENT 5. SOCIETY, LAW AND ETHICS

Total

Marks Theory

5 30 10 15 10 70

Periods

Theory Practicals

3

2

45

35

20

15

30

20

10

0

108

72

Unit 1: INTRODUCTION TO COMPUTER SYSTEM Basic computer organization: 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 2: INTRODUCTION TO PYTHON PROGRAMMING

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: integer, float, string. Introduce the notion of variable, and methods to manipulate it (concept of L-value and R-value even if not taught explicitly). Tokens--keywords, Identifiers, Literals, Delimiters. Knowledge of data type and operators: accepting input from the console, assignment statement, expressions, operators (assignment, arithmetic, relational and logical) and their precedence.

Conditional statements: if, if-else, if-elif-else; simple programs: e.g., absolute value, sort 3 numbers, divisibility.

Notion of iterative computation and control flow: for (range() , len()), while, flow charts.

Suggested programs: finding average and grade for given marks, amount calculation for given cost-qty-discount, perimeter-wise/area-wise cost calculation, interest calculation, profit-loss, EMI, tax calculation (example from GST/Income Tax).

List and dictionary: finding the maximum, minimum, mean; linear search on a list of numbers, and counting the frequency of elements in a list using a dictionary.

Text handling: compare, concat, and substring operations (without using string module).

Introduction to Python modules: importing math (sqrt, ceil, floor, pow, fabs), random (random, randint, randrange), statistics (mean, median) modules.

Unit 3: DATA HANDLING NumPy 1D array, 2D array. Arrays: slices, joins, and subsets. Arithmetic operations on 2D arrays.

Unit 4: DATA MANAGEMENT

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 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-FROMWHERE-ORDER BY along with BETWEEN, IN, LIKE. (Queries only on single table)

Aggregate Functions: MIN, MAX, AVG, COUNT, SUM

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download