Information technology Sample Paper

ARIHANT PRAKASHAN (School Division Series) All Rights Reserved © Publisher Administrative & Production Offices Regd. Office ‘Ramchhaya’ 4577/15, Agarwal Road, Darya Ganj, New Delhi -110002 Tele: 011- 47630600, 43518550 Head Office Kalindi, TP Nagar, Meerut (UP) - 250002, Tel: 0121-7156203, 7156204 Sales & Support Offices Agra, Ahmedabad, Bengaluru, Bareilly, Chennai, Delhi, Guwahati, Hyderabad, Jaipur, Jhansi, Kolkata, Lucknow, Nagpur & Pune. ISBN : 978-93-25795-18-1 PO No : TXT-XX-XXXXXXX-X-XX Published by Arihant Publications (India) Ltd. For further information about the books published by Arihant, log on to www.arihantbooks.com or e-mail at [email protected] Follow us on

Contents þ One Day Revision 3-6 þ The Qualifiers 9-18 þ Latest CBSE Sample Paper 21-26 Sample Paper 1 29-36 Sample Paper 6 69-76 Sample Paper 2 37-44 Sample Paper 7 77-84 Sample Paper 3 45-52 Sample Paper 8 85-92 Sample Paper 4 53-60 Sample Paper 9 93-100 Sample Paper 5 61-68 Sample Paper 10 101-108 Syllabus Term Units No. of Hours Max. Marks Theory Practical PART A Employability Skills Theory Practical Marks Term I Unit : Communication Skills-II Unit : Self-Management Skills-II Unit : Information and Communication Technology Skills-II PART B Subject Specific Skills Term I Unit : Digital Documentation Advanced Unit : Electronic Spreadsheet Advanced Unit : Database Management System Watch Free Learning Videos Video Solutions of CBSE Sample Papers Chapterwise Important MCQs CBSE Case Based MCQs CBSE Updates Much more valuable content will be available regularly

MCQs Preparation Tips Focus on Theory Learn to Identify Wrong Answers MCQs can be formed from any part or The simplest trick is, observe the options line of the chapter. So, strong command first and take out the least possible one on theory will increase your chances to and repeat the process until you reach solve objective questions correctly and the correct option. quickly. Analyze your Performance Practice of Solving MCQs During the practice of MCQs you can Cracking an MCQ-based examination identify your weak & strong requires you to be familiar with the topics/chapter by analyzing of incorrect question format, so continuous practice answers, in this way you will get an will make you more efficient in solving awareness about your weaker topics. MCQs Practice through Sample Papers Speed & Accuracy Solving more & more papers will make In MCQ-based examination, you need you more efficient and smarter for both speed and accuracy, if your exams. Solve lots of Sample Papers accuracy is good but speed is slow then given in a good Sample Papers book. you might attempt less questions resulting in low score. Attempting MCQs in Exams 1. Read the paper from beginning to by step solution is not required in MCQ type questions, it is a waste of end & attempt those questions first in time, you will not get extra marks for which you are confident. Now move this on to those questions which requires thinking and in last attempt those 4. Most of the time, you need not to questions for which you need more attention. solve the MCQ completely to get the correct option. You can start thinking 2. Read instructions of objective in reverse order and choose the best fit option. questions carefully and find out what is being asked, 5. As there is no negative marking for a bit carelessness can lead you to incorrect answer. incorrect answers, so don't leave any question unanswered. Use your 3. Tick/Write down the correct option guess if you have not exact idea about the correct answer. only while filling the OMR sheet. Step





CBSE Sample Paper Information Technology Class X (Term I) 03 ONE DAY REVISION Revise All the Concepts in a Day Just Before the Examination... Part A : Employability Skills G Communication Skills-II G The three important points to be considered in ONE DAY REVISION communication are content, process and context. 1. Communication It is a process which involves sharing of information, opinion, ideas, and beliefs G The 7C’s of effective communication are: Clear, between two or more persons through a Concise, Concrete, Correct, Coherent, Complete, continuous activity of speaking, listening and Courteous. understanding. G A communication barrier is an obstacle that 2. Types of Communication There are three basic prevents the receiver from receiving and types of communication: understanding the message that has been sent by a sender. G Verbal communication refers to using words to exchange thoughts, feelings and ideas with G There are several factors or barriers that may affect others. There are two types of verbal the communication. They are – Lingual factors, communication: Oral and Written Environmental factors, Past experiences, Cultural communication. influence, Prejudice, Feelings, and Personal factors. G Non-Verbal communication is usually understood as the process of communication 5. Basic Writing Skills through sending and receiving wordless messages between people using cues like G The effectiveness of written communication gestures, body language etc. depends on the usage of appropriate words, grammatically correct sentences, and their G Visual communication is the communication organisation into a coherent structure. using a non-verbal medium such as visual aids, posters, sign-boards etc. G A group of words that makes complete sense is called a sentence. Every complete sentence has 3. Feedback in Communication two parts — a Subject and a Predicate. G Feedback is the response that a receiver gives G The types of sentences are: Assertive, Imperative, after the message is received and understood Interrogative, and Exclamatory. by him/her. G A phrase is a group of words that form a unit within a G Effective feedback has the following sentence but is incomplete independently. characteristics: Intention, Specific, Fair and Non-Judgemental, Timeline, Usefulness, G The different types of phrases are: a noun phrase, Clarity. a verb phrase, an adjective phrase, an adverbal phrase and a prepositional phrase. G The different types of feedback are: Formal and Informal, Descriptive and Non-Descriptive, G Each word in the English language belongs to a Specific and Non-Specific. particular class or parts of speech. The eight parts of speech in English grammar are: Nouns, 4. Effective Communication Pronouns, Adjectives, Verbs, Adverbs, Prepositions, Conjunctions and Interjections. G Effective communication means transfer of exact message in time and with clarity.

04 CBSE Sample Paper Information Technology Class X (Term I) G An article is a word that is used to modify a G The rules to construct a good paragraph are: noun. There are two different types of articles: (a) Write an outline for the paragraph Indefinite articles( A and An) and Definite (b) Write the topic sentence article(The). (c) Write supporting sentences for each outline (d) Write concluding sentence G A paragraph is a group of sentences that describe one idea. G Self-Management Skills-II 1. Stress Management G The advantages of working independently are: (a) Boosts self-confidence G Stress is our body-and-mind’s response and (b) Makes the person self-reliant reaction to challenging situations in our lives. (c) Increases self-esteem There are two types of stress : Good Stress (d) Makes person accountable and Bad Stress. (e) Makes the person emotionally independent G The various stress management techniques G Self-awareness means being aware of your are: personality, including your strengths, weaknesses, (a) Physical exercise thoughts, emotions and motivations. There are two (b) Sports types of self-awareness: External and Internal. (c) Yoga (d) Meditation G Self-motivation drives a person to attempt and (e) Taking break accomplish tasks. There are two types of (f) Nature walks self-motivation: Intrinsic and Extrinsic. (g) Holidaying and vacationing G Self-regulation involves being able to control 2. Working Independently reactions to emotions like frustration or excitement. G An independent person is aware of his feelings G The fundamental of being independent are the and character; observes and evaluates his ability to work on your own, with minimal direction, behaviour, and corrects his mistakes. confidence, self-awareness, self-motivation, and self-regulation. G Information and Communication Technology Skills-II ONE DAY REVISION 1. Operating System 2. Basic Computer Maintenance G An operating system is the first program that gets G Computer maintenance refers to the actions loaded into a computer memory. carried out so as to keep a computer in a good state of working. G The operating system acts as an interface between the hardware and software. G Computer maintenance includes: physical cleaning, internal cleaning and keeping backup G Based on the way the operating system lets the and update software. user to interact, they are classified into two types: GUI (Graphical User Interface) and CUI G Physical cleaning removes dust and debris (Character User Interface). whereas, internal cleaning keeps computer applications and programs virus free. G Desktop is the first screen that is displayed after switching on computer. G Computer virus is a malicious program written specifically to harm data and applications on a G A file system defines the ways in which files are computer. named and placed for storage and retrieval. G Other virus like threats in computer are: Worms, G A clipboard is a temporary memory buffer Trojan horses etc. provided by the operating system to store data temporarily. G Anti-Virus software scans a computer virus and removes them.

