Code 402 Class 10 MS Office Base

Marks Breakup 200

Information Technology (402) Unsolved Sample Question Paper - 1 Class X Max Time: 2 Hrs. General Instructions Max. Marks: 50 ¦ Questions paper has 21 (5 + 16) questions of which 15 (5 + 10) questions must be answered. ¦ Do as per the instructions given with the questions. ¦ Section A: Objective type questions (24 marks) – Total Questions 5 ¦ Section B: Subjective Type Questions (26 marks) – Total 16 questions SECTION A: Objective Type Questions Q1. Answer any 4 out of given 6 questions on Employability Skills. (1 X 4 = 4) i. Traffic police and city administration use which of the communication means for instant guidance of the drivers and citizens? a. Visual b. Written c. Both a) and b) d. Oral ii. Kunal is working on a school project along with his 5 classmates. This team of 6 students has been assigned specific, independent tasks at their homes. They are supposed to meet next week to share their progress after accomplishing their tasks. Which of the following abilities would help Kunal and his team mates most in completing their independent tasks? Their ability to…. a. work as a team b. work independently c. be self-aware d. None of these iii. Snigdha went on a jungle safari trip along with her friends. They were riding a jeep and enjoying the surroundings when they saw a group of wild elephants running towards them. The elephants seemed angry. Snigdha jumped from the jeep and climbed the big tree to hide herself in its dense leaves. In which of the following categories should you keep Snigdha's response to the danger? a. Fight b. Eustress c. Distress d. Flight iv. Which of the following is not a function of operating system? a. Managing programs b. Managing Data c. User interface d. All of these v. Which of the following is not a myth related to entrepreneurship? a. No quick success guaranteed b. Easy to do c. More freedom d. Lot of funding is required vi. According to sustainable development goals, the economic growth of a nation should be which of the following? a. Inclusive b. Exclusive c. Always increasing d. Decreasing Q2. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Manish has a multipage document with headings, sub-headings and sub-topics. He wants to apply formal formatting on the document in least possible time. Which of the following is the best suited approach for him? a. Format painter b. Themes c. Template d. Formatting toolbar Sample Question Paper-1 (Unsolved) 201 Information Technology NSQF Level-2

ii. Naveen has inserted a large picture in his document covering half the page. He wants to keep the picture on one side of the page. Which of the features must help him in doing so? a. Cropping b. Rotating c. Text wrapping d. Resizing iii. Which of the following actions may increase the size of the image? a. Text wrapping b. Cropping c. Flipping d. Resizing iv. Anu could not find certain characters on the keyboard to type in her document. Which feature of the word processor program should help her? a. Shapes and special characters b. Shapes and symbols c. Symbols and special characters d. WordArt v. Each entry in a Table of Content is a/an _____________ to the topic. a. External hyperlink b. Internal hyperlink c. Reference d. Data source vi. The label's height and width are referred to as which of the following? a. Vertical pitch b. Horizontal pitch c. Both a) and b) d. Page size Q3. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Raman wants to calculate category-wise average of the sales of items in his shop. Which of the following spreadsheet feature will help him in this? a. Scenario b. Sub-total c. Goal seek d. Average function ii. In the formula, =sales_sheet!B5 * D5, the cell belonging to the current sheet is which of the following? a. D5 b. B5 c. Both a) and b) d. None of these iii. Relative hyperlinks are created on the basis of which of the following? a. Base address b. Common absolute address c. Linked text d. Linked file iv. Another name for internal hyperlink is which of the following? a. Defined name b. Bookmark c. Base address d. Data source v. Rajeev scored 70% marks in Math and 65% marks in Science. He wants to know how many marks he needs to achieve to secure at least 90% in English. Which feature of spreadsheet is best suited to calculate this? a. Scenario b. Sub-total c. Goal seek d. Macro vi. Raman wants to calculate minimised figure of annual expenses in cell J20 using Solver. Which type of the following is cell J20? a. Constraint b. Objective c. Changing d. None of these Q4. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. A database is an organised set of ___________. a. Tables b. Data c. Forms d. Queries ii. Incorrect and inconsistent data should not be stored in a database – this is ensured by which Sample Question Paper-1 (Unsolved) 202 Information Technology NSQF Level-2

