Page 1 :
CBSE | DEPARTMENT OF SKILL EDUCATION, INFORMATION TECHNOLOGY (SUBJECT CODE 402), CLASS X (SESSION 2021-2022), , BLUE- PRINT FOR SAMPLE QUESTION PAPER FOR TERM -1, Max. Time Allowed: 60 Minutes (1 Hrs.), , Max. Marks: 25, , PART A - EMPLOYABILITY SKILLS (05 MARKS):, UNIT NO., , NO. OF QUESTIONS, (1 MARK EACH), , NAME OF THE UNIT, , 1, , Communication Skills-II, , 2, , 2, , Self-Management Skills-II, , 2, , 3, , Information and Communication Technology Skills-II, , 2, , TOTAL QUESTIONS, , 6 Questions, , NO. OF QUESTIONS TO BE ANSWERED, , Any 5 Questions, , TOTAL MARKS, , 1 x 5 = 5 Marks, , PART B - SUBJECT SPECIFIC SKILLS (20 MARKS):, UNIT NO., , NAME OF THE UNIT, , NO. OF QUESTIONS, (1 MARK EACH), , 1, , Digital Documentation (Advanced), , 11, , 2, , Electronic Spreadsheets (Advanced), , 13, , 3, , Database Management System, , 3, , 402-SQP-X-Term1(2021-22), , TOTAL QUESTIONS, , 27 Questions, , NO. OF QUESTIONS TO BE ANSWERED, , 20 Questions, , TOTAL MARKS, , 1 x 20 = 20 MARKS, , 1

Page 2 :
CBSE | DEPARTMENT OF SKILL EDUCATION, INFORMATION TECHNOLOGY (SUBJECT CODE 402), CLASS X (SESSION 2021-2022), , SAMPLE QUESTION PAPER FOR TERM -1, Max. Time Allowed: 60 Minutes (1 Hrs.), , Max. Marks: 25, , General Instructions:, 1., 2., 3., 4., 5., 6., 7., 8., , Please read the instructions carefully, This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C., Section A is of 05 marks and has 06 questions on Employability Skills., Section B is of 15 marks and has 20 questions on Subject Specific Skills., Section C is of 05 marks and has 07 competency-based questions., Do as per the instructions given in the respective sections., Marks allotted are mentioned against each section/question., All questions must be attempted in the correct order, , SECTION A, Answer any 5 questions out of the given 6 questions on Employability Skills, , (1 x 5 = 5 marks), , 1., , __________feedback is specific information, in the form of written comments or, verbal conversations that help the learner understand what she or he needs to do, in order to improve., a. Descriptive, b. Specific, c. General, d. Sign, , 1, , 2., , ____________communication is the use of body language, gestures and facial, expressions to convey information to others., a. Verbal, b. Written, c. Non-Verbal, d. Visual, , 1, , 3., , Sonika gets up at 6 am and goes for her hobby classes. Then she comes back home, and finishes her homework before going to school. She does all work by herself. No, one tells her to do so. This is called ___________., a. Self-Awareness, b. Self-Motivation, c. Self-Regulation, d. Discipline, , 1, , 4., , High expectations from self can leave one with chronic anxiety and stress, thus, leading to, stress., a. Physical, b. Emotional, c. Mental, d. Financial, A __________ operating system is a computing environment that reacts to input, within a specific period of time., a. Single User, b. Multi-User, c. Real Time, d. Distribute, Identify the measure to protect computer from threats and viruses:, , 1, , 5., , 6., , a. Sharing password with friends, c. Use Antivirus, 402-SQP-X-Term1(2021-22), , b. Allow anyone to use your device, d. Leave computer without logging out, 2, , 1, , 1

Page 3 :
SECTION B, Answer any 15 questions out of the given 20 questions, 7., , 8., , 9., , 10., , 11., , 12., , 13., , 14., , 15., , 16., , 17., , 18., , (1 x 15 = 15 marks), , When you apply a ____________, you apply a group of formatting effects together, in one single step., a. Effect, b. Style, c. Template, d. Format, Which function cannot be performed through Subtotal in a Spreadsheet?, a. Sum, b. Product, c. Average, d. Percentage, In a document, __________ refers to the vertical or horizontal placement of a, graphic in relation to the chosen anchor point., a. Arrangement, b. Anchoring, c. Alignment, d. Text Wrapping, A_________ is a model that you use to create other documents., a. Template, b. Document, c. Design, d. Copy Paste, _________________ styles in a text document affect selected text within a, paragraph, such as the font and size of text, or bold and italic formats., a. Cell, b. Paragraph, b. Formatting, d. Character, To repeat the graphic across the entire background area, we need to select option, in word processor., a. Tile, b. Position, c. Stretch, d. Area, Scenarios are a tool to test questions., a. Auto, b. Goal Seek, c. What-if, d. Drop Down, ___________ is particularly useful when creating a watermark or when wrapping, the image in the background in a document., a. Transparency, b. Fill, c. Filters, d. Crop, It refers to a cell or a range of cells on a worksheet and can be used to find the, values or data that you want formula to calculate., a. Row, b. Column, c. Autosum, d. Cell Referenc, __________, totals/adds data arranged in an array—that is, a group of cells with, labels for columns and/or rows Which step one must should follow before using, the Subtotal option?, a. Consolidate, b. Rename Data, c. Filter Data, d. Subtotal, A ______ hyperlink contains the full address of the destination file or web page., a. Relative, b. Absolute, c. Mixed, d. Address, Which of the following is more elaborate form of Goal Seek?, a. Subtotal, b. Scenario, c. Solver, d. Consolidate, , 402-SQP-X-Term1(2021-22), , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 1, , 3

