Answer» SECTION A: OBJECTIVE TYPE QUESTIONSQ. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)i. Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?a) E-mail b) Letter c) Message through Friend d) Fax1ii. Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?a) Yoga b) Exercise c) Vacation with Family d) All of these1iii. ______________ ability of a person to do the things that need to be done without someone or something influencing us.a) Self-Motivation c) Self Disciplineb) Self Awareness d) Self-Regulation1iv. According to the concept of sustainable development, the environment and development are _________issues.a) Inseparable b) Separate c) Independent d) None of these1v. The cleaning of software installed in the computer cannot be achieved by ____________.a) Disk cleanup b) backup c) Cleaning CPU cabinet d) Installing antivirus software 1vi. Entrepreneurship has a crucial role in the ____________ of the society.a) Evolution b) Planning c) Functioning d) None of these 1Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i _______________ is not an instant messaging service.a) Skype b) Yahoo! Messenger c) Firefox d) Whatsapp1ii ______ is the process of emptying a place in case of an emergency, disaster.a) Accident b) Evacuation c) Hazards d) Exiting1iii Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?a) Peer to Peer b) Client-Server c) Point to Point d) Ring1iv A _________ is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice versa.a) Repeater b) Switch c) Router d) Modem1v __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.a) Goal Seek b) Scenario c) Solver d) Subtotal1vi ___________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.a) Alignment b) Footer c) Margin d) HeadingsQ. 3 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?a) Drawing/Shapes b) Symbols c) Pictures d) All of these1ii Fatima has inserted a picture in a document. But she wants to cut off a part of the picture. Which option she should use to accomplish the task?a) Cut b) Copy c) Crop d) Layout1iii The intersection point between a row and column is called _______.a) Row b) Column c) Table d) Cell1iv Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to manypeople with different addresses without typing it again and again?a) Mail Merge b) Letter wizard c) Document Type d) None of these1v A ____ is a model that you use to create other documents.a) Styles b) Template c) Wizard d) Sample1vi Formulas in a Spreadsheet must begin with a __________ sign.a) $ b) @ c) # d) =1Q. 4 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i ___________ is a tool to test “what-if” questions.a) Scenario b) Solver c) Macro d) Average1ii Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.a)Macro b) Solver c) Goal Seek d) Sub Total1iii _________can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.a) Illustrations b) Hyperlinks c) Links d) Filter1iv ______________ uses the keyboard as a pointing device instead of a mouse.a) MouseKeys b) Toggle key c) Filter key d) Sticky key 1v Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work.a) Consolidate Worksheet b) Shared Worksheetc) Link Worksheet d) Lock Worksheet1vi ___________ database is a type of database that stores data in several tables.a) Flat b) Relational c) both (a) and (b) c) None of theQ. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i In database _________ helps us to retrieve the filtered data based upon some conditions.a) Forms b) Reports c) Queries d) Table1ii A _____ is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.a) LAN b) WAN c) MAN d) PAN1iii Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose.a) Length b) Default c) Entry Required d) Format1iv ___________ can be set for a field if the user doesn\'t provide any value while entering the values in the table.a) Required b) Default c) Primary Key d) Format1v Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.a) Table b) Form c) Relationships d) Sorting1vi _____________ data type takes the values in the form of 0 and 1 in the database.a) Integer b) Text c) Boolean d) Memo1SECTION B: SUBJECTIVE TYPE QUESTIONSAnswer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)Answer each question in 20 – 30 words.Q. 6 Communication skills are very important for any business. Explain any two elements of a communication process.2Q. 7 Mention any two misconceptions about the Entrepreneurship. 2Q. 8 Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain ‘A’ in brief.2Q. 9 What are the measures to increase the performance of a computer system? 2Q. 10 How can an individual contribute to Sustainable Development Goals? 2Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)Q. 11 Differentiate between Relative and Absolute Hyperlinks with the help of an example.2Q. 12 What is the utility of text wrapping in a document? 2Q. 13 What is the use of Macros in a Spreadsheet? 2Q. 14 Write any two advantages of online shopping. 2Q. 15 Differentiate between Primary key and Foreign key. 2Q. 16 Define the following Hot spots:-a) WIMAXb) Wi-Fi2Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)Q. 17 Elaborate four different types of styles which can be provided in a Word Processor. 4Q. 18 Define the following:a) Subtotalsb) Consolidating Data 4Q. 19 What precautions must be taken to improve online security? 4Q. 20 What is DBMS? Explain any two advantages of DBMS. 4Q. 21 a) The structure of a table “ITEM” is given below. Suggest suitable data type and size of each column. Column name Type SizeItemno ____________ ______ Iname ____________ ______ Price ____________ ______ Quantity ____________ ______ b) Consider the following table “ITEM”: Table: ItemItemnoIname Price Quantity11 Soap 40 8022 Powder 80 3033 Face cream 250 2544 Shampoo 120 10055 Soap box 20 50Write queries to i. Display the total amount of each item. The amount must be calculated as the price multiplied by quantity for each item. ii. Display the details of items whose price is less than 50 .
SECTION A: OBJECTIVE TYPE QUESTIONSQ. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)i. Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?a) E-mail b) Letter c) Message through Friend d) Fax1ii. Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?a) Yoga b) Exercise c) Vacation with Family d) All of these1iii. ______________ ability of a person to do the things that need to be done without someone or something influencing us.a) Self-Motivation c) Self Disciplineb) Self Awareness d) Self-Regulation1iv. According to the concept of sustainable development, the environment and development are _________issues.a) Inseparable b) Separate c) Independent d) None of these1v. The cleaning of software installed in the computer cannot be achieved by ____________.a) Disk cleanup b) backup c) Cleaning CPU cabinet d) Installing antivirus software 1vi. Entrepreneurship has a crucial role in the ____________ of the society.a) Evolution b) Planning c) Functioning d) None of these 1Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i _______________ is not an instant messaging service.a) Skype b) Yahoo! Messenger c) Firefox d) Whatsapp1ii ______ is the process of emptying a place in case of an emergency, disaster.a) Accident b) Evacuation c) Hazards d) Exiting1iii Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?a) Peer to Peer b) Client-Server c) Point to Point d) Ring1iv A _________ is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice versa.a) Repeater b) Switch c) Router d) Modem1v __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.a) Goal Seek b) Scenario c) Solver d) Subtotal1vi ___________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.a) Alignment b) Footer c) Margin d) HeadingsQ. 3 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?a) Drawing/Shapes b) Symbols c) Pictures d) All of these1ii Fatima has inserted a picture in a document. But she wants to cut off a part of the picture. Which option she should use to accomplish the task?a) Cut b) Copy c) Crop d) Layout1iii The intersection point between a row and column is called _______.a) Row b) Column c) Table d) Cell1iv Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to manypeople with different addresses without typing it again and again?a) Mail Merge b) Letter wizard c) Document Type d) None of these1v A ____ is a model that you use to create other documents.a) Styles b) Template c) Wizard d) Sample1vi Formulas in a Spreadsheet must begin with a __________ sign.a) $ b) @ c) # d) =1Q. 4 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i ___________ is a tool to test “what-if” questions.a) Scenario b) Solver c) Macro d) Average1ii Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.a)Macro b) Solver c) Goal Seek d) Sub Total1iii _________can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.a) Illustrations b) Hyperlinks c) Links d) Filter1iv ______________ uses the keyboard as a pointing device instead of a mouse.a) MouseKeys b) Toggle key c) Filter key d) Sticky key 1v Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work.a) Consolidate Worksheet b) Shared Worksheetc) Link Worksheet d) Lock Worksheet1vi ___________ database is a type of database that stores data in several tables.a) Flat b) Relational c) both (a) and (b) c) None of theQ. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i In database _________ helps us to retrieve the filtered data based upon some conditions.a) Forms b) Reports c) Queries d) Table1ii A _____ is one which connects computers and devices in a limited geographical area such as home, school, computer laboratory, office building, or closely positioned group of buildings.a) LAN b) WAN c) MAN d) PAN1iii Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this purpose.a) Length b) Default c) Entry Required d) Format1iv ___________ can be set for a field if the user doesn\'t provide any value while entering the values in the table.a) Required b) Default c) Primary Key d) Format1v Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.a) Table b) Form c) Relationships d) Sorting1vi _____________ data type takes the values in the form of 0 and 1 in the database.a) Integer b) Text c) Boolean d) Memo1SECTION B: SUBJECTIVE TYPE QUESTIONSAnswer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)Answer each question in 20 – 30 words.Q. 6 Communication skills are very important for any business. Explain any two elements of a communication process.2Q. 7 Mention any two misconceptions about the Entrepreneurship. 2Q. 8 Goal setting is a very essential factor in your personal life. List all the SMART methods to set the goals. Explain ‘A’ in brief.2Q. 9 What are the measures to increase the performance of a computer system? 2Q. 10 How can an individual contribute to Sustainable Development Goals? 2Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)Q. 11 Differentiate between Relative and Absolute Hyperlinks with the help of an example.2Q. 12 What is the utility of text wrapping in a document? 2Q. 13 What is the use of Macros in a Spreadsheet? 2Q. 14 Write any two advantages of online shopping. 2Q. 15 Differentiate between Primary key and Foreign key. 2Q. 16 Define the following Hot spots:-a) WIMAXb) Wi-Fi2
SECTION A: OBJECTIVE TYPE QUESTIONSQ. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)i. Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?a) E-mail b) Letter c) Message through Friend d) Fax1ii. Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?a) Yoga b) Exercise c) Vacation with Family d) All of these1iii. ______________ ability of a person to do the things that need to be done without someone or something influencing us.a) Self-Motivation c) Self Disciplineb) Self Awareness d) Self-Regulation1iv. According to the concept of sustainable development, the environment and development are _________issues.a) Inseparable b) Separate c) Independent d) None of these1v. The cleaning of software installed in the computer cannot be achieved by ____________.a) Disk cleanup b) backup c) Cleaning CPU cabinet d) Installing antivirus software 1vi. Entrepreneurship has a crucial role in the ____________ of the society.a) Evolution b) Planning c) Functioning d) None of these 1Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i _______________ is not an instant messaging service.a) Skype b) Yahoo! Messenger c) Firefox d) Whatsapp1ii ______ is the process of emptying a place in case of an emergency, disaster.a) Accident b) Evacuation c) Hazards d) Exiting1iii Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?a) Peer to Peer b) Client-Server c) Point to Point d) Ring1iv A _________ is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice versa.a) Repeater b) Switch c) Router d) Modem1v __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.a) Goal Seek b) Scenario c) Solver d) Subtotal1vi ___________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.a) Alignment b) Footer c) Margin d) HeadingsQ. 3 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to accomplish this task efficiently?a) Drawing/Shapes b) Symbols c) Pictures d) All of these1ii Fatima has inserted a picture in a document. But she wants to cut off a part of the picture. Which option she should use to accomplish the task?a) Cut b) Copy c) Crop d) Layout1iii The intersection point between a row and column is called _______.a) Row b) Column c) Table d) Cell1iv Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to manypeople with different addresses without typing it again and again?a) Mail Merge b) Letter wizard c) Document Type d) None of these1v A ____ is a model that you use to create other documents.a) Styles b) Template c) Wizard d) Sample1vi Formulas in a Spreadsheet must begin with a __________ sign.a) $ b) @ c) # d) =1Q. 4 Answer any 5out of the given 6 questions (1 x 5 = 5 marks)i ___________ is a tool to test “what-if” questions.a) Scenario b) Solver c) Macro d) Average1ii Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.a)Macro b) Solver c) Goal Seek d) Sub Total1iii _________can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.a) Illustrations b) Hyperlinks c) Links d) Filter1iv ______________ uses the keyboard as a pointing device instead of a mouse.a) MouseKeys b) Toggle key c) Filter key d) Sticky key 1v Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work.a) Consolidate Worksheet b) Shared Worksheetc) Link Worksheet d) Lock Worksheet1vi ___________ database is a type of database that stores data in several tables.a) Flat b) Relational c) both (a) and (b) c) None of the
SECTION A: OBJECTIVE TYPE QUESTIONSQ. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)i. Karan lives at a hostel in Shimla. He calls his mother who lives in Delhi, to get her approval for the robotics class which is going to start in his school next week onwards. However, due to disruption in the phone line, his mother could not understand and reply to him. He got very upset. Which another medium can he use to get immediate approval of his mother?a) E-mail b) Letter c) Message through Friend d) Fax1ii. Trisha is always tense during exam time. She is a sincere and studious student, but the thought of exams creates anxiety in her. Which stress management technique that you would suggest to help her?a) Yoga b) Exercise c) Vacation with Family d) All of these1iii. ______________ ability of a person to do the things that need to be done without someone or something influencing us.a) Self-Motivation c) Self Disciplineb) Self Awareness d) Self-Regulation1iv. According to the concept of sustainable development, the environment and development are _________issues.a) Inseparable b) Separate c) Independent d) None of these1v. The cleaning of software installed in the computer cannot be achieved by ____________.a) Disk cleanup b) backup c) Cleaning CPU cabinet d) Installing antivirus software 1vi. Entrepreneurship has a crucial role in the ____________ of the society.a) Evolution b) Planning c) Functioning d) None of these 1Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)i _______________ is not an instant messaging service.a) Skype b) Yahoo! Messenger c) Firefox d) Whatsapp1ii ______ is the process of emptying a place in case of an emergency, disaster.a) Accident b) Evacuation c) Hazards d) Exiting1iii Richard needs to set up a network for his office where he wants to save all the data in a centralized system and other computers will take the services from the centralized system. Which architecture will be the best suitable for him?a) Peer to Peer b) Client-Server c) Point to Point d) Ring1iv A _________ is a device that converts digital computer signals into a form (analog signals) that can travel over phone lines and vice versa.a) Repeater b) Switch c) Router d) Modem1v __________is specifically designed to minimize or maximize the result according to a set of rules that you define in a spreadsheet.a) Goal Seek b) Scenario c) Solver d) Subtotal1vi ___________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.a) Alignment b) Footer c) Margin d) Headings
Konse subject ka
|
