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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction to python for econometrics statistics and
- informatics practices academics
- installing gdal for python on windows
- preeti arora
- about the tutorial
- python for finance
- python for data science cheat sheet lists also see numpy
- images and resampling simpleitk
- scikit learn
- an introduction to numpy and scipy ucsb college of