Information technology Sample Paper

CBSE Sample Paper Information Technology Class X (Term I) 47 16. A cell is the intersection of a ____________ and a ___________. (a) text, number (b) row, column (c) sheet, column (d) sheet, row 17. Which of the following cannot be used to resize the drawing object? (a) Position and size dialog box (b) Resizing handles (c) Both (a) and (b) (d) Grouping drawing objects 18. What will be the output of the given formula, if the values present in the mentioned cell is first five multiples of 3? The formula is = Average(C1:C5) (a) 9 (b) 9.5 (c) 8.5 (d) 10 19. The record macro option is present under which menu? (a) Data (b) Format (c) Insert (d) Tools 20. To edit a scenario, you can right click on the name of the scenario in the navigator and then select ___________. (a) scenario (b) window (c) properties (d) edit 21. Which of the following is a single piece of data? (a) Field (b) Table (c) Record (d) Form 22. Which of the following steps are used to create a document from a template in OpenOffice? (a) File ® New ® Text document (b) File ® New ® Template and Documents (c) File ® Open ® Template (d) File ® Default ® Template 23. Record Changes Mode allows us to make changes _________ in a document so as to confirm them later by reviewing them. (a) temporarily (b) permanently (c) occasionally (d) always 24. The key that can be used to select all the objects and to group them as one is (a) Ctrl (b) Shift (c) Tab (d) All of these 25. In Calc, a reference can be created from one document to another by using (a) keyboard (b) mouse (c) Both (a) and (b) (d) None of these 26. To delete the colour or graphics from the background of the table of contents, which option is to be selected from the drop-down list? (a) No fill (b) No colour (c) Delete colour (d) Delete fill Section C SAMPLE PAPER 3 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. You have been assigned a collaborative project in Mathematics. In this project, all five students in each group had to collect data from their neighbourhood and enter in the spreadsheet. Which option in Calc will you use so that all the students can work simultaneously in the sheet? (a) Combine document (b) Share document (c) Link document (d) Add document

48 CBSE Sample Paper Information Technology Class X (Term I) 28. Anita has to make a project on waste management. She has also documented the entire report in Writer. But she wants to write the titles in graphics form in order to enhance the look of her document. Which of the following tool on the drawing toolbar can be used to add a graphic text? (a) Fontwork gallery (b) Graphic text (c) Artistic text (d) Graphic gallery 29. In document, Rajesh has inserted several images along with the written text. In one such section he wants to display the text before and after the image. He knows that he has to use wrap text option but he is not sure which sub option to be selected from the list. Suggest the correct option from the following to get the desired output. (a) Wrap through (b) Wrap on sides (c) Optimal (d) Parallel 30. Sameer has already created a table called inventory table with some basic fields. While entering data he realised that, these fields are not enough. So, he decides to add those required fields. Which of the following option from table design window he has to select? (a) Insert rows (b) Insert columns (c) Insert more (d) All of these 31. Binit had created a style, which he was using since then. He was told to create another style but thought of modifying the same style as per the present requirements and to reduce his work load. He knows it can be done through various methods. Which of the following is not a common way to modify styles? (a) Update style from a selection (b) Copy styles from another document (c) Both (a) and (b) (d) Creating styles 32. Rajiv has created an employee table and made Emp_No, as the primary key, so that it can accept only unique values for each record. At the same time, he wants to have one more field that can behave like a primary key. Which of the following type of key can serve the purpose? (a) Foreign key (b) Candidate key (c) Unique key (d) None of these 33. Mr. Rao is working as account officer in an organisation. He is preparing a spreadsheet to calculate the gross salary of each employee working in a department, also he has to format the spreadsheet in a certain way. For this he wants to create a macro so that his work can be minimized, but he forgot the steps to create a macro. The correct steps to create a simple macro is (a) Tools ® Macros ® Record macro (b) Data ® Macros ® Record macro (c) Insert ® Macros ® Record macro (d) File ® Macros ® Record macro SAMPLE PAPER 3

OMR SHEET SP 3 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

50 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 3

CBSE Sample Paper Information Technology Class X (Term I) 51 Answers 1. (b) 2. (a) 3. (c) 4. (c) 5. (a) 6. (d) 7. (b) 8. (a) 9. (c) 10. (c) 11. (d) 12. (a) 13. (b) 14. (c) 15. (a) 16. (b) 17. (d) 18. (a) 19. (d) 20. (c) 21. (a) 22. (b) 23. (a) 24. (b) 25. (c) 26. (a) 27. (b) 28. (a) 29. (a) 30. (a) 31. (d) 32. (b) 33. (a) SOLUTIONS 1. There are several factors or barriers, which are 11. In Calc, solver is a useful tool to find an SAMPLE PAPER 3 responsible for the way people view our optimal solution for all kind of decision messages. Linguistic or lingual barrier is the problems. Solver is an elaborate form of Goal interference which occur due to accent, speak seek that deals with equations with multiple disorder, difference in language and unknown variables. sametimes completely different meanings, which can affect the communication process. 12. By holding down the Shift key while drawing a shape can maintain the height and width ratio 2. Bad stress refers to a stress that is ongoing and of the shape. does not lower down. Loss or gain of weight is one of the symptoms of bad stress. 13. There are three types of reference, relative, absolute and mixed. In mixed reference, either 3. A clipboard is a temporary memory buffer the column or the row is fixed. where data is stored for short-term in our computer applications. 14. A table is a collection of information about a particular object in horizontal rows and vertical 4. Adverb is one of the parts of speech that refers columns. It is one of the objects of a database to a word that describes a verb, an adjective or that stores data pertaining to a single object, another adverb, expressing manner, place, subject or purpose. time or degree. 15. Alignment is the position of an image or object 5. Icon is a small picture or symbol on a within a document. Left, centered, right, top, computer screen that represents a program. It center and bottom are the 6 alignments is a small graphical representation of a available in Writer. program or file. When we double click an icon, an associated file or program will be opened. 16. A cell is a combination of a row and a column. We enter our data in the active cell. 6. Emotional problems are a reflection of our character. It should be kept under control 17. A drawing object can be resized by using either when something triggers them. resizing handles or position and size dialog box. 7. If you want to keep a document with the formatting for future use, you need to turn 18. The average function returns the arithmetic that object’s (paragraph, title etc) formatting mean of the arguments that are passed as into a new style. By pressing Shift + F11, you values in the formula. can also create a new style. 19. A macro is an automated input sequence that 8. If function is a logical function, which is used copies keystrokes or mouse actions. Record to add conditions. If function tests a condition macro is present under Tools menu. The and returns a logical value (true or false). command Tools ® Macros ® Record macro, can be used to record a macro. 9. Calc provides the facility to enter data and edit multiple worksheets as a group at one go. You 20. A scenario is a What-if analysis tool that allows can group multiple sheets by holding Ctrl key us to substitute set of values automatically in a while clicking on the sheet tabs. Any changes worksheet. In order to edit a scenario, you can made in the active sheet will also be applied right click on the scenario name in the on other grouped sheets. navigator window and select properties. 10. Drag and drop technique is used in most of the 21. In a database table, a field is a data structure application to drag an image from its location for a single piece of data. A table consists of and dropping it where it is required. several records and each record can be broken into smaller entities known as fields.

52 CBSE Sample Paper Information Technology Class X (Term I) 22. To create a document based on an existing, 29. When you place an image in a document, you pre-defined template, you can use the may need to position the text around the command File ® New ® Templates and image. This is known as text wrapping. Text Documents and then select the desired template wrap satting determines the relation between from the list. the text and the graphic. 23. Making changes temporarily in a document so He should use wrap through sub option to get as to confirm them later by reviewing them. the desired output. This working mode is known as Record Changes Mode. 30. By using insert rows option, we can add more fields in an existing table. 24. By holding Shift key from the keyboard, we can select multiple objects. 31. Styles are predefined combination of font style, colour, size of text etc., that can be 25. We can create reference using either keyboard applied to selected text or paragraph to or mouse. When documents are linked, any change the appearance of the document. change in the original document will reflect in the linked document. Creating styles is not a common way to modify styles. 26. Colour or graphics from the background of the table of contents can be deleted by no fill option 32. A table can have more than a single field that on the colour grid from the drop down list. has unique values. All such fields that uniquely identify the rows in a table are called 27. The share document option allows multiple candidate keys. users to work simultaneously on the same spreadsheet. 33. A macro can be created by opening Tools menu, selecting Macros and then clicking on 28. You can insert decorative text by using Record Macro. Once all actions are done, you fontwork gallery on the drawing toolbar. You can click on stop recording option and save can create colourful, rotated and stretched text the macro. too. SAMPLE PAPER 3

SAMPLE PAPER 4 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability Skills. (1 ´ 5 = 5 marks) 1. _____________ describes how an idea, impression, or feeling is made known to others. (a) Response cycle (b) Communication cycle (c) Feedback cycle (d) All of these 2. Entering data is one such function, which is not performed by (a) Operating system (b) Spreadsheet (c) Both (a) and (b) (d) None of these 3. Stress management covers almost all the tools that can reduce stress which is _________. (a) chronic (b) temporary (c) low (d) high 4. Which of the following is not an advantage of working independently? (a) Boosts self-confidence (b) Makes person emotionally independent (c) Makes a person self-reliant (d) Makes a person arrogant 5. In the message, the facts and figure should be accurate. This is one of the features of which of the following 7C’s of effective communication? (a) Clear (b) Concise (c) Correct (d) Coherent

