(i) A template is a blue print to create... oi (a) Table (b) Table of contents, (c) Styles (d) Another document ii) refers to a range of cells (a) Row (6) Column (6) Cell reference (@ Formula j tiv) is a storage container which stores data that belongs to a simple object, j subject or purpose. ; (a) Database (b) Table i (c) Record (a) Field i o . _ option in Windows 10 is used to turn off animations and background images. (a) Narrator (b) Closed captioning ' (c) Magnifier (d) Other options } iy. isa group of computers that are connected in small area with the help of | some cables. ' (@) LAN () WAN i (VAN (a) RCN i Q3. Answer any 5 out of the given 6 questions. (1x 5.=5 Marks) (Which function cannot be performed through Subtotal in a Spreadsheet? (a) Sum (6) Product (©) Average (d) Percentage (i) Sarita is a poet. She wants her poems to reach the right people . For this she wants to start writing a blog. Which of the following sites can be used for the same? (a) Blogger (6) Word Press | (0) Type Pad (d) All of these i (ii) The description columa in Table Design view is used to } (a) Define data type for each field. i (b) Describe data to be stored in each field. i (c) Describe criteria for storing data in the field. (d) None of these (i) Consider the hyperlink-D:\Users\ Documents\mysheetxlsx. Identify the type of this document hypertink. (a) Absolute (6) Relative (0) Fixed (d) None of these (IT SAMPLE PAPERS}-X() Wi) Q4. @ Gi) (iii) (iv) @) (i) (62) ‘The final document produced after mail merge is called . (a) Main document (b) Data source (c) Merged document (d) Merge field Rohit has created 6 worksheets, in a single workbook, for each month for the sale of products in his shop. To check the half yearly sales, he needs to prepare a single worksheet. Which out of the following features will be helpful for him? (a) Goal Seek (b) Consolidate (c) Solver (d) Macro Answer any 5 out of the given 6 questions. (1x5=5 Marks) Why Styles are used in the document? (a) It maintains consistent formatting (b) Formatting changes in complete document is easy (c) The formatting is done very fast (d) All of these Ina worksheet, while performing consolidation, if same data range is selected from multiple worksheets, then consolidation is done by (a) Applying Average function on the range. () Copying data below the selected range. (c) Replacing data from the selected range. (@) Applying Sum function on the range. While creating a table in DBMS, which of the following is considered optional? (a) Field Name (b) Description (c) Data Type (@ Field size The structure of a table, once created, can be changed using (a) UPDATE (b) SET (c) MODIFY (d) ALTER TABLE Which of the following is not a type of blog? (a) Macro (6) News and views (©) Personal (d) Company ‘Saumya wants to use network banking for some transactions. She forgot the site address and searched it on Google. The search list is showing three websites with different starting symbols. Which of the following symbol should be in the beginning of URL? (a) HTTPS () FIP (c) HTTP (a) Any of these Pa eet)Q.5. Answer any 5 out of the given 6 questions. (To insert a downloaded image from Google into a document . processor is used. (a) Drawing objects (b) Pictures (c) Any of these (d) None of these (i) To connect the data in form of HTML page, which of the following should be done’? (a) Copy and paste the data in a workbook. (6) Create a document hyperlink for the HTML document. (0) Create link for the required components using link to external data. (d) All of these (iii) | When a primary key contains more than one field, it is called ... (a) Alternate (b) Foreign (c) Candidate (d) Composite (i)... ... is arranging data in order. (a) Filtering (b) Sorting (c) Reporting (@) Querying () SQL sands for .. : (a) Structured Query Language (b) Simple Query Language (©) Structured Quick Language (@ Simple Quick Language (vi) “Which of the following impairments effects the computer usage? (a) Speech (© Vision (© Mobility (d) All of these SECTION B SUBJECTIVE TYPE QUESTIONS (Lx 5=5 Marks +++ Option of wort ‘Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 Marks) Answer each question in 20-30 words. Q.6. There are some myths about Entrepreneurship. Mention any four of them. Q.7. Define organisational skills. Name some of the organisational skills. Q.8. Explain ‘M’ in SMART. Q.9. . What is the importance of time management? Q.10. Briefly explain the terms: (A) Worms (B) Trojan Horse (IT SAMPLE PAPERS)-X | (53)Answer any 4 out of the given 6 questions in 20-30 words each (2.x 4 = 8 Marks) Q.IL. Differentiate between a web server und a web client. Q.12. What do you understand by the following: (a) Magnifier (b) Speech recognition Q.13. When would you create a fink to data in extemal worksheet. Q.14. Write differences between a flatfile database and a relational database. Q.15. What are Clip arts? List any two websites that offer free clipart. Q.16. Differentiate between goal seck and solver. Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 Marks) Q.17. _Jaskeerat is a smart worker. He keeps on updating his knowledge and uses it to uplift his, work practices. As a data entry operator, he has to perform similar tasks on a group of worksheets. (A) How will Macros help him to do his work faster? (B) Using his programming skills, he wants to make some changes in macro that he bas created. How can he do it? (C) How can he write a macro as a function? (D) How are keystrokes stored in a macro? Q.18. Vinay has to prepare a sales report in which he has added some images. The size of the mage is too lange so he wants to resize the image? (A) Which option of word processor will change the size of image from both the dimensions? (B) Which tool he should use to keep the image in the centre of the text? (C) He wants to keep the image in the background with a transparent effect on it. Which tool should he use? (D) He wants to give a title to his report. Which tool offers artistic style of text? Q.19. Given below is the structure of a table named Library: [_ Meum star MemName VARCHAR(25) BookID CHARI) IssueDate DATE Return CHAR) (A) What is the difference between Char and Varchar? (54)Q.20. Q.21. (B) Write SQL queries to: (a) Create the table Library with Primary key MemID and the default value of Return as “N”. (b) Add record with given details (*MI01”, “Manya Gupta”, “BI151”, “2022-09-06”, (C) Change the value of Return as “Y” in the record of “Manya Gupta’, ‘Mohan is a shoe manufacturer and also runs his factory outlets. The company uses databases to maintain the sales records of their product. The data operator who enters the records of daily sales does not know how to work on tables in datasheet view. (A) What can be the other way to enter and modify the records in database’? (B) The manager of the company wants to see the sales of last month, Which feature will be helpful to view records for the same? (C) The manager wants the hard copy of sales for present month, Name the feature to perform this. (D) What is the difference between a Query and Report? Suhail uses Internet for his School Project but he is not aware of security issues regarding the Internet. Help him by solving the following queries. (A) What is a secure connection? (B) How you can recognize a secured connection? (C) Suggest any two security measures to ensure safety from online threats. (D) What is Firewall? N") (1. SAMPLE PAPERS}-X (55)SAMPLE PAPER-9 — SECTION A : OBJECTIVE TYPE QUESTIONS Max. Time: 2 Hours Max. Marks: 50 Qu. @ ii) ii) (iv) @) (i) Q2. @ (i) Gii) (56) Answer any 4 out of the given 6 questions on Employability Skills. (1x 4=4 Marks) ipple a day keeps a doctor away. (A/An/The) Which of the following is not the step taken by an entrepreneur to build up an organization? (a) Hiring Employees (b) Organizing the factors of production (©) Sourcing Finance (@ None of these Small pictures on the desktop are called ... si (@) Icons (&) Wall pape (©) Background (@) None of these Overgrazing may lead to .. ; (a) Deforestation (&) Ecological imbalance (c) Degradation of Lithosphere (d) None of these Working independently individuals become assets to ... (@ Organization (®) Group (©) Nation (@) All of the above “ss are the activities which help in reducing the stress. (a) Yoga (&) Physical Exercise (©) Healthy meals (A) Alllof these Answer any 5 out of the given 6 questions. (1x5=5 Marks) Numbering styles apply .. (@) Similar alignment (6) Numbering or bullet characters ©) Fonts to numbered list @) Alll of these When you open a new spreadsheet, by default it has one sheet with the name as (a) New Sheet (6) New workbook (©) Sheet] (d) Sheet The is a type of network which spreads across a city. (a) LAN (6) MAN (c) PAN (@ WAN Aes(iv) &) (i) Q3. ) ii) ii) (iv) 0) (vi) Q4. @ i) .. questions. ‘Scenarios is one of the tool t0 test .. (a) Solver (6) What. (6) Both (a) and (6) (@) None of these ‘Worksheet can be added or removed as per requirement”. Choose the correct option. (a) True (b) False (©) Can't say (d) None of these The is an organisation which provides you with access to internet. (a) ISP (b) ASP (0 TSP (d) None of these Answer any § out of the given 6 questions. (1x5 =5 Marks) The provides a convenient way to combine reusable objects. (a) Combining (0) Grouping (c) Selecting (@ None of these A is a graphical representation of data, in which the data is represented by symbols, such as bars. (a) Chart (b) Smart Art (c) Shapes (d) None of these keys are also known as modifier keys. (@) Shift (6) Ctrl (An (@ Allof the above To enable Macro Recording feature go to Tools and then select (a) Macros (6) Module (©) Options (@ Record Macro Symbol option is available under group in the Insert Tab in LibreOfffice. (a) Symbols (b) Shape (©) Media (@) Mlustrations The insert table option is in tab. (a) Home (6) Insert (©) View (@) Ilustrations Answer any 5 out of the given 6 questions. (1x 5=5 Marks) The... .. style include margins, headers and footers, borders and background. (a) Paragraph (b) Page (c) Table @) List Use the .. tab to format the entries in the table of content. (a) Tools : (6) Entry (c) Exit # (d) List (17 SAMPLE PAPERS)-x (87)(ii) In which menu Goal Seek is available in LibreOffice Calc? (a) Data (b) Tools (©) Window (d) Sheet (iv) Aksh have prepared 200 pages report and showed it to his senior. He suggested to replace the word ‘Board’ with the word “Board of Directors’. Suggest some features of Writer for doing this task. @) A. .. database refers to the data file that contains records stored in a single file. (vi) MANisa... .. which spreads across a city. Q.5. Answer any 5 out of the given 6 questions. (1x 5=5 Marks) (i) To combine two or more cells ... .. option is used. (a) Merge Cells (6) Split Cells (c) Protect Cells (d) None of these Wi). ... keys are also known as modifier keys. (a) Shift (b) Cul (alt (d) All of these (ii). . menu has the Define Ranges option. (a) Data (b) Tools (©) View (d) None of these (iv) By adding a... . the argument of a formula can be changed quickly. (a) Consolidate (b) Scenario (c) Macro (d) None of these (v) The field which is designated as the Primary key of a table cannot have ~ (a) Values (b) Duplicate values (c) Numbers (d) Text (vi) A table is an arrangement of ... : (a) Rows (b) Columns (c) Cells (d) Both (a) and (6) SECTION B : SUBJECTIVE TYPE QUESTIONS | Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 Marks) Answer each question in 20 ~ 30 words. Q.6. How can we overcome barriers of cultural influence? Q.7. What is self motivation? How can you motivate yourself”? (8) Pa ems SeQ.8. How does entrepreneurship help in promoting society growth? Q.9. Enlist any two major causes of air pollution. Q.10. How human body does respond to a stressful situation. ‘Answer any 4 out of the given 6 questions in 20-30 words each (2 x 4 = 8 Marks) QL. Differentiate between linking and embedding a document. Does embedding an object increase the size of the document? List any two websites that offer free clipart. [CBSE 2020] Q.12. What are electrical safety rules? Q.13.. Explain mail merge. Q.14. What are document templates? State the purpose of using document template. Qu5. Explain the following with respect to Databases: (a) Forms (b) Reports ICBSE 2020] Q.16. What are the good practices for internet security? ‘Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 Marks) Q.17. What is a template? How can you create a template? Q.18. Write command to create table named ‘BOOK * with following fields: FIELDS DATA\TYPES BOOK ID Char(4) Bname Varchar(15) Author Varchar(20) Price Decimal (@) Identify the primary key of the Book Table, also mention the suitable reason for choosing it as a Primary Key (b) Differentiate between (@ Char and varchar data type (i) DDL and DML (IT SAMPLE PAPERS)-X (59)Q.19. Write the SQL commands to answer the queries based on Fabric table FabricID Frame ~ : Type [Disc FOOL Shirt Woollen 10 F002 Suit Cotton 20 F003 Tunic Cotton 10 F004 Jeans Denim 5 F006 Shorts Cotton 7 (a) To insert the following record (“F005”, “Kurta”, "Woollen”,5) (b) To display only those fabric whose disc is more than 10 (c) To display those records whose type is "Woollen" (@ To delete the record of fabric *FO03” from table Q.20. Given the following Spreadsheet, Write the appropriate Formula/Expression/Function to be used for (a) to (d) :— A B _¢ oD E F 1 2 | Departmental Store 3 Prodcode | PNAME | QTY PRICE AMOUNT 4) P10 BAT 55 1250 5 | P102 RACKET 40 700 6 | P10s BALL 65 | | 150 7| 104 | GLoves so | | 300 8 TOTAL 9 AVERAGE 10: MAXIMUM (a) To calculate the Total Qty in cell C8. (b) To find the Maximum Price to be written in Cell D10. (c) To find the Average Qty to be written in cell C9, (d) To calculate the Total Amount in cell E8. Q.21. Explain the following terms — (a) Blog {h) Web Address. : (c) Network {d) Web Browser ~ (60)SAMPLE PAPER-10 SECTION A : OBJECTIVE TYPE QUESTIONS Max. Time: 2 Hours Max, Marks: 50 Qu1. Answer any 4 ont of the given 6 questions on Employability Skills. (1x 4.=4 Marks) (8) Distress is the term giveM 10 wannnnnnee + (a) Good stress (b) Bad stress (c) Eustress (@) None of these (ii) Self-awareness refers to awareness about one’s own (a) Strengths or weaknesses (6) Interests or capabilities (c) Values (d) All of these (iii) Susheela owns a manufacturing and packaging unit of Indian food items which she decides to sell in Dubai, Mexico and Russia. Due to some reasons the products did not sell and she bad a loss. She apologises to the people who work for her and promised to plan better for next time. She is : (a) taking responsibility for her mistakes. (}) thinking before making a decision (c) not giving up (@) being creative iw is the dashboard of your computer. (a) Taskbar (®) Start menu (0) Recycle bin (@ File explorer (6) Which of the following practices should be avoided for cleaning a computer? (a) Use lint free swabs to clean parts of computer (b) Spray a liquid before wiping the parts with cloth (c) Tum off computer before cleaning (@) Use natural bristle brush to clean internal parts (vi) - Which of the following is not a disadvantage of entrepreneurship? (a) Risks involved with success of new venture * (6) Working for long hours (c) No regular income initially (@) No higher authority (SAMPLE PAPERS)-XQ2. @ ii) Gii) (iv) wv) i) Q3. @ @ Answer any 5 out of the given 6 questions. (x 5=5 Marks) You anew style, an a «+. text selection into the Styles and Formatting window tn create (a) Drag and drop (b) Cut and paste (c) Copy and paste (d) Update Raghavendra is sending an invite to all his friends and colleagues for the celebration of 25 years of his anniversary. He is using mail merge to generate the invitation letters, Due to some reason he wants to change the venue given in the mail. Which of the following documents he has to change for the same? (a) Data Source. (6) Main text document. (c) Both given in (a) and (b). (d) None of these . adds data arranged in an array that is a group of cells with labels for colurnns or rows. (a) Consolidate (6) Group data (c) Subtotal (d) Query A relational database is defined as: (a) Relation between numbers in two tables (b) Relation between fields of tables (c) Consisting of separate tables of related data (d) Consisting of separate fields with common data A stand-alone computer is a computer that is: (a) Connected to the network. (b) Connected to the office network. (c) Not connected to a network. (d) Another name for a desktop PC. WordPressis an example of ct (a) Blogging site (b) Instant messenger (c) E-shopping site (d) None of these Answer any 5 out of the given 6 questions. {Lx $= 5 Marks) In word processors the drag and drop method will document. (a) Save (b) Embed (c) Delete (d) Cut Kritika is creating an annual sales report for her company. She uses the articles and charts of all the branch offices to create the final report. Now she wants al the reports to be identical Which of the following word processor features would help ber.to create such identical documents? weer the image into a (a) Mail merge (b) Graphics (©) Template (a) None of these(ii) — Which of the following is not an advantage of a database? (a) It supports data redundancy (6) Allows sharing of data {c) Ensures data security (d) None of these tiv) When all data is stored in one file, it is called . (a) Flat database (b) Relational database (c) Table (d) Report (») Which of the following is not an option for Intemet connectivity? (a) Dial-up (b) Broadband (c) Wistax (a) USENET (vi) Which of the following is not an antivirus software? (a) McAfee (by Norton : (c) MSOffice (a) Kaspersky QA. Answer any 5 out of the given 6 questions, (1x5 =5 Marks) (7) You can add an image into a document from (a) Scanner (b) Gallery (c) Clipboard (d) All of these (ii) Which of the following formula refers to cell BI in sheet Sales? (a) = Sales.BI (b) = Sales."BI" (c) SSales$BI (d) None of these (iii) A company has its offices in four major cities in India. The data of all regional offices is stored on separate worksheets, The company wants to consolidate this data. To use data from another worksheet, which of the following is most appropriate? a) Copying deta from all the sheets into @ new one (b) Creating Links to the data from another sheet (c) Copy data into sare sheet and then create link (d) All of these (ir) Primary key and alienate key together are called keys, (a) Foreign (b) Candidate fc) Non-primary (d) Composite (s) Which of the following is not an advantage of networking? (a) Resource sharing (b) Cost effective (c) Comansmication between computers {d) Conteol over compaters (vi) Which of the following fields in the table “Book” can act as a primary key? (a) Book amber (b) Suiject fe) Price (d) Author_name (1 BAMPLE PAPERS)-X (63)Qs. ® Gi) (iii) (iv) @) co) ‘Answer any 5 out of the given 6 questions. (2x5 =5 Marks) An absolute hyperlink contains the .. of the linked sheet. (a) Full address (b) Address from the current location (c) Web address (d) None of these a is not a DML command. (a) INSERT (b) DELETE. (c) CREATE, (d) UPDATE Which of the following defines a primary key? (a) The first field in the database (b) The date field in the database (c) The field which consists of numeric values (d) The field which stores unique value for each record ‘A query can be defined as a tool to .. (a) Enable users to enter and view data. (b) Filter data from the database based on some criteria. (c) Summarize and print data. (d) None of these A cell reference outside the worksheet is written a... (a) (b) (c) (d) Which of the following is not a use of Firewall? (a) Monitors all communications (6) Traps the unauthorized access (c) Prevents passage of unwanted contents (d) Prevents viruses and malicious software SECTION B SUBJECTIVE TYPE QUESTIONS ‘Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 Marks) Answer each question in 20-30 words. Q.6. What is the significance of self-awareness in achieving our goals? Q.7. What does ‘R’ mean in SMART goals? Q.8. “Stress is like a gateway that provides a heap of diseases.” Explain. Q.9. What is the use of File Explorer in windows? Q.10. How do entrepreneurs help in creating more entrepreneurs? 4)Answer any 4 out of the given 6 questions in 20-30 words each (2 x 4 = 8 Marks) QL. Discuss any four advantages of networking. Q.12. Define the following terms: (A) Toggle keys (B) Sticky keys Q.13. What is referential integrity? Explain with an example. Q.14, Ina finance company five users are working on the same shared document. Three of them are working on common overlapping data. What happens when they try to save the document? Q.15. What is the wrap secting? Mention the types of wrap settings available in Word processors. Q.16. You want to dd a link to a table in HTML namely sales.html How would you do it in Calc? Answer any 3 out of the given 5 questions in 50-80 words each (4 x 3 = 12 Marks) Q.17. _Jaskeerat is working in a renowned company that provides Network Solutions. The company has a worksheet that contains data of its valuable customers. This worksheet is available to all the employees that works for customer support. (A) Why the sharing of worksheet is required? (B) Jaskeerat has changed a value in the worksheet. Who else can see the changes? (C) List the features that are disabled in sharing mode, (D) How is document opened in sharing mode? Q.18. Suhana is creating 2 brochure for a school fair. She added picture in the brochure which contains some unwanted part (A) What can be done to remove that part from the picture? (B) There are few drawing objects on that brochure on which she wants to perform some common actions. How can she do it easily and quickly? (C) How can she keep the image between the text? (D) Is it possible to keep the image in the background of the text? How? Q19. Consider the following table named ‘House’ with details about houses allotted to the students in a school. (A) Which column can be set as a primary key in the given table? (B) Write SQL queries to: (@ Display the name, house, class in ascending order of the name of the house, (ii) Change the house name of Student with ID 11004 to Yellow, (iii) Delete the record of the student whose ID is 11006, (IT SAMPLE PAPERS)-X (65)Q.20. Q.21. (88) Ina school the records of students are stored in a database that consists of two tables. The first table stores personal details of students which are recognized by roll number. Every student has a unique roll number. This roll number field is linked with another table which stores marks of students. Answer the following with explanation in support of your answer. (A) What type of field is the roll number in the first table? (B) What is the term used to describe it in the second table? (C) What is composite primary key? (D) Define altemate key. Gayatri’s parents are old and cannot manage their day-to-day routine on their own. Earlier Gayitri was staying with them and taking care of their needs. But now she has got transferred to another city so she hired Sunanda for their help. But some of the tasks like paying electricity and phone bills etc, are still on Gayitri’s part. (A) How can she manage to pay the bills from another city? (B) Is it possible to purchase medicines for her parents from another city? How? (C) Name some of the applications that provide the facilities mentioned in (A) and (B)? (D) Define online shopping.