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

Analyze Data Using Scenarios & Goal Seek (Calc)

Data Consolidation across sheets and ranges, Subtotals calculations, What-If Analysis using Scenarios, Goal Seek for back-calculation, and multi-variable optimization using Solver.

Quick Key Takeaways:
Data Consolidation: Data → Consolidate combines data from multiple ranges/sheets into one summary table using functions like SUM, AVERAGE, COUNT, MAX, MIN.
Goal Seek vs Solver: Goal Seek (Tools → Goal Seek) solves for one unknown input variable; Solver (Tools → Solver) handles multiple variables with equations and constraint equations.
Jump to Concept:1. Data Consolidation & Subtotals2. What-If Analysis & Scenarios3. Goal Seek & Solver
1

Data Consolidation & Subtotals

Data Tools

Aggregating scattered tabular data into unified analytical summaries.

• Consolidating Data
Open target worksheet → Data → Consolidate → Choose Function (SUM, AVERAGE) → Add Source Data Ranges → Check 'Copy results to' → Check 'Link to source data' (auto-updates when sources change) → Click OK.
• Generating Subtotals
Sort data by grouping column → Select table → Data → Subtotals → Choose 'Group by' column → Select calculation function and target columns → Click OK. Calc inserts summary rows and outline grouping controls.
2

What-If Analysis & Scenarios

Decision Making

Scenarios are saved sets of cell values that represent different hypothetical conditions (e.g. Best Case, Worst Case, Expected Case).

• Creating Scenarios
Select changing input cells → Tools → Scenarios → Enter Scenario Name → Choose border color and copy-back settings → Click OK. Toggle between scenarios using the drop-down title bar in the sheet.
3

Goal Seek & Solver

Optimization

Reverse calculation tools to determine input values required to achieve a desired target output.

• Goal Seek Parameters
1. Formula Cell: Cell containing formula; 2. Target Value: Desired numerical result; 3. Variable Cell: Single input cell to adjust to reach the target.
• Solver Engine
Advanced version of Goal Seek for optimization (Maximization, Minimization, Exact Value) across multiple changing cells subject to mathematical limiting constraints (e.g., Cell <= 100, Cell = Integer).
Authentic Board Question (3 Marks)Topic: Calc Data Analysis Tools
In LibreOffice Calc, differentiate between "Consolidating Data" and "Goal Seek". Write the exact menu path and execution steps for both.

Official CBSE Step-by-Step Marking Breakdown:

Step 1: Consolidating Data (Definition & Menu): Combines data from multiple sheets into a summary sheet using aggregate functions (SUM, AVERAGE). Menu Path: Data -> Consolidate.
1½ Marks
Step 2: Goal Seek (Definition & Menu): Finds the unknown input value required to achieve a desired target output formula result. Menu Path: Tools -> Goal Seek.
1½ Marks
Model Student Answer (Target: Full 3/3 Marks):
1. Consolidating Data:
- Purpose: Gathers and aggregates data from multiple source ranges or sheets into a single master summary table using functions like SUM, AVERAGE, COUNT.
- Exact Menu Navigation: Data →\to Consolidate... →\to Select Function →\to Add Source Data Ranges →\to Specify Copy Results To destination cell →\to Click OK.

2. Goal Seek:
- Purpose: A what-if analysis tool that calculates the specific input variable required to produce a predetermined target formula result.
- Exact Menu Navigation: Tools →\to Goal Seek... →\to Set Formula Cell (e.g., Total Profit) →\to Enter Target Value →\to Select Variable Cell (input cell to change) →\to Click OK →\to Accept replacement.
Examiner Mark Deduction Traps:
•Always write the exact arrow-delimited GUI menu path (Data -> Consolidate and Tools -> Goal Seek).
•Identify the 3 required fields for Goal Seek: Formula Cell, Target Value, and Variable Cell.

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