Master10
All Revision Notes
Information TechnologyCh-11 14 min comprehensive revision
CBSE Class 10 IT (402) — Part B: Unit 2 (Electronic Spreadsheet)

Share & Review a Spreadsheet (LibreOffice Calc)

Enabling spreadsheet sharing for multi-user collaboration, opening/saving shared sheets, recording and reviewing changes, inserting and formatting comments, and merging/comparing spreadsheet versions.

Quick Key Takeaways:
Sharing Workbooks: Tools → Share Spreadsheet allows multiple users on a local network to open, edit, and save changes concurrently.
Reviewing & Merging: Edit → Track Changes tracks edits with colored cell borders. Edit → Track Changes → Merge Document combines two edited copies into one.
Jump to Concept:1. Setting Up Spreadsheet Sharing2. Recording, Reviewing Changes & Comments3. Comparing & Merging Workbooks
1

Setting Up Spreadsheet Sharing

Multi-User

Enables simultaneous multi-user data entry and collaborative reporting.

• Enabling Shared Mode
Tools → Share Spreadsheet → Check 'Share this spreadsheet with other users' → Click OK → Save file. The title bar displays (shared) next to the filename.
• Shared Spreadsheet Limitations
Certain features are disabled in shared mode: deleting sheets, inserting charts, conditional formatting, and editing macros.
2

Recording, Reviewing Changes & Comments

Audit Trail

Maintaining full transparency on who edited which cell, what was changed, and when.

• Recording Changes
Edit → Track Changes → Record (Ctrl+Shift+C). Edited cells get a red border and a small red triangle indicating modified content.
• Reviewing Changes
Edit → Track Changes → Manage... → Browse list of changes (Author, Date, Time, Old Value, New Value) → Click Accept or Reject.
• Adding & Formatting Comments
Right-click cell → Insert Comment (Ctrl+Alt+C). Enter note. Yellow indicator in cell corner shows comment presence.
3

Comparing & Merging Workbooks

Version Control

Consolidating divergent copies of a spreadsheet back into a master copy.

• Merging Documents
Open original document → Edit → Track Changes → Merge Document... → Select modified copy → Accept/Reject changes.
• Comparing Documents
Open edited file → Edit → Track Changes → Compare Document... → Select original file → Calc highlights all differences as recorded changes.
Authentic Board Question (3 Marks)Topic: Share & Review a Spreadsheet (LibreOffice Calc) LibreOffice Menu Path & Practical Workflow
Write the step-by-step practical procedure, menu path, and configuration settings in LibreOffice for "Share & Review a Spreadsheet (LibreOffice Calc)".

Official CBSE Step-by-Step Marking Breakdown:

Step 1: Exact Menu Navigation Pathway: State the precise menu sequence (e.g., Data -> Consolidate, Tools -> Scenarios, Format -> Styles and Formatting).
1 Mark
Step 2: Dialog Box Settings & Parameters: Specify the required input fields, source ranges, target cells, or style properties in the dialog window.
1 Mark
Step 3: Execution, Document Result & Shortcuts: Describe the resulting change in the document/sheet and provide the official keyboard shortcut (e.g., F11, Ctrl+F10).
1 Mark
Model Student Answer (Target: Full 3/3 Marks):
To score full 3 marks on "Share & Review a Spreadsheet (LibreOffice Calc)" in CBSE IT (402):

1. GUI Menu Pathway: Menu →\to Submenu →\to Tool Name... (e.g. Data →\to Consolidate).
2. Configuration Steps: In the dialog window, define source ranges, select the mathematical function or style attributes, and choose the output destination.
3. Application & Verification: Click OK to apply changes. Confirm the updated formatting, scenario switch, or consolidated summary.
Examiner Mark Deduction Traps:
•Always write menu paths using arrows: Main Menu -> Submenu -> Command.
•Mention standard shortcut keys where applicable to demonstrate practical lab mastery.

High-Frequency Conceptual Doubts & FAQs

Curated answers to the most common questions asked by Class 10 students.
This chapter establishes the foundational principles, definitions, and operational workflows required for Class 10 board mastery.

Next Learning Steps & Active Practice

You have completed the revision notes. Now apply, test, and evaluate your understanding.
Notes Completed