Information technology Sample Paper

OMR SHEET SP 9 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)

98 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 9

CBSE Sample Paper Information Technology Class X (Term I) 99 Answers 1. (b) 2. (d) 3. (a) 4. (d) 5. (b) 6. (a) 7. (b) 8. (b) 9. (c) 10. (a) 11. (c) 12. (b) 13. (d) 14. (b) 15. (c) 16. (a) 17. (a) 18. (a) 19. (c) 20. (d) 21. (b) 22. (a) 23. (c) 24. (c) 25. (a) 26. (c) 27. (b) 28. (a) 29. (b) 30. (b) 31. (c) 32. (a) 33. (c) SOLUTIONS 1. Perceptual barriers are created in the mind by 10. The reset button present on the tabs of table SAMPLE PAPER 9 none other than ourselves, through of contents dialog box is used to reset the preconceived notions and the stereotyping of default settings. The settings of the entries people. and background tabs has to be reset manually while customizing the table of contents. 2. Walking, jogging, dancing, swimming and sessions at the gym have all been found to be 11. The hyperlink creates a shortcut that jumps to useful stress busters. Talking is not considered another location in the current workbook, or as a type of exercise. opens a document stored on the Internet. The hyperlink tool is available standard toolbar. A 3. Moving a folder or a file means removing it hyperlink can also be created by selecting from its original location and placing it at Insert menu and then Hyperlink option from another location. it. Copying a folder or a file means placing it at 12. Alignment refers to where and how the text another location without removing it from its are lines up. There are 4 types of text original location. alignment – Left, Right, Center and Justify. The justify alignment in a document places 4. A passive voice construction is a grammatical the text evenly between the left and right voice construction that is found in many margins. languages. In the passive voice, the subject becomes the object and the object becomes the 13. When a worksheet is shared, there are many subject. options such as Subtotal, Sort, Validity, etc., that are disabled in order to maintain Options (a) and (b) are examples of passive objectivity. voice sentence. 14. Databases are broadly categorised as : Flat, 5. Anti-virus are computer software which are relational and distributed. Distributed used to prevent, identify, detect and remove all database is used in a network environment. kinds of malicious software. There is a centralised database that is administered. e.g. Kaspersky, McAfee, AVG etc. 15. The Style and Formatting dialog box allows 6. Fatigue builds up over a period of time and us to use and modify styles. You can also use takes a toll on the body. It is caused by F11 key to open style and formatting dialog overwork and long hours at work, school or box. home. 16. Comment acts as notes which the user or 7. To create a data source following command can reviewer often use to exchange ideas and be used. Insert Address Block ® Select Address suggestions. By pressing Ctrl+Alt +C, you can List ® Create ® New Address List ® add comments. Customize. 17. The paragraph styles are used to control all 8. The subtotal feature in Calc, helps to use aspects of a paragraph. It includes statistical functions like – Sum, Average, Count, paragraph’s appearance, such as text Max, Product, etc. A function can be selected for alignment, tab stops, line spacing, etc. Bold is doing specific type of calculation from the use an example of character style. function box. 18. The relative reference is relative in nature; it 9. The Solver dialog box has the following changes automatically when you copy the parameters are used: Target cell, By Changing formula to another cell. cell, Limiting conditions. If you are satisfied with the result you can select keep result option in the Solver dialog box.

