ICT Revision MCQ Series | OL ICT | First Term Test 2025 Grade 11

Spreadsheets are designed for data entry, calculations, and analysis, not for animation tools.

A worksheet is a single page, a cell is the intersection of a row and column, rows are horizontal, and columns are vertical.

The MAX function identifies the highest value in the range C2 to C6, which represents the Science scores of all students.

The COUNT function counts the number of non-empty cells in the range A2 to A6, which corresponds to the number of students listed in the table.

The SUM function adds up all the values in the range B2 to D2, which represents John's scores in Math, Science, and English.

The AVERAGE function calculates the mean of the values in the range B2 to B6, which represents the Math scores of all students.

The MIN function identifies the lowest value in the range D2 to D6, which represents the English scores of all students.

Spreadsheets are not designed for video editing but excel at organizing data, performing calculations, and visualizing data.

Efficiency reduces resource usage, accuracy ensures error-free results, speed enables faster processing, and scalability allows growth.

Bold makes text darker, italic slants text, underline adds a line beneath text, and font size adjusts text size.

Word processing software supports left, center, right, and justified alignments, but not diagonal alignment.

Input devices send data to the computer, and processing converts raw data into meaningful information. Output devices display results, and storage devices can store data permanently.

Data is first inputted, validated for accuracy, processed, and then outputted as meaningful information.

Computers are classified as mainframe, mini, micro, super, digital, analog, or hybrid. "Hybridization" is not a valid classification.

A primary key uniquely identifies records, a foreign key links tables, a record is a complete set of fields, and a field is a single piece of information.

Queries extract data, forms provide interfaces, reports present data, and relationships link tables.

The StudentID is the primary key in the Students table, ensuring each student has a unique identifier.

Relational databases aim to reduce redundancy, ensure data security, and maintain consistency, but they do not rely on manual data entry.

The ClassTeacherID column in the Students table links to the TeacherID column in the Teachers table, establishing a relationship between the two tables.

Deleting "T001" from the Teachers table will break the relationship, and students with ClassTeacherID = T001 will no longer have a valid teacher reference.

Valuable information should be understandable and reduce uncertainty, not be unnecessarily complex.

ICT is widely used in agriculture, healthcare, and education, but manual methods are not always superior to ICT.

Before organizing files, folders must be created to store them systematically.

Data encryption is not a primary function of an operating system. The OS handles user interfaces, resource management, and file organization.

Partitioning divides a drive, formatting prepares it, defragmentation rearranges data, and backup copies data for recovery.

Creation generates a new file, deletion removes it, renaming changes its name, and copying duplicates it.

While information systems improve efficiency and decision-making, they often require skilled human resources for operation and maintenance.

Computer-based systems automate data processing and rely on software tools, reducing reliance on manual data entry.

Common challenges include changing requirements, limited resources, and lack of user involvement, but excessive documentation is rarely a concern.

Proper identification of requirements ensures the system meets user needs; otherwise, it risks failure.

Waterfall is sequential, Agile is flexible, Iterative is incremental, and Spiral is risk-driven.

Input is data entry, process transforms data, output produces results, and feedback improves the system.

System testing verifies that the system functions as intended and meets user requirements.

Step 1: Group the binary digits into sets of three (from right to left)

Since octal is base 8 and each octal digit corresponds to 3 binary bits, we group the binary number into sets of 3 bits, padding with zeros on the left if necessary.

Binary:
1110110111101111

Pad with zeros to make it a multiple of 3 (we need 2 more bits):
001 110 110 111 101 111

Now group:

• 001

• 110

• 110

• 111

• 101

• 111

Step 2: Convert each group of 3 binary digits to its octal equivalent

Step 3: Write the final octal number

Putting it all together:
001110110111101111₂ = 166757₈

Cache memory has the smallest capacity compared to RAM, hard disks, and USB drives.

Explanation:
In BCD (Binary-Coded Decimal), each decimal digit is represented by a 4-bit binary equivalent.

• The decimal number 102 has three digits: 1, 0, and 2.
• Convert each digit to its 4-bit binary form:
  • 1 = 0001
  • 0 = 0000
  • 2 = 0010
• Combine the binary representations for each digit: 0001 0000 0010.

Thus, the correct answer is (a) 0001 0000 0010.

Step 1: Group the binary digits into sets of four (from right to left)

