Name of the Board : CBSE Academic
Class : XII STD
Document Type : Sample Question Paper SQP 2019-20
Subject : Informatics Practices
Year : 2019-20
Website : http://cbseacademic.nic.in/SQP_CLASSXII_2019_20.html
CBSE XII Informatics Practices Question Paper
Download Question Paper of Class XII Informatics Practices 2019-20 is now available in the official website of CBSE Academic.
Related : CBSE Class XII Biotechnology Sample Question Paper 2019-20 : www.pdfquestion.in/34583.html
General Instructions :
** All questions are compulsory
** Question Paper is divided into 4 sections A,B,C and D.
** Section A comprises of questions(1 and 2)
(i) Question 1 comprises Data Handling-2(DH-2)(Series,Numpy)
(ii) Question 2 comprises of question from Data Handling -2(DH-2)(Data Frames and its operations)
** Section B comprises of questions from Basic Software Engineering.
** Section C comprises of questions from Data Management-2(DM-2)
** Section C comprises of questions from Society, Law and Ethics-2(SLE-2)
Section A
Answer the following questions :
1 a) Find the output of following program.
import numpy as np
d=np.array([10,20,30,40,50,60,70])
print(d[-4:])
b) Fill in the blank with appropriate numpy method to calculate and print the variance of an array.
import numpy as np
data=np.array([1,2,3,4,5,6])
print(np.___(data,ddof=0)
c) Mr. Sanjay wants to plot a bar graph for the given set of values of subject on x-axis and number of students who opted for that subject on y-axis.
Complete the code to perform the following
(i) To plot the bar graph in statement 1
(ii) To display the graph in statement 2
import matplotlib.pyplot as plt
x=[‘Hindi’, ‘English’, ‘Science’, ‘SST’]
y=[10,20,30,40]
_____________________ Statement 1
_____________________ Statement 2
OR
Mr. Harry wants to draw a line chart using a list of elements named LIST. Complete the code to perform the following operations
(i) To plot a line chart using the given LIST,
(ii) To give a y-axis label to the line chart named “Sample Numbers”.
import matplotlib.pyplot as PLINE
LIST=[10,20,30,40,50,60]
_____________________ Statement 1
_____________________ Statement 2
PLINE.show()
d) Write the output of the following code
import numpy as np
array1=np.array([10,12,14,16,18,20,22])
array2=np.array([10,12,15,16,12,20,12])
a=(np.where(array1==array2))
print(array1[a])
e) Write a code to plot the speed of a passenger train as shown in the figure given below
f) What is series? Explain with the help of an example.
g) Write a NumPy program to create a 3×3 identity matrix, i.e. diagonal elements are 1, the rest are 0. Replace all 0 to random number from 10 to 20
OR
Write a NumPy program to create a 3×3 identity matrix, i.e. non diagonal elements are 1, the rest are 0. Replace all 0 to random number from 1 to 10
3 Answer the following questions
2 a) ______________ method in Pandas can be used to change the index of rows and columns of a Series or Dataframe
(i) rename()
(ii) reindex()
(iii) reframe()
(iv) none of the above
b) Hitesh wants to display the last four rows of the dataframedf and has written the following code
df.tail() But last 5 rows are being displayed. Identify the error and rewrite the correct code so that last 4 rows get displayed.
OR
Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] in an existing dataframe named EMP already having 2 columns.
c) Consider the following python code and write the output for statement S1
import pandas as pd
K=pd.series([2,4,6,8,10,12,14])
K.quantile([0.50,0.75]) ———————- S1
d) Write a small python code to drop a row fromdataframe labeled as 0.
e) What is Pivoting? Name any two functions of Pandas which support pivoting.
f) Write a python code to create a dataframe with appropriate headings from the list given below
[‘S101’, ‘Amy’, 70], [‘S102’, ‘Bandhi’, 69], [‘S104’, ‘Cathy’, 75], [‘S105’,
‘Gundaho’, 82]
OR
Write a small python codeto create a dataframewith headings(a and b) from the list given below
[[1,2],[3,4],[5,6],[7,8]]
g) Consider the following dataframe, and answer the questions given below
import pandas as pd
df = pd.DataFrame({“Quarter1″:[2000, 4000, 5000, 4400, 10000],
“Quarter2”:[5800, 2500, 5400, 3000, 2900],
“Quarter3”:[20000, 16000, 7000, 3600, 8200],
“Quarter4”:[1400, 3700, 1700, 2000, 6000]})
(i) Write the code to find mean value from above dataframedf over the index and column axis. (Skip NaN value)
(ii) Use sum() function to find the sum of all the values over the index axis.
(iii) Find the median of the dataframedf.
OR
Given a data frame df1 as shown below
(i) Write command to compute sum of every column of the data frame.
(ii) Write command to compute mean of column Rainfall.
(iii) Write command to compute average maxTemp, Rainfall for first 5 rows
h) Find the output of the following code
import pandas as pd
data = [{‘a’: 10, ‘b’: 20},{‘a’: 6, ‘b’: 32, ‘c’: 22}]
#with two column indices, values same as dictionary keys
df1 = pd.DataFrame(data, index=[‘first’, ‘second’], columns=[‘a’, ‘b’])
#With two column indices with one index with other name
df2 = pd.DataFrame(data, index=[‘first’, ‘second’], columns=[‘a’, ‘b1’])
print(df1)
print(df2)
i) Write the code in pandas to create the following dataframes
df1 df2
mark1 mark2mark1 mark2
0 10 150 30 20
1 40 45 1 20 25
2 15 302 20 30
3 40 703 50 30
Write the commands to do the following operations on the dataframes given above
(i) To add dataframes df1 and df2.
(ii) To subtract df2 from df1
(iii) To rename column mark1 as marks1in both the dataframes df1 and df2.
(iv) To change index label of df1 from 0 to zero and from 1 to one.
Section B
3 a) Which software model is best suitable for client server application?
(i) Waterfall
(ii) Spiral
(iii) Concurrent
(iv) None of the above
b) ____________ is the process of checking the developed software for its correctness and error free working
(i) Specification
(ii) Design/Implementation
(iii) Validation/Testing
(iv) Evolution
c) Write down any one benefit of pair programming. 1
d) In the Scrum process, a ScrumMaster differs from a traditional project manager. Justify the statement.
OR
List any two differences betweenIncremental model and Spiral model in developing complex software projects.
e) Write down any one situation where waterfall software process can be used. Also mention one advantage and one disadvantage of waterfall software process.
OR
Write down any one situation where spiral delivery model can be used. Also mention one advantage and one disadvantage of spiral delivery model.
f) Gunveen, Marshy and Aloha are three developers working on an exciting new app, and the launch day is just a day away. Gunveen creates an unmanaged package and saves it Aloha’s folder.
Marshy also writes a new piece of code and saves it in Aloha’s folder. What could go wrong on the day of the launch? Explain and also mention how version control can help teams in this scenario.
g) Draw a use case diagram and identify the actors for the situations (i) do (ii) as directed
(i) A repair can be made by a master, a trainee or any other repair shop employee.
(ii) Consider an ATM system. Identify at least three different actors that interact with this system.
Download Informatics Practices Question Paper 2019-20 :
New :
https://www.pdfquestion.in/uploads/pdf2019/34715-IPN.pdfOld :
https://www.pdfquestion.in/uploads/pdf2019/34715-IPO.pdf
Section C
4 a) Write the Django command to start a new app named ‘users’ in an existing project?
b) What is the use of COMMIT in sql ?
OR
What is the function of ALTER command?
c) CSV stands for _____________
d) NULL value means
(i) 0 value
(ii) 1 value
(iii) None value
(iv) None of the above
e) is_connected() is the MYSQL function to
(i) establish a connection to a mysql database from python.
(ii) verify whether the python application is connected to mysql database.
(iii) traverse through records in mysql database.
(iv) None of the above
f) Shewani has recently started working in MySQL. Help her in understanding the difference between the following
(i) Where and having clause
(ii) Count(column_name) and count(*)