Data Entry (229)
Tutor Marked Assignment
%20EM%20Solved%20TMA%202024-25.webp "Nios 10th Data Entry (229) English Medium Solved Assignment")
20% Marks Of Theory
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.
Answer: Steps to Protect Ekta's Document:
1. Set a Strong Password: Create a complex password that's hard to guess, combining uppercase and lowercase letters, numbers, and symbols.
2. Encrypt the Document: This scrambles the document's contents, making it unreadable to those without the decryption key.
3. Limit Sharing: Share the document only with trusted individuals and control who can view, edit, or copy it.
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.
Answer: To open the existing document "Pravesh" Pravesh can follow these steps:
1. Locate the file: Find the document in the folder where he saved it.
2. Double-click the file: This will open the document using the default application associated with that file type (e.g., Microsoft Word, Google Docs).
3. Make changes: Once the document is open, Pravesh can edit, modify, or add content as needed.
4. Save changes: After making changes, Pravesh should save the document to preserve his modifications. He can choose to save it with the same file name or a new one.
Answer: Shortcut keys for the following actions:
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?
Answer: To keep the first row of headings visible in Sunita's worksheet, she can follow these steps:
1. Select the first row: Click on the row number (e.g., 1) to select the entire row.
- Excel: Go to the "View" tab, then click on "Freeze Panes." Choose "Freeze Top Row" to keep the first row fixed.
- Google Sheets: Go to the "View" menu, then select "Freeze." Choose "Freeze Row 1" to keep the first row fixed.
3. Verify the result: Scroll down the worksheet to ensure that the first row remains visible and the column headings are always displayed.
By freezing the first row, Sunita can easily reference the column headings while working with the data in the rest of the worksheet.
.webp "(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?")
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.
1. Locate the installation file: Find the setup file (usually an .exe file on Windows or a .dmg file on macOS) that came with the game.
3. Follow the on-screen instructions: The wizard will guide Ramesh through the installation process, asking him to accept terms and conditions, choose an installation location, and select desired features.
4. Wait for installation to complete: The installation process may take a few minutes depending on the size of the game and the speed of Ramesh's computer.
5. Restart computer (optional): Some games may require a computer restart after installation to complete the setup process.
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:
(a) Create and save the above file as “Class 10 Record”.
Answer:
1. Open a Spreadsheet Software: You can use Microsoft Excel, Google Sheets, or another similar program.
2. Enter the Data: Fill in the table with the given data, ensuring the headings are in the first row.
3. Save the File: Go to the "File" menu and select "Save As." Choose a location on your computer, name the file "Class 10 Record," and select the appropriate file format (e.g., .xlsx for Excel).
(b) Add a new column “Social Science” in the spreadsheet.
Answer:
1. Click on the Column Header: Click on the letter representing the column to the right of "Science" (in this case, column H).
2. Insert a Column: Right-click on the column header and select "Insert." This will add a new column to the left of the selected column.
3. Rename the Column: Click on the header of the new column and type "Social Science."
(c) Give the cell reference of the cell that contains the value “Sunil”.
Answer: The cell reference for "Sunil" is B5. Here, "B" represents the column and "5" represents the row.
(d) Rename the column “Maths” as “Mathematics”.
Answer:
1. Click on the Column Header: Click on the letter "G" (assuming "Maths" is in column G).
2. Right-click and Select "Rename": Choose this option from the context menu.
3. Type the New Name: Enter "Mathematics" in the dialog box and click "OK."
(e) Count the total number of columns in the spreadsheet.
(f) Write the steps to delete this spreadsheet
Answer:
1. Select the File: Click on the file name in the spreadsheet's window.
2. Right-click and Choose: "Delete" This will remove the spreadsheet from your computer.
3. Confirm Deletion: If prompted, confirm that you want to delete the file.
