CBSE | DEPARTMENT OF SKILL EDUCATION
Information Technology (SUBJECT CODE – 402)
Blue-print for Sample Question Paper for Class X (Session 2023-2024)
Max. Time 2 : Hours | Max. Marks: 50
PART A – EMPLOYABILITY SKILLS (10 MARKS):
| UNIT NO. | NAME OF THE UNIT | OBJECTIVE TYPE QUESTIONS 1 MARK EACH | SHORT ANSWER TYPE QUESTIONS 2 MARKS EACH | TOTAL QUESTIONS |
| 1 | Communication Skills – II | 1 | 1 | 2 Q / 3 M |
| 2 | Self-Management Skills – II | 2 | 1 | 3 Q / 4 M |
| 3 | ICT Skills – II | 1 | 1 | 2 Q / 3 M |
| 4 | Entrepreneurial Skills – II | 1 | 1 | 2 Q / 3 M |
| 5 | Green Skills – II | 1 | 1 | 2 Q / 3 M |
| TOTAL QUESTIONS | 6 | 5 | 11 |
| NO. OF QUESTIONS TO BE ANSWERED | Any 4 | Any 3 | 07 |
| TOTAL MARKS | 1 x 4 = 4 | 2 x 3 = 6 | 10 MARKS |
PART B – SUBJECT-SPECIFIC SKILLS (40 MARKS):
| UNIT NO. | NAME OF THE UNIT | OBJECTIVE TYPE QUESTIONS 1 MARK EACH | SHORT ANSWER TYPE QUESTIONS 2 MARKS EACH | DESCRIPTIVE/ LONG ANS. TYPE QUESTIONS 4 MARKS EACH | TOTAL QUESTIONS |
| 1 | Digital Documentation (Advance) | 6 | 1 | 1 | 8 Q / 12 M |
| 2 | Electronic Spreadsheet (Advance) | 6 | 2 | 1 | 9 Q / 14 M |
| 3 | Database Management System | 6 | 1 | 2 | 9 Q / 16 M |
| 4 | Web Applications and Security | 6 | 2 | 1 | 9 Q / 14 M |
| TOTAL QUESTIONS | 24 | 6 | 5 | 35 |
| NO. OF QUESTIONS TO BE ANSWERED | 20 | Any 4 | Any 3 | 27 |
| TOTAL MARKS | 1 x 20 = 20 | 2 x 4 = 8 | 4 x 3 = 12 | 40 MARKS |
CBSE | DEPARTMENT OF SKILL EDUCATION
Information Technology (SUBJECT CODE – 402)
Sample Question Paper for Class X (Session 2023-2024)
| Max. Time: 2 Hours | Max. Marks: 50 |
General Instructions:
| Please read the instructions carefully. |
| This Question Paper consists of 21 questions in two sections: Section A & Section B. |
| Section A has Objective type questions whereas Section B contains Subjective type questions. |
| Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted (maximum) time of 2 hours. |
| All questions of a particular section must be attempted in the correct order. |
| SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS): i. This section has 05 questions. ii. Marks allotted are mentioned against each question/part. iii. There is no negative marking. iv. Do as per the instructions given. |
| SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS): i. This section has 16 questions. ii. A candidate has to do 10 questions. iii. Do as per the instructions given. iv. Marks allotted are mentioned against each question/part. |
SECTION A: OBJECTIVE TYPE QUESTIONS
| Q. 1 | Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) | 4 |
| i. | When it is difficult to communicate with someone who is not willing to talk or express their feelings and views it means there is a/an a. Culture Barrier b. Interpersonal Barrier c. Physical Barrier d. Language Barrier Ans: b. Interpersonal Barrier | 1 |
| ii. | Kartik’s Computer was running very slow, hangs and often restarts. He is very confused and tensed as he was working on a very important assignment. Kartik’s friend gave him the following suggestions. Identify who has given him a genuine suggestion. a. Radha : Restart your machine b. Ishan : Install reliable antivirus software and update c. Amar : Don’t use Pendrive d. Sam : Install free antivirus from net Ans: b. Ishan : Install reliable antivirus software and update | 1 |
| iii. | _____ refers to focusing human efforts for maintaining a healthy body and mind capable of better withstanding stressful situations. a. Self-Motivation b. Stress Management c. Self-Awareness d. Self-Regulation Ans: b. Stress Management | 1 |
| iv. | High expectations from self can leave with chronic anxiety and stress, thus leading to ______ stress. a. Physical b. Emotional c. Mental d. Financial Ans: c. Mental | 1 |
| v. | Which of the following is/are a myth about Entrepreneurship? a. Need a lot of money b. Must have a great Idea c. Should know everything about business d. All of these Ans: d. All of these | 1 |
| vi. | Name the organization that has the Sustainable Development Goals? a. UNICEF b. League of Nations c. United Nations d. World Health Organization Ans: c. United Nations | 1 |
| Q. 2 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | 5 |
| i. | Which one is not the tab of the insert/index Table window of Writer Document? a. Entries b. Background c. Style d. Row Ans: d. Row | 1 |
| ii. | In the custom styles, each ______ field on the Structure line represents a blank space in a document. a. Black b. White c. Blue d. Yellow Ans: a. Black | 1 |
| iii. | Saurabh has made an advertisement in Digital Document. He is facing difficulty in positioning the images within the text. Suggest him how he can adjust the image? a. Wrap text b. Crop c. Alignment d. Layout Ans: a. Wraptext | 1 |
| iv. | A ______ is a collection of records that store data in Mail merge. a. Data Source b. Main Document c. Document d. Merge Field Ans: a. Data Source | 1 |
| v. | To increases the contrast of an image, ______ option is used in a document. a. Smooth b. Sharpen c. Aging d. mosaic Ans: b. Sharpen | 1 |
| vi. | ______ provide Internet access by transmitting digital data over wires of a local telephone network. a) ISP b) DSL c) Dial-up connection d) Modem Ans: DSL | 1 |
| Q. 3 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | 5 |
| i. | _______ is specifically designed to minimize the results according to a set rules that we define in a spreadsheet. a. Goal Seek b. Scenario c. solver d. Subtotal Ans: b. Scenario | 1 |
| ii. | Sahil and his partners have created a list of their company employees in one of the spreadsheets in the office. Now the rest of the task they want to complete from home. Which option they should use to access the same Spreadsheet from home? a. Consolidate Worksheet b. Link Worksheet c. Merge Worksheet d. Lock Worksheet Ans: b. Link Worksheet | 1 |
| iii. | ______ can help to clarify the relation between cells while using “Multiple Operations”. a. Detective b. Solver c. Navigation d. Hyperlink Ans: c. Solver | 1 |
| iv. | Identify the part of a Spreadsheet using which a user can manage multiple sheets. a. Status Bar b. Sheet Tab c. Formula Bar d. Worksheet Area Ans: Sheet tab | 1 |
| v. | Spreadsheet software can find the changes by ______ sheets. a. Changing b. Comparing c. Renaming d. Editing Ans: b. Comparing | 1 |
| vi. | At the bottom of each worksheet, left tab indicates the _____ of the worksheet in a workbook. a. Size b. Type c. Name d. Color Ans: c. Name | 1 |
| Q. 4 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | 5 |
| i. | It enables users to view, enter, and change data directly in database objects. a. Report b. Query c. Form d. Database Ans: Form | 1 |
| ii. | There are ______ types of Relationships in a table of a database. a. One b. 3 c. 4 d. Many Ans: b. 3 | 1 |
| iii. | A Relational database uses ______ commands which is a standard user application that provides an easy programming interface for database interaction. a. Access b. Python c. SQL d. Protocol Ans: c. SQL | 1 |
| iv. | Suraj wants to create a database for his clients. For this purpose, she needs to store the Email IDs of his clients. Which datatype should he use to accomplish this purpose? a. Numeric b. Varchar c. Binary d. Boolean Ans: b. Varchar | 1 |
| v. | Geet has written a SQL query in SQL view. But he doesn’t know how to execute the query using keyboard keys. Suggest him the shortcut key to complete the task. a. Enter b. Ctrl + E c. Space bar d. F5 Ans: F5 | 1 |
| vi. | A table can have only ______ primary key in a database. a. 1 b. 2 c. 3 d. Many Ans: a. 1 | 1 |
| Q. 5 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | 5 |
| i. | ______ key is an accessibility feature that assists people having difficulty in using keyboard and mouse. a. Guide b. Sticky c. Serial d. Home Ans: c. Serial | 1 |
| ii. | Anaisha is a wildlife photographer. She wants to create her website where she can update the pictures and discuss about different events, reviews, announcements, news etc. Suggest her a suitable option to complete the task. a. Blog b. E-Mail c. Instant Messaging d. Mail Merge Ans: a. Blog | 1 |
| iii. | Which of the following is not a web browser? a. Safari b. Internet Explorer c. Google d. Firefox Ans: c. Google | 1 |
| iv. | Which out of the following is the best example of a strong password? a. 9412356789 b. 14Hd{]$_Sb10 c. HarryPotterSeries d. 14Oct2004 Ans: b. 14Hd{]$_Sb10 | 1 |
| v. | Bharat has set up his company with 20 computers in a building. He wants to connect all the computers together. Which type of Network will be the best suitable for this purpose? a. LAN b. WAN c. PAN d. MAN Ans: a. LAN | 1 |
| vi. | IP stands for _______. a. International Protocol b. Internet Protocol c. Intranet Protocol d. Interpersonal Protocol Ans: b. Internet Protocol (IP Protocol) | 1 |
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 are the learning objectives of communication? Ans: Learning objectives of Effective communication are: 1. Sending, receiving, and understanding the message or information 2. Development of Interposal Skills 3. To express effectively with maximum efficiency | 2 |
| Q. 7 | Why do we say that an entrepreneur should be open-minded? Ans: The smartest and most successful people welcome new ideas and diverse perspectives, allowing them to see more opportunities ahead of them and better solutions to problems. Open-minded entrepreneurs are able to strategize better because they can listen to varying and look at a problem through multiple lenses. | 2 |
| Q. 8 | How is self-regulation connected to the ability to work independently? Ans: The ability to work independently can be enhanced by being self-regulated. Self-regulation guides independent individuals as it help them to consider long term consequences rather than just transient feelings. It leads to a responsible and a value driven behavior. It teaches self-control and well-directed efforts to reach the goal. Self-regulated includes discipline that helps in consistent efforts to move towards the goal. | 2 |
| Q. 9 | How we can prevent computer against attack by viruses. Ans: We can prevent the computer against attack of viruses by installing proper antivirus, enabling the firewall, scan external devices before using on other computer, by avoiding emails that are suspicious or not known to us, should be very careful while downloading files or any programs from the internet etc. | 2 |
| Q. 10 | “Green economy promotes sustainable development”. Justify the statement. Ans: The focus of green growth strategies is ensuring that natural assets can deliver their full economic potential on a sustainable basis. That potential includes the provision of critical life support services – clean air and water, and the resilient biodiversity needed to support food production and human health. | 2 |
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
| Q. 11 | What do you understand by Anchoring in Word Processor? Ans: Anchoring refers to the reference point for the graphics. This point could be the page, or frame where the object is, paragraph, or even a character. An image always has an anchor point. | 2 |
| Q. 12 | What do you mean by Sorting in a Spreadsheet? Ans: Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example , you might want to arrange sales data by calendar month so that you can produce a graph of sales performance. | 2 |
| Q. 13 | State any four etiquettes to be followed while chatting on the internet. Ans: The etiquettes to be followed while chatting on the internet are : i. Message should be short and to the point. ii. Always introduce yourself by name if your screen name doesn’t reflect it. iii. Always ask if the other person has time to chat first, regardless of how important you think what you have to say is, it’s not going to be well received if the recipient is busy. | 2 |
| Q. 14 | How is Goal Seek different from Solver in a Spreadsheet? Ans: Goal seek determines what values need to be input in a cell to achieve the described result in a formula cell as it allows varying the value for one cell. Solver can solve equations that use several variables, so it can be used to determine what values need to be entered in multiple-input cells to achieve the described result. | 2 |
| Q. 15 | Differentiate between a Primary key and foreign key. Ans: A primary key is a unique value that identifies a row in a table, whereas a foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced table). A table can have only Primary Key but a table can have multiple foreign keys. | 2 |
| Q. 16 | What is the importance of healthy lifestyle? Give any four points related to it. Ans: A healthy lifestyle helps to keep and improve people’s health and well- being. A healthy lifestyle includes : i. Healthy eating habits. ii. Physical activities. iii. Stress management iv. Sound sleep | 2 |
Answer any 3 out of the given 5 questions in 50– 80 words each (4 x 3 = 12 marks)
| Q. 17 | What do you understand by the term Table of Contents? List the characteristics of a good ‘Table of content’ in a word processor. Ans: The table of contents is a snapshot of the headings and page numbers in your document and does not automatically updates itself as you make changes. It acts as a map for the users. A good table of content has the following characteristics: • It should be easy to read and simple to use. • It should be organised and formatted properly. • It must be accurate and easily accessible. • It should be given after the title and copyright page. | 4 |
| Q. 18 | Explain the term ‘Scenarios’ in relation to the Spreadsheets with examples. Ans: Scenarios are a tool to test “What-if” questions. Each scenario is names and can be edited and formatted separately . When you print the spreadsheet, only the content of the currently active scenario is printed. A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the navigator or a drop-down list which can be shown beside the changing cells. For example , if you wanted to calculate the effect of different interest rates on investment, you could add a scenario for each interest rate and quickly view the results. Formulas that rely on the values changed by your scenario are updated when the scenario is opened. If all your sources of income used scenarios, you could efficiently build a complex model of your possible income. | 4 |
| Q. 19 | Explain different kinds of online threats. Ans: There are different kinds of online threads: i. Phishing: Phishing attacks use fack communication, such as an email, to trick the receiver into opening it and carrying out the instructions inside, such as providing a credit card number. ii. Malware: Malware is malicious software such as spyware, ransomware, viruses, and worms. Malware is activated when a user clicks on a malicious link or attachment, which leads to installing harmful software. iii. Password Attacks: With the right password, a cyber attacker has access to a wealth of information. Social engineering is a type of password attack that data insider defines as “a strategy cyber attackers use that relies heavily on human interaction and often involves tricking people into breaking standard security practices.” iv. Email spoofing: It is the forgery of an email header so that the message appears to have originated from someone or somewhere other than the actual source. | 4 |
| Q. 20 | Explain the term “Referential Integrity”. Why is it important in a database? Ans: Referential Integrity is used to maintain the accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constrains. Referential Integrity is important in DBMS as: It prevents the entry of duplicate data.It prevents one table from pointing to a nonexistent field in another table.It prevents consistency between “Partnered” tables. It prevents the deletion of a record that contains a value referred to by a foreign key in another table.It prevents the addition of a record to a table that contains a foreign key unless key unless there is primary key in the linked table. | 4 |
| Q. 21 | Consider the following Vendor table and write the queries for the following: | 4 |
| i. Write a SQL command to display the records in ascending order by date of exam. ii. Write a query to display the above date sheet. iii. Write a query to display the subject name and date of the exam held on ‘Monday’. iv. Write a SQL command to display the date of exam and Sub_Name of Science subject. Ans: i. Select*from Datesheet order by DateofExam ii. Select*from Datesheet iii. Select Sub_Name, DateofExam from Datesheet where Days= ‘Monday’ iv. Select Sub_Name, Date of Exam from Datesheet where Sub_Name = ‘Science’ For visually impaired candidates. Write a short note on the following: i. DBMS ii. Database Server iii. Data Integrity iv. Record Ans: i) A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite. ii) Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Typically databases available on the database servers are accessed through command line or graphic user interface tools referred to as Frontends; database servers are referred to as Back-ends. Such type of data access is referred to as a client- server model. iii) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. iv) A record is a set of information (made up of fields) stored in your database about one of the items. |