CBSE Sample Paper Information Technology Class X (Term I) 05 Part B : Subject Specific Skills G Digital Documentation (Advanced) 1. Styles in a Document 3. Working with Templates G A style in a word processor, is a named G A template is a predefined layout that contains collection of various formatting information that sample content, themes, colours, font-styles, defines the look and behaviour of document background styles, etc., and gives an initial components associated with this style. foundation to build a document. G All style related information and management G A template can be created in Writer by saving a happens through a special floating window in document with an .ott extension. Writer known as Styles and Formatting window. G In Writer, it is possible to set up the custom G Fill Format mode is useful in situations when you template as a default template. have to apply a style to multiple scattered objects in a document. G To organize and use templates, you can use File ® Templates command submenu. G To apply a style, select the object on which a style is to be applied, and then double-click on 4. Using a Table of Contents the style name which is to be applied on it from the Styles and Formatting window. G The Table of Contents is a necessary index, generally available in long documents, books, G To copy the styles from another document, use drafts, etc. It consists of headings and sub command Styles and Formatting window ® New headings of a book or document. Styles ® Load styles, and then select the required document from the From File window. G The Writer lets you build an automated table of contents using the Table of Contents and Index 2. Images in a Document feature available in the Insert menu. G In a text document of Writer, you can insert an G The hierarchy of headings can be defined in a image from a file, a scanned image or from gallery. document, if it contains multi-level headings. G The gallery contains ready-to-use objects and G In Writer, you can easily customize every element sounds that you can insert in a document. of the table of contents by using the Table of Contents or Bibliography dialog box. G Writer provides the Image dialog box and image toolbar to make modification in images. 5. Using Mail Merge G The eight resize handles are used to resize an G The Mail Merge feature of Writer enables you to image. quickly create and print multiple copies of a document, mailing labels, and so on. G Shapes is a drawing feature that helps you to draw different shapes like, circles, rectangles, G Main document is the document that contains starts callouts etc. the text to be sent along with the merged fields. G Cropping means removing unwanted area from G The data for individual recipients can be stored in an image starting from its boundary. a spreadsheet, table or a database, and this is known as the data source. G Grouping allows you to combine multiple objects to behave like one object. G The Mail Merge wizard can be started from the Tools menu of Writer. G The Wrap setting determines the relation between the text and the graphics in a G Labels are stickers that may contain information document. related to a product to advertise, a warning message, instructions for use, environmental G An object can be aligned horizontally and advice, batch number etc. vertically in a document. G Electronic Spreadsheets (Advanced) ONE DAY REVISION 1. What-if Analysis G The Multiple operations tool displays the result of applying formula to a list of alternative values for G The Consolidate feature collates the contents of variables in a separate range of cells. cells from several worksheets and maintains the collected data in a matter worksheet with minimal G Goal Seek is used to set a goal to find the efforts. optimum value for one or more target variables, given with the certain conditions. G The Subtotal feature generates a subtotal of the rows of related data. G Solver is the elaborate form of Goal Seek. It deals with equations with multiple unknown G By using Scenarios feature, you can analyse the variables. data by putting different input values.

06 CBSE Sample Paper Information Technology Class X (Term I) 2. Linking Spreadsheets spreadsheet. You can either Accept or Reject these changes as per the requirement. G Linking spreadsheet data enables you to keep information up-to-date without editing multiple G The Record Changes mode is started by the locations every time the data changes. command Edit ® Changes ® Record G A hyperlink is a coloured and underlined text or G Compare document feature is used to compare graphics that you click to open a file, location in a the edited document with the original one. The file, or a web page. command used for this is: Edit ® Changes ® Compare document. G There are two types of hyperlinks used in Calc — Relative and Absolute. G Merging spreading spreadsheets help in reviewing all the changes done in different G A relative hyperlink contains a partial address, sheets in one go. i.e., an address which is relative to the address of the output file. 4. Macros in Spreadsheets G An absolute hyperlink contains the full address of G The Macro feature of Calc allows you to record a the destination file or web page. By default, Calc set of actions that you perform repeatedly in a shows an absolute hyperlink. spreadsheet. 3. Share and Review a Spreadsheet G Macros are usually written in a language called the Base. G Sharing spreadsheet feature allows multiple users to work on the same worksheet simultaneously. G You can use Tools ® Macros, to record and run a macro. G The command Tools ® Share document can be used to switch the mode for a document from G Internally, for each macro a code is generated, unshared to shared. which is stored inside Sub and End Sub clauses. G The Track changes feature enables you to keep a track on the changes done by all users in a G The values passed to a macro are called its Arguments. G Database Management System ONE DAY REVISION 1. Database refers to the collection of interrelated data G A Form is an interface in user specified layout and a Database Management System (DBMS) is a that lets users view, enter, or change data computer program that manages a database directly in the table. effectively and efficiently. G A Report is an effective way to present data in 2. Relational Database Management System (RDBMS) is a printed format. a type of DBMS software that uses Relational database model for its database. 7. Key It is defined as the column or the set of columns of the database table which is used to 3. A relational model enables the users to store data in identify each record uniquely in a relation. Types several tables, and whenever the data is needed, it of key are can be retrieved easily by establishing a relationship among them. G A primary key is a field that uniquely identifies the records in a table. 4. The extension of a database file in Base is .odb. G A foreign key consists of one or more fields 5. Duplication of data is known as data redundancy. whose values matches a primary key in another table. 6. The objects of a Database are: Tables, Forms, Queries and Reports that are used to manage data. G A composite key or composite primary key refers to a combination of two or more G A Table refers to a storage container storing data attributes that uniquely identifies the record in pertaining to single object, subject or purpose. a table. G A Query is a statement that gives you filtered data 8. A data type determines what type of data you according to your conditions and specifications. can enter into a filed.





CBSE Sample Paper Information Technology Class X (Term I) 9 THE QUALIFIERS Chapterwise Set of MCQs to Check Preparation Level of Each Chapter Part A : Employability Skills 1. Communication Skills-II Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. Which of the following is not an advantage of verbal communication? (a) Communication is interactive (b) Requires proximity (c) Instant feedback (d) Quick way to communicate 2. A _________________ feedback follows a pre-set format using which the receiver frames feedback and sends. (a) informal (b) descriptive (c) formal (d) non-descriptive 3. Lack of confidence makes communication difficult for some people. This is an example of which type of barrier in communication. (a) Personal factors (b) Past experiences (c) Prejudice (d) Environmental factors 4. My father has gifted me a new smart phone. Identify the type of sentence. (a) Assertive (b) Imperative (c) Exclamatory (d) None of these 5. _____________ is a part of the predicate. It tells about the things being acted by upon the verb. (a) Subject (b) Predicate (c) Object (d) Adverb THE QUALIFIERS 6. Could I have __________ milk in my tea, please? (a) a little (b) a few (c) much (d) several 7. Which of the following is not a type of written communication? (a) Newsletter (b) Media release (c) Manuals (d) Illustrations

10 CBSE Sample Paper Information Technology Class X (Term I) 8. _____________ is the important aspect of our personality and how our image is formed among people. (a) Body language (b) Written communication (c) Visual communication (d) None of these 9. Which of the following is not a characteristic of feedback? (a) Intention (b) Specific (c) Length (d) Clarity 10. “Good job! Congratulations!” is a type of ___________ feedback. (a) formal (b) informal (c) specific (d) descriptive 11. Which of the following is not a 7C’s of effective communication? (a) Complexity (b) Clarity (c) Completeness (d) Courtesy 12. A/An __________ phrase will contain a noun or pronoun along with a participle. It is generally separated by commas. (a) infinitive (b) absolute (c) gerund (d) noun 13. An ___________ is a piece of writing intended for publishing in a newspaper or magazine. (a) introduction (b) essay (c) article (d) None of these 14. Have you received the latest news about the match? Identify the parts of speech of the underlined word. (a) Adverb (b) Conjunction (c) Interjection (d) Adjective 15. Which of these sentences is in active voice? (a) A movie is being watched by them. (b) The car was repaired by Raju. (c) He is reading a book. (d) The thief was being chased by a policeman. Answers For Detailed Solutions Scan the code 1. (b) 2. (c) 3. (a) 4. (a) 5. (c) 6. (a) 7. (d) 8. (a) 9. (c) 10. (b) 11. (a) 12. (b) 13. (c) 14. (d) 15. (c) THE QUALIFIERS

