STD X SUBJECT: DOMESTIC DATA ENTRY OPERATOR (CODE 1100)

TOPIC – WISE DISTRIBUTION OF MARKS (THEORY)

Part A: Employability Skills (08 Marks)

Unit 1: Communication Skills 02 Marks
Unit 2: Self Management Skill 02 Marks
Unit 3: Basic ICT Skills 02 Marks
Unit 4: Entrepreneur Skill 01 Mark
Unit 5: Green Skill 01 Mark

Part B: Vocational Skills (22 Marks)

Unit 1: Digital Documentation 07 Marks
Unit 2: Electronic Spreadsheet 07 Marks
Unit 3: Database Management System 08 Marks

Total (30 Marks)

Blueprint of the Question Paper
Sr. MCQ, Very Short Long
No. T/F,
Topic Short answers answers Total
Match
answers
pairs, 2 marks
Terms 1 mark 3 marks
½
marks

1. Employability skills

Unit 1: Communication Skills 02 01 00 00 02

Unit 2: Self-Management Skills 00 00 02 00 02

Unit 3: Basic ICT Skills 02 01 00 00 02

Unit 4: Entrepreneur Skills 02 00 00 00 01

Unit 5: Green Skills 02 00 00 00 01

8X½ 2X1= 02 01x2=02 00 08

= 04

2. Vocational Skills

Unit 1: Digital Documentation 02 02 02 00 07

Unit 2 : Electronic Spreadsheet 04 03 01 00 07

Unit 3: Database Management 04 02 02 00 08

System

10X ½ 07X1= 07 5x2=10 00 22

= 05
Time : 1½ Hours Subject : DOMESTIC DATA ENTRY OPERATOR
STD X Subject Code - 1100

Total No. of Questions : 33 (Printed Pages: 04) Maximum Marks :30

INSTRUCTIONS:
(i) All questions are compulsory.
(ii) Figures to the right indicate full marks.
(iii) Write the question numbers clearly
Select the most appropriate alternative given below each statement and rewrite
the complete sentence:
1. The most common barrier to effective communication is _____________. ½

• Clear language
• Listening skill
• Feedback
• Noise

2. The abbreviation ICT stands for_____________. ½

• International Computer Technology
• Internet and Cable Technology
• Information and Communication Technology
• Information and Coding Technique

3. To be a good entrepreneur one must possess quality like_____________. ½

• Impatient
• hardworking
• negativity
• laziness

4. Sustainable development means _____________. ½

• Fast industrial growth

• Economic growth only
• Ignoring environmental protection
• Development that meets present needs without harming future
generations
P.T.O

S -1100 1
Answer the following in one sentence each:
5. Why is communication important ? 1
6. How can you increase the performance of a computer? 1

Answer the following in two sentences each:

7. Explain any two basic Self-Management Skills to be successful in life. 2

State whether the following statements are true or false:

8. Maintaining eye contact is a positive facial expression. ½
9. Solar energy is an example of a source of non-renewable energy. ½
Give a single term for the following:

10. The input device used to feed the data into the computer. ½
11. A businessman who does his/her business innovatively. ½

Answer the following in one sentence each:

12. How is subtotal tool used in LibreOffice Calc? 1

13. What is a record in a table? 1

Answer the following in two sentences each:

14. Differentiate between : Data and Information (two points) 2
15. Explain Resize and Crop with respect to an image in a Document (two points) 2

Select the most appropriate alternative given below each statement and rewrite
the complete sentence:

16. The Style Template in Libre Office Writer is _________________________ ½

 A kind of model style
 A Predetermined form and mode of document file
 A type of document
 A Cluster of documents

17. Table in a database is formed with _________________________ ½

 A graphic
 A set of slides
 A collection of rows and columns
 A formula

S -1100 2
18. The COUNT() function is used to _________________________ ½
 Add numbers
 Find the average
 Count numeric values in a range
 Count the number of characters in a range.

19. The _________________________ is NOT a type of text data type. ½

 Varchar
 Memo
 Float
 Char

Answer the following in one sentence each:

20. Name the page orientations in LibreOffice Writer? 1
21. State one advantage of using consolidated data in LibreOffice Calc. 1

Answer the following questions:

22. Read the following paragraph carefully and answer the questions given below:
Riya is working on a project report in LibreOffice Writer. She wants to ensure that
the document looks professional and is easy to navigate. Explain how each feature
would help Riya to enhance the formatting and organizing of her report with
reference to the following questions.