54 CBSE Sample Paper Information Technology Class X (Term I) 6. Mails that we receive from unwanted sources is technically known as (a) spams (b) garbage mails (c) thrash (d) bad mails Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. To ___________ the Fill Format Mode, click on the Fill Format Mode icon or press the ___________ key. (a) Quit, Esc (b) Quit, Shift (c) Apply, Enter (d) Apply, Ctrl 8. If you are working with the same range of cells while consolidating data, then you can assign names to them in place of using _______________. (a) functions (b) fields (c) cell references (d) lists 9. The maximum range in characters of CHAR datatype is (a) 128 (b) 256 (c) 255 (d) 257 10. In the Goal Seek dialog box, the formula cell contains the ________ of the cell that has a formula. (a) reference (b) value (c) Both (a) and (b) (d) Neither (a) nor (b) 11. The __________ field property specifies the number of characters for the data field. (a) value (b) length (c) capacity (d) fixed 12. By pressing the __________ key you can move between __________, while typing the information in a data source. (a) Tab, buttons (b) Tab, fields (c) Shift, buttons (d) Shift, fields 13. 1000, 8, 2 are the values present in cell, C2, D2 and E2, respectively. What will be the output of the formula = C2 * D2/100 * E2? (a) 1600 (b) 16000 (c) 160 (d) 1620 14. A table of content is required when we create a ____________ document. (a) 4-5 pages (b) cover page (c) multi page (d) None of these SAMPLE PAPER 4 15. Which of the following is the correct syntax to create a reference to link cells of different workbooks using a keyboard? (a) ‘File:///Path and File Name’#$SheetName.CellAddress (b) ‘File:///Path and Worksheet Name’#$SheetName.CellAddress (c) ‘File:///Path and File Name’#$WorkbookName.CellAddress (d) All of the above 16. You may keep a file using a new name and preserve the old file with its original name. This can be done by using which of the following commands? (a) File ® Save As (b) File ® Save (c) Both (a) and (b) (d) None of these

CBSE Sample Paper Information Technology Class X (Term I) 55 17. Which of the following option is not present under Format ® Anchor command? (a) To page (b) To paragraph (c) To character (d) To margin 18. In Calc, you can insert the data from different databases and other data sources. One such format is (a) .odd (b) .dbms (c) .odb (d) .ods 19. A __________ is a coloured and underlined text or graphics. (a) hyperlink (b) relative hyperlink (c) partial hyperlink (d) All of these 20. Which of the following is not considered as an advantage of built-in templates? (a) Easy to work with (b) Same format in many templates (c) Saves our time (d) Standard layout 21. If the sheet is ____________ and the option ____________ is selected while creating a scenario, then you cannot make any changes in it. (a) protected, prevent changes (b) protected, stop changes (c) locked, prevent changes (d) locked, stop changes 22. The __________ contains ready-to-use objects like, arrows, bullets, and sounds that can be inserted in a document. (a) gallery (b) object space (c) styles (d) pictures and sounds 23. Which of the following is not true? (a) More than one people can work simultaneously on shared worksheet. (b) Shared spreadsheet can be modified by other users. (c) You cannot make changes in a sheet, if it is not shared with you. (d) Other users can save the shared file while you resolving the conflicts. 24. The button that allows us to copy work on every document of the label is (a) copy labels (b) paint labels (c) synchronize labels (d) format labels 25. The LibreOffice macros are usually written in a language called LibreOffice _______. (a) Basic (b) Writer (c) Calc (d) Base 26. A hyperlink that contains the full address of the destination file or the web page is (a) relative hyperlink (b) absolute hyperlink (c) base hyperlink (d) address hyperlink Section C SAMPLE PAPER 4 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Sometimes, you need not turn on the track changes in the spreadsheet but you may want to add additional information or provide feedback while editing the contents of the cell. In such case, which of the following option is most suitable? (a) Feedback (b) Comments (c) Help tip (d) Message