CBSE Sample Paper Information Technology Class X (Term I) 11 2. Self-Management Skills-II Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. ______________ stress refers to the limited quantity of stress that helps one keep focused and motivated to do something. (a) Feel good (b) Good (c) Happy (d) None of these 2. Physical exercises help boost up the production of our brain’s feel good neurotransmitters called _________________. (a) endorphins (b) haemoglobin (c) cortisol (d) caffeine 3. _____________ from your regular routine is a useful technique of lowering stress, especially if the stress is being caused by your work or routine. (a) Acting smartly (b) Nature walks (c) Partying (d) Taking break 4. An independent worker plans actions to accomplish their task. Which of the following is not considered as one of such actions? (a) Planning (b) Enjoying (c) Goal setting (d) None of these 5. _______________ people develop mindfulness abilities and keenly observe how they improve their personality. (a) Self-sufficient (b) Self-regulating (c) Self-awareness (d) Self-motivated 6. Which of the following is not a component of self-regulation? (a) Will power (b) Sense of humour (c) Self-control (d) Effortful control 7. Monitoring your progress is one of the _____________ techniques. (a) motivation (b) regulation (c) awareness (d) None of these 8. Which of the following is not a personal sign of stress? (a) Excessive sweating (b) Poor judgement (c) Better concentration (d) Biting your nails 9. _____________ gives you the benefits of enabling you to indulge in your interest or hobbies, gives you a break from stress. (a) Nature walks (b) Yoga (c) Meditation (d) Leisure THE QUALIFIERS 10. Which of the following is not considered as one of the types of self-awareness? (a) About your strengths (b) About your finances (c) About your flaws (d) About your emotional problems 11. Which of the following is not an element of mediation? (a) Focused attention (b) Comfortable position (c) Abdominal breathing (d) None of these

12 CBSE Sample Paper Information Technology Class X (Term I) 12. The meaning of Yoga is _____________. (b) to spend (d) to multiply (a) to unite (c) to divide 13. What is an advantage of independent working? (a) Working under supervision (b) Held responsible for other’s mistake (c) Freedom to think and be creative (d) None of the above 14. Which of the following is not a type of self-awareness? (a) Peripheral (b) Indexical (c) Social (d) Detached 15. Taking initiative is a key element of _______________. (a) self-regulation (b) working independently (c) self-sufficient (d) self-reliant Answers For Detailed Solutions Scan the code 1. (b) 2. (a) 3. (d) 4. (b) 5. (c) 6. (b) 7. (a) 8. (c) 9. (d) 10. (b) 11. (d) 12. (a) 13. (c) 14. (a) 15. (b) 3. Information and Communication Technology Skills-II Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. The operating system that are designed for being used in devices for a specific purpose only are known as ___________________operating systems. (a) single user (b) multi user (c) embedded (d) distributed 2. Which of the following is a CUI operating system? (a) DOS (b) Windows 10 (c) Windows 7 (d) Windows XP 3. When you delete a file it goes to a temporary location, the ___________________. (a) dust bin (b) recycle bin (c) folder bin (d) directory bin THE QUALIFIERS 4. A __________ is a collection of data stored in form of text, pictures, videos or music. (a) folder (b) icon (c) link (d) file 5. The left pane of Windows Explorer screen displays ____________ and ___________. (a) drives, folders (b) files, folders (c) drives, text (d) text, folders 6. ____________ key can also be used to rename a file. (a) F1 (b) F3 (c) F2 (d) F5

CBSE Sample Paper Information Technology Class X (Term I) 13 7. To arrange the files and folders on the desktop in different ways, ________________ option is used from the context menu. (a) order (b) view (c) arrange (d) sort 8. To select files or folders which are not placed side by side, use the ___________ key. (a) Ctrl (b) Shift (c) Alt (d) Tab 9. A _________________ agent applied to the surface of the keys with a cloth is used to remove the accumulation of oil and dirt from the keyboard. (a) plastic-cleaning (b) metal-cleaning (c) anti-dust (d) None of these 10. Deleting the ____________ files from your computer can help keep it running smoothly as well as improve its performance. (a) image (b) huge (c) temporary (d) database 11. The cleaning of hardware components of a computer does not include the cleaning of ______________. (a) Windows (b) DVD (c) Keyboard (d) Speakers 12. To protect the user, almost all the e-mail clients provide the ______________ feature to prevent the spam messages from being delivered to your inbox. (a) stop (b) remove (c) filter (d) secure 13. Temporary files can be searched by typing _____________ in the search files and folders textbox. (a) Temporary (b) %temp% (c) #temp# (d) @temp@ 14. Which of the following option is not available as option for frequency at which you want to run the Disk Defragmenter program? (a) Daily (b) Weekly (c) Monthly (d) Hourly 15. The right side of the taskbar is known as _______________, which includes a clock and THE QUALIFIERS group of icons that provide the status and notification about updates, network connectivity, volume, etc. (a) notification area (b) display tray (c) windows area (d) updates area Answers For Detailed Solutions Scan the code 1. (c) 2. (a) 3. (b) 4. (d) 5. (a) 6. (c) 7. (d) 8. (a) 9. (a) 10. (c) 11. (a) 12. (c) 13. (b) 14. (d) 15. (a)

14 CBSE Sample Paper Information Technology Class X (Term I) Part B : Subject Specific Skills 4. Digital Documentation (Advanced) Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. _____________ styles are used to format graphics and text frames, including text wrap, borders, backgrounds and columns. (a) Border (b) Frame (c) Table (d) Text 2. If you _____________ styles, and then change the base style then all the ___________ styles will change as well. (a) link, linked (b) copy, copied (c) edit, edited (d) None of these 3. In the Load Style dialog box, ___________ option loads the paragraph and the character styles from the selected document into the current document. (a) page (b) paragraph (c) overwrite (d) text 4. To add a new image to the Gallery, you can click on the _____________ button. (a) New image (b) Add image (c) New theme (d) Add theme 5. By dragging any ___________ handle you can increase or decrease the __________ of the image diagonally. (a) corner, size (b) top, depth (c) side, quality (d) corner, quality 6. Which of the following is not a type of text wrapping option? (a) Wrap off (b) Optimal wrap (c) Page wrap (d) Wrap center 7. To delete a template, ______________ on a template in the Templates window and select delete. (a) Right-click (b) Left-click (c) Double-click (d) None of these 8. In the hierarchy of headings, the lower - level headings pertain to ___________ and ____________. (a) section, sub-sections (b) headings, sub-headings (c) Both (a) and (b) (d) None of these 9. Which of the following templates you cannot create using the Wizard? THE QUALIFIERS (a) Fax (b) Letters (c) Database (d) Agenda 10. The structure line displays the elements for entries in the level column. The ________________ button represents the page number. (a) # (b) & (c) % (d) @ 11. After adding the data source, you need to specify the salutation. The selected salutation will be displayed in the _______________ pane. (a) salutation (b) preview (c) display (d) None of these

CBSE Sample Paper Information Technology Class X (Term I) 15 12. In the Mail Merge dialog box, you can select the ___________ option if you want to save the merged documents. (a) File (b) Edit (c) View (d) Format 13. The grey colour in the TOC reminds us that the text has been generated __________. (a) manually (b) automatically (c) Both (a) and (b) (d) None of these 14. Prairna is a student of class X. Her teacher has asked her to create a document on ‘Women Empowerment’. She has written the text and also added relevant images in her document using Writer. But she has realised that the paragraph will look better if the images are placed around the text. Name the feature of Writer she can use to get the desired result. (a) Placing image (b) Wrap text (c) Positioning image (d) Closing text 15. Prashant is a writer. He has just completed writing his book using Writer software. Now he wants to add a page which will contain the title of each chapter and its respective page number. Suggest the feature that can be used to do this task. (a) Mail merge (b) Templates (c) Styles (d) Table of contents Answers 1. (b) 2. (a) 3. (d) 4. (c) 5. (a) For Detailed Solutions 6. (d) 7. (a) 8. (a) 9. (c) 10. (a) Scan the code 11. (b) 12. (a) 13. (b) 14. (b) 15. (d) 5. Electronic Spreadsheets (Advanced) Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. In the Subtotal dialog box, the _____________ box is used to select the column on which you want to add the Subtotal to. (a) group by (b) consolidate by (c) filter by (d) update by 2. In order to group sheets, while holding the _________ key, click on the Sheets tab you want to group. (a) Alt (b) Shift (c) Ctrl (d) Tab 3. The comments that are added while creating a scenario is displayed in the ___________ while using scenario. (a) preview pane (b) navigator box (c) comment window (d) None of these THE QUALIFIERS 4. In Goal seek dialog box, in the _____________ we enter the reference of the cell that contains the value to be changed. (a) variable cell (b) changing cell (c) modifying cell (d) replacing cell 5. Default name of first scenario created in Sheet1 of Calc is ___________. (a) Sheet_1_Scenario (b) Sheet_Scenario_1 (c) Sheet1_Scenario_1 (d) None of these

