💻 COMPUTISM LAB CLASS 8 — COMPLETE SOLUTION

SECTION A — Fill in the Blanks

1. Scratch was developed by the Lifelong Kindergarten Group at MIT Media Lab, led by Mitchel Resnick.
2. The X-axis in an Excel chart is also known as the category axis.
3. Statements that repeat a set of instructions based on a condition are called looping statements.
4. The SUM function in Excel is used to calculate the sum of values.
5. An operating system that manages network traffic and multi-user environments is essential for server computers, such as Windows Server.
6. A scatter chart displays data points by combining X and Y values into single points.
7. The if statement is used for making decisions in programming languages.
8. In Excel, absolute cell referencing uses the $ sign before column and row references.
9. A chart includes all the objects and elements present in a chart window.
10. Real-time operating systems are primarily used in applications that require zero delay.

The questions in this section are given on the examination page.

---

SECTION B — Multiple Choice Questions

Q.	Question	Correct Answer
1	Effective way to display data in pictorial form	b. Chart
2	Chart similar to a spider's net	b. Radar
3	Text concatenation operator in Excel	a. &
4	Error when a number is divided by zero	b. #DIV/0!
5	Selection statement	c. if...else
6	OS used in air traffic control	b. Real-time
7	CUI-based operating system	b. DOS
8	Running several programs simultaneously	b. Multitasking
9	Component showing the actual graph	a. Plot area
10	INT function	b. Rounds to nearest integer
11	Not a control structure	d. Hardware
12	Best chart for trends over time	a. Line chart
13	Function that rounds a number	a. ROUND
14	MOD(10, 3)	b. 1
15	Axis representing values in a standard column chart	b. Value axis
16	Example of system software	b. Windows
17	Cell range	b. A group of contiguous cells
18	Loop that checks condition at the end	c. do...while loop
19	OS between user and hardware	b. Interface / Bridge
20	Program for presentations	a. MS PowerPoint

These are based directly on the 20 MCQs published in Section B.

Important calculations

Q14: MOD(10,3)

10 ÷ 3 gives:

• Quotient = 3
• Remainder = 1

Therefore:

MOD(10,3) = 1

---

SECTION C — Assertion-Based MCQs

1.

Assertion: Control statements alter the normal sequential flow of program execution.

Reason: They allow programs to make decisions and repeat blocks of code based on conditions.

✅ Answer: a) Both A and R are true, and R is the correct explanation of A.

---

2.

Assertion: The condition in an if statement must evaluate to a Boolean value (True or False).

Reason: Program decisions depend entirely on whether the tested condition is true or false.

✅ Answer: a) Both A and R are true, and R is the correct explanation of A.

---

3.

Assertion: Excel functions are predefined formulas used to perform calculations.

Reason: Users cannot write custom calculations; they must rely entirely on built-in functions.

✅ Answer: b) A is true, but R is false.

Explanation: Excel provides predefined functions, but users can also create their own formulas.

---

4.

Assertion: An operating system is software that controls overall computer operations and hardware.

Reason: Application software can run independently without any operating system.

✅ Answer: b) A is true, but R is false.

Explanation: Application programs normally depend on an operating system to access hardware and system resources.

---

5.

Assertion: Charts make it easier to draw comparisons and analyze relationships in data visually.

Reason: Pictorial representation of data is more engaging and easier to interpret than raw numbers.

✅ Answer: a) Both A and R are true, and R is the correct explanation of A.

---

6.

Assertion: Absolute cell references change when copied to another cell.

Reason: Dollar signs ($) are used to lock row and column coordinates in absolute referencing.

✅ Answer: c) A is false, but R is true.

Example:

$A$1

When copied, the reference remains $A$1.

---

7.

Assertion: Real-time operating systems guarantee response within a strict time constraint.

Reason: They are utilized in mission-critical environments like medical equipment and industrial robotics.

Here, both statements are true, but the reason gives examples of where RTOS is used rather than directly explaining the definition of a strict time constraint.

✅ Answer: b) Both A and R are true, but unrelated.

---

8.

Assertion: The legend in a chart helps identify different data series by their colors or patterns.

Reason: Without a legend, users cannot read axis labels or chart titles.

✅ Answer: b) A is true, but R is false.

Explanation: Axis labels and chart titles can still be read without a legend.

---

9.

Assertion: Looping statements are used to repeat execution of a statement block multiple times.

Reason: For and while loops are classic examples of looping structures in programming.

The reason gives examples of looping structures and supports the assertion.

✅ Answer: a) Both A and R are true, and R is the correct explanation of A.

---

10.

Assertion: GUI operating systems require users to type text commands for every operation.

Reason: Graphical user interfaces use icons, menus, and windows for easy interaction.

✅ Answer: c) A is false, but R is true.

---

SECTION D — True or False

No.	Statement	Answer
1	The condition in an if statement must always return a Boolean value.	✅ True
2	All conditions in an if...else if...else ladder are checked even if one is already true.	❌ False
3	Sequential statements involve loops and conditions by default.	❌ False
4	The chart title indicates the overall purpose of the chart.	✅ True
5	Gridlines are exclusively used in XY scatter charts and no other chart types.	❌ False
6	Software and hardware operate completely independently without interaction.	❌ False
7	The BIOS loads the operating system into the computer's RAM during startup.	✅ True
8	A single-user multitasking operating system allows more than one user to log in at the same time.	❌ False
9	The SUM function is used to calculate averages of a given cell range.	❌ False
10	File management is an essential core function of modern operating systems.	✅ True