PREETI ARORA

PREETI ARORA

DOEACC ¡®A¡¯ level, M.Sc¨CIT, M.Tech¨CIT

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

INFORMATICS PRACTICES

CLASS XI Code No. 065

Distribution of Marks

Unit No.

Unit Name

Marks

Periods

Theory

Theory

Practicals

1.

INTRODUCTION TO COMPUTER SYSTEM

5

3

2

2.

INTRODUCTION TO PYTHON PROGRAMMING

30

45

35

3.

DATA HANDLING

10

20

15

4.

DATA MANAGEMENT

15

30

20

5.

SOCIETY, LAW AND ETHICS

10

10

0

Total

70

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