100 CBSE Sample Paper Information Technology Class X (Term I) 19. Paste special allows the items being time. Templates can be added in MyTemplate transferred to be formatted in several category by using get more templates online different ways. The Paste Special dialog box option. does not have in cell option under shift cells. 27. He can use scenario as option to find the 20. You can unshare the worksheet, to make use answer. of any command that is disabled when a worksheet is shared. 28. Flip horizontally or vertically option is used to change the direction of image. To do so click on 21. The horizontal rows are called records and the flip horizontally or flip vertically icon. the vertical columns in a table having a single type of information are called fields. 29. A watermark can be used to protect confidential information and to indicate the validity of the 22. The filter tool provides many options to add document. filter effect to the image. Filters enhance the look of the image. Filter and color toolbars 30. A query is a request for data or information can be used to modify the images too. from a database table. A query can give you an answer to a simple question, perform 23. Comparative operators are found in formulas calculations, combine data from different tables, that use the IF function and return either a add, modify or delete data from a database. true or false answer. > = (greater than equals to) is a comparison operation. 31. A table of contents acts as a map for the users. It allows them to find the information in the 24. ‘LS’ button on the entries tab of Insert document using the chapter name and page Index/Table of Contents dialog box number. A table of content should be present represents the start of a hyperlink. after the title page. 25. IDLE stands for Integrated Development 32. The default name that appears on the sheet tab Environment, which allows you to modify is Sheet 1. It can be renamed so that you know the code. Some commonly used IDLE which sheet contains what data without opening softwares are; Visual Studio, Netbeans, J it. Developer, etc. 33. The macros feature of Calc allows you to record 26. Template refers to a sample document which a set of actions that you perform repeatedly in a is not completely blank. It already has some spreadsheet. data filled in it, which can be used to save SAMPLE PAPER 9

SAMPLE PAPER 10 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 the first screen that is displayed after switching on the Windows. (a) My computer (b) Desktop (c) Windows (d) Login 2. Coherent is one of the 7’c of effecting communication. It means, the communication should be smooth and ____________. (a) logical (b) long (c) short (d) specific 3. Stress management infuses a sense of ____________ and accomplishment. (a) pressure (b) control (c) threat (d) None of these 4. A _________ is a network security device that monitors incoming and outgoing network. It restricts access to unwanted sites. (a) firewall (b) anti-virus (c) block sites (d) None of these 5. _____________ are the people who are too focused on what others think and they fail to focus on their internal matters. (a) Seekers (b) Introspectors (c) Gold diggers (d) Pleasers

102 CBSE Sample Paper Information Technology Class X (Term I) 6. Please pass me the sauce. This sentence is a type of _______________ sentence. (a) assertive (b) interrogative (c) imperative (d) exclamatory Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. The formula = Division(20, 5) will give _____________ as output. (a) 4 (b) Division(20,5) (c) Error message (d) None of these 8. Goal Seek is also called as _______________ is one of the What-if analysis tools that is available in Calc. (a) back-solving (b) forward-solving (c) solver (d) result analysis 9. Which of the following is not a style type in Writer? (a) Frame style (b) Image style (c) List style (d) Character style 10. In the given formula, identify the type of reference and the cells that are passed as arguments. = Average($A$5, $B$5) (a) Absolute reference; cells are-A5 and B5 (b) Relative reference; cells are-A5 and B5 (c) Relative reference; cells are-A5 to B5 (d) Absolute reference; cells are-A5 to B5 11. A primary key field cannot be null, which also means that it cannot be ____________. (a) invalid (b) positive (c) alphanumeric (d) empty 12. You can move a dockable window to a convenient position on the screen by holding down the _____________ key and drag it by the title bar to where you want it docked. (a) Ctrl (b) Alt (c) Shift (d) Windows 13. _________________ is particularly useful when creating a watermark or when wrapping the image in the background. (a) Transparency (b) Watermark (c) Enhance (d) Follow 14. In order to use data from a worksheet, you need to use its ____________ name. SAMPLE PAPER 10 (a) alias (b) representative (c) qualified (d) quantified 15. If you see #### in place of data in a cell, it means you need to ___________ the cell width. (a) increase (b) decrease (c) Both (a) and (b) (d) None of these 16. When user inserts a new worksheet in spreadsheet software, the new worksheet will be inserted to ___________. (a) at the end of sheet tab (b) in the beginning of sheet tab (c) next to active sheet (d) None of these

