केंद्रmय विद्यालय संगठन क्षेत्रmय कायाालय रायपnर

[Pages:159]

Kendriya Vidyalaya Sangathan Regional Office Raipur

Class - XII Multiple Choice Question Bank

[MCQ ] Term ? I & Term- II

Informatics Practices [065]

Based on Latest CBSE Exam Pattern for the Session 2021-22

Kendriya Vidyalaya Sangathan Regional Office Raipur

MESSAGE FROM DUPUTY COMMISSIONER

It is a matter of great pleasure for me to publish study material for different subjects of classes X and XII for Raipur Region. Getting acquainted and familiarized with the recent changes in curriculum and assessment process made by CBSE vide Circular No. 51 and 53 issued in the month of July 2021 will help students to prepare themselves better for the examination. Sound and deeper knowledge of the Units and Chapters is must for grasping the concepts, understanding the questions. Study materials help in making suitable and effective notes for quick revision just before the examination.

Due to the unprecedented circumstances of COVID-19 pandemic the students and the teachers are getting very limited opportunity to interact face to face in the classes. In such a situation the supervised and especially prepared value points will help the students to develop their understanding and analytical skills together. The students will be benefitted immensely after going through the question bank and practice papers. The study materials will build a special bond and act as connecting link between the teachers and the students as both can undertake a guided and experiential learning simultaneously. It will help the students develop the habit of exploring and analyzing the Creative & Critical Thinking Skills. The new concepts introduced in the question pattern related to case study, reasoning and ascertain will empower the students to take independent decision on different situational problems. The different study materials are designed in such a manner to help the students in their self-learning pace. It emphasizes the great pedagogical dictum that `everything can be learnt but nothing can be taught'. The self-motivated learning as well as supervised classes will together help them achieve the new academic heights.

I would like to extend my sincere gratitude to all the principals and the teachers who have relentlessly striven for completion of the project of preparing study materials for all the subjects. Their enormous contribution in making this project successful is praiseworthy.

Happy learning and best of luck!

Vinod Kumar (Deputy Commissioner)

2|Page

Kendriya Vidyalaya Sangathan Regional Office Raipur

Our Patorn

Vinod Kumar

Deputy Commissioner KVS RO Raipur

Smt.Biraja Mishra Assistant Commissioner KVS RO Raipur

Sh.A.K. Mishra Assistant Commissioner

KVS RO Raipur

3|Page

SUBJECT CO-ORDINATION BY

Mrs. Sandhya Lakra, Principal, KV No. 4 Korba

CONTENT TEAM

? Mr. Khumendra Bisen, PGT CS, KV BMY Bhilai ? Mr. Prakash Kumar Dewangan, PGT CS, KV No. 1 Shift II Raipur ? Mrs. Anshu Sinha, PGT CS, KV No. 3 Korba Kusmunda SECL ? Mr. Amit Nath, PGT CS, KV Ambikapur ? Mrs. Priyanka Kulshresta, PGT CS, KV Dongargarh ? Mr. Amarnath Pathak, PGT CS, KV Khairagarh

COMPILATION, REVIEW & VETTING BY

Mr. Sumit Kumar Choudhary, PGT CS, KV No. 2 Korba NTPC

4|Page

TABLE OF CONTENTS

S.

TERM - 1

No.

(Click the LINK to directly reach the content) 1 DISTRIBUTION OF MARKS

2 SYLLABUS 3 DATA HANDLING USING

PANDAS AND DATA VISUALIZATION 4 SOCIETAL IMPACTS

5 MODEL QUESTION PAPER SET 1 SET 2 SET 3

TERM - 2

Page Number

06

(Click the LINK to directly reach the content)

DISTRIBUTION OF MARKS

Page Number 06

07-08 11-46

SYLLABUS DATABASE QUERY USING SQL

09-10 92-119

47-68 69-91

INTRODUCTION TO COMPUTER NETWORKS MODEL QUESTION PAPER

SET 1

SET 2

SET 3

120-136 137-156

5|Page

Informatics Practices CLASS XII Code No. 065

2021-2022

1. Prerequisite: Informatics Practices ? Class XI

2. Learning Outcomes At the end of this course, students will be able to: Create Series, Data frames and apply various operations. Visualize data using relevant graphs. Design SQL queries using aggregate functions. Learn terminology related to networking and the internet. Identify internet security issues and configure browser settings Understand the impact of technology on society including gender and disability issues.

3. Distribution of Marks and Periods:

Unit Unit Name No

1 Data Handling using Pandas and Data Visualization

2 Database Query using SQL 3 Introduction to Computer Networks 4 Societal Impacts

Project Practical Total

Marks 25

Periods Theory

25

Periods Practical

25

25

20

17

10

12

0

10

14

-

-

-

7

30

-

-

100

71

49

Total Period

50

37 12 14 7 120

6|Page

Syllabus for Term ? 1 Distribution of Theory Marks

Unit No 1

4

Unit Name Data Handling using Pandas and Data Visualization Societal Impacts Total

Marks 25

10 35

Unit 1:

Data Handling using Pandas and Data Visualization Data

Handling using Pandas -I Introduction to Python libraries- Pandas, Matplotlib. Data structures in Pandas - Series and data frames. Series: Creation of series from dictionary, scalar value; mathematical operations; series attributes, head and tailfunctions; selection, indexing and slicing.

Data Frames: creation of data frames from dictionary of series, list of dictionaries, text/CSV files, display, and iteration. Operations on rows and columns: add (insert /append), select, delete (drop column and row), rename, Head and Tail functions, indexing using labels, Boolean indexing.

Data Visualization

Data Visualization: Purpose of plotting, drawing and saving of plots using Matplotlib (line plot, bar graph, histogram). Customizing plots: adding label, title, and legend in plots.

Unit 4: Societal Impacts Digital footprint, net and communication etiquettes, Data protection, intellectual property rights (IPR), plagiarism, licensing and copyright, Free and open source software (FOSS), Cybercrime and cyber laws, hacking, phishing, cyber bullying, overview of Indian IT Act. E-waste: hazards and management. Awareness about health concerns related to the usage of

technology.

7|Page

Distribution of Practical Marks

Topic

Marks

Pandas program (pen and paper or Collab or any online idle or pyroid screen for mobile) 8

Practical File 15 Pandas Programs

3

Project synopsis

2

Viva

2

Total

15

Suggested Practical List Data Handling

1. Create a panda's series from a dictionary of values and a ndarray 2. Given a Series, print all the elements that are above the 75th percentile. 3. Create a Data Frame quarterly sales where each row contains the item category, item name,

and expenditure. Group the rows by the category and print the total expenditure per category. 4. Create a data frame for examination result and display row labels, column labels data types of

each column and the dimensions 5. Filter out rows based on different criteria such as duplicate rows. 6. Importing and exporting data between pandas and CSV file

Visualization 1. Given the school result data, analyses the performance of the students on different parameters,

E.g. subject wise or class wise. 2. For the Data frames created above, analyse, and plot appropriate charts with title and legend. 3. Take data of your interest from an open source (e.g. .in), aggregate and summarize it.

Then plot it using different plotting functions of the Matplotlib library.

Project Synopsis The synopsis should cover the brief description about the project along with reasons for selection of the dataset. The learner should write the source of the dataset whether created or taken from any reliable source. The learner should write what analytics can be done on the project.

.

Syllabus for Term ? 2

8|Page

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

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

Google Online Preview   Download