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

Create & Use Macros in Spreadsheet (Calc)

Automating repetitive spreadsheet tasks using Macro Recorder, running macros, writing user-defined functions in Basic, passing arguments to macro functions, and organizing macros in libraries.

Quick Key Takeaways:
Macro: A saved sequence of keystrokes, commands, and actions recorded or written in LibreOffice Basic to automate repetitive tasks.
Macro Recorder & Functions: Enable via Tools → Options → LibreOffice → Advanced → Check 'Enable macro recording'. Custom macros can be called inside sheet cells as user-defined functions.
Jump to Concept:1. Recording & Running Macros2. Macros as Functions & Passing Arguments
1

Recording & Running Macros

Automation

Macro Recorder records user interactions and generates underlying LibreOffice Basic script automatically.

• Enabling Macro Recording
By default disabled in modern LibreOffice. Enable via Tools → Options → LibreOffice → Advanced → Check 'Enable macro recording (may be limited)' → Click Apply/OK.
• Recording a Macro
Tools → Macros → Record Macro → Perform formatting/calculation tasks → Click Stop Recording in small floating toolbar → Choose destination library (e.g. My Macros → Standard → Module1) → Enter Macro Name → Click Save.
• Running a Macro
Tools → Macros → Run Macro... → Select Macro from library tree → Click Run.
2

Macros as Functions & Passing Arguments

Basic Script

Writing custom calculations that can be invoked like built-in Calc formulas (=MYFUNC(A1, B1)).

• Custom Function Syntax
Function DoubleValue(x)
DoubleValue = x * 2
End Function
• Calling in Spreadsheet
In cell B1, enter =DOUBLEVALUE(A1). Calc computes the result dynamically by executing the underlying Basic function.
• Organizing Macros
Tools → Macros → Organize Macros → Basic... allows creating modules, exporting libraries, and assigning macros to keyboard shortcuts or toolbar buttons.
Authentic Board Question (3 Marks)Topic: Create & Use Macros in Spreadsheet (Calc) LibreOffice Menu Path & Practical Workflow
Write the step-by-step practical procedure, menu path, and configuration settings in LibreOffice for "Create & Use Macros in Spreadsheet (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 "Create & Use Macros in Spreadsheet (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