1 A. WRITE THE FULL FORMS OF THE FOLLOWING;
a. HMI ____________________________________
b. VR ____________________________________
c. AR
d. VUIs
e. GUIs
f. BCIs
2 B. FILL IN THE BLANKS (Computer vision, Financial records, Machine learning, NLP, Deep learning,
a. Google Translate in an example of ____________________.
b. Virtual assistants like Siri and Alexa are examples of___________.
c. ________________________ replicated the identification of the human vision system.
d. _____________________________ immitates the way human learn from the experience.
e. ________________ mimics data processing methods of the human brain.
f. ________________________ are well structured data.
3 C. STATE TRUE OR FALSE
a. GUIs interfaces are generally used in smartphones and tablets.
b. Touchscreen interfaces allows easy and quick finger based interaction c. Log files and NoSQL databases are examples of semi structured data.
c. Log files and NoSQL databases are examples of semi structured data.
d. Computer vision can be helpful in sports and agricultural fields
e. Ambiguity in text and voice tone of humans is a challenge in NLP.
4 D. ANSWER IN 1-2 WORDS
a. Which devices are used to detect and interpret human gestures?
b. Which interface allows direct communication between the brain and machine?
c. Name two sources of unstructured data.
5 E. SHORT ANSWER QUESTIONS.
a. How is eye tracking system useful for interaction with machine?
b. Define computer vision.
6 F. LONG ANSWER TYPE QUESTIONS
a. Define big data with its characteristics
b. Differentiate between structured and unstructured data with examples
c. What do you mean by Natural Langugae Processing?
7 G. SITUATIONAL QUESTION
a. Riya is a student of st. francis senior secondary school. She is creating a presentation for yoga day. While she needs to present her idea in the English language she is finding the data of her choice in hindi language. Which AI facility will be helpful to her? i. Machine learning ii. Google translate iii. Eye tracking system
1 A. FILL IN THE BLANKS (Filters, descending, Top/Bottom, style, ascending)
a. Conditional formatting option if found in _________________ group.
b. __________ can be used to narrow down the data in your worksheet
c. Sorting can be done________________ and ___________________ order.
d. __________________ rules let you format the top or bottom percentage or number of cells in a range.
2 B. MATCH THE FOLLOWING
3 C. ANSWER IN 1-2 WORDS
a. In which group and tab is the sorting option found?
b. Where is the grouping indicator found?
4 D. SHORT ANSWER QUESTIONS
a. What are the four filter options? List them.
b. How can we select multiple consecutive worksheets?
5 E. LONG ANSWER TYPE QUESTIONS
a. What do you mean by sorting? List various ways of sorting.
b. How is grouping of worksheets useful?
6 F. SITUATIONAL QUESTIONS
1 A. MULTIPLE CHOICE QUESTIONS.
a. _______________ provides a brief description of the chart. i. Legend ii. Chart title iii. Gridlines
b. A ____________is a small, condensed chart that provides a visual representation of data trends or variations within a single cell in Microsoft Excel. i. Sparkline ii. Legend
c. Which chart combines two or more different chart types into a single chart? ii. Combo charts ii. Bar chart iii. Pie chart
d. What is the shortcut key to create charts? i. F8 ii. F10 iii. F11
2 B. STATE TRUE OR FALSE
a. X-axis is the verticall axis and Y-axis is the horizontal axis.
b. As the data is changed excel automatically updates the chart reflecting the data change.
c. Chart and graphs are very helpful in the process of decision making.
d. To resize the chart proportionally, click and drag one of the corner handles.
e. Combo charts allow you to visualize and compare multiple sets of data that may have different scales or units of measurement in a single chart.
3 C. ANSWER IN 1- 2 WORDS
a. In which tab is the chart group found?
b. List three options of Sparkline charts
a. List some advantages of using charts.
b. What is the use of legend in a chart?
c. How are gridlines helpful in a chart?
a. What is the difference between chart area and plot area?
b. Write the steps to insert a chart in Excel.
a. Mr Jasbeer generated a chart in MS Excel 2016 on the basis of data of sales at his store? Later the data was updated. Which of the following statements is true? i. The chart needs to be manually updated. ii. The chart gets updated automatically. iii. The chart has to be regenerated as it can not be updated.
1 A. FILL IN THE BLANKS (Unary, //, Debugging, **, bug)
a. ____________ is the process of detecting and removing existing and potential errors
b. __________ operators work with a single operand (value or variable).
c. __________ is the symbol for Floor division.
d. A ___________is a general term used to describe any unexpected problem.
e. The _______________ operator is the right associative operator.
a. Repetition operators are not applicable on strings.
b. Syntax errors occur when the code violates the rules of the programming language's syntax.
c. Operator associativity defines the priority or hierarchy of operators in an expression.
d. Bug may cause a program to unexpectedly quit or behave in an unintended manner.
a. Which type of operators work with two operands?
b. What type of error is incorrect conditional statements?
a. List all the arithmetic operators in python with their names.
b. What is the use of the concatenation operator of string?
5 E. LONG ANSWER TYPE QUESTIONSS
a. What is the difference between = and == operators?
b. What do you mean by operator associativity?
a. Madhu is a python developer in mystro limited. She is trying to find the remainder after division of two numbers in her program. Which of the following is the correct operator? ii. / ii. // iii. %
1 A. MULTIPLE CHOICE QUESTION.
a. How many important control structures are there in Python? ii. 3 ii. 4 iii. 5
b. Which punctuation should be used in the blank? if _ statements-block 1 else: statements-block 2 ii. ; ii. : iii. ::
c. The order of execution of statements in a program is known as _________ ii. Flow of control ii. Selection iii. Iteration
d. An if condition inside another if is called_____________ ii. Nested if ii. elif iii. Secondif
e. _________________ is an empty statement in python ii. break ii. continue iii. pass
2 B. FILL IN THE BLANKS (Multiple conditions, terminates, variable, Sequential.)
a. All the statements of the program are executed one after another in _________________ flow control.
b. if-elif statements are used in case of ______________________.
c. When the condition in the loop become false, the loop _________________
d. For <________________> in : Body of the loop
a. List the control structures in Python.
b. What is the use of step in "range (start,stop,[step])"?
c. Write the syntax of simple if statement
a. Write a note on the break statement.
b. When do we use While loop?
a. What is the nested if statement? Explain with flow diagram.
b. Explain the use of membership operators?
c. What is an infinite loop? List the reason for the creation of an infinite loop.
a. Ram wants to check whether a year entered is a leap year or not. For this he should have good understanding of __________ ii. Conditional statement ii. For loop iii. While loop
1 A. FILL IN THE BLANKS ( Effect button, play head, preview, import.)
a. Project file option allows you to ______________ files into the project.
b. _______________ provides various effects to be applied in the project.
c. The _____________ window displays the current frame or video playback.
d. Red vertical line on the timeline is called the________________ .
2 B. ANSWER IN 1-2 WORDS
a. List the operating systems which support OpenShot video editor?
3 C. SHORT ANSWER TYPE QUESTIONS
a. Why do we apply effects?
b. Define transitions.
4 D. LONG ANSWER TYPE QUESTIONS
a. List any four features of OpenShot video editor.
b. What is the use of play head?
5 E. SITUATIONAL QUESTIONS
1 A. FILL IN THE BLANKS (src, height, Normal State, width, Link Text, Border)
a. ______________ specifies the source URL of the image.
b. __________________ attribute is used to specify the thickness of the image.
c. _________________is the default appearance of a link when it hasn't been interacted with.
d. ______________ is the visible text or content of the link that users can click on.
e. The size of the image can be modified using _______________ and _______________ attribute.
a. Visited links often change color usually to purple.
b. To embed an audio file on your web page, use the video element.
c. HTML frames are used to divide your browser window into multiple sections where each section can load a separate HTML document.
d. Border: width style color will define the border of frames
a. What does href stand for?
b. Which attribute adds audio playback controls ?
a. What is fallback text?
b. What is the use of hyperlink?
a. How can we make an image as a link?
b. What do you mean by link states?
c. What is the use of Inline Frame?
a. The base of the _______________ number system is 10 i. Decimal ii. Binary iii. Hexadecimal
b. In binary addition 1+1 equals____________ i. 1 with carry 0 ii. 11 iii. 0 with carry 1
c. All the mathematical operations are performed on the basis of ___________ number system. i. Binary ii. Decimal iii. Octal
d. The redix of hexadecimal number system is ________ i 12 ii. 8 iii. 16
e. What is the value of the binary number 18? i. 10010 ii. 10101 iii. 11010
f. Highest value in the hexadecimal number system is _________ i. 10 ii. 15 iii. F
a. A bit in the computer terminology means either 0 or 1.
b. Octal number system has number set from 1 to 8
c. The Methods of binary division and decimal division are not the same.
d. 1 multiplied with 0 is equal to 0.
e. A digit in a binary number system is called bit.
f. The hexadecimal value of (3)2 is 0011.
a. Find the sum of (11101)2 and (101)2.
b. Find the difference between (111)2-(100)2
4 D. SHORT ANSWER QESTIONS
a. Perform multiplication of (1110)2 and (10)2.
b. Convert (1100110)2 to base 10
a. Write the steps to convert the Hexadecimal number system to octal and explain with an example.
b. Convert (5B)16 to base 8.
a. Mrs dhvani has given a question to the students in her class, having digits 35BA6. Which number system is to be worked upon by the students? ii. Hexadecimal ii. Binary iii. Decimal
1 A. MULTIPLE CHOICE QUESTIONS
a. Computer virus is simply meaning is _______________
I. hardware component
ii. disease
iii. set of computer instructions or code
b. The first documents computer virus is:
i. Creeper
ii. Brain
iii. Reaper
c. Which viruses are frequently found in word processing and spreadsheet programs?
ii. Boot sector
ii. Macro
iii. Polymorphic
d. Which of the following is not a correct practice?
I. Open all types of emails and attachments.
ii. Advertisement pop ups are useful
iii. Use anti virus programs.
e. Traces and records of a person's online activities and interactions is called _______
ii. MFA
ii. Micro
iii. Digital footprint
a. The Brain virus was found in Aplle II computers.
b. Web scripting viruses attach themselves to executable files, such as .exe or .dll files.
c. Polymorphic virus is particularly difficult to detect and remove because it constantly changes its name.
d. Identity theft is a type of cybercrime in which an individual's personal and financial information is stolen
e. Use strong, unique passwords for your online accounts and do not change them regularly.
3 C. ANSWER IN 1 -2 WORDS
a. What is the full form of virus?
b. Which cyber activity refers to harassing, intimidating, threatening or harming individuals or groups?
c. What are the two types of digital footprints?
a. Define computer virus.
b. Write any three sources of virus.
c. What is multifactor authentication?
5 E. LONG ANSWER QUESTIONS
a. List the effects of the presence of viruses in the computer system.
b. List various types of viruses and describe them in brief.
a. Mr Ammy's mail is filled with numerous unsolicited and often irrelevant or inappropriate messages. What kind of unethical behaviour is this? ii. Spamming ii. Cyber bullying iii. Identity theft
b. Mr Ammy is also afraid of Phishing which is a form of cybercrime in which attackers attempt to deceive individuals into revealing sensitive and confidential information. Which among the following prevention must be ensured by him? i. Ensure websites use HTTPS ii. Enable and regularly update spam filters iii. Both the above.
1 A. FILL IN THE BLANKS (Descending, Legend, Computer vision, Debugging, Ascending, Filters, Financi
a. Virtual assistants like Siri and Alexa are examples of___________.
b. ________________________ are well structured data.
c. __________ can be used to narrow down the data in your worksheet
d. ________________________ replicated the identification of the human vision system.
e. Sorting can be done _______________ and ___________________ order.
f. ____________ is the process of detecting and removing existing and potential errors
g. _______________ provides a brief description of the chart.
a. Touchscreen Interface allows easy and quick finger based interaction
b. Ambiguity in text and voice tone of humans is a challenge in NLP.
c. F8 is the shortcut key to create charts.
d. X-axis is the vertical axis and Y-axis is the horizontal axis.
e. The // operator is the right associative operator.
f. Repeatition operator is not applicable on strings.
a. Name two sources of unstructured data.
c. Which chart combines two or more different chart types into a single chart?
d. List three options of Sparkline charts
a. WRITE THE FULL FORMS OF THE FOLLOWING:
i. HMI ____________________________________
ii. AR ____________________________________
iii. VUIs ____________________________________
b. How is eye tracking system useful for interaction with machines?
c. What are the four filter options? List them.
d. How are gridlines helpful in a chart?
e. List all the arithmetic operators in python with their names.
b. What do you mean by sorting? List various ways of sorting.
c. How is grouping of worksheets useful?
d. What is the difference between chart area and plot area?
e. What is the difference between = and == operators?
6 F. SITUTATIONAL QUESTION
a. Riya is a student of st francis senior secondary school. She is creating a presentation for yoga day. While she needs to present her idea in the English language she is finding the data of her choice in hindi language. Which AI facility will be helpful to her? ii. Machine learning ii. Google translate iii. Eye tracking system
b. Mrs Manita wants to arrange students list in ascending order, class wise and if the class of students are the same then the list is to be arranged in alphabetical order section wise. Which option of sorting should she use?
c. Madhu is a python developer in mystro limited. She is trying to find the remainder after division of two numbers in her program. Which of the following is the correct operator?
i. /
ii. //
iii. %
1 A. MULTIPLE CHOICE QUESTION
a. How many important control structures are there in Python?
i. 3
ii. 4
iii. 5
b. Which punctuation should be used in the blank? if _ statements-block 1 else: statements-block 2
i. ;
ii. :
iii. ::
c. Project file option allows you to ______________ files into the project.
i.import
ii. export
iii. play
d. Which is the default appearance of a link when it hasn't been interacted with.
i. Normal state
ii. Visited state
iii. Active state
e. All the mathematical operations are performed on the basis of ___________ number system.
i. binary
ii. decimal
iii. octal
f. What is the value of the binary number 18?
i. 10010
ii. 10101
iii. 11010
g. The first document computer virus is:
h. Which of the following is not a correct practice?
i. Highest value in the hexadecimal number system is _________
ii. 10
ii. 15
iii. F
2 B. FILL IN THE BLANKS (terminates,0011, Play head, Octal, src, Pass)
a. _________________ is an empty statement in python.
b. ______________ specifies the source URL of the image.
c. When the condition in the loop becomes false, the loop _______________.
e. ___________ number system has number sets from 0 to 7
f. The hexadecimal value of (3)2 is_______________ .
b. What does href stand for?
c. Find the sum of (11101)2 and (101)2.
d. In which computers the Brain virus was found?
e. What is the full form of virus?
f. What are the two types of digital footprints?
a. When do we use While loop?
b. What is the nested if statement? Explain with a flow diagram.
c. Why do we apply effects?
d. What is fallback text?
e. Convert (1100110)2 to base 10
f. Write any three sources of virus.
a. What is an infinite loop? List the reason for the creation of an infinite loop
b. List any four features of OpenShot video editor.
c. What do you mean by link states?
d. Write the steps to convert the Hexadecimal number system to octal and explain with an example.
e. List the effects of the presence of viruses in the computer system.
a. A video editor is trying to divide the clips into multiple sections. Which of the following tools is helpful for this?
c. Mrs dhvani has given a question to the students in her class, having digits 35BA6. Which number system is to be worked upon by the students? i. Hexadecimal ii. Binary iii. Decimal
d. Mr Ammy's mail is filled with numerous unsolicited and often irrelevant or inappropriate messages. What kind of unethical behaviour is this? i. Spamming ii. Cyber bullying iii. Identity theft
SAVE