Describe four categories of data which can be entered on a Microsoft Excel sheet.

1. Describe four categories of data which can be entered on a Microsoft Excel sheet. (4 mk)

Upgrade to see model answers.

Mention six components of the Integrated Development Environment (IDE) in Visual Basic and explain the function of IDE.

1. Mention six components of the Integrated Development Environment (IDE) in Visual Basic. (4 mk)
2. Explain the function of IDE. (2 mk)

Upgrade to see model answers.

(a) Differentiate logic diagram from truth table. (b) Study the following logic diagram and to answer the questions that follow: (i) With clear steps, write a simplified Boolean expression for the output "F". (ii) Construct the equivalent truth table for the simplified expression.

1. Differentiate logic diagram from truth table. (2 mk)
2. With clear steps, write a simplified Boolean expression for the output "F". (5 mk)
3. Construct the equivalent truth table for the simplified expression. (3 mk)

Upgrade to see model answers.

(a) Explain the term Pseudocode. (b) Study the following scenario and answer the questions that follow: Tanzania Youth Bank (TYB) pays 10% interest on shares exceeding Tsh. 200,000 and 2% on shares that do not meet this target. No interest is paid on deposit in the member's bank account. Using a pseudocode, design an algorithm for program that would; (i) Prompt the user for shares, deposit of a particular member and the name. (ii) Calculate the interest and total savings. (iii) Display the interest and total savings on the screen for a particular member on the bank.

1. Explain the term Pseudocode. (2 mk)
2. Prompt the user for shares, deposit of a particular member and the name. (3 mk)
3. Calculate the interest and total savings. (3 mk)
4. Display the interest and total savings on the screen for a particular member on the bank. (2 mk)

Upgrade to see model answers.

(a) Explain three types of HTML lists. (b) Provide HTML codes which generated the following login form

1. Explain three types of HTML lists. (6 mk)
2. Provide HTML codes which generated the following login form (4 mk)

Upgrade to see model answers.

(a) Define the term wireless network. (b) Study the following figure and answer the question that follow: (i) List the topologies used in the Figure studied. (ii) Mention the names of device A and B. (iii) Why it is necessary to have device B? (c) Give one advantage of the topology used in administration network.

1. Define the term wireless network. (1 mk)
2. List the topologies used in the Figure studied. (2 mk)
3. Mention the names of device A and B. (2 mk)
4. Why it is necessary to have device B? (1 mk)
5. Give one advantage of the topology used in administration network. (1 mk)

Upgrade to see model answers.

(a) Explain the term “requirement specifications” as used in software development. (b) Explain three considerations to be included in the requirement specification stage. (c) Describe two roles of testing phase in software development life cycle.

1. Explain the term “requirement specifications” as used in software development. (2 mk)
2. Explain three considerations to be included in the requirement specification stage. (3 mk)
3. Describe two roles of testing phase in software development life cycle. (2 mk)

Upgrade to see model answers.

(a) Differentiate data availability from data confidentiality (b) Describe four physical threats to data security.

1. Differentiate data availability from data confidentiality (2 mk)
2. Describe four physical threats to data security. (4 mk)

Upgrade to see model answers.

(a) Explain the presentation of hexadecimal number system and give the range of digits and letters used to represent hexadecimal numbers. (b) Convert A90F16 number system into: (i) its binary equivalent. (ii) its decimal equivalent.

1. Explain the presentation of hexadecimal number system and give the range of digits and letters used to represent hexadecimal numbers. (2 mk)
2. Convert A90F16 number system into its binary equivalent. (2 mk)
3. Convert A90F16 number system into its decimal equivalent. (2 mk)

Upgrade to see model answers.

(a) Explain the meaning of the term Information system. (b) Elaborate two roles of information system analyst. (c) Describe three main purposes of information system in an organization.

1. Explain the meaning of the term Information system. (1 mk)
2. Elaborate two roles of information system analyst. (2 mk)
3. Describe three main purposes of information system in an organization. (3 mk)

Upgrade to see model answers.

Describe the decimal, binary, octal and hexadecimal number systems and give an example for each type.

1. Describe the decimal, binary, octal and hexadecimal number systems and give an example for each type. (10 mk)

Upgrade to see model answers.

Describe four problems caused by storing data redundantly in a database and to explain how the first three levels of normalization can be used to avoid data redundancy.

1. Describe four problems caused by storing data redundantly in a database and to explain how the first three levels of normalization can be used to avoid data redundancy. (10 mk)

Upgrade to see model answers.

Draw a flowchart, write pseudocodes and use the while...loop to construct a C++ program that could: (i) Read a positive integer N. (ii) Calculate and print Where

1. Read a positive integer N. (2 mk)
2. Calculate and print Where (8 mk)

Upgrade to see model answers.