of the following database features? a. Security b. Data sharing c. Data recovery d. Referential integrity iii. A database frontend interface is run by which of the following? a. Database server b. Database client c. DBMS d. Web server iv. A database table, that stores admission_number, student_name and address, has 900 records. What is the Degree of the table? a. 3 b. 1000 c. 2700 d. 300 v. Ritu is the class teacher of class 10th. She is creating a database table to store daily student attendance if the student is present or not. Which data type is most suitable for such field? a. Char b. Varchar c. Boolean d. Real vi. To setup a field as foreign key while designing a table, what should be done? a. Right click on the desired field b. Use Format toolbar c. Both a) and b) d. None of these Q5. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Varun is copy-pasting some text in a file. He needs the Ctrl key to remain active without pressing while he presses C for copy and V for paste. Which feature of operating system should he use? a. Toggle keys b. Filter keys c. Mouse keys d. Sticky keys ii. Bluetooth is best suited for which of the following network types? a. MAN b. PAN c. LAN d. WAN iii. Google hangout, Facebook messenger and Whatsapp are which of the following types of tools? a. Instant messaging b. Blogging c. Online classes d. Email iv. A blog needs to be ______________ for viewing by the people online. a. Promoted b. Published c. Shared d. Edited v. Find the odd one out payment mode. a. Netbanking b. Credit card c. Cash on delivery d. Debit card vi. In case of any cyberbullying, children must do immediately which of the following? a. Inform the principal b. Inform the police c. Inform their parents d. Inform their friends Section B: Subjective Type Questions Answer any 3 out of given 5 questions on Employability Skills in 20-30 words. (2 X 3 = 6) 6. Briefly describe any 2 features that mainly reveal about ourselves through our body language? 7. Why eustress is of a very brief duration? Explain with an example. 8. Do you think, the terms “innovation” and “entrepreneurship” related? How? 9. Which of the following is best suited to display a sequence of steps? a. Bullet list b. Numbered list c. Symbols d. Table 10. Using fossil fuel more and more instead of renewable energy will primarily harm which of the Sample Question Paper-1 (Unsolved) 203 Information Technology NSQF Level-2

following? a. Society b. Economy c. Environment d. Government Answer any 4 out of given 6 questions in 20-30 words. (2 X 4 = 8) 11. What is the basic difference between cropping and resizing a picture? 12. What is the role of “base address” in relative hyperlinking? 13. How a macro helps in easing our task in a spreadsheet? 14. Why do we need to store data in multiple tables in a database? 15. Briefly describe the standard flow of an online transaction such as purchase or booking a ticket. 16. How fire is a safety hazard over workplace? Answer any 3 out of given 5 questions in 50-80 words. (3 X 4 = 12) 17. Describe the role of Data source and Main document in the process of mail merge. 18. How is Goal Seek different from Solver? 19. What is a database? Briefly describe any 3 application areas of a database. 20. a. Consider the following table SUBSCRIBER structure and explain which field is best suited for being a primary key and why? EmailID Customer Name Course Type Fees b. Consider the following table FURNITURE and write the queries for the requirements that follow. Table: FURNITURE FURNITURE_CODE DESCRIPTION MATERIAL MRP DISCOUNT PERCENT Chair Plastic 1200 5 F001 Sofa Wood 85000 12 F002 Chair Wood 3000 8 F003 Table Plastic 3000 10 F004 Table Wood 25000 7 F005 Sofa Leather 85000 10 F006 i. Display the amount to pay after discount along with MRP of all the plastic furniture. ii. Display the details of all the wooden furniture items whose MRP is more than 20000. 21. Briefly describe some best practices for online security. Sample Question Paper-1 (Unsolved) 204 Information Technology NSQF Level-2

Information Technology (402) Solved Sample Question Paper - 1 Class X Max Time: 2 Hrs. General Instructions Max. Marks: 50 ¦ Questions paper has 21 (5 + 16) questions of which 15 (5 + 10) questions must be answered. ¦ Do as per the instructions given with the questions. ¦ Section A: Objective type questions (24 marks) – Total Questions 5 ¦ Section B: Subjective Type Questions (26 marks) – Total 16 questions SECTION A: Objective Type Questions Q1. Answer any 4 out of given 6 questions on Employability Skills. (1 X 4 = 4) i. Facial expression are the part of which mode of communication? a. Body language b. Visual c. Oral d. Feedback ii. Eustress is different from distress in which of the following? a. Useful b. Harmful c. Negative d. Bad iii. Nakul lives alone and does not know cooking. He eats outside and has a very tiring work schedule. Which of the following lifestyle is most suitable for him? a. Healthy eating and weekly yoga b. Gym and professional cook c. Both a) and b) d. Join cookery classes and early sleeping iv. Find the odd one out. a. Windows b. McAfee c. Linux d. Android v. Which of the following characteristic of entrepreneurship helps in dealing with competition? a. Good promotion of the product b. Experience c. Innovation d. Heavy investments vi. A sustainable solution is beneficial to which of the following? a. Environment b. Society c. Economy d. All of these Q2. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Mantra is new to word processing and needs to create her resume. Which of the following feature is best suited to her? a. Styles b. Themes c. Template d. Toolbars ii. Raman wants to create a write up on his trip to Bhutan. He has some pictures also. He wants to embed pictures among the typed words. Which feature is most suited to achieve this? a. Shapes b. Design toolbar c. Themes d. Text wrapping iii. Cropping an image affects the image in which of the following ways? a. Cropped region is removed b. Cropped region is retained c. Image dimensions are increased d. Image is distorted iv. Anu is generating 100 letters to her clients using mail merge feature. Which of the following document contains the names of her clients in one place? a. Merged fields b. Main document c. Data source d. Merged letters v. To generate an automatic Table of Content, it is important to apply consistent ____________ on the document headings and headlines. a. Font b. Style c. Colour d. Size Sample Question Paper-1 (Solved) 205 Information Technology NSQF Level-2

