TH CLASS – 10 PRE BOARD EXAM – 1 IT M.M – 50 TIME – 50 MIN General Instructions: (1) Please read the instructions carefully. (2) This Question Paper consists of 21 questions in two sections: Section A & Section B. (3) Section A has Objective type questions whereas Section B contains Subjective type questions. (4) Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours. (5) All questions of a particular section must be attempted in the correct order. (6) SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS): (i) This section has 05 questions. (ii) Marks allotted are mentioned against each question/part. (iii) There is no negative marking. (iv) Do as per the instructions given. (7) SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS): (i) This section has 16 questions. (ii) A candidate has to do 10 questions. (iii) Do as per the instructions given. (iv) Marks allotted are mentioned against each question/part
Q1.Answer any 4 out of the given 6 questions on Employability Skills. (1×4=4)
(A) Communication is essential for human existence but ........... is the livewire of Communication (a) words (b) thoughts (c) expressions (d) feedback (B) Stress management prevents ............. problems. (a) Behavioural (b) Psychological (c) Physical (d) Both (a) and (b) (C) Which of the following is an idea of self-employment? (a) Making a shoe in factory. (b) Selling shoe in a showroom. (c) Owning a shoe factory/showroom. (d) Maintaining accounts of shoe factory/showroom. (D) Imagine you are a high school student and your board practicals are round the corner. You haven't prepared your practical file and so you are stressed. A person is said to be stressed if he is: (a) tense (b) worried (c) relaxed (d) both (a) and (b) (E) The organisation that has been assigned responsibility of supervising and coordinating the actions and schemes of SDGs: (a) NEET (b) NTA (c) ARPANET (d) NITI Aayog (F) Shortcut keys used to paste a file is: (a) Ctrl + C (b) Ctrl + P (c) Ctrl + V (d) Ctrl + X 2. Answer any 5 out of the given 6 questions. (1×5=5) (A) ............. style affects numbering and bullet style. (a) Page (b) Frame (c) List (d) Paragraph (B) What will be the output of = MAX(10, 18, –210, 190)? (a) 190 (b) –210 (c) 18 (d) 10 (C) To make the picture as mirror placed at the bottom of the image ............. tool is used. (a) Flip horizontal (b) Flip vertical (c) Rotate (d) Crop (D) Khushi is inserting an image in her document. She wants to increase the contrast of this image, which graphic filter should she choose? (a) Smooth (b) Sharpen (c) Invert (d) Remove Noise (E) Scenarios are the tool to test ............. type of questions. (a) If-else (b) What-if (c) What-then (d) If-then F) An image’s position in the document is not affected by which of the following? (a) Anchoring (b) Alignment (c) Text Wrapping (d) Contrast 3. Answer any 5 out of the given 6 questions. (1×5=5) (A) Which of the following cannot be calculated through Subtotal in a Spreadsheet? (a) Sum (b) Product (c) Average (d) Percentage (B) To connect the data in form of HTML page, which of the following should be done? (a) Copy and paste the data in a workbook. (b) Create a document hyperlink for the HTML document. (c) Create link for the required components using link to external data. (d) All of these (C) ............. refers to a range of cells. (a) Row (b) Column (c) Cell reference (d) Formula (D) Consider the hyperlink- D:\Users\ Documents\mysheet.xlsx. Identify the type of this document hyperlink. (a) Absolute (b) Relative (c) Fixed (d) None of these (E) ............. is arranging data in order. (a) Filtering (b) Sorting (c) Reporting (d) Querying (F) Rohit has created 6 worksheets, in a single workbook, for each month for the sale of products in his shop. To check the half yearly sales, he needs to prepare a single worksheet. Which out of the following features will be helpful for him? (a) Goal Seek (b) Consolidate (c) Solver (d) Macro 4. Answer any 5 out of the given 6 questions. (1×5=5) (A) ............. is a storage container which stores data that belongs to a single object, subject or purpose. (a) Database (b) Table (c) Record (d) Field (B) The description column in Table Design view is used to .............. (a) define data type for each field. (b) describe data to be stored in each field. (c) describe criteria for storing data in the field (d) None of these (C) While creating a table in DBMS, which of the following is considered optional? (a) Field Name (b) Description (c) Data Type (d) Field size (D) The structure of a table, once created, can be changed using ............. SQL command. (a) UPDATE (b) SET (c) MODIFY (d) ALTER TABLE (E) SQL stands for: (a) Structured Query Language (b) Simple Query Language (c) Structured Quick Language (d) Simple Quick Language (F) When a primary key contains more than one field, it is called ............. key. (a) Alternate (b) Foreign (c) Candidate (d) Composite 5. Answer any 5 out of the given 6 questions. (1×5=5) (A) Employees should be trained for how to handle and use the fire extinguisher. But what are the preventive measures for avoiding fire? (a) Put the phone numbers of fire department near the phone. (b) Eliminate fire hazards through good house keeping. (c) Keep inflammable materials inside proper containers. (d) Both (b) and (c) (B) The two ‘S’ in the acronym PASS for remembering the steps of using fire extinguisher stand for: (a) Squeeze and Spray (b) Slip and Stand (c) Stir and Spray (d) Squeeze and Stir (C) Situation which poses immediate risk and requires urgent attention: (a) Emergency (b) Accident (c) Disaster (d) Natural calamity (D) Samira is learning about safety and first aid. She knows that there are certain rules that must be followed while handling accidents. Help her with selecting the inappropriate practice that is not required during an emergency. (a) Preserve Life (b) Plant trees (c) Prevent further injury (d) Promote recovery (E) Krishna was educated about first aid and safety in his school assembly. He can’t remember the word used for the process of emptying a place in case of an emergency or disaster. (a) First aid (b) Eloping (c) Evacuation (d) Recovery (F) For a worker to be able to work with his full potential he must be: (a) Happy and healthy (b) Hard working (c) Highly educated (d) With high morals SECTION - B 26 marks (Subjective Type Questions) Answer any 3 out of the given 5 questions on Employability Skills Answer each question in 20 – 30 words. 6. What are your favourite stress management techniques? Elaborate any two. 2 7. What is the importance of effective communication skill? 2 8. Mention any two tips for the success of startup? 2 9. Since Anu entered her teenage, her father has been telling her that she should set some achievable goals. What do you understand by Goal Setting? What do you think Anu’s father means when he says achievable goals? 2 10. Differentiate between CUI and GUI. 2 Answer any 4 out of the given 6 questions in 20 – 30 words each. (2×4=8) 11. The flowchart consists of many symbols and text along with the symbols. Ankit wants to change the size of all the symbols but selecting each of them together is very tedious. What can he do to select them together on a single click? 2 12. Suvidha slipped in her office and fractured her leg. This was second incident of its kind in their office. Suggest her two safety measures against slips and falls. 2 13. Name the two ways of referencing cells in other worksheets. Describe any one. 2 14. Sitting long hours in front of the computer screen is inevitable for most of us and so are its hazards. Write any two measures to follow at your work place that can help mitigate the risks related to this. 2 15. To create a form or report in database you need some prerequisites. What are these? 2 16. What is the significance of What-if analysis? 2 Answer any 3 out of the given 5 questions in 50–80 words each. (4×3=12) 17. Imagine you have just passed your class 9th and are now going through the text books of class X. You find certain terms in your IT book, about which you ask one of the senior’s (A) What is an absolute hyperlink? (B) What is a relative hyperlink? (C) What is data consolidation? (D) What do you understand by what-if analysis? 4 18. Out of many ways of making a document look professional and presentable Styles and Templates are most commonly used. Differentiate between styles and template. 4 19. Garima is a budding entrepreneur. She wants to know the importance of the safety policy for a company. 4 20. Shamita wants to present the data of sales table to her manager. Which database feature should she use? How can she arrange sales records in descending order of sales? Name the feature should she use to group the records of sales table according to the city. 4 21. Consider the following table named ‘Product’ with details about baby products being sold in the showroom.
(A) How many fields and records are in the given table? (B) What would be the structure of the given table? (C) As the database administrator you need to define a new table supplier that contains the details of a supplier along with the products it supplies. Name any two fields of this table that would be the most important to identify a supplier. (D) Which field of the supplier table must be added to the ‘Product’ table so that both the tables can be linked? 4