CBSE Sample Paper Information Technology Class X (Term I) 103 17. ________________ ensure that all the documents have a standard layout, look and feel. (a) Graphics (b) Layout (c) Properties (d) Templates 18. _____________ is a list, usually found on a page before the start of a written work, of its chapter or section titles or brief descriptions with their commencing page numbers. (a) Preface (b) Table of contents (c) Acknowledgements (d) Page title 19. _______________ are descriptions about the changes made in cells during record changes mode. (a) Tips (b) Messages (c) Comments (d) None of these 20. For sorting through macro, the selected cell range must be _______________. (a) identical (b) different (c) Both (a) and (b) (d) formatted 21. A _____________ can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope. (a) data source (b) database (c) mail merge (d) E-mail 22. A table in a relational database is also called as _______________. (a) tuple (b) records (c) results (d) relation 23. Which of the following is not a required information for Label set-up? (a) Height (b) Number (c) Vertical pitch (d) Column 24. This is a type of hyperlink available in Hyperlink dialog box, which creates a new worksheet. (a) New document (b) New file (c) New worksheet (d) New data 25. A ___________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. (a) values (b) location (c) arguments (d) None of these 26. _____________ is represented by invisible character (¶) which looks like a horizontally flipped P letter. (a) Paragraph break (b) Word break (c) File break (d) All of these Section C SAMPLE PAPER 10 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Neeta is planning to take a car loan to buy a new car. But she is not sure about the payback time, i.e. whether to pay it back in 5 or 6 years considering that her monthly fuel cost will also increase. In such cases, which of the following feature of spreadsheet she can use to get an idea about it? (a) Consolidation (b) Macros (c) Templates (d) What-if analysis

104 CBSE Sample Paper Information Technology Class X (Term I) 28. Rajat has received a spreadsheet, which is reviewed by his subordinates Puneet, Kavya and Aman, who made some corrections in it. Before Rajat shared the spreadsheet with his subordinates, he has activated the track changes feature. Which of the following option he should use now to keep some of the changes made by them? (a) Accept and reject changes (b) Overwrite and keep changes (c) Both (a) and (b) (d) None of these 29. While working on a database, Mihira has created a table to store information about the electronic products that they sell online. She has listed down a number of fields that she is going to have in her table. She has decided that the field, Item_Code will be the primary key. At the same time, she wants the data entry operator to enter the value under this filed in a particular format. Which of the following field property she needs to show the format she needed? (a) Length (b) Auto format (c) Default format (d) Format example 30. Sahana is an editor, working with a publishing house. She has received a document on and while editing it she realises that some of the images used in the document are not properly modified. The contrast of these images is too soft and she wants to increase their contrast. Suggest the filter effect she can use to increase the contrast of such images and the images will look better. (a) Smooth (b) Sharpen (c) Invert (d) Relief 31. Afza’s teacher has asked her to create a document which will also include the basic geometrical shapes. She has completed the work and added various geometrical shapes using the Writer software. But she is facing problem while setting the stacking order of these images. Suggest her the command she can use to keep the images in the order she wants to. (a) Format ® Order (b) Format ® Arrange (c) Image ® Order (d) Image ® Arrange 32. Amish is the sales country head in a multi-national company. He has last year sales report from North, East, West and South zones. Now he wants to combine all these data in order to view the total sales of every month made by his company in one place. Which of the following feature in Calc will allow him to do so? (a) Consolidate (b) Combine (c) Scenarios (d) Macros 33. Sunil has created a table of contents for a textbook he was working on. He has used the default format of table of contents available in Writer to do so. But he is not happy with SAMPLE PAPER 10 the outcome, hence he wants to assign some custom styles to it. Which of the following option present under the Create from area he should use to apply a customized style? (a) Additional styles (b) Customized styles (c) More styles (d) None of these

OMR SHEET SP 10 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)

106 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 10