vi. Raj does not like any of the text styles in the word processor. What should he do to have preferred style? Ans. Q3. a. Format the text the way he wants and apply it on any existing style using Update i. action. ii. iii. b. Download more styles from internet. iv. v. c. Double click on the style and change it. vi. d. Use format painter tool. a. Format the text the way he wants and apply it on any existing style using Update action. Answer any 5 out of given 6 questions. (1 X 5 = 5) Which tool perfroms calculations based on certain constraints to optimise the output? a. Goal seek b. Scenario c. Solver d. Sub-total In the formula, =[Game]Attmepts!B5 + 1, what does “Game” refer to? a. Workbook b. Range name c. Worksheet d. Relative hyperlink A base address is helpful in defining which of the following? a. Absolute hyperlinking b. Relative hyperlinking c. Internal hyperlinking d. Bookmarks Three friends need to work on an online sheet. Which feature should they use? a. Share worksheet b. Compare and merge c. Relative linking d. Link worksheet Atul receives multiple worksheets from branch offices. He needs to consolidate all data on one sheet. Which of the following features is best suited for this? a. Macro b. Merge and compare c. Scenario d. Link sheets Sub-total feature helps in calculating which of the following on the basis of a label or field? a. Sum b. Average c. Both a) and b) d. Percentage Q4. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Which of the following helps in implementing Referential integrity in a database? a. Rules b. Validations c. Formulae d. Primary key ii. The term “Data redundancy” refers to which of the following? a. Duplicate values b. Invalid values c. Null values d. All of these iii. Which of the following database components cannot be used to modify the data in the database? a. Table b. Query c. Form d. Report iv. A database table, that stores 6 fields and 300 records. What is the cardinality of the table? a. 6 b. 300 c. 50 d. 1800 v. Atul is creating a database table and wants that if data entry for field “Department” is skipped then value “not assigned” should be stored in it. Which field property is most suitable to set for this field? a. Width b. Default value c. Required d. Decimal places vi. Which of the following is a conceptual similarity between a primary key field and foreign key field? a. They can store null values b. They cannot store null values c. They cannot store matching values d. They can store repeating values Q5. Answer any 5 out of given 6 questions. (1 X 5 = 5) I. Jatin's grandfather faces challenge in hearing and seeing. He needs to read an email on the screen. Which accessibility features should help him? Sample Question Paper-1 (Solved) 206 Information Technology NSQF Level-2

a. Magnifier and Toggle keys b. Magnifier and Visual notifications c. Visual notifications and Toggle keys d. Toggle keys and sticky keys ii. A good password is __________________? a. Of at least 40 letters b. Difficult to remember c. Combination of numbers, letters and symbols d. Combination of birth date, height and weight iii. Find the odd one out? a. Twitter b. Amazon c. Facebook d. Instagram iv. Which of the following is the medium of information sharing over internet and runs on http protocol? a. Google b. WWW c. Email d. Facebook v. Mr. Malik has a small office where 10 people work on their computers. Only his computer has a printer connected with it. Everyone needs to take printouts often for which they need to bother Mr. Malik. What solution is best suited to deal with this problem. a. Setup a LAN b. Take an internet connection c. Mail printable file to Mr. Malik d. Install a printer on every computer. vi. Which of the following allows only the authorised data packets into a computer or a network? a. Firewall b. Antivirus c. Antispyware d. Operating system Section B: Subjective Type Questions Answer any 3 out of given 5 questions on Employability Skills in 20-30 words. (2 X 3 = 6) 6. Briefly explain how listening helps us in carrying out effective communication. Ans. Listening with attention and making either mental or physical notes is also called active listening which is useful for a successful conversation. By proper listening only we can understand what the sender means to say. Listening helps in minimising misinterpretation of message and also the misunderstanding among people. 7. Describe briefly how distress affects us psychologically. Ans. Distress is the negative or harmful form of stress. Stress makes us less productive and affects our personality as a whole. Longer stress affects our mental ability and makes us anxious. This psychological stress may affect our health badly such as headache, restlessness, sleep deprivation, loss of concentration and mistakes in work. 8. Explain the facts about any 2 myths about entrepreneurship. Ans. It is a myth that entrepreneurs are free persons. They enjoy freedom because they are the owner of the company but, in fact, a passionate entrepreneur is married to his goal hence finds less free time for himself. It is a myth that entrepreneurship needs a lot of investment. One can start with a little amount and then can build up by attracting investors and other partners as the business progresses. 9. How is animation different from slide transition in a presentation software? Ans. Utility software allow us to perform various maintenance operations on the computer. We can keep our data secured from system crash by using Backup and Restore utility by taking regular backups and restore the data in case of data loss. Utilities like Defragmenter and Disk Clean Up help in reorganising the files on the disk for optimising disk space and to remove unwanted files to make more disk space. An antivirus helps us in detecting and removing harmful programs from the computer through regular system scan. Sample Question Paper-1 (Solved) 207 Information Technology NSQF Level-2