16 CBSE Sample Paper Information Technology Class X (Term I) 6. We can rename a new sheet in Calc. (b) While inserting a new sheet (d) None of these (a) After inserting a new sheet (c) Both (a) and (b) 7. To start the macro recorder, which of the following command is used? (a) Tools ® Macros ® Record Macro (b) Tools ® Record ® Record Macro (c) Data ® Macros ® Record (d) None of these 8. Cell referencing can be done by using a ____________ as well _____________. (a) keyboard, windows menu (b) keyboard, mouse (c) windows menu, mouse (d) None of these 9. To create the link from one document to another , both the documents should be __________. (a) open (b) closed (c) Both (a) and (b) (d) None of these 10. In case, another user is trying to save the shared worksheet and resolve conflicts, you see a message that the shared spreadsheet file is ____________ due to a merge in progress. (a) stopped (b) locked (c) Both (a) and (b) (d) None of these 11. ___________ is used in between the cell reference in a formula. (a) : (b) , (c) Both (a) and (b) (d) @ 12. Internally for each recorded macro, some code is generated, which is stored inside _____________ and ____________ clause. (a) Sub, End Sub (b) Section, End Section (c) Function, End Function (d) None of these 13. To create a hyperlink to a webpage, FTP server of Telnet connection, click on the _____________ icon. (a) internet explorer (b) Internet (c) hyperlink (d) document 14. Aparna has made four spreadsheets containing marks of 5 subjects of all the students of her class. She has to prepare a sheet that contains the total marks of all the subjects of her class. Name the option that can be used to perform this task. (a) Subtotal (b) Average (c) Goal Seek (d) Scenario 15. Priya, Ravi and Suresh are working in the accounts department of an advertising company. They handle different set of clients. Now they collaborating to create a THE QUALIFIERS spreadsheet for maintaining records of all their clients combined together. Which option they should use so that they all can work simultaneously in the sheet? (a) Add document (b) Share document (c) Combine document (d) None of these Answers 1. (a) 2. (c) 3. (b) 4. (a) 5. (c) For Detailed Solutions 6. (c) 7. (a) 8. (b) 9. (a) 10. (b) Scan the code 11. (c) 12. (a) 13. (b) 14. (a) 15. (b)

CBSE Sample Paper Information Technology Class X (Term I) 17 6. Database Management System Direction (Q. Nos. 1-15) Each of the question has four options out of which only one is correct. Select the correct option as your answer. 1. A DBMS allows different user application programs to concurrently access the _____________ . (a) same database (b) different spreadsheets (c) different database (d) None of these 2. Databases available on the database servers are accessed through command line or graphic user interface tools referred to as ______________. (a) back-ends (b) front-ends (c) intermediate (d) interfaces 3. A _____________ is the actual text or numerical amount or date that you put in while adding information to your database. (a) record (b) data (c) value (d) entry 4. RDBMS is based on the relational model introduced by (a) Henry Ford (b) E.F.Codd (c) Both (a) and (b) (d) None of these 5. Primary key can be of three types: ______________, single field primary key and multi-field primary key. (a) auto number (b) auto name (c) auto field (d) auto select 6. ________________ will restrict the amount of data that each data item or value can hold. (a) Data type (b) Data size (c) Data length (d) Data width 7. The _____________ data type stores serialised Java objects. (a) varbinary (b) varchar (c) other variable (d) bigint 8. Reports are used to produce formatted summaries of the data contained from one or more tables or queries in a ___________ format. (a) printed (b) prepared (c) presentation (d) possible 9. The bottom half of the Table Design window displays the ______________ for the field THE QUALIFIERS type you have selected. (a) field types (b) field properties (c) field output (d) field design 10. Multiple fields can be selected by holding the ___________ key while selecting the fields. (a) Ctrl (b) Alt (c) Shift (d) Tab

18 CBSE Sample Paper Information Technology Class X (Term I) 11. A query is a statement that gives you ___________ data according to your conditions and specification. (a) Conditioned (b) Sorted (c) Filtered (d) Closed 12. A foreign key is linked to the primary key of the _______________. (a) same table (b) different table (c) Both (a) and (b) (d) None of these 13. The ____________ data type stores both date and time. (a) DateTime (b) Timestamp (c) Datestamp (d) DateAndTime 14. Sonali has created a table to store the details of the registered dealers of her company. She has created all the fields as per the requirement. For entering phone number, she is not sure which data type can be used. Suggest her the best data type from the following options for storing phone numbers. (a) Boolean (b) Varchar (c) Integer (d) Float 15. Ragini has created a table named Student_Details in order to store all the details of the student of her class. She has added the following fields: Admission_No, Student_Name, Birth_Date, Address, Joining_Date, Mother_Name, Father_Name. Out of the following fields, which field can be selected as primary key as the entries in it will be unique? (a) Admission_No (b) Birth_Date (c) Student_Name (d) None of these Answers For Detailed Solutions Scan the code 1. (a) 2. (b) 3. (c) 4. (b) 5. (a) 6. (b) 7. (c) 8. (a) 9. (b) 10. (a) 11. (c) 12. (b) 13. (a) 14. (c) 15. (a) THE QUALIFIERS





CBSE Sample Paper Information Technology Class X (Term I) 21 Latest CBSE SAMPLE PAPER Latest Sample Question Paper for Class X (Term I) Issued by CBSE on 2 Sept 2021 Information Technology Class 10 (Term I) 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. 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. __________feedback is specific information, in the form of written comments or verbal conversations that help the learner understand what she or he needs to do in order to improve. (a) Descriptive (b) Specific Latest CBSE SAMPLE PAPER (c) General (d) Sign 2. ____________communication is the use of body language, gestures and facial expressions to convey information to others. (a) Verbal (b) Written (c) Non-verbal (d) Visual 3. Sonika gets up at 6 am and goes for her hobby classes. Then, she comes back home and finishes her homework before going to school. She does all work by herself. No one tells her to do so. This is called ___________. (a) self-awareness (b) self-motivation (c) self-regulation (d) discipline 4. High expectations from self can leave one with chronic anxiety and stress, thus leading to _________ stress. (a) physical (b) emotional (c) mental (d) financial

22 CBSE Sample Paper Information Technology Class X (Term I) 5. A __________ operating system is a computing environment that reacts to input within a specific period of time. (a) single user (b) multi-user (c) real time (d) distribute 6. Identify the measure to protect computer from threats and viruses. (a) Sharing password with friends (b) Allow anyone to use your device (c) Use Antivirus (d) Leave computer without logging out Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. When you apply a ____________ , you apply a group of formatting effects together in one single step. (a) effect (b) style (c) template (d) format 8. Which function cannot be performed through Subtotal in a Spreadsheet? (a) Sum (b) Product (c) Average (d) Percentage 9. In a document, __________ refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point. (a) arrangement (b) anchoring (c) alignment (d) text wrapping 10. A_________ is a model that you use to create other documents. (a) template (b) document (c) design (d) copy paste 11. _________________ styles in a text document affect selected text within a paragraph, such as the font and size of text, or bold and italic formats. (a) Cell (b) Paragraph (c) Formatting (d) Character Latest CBSE SAMPLE PAPER 12. To repeat the graphic across the entire background area, we need to select option in word processor. (a) Tile (b) Position (c) Stretch (d) Area 13. Scenarios are tool test for ____________ questions. (a) Auto (b) Goal Seek (c) What-if (d) Drop Down 14. ___________ is particularly useful when creating a watermark or when wrapping the image in the background in a document. (a) Transparency (b) Fill (c) Filters (d) Crop 15. It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate. (a) Row (b) Column (c) Autosum (d) Cell reference

