cbse IT class 10 x sample question paper
SAMPLE PAPER - I
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
CLASS X (SESSION 2023-2024)
Max. Time: 2 Hours Max. Marks: 50
SECTION – A
Q. 1 | Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) | |
i.Which of the following is/are the symptoms of stress? i)Social Isolation ii. Fatigue iii. Heartburn iv. All of these | 1 | |
ii.Which of the following operating systems ensures that critical tasks are completed on time?
| 1 | |
iii.Which of the following is a myth about entrepreneurship?
| 1 | |
iv.To remove the files of temporary folder, we type in Run dialog box after pressing “Windows button + R” on the keyboard. a. #temp# b. %temp% c. e $temp% d. &temp& | 1 | |
v.Akshara comes back from school, takes her food, rests for some time and goes for her hobby classes. She finishes her homework and studies before going to bed. She does all her work by herself. No one tells her to do so. This is called ___________. a. Self-Awareness b. Self-Motivation c. Self-Regulation d. Discipline | ||
vi.Which of the following is an important role of an entrepreneur?
|
Q. 2 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
i.Which file format is commonly used for creating and sharing electronic documents while maintaining their formatting and layout? A. .TXT | 1 | |
ii.Which of the following is not an advantage of a DBMS?
| 1 | |
iii.Rajat is a computer programmer and he needs to create graphical representations of his program logic. Which shape category is most useful for him i.Basic shapes ii. Block arrows iii. Callouts iv. Flowcharts | 1 | |
iv.A consistent look to the document formatting can be given by the help of which of the following? i.Styles ii. Text alignment iii. Section breaks iv. Shapes | 1 | |
v.While editing a shared sheet, if tracking of changes is not on, then which of the following is useful to examine which changes have been done? i.Merge sheets ii. Review sheets iii. Compare sheets iv. Any of these | 1 | |
vi._______ can be set for a field if the user doesn’t provide any value while entering the values in the table. i.Required ii.Default iii.Primary key iv.Format | 1 |
Q. 3 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
i.Which of the following action changes the dimensions of an image inserted in a document?
| ||
a.>=500 b. <=500 c. !=500 d. > 500 | 1 | |
iii.Toggle key is designed for people who have __________
| 1 | |
iv.State whether True or False: “It is not possible to create a default template in a Word processor”. a. True b. False | 1 | |
v.To keep the hyperlinks intact while distributing documents to others,which of the following must be used?
| 1 | |
vi.Macros can be implemented by using which of the following keywords?
| 1 |
Q. 4 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
i.Identify the website that offers offline blog service for free. a. Blogdesk b. Qumana c. WordPress d. both a and b | 1 | |
ii.Table of content is based on which of the following?
| 1 | |
iii.This data type allows alphanumeric characters and special symbols. a. Text b. Memo c. Auto number d. None of these | 1 | |
iv.What comes naturally without efforts?
| 1 | |
V.“What should be the maximum performance of the class if all the students appear for the exam and all of them secure at least 65%?” -this cab be answered by which of the following tools?
| 1 | |
Vi.A refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
|
Q. 5 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
i.Using a database form which of he following actions can be performed?
| 1 | |
ii.VIRUS stands for
| 1 | |
iii.function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily. a .Data Combination c. Data Consolidation b. Data Merging d. Data Concatenation | 1 | |
Iv.store data in a single table which is suitable to store less amount of Data. a. Flat File b. Relational c. Mini File d. Single File | 1 | |
V.In a word processor, by default, evaluates levels of headings when it builds the table of contents. a. 3 c. 10 b. 7 d. 12 | 1 | |
Vi.Which of the following devices is a network connecting device? a. Printer b. Hub c. CPU d. USB | 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 .How self-motivation and self-regulation help you achieve your goals? Ans. Self-motivation enables us to take action on our ideas and thoughts. Our weaknesses control our self-motivation. To counter this, we need to be self-aware. Being self-aware in a proper way helps us convert our thoughts into actions. For this self-regulation and discipline is also necessary. By using all our strengths and abilities we overcome our weaknesses which brings in self-regulation and which, in-turn, helps us achieve our goal. | 2 | |
Q.7. Cite any failure which became a learning experience for you? Ans. Students should answer this themselves. | 2 | |
Q.8.What preventive measures should we take against computer viruses? Ans. To prevent computer virus, we need to practice basic internet discipline such as avoiding opening untrusted emails and websites, use spam filters, use strong passwords etc. To protect the computer, we should take regular data backups and install updated antivirus and updated genuine operating system. | 2 | |
Q.9. Is it a myth that every start-up should begin with a new product or service? Ans. Entrepreneurs do the things differently or innovatively. As an entrepreneur if you have a new product to offer, it is good but most start-ups have found innovative and creative ways in offering the same products and services. This is called disruption. Paytm, Uber, Ola etc. are disruptions. | 2 | |
Q.10.List some common challenges in sustainable development. Ans. Climate changes, energy usage, border conflicts, hunger and malnutrition, corruption, rapid urbanisation, lack of vision and policy. | 2 |
Answer any 4 out of the given 6 questions. (2 x 4 = 8 marks)
Answer each question in 20 – 30 words.
Q.11.How will you create a style from already formatted text? Ans. Assume that there is a heading already formatted as size 18, colour blue and arial font. To save this as a new style, click on the Styles and Formatting icon on the side bar > Styles actions button > New Style from Selection option > In Create Style dialog box, give a name to your new style and click OK. | 2 | |
Q.12.Discuss a scenario each where we can use subtotal feature and data consolidation feature of spreadsheets. Ans. Subtotal feature allows us to preform calculation on a group of data such as department-wise average salary or class-wise student count. In data consolidation, we bring together the data in different sheets or workbooks into one sheet along with calculations such as consolidating reports of 5 different regions or combining the marksheets of all the sections of a class into one. | 2 | |
Q.13.In what-if analysis tools, what advantage does scenario have over goal seek? Ans. Goal seek tool allows us to change only one input variable to achieve the desired output but scenario allows us to change multiple input values and see how the output values change. | 2 | |
Q.14.How do databases reduce or control data redundancy? Ans. Data redundancy means multiple copies of the same data. Databases store the data in a centralized location and all the users access the same data according to their requirements. This is achieved by data sharing feature of the database. Since there are no multiple copies of the data, there are no problems of delayed updates or outdated copies. | 2 | |
Q.15.How does first aid kit help in a workplace accident? Ans. First Aid Kit – as the name suggests, contains basic tools and medicines to provide immediate primary relief to the victim of an accident. Pain killers, bandages, disinfectant, wipes, thermometer, tape, etc. are some common contents of a FAK. | 2 | |
Q.16.Briefly, discuss the ergonomics related to computers? Ans. While working on the computer the first concern is the posture. It needs to be correct. Proper sitting, suitable chair and its height, elbows must rest parallel on the arms of the chair, positions of neck and shoulder should be relaxed, correct angle of wrists while using keyboard and mouse, suitable distance of eyes from the monitor, proper brightness of the monitor, right angle of knees and use of foot rest are some of the common ergonomic issues related to using a computer. | 2 |
Answer any 3 out of the given 5 questions. (4 x 3 = 12 marks)
Answer each question in 50 – 80 words.
Q.17. How will you add a new field and a new constraint in a table? Explain with an example. Ans. The syntax to add a field to a table is: Alter table “table name” add “new field” “type” before “existing field name” For example, alter table item add item_type varchar(50). The syntax to add a constraint on a field is: Alter table “table name” add [CONSTRAINT “constraint name”] constraint definition. For example, alter table item constraint “chk_qty” add check(qty > 0) | 4 | |
Q.18. Anuj has a worksheet in a particular format. A copy of same sheet is with his assistant. They both made certain changes in their copies. How will Anuj keep his changes as well as accommodate assistant’s changes also in his sheet? Write detailed steps. Ans. If there are multiple copies of same worksheet modified by multiple users then all of them need to be merged into the original sheet. In such a case, Anuj can compare his document and assistant’s document. To merge the worksheets, Anuj must first open his worksheet. Then, go to Edit menu > Track Changes > Merge Document option. In the Merge With dialog box, select the assistant’s file whose data needs to be merged and click on Open button. Manage Changes dialog box will appear. Accept/Reject changes as you need and click Close. The sheet will be merged. | 4 | |
Consider the following table: Student RollNo Name Class House 7001 Himanshu 8 Blue 7002 Rohit 7 Yellow
Q.19. 1. Display the details of class 9 students. Ans. Select * from student where Class=9 2. In which class does “Rohit” study? Ans. Select Class from Student where name= ‘Rohit’ 3. Insert the record: 7004, ‘Aman’,11, ‘Blue’ Ans. Insert into Student values (7004, ‘Aman’,11, ‘Blue’) 4. Display the Names and Roll Number of the students whose belong to Blue house. Ans. Select Name, RollNo from Student where House= ‘Blue’ | 4 | |
Q.20. Shubham is a student of class X. He recently changed his school so he is not aware of the people, but someone is posting negative, demeaning comments on his social media profile. He is also getting repeated mails from unknown people. Every time he goes online, he finds someone chasing him.
Ans. Cyber stalking
Ans. Computer ethics
Ans. The term used is piracy.
Ans. The act of fraudulently acquiring someone’s personal and private information, such as online account names, login information and password is called Phising | ||
Q.21.Why do we need solver when we have powerful tools such as goal seek and scenarios? Ans. Goal seek and scenarios work on ideal situations where we know the desired output and we need specific inputs but solver is used when we need a suitable set of input values to get an optimized output which also takes into consideration any constraints. For example, calculate my marks in each subject to achieve overall average percentage of 90%. Constraints are: i. The marks should be whole integers. ii. I should get at least 60% marks in each subject. iii. The marks should not exceed 100. |
Comments
Post a Comment