10. Explain how any 3 challenges in the way of sustainable development can be overcome. Ans. Through strong institutions and policies, we can implement development programs effectively. Equal opportunities for education and employment help society grow together and by using renewable energy sources we can ensure clean and sustainable environment and climate for all. Answer any 4 out of given 6 questions in 20-30 words. (2 X 4 = 8) 11. Rajeev needs to create Table of Content for his multi-page school project report. With a small example, explain how document Styles can help him in this. Ans. An efficient way of creating a ToC is to apply styles on the headings in the documents which are needed to include in the ToC. For example, the document Rajeev’s project report will contain various sections, topics and sub-topics. Each section name can be given the a text style such as Heading 1, topics can be applied with a different style with smaller size such as Heading 2 and sub- headings can be of different styles. Then, the table of content will be created automatically on the basis of sections, topics and sub-topics. 12. What do you mean by “what-if ” analysis? How does Goal seek or Scenario (any one) feature helps in it? Ans. What-if analysis is a way to do forecast on the basis of assumed but realistic figures. For example, “what” should be the Total marks “if ” the marks in Math are increased? There are various ways to perform what-if analysis in electronic spreadsheets such as applying scenarios, goal-seek etc. Scenario is a way to define a set of values which can be applied on an existing data-set. The original data-set is substituted by the scenario data-set and user can analyse the changes. Goal seek feature is used when we need to assess the impact of change in a data value on another data value. Using goal seek we can determine the input for a desired output. For example, how many marks are needed to score total percentage 90% 13. What problem does relative hyperlinking overcome? Explain with a small example. Ans. Source document (that contains hyperlinks to other files) and the linked files are often stored in different folders. We often move and copy files into different folders. Due to this, linked files become inaccessible through hyperlink as their location gets changed. To avoid this problem, we need to determine the common folder path between the source file and the linked files. If we do not change the common folder path the relative hyperlinking remains intact. For example: Source file path: D:\\myreports\\2021\\Main.xls Linked files are on the path: D:\\myreports\\2021\\Quarters\\Quarter1 Relative hyperlink: \\Quarters\\Quarter1 14. Which limitation of flat file system is resolved by relational database model? Ans. Flat file system such as spreadsheets are good to store smaller data sets for analysis but they cannot take care of redundant data and storage of invalid data as compared to databases. Managing data (update, delete, insert) also becomes difficult and may lead to data redundancy and accidental loss of data. Relational databases take care of these problems through multiple tables related on common fields (primary key value matching with foreign key) and applying suitable referential integrity. 15. How WWW is different form internet? Ans. Internet is the worldwide network composed of computers and digital devices sharing information over various communication channels such as telephone lines, satellite and wireless protocols. It is the physical form of worldwide communication network. World wide web is the medium in which information od shared and transferred in multimedia form and hypertext. Hypertext transfer protocol and TCP/IP are used to share and send information. WWW is the digital medium of information over internet. Sample Question Paper-1 (Solved) 208 Information Technology NSQF Level-2

