💻

🤖

🖥️

🗼

✨ Class 8 Computer Science Examination ✨

COMPUTISM LAB CLASS 8 HALF YEARLY EXAMINATION

Half-Yearly Assessment

🧠

🤖

Class: 8

Max Marks: 70

Time Allowed: 2 Hours

Section A: Fill in the Blanks10 Marks

1. Scratch was developed by the Lifelong Kindergarten Group at MIT Media Lab, led by .
2. The 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 statements.
4. The 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 .
6. A chart displays data points by combining X and Y values into single points.
7. The 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 .

Section B: Multiple Choice Questions (MCQs)20 Marks

1. Which of the following is an effective way to display data in a pictorial form?
   • a. Table
   • b. Chart
   • c. Function
   • d. Formula
2. Which chart type looks similar to a spider's net?
   • a. Stock
   • b. Radar
   • c. Area
   • d. Bubble
3. Which operation is used for text concatenation in Excel?
   • a. &
   • b. +
   • c. *
   • d. %
4. What type of error occurs when a number is divided by zero in Excel?
   • a. #VALUE!
   • b. #DIV/0!
   • c. #NAME?
   • d. #REF!
5. Which of the following is a selection statement in programming?
   • a. for
   • b. while
   • c. if...else
   • d. do...while
6. Which operating system type is used in air traffic control systems?
   • a. Single-user
   • b. Real-time
   • c. Distributed
   • d. Batch
7. Which of these is a CUI-based operating system?
   • a. Windows
   • b. DOS
   • c. Ubuntu
   • d. Android
8. Running several programs simultaneously on a computer system is known as:
   • a. Single-tasking
   • b. Multitasking
   • c. Booting
   • d. Compiling
9. Which component shows the actual graph in an Excel chart?
   • a. Plot area
   • b. Chart area
   • c. Legend
   • d. Axis title
10. What does the INT function do in Excel?
    • a. Counts values
    • b. Rounds to nearest integer
    • c. Displays current date
    • d. Finds maximum value
11. Which of the following is not a control structure?
    • a. Sequential
    • b. Selection
    • c. Looping
    • d. Hardware
12. Which chart is best suited for showing trends over time?
    • a. Line chart
    • b. Pie chart
    • c. Doughnut chart
    • d. Radar chart
13. What function rounds a number to a certain number of digits?
    • a. ROUND
    • b. MOD
    • c. INT
    • d. SUM
14. What does MOD(10, 3) return in Excel?
    • a. 3
    • b. 1
    • c. 10
    • d. 0
15. Which axis represents values in a standard column chart?
    • a. Category axis
    • b. Value axis
    • c. Series axis
    • d. Plot axis
16. Which of the following is an example of system software?
    • a. MS Word
    • b. Windows
    • c. MS Excel
    • d. Paint
17. What is a cell range in Excel?
    • a. A single cell
    • b. A group of contiguous cells
    • c. A workbook
    • d. A formula bar
18. Which loop structure checks the condition at the end of the loop?
    • a. for loop
    • b. while loop
    • c. do...while loop
    • d. if statement
19. What does an operating system act as between the user and hardware?
    • a. Barrier
    • b. Interface / Bridge
    • c. Antivirus
    • d. Compiler
20. Which program allows users to create presentations with text, graphics, and animations?
    • a. MS PowerPoint
    • b. MS Access
    • c. MS Paint
    • d. Notepad

Section C: Assertion-Based MCQs10 Marks

1. Assertion (A): Control statements alter the normal sequential flow of program execution.
   Reason (R): They allow programs to make decisions and repeat blocks of code based on conditions.
   a) Both A and R are true, and R is the correct explanation of A.
   b) Both A and R are true, but R is not the correct explanation of A.
   c) A is true, but R is false.
   d) A is false, but R is true.
2. Assertion (A): The condition in an if statement must evaluate to a Boolean value (True or False).
   Reason (R): Program decisions depend entirely on whether the tested condition is true or false.
   a) Both A and R are true, and R is the correct explanation of A.
   b) Both A and R are true, but R is not the correct explanation of A.
   c) A is true, but R is false.
   d) A is false, but R is true.
3. Assertion (A): Excel functions are predefined formulas used to perform calculations.
   Reason (R): Users cannot write custom calculations; they must rely entirely on built-in functions.
   a) Both A and R are true.
   b) A is true, but R is false.
   c) A is false, but R is true.
   d) Both A and R are false.
4. Assertion (A): An operating system is software that controls overall computer operations and hardware.
   Reason (R): Application software can run independently without any operating system.
   a) Both A and R are true.
   b) A is true, but R is false.
   c) A is false, but R is true.
   d) Both A and R are false.
5. Assertion (A): Charts make it easier to draw comparisons and analyze relationships in data visually.
   Reason (R): Pictorial representation of data is more engaging and easier to interpret than raw numbers.
   a) Both A and R are true, and R is the correct explanation of A.
   b) Both A and R are true, but unrelated.
   c) A is true, R is false.
   d) A is false, R is true.
6. Assertion (A): Absolute cell references change when copied to another cell.
   Reason (R): Dollar signs ($) are used to lock row and column coordinates in absolute referencing.
   a) Both A and R are true.
   b) A is true, R is false.
   c) A is false, but R is true.
   d) Both A and R are false.
7. Assertion (A): Real-time operating systems guarantee response within a strict time constraint.
   Reason (R): They are utilized in mission-critical environments like medical equipment and industrial robotics.
   a) Both A and R are true, and R is the correct explanation of A.
   b) Both A and R are true, but unrelated.
   c) A is true, R is false.
   d) A is false, R is true.
8. Assertion (A): The legend in a chart helps identify different data series by their colors or patterns.
   Reason (R): Without a legend, users cannot read axis labels or chart titles.
   a) Both A and R are true.
   b) A is true, but R is false.
   c) A is false, but R is true.
   d) Both A and R are false.
9. Assertion (A): Looping statements are used to repeat execution of a statement block multiple times.
   Reason (R): For and while loops are classic examples of looping structures in programming.
   a) Both A and R are true, and R is the correct explanation of A.
   b) Both A and R are true, but unrelated.
   c) A is true, R is false.
   d) A is false, R is true.
10. Assertion (A): GUI operating systems require users to type text commands for every operation.
    Reason (R): Graphical user interfaces use icons, menus, and windows for easy interaction.
    a) Both A and R are true.
    b) A is true, R is false.
    c) A is false, but R is true.
    d) Both A and R are false.

Section D: True or False10 Marks

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

Section E: Short Answer Questions (2 Marks Each)20 Marks

1. What is a control statement in programming?
2. What is the difference between sequential and selection statements?
3. What is a formula in Excel? Give an example.
4. What is a cell range? How is it represented?
5. Differentiate between absolute and mixed cell references.
6. What is the role of an operating system? Name two examples.
7. What are Excel functions? Give two examples of functions.
8. What is the purpose of using a chart in Excel?
9. What is a data series in a chart?
10. Explain the benefit of a Graphical User Interface (GUI) over a Character User Interface (CUI).

⭐ Best of Luck for Your Examination! Keep Learning! 🚀

CREATED BY BIJAN KRISHNA PAUL