avantika

🚗

🤖

🗼 💻 🖥️ 🧠

🖥️

🗼

✨ 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

1. An is the most important system software without which a computer cannot run.
2. The shortcut key combination for the Find and Replace feature in MS Word is .
3. utility software speeds up the access of data from a hard disk by rearranging files and unused space.
4. A cell in Excel is formed by the intersection of a row and a .
5. The statement in Python is used to terminate a loop prematurely.
6. A built-in dictionary in MS Word used to look up meanings and opposites is called .
7. The feature in PowerPoint allows displaying multiple pictures as a slide show.
8. software is designed specifically to meet the individual or organizational requirements like billing or reservations.
9. In Python, the statement acts as an empty placeholder that performs no operations.
10. The bar in Excel displays the contents of the currently active cell.

Section B: Multiple Choice Questions (MCQs)10 Marks

1. Which of the following serves as an interface between the user and hardware?
   • a. Operating System
   • b. MS Word
   • c. Antivirus
   • d. Paint
2. What is the shortcut key to activate the Spelling and Grammar feature in Word?
   • a. F5
   • b. F7
   • c. Ctrl + F
   • d. Shift + F7
3. Which of the following is an example of utility software?
   • a. Windows 10
   • b. Disk Defragmenter
   • c. MS Excel
   • d. Compiler
4. Which area in an Excel window displays the address of the current cell?
   • a. Formula Bar
   • b. Name Box
   • c. Status Bar
   • d. Ribbon
5. 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
6. Which tab in PowerPoint contains the options to apply themes to presentations?
   • a. Home
   • b. Insert
   • c. Design
   • d. View
7. 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
8. Which software category manages hardware resources and provides platforms for application programs?
   • a. System Software
   • b. Application Software
   • c. Presentation Software
   • d. Graphics Software
9. What is a collection of worksheets stored under a single file name in Excel called?
   • a. Cell
   • b. Workbook
   • c. Database
   • d. Sheet
10. 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

1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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

1. An operating system serves as an interface between the user and computer hardware. (True / False)
2. Application software can run independently without any operating system installed. (True / False)
3. The `break` statement in Python exits the entire loop immediately. (True / False)
4. Disk Defragmenter utility speeds up file access by combining scattered disk spaces. (True / False)
5. We can replace all occurrences of a word at once using the Find and Replace feature. (True / False)
6. Transition effects apply animations to individual objects on a single PowerPoint slide. (True / False)
7. The `pass` statement acts as a temporary placeholder in Python code blocks. (True / False)
8. Headers and footers can only be placed in the center of a document page. (True / False)
9. Excel spreadsheet software allows users to calculate, organize, and analyze numeric data. (True / False)
10. Antivirus programs scan computer storage disks to identify and remove malicious viruses. (True / False)

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

1. 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.
2. 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.
3. 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.
4. 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.
5. 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

1. 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)
2. 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
3. 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)
4. 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. Press Ctrl + H shortcut key.
   2. Enter "essential" in the Find what box.
   3. Enter "important" in the Replace with box and click Replace All.
5. 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