16. Briefly describe how students can ensure their safety in various locations such as playground, Ans. school laboratory and classroom? In playground, students must follow the rules and guidelines meant for various sports activities for example wearing suitable guards while batting or not trying any exercise in the gym without suitable guidance. School laboratory needs disciplined use of equipment, chemicals and other tools to avoid accidents. Correct posture while sitting in the classroom and proper use of furniture is necessary. Answer any 3 out of given 5 questions in 50-80 words. (3 X 4 = 12) 17. What is the significance of Table of Content in a document? What role do document heading styles play in creating a ToC? How will you create a simple ToC of heading and sub-heading in a word processor? Ans. A table of contents (ToC) contains the numbered list of topics in a document and the page number on which they are located. In the soft copy of the document, each entry in the ToC functions as an internal hyperlink to the topic content. A ToC can be created automatically in any word processor by applying various styles on the headings in the documents which are needed to include in the ToC. It is necessary that document contains adequately defined standard headings such as Heading 1, Heading 2, Heading 3 etc. To create a ToC in the document, first place the cursor where you need the ToC to appear (usually in the beginning of the document), then go to Reference tab. Click on Table of Contents drop-down in Table of Contents group. Choose any automatic style. 18. Write a brief note on the significance of sharing worksheets in an online work environment stressing on the advantages of sharing. Ans. Sharing means use of a resource by multiple users either simultaneously or on need basis. The same is true for worksheets. Worksheets help in storing data in a symmetrical and tabular form, perform calculations using various formulas and functions and analyse the data. For multiple users, as many copy need to be created and then update of all such worksheets is a difficult task which leads to errors and data loss. To avoid such problems, it is a good practice to share the same worksheet among all the users by keeping it at a public location such as cloud drive or a shred drive. Sharing eliminates the need of maintaining multiple copies of same data and helps in easy track of who made what changes in the data by using another feature called tracking and reviewing. This necessary step comes under preparing the sheet for sharing. 19. What is an RDBMS? Why do we need a database to manage data of any enterprise? Ans. Organised arrangement of data is called a database. A relational database management system is a software application that stores data in one or more tables called relations. These tables are related with each other through common fields to retrieve complete information whenever needed. Databases are indispensable for all kinds of industries. Some examples are such as schools keep the details of students admission, their exam performance details, fess details etc. In businesses like banks and industries databases are used to store the details of various transactions, customers and products etc. All the data we see online comes and gets stored in a database like train reservations details, hotel bookings, online book stores, social media platforms etc. Without databases it is impossible to present, organise, manage and secure the information. 20. a. Write the SQL statement to create the following table PLAYER. Specify a primary key field also. Which field do you think suitable to be a primary key. Why/why not? What is the remedy? Player_Name variable character length max 40 Goals_Hit must store number Matches_Won must be a number Ans. Create table PLAYER(Player_Name varchar(40), Goals_Hit number, Matches_won number); Sample Question Paper-1 (Solved) 209 Information Technology NSQF Level-2

None of these fields are suitable for primary key since all of them are prone to duplicate values (similar player names, same goals and matches won). It is recommended that an additional field be added in the table as primary key. For example, PlayerID. The correct statement now, is: Create table PLAYER(PlayerID number primary key, Player_Name varchar(40), Goals_Hit number, Matches_won number); b. Consider the following table MARKS and write the queries for the requirements that follow. Table: STUDENT ADM_NO STUDENT_NAME ACADEMICS SPORT Raj 80 47 101 Anu 97 82 102 Ravi 56 54 103 Ali 76 81 104 81 59 105 Harjot 93 88 106 Mamta i. Display the average of academics and sports percentage of all the students. Ans. Select ADM_NO, STUDENT_NAME, avg as ((ACADEMICS + SPORTS)/2) from STUDENT ii. Who have scored distinction (>=75%) both in academics as well as sports? Ans. Select STUDENT_NAME from STUDENT where academics >=75 and sports>=75 21. Briefly discuss how we can prevent common accidents over workplaces. Ans. Safety guidelines, rules and their communication keep people aware. Conspicuous warning signs, directions, safety tips and indicators for any diversions during maintenance, conveyance of timely emergency warnings. Efficient housekeeping should be ensured through trained and skilled staff. Preventing unauthorised access through restricted entry rules and practices (ID cards, security checks, digital swipe cards, fingerprint scanners, CCTV cameras, alarm systems). Safety guidelines during operations at various work areas. Risk assessment to understand and prevent potential dangers and to ensure safety quality of the workplace. Regular training of new staff regarding safety practices. Discipline, alertness and care are the three basic qualities which help maintaining common security. Positive attitude and awareness of the people is of importance here. A sense of responsibility and professionalism needs to be there in working personnel to cooperate in observing safety at workplace. Sample Question Paper-1 (Solved) 210 Information Technology NSQF Level-2