CBSE Sample Paper Information Technology Class X (Term I) 23 16. __________, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows. Which one step must should follow before using the Subtotal option? (a) Consolidate (b) Rename Data (c) Filter Data (d) Subtotal 17. A ______ hyperlink contains the full address of the destination file or web page. (a) relative (b) absolute (c) mixed (d) address 18. Which of the following is more elaborate form of Goal Seek? (a) Subtotal (b) Scenario (c) Solver (d) Consolidate 19. _________ means combining data in a spreadsheet from different worksheets into master worksheet. (a) Hyperlinks (b) Consolidating (c) Linking (d) Filter 20. A/An__________ link will stop working only if the target is moved while a__________ link will stop working only if the start and target locations change relative to each other. (a) absolute, fixed (b) relative, absolute (c) absolute, relative (d) permanent, absolute 21. Database servers are referred to as _______________. (a) front-ends (b) back-ends (c) clients (d) model 22. A table is a set of data elements that is organised using a model of vertical ___________ and horizontal ____________. (a) rows, tables (b) columns, rows (c) rows, columns (d) forms, reports 23. _______________ include fonts, alignment, borders, background, number formats (for Latest CBSE SAMPLE PAPER example, currency, date, number) and cell protection in document. (a) Cell style (b) Numbering style (c) Paragraph style (d) Character style 24. By default, sheets tab are present at the __________ of the spreadsheet. (a) top (b) bottom (c) center (d) right 25. The cell reference in a spreadsheet for cell range B2 to F15 is _____________. (a) B2.F15 (b) B2;F15 (c) B2:F15 (d) B2-F15 26. ____________ controls how graphics are stacked upon each other or relative to the text. (a) Arrangement (b) Alignment (c) Anchoring (d) Wrapping

24 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. Millennium University is organising a reunion meet for their alumnae students. For this purpose, university wants to send the invite to all these students with their different addresses. Which feature of the Word Processor, University should use to accomplish the task? (a) Mail merge (b) E-mail (c) Templates (d) Data source 28. Prisha is a book editor. She wants to change the indentation of all paragraphs, and change the font of all titles in the book. Which feature she should use to make the task easy? (a) Styles (b) Templates (c) Table of content (d) Consolidating 29. Gaurav has inserted an image in a document. He wants to remove the unwanted area of the image. Which option of the word processor he will use to complete the task? (a) ClipArt (b) Cut (c) Crop (d) Contrast 30. Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday basis. There are number of steps which she needs to follow every time. Can you suggest her a feature of spreadsheet through which she can perform these tasks quickly without repeating the steps every time? (a) Record changes (b) Track changes (c) Goal seek (d) Using macros 31. Raj has created a worksheet where he has added all the information of his employees. He wants every employee to go through the worksheet and update their address and phone number, if required. He also would like to know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes made by his employees? (a) Macro (b) Link workbook (c) Change worksheet (d) Track changes Latest CBSE SAMPLE PAPER 32. Akshat wants to store a huge amount information about his firm in a database. Which type of table organisation would be most suitable for this purpose? (a) Relational (b) Flat file (c) Either relational or flat file (d) Hierarchical 33. Sunita is making a project in spreadsheets. Her friend has told her how to rename a spreadsheet as it will help her identify the worksheet data easily. She was very excited and told the same to her brother. Her brother told her that in spreadsheets (OpenOffice.Org), a worksheet can be renamed using __________ ways. (a) 2 (b) 3 (c) 4 (d) 1

CBSE Sample Paper Information Technology Class X (Term I) 25 Answers 1. (a) 2. (c) 3. (b) 4. (c) 5. (c) 6. (c) 7. (b) 8. (d) 9. (c) 10. (a) 11. (d) 12. (a) 13. (c) 14. (a) 15. (d) 16. (d) 17. (b) 18. (c) 19. (b) 20. (c) 21. (b) 22. (b) 23. (a) 24. (b) 25. (c) 26. (a) 27. (a) 28. (a) 29. (c) 30. (d) 31. (d) 32. (c) 33. (b) SOLUTIONS 1. Feedback is the receiver’s response to the Function Wizard : Insert ?Function. Subtotal Latest CBSE SAMPLE PAPER message. It is the final step in the allows us to perform functions like; Sum, communication cycle. Descriptive feedback Average, Product, Count but not percentage. provides meaningful information in a detailed, expressive manner that also contains some 9. In a document, alignment refers to the vertical analysis or suggestions, etc. or horizontal placement of a graphic in relation to the chosen anchor point. To set alignment, 2. Non-verbal communication occurs without select the image and click on the Align button using any oral or written work. It relies on and choose the required alignment. Images can non-verbal cues such as physical movements, have Left, Centered, Right, Top, Center, or colours, signs, symbols, body language etc., to Bottom alignment. express feelings, attitudes or information. 10. A template is predefined layout that contains 3. Self-motivation refers to your ability to identify sample content, themes, colours, font styles, effective methods of making yourself move background styles, etc., and gives an initial from thinking about something to taking foundation to build a document. Using a action about it. template, you can create your own document easily and quickly. 4. Stress is our body-and-mind’s response and reaction for challenging situations in our lives. 11. In Writer, you can apply headings, titles, text, It is our body’s way of reacting and getting lists and other predefined formatting styles to prepared to deal with a situation and the the text by using the styles pane. Character pressure it creates. The signs of mental stress styles are used for a block of text inside a are headaches, shortness of breath, dizziness, paragraph, for example they enable you to set feeling tired, anxious or depressed. the font, font size, applying bold or italics effect. 5. RTOS (Real Time Operating System) is a computing environment that reacts to input 12. A tiled background image is a small size image within a specific period of time. It aims at that is designed so that it can repeat seamlessly executing applications in real-time and it both horizontally and vertically. In word responds to input within a specific time processor, you can tile any image as the period. It is commonly used in Robots and background. scientific research. 13. The scenarios are important feature of Calc that 6. Computer viruses are small software programs use to test the ‘What-if’ questions. It enables you that are designed to spread from one computer to analyse the data by putting different input to another, to interface with the computer values. The other What-if tools are – Multiple operations. Antivirus software, also known as Operations, Goal Seek, and Solver. anti-malware software, is computer software which is used to prevent, identify, detect and 14. Transparency tool, on the pictures toolbar to remove all kinds of malicious software. Avast, make the image more transparent. This is Quick Heal, McAfee are some examples of particularly useful when creating a watermark anti-virus software. or when wrapping the image in the background. 7. A style is a set of formats that you can apply to selected pages, text, frames, and other elements 15. A cell reference refers to the value of a in your document to quickly change their different cell or range of cells on the current appearance. When you apply a style, you apply worksheet or a different worksheet within the a whole group of formats at the same time. spreadsheet. A cell reference can be used as a variable in a formula. 8. Subtotal is a function listed under the Mathematical category when you use the 16. The Subtotal feature in Calc is used for generating subtotals. It helps you to manage,

26 CBSE Sample Paper Information Technology Class X (Term I) Latest CBSE SAMPLE PAPER analyse, and extract specific information from and the reference of the lower right cell rows or columns of related data. It is basically (maximum value) of the range. used to summarize data. Cell range for cell reference is denoted by : 17. A hyperlink is a colored and underlined text or (colon) e.g. Cell reference for cell range B2 to F15 graphics that you click to open a file, or web is B2 : F15. page. In Calc, an absolute hyperlink is a hyperlink that contains the full address of the 26. Arrangement refers to the placement of a destination file or web page. graphic on an imaginary vertical axis. Arrangement allows you to change the 18. Solver is a What-if tool that follows the Goal stacking order of objects in your document. seek method to solve equations. It is the elaborate form of Goal Seek. The only 27. University should use the feature as Mail difference between the Goal seek and Solver is Merge. Mail Merge is a feature that enables that the Solver deals with equations that have users to send a similar letter or document to multiple unknown values. multiple recipients. It enables connecting a single form template with a data source that 19. Consolidating data means combining data contains information about the recipient’s from different sources into one place. Calc name, address and other predefined and provides the Consolidate feature that allows supported data. you to collate the data with minimal efforts. It selects the contents of cells from several 28. A Style in a word processor, is a collection of worksheets and maintains the collected data in various formatting features that defines the a master worksheet. look and behaviour of document components, such as paragraph, or a page or a group of 20. Absolute link will stop working only, if the selected characters. target is moved while a relative link will stop working only if the start and target locations 29. Cropping means removing the unwanted area change relative to each other. from an image starting from its boundary. Also, cropping removes a continuous section. 21. A database server is a server which uses a You cannot remove a random part of an image database application that provides database by using Crop tool. services to other computer programs or to computers, as defined by the client–server 30. The macro feature of Calc allows you to create model. It is also called as Back-ends as it stores a set of actions that you perform repeatedly in the data and also provide the data on request. a spreadsheet. You can run the macro as many times as you want. When you create a macro, 22. A table is a set of data elements that is you are actually recording your mouse clicks organised using a model of vertical columns and keystrokes. and horizontal rows. A table is an object of a database. It refers to a storage container storing 31. Track changes feature of Calc enables you to data pertaining to single object, subject or keep a track of the changes done by you or the purpose. other users in a spreadsheet. The changes done by you or other users in a spreadsheet can be 23. Styles help improve consistency in a reviewed later. document. They also make major formatting changes easy. Cell styles include fonts, 32. Data can be organised into two types: alignment, borders, background, number formats (for example, currency, date, number), (a) Flat File: Data is stored in a single table. and cell protection, in document. Usually suitable for less amount of data. 24. At the bottom of each worksheet window is a (b) Relational: Data is stored in multiple tables small tab that indicates the name of the and the tables are linked using a common worksheets in the workbook. By default, there field. Relational is suitable for medium to are three sheets available and the names large amount of data. displayed on these tabs are Sheet1, Sheet2 and Sheet3. You can add or delete sheets as per 33. There are three ways in spreadsheet to rename your requirement. a worksheet. 25. A range is a group of cells. In a spreadsheet, a (a) Double-click on one of the existing cell range is defined by the reference of the worksheet names. upper left cell (minimum value) of the range (b) Right-click on an existing worksheet name, then choose Rename from the resulting Context menu. (c) By using the Format menu.





