SSSaraswatiaraswatiaraswati IIINFORMATICS P P PRACTICES ...

ite

d

Li

m

iv

a

te

Saraswati

In

di

a

TEXTBOOK FOR CLASS XII]

se

[A

Pr

INFORMATICS PRACTICES

ou

By

Gagan Sahoo

M.C.A.

M.C.A.

@

N

ew

Sa

ra

sw

at

iH

Reeta Sahoo

New Sa aswati

r

House (India) Private Limited

New Delhi-110002 (INDIA)

ite

d

Li

m

e

Head Office : Second Floor, MGM Tower, 19 Ansari Road, Daryaganj, New Delhi¨C110 002 (India)

Registered Office : A-27, 2nd Floor, Mohan Co-operative Industrial Estate, New Delhi¨C110 044

Pr

iv

at

Phone

: +91-11-4355 6600

Fax

: +91-11-4355 6688

E-mail

: delhi@

Website :

CIN

: U22110DL2013PTC262320

Import-Export Licence No. 0513086293

In

di

a

Branches:

ou

se

? Ahmedabad: Ph. 079-2657 5018 ? Bengaluru: Ph. 080-2675 6396

? Chennai: Ph. 044-2841 6531 ? Bhubaneswar: Ph. +91-94370 05810

? Guwahati: Ph. 0361-2457 198 ? Hyderabad: Ph. 040-4261 5566 ? Jaipur: Ph. 0141-4006 022

? Jalandhar: Ph. 0181-4642 600, 4643 600 ? Kochi: Ph. 0484-4033 369 ? Kolkata: Ph. 033-4004 2314

? Lucknow: Ph. 0522-4062 517 ? Mumbai: Ph. 022-2876 9871, 2873 7090

? Patna: Ph. 0612-2275 403 ? Ranchi: Ph. 0651-2244 654 ? Nagpur: Ph. +91 9371940224

H

Revised edition 2019

Reprinted 2020

at

i

ISBN: 978-93-53621-34-6

The moral rights of the author has been asserted.

Sa

ra

s

w

? New Saraswati House (India) Private Limited

Jurisdiction: All disputes with respect to this publication shall be subject to the jurisdiction of the Courts, Tribunals and

Forums of New Delhi, India Only.

ew

All rights reserved under the Copyright Act. No part of this publication may be reproduced, transcribed, transmitted,

stored in a retrieval system or translated into any language or computer, in any form or by any means, electronic,

mechanical, magnetic, optical, chemical, manual, photocopy or otherwise without the prior permission of the

copyright owner. Any person who does any unauthorised act in relation to this publication may be liable to criminal

prosecution and civil claims for damages.

@

N

Product Code: NSS3IPC120CSCAB19CBN

This book is meant for educational and learning purposes. The author(s) of the book has/have taken all reasonable

care to ensure that the contents of the book do not violate any copyright or other intellectual property rights of any

person in any manner whatsoever. In the event the author(s) has/have been unable to track any source and if any

copyright has been inadvertently infringed, please notify the publisher in writing for any corrective action.

PRINTED IN INDIA

By Vikas Publishing House Private Limited, Plot 20/4, Site-IV, Industrial Area Sahibabad, Ghaziabad¨C201 010 and

published by New Saraswati House (India) Private Limited, 19 Ansari Road, Daryaganj, New Delhi¨C110 002 (India)

ite

d

Preface

Li

m

Informatics Practices book is designed as per the new syllabus prescribed by CBSE for class - XII. This

book covers advanced operations on Pandas DataFrame, descriptive statistics, histogram, function

application, etc. NumPy array is used to handle multi-dimensional array objects. Software engineering,

database management using MySQL, computing ethics and cyber safety are the other highlights of

the book.

e

The salient features of the book are:

Easy-to-understand aggregation operations, descriptive statistics, and re-indexing columns in a

DataFrame.

2.

Learn to plot different graphs using pandas DataFrame.

3.

Apply functions row-wise and element-wise on a Data Frame.

4.

Detailed explanation of the know how to NumPy array used for scientific computing applications

including covariance, correlation and linear regression.

5.

NumPy array discussed in detail to handle multi-dimensional array object.

6.

Understanding of the basic software engineering: models, activities, business use-case diagrams,

and version control systems.

7.

Know-hows to connect a Python program with a SQL database, and learn aggregation functions

in SQL.

8.

A clear understanding of cyber ethics and cybercrime. Helps to understand the value of technology

in societies, gender and disability issues, and the technology behind biometric ids.

H

ou

se

In

di

a

Pr

iv

at

1.

w

at

i

This new edition provides you with an updated knowledge based on plenty of solved exercises and

unsolved questions. It includes complete and easily understandable explanations of the commonly

used features of Python pandas DataFrame, NumPy and MySQL. The questions and examples will

enable students to test their knowledge and understanding.

Sa

ra

s

Many solved and unsolved examples are provided at the end of each chapter. It also contains a CD

with a folder called IPSource_XII which includes chapter-wise solved examples and can be made

available on demand.

Also, we would like to convey our sincere thanks to the dedicated team of New Saraswati House

(India) Pvt. Ltd. for bringing out this book in an excellent form.

@

N

ew

Suggestions for further improvement of the book will be gratefully acknowledged.

Reeta Sahoo & Gagan Sahoo

Phone: 011-42953418

Mobile No.: 9818588644

E-mail: gbsahoo@

SYLLABUS

Unit Name

Periods

Marks

Theory

Practical

Data Handling - 2

80

70

2.

Basic Software Engineering

25

10

3.

Data Management - 2

20

20

4.

Society, Law and Ethics - 2

15

5.

Practicals

Pr

iv

at

e

1.

Li

m

Unit No.

ite

d

UNIT¨CWISE MARKS (THEORY)

15

15

10

30

100

In

di

a

Total

30

Unit 1: Data Handling (DH-2)

H

ou

se

Python Pandas

? Advanced operations on Data Frames: pivoting, sorting, and aggregation

? Descriptive statistics: min, max, mode, mean, count, sum, median, quartile, var

? Create a histogram, and quantiles.

? Function application: pipe, apply, aggregation (group by), transform, and apply map.

? Reindexing, and altering labels.

Sa

ra

s

w

at

i

Numpy

? 1D array, 2D array

? Arrays: slices, joins, and subsets

? Arithmetic operations on 2D arrays

? Covariance, correlation and linear regression

Plotting with Pyplot

?

Plot bar graphs, histograms, frequency polygons, box plots, and scatter plots.

ew

Unit 2: Basic Software Engineering (BSE)

@

N

?

?

?

?

?

?

?

Introduction to software engineering

Software Processes: waterfall model, evolutionary model, and component based model

Delivery models: incremental delivery, spiral delivery

Process activities: specification, design/implementation, validation, evolution

Agile methods: pair programming, and Scrum

Business use-case diagrams

Practical aspects: Version control system (GIT), and do case studies of software systems and

build use-case diagrams.

Unit 3: Data Management (DM-2)

Write a minimal Django based web application that parses a GET and POST request, and writes

the fields to a file ¨C flat file and CSV file.

?

Interface Python with an SQL database

?

SQL commands: aggregation functions, having, group by, order by.

Li

m

ite

d

?

Unit 4: Society, Law and Ethics (SLE-2)

?

e

Intellectual property rights, plagiarism, digital rights management, and licensing (Creative

Commons, GPL and Apache), open source, open data, privacy.

Privacy laws, fraud; cybercrime- phishing, illegal downloads, child pornography, scams; cyber

forensics, IT Act, 2000.

Technology and society: understanding of societal issues and cultural changes induced by

technology.

E-waste management: proper disposal of used electronic gadgets.

Identity theft, unique ids, and biometrics.

Gender and disability issues while teaching and using computers.

Role of new media in society: online campaigns, crowdsourcing, smart mobs

Issues with the internet: internet as an echo chamber, net neutrality, internet addiction

Case studies - Arab Spring, WikiLeaks, Bit coin

iv

at

?

Pr

?

ou

se

In

di

a

?

?

?

?

?

?

H

Practical

S. No.

Unit Name

at

i

1.

Marks (Total = 30)

Lab Test (10 marks)

Sa

ra

s

w

Python programs for data handling (60% logic + 20%

documentation + 20% code quality)

Small Python program that sends a SQL query to a database and

displays the result. A stub program can be provided.

3

Report File + viva (9 marks)

Report file: Minimum 21 Python programs. Out of this at least 4

programs should send SQL commands to a database, and retrieve

the result; at least 1 program should implement the web server

to write user data to a CSV file.

7

Viva voce based on the report file

2

@

N

ew

2.

7

3.

Project + viva (11 marks)

Project (that uses most of the concepts that have been learnt)

8

Project viva voce

3

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

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

Google Online Preview   Download