Information Technology (402) Solved Sample Question Paper - 2 Class X Max Time: 2 Hrs. General Instructions Max. Marks: 50 ¦ Questions paper has 21 (5 + 16) questions of which 15 (5 + 10) questions must be answered. ¦ Do as per the instructions given with the questions. ¦ Section A: Objective type questions (24 marks) – Total Questions 5 ¦ Section B: Subjective Type Questions (26 marks) – Total 16 questions SECTION A: Objective Type Questions Q1. Answer any 4 out of given 6 questions on Employability Skills. (1 X 4 = 4) i. Which of the following is considered as Social distance among people? a. More than 10 feet b. Less than 10 feet c. More than 10 inches d. Less than 10 inches ii. Which of the following constitutes environmental stress? a. Noisy or polluted surroundings b. Classroom c. Movie hall d. Late night party iii. Owning your task and being responsible for it is the sign of which of the following? a. Self-awareness b. Ability to work independently c. Healthy work habit d. Eustress iv. Which one of these is used where multiple computers and users are involved? a. Distributed OS b. Multi-user OS c. Both a) and b) d. Real-time OS v. An entrepreneur is uniquely different from a businessman in which of the following characteristics? a. Finances b. Business model c. Innovation d. Management vi. Find the odd one out in the following SDGs. a. Zero poverty b. Zero hunger c. Life below water d. Gender equality Q2. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Which of the following help save time in formatting a document? a. Styles b. Themes c. Template d. All of these ii. A pre-loaded group of illustrations is called which of the following? a. Shape b. SmarrtArt c. WordArt d. ClipArt iii. Which of the following can be inserted in the document from online sources also? a. ClipArts b. Pictures c. Both a) and b) d. Shapes iv. When text wraps closely and tightly around the image then it is which of the following wrapping types? a. Tight b. Square c. Through d. None of these v. To insert a left pointing arrow in the document, Anu needs to use which of the following? a. Left arrow key b. Symbols c. ClipArt d. Picture vi. Nitin needs his document template seen in the user templates category on opening his word processor. What should he do? a. Save the template in C drive. Sample Question Paper-2 (Solved) 211 Information Technology NSQF Level-2

b. Save the template in the folder where word processing application is installed. c. Save the template in the default template folder of the word processing application. d. Just save the template anywhere on the computer with the extension .dot. Q3. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Sameer has a worksheet containing student names, classes, sections and marks. He wants to calculate the average marks of the students, section-wise. Which of the following feature should he use? a. Scenario b. Sub-total c. Goal seek d. Average function ii. In cell A1, this is the formula, =[Reports]January!D8 + 1. If current worksheet has value 12 in the cell D8 then what will be the result of this formula? a. One more than the value in cell D8 of current sheet b. One more than the value in cell D8 of sheet January c. One more than the value in cell D8 of workbook January d. One more than the value in cell D8 of sheet Reports iii. The main purpose of what-if analysis is which of the following? a. Calculating sub-totals b. Preparing data summary c. Doing forecast d. All of these iv. The common path to the linked files and the main file (that contains the link to other files) is called which of the following? a. Base path b. Absolute path c. Hyperlink d. All of these v. Data redundancy in the worksheet and real-time updates can be achieved by which of the following features? a. Macros b. Sharing the sheets c. Merge sheets d. Link sheets vi. Which of the following is required to prepare a sheet for sharing? a. Linking the sheets b. Merging all the sheets c. Enabling Track changes d. Writing required macros Q4. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. Composite keys functions as which of the following? a. An alternate key b. A foreign key c. A unique key d. A primary key ii. Referential integrity deals with which of the following? a. Data redundancy b. Data security c. Data sharing d. All of these iii. Which of the following database components are used to display desired information from the database tables? a. Query b. Report c. Both a) and b) d. None of these iv. VARCHAR(10) can store minimum how many characters? a. 10 b. 0 c. 1 d. 80 v. Out of three fields, two are chosen to create a composite key in a table. Which of the following were these three fields before creating the primary key? a. Alternate keys b. Candidate keys c. Composite primary keys d. Foreign keys vi. Find the odd one out. a. INSERT b. CREATE c. UPDATE d. DELETE Sample Question Paper-2 (Solved) 212 Information Technology NSQF Level-2

