KENDRIYA VIDYALAYA SANGTHAN - KVS
KENDRIYA VIDYALAYA SANGTHAN
REGIONAL OFFICE, RAIPUR An Autonomous Body under the Ministry of Education,
Government of India
INFORMATICS PRACTICES SESSION 2020-21 CLASS-XII
STUDENT SUPPORT MATERIAL
ADVISORS
Ms. Chandana Mandal, Deputy Commissioner, KVS RO RAIPUR
Smt.BIRAJA MISHRA Assistant Commissioner
Shri A.K.MISHRA Assistant Commissioner
CO-ORDINATION TEAM Shri VIKAS GUPTA, PRINCIPAL KV JAGDALPUR Shri RAHUL DEV, PRINCIPAL Gr-II, K.V.SARAIPALI
CONTENT TEAM Shri. PRAKASH KUMAR DEWANGAN, PGT C.S. K.V. RAIPUR No-1 Shri. ARVIND BHATPAHARE, PGT C.S. RAIPUR No-2 Smt. ANSHU SINHA, PGT C.S, KORBA NO-3 KUSMUNDA Smt. TARA YADAV. PGT C.S. K.V. BILASPUR Shri. MOHNISH SAHU, PGT C.S., K.V. DANTEWADA
REVIEW TEAM Shri. VIKAS GUPTA, PRINCIPAL KV JAGDALPUR Shri. RAHUL DEV, PRINCIPAL Gr-II, K.V.SARAIPALI Shri. AMIT NATH, PGT CS , K V AMBIKAPUR
EDITING AND COMPILATION TEAM
Shri. AMIT NATH, PGT ICNS ,DK EV AXMPBIAKAGPUER
INDEX PAGE
UNIT NO.
1
UNIT NAME
REVISED SYLLABUS & DELETED PORTIONS
2
SPEICAL REVISION PLAN FOR REVISION
3
DAY WISE REVISION PLAN FOR REVISION
4
DAY WISE REVISION PLAN FOR BRIGHT LEARNERS
4
MIND MAP FOR PANDAS LIBRARY
5
MIND MAP PANDAS DATAFRAME -I
6
MIND MAP MYSQL CATEGORY OF COMMANDS
7
MIND MAP MYSQL AGGREGATE QUERIES
8
MIND MAP MYSQL AGGREGATE FUNCTION
9
MIND MAP NETWORKING - I
10 MIND MAP NETWORKING ? II
11 MIND MAP SOCIAL IMPACT
12 E-WASTE MANAGEMENT
13 VSA / SA / LA TYPE OF QUESTION SECTION
14 UNIT WISE FAQ
15 02 SAMPLE PAPER AND THEIR MARKING SCHEME
PAGE NO. 1-5 6-8 9-13 14-18 19 20 21 22 23 24 25 26 27-28 29-70
71-108 109
Informatics Practices
CLASS XII Code No. 065
2020-2021
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. Perform aggregation operations, calculate descriptive statistics. Visualize data using relevant graphs. Design SQL queries using aggregate functions. Import/Export data between SQL database and Pandas. Learn terminology related to networking and internet. Identify internet security issues and configure browser settings. Explain 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
30
25 7 8 30 100
Periods Theory 50
Periods Practical
40
Total Period 90
30
22
52
12
2
14
14
-
14
-
10
10
-
-
-
106
74
180
1
................
................
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.