Class 10 Data Entry Operations (229) Solved Free Assignment 2024-25 (NIOS)

 

1. Answer any one of the following questions in about 40-60 words.  

i. Ekta has created a document and she wants to protect that document from unauthorized access. Write down the steps to protect the document. (See Lesson 3)

Ans:-   To protect a document from unauthorized access, Ekta can set a password in her word processing software. Here are the steps:

1. Open the document.

2. Go to the **File** menu and select **Info**.

3. Click on **Protect Document** or **Encrypt with Password**.

4. Enter a password and confirm it.

5. Save the document to apply the password protection.

Now, only users with the password can access the document.

ii. Anil has deleted a file accidently and he wants to restore that deleted file. Write down the steps to restore the deleted file. (See Lesson 2)

Ans:-  To restore a deleted file, Anil can follow these steps:

1. Open the **Recycle Bin** on his desktop.

2. Find and select the file he wants to restore.

3. Right-click on the file and choose **Restore**.

The file will be restored to its original location, making it accessible again.

2. Answer any one of the following questions in about 40-60 words

i. Pravesh has written an application and saved it as a document with the file name “Pravesh”. He wants to do some changes in it. Write down the steps to open the existing document. (See Lesson 3)

Ans:-  To open his existing document and make changes, Pravesh can follow these steps:

1. Open the word processing application.

2. Go to the **File** menu and select **Open**.

3. Browse to locate the document named **"Pravesh"**.

4. Select the file and click **Open**.

The document will open, allowing him to make the necessary changes.

ii. Aisha is a class teacher and she wants to create a spreadsheet to store the details of the class. Write the names (only) of the various data types she should use in order to store the details like name, age, mobile no., email etc. (See Lesson 6) 

Ans:-  Aisha should use the following data types to store class details:

- Text (for name and email)

- Number (for age and mobile number)

3. Answer any one of the following questions in about 40-60 words.

i. Write the shortcut keys of the following. (See Lesson 3).

a) Cut 

b) Left alignment 

c) Print Preview 

d) Help 

Ans:-  Here are the shortcut keys for the following actions:

a) **Cut** – Ctrl + X  

b) **Left Alignment** – Ctrl + L  

c) **Print Preview** – Ctrl + F2  

d) **Help** – F1

ii. Rahul is working on a worksheet in a workbook. He wants to create a new worksheet in the existing workbook. List the steps to insert the new worksheet in the existing workbook. (See Lesson 6)

Ans:-  To insert a new worksheet in an existing workbook, Rahul can follow these steps:

1. Open the workbook where he wants to add a new worksheet.

2. Click on the **Insert Worksheet** tab (usually represented by a "+" or next to the existing sheets).

3. Alternatively, he can right-click on an existing worksheet tab and select **Insert** > **Worksheet**.

A new worksheet will be added to the workbook.

4. Answer any one of the following questions in about 100-150 words.

i. Sunita is working on a large worksheet with the first row as columns headings. Those headings will disappear as the worksheet is scrolled down. Write the steps through which she can fix the first row so that the headings do not disappear even after scrolling down? (See Lesson 6)

Ans:-  To keep the first row visible while scrolling through a large worksheet, Sunita can use the "Freeze Panes" feature. Here are the steps:

1. Open the worksheet where she wants to freeze the top row.

2. Click on the **View** tab on the ribbon at the top.

3. Select **Freeze Panes** from the options in the View tab.

4. From the dropdown, choose **Freeze Top Row**.

By selecting "Freeze Top Row," the first row will remain visible even when she scrolls down through the worksheet. This way, Sunita can always see her column headings, making it easier to work with large datasets without losing track of the header information.

ii. Raju wants to open a word program using the Start button. Write down the steps. Also write two main features of word processing. (See Lesson 3)

Ans:-  To open a word processing program using the Start button, Raju can follow these steps:

1. Click on the **Start** button at the bottom-left corner of the screen.

2. Type "Word" in the search bar or find **Microsoft Word** (or the name of his word processing software) in the list of applications.

3. Click on the **Word** icon to open the program.

Two main features of word processing are:

1. **Text Formatting**: Allows users to change font style, size, color, and alignment, making the document visually appealing and easy to read.

2. **Spell Check and Grammar Check**: Automatically identifies spelling and grammatical errors, helping users create error-free documents quickly and efficiently.

5. Answer any one of the following questions in about 100-150 words.

i. Ramesh has purchased the software of his favourite game. He wants to install the software in his computer. Help him to install the software and state the steps to do so. (See Lesson 2)

Ans:-  To help Ramesh install his new game software on his computer, he can follow these steps:

1. **Insert the Installation Media**: If the game software came on a CD, DVD, or USB drive, insert it into the computer. If he downloaded the game, locate the downloaded setup file (often in the "Downloads" folder).

2. **Locate the Setup File**: Open the installation media or folder and find the setup file, typically named "setup.exe" or "install.exe" for Windows.

3. **Run the Setup File**: Double-click the setup file to start the installation process. He may need to confirm any security prompts to allow the installation.

4. **Follow On-Screen Instructions**: The installer will guide him through a series of steps. He should read each step carefully, select the installation location if prompted, and agree to any license terms.

5. **Complete Installation**: Click "Install" or "Finish" when prompted, and wait for the installation to complete.

6. **Launch the Game**: Once installed, Ramesh can launch his game from the Start menu or desktop icon.

Following these steps, Ramesh can enjoy playing his favorite game on his computer!

ii. Aftab has created a document using some selected page size. He wants to print that document in a different page size or multiple pages in a single sheet of paper without disturbing the general format. Help him to print the pages in different page size by listing down the steps he should follow. (See Lesson 3)

Ans:-  To help Aftab print his document in a different page size or multiple pages on a single sheet of paper without disturbing the general format, he can follow these steps:

1. **Open the Document**: Launch the word processing program and open the document Aftab wants to print.

2. **Go to Page Layout**: Click on the **Layout** or **Page Layout** tab in the ribbon at the top of the window.

3. **Set Page Size**: 

   - Click on **Size** in the Page Setup group.

   - Choose the desired page size from the dropdown menu, or select **More Paper Sizes** to create a custom size.

4. **Print Options**: Click on the **File** tab and select **Print**.

5. **Select Multiple Pages per Sheet**:

   - In the Print settings, look for the option labeled **Multiple Pages per Sheet** (this may vary by program, but it’s often found under **Settings** or **Print One Sided**).

   - Choose how many pages to print per sheet (e.g., 2, 4, etc.).

6. **Check Print Preview**: Review the print preview to ensure that the document format appears correct and that the pages are arranged as desired.

7. **Print the Document**: Finally, click the **Print** button to print the document.

By following these steps, Aftab can successfully print his document in a different page size or multiple pages on a single sheet while maintaining the original format.

6. Prepare any one of the following projects in about 500 words.

i. A class teacher keeps a spreadsheet for student’s data on his/her laptop showing the basic details and the marks of students. Below mentioned is the table showing a part of the spreadsheet: (See Lesson 6).

a). Create and save the above file as “Class 10 Record”.

b). Add a new column “Social Science” in the spreadsheet.

c). Give the cell reference of the cell that contains the value “Sunil”.

 

d). Rename the column “Maths” as “Mathematics.

e). Count the total number of columns in the spreadsheet.

f). Write the steps to delete this spreadsheet.

Ans:-    Project: Managing Student Data in a Spreadsheet

 Introduction

In today’s educational environment, maintaining student records efficiently is essential for teachers. This project outlines the steps to create and manage a spreadsheet that contains basic details and academic performance of students in a class. The following sections detail how to create a student data spreadsheet, add new information, modify existing entries, and manage the file.

 Part 1: Creating the Spreadsheet

1. **Open a Spreadsheet Program**: Launch a spreadsheet application such as Microsoft Excel, Google Sheets, or any other equivalent software.

2. **Input Data**: Create a new spreadsheet and input the following data based on the provided table:

3. **Save the File**: Save the file as “Class 10 Record” in a designated folder on your laptop.

 Part 2: Modifying the Spreadsheet

 a) Adding a New Column