SAMPLE PAPER 1 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. Which of the following is not considered as of body language? (a) Touching your face repeatedly (b) Offering your hand firmly for a handshake (c) Keeping your shoulders relaxed down (d) Greeting others with a gentle smile 2. The quantifier ‘some’ can be used as (b) uncountable noun (d) None of these (a) countable noun (c) Both (a) and (b) 3. ____________ hormones that are released in our brain and help us to cope with stress. (a) Dopamine (b) Serotonin (c) Endorphins (d) All of these 4. Seema has decided to do well in her coming mathematics test as she has overcome the fear of the subject. This is an example of (a) self-awareness (b) self-motivation (c) self-regulation (d) self-satisfaction 5. The shortcut key combination for opening file explorer window is ___________. (a) Windows + E key (b) Windows + X key (c) Windows + P key (d) Windows + F1 key

30 CBSE Sample Paper Information Technology Class X (Term I) 6. Which of the following is not considered as a computer virus? (a) Trojan horse (b) Malware (c) Worm (d) Bad sector Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. ___________ means removing a part from a picture staring from its boundary. (a) Deleting (b) Cropping (c) Removing (d) Resizing 8. __________ allows multiple users to view, edit and change in a spreadsheet. (a) Opening (b) Reviewing (c) Sharing (d) Collaborating 9. Template is a __________ document based on which one can create a new document. (a) blueprint (b) printed (c) suggested (d) copied 10. Which of the following is the correct formula to find the sum of the values present in cells B1 to B5 and C6? (a) Sum(B1, B5, C6) (b) = Sum(B1 : B5, C6) (c) = Sum(B1 : B5 & C6) (d) Sum(B1 : B5, C6) 11. Identify this picture formatting tool (a) send to back (b) bring to front (c) frame properties (d) borders 12. Grouping drawing object can be used for which of the following? (a) Combining drawing objects as one (b) Resizing (c) Adding more drawing objects (d) None of these 13. The use of count function is to (a) count the number of cells in a range (b) count the number of cells in a range containing only text entries (c) count the number of cells in a range containing only numeric entries (d) All of the above SAMPLE PAPER 1 14. According to Open Office Calc which of the following is not a What-if analysis tool? (a) Conditional formatting (b) Goal seek (c) Scenarios (d) Solver 15. Table of contents feature makes all the entries automatically as _________. (a) table (b) row (c) column (d) hyperlinks 16. Which of the following is not a good choice as a field name for a database? (a) Emp_Id (b) Emp_dept (c) Emp_name (d) Emp_set

CBSE Sample Paper Information Technology Class X (Term I) 31 17. Arguments in macros are passed as ____________. (a) values (b) functions (c) work (d) All of these 18. The data in the data source are organised in (a) text form (b) image form (c) tabular form (d) paragraph form 19. Which of the following is not an object of a database? (a) Report (b) Forms (c) Query (d) Functions 20. The select tool is present under which tool bar? (a) Image toolbar (b) Drawing toolbar (c) Standard toolbar (d) None of these 21. Which of the following is not a type of page margin in Calc? (a) Print (b) Left (c) Bottom (d) Right 22. ___________ provide(s) extra information about a value in the chart. (a) Legends (b) Data series (c) Data labels (d) Data info 23. A custom style displays _________ styles. (b) conditional (d) user defined (a) text (c) HTML 24. The Show Changes dialog box has which of the following settings? (a) Data (b) Comment (c) Views (d) All of these 25. The address of the active cell is displayed in (a) formula bar (b) active box (c) name box (d) the active cell itself 26. Reports are generally used to show the data in ___________ form. (a) printed (b) chart (c) Both (a) and (b) (d) None of these Section C Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Rishabh wants to make a professional resume. He tried many a times but the end result for not satisfactory as he was not knowing what all points should be there and in which order too. Which one of the following in Writer would you suggest him, so that his problem is solved? (a) Template (b) Form (c) Worksheet (d) Format SAMPLE PAPER 1 28. Shalini is working in a school. She is the class teacher of VIII B. It is the time to enter the subject marks and grades of all students of her class in a worksheet. While entering the marks and grades, she has to scroll up again and again to the row where all subject names are entered, in order to avoid any mistakes in her entries. This process is consuming a lot of her time. Help her by letting her know one such tool by which she can fix the fields row from the following and continue with her work without wasting much time. (a) Fix row (b) Fix column (c) Freeze panes (d) Freeze all

32 CBSE Sample Paper Information Technology Class X (Term I) 29. Surbhi wants to create a flowchart in order to show the steps involved in a problem, in a document. She has to make it using Writer document, but she is not sure how to make those shapes required in the flowchart. Suggest her the toolbar from the following, under which she can find those shapes. (a) Standard toolbar (b) Drawing toolbar (c) Status bar (d) Layout bar 30. Aanya is making a table in Access to store data of all the employees working in her organisation. She has decided on the various information that she needs to store in that table. She also has to have a field in which only unique data can be entered. Out of the given fields suggest the best field suitable that can be used as a primary key, so that it can accept only unique data. (a) Emp_name (b) Emp_dept (c) Emp_number (d) Emp_DOB 31. Dinesh found that the data which he needed for analysing and to make a decision is present in different locations. But these scattered data need to be combined together and placed at a single place for present and future use. Which of the following feature Dinesh can use for this purpose? (a) Consolidating data (b) Combining data (c) Placing data (d) Segregating data 32. Rohan works in the printing department of a fashion magazine. They have a huge list of subscribers who has registered for getting this magazine delivered to them through post. They have to make stickers containing the address of the subscribers of the fashion magazine to be pasted on the envelopes containing the magazine. Which of the following under Mail Merge ® Main document should they use for the same? (a) Letters (b) Lists (c) Labels (d) Documents 33. Manya has created a spreadsheet using Calc, to find the average of the values in a range of cells. She wants to use a function, so that it is calculated automatically and also she can copy the same formula for other range of cells. Which of these functions will give the correct result? (a) AVG (b) Average (c) Mean (d) None of these SAMPLE PAPER 1

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

34 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 1

