Unformatted text preview: SU09 CSE1520-A Test #1 KEY Part A: Multiple Choice – Choose the option with the best fit. [20 Marks] CSE
1520 1. Who were the original computer users with problems to solve?
A. Business professionals
C. Graduate students
D. Civil servants
2. The discipline of computing consists in _______.
D. All of the above 3. This aspect of computing relates to problem-solving using such techniques as numerical
computations, databases and information retrieval, artificial intelligence, robotics, graphics,
organizational informatics and bioinformatics.
C. User interfaces
D. Personal computing
4. This statement is true with respect to a machine language.
A. It is built into the electrical circuitry of a computer.
B. It is a language made up of mnemonic codes.
C. It requires a compiler.
D. It requires an assembly program. 5. This became available in the Fourth generation of software development.
D. World Wide Web.
6. This is a rationale behind the development of operating systems.
A. The human systems operator was too slow.
B. Computers were inefficiently utilized.
C. Computers could organize themselves.
D. All of the above. 7. This is true with respect to the SPSS program.
A. It introduced an important feature unlike any other program that preceded it.
B. It was written for use by non-programmers.
C. The user could enter data and specify the processing of the data.
D. All of the above. 8. The integrated circuits developed in the Third generation were associated with this.
Apr. 7, 2009 1 of 5 SU09 Test #1 KEY Assembly
D. CSE1520-A 9. The first successful commercial spreadsheet program debuted in the ____ Generation.
10. Bandwidth use is typically improved by adopting this.
B. Data compression
C. CPU performance
D. None of the above.
11. The term "directory" refers to this.
A. A named group of files
B. A file path
C. All files in a logical drive.
D. A single file 12. This is an alternative floating-point notation.
A. Two’s complement
D. Exponentiation 13. Computers' fundamental strengths include these except ____.
14. This refers to methods used to shrink the size of a movie file.
A. Temporary compression
B. Video codec
C. Spatial bit map
D. Run-length compression 15. This format refers to graphics that store image information pixel by pixel.
A. Linear graphics
B. Vector graphics
C. Spatial graphics
D. Raster graphics 16. This is the act of breaking information down into discrete pieces.
A. Analog compression
Apr. 7, 2009 2 of 5 SU09 CSE1520-A Test #1 KEY B. Pulse-code modulation
D. High resolution CSE
17. The technique in which data in a file is accessed in series one after the other is referred to as ____.
A. Direct file access
B. File access streaming
C. Sequential file access
D. File pointer access
18. This is a means to compensate for degradation in transmission signal.
B. Pulse-code modulation
C. Lossless compression
D. Digitize 19. This refers to the number of bits that can be transmitted from one place to another in a fixed amount of time. A.
D. Frequency modulation
Digital data 20. The positional number system is possible because of this.
A. Natural number
D. Number Zero Part B - Complete the tables below. [15 Marks] For the next 4 questions, given the binary number 11101, 21. Its Base 4 equivalent is: 131
___________  22. Its Octal equivalent is: 35
___________  23. Its Hexadecimal equivalent is: 1D
___________  24. Its Decimal equivalent is: 29
___________  For the next 6 questions, refer to the 8-bit normalized floating-point number, where the sign bit
is followed by the exponent expressed in 3-bit excess notation. Apr. 7, 2009 3 of 5 SU09 CSE1520-A Test #1 KEY The original 8-bit floating-point number is: 10111110 CSE
25. The sign of the number represented is: (-)  26. The value represented by the mantissa
before the exponent is considered is: 7/8  27. The value represented by the exponent
component is: -1  28. The direction to which the radix should
move from the original position is: Left  29. The fully decoded value represented by
10111110 is: -7/16  Rational number  30. The kind of numbers this notation
represent are: 31. Perform the subtraction, 8 – 6, by preserving addition using the 2's complement notation
with minimum required bits. What is the result represented as a decimal value? Show all
steps for full marks. 
-6 = +8
+(-6) 01000 (+8)
00110 (+6) => + 11010
+6 to -6 Apr. 7, 2009 (+8)
= Add two numbers &
Truncate Extra bit. 4 of 5 00010 = +2 Final Result SU09 CSE1520-A Test #1 KEY Part C: Short Answers – Use only the space provided. [15 Marks]
32. MS Excel stores all dates and times as ______.  CSE
33. Computation provided by Excel that can be incorporated into a formula is called a(n) ____. 
function 34. Which format type in MS Excel aligns the data to the left by default? 
Text (also accept "label") 35. Name two types of "literal" data that can be entered in to an Excel worksheet. 
a. label/text/string b. number/numeric 36. In Excel, what is a "range"?  One or more contiguous cells 37. Name an example of an "information system" as defined by Dale and Lewis.  Excel (or any software designed to aid the organization and analyses of data.) 38. Identify the two components that make up a typical function expression in a formula. 
The function name e.g., SUM, and the argument (list) e.g. =SUM(A1:A10)
39. Describe the process involved in an "what-if analysis".  A what-if analysis involves modifying values that represent assumptions to see how those changes
affect related data. 40. Times New Roman and Courier represent two distinct kinds of fonts. What is the basis of the
distinction?  Times New Roman is a proportional font where characters takes only as much horizontal
space as required; Courier is a mono-spaced fonts where characters take up exactly the same width on the page. Apr. 7, 2009 5 of 5 ...
View Full Document
- Summer '09
- Binary numeral system, Decimal, Numeral system