Page 4 :
19., , 20., , 21., , 22., , 23., , 24., , 25., , 26., , _________ means combining data in a spreadsheet from different worksheets into, master worksheet, a. Hyperlinks, b. Consolidating, c. Linking, d. Filter, An __________ link will stop working only if the target is moved while, a__________ link will stop working only if the start and target locations change, relative to each other., a. absolute, fixed, b. Relative, Absolute, c. absolute, relative, d. permanent, absolute, Database servers are referred to as _______________., a. Front-ends, b. Back-ends, c. Clients, d. Model, A table is a set of data elements that is organized using a model of vertical, ___________ and horizontal ____________., a. Rows, Tables, b. Columns, Rows, c. Rows, Columns, d. Forms, Reports, _______________ include fonts, alignment, borders, background, number formats, (for example, currency, date, number), and cell protection in document., a. Cell Style, b. Numbering Style, c. Paragraph Style, d. Character Style, By default, sheets tab are present at the __________ of the spreadsheet., , 1, , 1, , 1, , 1, , 1, , 1, , a. Top, b. Bottom, c. Center, d. Right, The cell reference in a spreadsheet for cell range B2 to F15 is _____________., a. B2.F15, b. B2;F15, c. B2:F15, d. B2-F15, ____________ controls how graphics are stacked upon each other or relative to the, text., a. Arrangement, b. Alignment, c. Anchoring, d. Wrapping, , 1, , 1, , SECTION C, (COMPETENCY BASED QUESTIONS), Answer any 5 questions out of the given 6 questions, , (1 x 5 = 5 marks), , 27., , Millennium University is organizing a reunion meet for their alumnae students. For, this purpose, university wants to send the invite to all these students with their, different addresses. Which feature of the Word Processor University should use to, accomplish the task?, a. Mail Merge, b. E-Mail, c. Templates, d. Data Source, , 1, , 28., , Prisha is a book editor. She wants to change the indentation of all paragraphs, and, change the font of all titles in the book. Which feature she should use to make the, task easy?, a. Styles, b. Templates, c. Table of content, d. Consolidating, , 1, , 402-SQP-X-Term1(2021-22), , 4

Page 5 :
29., , Gaurav has inserted an image in a document. He wants to remove the unwanted, area of the image. Which option of the word processor he will use to complete the, task?, a. Clip art, b. Cut, c. Crop, d. Contrast, , 1, , 30., , Hema is a chartered accountant. She used to maintain the accounts in a, spreadsheet on everyday basis. There are number of steps which she needs to, follow every time. Can you suggest her a feature of spreadsheet through which she, can perform these tasks quickly without repeating the steps every time?, , 1, , a. Record Changes, c. Goal Seek, 31., , Raj has created a worksheet where he has added all the information of his, employees. He wants every employee to go through the worksheet and update, their address and phone number, if required. He also would like to know the, changes done by his employees. Which feature of spreadsheet he should enable to, see the changes made by his employees?, a. Macro, c. Change Worksheet, , 32., , 1, , b. Link Workbook, d. Track Changes, , Akshat wants to store a huge amount information about his firm in a database., Which type of table organization would be most suitable for this purpose?, a. Relational, c. Either Relational or Flat file, , 33., , b. Track Changes, d. Using Macros, , 1, , b. Flat File, d. Hierarchical, , Sunita is making a project in spreadsheets. Her friend has told her how to rename a, spreadsheet as it will help her identify the worksheet data easily. She was very, excited and told the same to her brother. Her brother told her that in, spreadsheets(OpenOffice0, a worksheet can be renamed using __________ ways., a. 2, c. 4, , 402-SQP-X-Term1(2021-22), , 1, , b. 3, d. 1, , 5