CBSE Sample Paper Information Technology Class X (Term I) 35 Answers 1. (a) 2. (c) 3. (c) 4. (b) 5. (a) 6. (d) 7. (b) 8. (c) 9. (a) 10. (b) 11. (b) 12. (a) 13. (c) 14. (a) 15. (d) 16. (d) 17. (a) 18. (c) 19. (d) 20. (b) 21. (a) 22. (c) 23. (d) 24. (b) 25. (c) 26. (a) 27. (a) 28. (c) 29. (b) 30. (c) 31. (a) 32. (c) 33. (b) SOLUTIONS 1. Body language is the most important aspect of 11. Bring to front tool is used to bring the image on SAMPLE PAPER 1 our personality and how our image is formed the top of any other image or shape. Basically, among people. Touching your face repeatedly it moves the selected object to the top of the is not considered to be the body language. stacking order, so that it is in front of other objects. 2. We use quantifiers when we want to give information about the number or quantity of a 12. We can combine two or more shapes or object noun. ‘Some’ is used as both countable as well using grouping tool and use it as one object. as uncountable nouns. 13. Count function counts the number of cells 3. Endorphins are our body’s feel good having numeric entries in a range. CountA chemicals that are released in brain and help function counts the number of cells having any us to cope with stress. type of entries excluding empty cells. 4. Self-motivation is the ability to drive oneself to 14. What-if analysis is the process of changing the take initiative and actions to pursue goals and values in cells to see how those changes will complete tasks. affect the outcome of a formula on a worksheet. Goal seek, Scenario and Solver are What-if 5. File explorer is the most used application analysis tools, where conditional formatting is a which is used to browse folders and files that formatting option that allows user to format are stored in our computer. Windows + E key only those cells which satisfies certain is the shortcut to open it. conditions. 6. Computer viruses are malicious programs that 15. Table of contents creates a hyperlink for all the cause damage to data and files on a system. A entries which can be accessed through these bad sector in computing is a disk sector on a hyperlinks easily. disk storage unit that is permanently damaged. 16. Field is a piece of information related to a person or thing. For example, name, 7. Cropping means removing a part from a department, address of an employee. Emp_set picture starting from its boundary. Cropping is not a good choice as a field name for a removes a continuous section, you cannot database as it is not addressing to any details remove a random part of an image. about an employee. 8. Sharing of a document means the same file 17. Macros are basically a saved sequence of can be viewed, edited and reviewed by commands, which is stored for later use. The multiple users. The command Tools ® Share values are passed to a macro are called its document can be used to switch the mode for arguments. a document from unshared to shared. 18. The data source consists of the mailing list with 9. A template is like a blueprint document based specific fields such as name, address, contact on which you can create a new document. It is number, etc. The data is stored in tabular form. a preformatted document. 19. The database objects allow you to enter, store, 10. A function is a predefined calculation entered analyze and compile your data in the way you in a cell to help you analyze or manipulate want. Tables, Forms, Query, Reports are data in a spreadsheet. Sum function allows us database objects. Function is not an object of to find the sum of the values as per the database. It is a predefined formula that is used parameters given in the brackets. in Calc.

36 CBSE Sample Paper Information Technology Class X (Term I) 20. Drawing toolbar consists of various shapes to 27. Templates are the preformatted documents be drawn in the document. Select tool present which provide us with information and style on this toolbar is used to select an object. that can be used to create a new document. 21. Page margins are the blank spaces between the 28. The Freeze pane tool allows you to lock your worksheet data and the edges of the printed column or row headings so that, when you page. The preset margin in Calc are:top, bottom, scroll down or over to view the rest of your left and right. There is no option-print under it. sheet, these columns or rows remain on the screen. 22. A data label helps us to identify a data series in a chart. Data labels provides extra information 29. Drawing toolbar has a set of tools that can be about a value in the chart. used to draw various shapes in the document. 23. Custom styles list all the user defined styles. 30. A primary key is a field or set of fields with These are the styles that are created by users values that are unique throughout a table. A and saved for future use. primary key uniquely identifies a record in a table. It cannot be empty, also it does not 24. The Show Changes dialog box is used to control allow the user to enter any duplicate data. which changes to appear on the screen, like date, author, comment, etc. When reviewing a 31. Data consolidation is a process of collecting document, the show changes dialog box is used and integrating data from multiple locations filter the changes to be displayed. into a single file. 25. Name box is present on the left of the formula 32. Mailing labels are stickers that we put on the bar. It shows the address of the active cell or the outside of the envelopes. range that is selected. 33. Average function calculates the average of all 26. Reports are one of the objects of a database that the numeric values present in a given range of can be created and presented as hardcopy. cells. SAMPLE PAPER 1

SAMPLE PAPER 2 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. A communication is considered to be complete when ____________ is provided. (a) feedback (b) signal (c) message (d) barrier 2. Which of the following is not an advantage of verbal communication? (a) It saves time (b) It is quick in obtaining feedback (c) It is suitable for lengthy messages too (d) None of these 3. Pranay was feeling really stressed out and was not able to focus on simple daily task. His friend, Ravi suggested him to do something that combines physical poses, mind and body and will also help him in releasing his emotional energy. Ravi is mentioning about which technique of stress management? (a) Physical exercise (b) Yoga (c) Meditation (d) Laughter therapy 4. _____________ makes us resilient. (b) Self-regulation (d) Self-doubt (a) Self-motivation (c) Self-awareness 5. During a virus scan if the infected file is not deleted, but it has no opportunity to infect your computer, then such files are said to be (a) extracted (b) quarantined (c) removed (d) hibernated

38 CBSE Sample Paper Information Technology Class X (Term I) 6. The operating system that manages a group of independent computers and makes them appear to be a single computer is known as _____________. (a) single user operating system (b) multi user operating system (c) embedded operating system (d) distributed operating system Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. Which one of the following is a feature of a word processor? (a) OLE (b) Auto adjusting (c) Auto colouring (d) CUI interface 8. The shortcut key combination for centre alignment is ___________. (a) Ctrl + E (b) Ctrl + T (c) Ctrl + R (d) Ctrl + N 9. This feature in a spreadsheet displays only the rows that meet certain criteria and hides the rest of the rows. (a) selective display (b) conditional formatting (c) channelising (d) filtering 10. __________ refer to a set of formats consisting of fonts, font colours, font sizes and paragraph formats. (a) Fonts (b) Styles (c) Formats (d) Texts 11. A mathematical symbol in an equation can be inserted by (a) Insert ® Symbol ® Mathematics (b) Insert ® Special Character (c) Insert ® Symbol ® Equation (d) None of the above 12. When primary key constraint is applied on one or more columns, then it is known as (a) composite primary key (b) foreign key (c) composite foreign key (d) connecting key 13. C10 in a worksheet represents (b) C ® Row and 10 ® Column (d) Name of the worksheet (a) C ® Column and 10 ® Row (c) Name of the workbook 14. _____________ are the horizontal and vertical lines within the plot area in a chart. SAMPLE PAPER 2 (a) Graph lines (b) Gridlines (c) Plot lines (d) None of these 15. Which of the following is not a type of main document to be used in Mail merge? (a) Certificates (b) Letters (c) Envelops (d) Labels 16. Calc allows us to represent our data graphically by using ___________. (a) graphs (b) images (c) charts (d) drawings

CBSE Sample Paper Information Technology Class X (Term I) 39 17. Which feature in word processor enables you to surround a picture or diagram with text? (a) Crop image (b) Text wrap (c) Compress image (d) Compress text 18. Which of the following function key allows us to edit the data in the active cell? (a) F2 (b) F3 (c) F5 (d) F12 19. Identify this shape (a) Textbox (b) Callout (c) Dialog box (d) Insert textbox 20. Ctrl + P in Calc is used to (b) paste a worksheet (d) paste a formula in a worksheet (a) print the active worksheet (c) add a new worksheet 21. There are _______ handles around a selected picture. (a) 5 (b) 6 (c) 7 (d) 8 22. VisiCalc is one of the oldest (b) presentation software (d) calculating device (a) word processor (c) spreadsheet software 23. Which data type is most appropriate to store a short bio about an employee? (a) Text (b) String (c) Memo (d) Large text 24. The information like current page number, total number of pages and number of pages are displayed on (a) menu bar (b) status bar (c) horizontal ruler (d) None of these 25. Which of the following is a correct formula for finding the sum of all numbers present in cell A1 to A5? (a) =Sum(A1 : A5) (b) Sum(A1 : A5) (c) =Sum(A1 to A5) (d) =Sum(A1, A5) 26. To rename a worksheet, you can also ____________ on the sheet tab. (a) click (b) double click (c) triple click (d) scroll Section C SAMPLE PAPER 2 Answer any 5 questions out of the given 7 questions. (1 ´ 5 = 5 marks) 27. Amit has asked a question to 1000 people and want to show the data graphically for better understanding. The question is “Whether schools should be opened or not in present situation of pandemic?” He has given three choices, ‘Yes’, ‘No’ or ‘Cannot say’. Which chart type is best suitable for such representations? (a) Line (b) XY (c) Scatter (d) Pie