1. **Insert Column**: To add a new column for “Social Science,” right-click on the header of the column immediately to the right of “Science” (column H) and select **Insert** from the context menu. This will create a new blank column.

   

2. **Name the Column**: Click on the new header cell (I1) and type “Social Science.”

b) Cell Reference for "Sunil"

The cell reference for “Sunil” is **B5**. This means that the name “Sunil” is located in column B and row 5 of the spreadsheet.

c) Renaming the "Maths" Column

1. **Select the Header**: Click on cell G1 where “Maths” is located.

2. **Edit the Name**: Type “Mathematics” to rename the column. Press **Enter** to confirm the change.

Part 3: Counting Columns

To count the total number of columns in the spreadsheet:

1. **Identify Columns**: Count the number of columns from A to I, which are: 

   - Roll No.

   - Student Name

   - Class

   - Gender

   - Hindi

   - English

   - Mathematics

   - Science

   - Social Science

2. **Total Count**: The total number of columns is **9**.

Part 4: Deleting the Spreadsheet

If Ramesh or any other teacher needs to delete this spreadsheet, they can follow these steps:

1. **Close the Spreadsheet**: Ensure the spreadsheet is not open; if it is, save any changes and close the file.

2. **Navigate to the File Location**: Open the file explorer (Windows) or Finder (Mac) and go to the folder where the spreadsheet is saved.

3. **Select the File**: Find “Class 10 Record” in the folder. Click on it to select it.

4. **Delete the File**: Right-click on the file and select **Delete** from the context menu. Alternatively, select the file and press the **Delete** key on the keyboard.

5. **Confirm Deletion**: If prompted, confirm that you want to permanently delete the file.

ii. James has been asked by his teacher to demonstrate to the class the functioning of a word processor. Help him in performing the following actions: (See Lesson 3)

a. Create a new document from the menu bar (using the prescribed short cut key). Also write the steps.

b. Save the created document with the name “My document” and then close it. Also write the steps.

c. Open the already created “My document” and rename it as “My renamed document”. Also write the steps.

Ans:-  Project: Demonstrating the Functioning of a Word Processor

Introduction

In this project, James will demonstrate the basic functionalities of a word processor, including creating, saving, opening, and renaming documents. Word processors are essential tools in today's digital world, allowing users to create, edit, and manage text documents efficiently. Below are the detailed steps for each action James needs to perform.

 Part 1: Creating a New Document

**Action**: Create a new document from the menu bar using the shortcut key.

**Steps**:

1. **Open the Word Processor**: Launch the word processing application (e.g., Microsoft Word).

2. **Use the Shortcut Key**: Press **Ctrl + N** on the keyboard. This shortcut quickly creates a new document.

3. **Verify the New Document**: A blank document will open, ready for typing. The title will usually be “Document1” or similar.

Part 2: Saving the Document

**Action**: Save the created document with the name “My document” and then close it.

**Steps**:

1. **Save the Document**: Click on the **File** menu in the menu bar.

2. **Select Save As**: Choose **Save As** from the dropdown list to specify a new file name.

3. **Enter the File Name**: In the dialog box that appears, type “My document” in the file name field.

4. **Choose the Save Location**: Select the folder where he wants to save the document (e.g., Documents folder).

5. **Click Save**: Click the **Save** button to save the document.

6. **Close the Document**: Go back to the **File** menu and select **Close**, or simply click the **X** in the upper right corner of the window.

Part 3: Opening and Renaming the Document

**Action**: Open the already created “My document” and rename it as “My renamed document.”

**Steps**:

1. **Open the Document**: Click on the **File** menu and select **Open**.

2. **Locate the File**: In the dialog box, navigate to the location where “My document” is saved.

3. **Select the Document**: Click on “My document” to highlight it.

4. **Open the Document**: Click the **Open** button to open the file.

5. **Rename the Document**: 

   - After the document opens, click on **File** again and select **Save As**.

   - In the dialog box, type “My renamed document” in the file name field.

6. **Save the Renamed Document**: Click **Save** to save the document with the new name.

7. **Close the Document**: Again, go to the **File** menu and select **Close** to exit the document.