EXAMSHARE

Western Delta University, Oghara Delta State

department of computer science
college of computing
western delta university

first semester examination 2022/2023 session

CSC101 - introduction to computers and spreadsheet analysis (FOR SCIENCES) time: 2hrs

answer question 1 and any other THREE questions

  1. Question 1 (Compulsory)

    1. Highlight one major contribution of the Babbage Analytical Engine (2 marks)
    2. State the key element of the Von Neumann computer architecture (2 marks)
    3. State the result of the binary addition: 100011012 + 110011012 (2 marks)
    4. State the name of the first computer programming language developed (2 marks)
    5. State the major application area of the first computer developed during the Second War World (2 marks)
    6. State the name of the input and output units of a microwave oven controller (2 marks)
    7. If a document of 9024MB of data is stored in a hard disk, how many number of the hard disk sectors is used? (2 marks)
    8. If there are 56250 words in a document, determine the storage size of the document in megabytes. (2 marks)
    9. Highlight two disadvantages of the cache memory of the computer. (2 marks)
    10. The following: 50 45 83 64 30 38 48 61 73 47 are the scores of ten students in GST101 test. If the scores are stored in cell addresses D1 through D10, and given the passing score is 55, write an Excel formula in:
      1. Cell address D12 to find the number of students that score at least the passing score.
      2. Cell address D13 the number of students that score below the passing score.
      (4 marks)
    11. Convert the binary number 110011.1012 to hexadecimal (3 marks)

  2. Question 2

    1. State two limitations of the Colossus computer to Computer industry (4 marks)
    2. State five components of the microcontroller (5 marks)
    3. The following expression: Pay = (Hours Worked * Hourly Rate) + Allowance is used to compute employee pay in a given establishment. Format a worksheet that computes employee pay using the following instructions:
      1. Enter the labels: Hours Worked, Hourly Rate, and Allowance in cells A1 through A3 respectively.
      2. Enter the values 56, 687, 20000 of the labels in cells B1 through B3 respectively.
      3. Enter the label Pay in cell B4
      4. Enter the formula to compute employee pay in cell C4.
      (6 marks)

  3. Question 3

    1. State two Excel data types that are not numeric in nature. (2 marks)
    2. The score of a student in a given examination are: 56 60 77 70 60 61 66. Format a worksheet using the following instructions:
      1. Enter the labels Scores in cell A1
      2. Enter the score values in cell A2 through A8 respectively.
      3. Enter the labels: Sum, Mean, Standard Deviation, and Variance in cells C5 through C8 respectively.
      4. Write formulae in cells D5 through D8 to compute Sum, Mean, Standard Deviation, and Variance respectively.
      (7 marks)
    3. State the name of the first Internet Browser to use both text and image in a webpage. (2 marks)
    4. Determine the number of megabytes in 256000 bits of storage. (4 marks)

  4. Question 4

    1. Define a Service program (2 marks)
    2. State four characteristic features of hexadecimal number system (2 marks)
    3. Convert 19FDE16 to decimal (3 marks)
    4. State the necessary steps to insert a new row in Microsoft Excel (2 marks)
    5. State the two major functions of the operating system (2 marks)
    6. Compute the product of the binary operation: 110101 * 111 (4 marks)

  5. Question 5

    1. State the steps necessary to increase Excel column width (2 marks)
    2. Write an Excel formula to compute A = P(1 + R)N, if the labels of P is in cell address A2, R is in cell address A3, and N is in cell address A4 and the values of P, R, N in cell addresses B2 through B4 respectively. The label A in cell address A6 and enter a formula to compute A in cell address B6. Note P = 5500, R = 0.25, and N = 20. Show your worksheet (5 marks)
    3. Give the octal representation of the following: 11101100102 (4 marks)
    4. State the hallmark of third generation computers (2 marks)
    5. Define an Embedded system (2 marks)

  6. Question 6

      1. Highlight two functions of the CPU control unit. (2 marks)
      2. Highlight two major characteristics of the RAM (2 marks)
      1. State the name of the first application package developed (2 marks)
      2. In what generation of computers was the named application package developed (2 marks)
    3. Compute the difference of the binary operation using 2's complement: 10110 - 01010 (3 marks)
    4. Highlight four major characteristic features of first generation computers. (2 marks)
    5. State the major distinction between the Excel functions: COUNT and COUNTIF (2 marks)