CBSE Sample Paper Information Technology Class X (Term I) 107 Answers 1. (b) 2. (a) 3. (b) 4. (a) 5. (d) 6. (c) 7. (c) 8. (a) 9. (b) 10. (a) 11. (d) 12. (a) 13. (a) 14. (c) 15. (a) 16. (c) 17. (d) 18. (b) 19. (c) 20. (a) 21. (c) 22. (d) 23. (b) 24. (a) 25. (c) 26. (a) 27. (d) 28. (a) 29. (d) 30. (b) 31. (b) 32. (a) 33. (a) SOLUTIONS 1. Desktop is the first screen that is displayed 11. A primary key is a set of one or more fields that SAMPLE PAPER 10 after switching on the windows. uniquely identifies each record in a table. It does not contain any duplicate data. 2. Coherent: Any effective communication requires the words to be related to the main A primary key cannot be null, it means that it topic. Professional communication is always cannot be left empty. comprehensible and logical. 12. A dockable window is a type of window, which 3. Stress management boosts the immune system can be moved anywhere on the screen. You can and makes one healthy. It brings a positive position it wherever you want to place it by change in the outlook and lifestyle of a person. holding down the Ctrl key and drag it by title bar. Stress management infuses a sense of control and accomplishment. 13. Transparency tool modifies the percentage of transparency of an image. You can set the value 4. Installation of Firewall, i.e. restricting access to of transparency on the picture toolbar to make unwanted sites through appropriate settings the image more transparent. in the browsers should also be done as a mandatory act. 14. While working with multiple sheets and you need to use data stored on another sheet you 5. Seekers and Pleasers comes under the can use <sheetname>.<cell reference> syntax . category of people with low internal Only qualified name can be used to use data self-awareness and high external from a worksheet. self-awareness. Pleasers are always focused on what others think and they fail to focus on 15. #### is one of the most common and easiest to their internal matters. tackle error. Basically, it is not a formula-based error but occurs when the width of column is 6. Imperative sentences make requests to give small. So, you need to increase the cell width. commands and advice. They are also known as declarative sentence, in this type of 16. Generally, a new sheet is normally inserted sentence the subject usually comes before the next to the active sheet. verb. 17. Templates are used for generic content that you 7. The formula = Division(20,5) will show intend to use multiple times. As many #Name error as there is no such function documents can be created from a template you named Division in Calc. want. 8. A Goal seeking is a What-if analysis tool that 18. Writer’s table of contents feature lets you build calculates backward to obtain an input that an automated table of contents from the would yield a given output. It means, the headings in your document. Usually, it is found output is provided and based on the output, on a page before the start of a written work. Goal seek option calculates the input. 19. Comments are the descriptions about the 9. Styles help improve consistency in a changes made in cells during record changes document. They also make major formatting mode. If you want to add some details about changes easy. Image style is not available in the changes, you can do it by adding Writer. comments. 10. An absolute cell reference is a cell reference in 20. The Data ® Sort command on a selected range a spreadsheet application that remains of cells is applied to sort the data in a particular constant even, if the reference is copied or order. If you want to sort data using macro, the moved to another cell or sheet unlike relative selected cells should have identical data. reference.

108 CBSE Sample Paper Information Technology Class X (Term I) 21. A mail merge is a way to take a letter you have by changes in the assumptions that projections written and send it to a whole bunch of people, are based upon. It is the process of changing personalising it with information about them the values in cells to see how those changes so they might think that you typed that letter will affect the outcome of formulas on the personally for them. worksheet. 22. A table refers to a storage container storing 28. The accept and rejects dialog box allows us to data pertaining to a single object, subject or see the changes made by other users on the purpose. A table in a relational database is also same worksheet. Also, you can either delete reformed as relation. It is the main building and keep the changes made by multiple users. block of a database. 29. The format example field property allows you 23. The information required for label set-up are; to display data in a format that is different Height, width, columns, rows, horizontal from the way it is stored generally instead in pitch, vertical pitch, left margin and top the format that you want to store the data. margin. 30. Smooth tool softens the contrast of an image 24. On the left hand side, you can select one of the whereas, Sharpen tool increases the contrast of four types of hyperlinks: Internet, Mail & an image. News, Document and New Document. The new document option creates a new worksheet 31. Format ® Arrange command allows us to put as a hyperlink. the images in an order. There are several options present under it like: Bring to Front, 25. Arguments refer to a cell or a range of cells on Forward One, Send to Back, etc. a worksheet and can be used to find the values or data that you want formula to calculate. 32. The Consolidate feature in Calc helps to collate the data with minimal efforts. The consolidate 26. A paragraph break is represented by invisible feature of Calc is used to integrate data from character (¶) which looks like a horizontally multiple sources into a single destination. flipped P letter. You can Show/Hide these characters by clicking on the toggle button (¶). 33. To assign paragraph formatted with custom styles to a Table of Contents, in the Create 27. A What-if analysis is a technique that is used from area, check the Additional Styles to determine how projected result is affected checkbox. SAMPLE PAPER 10