a) Use of Table of Contents for easy navigation. 1

b) Use of Headers and Footers to include page numbers and document title. 1

23. How is redundancy or inconsistency controlled in a database. Explain with an

example. 2

Match the following items in Column A with the correct items in Column B and
write the correct pair: 1
ColumnA ColumnB
24 Reference to Cell B3 of sheet Class X (a) . odb
25 Extension of a LibreOffice Base (b) $Class X.’B3’
(c) .obd
(d) $’Class X’.B3

S -1100 3
Compare the Co-ordination in first pair and complete the second pair:
26. Key that uniquely identifies a row in a table → Primary Key

Key that builds a relation between two tables → ....................... ½

27. Ctrl + C → Copy

Ctrl + V → ....................... ½

Select the most appropriate alternative given below each statement and rewrite the
complete sentence:
28. While entering records in a table, we can move to the next field by pressing the _________
key. ½
 Tab
 Ctrl
 Shift
 Enter
29. Details of your document like Page No, No of Pages are displayed on the ___________ ½
 Standard toolbar
 Status bar
 Title bar
 Formatting toolbar

Answer the following in one sentence each:

30. State the use of Goal Seek in LibreOffice Calc. 1
31. What is a Candidate key in database? 1
32. Name any two image filters in LibreOffice Writer. 1

Answer the following in two sentences each:

33. Give two advantages of Data Analysis tools ina Libre Office Calc. 2

------------------------------------- xxxxxxxxxxxxxx -------------------------------------------

S -1100 4
 Subject :DOMESTIC DATA ENTRY OPERATOR
STD X Subject Code - 1100
MODEL ANSWER KEY

1. Noise.
2. Information and Communication Technology.
3. Hardworking.
4. Development that meets present needs without harming future generations.

5. Communication is important because it helps in sharing ideas, thoughts and

information effectively.
6. The performance of a computer can be increased by removing extra files by using
disk cleaner software.
7. The two basic skills are:-
 Time Management – helps in completing tasks on time.
 Self-motivation – encourages us to work hard towards our goals.

8. True
9. False
10. Keyboard / Mouse / Scanner (any one input device)
11. Entrepreneur
12. The Subtotal tool in LibreOffice Calc is used to calculate the total, average, or count
for grouped data.
13. A record in a table is a collection of related data items stored in one row.
14. Data:
1. Raw facts and figures (e.g., 50, 60, 70)
2. Can be numbers, words, images or sound.
Information:
1. Processed data with meaning (e.g., Average marks = 60)
2. Helps in decision making, understanding or insight.

15. Resize:
1. Changes the overall size of the image.
2. Maintain the original image content but may affect resolution or quality.
Crop:
1. Removes unwanted outer parts of the image.
2. Does alter the resolution or quality

16. A kind of model style.

17. A collection of rows and columns.
18. Count the numeric values in a range.
19. Float
S -1100 1
 20. The page orientations in LibreOffice Writer are Portrait and Landscape.
21. Advantages of using Consolidated Data (any one)
1. Helps to combine data from multiple ranges into one summary sheet.
2. Saves Time and Effort- No need to add or copy data from different sheets
manually; Calc automatically merges and summarizes it.
3. Accurate Calculations- Reduces the risk of errors that often occur with manual
summation or copying.
3. Summarizes Data Easily- You can quickly generate totals, averages, counts, etc.
from multiple ranges.
4. Handles Data from Different Sheets/Files- Useful when information is spread
across different sheets in one file (e.g., monthly sales reports).

22. Paragraph
a) Table of Contents –
 Helps in quick navigation to different sections.
 organise information
b) Headers and Footers –
 Add page numbers, date and document title for a professional look.
23. Redundancy and inconsistency are controlled in a database by using
Normalization.
Example: Instead of repeating student details in every subject table, one student
table is created and linked using a unique ID.

24. $’Class X’.B3

25. .odb

26. Foreign Key

27. Paste

28. Tab key

29. Status bar

30. Goal Seek in LibreOffice Calc is used to find the required input value to achieve a
desired output.
31. A Candidate Key is an attribute that can uniquely identify each record in a table.
32. Two image filters in LibreOffice Writer are Invert, Grayscale and Aging. (Any 2)

33. Advantages of Data Analysis tools in LibreOffice Calc:

1. They help to summarize and analyze large amounts of data quickly.
2. They make decision-making easier with clear reports and comparisons.

S -1100 2