Q5. Answer any 5 out of given 6 questions. (1 X 5 = 5) i. ii. Computer Accessibility options are referred to as which of the following? iii. iv. a. User friendly options b. Assistive technology v. c. Cognitive technology d. User assistance technology vi. Which of the following is not a part of a peer-to-peer computer network? a. Clients b. Server c. Both a) and b) d. Proxy server Find the odd one out? a. Wi Fi b. Dial up c. 3G d. 4G Which of the following is considered as shouting and aggressive according to chat etiquette? a. Typing the messages in bold b. Typing the messages in all uppercase c. Typing the message with unconstitutional language d. Typing the messages with smileys. Ajit wants to share his knowledge of internet in the form of several articles for the online communities. Which of the following ways is best suited? a. Blog b. YouTube video c. Facebook page d. WhatsApp group Which of the following is a mandatory requirement for all kinds of work places? a. Ergonomic furniture b. Personal protection kits c. Soundproof workplace d. First Aid Kit Section B: Subjective Type Questions Answer any 3 out of given 5 questions on Employability Skills in 20-30 words. (2 X 3 = 6) 6. Briefly explain the significance of feedback in effective communication. Ans. Feedback is the response of the message recipient to the message sender. Feedback helps sender ensure that message is understood by the recipient as intended and helps recipient in ensuring that he/she understood the message correctly. Feedback helps in the progression of communication and helps in ending the communication cycle successfully leaving both all the parties of communication satisfied. 7. What are the consequences of long-term stress? Ans. Long term stress is nothing but several consecutive short durations of stress ignored by the person. Stress, when overlooked for a longer period of time, leads to adverse physical and psychological effects. A little fatigue may turn into restlessness and insomnia. Headache and physical exertion may lead to heart troubles and muscular tensions etc. Psychologically, a person may fall victim to anxiety, depression and drug abuse – ending up in a rehab centre. 8. What is a virus? What general symptoms hint the presence of virus in a computer? Ans. A computer virus is a harmful program which attaches itself with the computer files and infects them. It can copy itself and spread across other computers over a network or through shared storage media. Some common virus symptoms are: 1. Computers works too slow. 2. Sudden restart or crash. 3. Unwanted, strange notifications pop up. 4. Undesired disk activity. 5. Unwanted files are created. 9. How do entrepreneurs contribute to society and economy? Ans. Entrepreneurs provide employment opportunities to the skilled professionals. They mobilise public’s money through investment to grow business. They bring positive change in the lives of the people through their innovative products and services. This way, entrepreneurs contribute in GDP, industrial growth, economy and society. Sample Question Paper-2 (Solved) 213 Information Technology NSQF Level-2

10. What is the significance of sustainable development drive? Ans. In the race of rapid development, achieve growth and prosperity in lesser time and to outdo other countries and competition, today we are facing the problems such as inequality, poverty, threat to environment and a big gap between haves and have-nots. To address these problems, 17 global sustainability goals have been envisioned by United Nations member countries. The goals encourage sustainability drive and mission in different countries to find suitable solutions to the prevailing problems. Answer any 4 out of given 6 questions in 20-30 words. (2 X 4 = 8) 11. How do document styles and themes help in creating documents easily and quickly? Ans. A standard word processor provides a library of text styles for various headings, titles, sub headings and other text components. These styles can be applied on the document text easily. User can define own styles too. Themes are predesigned sets of text colour, fonts and effect which can be applied to the text and consistent text formatting is applied in no time. This way, document can be given a professional look with least efforts and time as compared to doing it manually through menu options. 12. Sameer manages the sales teams of 5 branches of his company. To each company, he has given the target sale to be done 3 products and discounts to be given on each product. He has a sheet that shows the sales of 3 products in current month. He wants to check how the sales figures will change for different 5 branches. Which feature of the spreadsheet should he use to do so? Ans. Sameer must use Scenarios feature because the change in the sales figures needs to be observed by applying details of 3 products for different 5 branches. Figures of targets and discounts for each branch is like a different scenario. So he can create 5 scenarios (one for each branch) and apply them one by one on the main data sheet to observe the changes in the sales figures. 13. What is the significance of sharing sheets or documents? Ans. Today businesses work through internet and WWW. The traditional ways of working with data are the things of past. Sharing data and working on shared resources is a common practice. Practically, more than people work on a single document so it is beneficial to keep a single copy of sheet or document shared among all the people concerned. It saves time, real time updates can be done in the single sheet in a collaborative work environment. This saves expenses and time. 14. In a database, reports display the data stored in the database. So do the query results. Then, how are reports useful as compared to queries? Ans. A query is a way to retrieve some information on ad-hoc basis as and when required randomly on the need-basis. Queries also help in retrieving information needed to be shown in reports. Reports are a formal, more organised way of presenting data for the purpose of analysis and decision making for future. Reports help management understand various aspect of the business progress and trends. 15. Which accessibility features of an operating system help visually impaired users and how? Ans. Visual impairments usually include poor vision, complete or partial blindness and colour blindness etc. For such users, operating system provides features such as: 1. Setting up a high contrast display theme to see options and icons etc. with more ease. 2. Text can be read aloud from files and screen using Narrator feature. 3. For any videos played, audio description feature can describe the video. 4. Magnifier can be used to display any part of the screen enlarged multiple times. 5. The thickness and size of the cursor can be adjusted. 16. What is the significance of offline blog editor? Ans. Offline blog editors are software applications that allow the blogger to manage his/her blogs when due to any reason internet access is not available. Offline blog editor maintains a local copy of the blogs. Changes to the existing blogs and any new blog created can be published on the online blog Sample Question Paper-2 (Solved) 214 Information Technology NSQF Level-2

