Class 10 IT (402) Preboard Sample Paper - I

Preboard Sample Question Paper

Subject: Information Technology (402) | Class: X
Max Marks: 50 | Time: 2 Hours

SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)

Q1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

1. Which of the following is NOT a barrier to effective communication? a) Linguistic b) Interpersonal c) Physical d) Subjective

Correct Answer: c) Physical barrier (Wait, standard answer key typically cites 'Subjective' or 'Linguistic' as barriers. If the question implies 'Physical' IS a barrier, the 'NOT' usually refers to a facilitator. However, based on standard IT 402 texts: d) Subjective barrier is often cited as a category, but sometimes options are tricky.
Correction based on CBSE text: Linguistic, Interpersonal, Physical, Organizational are barriers. Subjective is often synonymous with Psychological/Interpersonal.
Best Exam Answer: d) Subjective barrier (or check specific textbook context, usually 'Subjective' isn't a primary category name).

2. Which stress management technique involves visualizing a peaceful setting? a) Physical Exercise b) Guided Imagery c) Deep Breathing d) Yoga

Correct Answer: b) Guided Imagery

3. Which key combination is used to minimize all open windows in Windows OS? a) Win + D b) Win + M c) Alt + F4 d) Ctrl + M

Correct Answer: b) Win + M (Win + D toggles desktop, Win + M specifically minimizes)

4. Ravi is willing to take calculated risks to grow his business. Which quality does he exhibit? a) Confidence b) Risk-taking c) Hard working d) Leadership

Correct Answer: b) Risk-taking

5. Which of the following is a non-renewable energy resource? a) Solar Energy b) Wind Energy c) Coal d) Tidal Energy

Correct Answer: c) Coal

6. Self-motivation implies: a) Fear b) Reward c) Inner drive d) Please others

Correct Answer: c) Doing work due to inner drive

Q2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. Which feature in Writer is used to create a series of documents with same content but different addresses? a) Consolidate b) Mail Merge c) Scenarios d) Goal Seek

Correct Answer: b) Mail Merge

2. In Calc, which function calculates the total of a range of cells? a) =ADD() b) =TOTAL() c) =SUM() d) =CALC()

Correct Answer: c) =SUM()

3. A ________ is a set of data elements (values) using a model of vertical columns and horizontal rows. a) Database b) Table c) Form d) Report

Correct Answer: b) Table

4. Which accessibility feature helps people who have difficulty pressing multiple keys at once? a) Toggle Keys b) Sticky Keys c) Filter Keys d) Mouse Keys

Correct Answer: b) Sticky Keys

5. What is the default extension of a LibreOffice Writer document? a) .docx b) .odp c) .odt d) .ods

Correct Answer: c) .odt

6. The first page of a website is called ________. a) Web page b) Home page c) Main page d) Front page

Correct Answer: b) Home page

Q3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. Which option is used to apply a specific style to a selected text in Writer? a) Fill Format b) Style Manager c) Styles and Formatting window d) All above

Correct Answer: a) Fill Format Mode (or c, depending on context, but Fill Format applies it quickly. Usually 'd' if asking method availability). Best Answer: c) Styles and Formatting window (where the list exists).

2. Which tool in Calc allows you to test "what-if" questions? a) Solver b) Scenarios c) Goal Seek d) Macros

Correct Answer: b) Scenarios

3. A primary key must be ________ and cannot contain ________ values. a) Unique, NULL b) Duplicate, NULL c) Unique, Zero d) Duplicate, Text

Correct Answer: a) Unique, NULL

4. Which network topology requires a central controller or hub? a) Star b) Bus c) Ring d) Mesh

Correct Answer: a) Star

5. IM services fall into two categories: ________ based and ________ based. a) Application, Web b) Text, Video c) Mobile, PC d) Offline, Online

Correct Answer: a) Application, Web

6. Which is NOT a valid data type in OpenOffice Base? a) VARCHAR b) BOOLEAN c) DATE d) MEMO

Correct Answer: d) MEMO (Base uses LONGVARCHAR)

Q4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. To group drawing objects in Writer: a) Format > Group > Group b) Insert > Group c) Tools > Group d) Edit > Group

Correct Answer: a) Format > Group > Group

2. Which feature is used to view just the rows of a table that meet certain criteria? a) Sorting b) Filtering c) Scenarios d) Goal Seek

Correct Answer: b) Filtering

3. SQL stands for: a) Structured Question Language b) Simple Query Language c) Structured Query Language d) Standard Query Language

Correct Answer: c) Structured Query Language

4. An online blog is an example of: a) B2B application b) Web application c) Desktop application d) System software

Correct Answer: b) Web application

5. Which tag is used to insert an image in an HTML document? a) <picture> b) <img> c) <image> d) <src>

Correct Answer: b) <img>

6. Unplanned events that may cause harm or damage are called: a) Hazards b) Accidents c) Safety d) Risks

Correct Answer: b) Accidents

Q5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. In Writer, the table of contents is created automatically from: a) Bookmarks b) Hyperlinks c) Headings d) Index marks

Correct Answer: c) Headings

2. ________ are saved sequences of commands or keystrokes stored for later use. a) Functions b) Macros c) Templates d) Solvers

Correct Answer: b) Macros

3. In a database, a single row of a table containing a complete set of information is a: a) Field b) Record c) Attribute d) Value

Correct Answer: b) Record

