Differences

This shows you the differences between two versions of the page.

--- tanszek:oktatas:midterm_exam_questions [2024/09/01 12:32] – created nasraldeen
+++ tanszek:oktatas:midterm_exam_questions [2025/10/30 17:34] (current) – nasraldeen
@@ Line 1: / Line 1: @@
 ===== Midterm Exam Questions =====
-  - Explain the function of the bus in a computer system.
+Section A: Multiple Choice Questions (10 marks, Each = 1 mark)
-  - Describe a scenario where the bus speed could become a bottleneck in a computer system. What are some possible solutions?
-  - Describe the Von Neumann architecture and explain how it influences modern computer systems.
+- A computer can be defined as:
-  - What is the role of libraries in software development?
+a) A mechanical device for simple calculations
-  - Compare and contrast the functions of system software and application software, providing examples of each.
+b) An electronic device that processes and stores data
-  - You are tasked with installing a new operating system on a computer. List the steps you would take to ensure the operating system is installed correctly.
+c) A machine for playing games
-  - You have a dataset in Excel containing sales data for the past year. Describe the steps you would take to create a pivot table that shows total sales per month.
+d) None of the above
-  - Explain the concept of the Turing machine and its significance in computer science.
-  - A computer is running slowly even though the CPU usage is low. What other hardware components could be causing the issue, and how would you diagnose them?
+- Which of the following is an input device?
-  - Describe a situation where understanding the Neumann principle would be essential for solving a computer system problem.
+a) Printer
-  - What is the purpose of using conditional formatting in Excel?
+b) Mouse
-  - Given a spreadsheet, perform the following tasks:
+c) Projector
-  * a) Create a formula to calculate the total sales.
+d) Speaker
-  * b) Use VLOOKUP to find the sales amount for a specific product.
-  * c) Apply conditional formatting to highlight all sales figures above a certain threshold.
+- The main function of the CPU is to:
+a) Store data permanently
+b) Perform arithmetic and logic operations
+c) Display output on screen
+d) Manage printers
+- The motherboard primarily:
+a) Displays results
+b) Connects and communicates between hardware components
+c) Runs antivirus software
+d) Stores user data
+- Which of the following is a type of storage device?
+a) Monitor
+b) USB Flash Drive
+c) Keyboard
+d) Speaker
+- The Arithmetic Logic Unit (ALU) performs:
+a) Only data storage
+b) Arithmetic and logical operations
+c) Internet connections
+d) Sound recording
+- The Von Neumann principle is based on:
+a) Hardware duplication
+b) Separate storage for data and instructions
+c) Shared storage for data and instructions
+d) Parallel computing
+- Which of the following is system software?
+a) MS Excel
+b) VLC Media Player
+c) Windows 11
+d) Photoshop
+- In binary arithmetic, 1 + 1 +1 equals:
+a) 0
+b) 10
+c) 11
+d) 1
+- The function used in Excel to count cells meeting a condition is:
+a) SUMIF
+b) COUNTIF
+c) AVERAGE
+d) ROUND
+________________________________________
+Section B: Short Answer / Problem Solving (10 marks, Each = 2 marks)
+- List and briefly explain two main types of computer memory.
+- Explain the difference between hardware and software with one example each.
+- Describe the four basic components of a computer system as shown in the block diagram.
+- Define the microprocessor and list its four main steps in instruction execution.
+- What is a bus in computer architecture? Mention its three types.
+- Differentiate between compiler and interpreter.
+- Explain the five main functions of an Operating System.
+- Convert the following binary number to decimal: (11010)₂ = ?
+- Perform binary addition: 1011 + 1101 = ?
+- In Microsoft Excel:
+a) Write a formula to find the average of cells A1 through A5.
+b) Write a SUMIF formula that adds values in B2:B10 where A2:A10 equals “Apples”.