account once the internet access is available. Offline blog editor allows the user to setup connection with the online blog site once and then it helps in updating the changes in local copy of the blog to the online site. Answer any 3 out of given 5 questions in 50-80 words. (3 X 4 = 12) 17. Rajeev is planning the layout of a weekly magazine for his school. What approach should he follow to design every edition of the magazine easily with consistent design? Ans. Rajeev can use a template to create first edition of the magazine. Templates are the predesigned formatted documents. Using a template, he can design the first edition and then he can make a few different templates by modifying the first templates. He can later use these newly created templates for forthcoming editions. Since templates include preformatted pages, they can be used in creating consistent designs of the magazine with little modifications required. The templates must be saved in the default template folder of the word processor to list them in the New command of the software. 18. Giving a brief example, explain the distinct situations wherein goal seek and scenarios features help by applying them in data in a spreadsheet. Ans. Both scenario and gaol seek are what-if analysis tools which allow us to see “what” changes would happen “if ” the data values are changed in a particular manner. A scenario is a set of assumed but realistic values that are applied on the original data-set to analyse different situations predicted in the scenario. For example, to observe how the average percentage of students will change by applying different marks we can create desired scenarios to be applied on the actual data set shown below: STUDENT ACADEMICS COCURRICULAR SPORTS AVERAGE PERCENT ANU 78 98 67 81 RAVI 89 78 87 85 AMIT 93 89 88 90 RAJ 59 88 93 80 Various scenarios can include different marks for each column for each student. Goal seek allows us to determine the input for a desired output. In the following example, teacher needs to know how much should have been the percentage marks in ACADEMICS (cell A3) to achieve the AVERAGE (D3) of 75% (output value). The goal-seek has shown that in cell A3 value 68 will bring average of 75 in cell D3. 19. Various scenarios can include different marks for each column for each student. Ans. Goal seek allows us to determine the input for a desired output. In the following example, teacher needs to know how much should have been the percentage marks in ACADEMICS (cell A3) to achieve the AVERAGE (D3) of 75% (output value). The goal-seek has shown that in cell A3 value 68 will bring average of 75 in cell D3. What do you mean by referential integrity? What is its significance? Managing data in multiple tables raises the need of maintaining accurate and consistent data. Sample Question Paper-2 (Solved) 215 Information Technology NSQF Level-2

Referential integrity is the concept to ensure that accurate and consistent data is maintained in the database tables which are related. Referential integrity addresses following 3 aspects: A. Value entered in foreign key in child table must match a primary key value in the parent table. B. Any update in the key of the parent table will automatically update the matching values in child table. This is called Update cascade. C. Any delete operation on a record in the parent table will automatically delete the matching records in child table. This is called Delete cascade. 20. a. Write the SQL statement to create the following table USER. Specify a primary key field also. Ans. Which field do you think suitable to be a primary key. Why? First Name variable character length max 50 Last Name variable character length max 50 BirthDate datetime Username variable character length max 50 Password variable character length max 20 Create table USER(First_Name varchar(50), Last_Name varchar(50), BirthDate datetime, Username varchar(50) primary key, Password varchar(20)); No usernames of two users can be same so field Username is best suited to be set as primary key. b. Consider the following table data and answer the questions that follow: Table: PRODUCT ITEM_NO PRICE DISCOUNT_PERCENT AMOUNT_PAYABLE 101 2500 10 102 1320 8 103 5000 12 104 1300 10 105 4500 8 106 1000 10 i. Display the discount amount of all the items. Ans. ii. Select ADM_NO, DISCOUNT as (PRICE/100) * DISCOUNT_PERCENT from PRODUCT Ans. Calculate and store the amount payable after discount in the table for the items having price more than 1500. 21. Ans. Update PRODUCT Set AMOUNT_PAYABLE = PRICE – ((PRICE/100) * DISCOUNT_PERCENT) Where PRICE > 1500 How can healthy living help us in staying a safer life? An individual should take care of his/her health and physical wellbeing Some common ways to healthy living can be mild exercises which help in keeping fit and getting rid of stress. Yoga and meditation relieve mental stress and develop a positive mind set. As well as impressive physical appearance too. People can play sports, go for jogging or visit gym regularly as a hobby to keep fit. Sport involve physical exercise, running and any game like chess, sodoku etc. tweak mental fitness. Healthy eating means eating in right measure and frequency. Having some sort of discipline in eating brings out good physical results and add to the impressive personality. Avoiding indulgence in drinking and smoking is good. In addition, observing basic human values such as humility, respectfulness, avoiding fruitless conflicts, being considerate, developing civic sense, clean and good habits make one strong from inside and develop an effective and positive outlook. Sample Question Paper-2 (Solved) 216 Information Technology NSQF Level-2