Description

DATA ENTRY OPERATIONS (229)
TUTOR MARKED ASSIGNMENT

Note:
i. All questions are compulsory. The marks allotted for each question are given alongside the questions.
ii. Write your name, enrolment number, AI name and subject on the first page of the answer sheet.

1. Answer any one of the following questions in about 40-60 words.
A. Sangeeta and Rama, two friends, are working on the same project. Sangeeta, after doing her part of the project, sent the file to Rama through email. Rama has downloaded the project file but is unable to find it on the computer. How can she locate the file on her computer? [See Lesson 2]
B. Sangeeta accidentally deleted the project file from her computer. How can she retrieve it through operating system features? [See Lesson 2]

2. Answer any one of the following questions in about 40-60 words.
A. Mr. Rajat, an accountant, is creating an expense sheet. How will he enter and format data so that: [See Lesson 6]
 Currency symbols (₹) appear automatically in the “Amount” column.
 Values of the Date of expense column appear in DD Month YYYY format.
B. Simoni, a story writer, is supposed to work on multiple documents in Word Processing Software (WPS). How can she do work on multiple documents in WPS? [See Lesson 3]

3. Answer any one of the following questions in about 40-60 words.
A. Shreya has just installed a new software on her Personal Computer (PC) but she realised that it is causing issues. She needs to uninstall it. How can she do that? [See Lesson 2]
B. You have created a movie related to International Environment Day and saved it on your Desktop. Later, you decided to move it to a folder named “Movies” in Documents. How will you do this? [See Lesson 2]

4. Answer any one of the following questions in about 100-150 words.
A. Mr. Jacob, a scientist in a government organization, is making a project report of his recent confidential project in word processing software. He wants to protect his document from accidentally changing its format and text or from other users to get access to it. Help him by telling the steps of the same in detail. [See Lesson 3]
B. Rachna, a beginner in the IT field has just started learning about word processing software. Help her identify the components shown in the given screenshot. Also, mention the purpose of these components in brief. [See Lesson 3]

5. Answer any one of the following questions in about 100-150 words.
A. Mr. Rajat, a class teacher of X B, needs to prepare a consolidated result sheet of his whole class, in which he may need to apply various formulas/functions for calculations. He may also need to represent the data in the form of a variety of charts for better analysis. Suggest the name of the software on which he should start working. Also, mention the steps to start the suggested software/application. [See Lesson 6]
B. Supriya, a homemaker is preparing a month-wise annual budget of her household expenses. She has already done it for January, February, and March in separate sheets. Now she wants to add more sheets to make it for the remaining months. Help her by telling the steps of the same. Additionally, she may want to rename the sheets for better organization. How will she do this?

6. Prepare any one of the following projects in about 500 words:
A. Daniel, a sports analyst has just gathered some data related to the recently concluded Olympic games and stored it in a spreadsheet software for further analysis. Screenshot of the same is given here for the reference: [See Lesson 6]

Help him in answering the following questions:
i. Write the steps to add the footer “Olympics-2024” in the worksheet.
ii. Count and tell how many records and columns are shown in the spreadsheet.
iii. Mention the steps to take the printout of this sheet.

B. Ramanpreet, a class X student is making a project in word processing software. He wants to open the file in which he was previously working. Help him by telling him the steps of the same. Once the project report is completed, he needs to save it in PDF format. What steps should he follow? Also, mention the significance of the shortcut menu to him. [See Lesson 3]