Sample Question Paper, Exercises of Information Technology

Download Sample Question Paper and more Exercises Information Technology in PDF only on Docsity! 402 – Information Technology – Class X Page 1 of 6 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 SHORT ANSWER TYPE QUESTIONS TOTAL QUESTIONS 1 MARK EACH 2 MARKS EACH 1 Communication Skills - II 1 1 2 2 Self-Management Skills - II 2 1 3 3 ICT Skills - II 1 1 2 4 Entrepreneurial Skills - II 1 1 2 5 Green Skills - II 1 1 2 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 SHORT ANSWER TYPE QUESTIONS DESCRIPTIVE/ LONG ANS. TYPE QUESTIONS TOTAL QUESTIONS 1 MARK EACH 2 MARKS EACH 4 MARKS EACH 1 Digital Documentation (Advance) 6 1 1 8 2 Electronic Spreadsheet (Advance) 6 2 1 9 3 Database Management System 6 1 2 9 4 Web Applications and Security 6 2 1 9 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 402 – Information Technology – Class X Page 2 of 6 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: 1. Please read the instructions carefully. 2. This Question Paper consists of 21 questions in two sections: Section A & Section B. 3. Section A has Objective type questions whereas Section B contains Subjective type questions. 4. 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. 5. All questions of a particular section must be attempted in the correct order. 6. 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. 7. 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. 402 – Information Technology – Class X Page 5 of 6 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 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 1 vi. A table can have only _________ primary key in a database. a. 1 b. 2 c. 3 d. Many 1 Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) i. __________ key is an accessibility feature that assists people having difficulty in using keyboard and mouse. a. Guide b. Sticky c. Serial d. Home 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 1 iii. Which of the following is not a web browser? a. Safari b. Internet Explorer c. Google d. Firefox 1 iv. Which out of the following is the best example of a strong password? a. 9412356789 b. 14Hd{]$_Sb10 c. HarryPotterSeries d. 14Oct2004 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 1 vi. IP stands for _______________ . a. International Protocol b. Internet Protocol c. Intranet Protocol d. Interpersonal 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? – 2 Q. 7 Why do we say that an entrepreneur should be open-minded? 2 Q. 8 How is self-regulation connected to the ability to work independently? 2 402 – Information Technology – Class X Page 6 of 6 Q. 9 How we can prevent computer against attack by viruses. 2 Q. 10 “Green economy promotes sustainable development”. Justify the statement. 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? 2 Q. 12 What do you mean by Sorting in a Spreadsheet? 2 Q. 13 State any four etiquettes to be followed while chatting on the internet. 2 Q. 14 How is Goal Seek different from Solver in a Spreadsheet? 2 Q. 15 Differentiate between a Primary key and Foreign key. 2 Q. 16 What is the importance of healthy lifestyle? Give any four points related to it. 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. 4 Q. 18 Explain the term ‘Scenarios’ in relation to the Spreadsheets with example. 4 Q. 19 Explain different kinds of online threats. 4 Q. 20 Explain the term “Referential Integrity”. Why is it important in a database? 4 Q. 21 Consider the following Vendor table and write the queries for the following: Table Datesheet Sub_code Sub_Name DateofExam Days E001 English 11-03-2021 Monday H002 Hindi 15-03-2021 Friday S003 Social Sci. 18-03-2021 Monday S004 Science 21-03-2021 Thursday 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. For visually impaired candidates. Write a short note on the following: i) DBMS ii) Database Server iii)Data Integrity iv)Record 4