XII IP TSK QP PB
XII IP TSK QP PB
XII IP TSK QP PB
MARKING SCHEME
Class XII – Informatics Practices
SECTION A
1. iii. Gateway 1
2. iv.All of Above 1
3. i.read_csv() 1
4. iii. SELECT * FROM PRODUCT ORDER BY PRICE DESC; 1
5. ii.Accessing someone’s e-mail without permission 1
6. B. NP.tail(2) 1
7. iii. Open Source Software 1
8. (b) 3200.00 1
9. i. INSTR() 1
10. d. Batsman .size 1
11. (i) Column labels 1
12. c)MONTHNAME() 1
13. c) Hacking 1
14. b) 3 1
15. iii.SUBSTR() 1
16. iv. Intellectual Property Right 1
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as a. Both A and R are true
and R is the correct explanation for A b. Both A and R are true and R is not the correct explanation for A c. A is True but
R is False d. A is false but R is True
17. B 1
18. A 1
SECTION B
19. 2 marks for correct difference or definition. 2
20. 0 50 2
3 40
21. import pandas as pd 2
Months = [‘Jan’, ‘Feb’, ‘Mar’, ‘Apr’, ‘May’, ‘Jun’, ‘Jul’, ‘Aug’, ‘Sep’, ‘Oct’, ‘Nov’, ‘Dec’]
Days = [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31]
Monthdays = pd.Series( data = Days, index = Months)
print(Monthdays)
22. 2 marks for correct explanation. 2
23. i. index([‘A1’, ‘B1’, ‘C1’, ‘E1’]) 2
ii. index([1, 2])
1 mark for each correct answer.
24. 1 mark for each correct answer. 2
25. 2 marks for correct answer. 2
SECTION C
26. 1 mark for each correct answer. 3
27. 3 marks for correct program. 3
28. 1 mark for each correct answer 3
29. 1 mark for creating database, 2 marks for creating table. 3
30. 1 mark for each correct answer 3
SECTION D
31. 1 mark for each correct answer. 4
32. i. 1 mark for each correct output (1+1) 4
ii. 1 mark for correct answer
iii. 1 mark for correct answer
SECTION E
33. 1 mark for each correct answer. 5
34. 4 marks for correct plotting 5
1 marks for saving the chart.
35. 1 mark for each correct answer. 5