4. Which device connects two dissimilar networks? a) Switch b) Hub c) Gateway d) Repeater

Correct Answer: c) Gateway

5. A strong password should contain: a) Only letters b) Only numbers c) Mix of uppercase, lowercase, numbers, symbols d) Name and birthdate

Correct Answer: c) A mix of uppercase, lowercase, numbers, and symbols

6. Evacuation is the process of: a) Starting fire b) Emptying place in emergency c) Cleaning d) Hiring

Correct Answer: b) Emptying a place in an emergency

SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)

Answer any 3 out of 5 Employability Skills questions (2 marks each)

Q6. Define "Sustainable Development". Why is it important?

Answer: Sustainable development is development that meets the needs of the present without compromising the ability of future generations to meet their own needs. It is important to ensure that resources are available for the future and the environment is protected.

Q7. List any four qualities of a self-motivated person.

Answer: 1. Focused 2. Dedicated 3. Optimistic/Positive 4. Knows what they want (Goals).

Q8. Explain the difference between "Interests" and "Abilities".

Answer: Interests are things you enjoy doing (e.g., listening to music). Abilities are things you are good at doing (e.g., playing the guitar). You may be interested in something but not have the ability for it, and vice versa.

Q9. What are the "7 Cs" of effective communication? List any four.

Answer: Clear, Concise, Concrete, Correct, Coherent, Complete, Courteous.

Q10. Mention two misconceptions (myths) about entrepreneurship.

Answer: 1. Entrepreneurs are born, not made. 2. Entrepreneurs take wild/unmanaged risks (in reality, they take calculated risks). 3. You need a lot of money to start a business.

Answer any 4 out of 6 Subject Specific Skills questions (2 marks each)

Q11. Differentiate between "Keep Scale" and "Keep Image Size" options while cropping.

Answer:

• Keep Scale: When you crop, the image size changes, but the scale (zoom level) of the picture inside remains the same.
• Keep Image Size: When you crop, the image size remains locked, so the picture inside scales up (zooms in) or distorts to fill the original area.

Q12. What is the use of "Solver" in spreadsheets? How is it different from Goal Seek?

Answer: Solver is used to find an optimal value for a formula in one cell (target) by changing multiple other cells, subject to constraints. Goal Seek can only change one input variable to reach a specific target, whereas Solver can handle multiple variables and constraints.

Q13. Define "Referential Integrity". Why is it important?

Answer: Referential Integrity is a rule that ensures relationships between tables remain consistent. It prevents users from deleting a record in a parent table if a related record exists in a child table (e.g., deleting a Student who still has Grades assigned).

Q14. Explain "Toggle Keys" and "Sound Sentry".

Answer:

• Toggle Keys: Provides a sound cue when locking keys (Caps Lock, Num Lock, Scroll Lock) are pressed.
• Sound Sentry: Generates visual warnings (like blinking the screen) when the computer makes a sound, aiding hearing-impaired users.

Q15. What is a Blog? Differentiate online vs offline blog editors.

Answer: A blog is an informational website consisting of posts.
Online Editors (e.g., WordPress.com) require an active internet connection to write and post.
Offline Editors (e.g., Qumana, Windows Live Writer) allow you to write posts without internet and publish them later when connected.

Q16. List any four best practices for Internet Security.

Answer: 1. Use strong passwords. 2. Keep software/antivirus updated. 3. Do not click on suspicious links (Phishing). 4. Use firewalls. 5. Backup data regularly.

Answer any 3 out of 5 Subject Specific questions (4 marks each)

Q17. (Competency) Rahul's Table of Contents (TOC) problem...

Answer:
a) He must apply Heading Styles (Heading 1, Heading 2) to the chapter names.
b) Insert > Table of Contents and Index > Table of Contents, Index or Bibliography.
c) Right-click on the TOC and select Update Index/Table.
d) Yes.

Q18. (Competency) Anjali's Sales Data Consolidation...

Answer:
a) Data Consolidation.
b) Data > Consolidate > Select Function (Sum) > Add ranges from Jan, Feb, Mar sheets > Click OK.
c) Yes, by checking the "Link to source data" option.
d) The labels (row/column headers) must be identical/consistent in all sheets.

Q19. SQL Queries for table STUDENT...

Answer:
a) CREATE TABLE STUDENT (AdmNo INTEGER PRIMARY KEY, Name VARCHAR(50), Class INTEGER, Section VARCHAR(5), DOB DATE);
b) SELECT * FROM STUDENT WHERE Class = 10;
c) SELECT * FROM STUDENT ORDER BY Name ASC;
d) DELETE FROM STUDENT WHERE AdmNo = 1201;

Q20. Explain different types of database relationships with examples.

Answer:
1. One-to-One: One record in Table A relates to only one in Table B. (Ex: Person and Passport ID).
2. One-to-Many: One record in Table A relates to many in Table B. (Ex: One Class has Many Students).
3. Many-to-Many: Many records in Table A relate to many in Table B. (Ex: Students and Courses - a student takes many courses, a course has many students).

Q21. Safety Officer Scenario (Accidents, Fire, etc.)...

Answer:
a) Slips/Trips/Falls, Electrical shocks.
b) Do not overload sockets; Replace frayed cords immediately.
c) PASS: Pull the pin, Aim at the base of fire, Squeeze the handle, Sweep side to side.
d) To ensure employees know the escape routes and can exit safely without panic.