56 CBSE Sample Paper Information Technology Class X (Term I) 28. Pradip is studying in class VI. His computer teacher has asked him to create an abstract art using Writer software. The teacher has also specified that he has to use various shapes and lines in order to make his art work look impressive. Suggest the toolbar from the following, which will have all these tools to work with. (a) Drawing (b) Shapes (c) Standard (d) Art 29. Srinivas has to add certain scanned images in his text document. For this he has connected the scanner to the computer. He is using the feature of Writer to directly call the scanning application and insert the scanned item into the document as an image. Which of the following command is correct after choosing the device? (a) Insert ® Picture ® Add (b) Insert ® Picture ® Scan ® Add (c) Insert ® Picture ® Scan ® Apply (d) Insert ® Picture ® Scan® Request 30. Jafar has created a database. He has to extract certain specific data from the table he has made. For this he is creating a query using the design view. He used a specific property in the design grid. He has selected the field name Reg_No and gave it an alternative name, i.e. Registration_No. From the following identify the property which allows us to do so. (a) Alias (b) Dummy (c) Copy (d) Pen name 31. Suhani has written an article on ‘Sustainable Development Goals’ in about 1000 words. She has given appropriate headings and subheadings in it. She has also created a table of contents using the hierarchy of headings. She also wants to customize the look of the table of contents by adding an image in its background. Which of the following option under the background tab she should select to add an image? (a) Image (b) Picture (c) Bitmap (d) Art 32. Kiran is the manager of an automobile showroom. She wants to know the total car sales of the third quarter of the year 2020 and 2021. The sales data is stored in different worksheets named as Sales_2020 and Sales_2021. Which of the following feature she should use, which will allow her to easily collate data from several worksheets? (a) Collate (b) Consolidate (c) Compare (d) Connect 33. Sanjay is a sales executive in a private firm that deals in sales and purchase of CCTV cameras. The sale price of a single unit is ` 5700 and the purchase price is ` 4800, in addition, the maintenance cost is ` 25000 per year. He wants to know the profit, if he sells a certain number of CCTVs in a year. Which of the following tool he can use, that will allow him to calculate different results without entering the values and formula, SAMPLE PAPER 4 separately? (a) Multiple operation (b) Goal seek (c) Solver (d) Consolidate

OMR SHEET SP 4 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

58 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 4

CBSE Sample Paper Information Technology Class X (Term I) 59 Answers 1. (b) 2. (a) 3. (b) 4. (d) 5. (c) 6. (a) 7. (a) 8. (c) 9. (c) 10. (a) 11. (b) 12. (b) 13. (c) 14. (c) 15. (a) 16. (a) 17. (d) 18. (c) 19. (a) 20. (b) 21. (a) 22. (a) 23. (d) 24. (c) 25. (a) 26. (b) 27. (b) 28. (a) 29. (d) 30. (a) 31. (c) 32. (b) 33. (a) SOLUTIONS 1. Communication cycle describes how an idea, 10. Goal Seek dialog box has three fields, formula SAMPLE PAPER 4 impression, or feeling is made known to others. cell, target value and variable cell. A communication cycle includes resources such as e-mail threads, social media outlets, V.I.P The formula cell in the Goal Seek dialog box message outlets, etc. contains the reference of the cell that has a formula. 2. Operating system is a computer program that organizes a number of other programs at the 11. The length field property specifies the same time. maximum number of characters for a particular data field. It restricts the entry of 3. Stress is defined as a reaction to any external unwanted characters. stimuli that triggers changes in one’s personality. Stress management refers to a wide 12. Field is a column in a data source that range of techniques that enable a person to cope contains one type of information. You can with psychological stress effectively. It helps in switch between the fields by pressing the Tab reducing the stress that is temporary. key, while typing information in a data source. 4. An independent person is aware of his feelings and characters, evaluates his/her behaviour and 13. A formula is an expression that operates on correct his mistakes. An independent person values in a range of cells or a cell. In the has high self-confidence working formula = C2 * D2/100 * E2, it will first independently does not make a person multiply 1000 and 8 followed by dividing the arrogant. product by 100 and then multiplying it by 2. Hence, the output is 160. 5. Correctness is an important element in effective communication. Hence, the fact and figures 14. Writer lets you to build an automated table of shared should be correct. contents using table of contents and index feature. A table of content is generally created 6. Spams are unwanted messages sent to for a multi page document. somebody via email, especially advertisements. Spams are generally sent from unwanted and 15. Using keyboard and also by mouse, you can unreliable sources. link data of one workbook with data of another workbook. 7. Fill format mode allows us to apply a style to many different areas quickly. By pressing the The correct syntax to create reference to link Esc key after clicking on the Fill Format mode cells is icon, we can quit the Fill Format mode. File:///Path and File Name’ #$SheetName. CellAddress 8. If the same range of cells are used again and again during consolidation, we can assign a 16. Save As is generally used to make a copy of name to the range instead of typing the cell original file, with a different name. references and this name can be used further. To assign a name to a range of cells, click on Using File ® Save As command, you can save Data ® Define Range, a dialog box will open, a copy of the same file, at a different location, enter name in the Name field and click on OK with a different name. button. 17. Using the Anchor points around a selected 9. The CHAR datatype stores character or strings image, you can position an image as per your of a fixed length. Its range in characters is 0 to requirement. The ‘to margin’ option is not 255. available under the Format ® Anchor command.

60 CBSE Sample Paper Information Technology Class X (Term I) 18. Data from only registered databases and data 27. In a spreadsheet, you can add comments, if sources can be inserted in Calc. .odb is the you want to add some information or extension name of a file created by using Base. feedback while editing the contents of the cell. 19. A hyperlink is a coloured and underlined text or graphics that you click to open a file, location in a 28. Drawing toolbar consists of various tools file, or a web page. using which you can add various shapes, add graphic text in your document to make 20. Templates ensure that all documents have a it more attractive. standard layout, look and feel. Different templates have different format that can be used 29. Writer has a feature to directly call the as per our requirement. application and insert the scanned item into the document as an image. To add a scanned 21. When a sheet is protected, it doesn’t allow us to image in a document, Insert ® Picture ® make any changes in the sheet, until and unless it Scan ® Request command is used. is unprotected again. 30. Alias property allows the user to specify an 22. The gallery contains ready-to-use objects and alternative name for any field in a query and sounds that can be inserted in a document as per display the result. our requirement. 31. The Bitmap button in the background tab 23. Other users cannot save the shared file while you will allow you to add an image in the resolving the conflicts. background of table of contents. 24. Using mail merge feature of Writer, we can create 32. The consolidate feature allows us to collate labels that contain information related to a data with minimal efforts from several product, instruction, batch numbers, etc. The worksheets. Data consolidation is a process synchronize labels button helps us to apply the of collecting and integrating data from same formatting to all the labels. multiple sources into a single file. 25. The macros are generally written in a language 33. Multiple operation is a very useful tool that under LibreOffice, i.e. LibreOffice Basic. does not present the alternative versions in the same cell. It displays the result of 26. There are two types of hyperlinks, relative and applying formula to a list of alternatives for absolute hyperlinks. An absolute hyperlink tells variables in a separate range of cells. how to get to a file from its top most folder. It contains the full address of the destination file. SAMPLE PAPER 4

SAMPLE PAPER 5 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability. (1 ´ 5 = 5 marks) 1. Which of these is not an example of the visual method? (a) Maps (b) Telephonic chat (c) Graphs (d) Charts 2. All the devices that are attached separately to the computer are called _____________. (a) peripherals (b) side devices (c) storage devices (d) additional hardware 3. A teacher may use a script like – Dear students settle down, settle down in a comfortable position. Take a moment to notice how your body feels and so on. This whole procedure is known as (a) yoga (b) meditation (c) guided meditation (d) nature walk 4. Spending time and going on vacation with your family is a technique of __________. (a) stress management (b) leisure spending (c) exercising (d) None of these 5. Which of these sentences is punctuated correctly? (a) Take Care of your manners, Meena. (b) Take care of your manners meena. (c) Take care of your manners, Meena. (d) Take care of your. Meena,

62 CBSE Sample Paper Information Technology Class X (Term I) 6. Which of the following is not a type of word processor? (a) Writer (b) MS Word (c) Wordpad (d) Tally Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. Which of the following styles is used to set the font and size of the text in a paragraph? (a) Paragraph styles (b) Character styles (c) Table styles (d) Text styles 8. In the Solver dialog box, __________ is used if you expect your reference cell to have only 0 and 1. (a) binary (b) boolean (c) bits (d) integer 9. A DBMS supports a _______ environment, allowing several users to access and work on data concurrently. (a) multi-user (b) multi-file (c) multiple (d) None of these 10. If you wish to add more sheets in your workbook, then the command to be used in Calc is (a) Insert ® Workbook ® Worksheet ® OK (b) Insert ® Worksheet ® Enter number of sheets ® OK (c) Insert ® Sheet ® OK (d) File ® Insert ® Worksheet ® OK 11. Sharing a document disables many features in a shared spreadsheet. __________ and _____________ features are disabled under Insert menu. (a) Compare documents, move sheet (b) Protect, print ranges (c) Validity, sort (d) Objects, names 12. __________ filter mimics the effects of time on an image, whereas __________ makes the picture appears like a painting. (a) Aging, posterize (b) Copy, art (c) Relief, mosaic (d) Pop art, aging 13. ___________ are very flexible, allowing automation of both simple and complex tasks. (a) Goal seek (b) Macros (c) Sharing document (d) Protecting document 14. In which of the following text wrapping styles, is the text placed above and below the image but not around it? SAMPLE PAPER 5 (a) Page wrap (b) Wrap through (c) Optimal page wrap (d) No wrap 15. Max(23, 34, 12, 10) is written in the formula bar. What it will reflect in the active cell? (a) 34 (b) Max(23, 34, 12, 10) (c) 10 (d) None of these 16. The ___________ tab in the index/table dialog is used assign the paragraph pre-defined formats to each level of contents. (a) styles (b) columns (c) background (d) entries

CBSE Sample Paper Information Technology Class X (Term I) 63 17. To insert a hyperlink in table of content, you need to specify ___________ and __________ of the hyperlink. (a) start, stop (b) beginning, end (c) left, right (d) entry, exit 18. Spreadsheet software can find the changes by __________ sheets. (a) adding (b) changing (c) comparing (d) deleting 19. Which of the following option tells a summary of a macro in the Macro dialog box? (a) Summary (b) Macro name (c) Macro details (d) Description 20. We have to be cautious while we ___________ the table of contents, as writer do not prompt you to confirm the action. (a) create (b) save with a different name (c) delete (d) None of these 21. If you use more than one group, then you can also arrange the subtotals according to choices available in the subtotal dialog box. To use access the subtotal dialog box, click of ___________ menu. (a) Tools (b) Data (c) Edit (d) Insert 22. From the following select the correct steps that can be used to print labels in Writer. (a) Edit ® Print (b) File ® Print (c) Tools ® Print (d) Format ® Print 23. The reference (A1, C5), suggests that it includes (a) cells A1 and C5 (b) all cells from A1 to C5 (c) Both (a) and (b) (d) None of these 24. Which of the following is not a pre-requisite for the process of Mail merge? (a) Data source (b) Main document (c) Field names (d) Comments 25. Electronic spreadsheet is an example of __________ database. (a) flat (b) open (c) closed (d) None of these 26. Which of the following is the correct output of CountA function? (a) Number of cells including empty cells in the given range. (b) Number of cells excluding empty cells in the given range. (c) Number of cells having numeric entries in the given range. (d) Number of cells having formula in the given range. Section C SAMPLE PAPER 5 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. In a school, various coach has to work on their upcoming budgets. They were asked to prepare their budgets using the same worksheet shared by the school. Now they all have returned with their edited versions of the worksheet at the same time. In this case, it may be quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides the feature of (a) merging worksheets (b) adding worksheets (c) editing worksheets (d) None of these

64 CBSE Sample Paper Information Technology Class X (Term I) 28. Lata has made a project on waste management. She has to submit a softcopy of all her research work done. She has created a document using Writer, which includes text and images. Only there is one image in which she has to remove a part of it from right. Which of the following feature she should use to get what she wanted? (a) Remove (b) Delete (c) Crop (d) Cut 29. Ranjan is working on a document. He is using Writer to create his work. He wants to save some time by applying the styles that are available in the software. But he is not happy with the styles that are there, so he thought of looking into another document. He found a suitable style. To copy the style which button he should click? (a) From file (b) From style (c) Copy style (d) Paste style 30. A relational database management system is a database system that stores and retrieves data in a tabular format organized in the form of rows and columns. Using a RDBMS software also allows us to create and print reports as per our requirement or conditions. Which of the following is a RDBM software? (a) Oracle (b) MySQL (c) IBM DB2 (d) All of these 31. Raj is trying to use all the tools present on the drawing toolbar. One by one he is using them all. He wanted to use a particular tool where in he can add some text in it too. He found the right tool, i.e. the text box. Which of the following is not an option available for enhancing the look of the text? (a) Shadow (b) Fill colour (c) Rotation (d) None of these 32. You are the head of a marketing team. Amit who is working under you has submitted a budget to you for an event and you need to edit the costs and return it to him. You are concerned that if you just make the changes, then the he won't see the changes you made. You decide to use one of the features of Calc, so that Amit can easily see the changes you have made. Which of the following feature you have chosen? (a) Make changes (b) Record changes (c) View changes (d) Apply changes 33. Cheak is going to invest in a project. For this she is thinking of taking a loan from a bank. She has the list of interest rate, from different banks. She wanted to see what will be the result for the respective interest rates on her investment. Which of the following tool she should use to get the results quickly? (a) Goal seek (b) Solver (c) Scenario (d) Calculate SAMPLE PAPER 5

OMR SHEET SP 5 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

66 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 5

CBSE Sample Paper Information Technology Class X (Term I) 67 Answers 1. (b) 2. (a) 3. (c) 4. (a) 5. (c) 6. (d) 7. (b) 8. (a) 9. (a) 10. (c) 11. (d) 12. (a) 13. (b) 14. (d) 15. (b) 16. (a) 17. (b) 18. (c) 19. (d) 20. (c) 21. (a) 22. (b) 23. (a) 24. (d) 25. (a) 26. (b) 27. (a) 28. (c) 29. (a) 30. (d) 31. (d) 32. (b) 33. (c) SOLUTIONS 1. Visual method is another important method of are many features that are disabled under SAMPLE PAPER 5 communication, which involves sending and various menus. Inserting objects and names comprehending messages only through are two such options that are initially disabled images. under Insert menu, when we share a document. Telephonic chat is an example of visual method. 12. Filter provides many options to add filter to the image to make it look more attractive. The 2. All the devices that are attached separately to aging filter mimics pictures a certain look the computer is called peripherals. Mouse, resembling that of old photos. Posterize filters keyboard, speakers etc, that connect to and the number of colours in the picture by work with the computer are some examples of reducing them and makes the picture appears peripheral devices. like a painting. 3. In guided meditation, a script is generally used 13. A macro can be recorded to automize our for a simple breathing meditation or for complex tasks and it can be used once it is relaxation. saved. 4. Travelling with family and friends is a good 14. No wrap is the default text wrap style where method to release stress. It is one of the the text is placed above and below the image techniques of stress management. but not around it. 5. Punctuations also aim at making expressions 15. It will show the same text as Calc will not clear. Punctuation means the right use of identify it as a formula because there is no certain points, stops and marks which equal ( =) symbol. separates one sentence from another or one part of sentence from another. 16. The index/table dialog box have 5 tabs. They are index/table, entries, styles, columns and 6. A word processor is a program that provides Background. The styles tab in the index/table for inputting, editing, formatting, etc. Using a dialog box allows us to assign the paragraph a word processor we can create documents e.g. pre-defined formats to each level of contents. Writer, MS-Word, Wordpad, etc. Tally is an accounting software not a word processor. 17. A hyperlink can be added in a document, but you need to specify both the beginning and 7. Character styles allows us to set the font and end of the link. size of the text in a paragraph. 18. The spreadsheet compare is used to compare 8. If you wish to expect your reference cell to two workbooks to see the differences between have only 0 and 1, then select binary in the them, line by line. Solver dialog box. 19. Description box displays a summary of the 9. One of the features of a database management selected macro. The discription section is software is that it supports a multi-user present at the bottom of the macro selector environment which allows multiple users to dialog box. access and work on the data simultaneously. 20. A table of content can be deleted by right-click 10. By default, there are three sheets available in a on the table contents and selecting delete workbook in Calc. More sheets can be inserted index/table option from the context menu. in the same workbook by command, 21. f you use more than one group, then you can Insert ® Sheet ® OK also arrange the subtotals according to choices made on the dialog‘s options, including 11. Sharing a document allows multiple users to ascending and descending order or using one work on the same spreadsheet. However, there

68 CBSE Sample Paper Information Technology Class X (Term I) of the predefined custom sorts defined under 28. Cropping means removing a section of an tools menu as Tools ® Options ® OpenOffice image starting from its boundary. Cropping Calc ® Sort Lists. is done when you do not want to use the entire picture and inserted only some part 22. Labels can be printed by using File ® Print of it. command. A dialog box will appear, click on Yes. From the dialog box, apply the correct 29. To copy the styles from another document, settings and click on Print button. click the From file button to open a window from which you can select the required 23. Referencing is important in spreadsheet. It is document. used to identify a cell of a group of cells to be used for various purpose. The reference (A1, C5) 30. A relational database management system is is pointing to the cell A1 and C5 but not from A1 a database system that stores and retrieves to C5, as the comma (,) seperator is used. data in a tabular format organized in the form of rows and columns. It is different 24. Mail merge is a feature of writer using which from a database management system. In a you can send the same document to multiple RDBMS, tables can be linked through their users at the same time. The pre-requisite for the common key fields. Oracle, MySQL and IBM Mail-merge process are, the main document, DB2 are RDBMS softwares. data source and merged fields. 31. A text box is a rectangular box wherein you 25. In a flat database, information is stored as a can insert text. The text box can be moved, single file in a tabular form which has no relation grouped, ungrouped, etc. with the other databases. Options available for enhancing the look of 26. CountA function counts the number of cells in a the text are shadow, fill colour, rotation, etc. given range excluding the empty cells and returns the number of cells as the output. 32. Record changes feature in Calc can track what data was changed, when the change 27. Sometimes, multiple reviewers return edited was made, who made the change and in versions of a worksheet at the same time. In this which cell the change has occurred. case, it may be quicker to review all of these changes at once, rather than one review at a time. 33. A scenario is a set of values that a For this purpose, Calc provides the feature of spreadsheet saves and can substitute merging worksheets. automatically in the worksheet. SAMPLE PAPER 5

SAMPLE PAPER 6 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability Skills. (1 ´ 5 = 5 marks) 1. __________ and ___________ are the two hormones which is released in our body when there are increased stress levels. (a) Cortisol, adrenaline (b) Aldosterone, corticosteroid (c) Oxytocin, prolactin (d) None of these 2. Which of the following is not considered as a rule for writing a good paragraph? (a) Write an outline (b) Write topic sentence (c) Write the line numbers (d) Write the concluding sentence 3. The GUI operating system that graphical interface and allows access to user through mouse or track-ball is abbreviated to ____________. (a) WIMP (b) CUI (c) RAM (d) None of these 4. An independent worker plans actions to accomplish a task. Which of the following does not fall under this category? (a) Goal setting (b) Planning (c) Timeline (d) Loose time management

70 CBSE Sample Paper Information Technology Class X (Term I) 5. A ___________ provides access to all programs, settings, files and information on the computer. (a) taskbar (b) status bar (c) file menu (d) All of the above 6. The feedback should not be vague and should be conveyed with clarity. This characteristic of communication is known to be (a) intentional (b) specific (c) useful (d) fair Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. If you want to use a macro as function, then it must be stored in code, inside __________ and ____________ clauses. (a) function, end function (b) task, end task (c) sub, end sub (d) macro, end macro 8. Any changes you make to a style are effective only in the current document. To change styles in more than one document, you need to change the ____________. (a) format (b) file (c) type (d) template 9. Which of the following option in show changes dialog box will display only those changes made in a specific range of cells? (a) Group (b) Range (c) Name (d) Section 10. The registered data source are databases that are compatible and used in Calc is (a) *.odt (b) *.txt (c) *.odb (d) *.sql 11. To link the file instead of embedding it, hold down the _________ keys while dragging the image. (a) Alt + Ctrl (b) Ctrl + Shift (c) Alt + Shift (d) Ctrl + Enter 12. A ___________ key is a field that provides a link between two __________. (a) primary, tables (b) primary, forms (c) foreign, tables (d) foreign, forms 13. If we are working on multiple sheets and we have to use data present on a different SAMPLE PAPER 6 worksheet, the syntax used is (a) <Sheetname> × <Cell reference> (b) <Cell reference> (c) <Col letter> + <Row number> (d) <Sheetname> + <Cell reference> 14. If the data is ________ , it is considered to be a good practice while applying subtotals. (a) solved (b) sorted (c) formatted (d) updated 15. In order to view the individual tables, double-click on the tables or click on the _______ sign. (a) plus (b) minus (c) equals to (d) hash

CBSE Sample Paper Information Technology Class X (Term I) 71 16. Frame styles are used to format graphic and text frames, including wrapping type, borders, __________ and ___________. (a) texts, columns (b) backgrounds, columns (c) texts, backgrounds (d) None of these 17. If the application from which the graphic was copied is closed before the graphic is pasted into the target, the image stored on the __________ could be lost. (a) clipboard (b) hard drive (c) writer (d) file 18. Which of the following fields will not make a suitable primary key? (a) A customer’s account number (b) A data field (c) An auto number field (d) A student’s admission number 19. When you hold the __________ key while resizing an image, the image is either enlarged or reduced proportionally. (a) Ctrl (b) Alt (c) Window (d) Shift 20. Which of the following command is used to open the ‘External Data’ dialog box? (a) Tools ® Link to External (b) Sheet ® Link to External (c) Data ® Link to External (d) File ® Link to External 21. Change Anchor tool allows you to switch between anchoring options. The change Anchor icon is only visible, when an object is (a) selected (b) deleted (c) printed (d) None of these 22. The __________ datatype stores Yes/No or True/False values. (a) binary (b) number (c) type (d) boolean 23. If you have two values in cells A1 and B1 and you want to calculate the product of these two values type the __________ formula. (a) = Multiply(A1, B1) (b) = A1 * B1 (c) Both (a) and (b) (d) = Mul (A1, B1) 24. By default, Writer evaluates _________ levels of headings when it builds the table of contents. (a) 10 (b) 8 (c) 5 (d) 12 25. You can see non-printing characters, such as paragraph marks, line breaks and so on. If these are not already visible, choose View ® Nonprinting Characters from the menu SAMPLE PAPER 6 bar, or press ___________. (a) Ctrl+F10 (b) Alt + F10 (c) F10 (d) Shift + F10 26. _________ option specifies, if the link is to be presented as text or as a button. (a) Form (b) Type (c) Look (d) Display

72 CBSE Sample Paper Information Technology Class X (Term I) Section C Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Binny has to create a document on a certain topic. To make her work look more attractive, she has decided to apply a style instead of formatting the whole document, page wise. She wants to use a user-defined style rather than the default styles available. Which of the following style group she should select to display user-defined styles? (a) Custom styles (b) User defined styles (c) Conditional styles (d) Index styles 28. Rashmi has done all the hard work and has recorded and saved a macro. She has created this macro to apply it on other worksheets, where the same set of formatting is to be applied. Although she knows how to create a macro, she is not sure of the command to be used to run the macro. Out of the following, which is the correct sequence of command to run a macro? (a) Data ® Macros ® Run macro (b) Tools ® Macros ® Run macro (c) File ® Macros ® Run macro (d) Format ® Macros ® Run macro 29. Raghav is working in a Bank. He is creating a table to store the details of the customers of the Bank. Acc_No, Cust_Name, Date_of_Birth, PAN_No, Cust_Add are the fields that are added in the table named CustomerDetails. Which of the following fields can be selected as candidate key? (a) Acc_No (b) PAN_No (c) Cust_Name (d) Both (a) and (b) 30. Kabir’s computer teacher has asked him to prepare a flow chart based on a particular algorithm. He has done the work and showed file to his teacher. The teacher told him that everything is correct but he should use arrows in place of simple lines to show the flow. The command that will let him change the lines into arrow is (a) Format ® Line (b) Format ® Line ® Arrow (c) Format ® Object ® Line (d) Format ® Object ® Arrow 31. Vinay owns a retail shop. He is trying to keep a track of the sales of various products. There are several products and the information is scattered and disorganized and are presents in different locations. He cannot get an idea about his sales. Which of the following action he can do so that all the information is in one file? (a) Arrange data in workbooks (b) Arrange data in worksheets of a workbook (c) Leave data as it is (d) None of these 32. Swati is a teacher in a public school. She has entered marks of all the students of her SAMPLE PAPER 6 class and applied formulas to calculate their total and percentage. She has to find out the top 10 performing students from her class. Which of the following feature of spreadsheet she can apply to get the result? (a) Sorting data (b) Formatting data (c) Adding data (d) Displaying data 33. Aman, who works in the design department of a company. He has to make similar kind of documents with little bit of change in it. For this he is using a file that already has the required look and feel, with placeholders so that he can make few changes in it as per his needs. Which of the following option is mentioned above? (a) Tables (b) Charts (c) Templates (d) Macros

OMR SHEET SP 6 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

74 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 6

CBSE Sample Paper Information Technology Class X (Term I) 75 Answers 1. (a) 2. (c) 3. (a) 4. (d) 5. (a) 6. (b) 7. (a) 8. (d) 9. (b) 10. (c) 11. (b) 12. (c) 13. (a) 14. (b) 15. (a) 16. (b) 17. (a) 18. (b) 19. (d) 20. (b) 21. (a) 22. (d) 23. (b) 24. (a) 25. (a) 26. (a) 27. (a) 28. (b) 29. (d) 30. (c) 31. (b) 32. (a) 33. (c) SOLUTIONS 1. Stress is simply the body’s response to 10. External data sources that are registered in Calc SAMPLE PAPER 6 change that creates taxing demands. and databases with extension .odb. To register a Unmanaged stress affects our immune data source that is not in .odb format you can system also. Cortisol and adrenaline are the click on File ® New ® Database Command and two hormones which is released, when the select the database. stress level is increased. 11. An image can be embedded in a document by 2. A paragraph is a group of sentences that using drag and drop too. To link the file instead describe one idea. It presents an idea at a of embedding it, hold down the Ctrl + Shift keys time and prevent text from becoming while dragging the image. overwhelming. 12. A foreign key acts as a cross-reference between 3. WIMP (Windows, Icons, Menus, Pointers) tables because it references the primary key of requires much more RAM compared to the another table, thereby establishing a link between command line OS. It allows the user to them. access through pointing devices like mouse. 13. While working with multiple sheets, we can use 4. An independent worker plans actions to data from within a sheet or outside a sheet using accomplish the task in a way that help a qualified name and proper syntax. The syntax him/her keep an eye on the progress of to use data present on a different work sheet is work. Loose time management is not a feature in planning an action to accomplish a <Sheetname>.<Cellreference> task. 14. It is a good practice to use sorted data while 5. Taskbar, by default is present at the bottom applying the subtotals command to it. Sorting is of the desktop. It allows us to access all the the process of arranging data into meaningful opened programs. order, so that you can analyze it more effectively. 6. The role of feedback is to make the 15. The data source view pane appears above the communication effective and successful. spreadsheet with a list of registered databases in Only an effective communication can do the data explorer. In this you can view a table by this. clicking on the plus (+) sign too. The feedback should not be vague and 16. Styles help improve consistency in a document. should be conveyed with clarity. It is specific They also make major format changes easily. characteristic of communication. OpenOffice.org supports many types of styles. Frame styles are used to format graphic and text 7. Macros written in function and end function frames, including text wrap, borders, clauses can be used like the other functions backgrounds and columns. of Calc. 17. The clipboard is a special location on computer 8. OpenOffice.org provides several ways to memory that temporarily stores the cut or copied modify styles both predefined styles and text or other data. custom styles. By modifying the style template, you can change styles in more 18. From the given options, data field cannot be set than one document. as a primary key because it cannot be fixed for an object. 9. The range settings in the show changes dialog box displays only the changes that are 19. When you hold the Shift key while resizing it, the made in a specific range of cells. image is resized proportionally.

76 CBSE Sample Paper Information Technology Class X (Term I) 20. The external data dialog box is used to link 27. Writer allows you to create a style from scratch. to an external sheet. The URL of the source This new style is termed as custom style. Custom file is used in it. The command, Sheet ® styles display all the user-defined styles in the Link to External can be used to open the selected style category. ‘External Data’ dialog box. 28. Once you have recorded a macro, you can run it 21. An image has anchor points that can be as many times as you need. You can use or run a used to set the position of an image in a macro by following the command line-Tools ® document. Anchor tool sets the anchoring Macros ® Run Macro. options for the selected object. There are 5 options available to switch between. 29. Primary key and the alternate keys together are called the candidate keys. It means, all fields that 22. The boolean datatype is a sub-category of are eligible to be a primary key, are candidate number type that stores values in the form keys. PAN_No and Acc_No can be used as of 0 and 1, which represents, False and candidate key, since the PAN_No defines each True. individual is a unique value. 23. By using the formula, = A1 * B1, you can 30. If you just want to draw a straight line, click on calculate the product of the values present the line tool on the drawing toolbar. It can be in A1 and B1 cells. modified into arrows by using Format ® Object ® Line command. 24. By default, Writer evaluates 10 levels of headings when it builds the table of 31. Multiple sheets help us to keep information contents. To change the number of levels organized in a workbook. Different data can be evaluated, enter the desired number in the stored in separate sheets for a better organisation. evaluate up to level spin box. Associated data can be stored in a worksheet of a workbook. 25. To view the non-printing characters, choose View ® Non printing Characters from the 32. Sorting refers to ordering data in an increasing or menu bar, or press Ctrl+F10, or click on the a decreasing order. Sorting can be done on names, non-printing characters icon on the numbers and records. standard toolbar. 33. A template is a document which has been 26. Form option specifies if the link is to be designed with pre-existing themes, styles and presented as text or as a button. layouts. SAMPLE PAPER 6

SAMPLE PAPER 7 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability Skills. (1 ´ 5 = 5 marks) 1. ___________ stress is the stress that hits you when you find yourself in a tight spot, fighting for survival. (a) Mental (b) Survival (c) Internal (d) External 2. _______________ is the verbal communication that we have with ourselves. (a) Interpersonal (b) Intrapersonal (c) Intermediate (d) In-between 3. Which of the following file extension is of image file? (a) . avi (b) . txt (c) . mp3 (d) . bmp 4. _________________ is not a key element of meditation. (a) Silence (b) A closed mind (c) Relaxed breathing (d) None of these 5. Regular use of system tools and smart optimisation can enhance the ___________ of your computer. (a) look (b) interface (c) speed (d) quantity

78 CBSE Sample Paper Information Technology Class X (Term I) 6. My favourite jacket, the hooded one, is in need of a wash. The underlined part of the sentence is an example of which phrase? (a) Appositive phrase (b) Adjective phrase (c) Adverb phrase (d) Noun phrase Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. You cannot apply the sorting feature on which of these columns in a spreadsheet? (a) Name (b) Date of joining (c) Marks obtained (d) None of these 8. All the styles related information and management happens through a special management floating window in Writer, known as ________ and ________ window. (a) styles, formatting (b) styles, management (c) styles, features (d) management, features 9. Which of the following is the correct output of the formula, = Average(20, 25, 15, 40)? (a) No output (b) 20 (c) 25 (d) Error message 10. The one that is not a spreadsheet software from the following is (a) Excel (b) Calc (c) Lotus symphony (d) None of these 11. When the fill format mode is active, then using ___________ can undo the actions you want to keep. (a) left-click (b) esc key (c) right-click (d) shift key 12. When multiple entries of the same data are present that mismatch, are known as (a) data redundancy (b) data inconsistency (c) data repeating (d) None of these 13. _________ allows you to gather data from different worksheets into a master worksheet. (a) Goal seek (b) Solver (c) Data consolidation (d) Data sum 14. In which option we have to specify the target range, the place where we want the result to be displayed (a) copy results to (b) show results to SAMPLE PAPER 7 (c) target range (d) show range 15. Which option is used to name a range of cells? (a) Cell range (b) Select range (c) Name range (d) Define range 16. To preview the document of a particular recipient, enter the record number of a recipient in the _________________ box. (a) Active Mail Merge Entry (b) Current Mail Merge Entry (c) Recipient Mail Merge Entry (d) All of these

CBSE Sample Paper Information Technology Class X (Term I) 79 17. Which of the following command is used to change the fill-colour of a drawing object? (a) Format ® Object ® Area (b) Format ® Object ® Colour (c) Object ® Format ® Area (d) Object ® Area ® Format 18. In subtotals, we can select upto _______ groups of arrays. (a) 3 (b) 4 (c) 5 (d) infinite 19. Which of the following types of drawing objects is not supported by Writer? (a) Curves (b) Lines (c) TextArts (d) Painting 20. We can shift from one scenario to another by _____________. (a) navigator (b) find and replace (c) data source (d) None of these 21. By default, writer uses only the first three levels in the table of contents. ___________, indexes & tables and ______________ are those levels. (a) entry, bibliography (b) entry, credits (c) start, bibliography (d) start, credits 22. Which of the following fields cannot be used as a primary key? (a) Employee Id (b) Employee DOB (c) Student admission number (d) An AutoNumber field 23. To select random multiple cells, hold down ________ key as you click on each cell. (a) Alt (b) Shift (c) Ctrl (d) All of these 24. Mail merge is a technique to merge text with addressed to create ______________ letters. (a) unique (b) personalised (c) Both (a) and (b) (d) None of these 25. The ___________ tool on the drawing toolbar is used to draw a circle in a document. (a) ellipse (b) circle (c) curve (d) closed curve 26. Hyperlink dialog box in Calc shows ________ options on left hand side. (a) internet (b) document (c) new document (d) All of these Section C SAMPLE PAPER 7 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Javed has to create a document containing various shapes. Using drawing toolbar he has made the shapes that were needed. Now he has to change the fill-colour to blue and the line colour to grey. As there are many shapes, he was wondering the formatting can be applied together on all the shapes. Which of the following option he should use to combine all shapes and format it together? (a) Combine (b) Group (c) Both (a) and (b) (d) None of these

80 CBSE Sample Paper Information Technology Class X (Term I) 28. There are three users working on a shared spreadsheet and the changes made by them happen to affect the same cells. It means the changes made by all of them are conflicting. Since, the changes conflict which of the following dialog box can be used to solve these conflicts? (a) Resolve conflicts (b) Solve conflicts (c) Share conflict (d) None of these 29. Sujal has created a database to store various information about all members that are associated with his NGO. He wanted to enter all their details to be stored in the table Member_Info. He does not have much time, so he has asked his assistant to enter all the details. But he thought he might not understand the fieldnames used, hence decided to create an interface, using which his assistant can enter the data and it can be stored in Member_Info table. Which object of database management system allows us to do so? (a) Module (b) Query (c) Form (d) Report 30. Srikant has decided to create a template. He has used a default template, made some changes in it as per his requirement and saved it. Now that Srikant has his own template, he wants to make it as default template. Which of the following dialog box has the setting to make his template as default template? (a) Template setting (b) Template management (c) Template format (d) Organize template 31. Ananya is working on a spreadsheet containing large amount of data. She has to do repeated tasks in the worksheets. For reduce her workload and effective usage of time, she has created a macro. She is trying to save the macro with a name but she is not able to do so, as her macro name is not valid. Which of the following error she might be making while doing so? (a) The name might be starting with an alphabet (b) The name might be starting with a number (c) The name might be a combination of alphabet and number (d) None of the above 32. Priya is a class teacher. She has created a worksheet to enter the marks and calculate the total and percentage of the students of her class. She has applied the SUM function to find the total marks scored by each student. To find the percentage, which of the following formula can be used if the reference of the cell showing total marks obtained is D5, out of marks is in cell M8? (a) = Percentage (D5, M8) (b) = D5 * M8100 (c) = D5/M8*100 (d) = Percentage (M8, D5) SAMPLE PAPER 7 33. Punit works in a private firm. They have decided to send the new set of office rules in this time of pandemic as they are going to open soon. They want to send a personalised letter all employees. He is using mail merge feature to complete this task. He has put the placeholder for individual address, in the main document. This placeholder is technically known as (a) data source (b) merged document (c) merged fields (d) merged source

OMR SHEET SP 7 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

82 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 7

CBSE Sample Paper Information Technology Class X (Term I) 83 Answers 1. (b) 2. (b) 3. (d) 4. (b) 5. (c) 6. (a) 7. (d) 8. (a) 9. (c) 10. (d) 11. (c) 12. (b) 13. (c) 14. (a) 15. (d) 16. (b) 17. (a) 18. (a) 19. (d) 20. (a) 21. (a) 22. (b) 23. (c) 24. (c) 25. (a) 26. (d) 27. (b) 28. (a) 29. (c) 30. (b) 31. (b) 32. (c) 33. (a) SOLUTIONS 1. Survival stress is the stress that hits you when you and formatting window. When the fill SAMPLE PAPER 7 find yourself in a tight spot, fighting for survival. format mode is active, then using right Lack of money, or sometimes an excess of it, can click can undo the actions you want to contribute to survival stress. keep. 2. Intrapersonal communication is that we have with 12. Multiple mismatch copies of same data is ourselves. Within our minds, we sort out our known as data inconsistency. It is a thoughts, simultaneously playing the role of the situation when there are multiple tables sender as well as the receiver. within a database that deals with the same data but have received it from different 3. A file can be a picture you have drawn, an image inputs. which you have downloaded from the Internet or a poem which you have typed. File extensions are 13. Data consolidation refers to the collection usually of 3-4 letters. Some of the image file and integration of data from multiple extension names are – .jpeg, .gif,.png and .bmp. sources into a single destination. 4. Meditation is a sure way to not only relieve stress 14. If you try to consolidate data by selecting but also gain a feeling of inner peace. The three different ranges from the same advantage of meditation is that one can practice it worksheet, it simply clubs the ranges one anywhere and anytime. A relaxed mind instead of below the other. Clicking on the copy a closed mind is a key element of meditation. results to list box, you can select the cell of the target range to display the result. 5. Regular use of system tools and smart optimisation like, disk cleanup, can speedup your 15. By using the option define range in Calc, computer. we can assign a name to a selected range of cells. 6. An appositive phrase is a noun phrase that follows another noun or noun phrase and provides further 16. After finishing all the steps using mail information that identifies the preceding noun or merge wizard, the merged letters will open noun phrase. up. The document of a particular recipient can be named by entering the record 7. Sorting feature is used to arrange the data on a number in the Current Mail Merge Entry worksheet in ascending or descending order. box. 8. All the styles related information and 17. The area dialog box allows us to change the management happens through a special fill colour of a selected object. The management, a special floating or dockable command, Format ® Object ® Area in window in Writer, known as styles and formatting order to apply or change the fill-colour of a window. drawing object. 9. The average function is a statistical function that 18. The subtotal function allows users to create will calculate the arithmetic mean of the values groups and then perform various other entered in a cell or a range of cells. The formula = functions. Upto three groups of array can Average (20, 25, 15, 40) will give 25 as output. be selected in a subtotal. 10. Spreadsheet software is a software application 19. Drawing toolbar offers various types of capable of organizing, storing and analyzing data drawing objects in Write. Some of them are in tabular form. Excel, Calc and Lotus symphony : Autoshapes, Arrows, Graphics, Curves, are spreadsheet softwares. Lines, TextArts etc. 11. Use fill format to apply a style to many different Painting is not a type of drawing object areas quickly without having to go back to styles supported by Writer.

84 CBSE Sample Paper Information Technology Class X (Term I) 20. Using navigator, we can shift from one 28. When there are conflicts in changes made by scenario to another. The navigator is also multiple users, these conflicts can be resolved by used to select and delete a particular scenario. using the resolve conflicts dialog box and select the version you want to keep. 21. Writer provides functionality to create TOC and one must create TOC using the 29. A form is an interface in user defined layout that functionality provided. Entry, indexes & lets user to enter, change data directly in the tables and bibliography are the three levels in table. the table of contents that is present by default. 30. By default, when you create a new document in Writer, it creates a document based on its 22. For a filed to be used as a primary key, it default template. If you want to use a particular should only unique values as no duplication template to be open whenever you create a of data is allowed. We cannot use data of document in Writer, you need to set that birth of employees as primary key. Since that template as default. data is not unique to an individual. There are many people who are born on the same data. 31. Macro names should only consist of alphanumeric characters and underscores, i.e. 23. In order to select random multiple cell hold 'a-z' , 'A-Z' , '0-9' , and '_' , and the first character down Ctrl key as you click on each cell. should not be a digit. While typing a macro name, if you start it with a number it will not 24. Mail merge feature automatically merges a accept it, as a macro name should always start common text with a set of data coming from a with an alphabet. database to produce unique letters. 32. A formula is an equation that makes 25. To draw a circle or square, click ellipse or calculations based on the data in your rectangle tool on the drawing toolbar and spreadsheet. They must begin with an equal then click on the document. sign, followed by the addresses of the cells that will be calculated upon, with an appropriate 26. On the Insert tab, select hyperlink. You can operand placed in between. The formula = also right-click the cell and then select D5/M8*100 will calculate the percentage taking hyperlink on the shortcut menu, or you can the values present in cell D5 and M8. press Ctrl+K. The hyperlink dialog box in Calc shows internet, document and new 33. Mail merge process merge the Main document document options. with data source using the merge fields to create unique documents the merge fields placeholder 27. Grouping allows you to combine multiple is the location where the values will be inserted objects to behave like one object. It can be from a datasource for the respective fields. done by holding the Shift key while clicking on them. SAMPLE PAPER 7

SAMPLE PAPER 8 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability Skills. (1 ´ 5 = 5 marks) 1. ______________ is an effective method to learn the art of freely interacting with people, at the same time boosting your self-confidence. (a) Listening (b) Public speaking (c) Playing (d) Working out 2. Which of the following is not a symptom of stress? (a) Irritability (b) Insomnia (c) Fatigue (d) Fever 3. When you start a computer, the operating system gets loaded into the main memory from the hard disk. This is called ____________. (a) uploading (b) booting (c) starting (d) downloading 4. Unless the students are clear about their learning target, ____________ is irrelevant. (a) feedback (b) solution (c) Both (a) and (b) (d) None of these 5. _______________ is a windows’ utility that consolidates fragmented files and folders on your computer’s hard disk. (a) Disk cleanup (b) Disk consolidation (c) Disk defragmenter (d) None of these

86 CBSE Sample Paper Information Technology Class X (Term I) 6. The drive within you that compels you to complete tasks is (a) self-motivation (b) self-regulation (c) self-awareness (d) self-sufficient Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. ____________ formatting include margins, headers and footers, borders and backgrounds. It also includes margins, headers and footers, borders and backgrounds. (a) Page (b) Paragraph (c) Character (d) Frame 8. Which of the following symbol is used as exponentiation operator? (a) % (b) $ (c) ^ (d) / 9. A deleted column or row in shared worksheet is marked by a ______________ colored bar. (a) red (b) heavy (c) thin (d) regular 10. Select _________________, if you want the styles being copied to replace any styles of the same names in the document you are copying them into. (a) Replace (b) Change (c) Overwrite (d) Save 11. A macro is a saved _______________ or __________ that are stored for later use in spreadsheets. (a) sequence of commands, keystrokes (b) keystrokes, messages (c) messages, sequence of commands (d) None of these 12. In the insert picture dialog box, select ______________ to view a thumbnail of the selected image on the right, so you can verify that you have the correct file. (a) preview (b) show (c) display (d) copy 13. In Calc, when a document is created and saved, it automatically contains a library named (a) macro library (b) standard library (c) module library (d) document library 14. When data is stored, maintained and retrieved from multiple tables, then special database software are required called ___________. SAMPLE PAPER 8 (a) RDBMS (b) DBMS (c) multiple DBMS (d) None of these 15. ___________ and ____________ are two ways to modify an image. (a) Cropping, deleting (b) Deleting, rotating (c) Rotating, cropping (d) Resizing, deleting 16. The correct formula to refer to cell A5 in the sheet named ‘Dept’ in OpenOffice is (a) = A5 (b) = Dept.A5 (c) = $Dept.A5 (d) = ‘Dept’- A5

CBSE Sample Paper Information Technology Class X (Term I) 87 17. Which of the following filters joins groups of pixels into a single area of one color? (a) Pop art (b) Sharpen (c) Relief (d) Mosaic 18. Which of the following elements are present in “Insert Sheet” dialog box? (a) Before current sheet (b) After current sheet (c) Number of sheet (d) All of these 19. Which option is suitable to calculate the effect of different interest rates on an investment? (a) Subtotals (b) Scenarios (c) Consolidation (d) None of these 20. We can ______________ the data by using row labels as well as column labels. (a) consolidate (b) merge (c) delete (d) reflect 21. Which of the following data types cannot store decimal values? (a) Real (b) Numeric (c) Decimal (d) Boolean 22. Which of the following option is not available in graphics mode of picture toolbar? (a) Original (b) Greyscale (c) Watermark (d) Black/White 23. In the formula, =SUM(B2 : B8), the address used here is an example of ____________ reference. (a) absolute (b) mixed (c) relative (d) real 24. To retain original proportion of the graphic, hold ________ key and click one of the corner handles. (a) Ctrl (b) Alt (c) Tab (d) Shift 25. The file extension of a document created by using the spreadsheet software Calc is (a) .ods (b) .odt (c) .odb (d) .osd 26. Which of the following levels of headings can be indexed in Writer? (a) H1 (b) H3 (c) H2 (d) All of these Section C Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Karim works as account officer in a company. He is preparing the salary for the current month. Due to pandemic, the company has decided to cut down the salary by 10% in SAMPLE PAPER 8 order to minimize its losses. Karim has to write a formula to calculate the final salary. Which of the following symbol is used to start a formula? (a) $ (b) = (c) # (d) @ 28. Anita wants that her company’s logo should automatically appear on the top and company’s address at the bottom of the Writer document, whenever she opens a new document. Which feature of Writer will help her to do so? (a) Style (b) Mail merge (c) Template (d) Draft

88 CBSE Sample Paper Information Technology Class X (Term I) 29. Varun is a comic book writer. He is working on a new project, in this he has started with two characters, amongst whom there is conversation is going on. He is using the Word processor software using which he wants to show the conversation. Which of the following tool under drawing toolbar is most suitable to show the dialog delivery happening between the characters ? (a) Ellipse (b) Callouts (c) Stars (d) Line 30. Divya has created a table using Base that has several fields, one such field is name. While entering the data, she wants that the name field should not be left blank. Help her in identifying the field property she should apply for this purpose. (a) Entry required (b) Entry must (c) Entry mandatory (d) No such property is there 31. Imran is celebrating his 15th birthday. He wants to invite his friends and family members to his birthday party. He has decided the venue and timing of the birthday party. Which feature will he use to send the same invitation to all these people with the same content but with different addresses without typing it again and again? (a) Letter wizard (b) Document wizard (c) Mail merge (d) Mail all 32. Arvind has scored 76 out of 100 in Science, 86 out of 100 in Mathematics and 72 out of 100 in Social Science. He wants to calculate the score he should get in English to achieve 90 per cent in overall. Suggest a suitable option out of the following to do so. (a) Macro (b) Goal seek (c) Subtotal (d) All of these 33. Manish is a bookseller. He creates a report every month to view the sales and calculate the profit. He colors the names of the customers with overdue account in red color and applies bold formatting to them. He has to do this every time. To speed up his work, he can create a macro and apply these formatting quickly. Under which menu, the Macro option is available? (a) Tools (b) Data (c) File (d) Edit SAMPLE PAPER 8

OMR SHEET SP 8 Roll No. Sub Code. Student Name Instructions Use black or blue ball point pens and avoid Gel & Fountain pens for filling the OMR sheet. Darken the bubbles completely. Don’t put a tick mark or a cross mark, half-filled or over-filled bubbles will not be read by the software.  Correct Incorrect Incorrect Incorrect Do not write anything on the OMR Sheet. Multiple markings are invalid. 1 12 23 2 13 24 3 14 25 4 15 26 5 16 27 6 17 28 7 18 29 8 19 30 9 20 31 10 21 32 11 22 33 Check Your Performance Score Percentage = Total Correct Questions 100 Total Questions: × Total Correct Questions: Total Questions Less than 60% > Average (Revise the concepts again) If Your Score is Greater than 60% but less than 75% > Good (Do more practice) Above 75% > Excellent (Keep it on)

90 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 8

CBSE Sample Paper Information Technology Class X (Term I) 91 Answers 1. (b) 2. (d) 3. (b) 4. (a) 5. (c) 6. (a) 7. (a) 8. (c) 9. (b) 10. (c) 11. (a) 12. (a) 13. (b) 14. (a) 15. (c) 16. (c) 17. (d) 18. (d) 19. (b) 20. (a) 21. (d) 22. (a) 23. (c) 24. (d) 25. (a) 26. (d) 27. (b) 28. (c) 29. (b) 30. (a) 31. (c) 32. (b) 33. (a) SOLUTIONS 1. A good public speaker will have a sharpened shared worksheet, it is marked by a heavy SAMPLE PAPER 8 critical thinking as well as good verbal and colored bar. non-verbal communication skills. Studies reveal that public speaking is the greatest fear 10. To copy the styles from another document, among people. click the file button to open a window from which you can select the required document. 2. There are some certain signs and symptoms of You can select Overwrite option, if you want stress that we should pay attention to the style being copied to replace any style with otherwise it can lead to major problems. Some the same name. of the symptoms of stress are insomnia, fatigue and irritability whereas fever is not a 11. A macro is a saved sequence of commands or symptom of stress. keystrokes that are stored for later use. It minimises our work and saves time. 3. When you start a computer, the operating system gets loaded into the main memory 12. At the bottom of the insert picture dialog box from the hard disk. This is called booting. there are two options, preview and link. The preview option allows us to view a thumbnail 4. For feedback to be useful to the student, it of the selected image. should be given during the learning process, so that there is still time to take action based 13. The standard library resides locally in your on it and improve. user directory and is the default library that is available when a document is created. 5. Disk defragmenter increases the overall performance of your system by storing the 14. When data is stored, maintained and retrieved files in contiguous spaces in the memory. from multiple tables, then special database softwares are requried called RDBMS 6. A self-motivated person is driven to evolve (Relational Database Management System). into a natural independent worker who helps others along the way. A self-motivated person 15. The picture toolbar is used for resizing, does not wait for someone to tell them, what cropping and a work around to rotate a picture. to do instead they the initiative and tries to Cropping, resizing and rotating are different complete a task on their own. methods, that are used to modify an image. 7. Styles help improve consistency in a 16. To reference any cell or range of cells in another document. When you apply a style, you apply worksheet, put dollar “$” followed by sheet a whole group of formats at the same time. name then a dot (.), then the cell address. Page formatting is used to organize the structure of a document and also for page 17. Mosaic filter joins groups of pixels into a single formatting, such as page number, header and area of one color, whereas the pop art filter footer, page size, etc. modifies the picture dramatically. 8. Operators are symbols used in a formula to 18. The Insert Sheet dialog box allows us to insert a define the relationship between two or more sheet, before active sheet, after active sheet or cell references or between two or more values. next to selected sheet number. The ‘^’ symbol is used as exponential operator. For example, 2^3 will give 8 as the 19. By using What-if analysis tool in spreadsheet, output. you can use several different sets of values in one or more formulas to explore all the various 9. Shared workbook is a feature that allows you results. Scenarios can be used to calculate the to collaborate on a workbook with multiple effect of different interest rates on an people. If a column or row is deleted in a investment as it works an as per the input value to do the calculation.

92 CBSE Sample Paper Information Technology Class X (Term I) 20. The data consolidation function takes data 27. A formula always starts with an equal to (=) from a series of worksheets or workbooks and symbol. Without this symbol, anything written summaries it into a single worksheet that you in the cell is considered as normal text. can update easily. Data consolidation can be done using row lables as well as column 28. She should use template to get the document as labels. her needs. 21. If you use decimal data type and specify two Templates are pre-set layouts that make it easy decimals, base should store and display two to create and shape different types of decimals. The boolean datatype can store documents. either true (1) or false (0) based on the condition. 29. A callout is a type of text box that also includes a line for pointing to any location on the 22. The picture toolbar is a docked toolbar that document. A callout is helpful when you need contains various options to enhance the to identify and to explain parts of a picture. picture. In the picture toolbar, under the graphic mode ‘original’ option is not available. 30. If a field is not a primary key and you don’t want it to be left blank while entering data, 23. The relative reference changes when the then the entry required field property can be formula is copied to any other cell or any other selected for it. worksheet. 31. Mail merge is a feature that allows us to send For example, = SUM (B2 : B8) the same message to multiple people with different addresses, without typing the 24. By holding down the Shift key while dragging message again and again. using corner handles keep the original proportionality of the image. 32. The goal seek function is a method of solving for a desired output by changing an 25. The file extension suggests the type of the file. assumption that drives it. The function For Calc, it is .ods and templates are saved essentially uses a trial and error approach to with extension .ots. back-solving the problem by plugging in guesses until it arrives at the answer. 26. Writer’s table of contents feature lets you build an automated table of contents from the 33. Macro feature of Calc allows you to record a set headings in your document. Writer provides 3 of actions that you perform repeatedly in a levels of heading by default as H1, H2 and H3. spreadsheet. Under Tools menu, the Macro You can add as many headings as per the option is available using which you can record document length in Writer. a macro. SAMPLE PAPER 8

SAMPLE PAPER 9 INFORMATION TECHNOLOGY A Highly Simulated Practice Questions Paper for CBSE Class X (Term I) Examination Instructions 1. Please read the instructions carefully. 2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C. 3. Section A is of 05 marks and has 06 questions on Employability Skills. 4. Section B is of 15 marks and has 20 questions on Subject Specific Skills. 5. Section C is of 05 marks and has 07 competency-based questions. 6. Do as per the instructions given in the respective sections. 7. Marks allotted are mentioned against each section/question. 8. All questions must be attempted in the correct order. Roll No. Maximum Marks : 25 Time allowed : 60 min Section A Answer any 5 questions out of the given 6 questions on Employability Skills. (1 ´ 5 = 5 marks) 1. ______________ barriers are created in the mind by none other than ourselves, through preconceived notions and the stereotyping of people. (a) Imaginative (b) Perceptual (c) Language (d) Cultural 2. Regular exercise helps pep your mood and can take your mind off a lot of worry and negativity which are the main feed of stress. Which of the following activity is not considered as exercise? (a) Walking (b) Jogging (c) Swimming (d) Talking 3. Moving a folder or a file means _________ it from its original location and placing it at another location. (a) removing (b) leaving (c) pointing (d) None of these 4. Which of the following sentences is in passive voice? (a) By whom was the mess cleaned? (b) The birds were being fed by my sister. (c) Uncle Rakesh teaches my brother. (d) Both (a) and (b) 5. Kaspersky, McAfee are examples of popular _______________. (a) image editing software (b) anti-virus software (c) word-processing software (d) DBMS

94 CBSE Sample Paper Information Technology Class X (Term I) 6. ____________ builds up over a period of time and takes a toll on the body due to overwork. (a) Fatigue (b) Depression (c) Irritability (d) None of these Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. The ____________ tab under the New Address List dialog box allows us to add or remove fields. (a) insert (b) customize (c) create (d) modify 8. If you want to use a function from the calculate subtotal box, then select the function you want to use for calculation from the _______________ box. (a) apply function (b) use function (c) choose function (d) select function 9. In the Solver dialog box, when you click on the Solve button, a dialog box appears informing you that the solving successfully finish. You can click on _____________ button, if you are satisfied with the result. (a) save result (b) save (c) keep result (d) None of these 10. The settings of the ___________ and ____________ tabs must be reset manually as there is no Reset button for them, while customizing the TOC. (a) entries, styles (b) columns, background (c) background, style (d) columns, entries 11. In order to create a hyperlink in a workbook, you can click on the hyperlink tool on ___________ toolbar or click on ______________ from the menu bar. (a) Standard, Data ® Hyperlink (b) Drawing, Insert ® Hyperlink (c) Standard, Insert ® Hyperlink (d) Drawing, Data ® Hyperlink 12. The type of alignment that places the text evenly between the left and the right margins is (a) center (b) justify (c) line (d) with margin 13. Which of the following option disabled under Data menu when a sheet is shared? (a) Subtotal (b) Sort (c) Validity (d) All of these 14. ______________ is the type of database that are mainly used in a networked SAMPLE PAPER 9 environment, where centralised database is administered at multiple locations on the network. (a) Relational database (b) Distributed database (c) Flat database (d) None of these 15. The shortcut key to open Style and Formatting dialog box is ________. (a) F10 (b) F12 (c) F11 (d) F8 16. By pressing the ____________ key combination, we can open the Comment dialog box. (a) Ctrl + Alt + C (b) Alt + C (c) Ctrl + C (d) Ctrl + Shift + C

CBSE Sample Paper Information Technology Class X (Term I) 95 17. Which of the following option does not come under the paragraph style? (a) Bold (b) Tab stop (c) Alignment (d) Line spacing 18. Interpret the type and cell address that is passed in the given formula, = Sum(C2 : C6) (a) Relative; From C2 to C6 (b) Absolute; From C2 to C6 (c) Relative; C2 and C6 (d) Absolute; C2 and C6 19. The Paste Special dialog box does not have _____________ option under Shift cells. (a) down (b) right (c) in cell (d) don’t shift 20. Which of the following action you should do in order to make use of disabled commands under any menu? (a) Share worksheet (b) Copy worksheet (c) Move worksheet (d) Unshare worksheet 21. Table is the basic building block of any database that helps to create a framework for storage of data. _____________ and _____________ are components of a table. (a) Forms, record (b) Record, field (c) Field, form (d) Form, report 22. The ________________ and _________________ additional toolbars can also be used to modify the images for corrections and to obtain special effects. (a) filter, color (b) effects, color (c) special effects, filters (d) None of these 23. Which of the following operator is used for ‘greater than equals to’ operation? (a) <= (b) <> (c) >= (d) None of these 24. The “LS” button in Entries tab of Insert Index / Table of Content dialog box represents (a) end of a hyperlink (b) left side (c) start of a hyperlink (d) None of these 25. When you enter the module name in New Module dialog box and click OK button , the new module gets created and the ___________ window appears. (a) IDLE (b) OOPS (c) ADD (d) MODULE 26. OpenOffice Writer does not contain any template in MyTemplates category. Which of the following options can be used to get templates? (a) Import templates from other applications (b) Download themes (c) Get more templates online (d) Load templates from another folder Section C SAMPLE PAPER 9 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Nitin is having ` 50,000, that he wants to invest in two mutual funds for a year. The interest rates are 8% and 10%, respectively. He is wondering how much money he should he invest in each fund to earn a total interest of ` 10,000. Out of the following which option he can use to find the answer? (a) Subtotal (b) Scenario (c) Solver (d) Consolidate

96 CBSE Sample Paper Information Technology Class X (Term I) 28. Geeta has to add some images in her document she is preparing. She has downloaded few images to be used for her project from Internet. She has even added these images in her document, but she has found that the direction of one of the images is just the opposite of what she needed. Which of the following option she can use to change its direction as she needed? (a) Flip vertically (b) Flip right (c) Flip left (d) Flip opposite 29. Sumit is a professor in a college. He has prepared notes in his subject for his students. Before he circulates the notes to his students, he wanted to make sure that these notes are not copied by someone else. Which of the following option he can use so that even if anyone takes a hardcopy of it, there will be a mark behind the text showing his name? (a) Faintmark (b) Watermark (c) Imagemark (d) None of these 30. Manjeet is working as a transport coordinator in a public school. There was some problem in a particular route. He has to arrange for an alternative for all those students. He has only one table containing all the details of students. Using which object of database, he can get the list of students without affecting the original table? (a) Forms (b) Query (c) Reports (d) Macro 31. Bhumika has made a table of contents page for a book that they are going to refer. To go to a particular chapter, it consists of heading and sub-heading of the book. She was trying to find the qualities of a good table of contents. From the following points she has found, which one is not a characteristic of a good table of contents? (a) Easy to read (b) Simple to use (c) It should be present before the title page (d) Accurate and easily accessible 32. Government of India has done a census on Tigers. They have collected the data from various states and Fahim who is working in the ministry has been assigned the job of entering all the data on different sheets in a workbook. He has done the job, but he is not sure which sheet contains data of which state. For this he has to open the sheet. Suggest an option using which he does not have to open the sheet to know the state name. (a) Renaming sheets (b) Copying sheets (c) Adding sheets (d) Changing sheets 33. Anjali is the timetable in-charge in a school. Since, the new session is round the corner, she needs to prepare timetable for the coming session. She has made the timetable for a class applying required formatting. She has to repeat the same formatting for all other SAMPLE PAPER 9 classes too. Which of the following option, she can use to apply the formatting with one click and can save valuable time? (a) Conditional formatting (b) Applying formatting (c) Using macro (d) Using validation