40 CBSE Sample Paper Information Technology Class X (Term I) 28. Inderjeet wanted to add his company’s logo at the top of the page and page number at the bottom of each page of his document. Which option he should use to get the desired result? (a) Header and footer (b) Head and foot (c) Top and bottom (d) Comment and note 29. Amit is very confused when it comes to integer subtraction. He is trying to solve a question ® What should be subtracted from – 9 to get – 5? Sanaya suggested him to use one interesting feature of spreadsheet to find the answer where he can enter – 9 in a cell and required answer in another and spreadsheet will do the rest. Which feature of spreadsheet is mentioned in the given context? (a) Calculation (b) Goal seek (c) Scenario (d) Macros 30. Priya bought a study material for preparation of the forthcoming examination. But she finds a faint picture, i.e. logo of the publication at the background of every page. Which effect is mentioned in the given context? (a) Copyright (b) Watermark (c) Logo design (d) Background image 31. Seema wants to copy a formula from a cell and use it somewhere else. At the same time, she doesn’t want the cell reference used in the formula to change, instead it should be fixed. Which cell reference would you suggest her to use in the formula? (a) Relative reference (b) Mixed reference (c) Absolute reference (d) Correct reference 32. Rajiv was asked to highlight the cells with green colour where the value entered is either greater than or equals to 120 in the worksheet containing thousands of data. Which feature of Calc he should be use to get the work done within seconds? (a) Conditional formatting (b) Filtering (c) Sorting (d) Simple formatting 33. Naina has created a database of all the employees working in her organisation. But these entries were done randomly. Her boss wants the entire list in ascending order of employee Id. She can do this by using which of the following tool in DBMS? (a) Ordering data (b) Sorting data (c) Presenting data (d) Referring data SAMPLE PAPER 2

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

42 CBSE Sample Paper Information Technology Class X (Term I) SAMPLE PAPER 2

CBSE Sample Paper Information Technology Class X (Term I) 43 Answers 1. (a) 2. (c) 3. (b) 4. (b) 5. (b) 6. (d) 7. (a) 8. (a) 9. (d) 10. (b) 11. (b) 12. (a) 13. (a) 14. (b) 15. (a) 16. (c) 17. (b) 18. (a) 19. (b) 20. (a) 21. (d) 22. (c) 23. (c) 24. (b) 25. (a) 26. (b) 27. (d) 28. (a) 29. (b) 30. (b) 31. (c) 32. (a) 33. (b) SOLUTIONS 1. A communication is considered to be complete 12. When primary key constraint is applied on SAMPLE PAPER 2 when feedback is provided. Feedback is one or more columns, then it is known as important as it ensures us to understand composite primary key. whether our message has reached the intended person and has been understood. 13. C10 in Calc represents cell address, where C is column name and 10 is row number. 2. Verbal communication is that style of communication where mostly you interact with 14. Gridlines are the horizontal and vertical lines others through spoken words. It is not suitable within the plot area in a chart. Gridlines are for lengthy messages. lines that cross the chart plot to show axis divisions. 3. Yoga combines physical poses, mind and body and will also help him in releasing his emotional 15. Mail merge is a special feature used to send a energy. document to multiple recipients at a time. Five types of main documents are there – 4. Self-regulation is the ability to understand and letters, envelopes, labels, e-mail messages and manage your reaction to the things happening directory. around you. Self-regulation makes us resilient. 16. Charts are the special feature in Calc that 5. Often, when your antivirus software finds a allows us to represent our data graphically. sign of infection, it places the suspect file into quarantine. Such files are not deleted but they 17. Text wrap is a feature in word processor cannot even infect your computer. enables you to surround a picture or diagram with text. 6. The operating system that manages a group of independent computers and makes them appear 18. F2 allows us to edit the data in the active cell. to be a single computer is known as distributed It can also be edited by double clicking inside operating system. the cell you want to edit, also by selecting the cell and editing data displayed in the formula 7. OLE is a technology that facilitates the sharing bar. of applications data and objects written in different formats from multiple sources. 19. Callout is a shape that is used to write little information about something in Writer. On 8. The shortcut key combination for centre the drawing toolbar, the Callout tool is used alignment is Ctrl + E. Center alignment means to add a rectangular Callout with a line. that the text is aligned around a midpoint. There is equal spacing from the left and right margin 20. Ctrl + P is used to print a document. In Calc, to the text. Ctrl+P is used to print the active sheet. 9. Filtering data is one of the features of 21. There are 8 handles around a selected picture. spreadsheet, which is used to find and work These handles are used to resize an image. with selected data. It only displays those rows They are present on top, bottom, right, left which satisfy a certain condition and hides other and at the corners of the image’s selection. rows that doesn’t fulfil the criteria. 22. VisiCalc is one of the oldest spreadsheet 10. Styles refer to a set of formats consisting of software. VisiCalc (visible calculator) was the fonts, font colours, font sizes and paragraph first spreadsheet computer program for formats. personal computers, release for Apple 11. 11. A mathematical symbol in an equation can be 23. Memo data type can store up to around inserted by 65,000 characters. Hence, it is used to enter description about anything in a table. Insert ®Special Character

44 CBSE Sample Paper Information Technology Class X (Term I) 24. The status bar displays information like current 30. Watermark is a faint picture or text present on page number, total number of pages and the background of every page. number of pages. It also displays the current language that is being used currently. Watermarking is a way of inserting any graphics or text in all the pages of a writer 25. A formula always starts with an equal to document to make sure that the document is symbol followed by the function name. To find not copied or distributed and it can be the sum of all values present in cells, Sum marked with watermark for easy function can be used. identification. 26. By double clicking on the sheet tab, a worksheet 31. Absolute reference is the type of reference, can be renamed. It can also be done by right where the address of the cell is fixed. It is clicking on the sheet tab and choosing Rename represented by using $ symbol before column sheet option. name and row number as well. 27. A pie chart is a circular statistical graphic, 32. Conditional formatting changes the which is divided into slices to show numerical appearance of the cells on the basis of proportion. specified conditions specified. It automatically applies cell style to cell or cell range when 28. Header and footer allows us to add certain user defined condition is performed. information like company’s logo, author’s name, page number and date etc, at the top and 33. Sorting data means arranging data in bottom of each page in document. ascending or descending order. Sorting helps to arrange data in a specific way for easily 29. Goal seek in Calc, helps us to find the desired accessible. Data can be sorted based on a result by adjusting an input value. It is one of specific field. the What-if tools. SAMPLE PAPER 2

SAMPLE PAPER 3 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. A Japanese woman who speaks only her language, would not be able to interact with an Indian woman who can only converse in Hindi. This is a case of ___________ barrier in communication. (a) bilingual (b) lingual (c) cultural (d) feelings 2. Weight gain or loss is one of the symptoms of ___________. (a) stress (b) lack of sleep (c) depression (d) heart problem 3. A temporary memory buffer provided by the operating system to store data for short term in a computer application is (a) copy board (b) file (c) clipboard (d) memory board 4. Slowly and gradually, she recovered. Identify the part of speech for the underlined words. (a) Adjective (b) Pronoun (c) Adverb (d) Verb

46 CBSE Sample Paper Information Technology Class X (Term I) 5. A/an _________ is an image that is available on your desktop to access that application. (a) icon (b) file (c) folder (d) None of these 6. Am I a good listener? This question will help us to know better about our (a) financial problems (b) neurological problems (c) physical problems (d) emotional problems Section B Answer any 15 questions out of the given 20 questions. (1 ´ 15 = 15 marks) 7. A new style can also be created in Writer by pressing which of the following key combination? (a) Shift + F12 (b) Shift + F11 (c) Shift +Ctrl + F11 (d) Ctrl + F11 8. Which of the following function is not present under statistical function? (a) If (b) Average (c) Max (d) Min 9. When we __________ worksheets, any changes made on the active sheet will also be applied on other sheets. (a) hyperlink (b) add (c) group (d) None of these 10. _________ and ___________ refers to selecting an image from a particular location, moving it by holding the left mouse button and placing it in the document where it is required. (a) Copy, paste (b) Move, paste (c) Drag, drop (d) Move, drop 11. In the Solver dialog box which of the following parameters is not used? (a) Target cell (b) By changing cell (c) Limiting conditions (d) None of these 12. The height and width ratio of a shape can be maintained by holding the _________ while drawing a shape. (a) Shift key (b) Ctrl key (c) Alt key (d) Tab key 13. $B5 and C$9 are examples of __________ reference. SAMPLE PAPER 3 (a) relative (b) mixed (c) absolute (d) combined 14. A _________ is the basic building block of any database that helps us to create a framework for storage of data. (a) form (b) query (c) table (d) report 15. Objects can be aligned horizontally and vertically. Which of the following is not a valid alignment setting? (a) Middle (b) Centered (c) Top (d) Bottom