Since hexadecimal is base 16, and each hexadecimal digit corresponds to 4 binary bits, we group the binary number into 4-bit sections.

Binary:
1110110111101111

Group into 4 bits (no need to add zeros because it's already a multiple of 4):
1110 1101 1110 1111

Step 2: Convert each 4-bit group to a hexadecimal digit

Step 3: Write the final hexadecimal number

Putting it together:
1110110111101111₂ = EDEF₁₆

Explanation:
To convert the string "CAB" into binary using ASCII codes:

1. Find the ASCII values of each character:
   • 'C' = 67, 'A' = 65, 'B' = 66.
2. Convert each ASCII value to binary:
   • 67 in binary = 01000011,
   • 65 in binary = 01000001,
   • 66 in binary = 01000010.
3. Combine the binary values in the order of the string "CAB":
   • 01000011 01000001 01000010.

Thus, the correct answer is (a) 01000011 01000001 01000010.

• In BCD, each decimal digit is represented as a 4-bit binary number, making it easy to encode but less efficient in terms of storage compared to pure binary.
• Option (a) is incorrect because BCD typically uses more bits than pure binary.
• Option (c) is incorrect because BCD can represent numbers greater than 99 by extending the number of digits.
• Option (d) is incorrect because BCD encodes each digit separately, unlike pure binary, which converts the entire number into binary.

Thus, the correct answer is (b) BCD represents each decimal digit as a 4-bit binary number.

Explanation:
Step 1: Convert the octal number 753₈ to binary.
Each octal digit is represented by 3 bits in binary:

• 7₈ = 111₂
• 5₈ = 101₂
• 3₈ = 011₂
  So, 753₈ = 111101011₂.

Step 2: Group the binary number into sets of 4 bits (starting from the right):
111101011₂ becomes 0001 1110 0111₂.

Step 3: Convert each group of 4 bits into hexadecimal:

• 0001₂ = 1₁₆
• 1110₂ = E₁₆
• 0111₂ = 7₁₆

Thus, 753₈ = 1E7₁₆.

Binary uses base 2, octal uses base 8, hexadecimal uses base 16, and decimal uses base 10.

A bit is the smallest unit, a byte is 8 bits, a kilobyte is 1,024 bytes, and a megabyte is 1,024 kilobytes.

Common slide transitions include fade, push, and wipe, but "encrypt" is not a valid transition type.

Efficiency reduces resource usage, accuracy ensures error-free results, speed enables faster processing, and scalability allows growth.

Images provide visual representation, videos add dynamic content, audio includes music or narration, and text conveys key information.

The NOR gate outputs 1 only if all inputs are 0. It outputs 0 if any input is 1.

Efficiency reduces resource usage, accuracy ensures error-free results, speed enables faster processing, and scalability allows growth.

Step-by-step Analysis of the Circuit

1. Top AND Gate: Inputs A and B → Output = A AND B

2. Left OR Gate: Inputs B and C → Output = B OR C

3. Bottom AND Gate: Inputs B and C → Output = B AND C

4. Middle AND Gate: Inputs = (B OR C) AND (B AND C)

5. Rightmost OR Gate: Inputs = (A AND B) OR [(B OR C) AND (B AND C)] → this gives the final output Q

Expression for Q

$$Q=(A\cdot B)+[(B+C)\cdot (B\cdot C)]$$

Where:

• + = OR

• · = AND

Try All Combinations of A, B, C

Let’s test combinations to find one where Q = 1.

Case: A = 0, B = 1, C = 1

• A · B = 0 · 1 = 0

• B + C = 1 + 1 = 1

• B · C = 1 · 1 = 1

• (B + C) · (B · C) = 1 · 1 = 1

• Q = 0 + 1 = 1 ✅

✅ Answer: A = 0, B = 1, C = 1 gives Q = 1

AND has a curved input and sharp output, OR has a D-shaped symbol, NOT has a triangle with a circle, and NAND has a D-shaped symbol with a circle.

Explanation:
To determine the output Q, follow these steps:

1. The first AND gate has inputs A and B. Since both are 1, the output of this AND gate is 1.
2. The second AND gate has inputs B and C. Since both are 1, the output of this AND gate is 1.
3. The two outputs from the AND gates (1 and 1) are fed into a OR gate.
4. A NOR gate outputs 1 only if both inputs are 0. In this case, since both inputs to the NOR gate are 1, the output Q will be 0.

Thus, the correct answer is (a) 0.