🚗
🤖
🗼 💻 🖥️ ðŸ§
🖥️
🗼
✨ Comprehensive Computer Studies Assessment ✨
COMPUTISM LAB
YEARLY EXAMINATION
ðŸ§
🤖
Subject: Computer Science
Max Marks: 100
Time Allowed: 3 Hours
Section A: Fill in the Blanks10 Marks
- An is the most important system software without which a computer cannot run.
- The shortcut key combination for the Find and Replace feature in MS Word is .
- utility software speeds up the access of data from a hard disk by rearranging files and unused space.
- A cell in Excel is formed by the intersection of a row and a .
- The statement in Python is used to terminate a loop prematurely.
- A built-in dictionary in MS Word used to look up meanings and opposites is called .
- The feature in PowerPoint allows displaying multiple pictures as a slide show.
- software is designed specifically to meet the individual or organizational requirements like billing or reservations.
- In Python, the statement acts as an empty placeholder that performs no operations.
- The bar in Excel displays the contents of the currently active cell.
Section B: Multiple Choice Questions (MCQs)10 Marks
- Which of the following serves as an interface between the user and hardware?
- a. Operating System
- b. MS Word
- c. Antivirus
- d. Paint
- What is the shortcut key to activate the Spelling and Grammar feature in Word?
- a. F5
- b. F7
- c. Ctrl + F
- d. Shift + F7
- Which of the following is an example of utility software?
- a. Windows 10
- b. Disk Defragmenter
- c. MS Excel
- d. Compiler
- Which area in an Excel window displays the address of the current cell?
- a. Formula Bar
- b. Name Box
- c. Status Bar
- d. Ribbon
- Why do we use loops in Python programming?
- a. To automate repetitive tasks
- b. To write longer code
- c. To prevent execution
- d. To delete files
- Which tab in PowerPoint contains the options to apply themes to presentations?
- a. Home
- b. Insert
- c. Design
- d. View
- What does the `continue` statement do inside a loop?
- a. Exits the loop entirely
- b. Skips current iteration and moves to next
- c. Restarts the program
- d. Deletes variables
- Which software category manages hardware resources and provides platforms for application programs?
- a. System Software
- b. Application Software
- c. Presentation Software
- d. Graphics Software
- What is a collection of worksheets stored under a single file name in Excel called?
- a. Cell
- b. Workbook
- c. Database
- d. Sheet
- Which of these effects appear when one slide changes to another during a slideshow?
- a. Animation Effects
- b. Transition Effects
- c. Annotation Effects
- d. Header Effects
Section C: Assertion-Based MCQs10 Marks
-
Assertion (A): An application software cannot run without the presence of a system software.
Reason (R): System software manages hardware resources and provides the foundational platform for application execution.
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, but unrelated.
c) A is true, R is false.
d) A is false, R is true. -
Assertion (A): The `break` statement immediately terminates the loop execution in Python.
Reason (R): It transfers program control to the statement immediately following the loop body.
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, unrelated.
c) A is true, R is false.
d) A is false, R is true. -
Assertion (A): Disk defragmenter slows down file retrieval across hard disk sectors.
Reason (R): Defragmentation rearranges scattered files into contiguous blocks to speed up disk access.
a) Both A and R are true.
b) A is true, R is false.
c) A is false, but R is true.
d) Both are false. -
Assertion (A): Word indicates spelling mistakes in documents using a red wavy line.
Reason (R): Grammatical errors are similarly highlighted with green wavy underlines.
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, unrelated.
c) A is true, R is false.
d) A is false, R is true. -
Assertion (A): The `else` block associated with a Python loop executes even if a `break` statement occurs.
Reason (R): Loop-else blocks only run when the loop completes all iterations normally without breaking.
a) Both A and R are true.
b) A is true, R is false.
c) A is false, but R is true.
d) Both are false. -
Assertion (A): Specific purpose application software is developed for generalized everyday user needs.
Reason (R): Customised software is built keeping specific organizational tasks like billing or reservations in mind.
a) Both A and R are true.
b) A is true, R is false.
c) A is false, but R is true.
d) Both are false. -
Assertion (A): A `while` loop checks its condition prior to executing the loop code block.
Reason (R): If the initial condition evaluates to False, the while loop body never executes.
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, unrelated.
c) A is true, R is false.
d) A is false, R is true. -
Assertion (A): Headers and footers appear in the top and bottom page margins across documents.
Reason (R): They are useful for displaying page numbers, document titles, or dates consistently.
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, unrelated.
c) A is true, R is false.
d) A is false, R is true. -
Assertion (A): The Format Painter replicates font styles, colors, and formatting across text.
Reason (R): It permanently modifies workbook margins and sheet orientations.
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 are false. -
Assertion (A): Language processors translate high-level computer code into machine language.
Reason (R): Computers are electronic devices that natively understand machine language (zeros and ones).
a) Both A and R are true, and R is the correct explanation of A.
b) Both are true, unrelated.
c) A is true, R is false.
d) A is false, R is true.
Section D: True or False10 Marks
- An operating system serves as an interface between the user and computer hardware. (True / False)
- Application software can run independently without any operating system installed. (True / False)
- The `break` statement in Python exits the entire loop immediately. (True / False)
- Disk Defragmenter utility speeds up file access by combining scattered disk spaces. (True / False)
- We can replace all occurrences of a word at once using the Find and Replace feature. (True / False)
- Transition effects apply animations to individual objects on a single PowerPoint slide. (True / False)
- The `pass` statement acts as a temporary placeholder in Python code blocks. (True / False)
- Headers and footers can only be placed in the center of a document page. (True / False)
- Excel spreadsheet software allows users to calculate, organize, and analyze numeric data. (True / False)
- Antivirus programs scan computer storage disks to identify and remove malicious viruses. (True / False)
Section E: Short Answer Questions (2 Marks Each)10 Marks
- What is system software? Give two examples.
Answer: System software is required to control the overall working and hardware resources of a computer. Examples: Windows 10, Linux. - Differentiate between `break` and `continue` statements in Python.
Answer: `break` terminates and exits the loop entirely, whereas `continue` only skips the current iteration and jumps to the next one. - What is the role of an Operating System as a resource manager?
Answer: It allocates system resources such as CPU time, memory space, and input/output devices to various running programs as needed. - Explain the significance of the Thesaurus feature in MS Word.
Answer: Thesaurus is a built-in dictionary that helps users look up synonyms and antonyms to improve vocabulary and sentence formation. - What are transition effects in PowerPoint?
Answer: Transition effects are visual movements and animations that appear on screen when one slide changes to another during a presentation slideshow.
Section F: Programming Tasks & Practical Applications25 Marks
-
Program 1: Python Loop with Break
Write a Python program using a `for` loop to iterate from 1 to 10 and stop execution using a `break` statement when the number equals 5.
for i in range(1, 11):
if i == 5:
break
print(i) -
Program 2: Python While Loop Counter
Write a Python program using a `while` loop to print numbers from 1 to 5.
count = 1
while count <= 5:
print(count)
count += 1 -
Program 3: Python Loop with Continue
Write a Python program using a `for` loop and `continue` statement to skip printing odd numbers between 1 and 6.
for number in range(1, 7):
if number % 2 != 0:
continue
print(number) -
Task 4: MS Word Find & Replace
Outline the quick steps to find all occurrences of the word "essential" and replace them with "important" in MS Word.
1. PressCtrl + Hshortcut key.
2. Enter "essential" in the Find what box.
3. Enter "important" in the Replace with box and click Replace All. -
Task 5: Excel Data Entry & Formula Usage
Explain how data values and formulas are initiated in Excel worksheets.
1. Click a cell and type numbers, dates, or text directly.
2. Formulas in Excel must always begin with an equal to (=) sign.
⭐ Best of Luck for Your Examination! Code and Learn with Confidence! 🚀
CREATED BY BIJAN KRISHNA PAUL