ITEC 1010 – Section M – Winter 2000

Midterm Exam Solutions

Contents

Part A – Multiple Choice Questions ( “a” exam | “b” exam )

Part B – Excel

Part C – HTML

Part A – “a” exam

1. b (INFOSYS-1-11)  A software sales office is given a specific objective of contacting at least 50 Apple computer users each day.  This objective can be considered a(n) ________.

2. a (INFOSYS-1-9)  In Figure 1.9, payroll checks can be considered a(n) _______________.

3. b (INFOSYS-1-6)  In Figure 1.2, Box 1 represents _________  and Box 2 represents ____________.

4. b (INFOSYS-1-9)  If a checking account was viewed from a systems perspective, which of the following would be considered an input?

5. c (INFOSYS-1-9)  If a checking account was viewed from a systems perspective, which of the following would be considered feedback?

6. b (INFOSYS-1-13)  System models are used because ________.

7. b (INFOSYS-1-14)  The following figure represents a ________ model.

8. c (INFOSYS-1-14)  Figure 1.6 represents a ___________ type of model.

9. d (INFOSYS-1-17)  The computer equipment used to perform input, processing and output activities is called _________.

10. a (INFOSYS-1-18)  The ________ is the world's largest network.  A(n) ________ uses this technology within a specific organization.

11. c (INFOSYS-2-43)  The heavy dark line labeled 'A' in Figure 2.1 represents the _________________.

12. b (INFOSYS-2-44)  How is a contemporary information system related to a firm's value-added processes?

13. a (INFOSYS-2-45)  Upstream management often includes:

14. c (INFOSYS-2-46)  Empowerment can result in ________________.

15. c (INFOSYS-2-47)  The Bristol Brisket Company is organized around its two products, pork barbecue and beef brisket. Each unit has separate organizational functions (such as accounting, marketing, and et cetera). Its organizational structure is _____.

16. d (INFOSYS-2-48)  Figure 2.5 shows a _______________ organizational structure.

17. a (INFOSYS-2-48)  The major understandings and assumptions shared by those working within an organization are called ___________________.

18. b (INFOSYS-2-48)  A drawback in multidimensional organizational structure-based environments is that ___________________.

19. c (INFOSYS-2-49)  Follow-up training provided to users of an new decision support system is an example of the ____________ part of the change model.

20. b (INFOSYS-2-49)  One of the hardest tasks involved with bringing information systems into an organization is _____________.

21. c (INFOSYS-3-87)  A ___________ consists of the instruction phase and the execution phase of an instruction.

22. b (INFOSYS-3-89)  The _________ is the number of bits the CPU can process simultaneously while the __________ is how many bits can be simultaneously moved between connected devices.

23. b (INFOSYS-3-90)  Moore's law states that physical densities on a single chip will double every ________.

24. b (INFOSYS-3-91)  The idea of reducing the number of microcode instructions built into a chip is known as _____________.

25. a (INFOSYS-3-93)  RAM is _____________ and _______________.

26. c (INFOSYS-3-96)  _______ is represented by Figure 3.7.

27. b (INFOSYS-3-97)  To access a specific piece of information, _________ are usually faster than ________.

28. a (INFOSYS-3-100)  Once data has been recorded on a _______________ drive, it can be repeatedly accessed but not altered.

29. d (INFOSYS-3-103)  Which of the following storage devices has the highest capacity:

30. c (INFOSYS-3-110)  Most computers today have a(n) _______________ output display.

31. b (INFOSYS-4-139)  If general ledger software were classified by software type and sphere of influence, it would be considered _____________________.

32. c (INFOSYS-4-139)  Operating systems such as ESA/370 and MVS/ESA are found on _________ computers.

33. d (INFOSYS-4-142)  Which of the following is not a common activity performed by the operating system?

34. b (INFOSYS-4-142)  In Figure 4.2, the box labeled 'A' would represent ______ and the box labeled 'B' would represent ________.

35. b (INFOSYS-4-144)  ___________ refers to the idea that application programs can be isolated from system hardware and remain insulated from hardware changes.

36. d (INFOSYS-4-145)  Virtual memory allocates hard disk space to supplement the immediate, functional memory capacity of ___________.

37. a (INFOSYS-4-146)  ____________ means that several parts of the same application can work simultaneously.

38. d (INFOSYS-4-146)  A computer system that can smoothly manage the addition of another concurrent user exhibits ___________.

39. c (INFOSYS-4-146)  Figure 4.4 demonstrates how paging or _________ is implemented in a computer system.

40. c (INFOSYS-4-155)  Which of the following is an example of a utility program:

41. a (INFOSYS-5-190)  A key element of most organizations' information systems is the  ___________.

42. a (INFOSYS-5-191)  In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n) __________.

43. b (INFOSYS-5-191)  In Figure 5.1, Label 'C' represents ____________ in the hierarchy of data.

44. d (INFOSYS-5-192)  In a database, key fields are used to ___________.

45. c (INFOSYS-5-194)  If the accounting department kept a file that contained Jane Doe's address and the marketing department kept its own file that also contained Ms. Doe's address, _____________ would exist.

46. c (INFOSYS-5-195)  A key advantage of using a DBMS is _____________.

47. a (INFOSYS-5-197)  A DBMS is primarily a(n) ____________________.

48. b (INFOSYS-5-197)  Currently, most businesses use a ________________ for data management.

49. b (INFOSYS-5-200)  A schematic modeling technique used in relational database design is a(n)_______.

50. a (INFOSYS-5-204)  Projecting and joining are done in ____________.

51. b (INFOSYS-6-242)  In Figure 6.1, what does the arrow labeled 'A' represent?

52. c (INFOSYS-6-246)  A ____________ can be considered a microwave station placed in space.

53. a (INFOSYS-6-248)  A(n) _______ signal is transmitted by a computer while a(n) ________ signal is transmitted across a traditional phone line.

54. c (INFOSYS-6-248)  Infrared transmission relies on ________ for signal transmission.

55. b (INFOSYS-6-249)  If an organization needs to transmit several signals over the same communications medium, a ________ may be required.

56. a (INFOSYS-6-249)  The devices marked 'A' and 'B' on Figure 6.10 are _______.

57. d (INFOSYS-6-251)  Another name for standard telephone lines is ___________.

58. c (INFOSYS-6-253)  A private branch exchange (PBX) manages _____________ communication.

59. b (INFOSYS-6-259)  Figure 6.14 shows a __________ network topology

60. b (INFOSYS-6-266)  IBM's communication protocol is called ____________.

Part B – “b” exam

1. a (INFOSYS-1-9)  In Figure 1.9, payroll checks can be considered a(n) _______________.

2. b (INFOSYS-1-11)  A software sales office is given a specific objective of contacting at least 50 Apple computer users each day.  This objective can be considered a(n) ________.

3. b (INFOSYS-1-9)  If a checking account was viewed from a systems perspective, which of the following would be considered an input?

4. b (INFOSYS-1-6)  In Figure 1.2, Box 1 represents _________  and Box 2 represents ____________.

5. b (INFOSYS-1-13)  System models are used because ________.

6. c (INFOSYS-1-9)  If a checking account was viewed from a systems perspective, which of the following would be considered feedback?

7. c (INFOSYS-1-14)  Figure 1.6 represents a ___________ type of model.

8. b (INFOSYS-1-14)  The following figure represents a ________ model.

9. a (INFOSYS-1-18)  The ________ is the world's largest network.  A(n) ________ uses this technology within a specific organization.

10. d (INFOSYS-1-17)  The computer equipment used to perform input, processing and output activities is called _________.

11. b (INFOSYS-2-44)  How is a contemporary information system related to a firm's value-added processes?

12. c (INFOSYS-2-43)  The heavy dark line labeled 'A' in Figure 2.1 represents the _________________.

13. c (INFOSYS-2-46)  Empowerment can result in ________________.

14. a (INFOSYS-2-45)  Upstream management often includes:

15. d (INFOSYS-2-48)  Figure 2.5 shows a _______________ organizational structure.

16. c (INFOSYS-2-47)  The Bristol Brisket Company is organized around its two products, pork barbecue and beef brisket. Each unit has separate organizational functions (such as accounting, marketing, and et cetera). Its organizational structure is _____.

17. b (INFOSYS-2-48)  A drawback in multidimensional organizational structure-based environments is that ___________________.

18. a (INFOSYS-2-48)  The major understandings and assumptions shared by those working within an organization are called ___________________.

19. b (INFOSYS-2-49)  One of the hardest tasks involved with bringing information systems into an organization is _____________.

20. c (INFOSYS-2-49)  Follow-up training provided to users of an new decision support system is an example of the ____________ part of the change model.

21. b (INFOSYS-3-89)  The _________ is the number of bits the CPU can process simultaneously while the __________ is how many bits can be simultaneously moved between connected devices.

22. c (INFOSYS-3-87)  A ___________ consists of the instruction phase and the execution phase of an instruction.

23. b (INFOSYS-3-91)  The idea of reducing the number of microcode instructions built into a chip is known as _____________.

24. b (INFOSYS-3-90)  Moore's law states that physical densities on a single chip will double every ________.

25. c (INFOSYS-3-96)  _______ is represented by Figure 3.7.

26. a (INFOSYS-3-93)  RAM is _____________ and _______________.

27. a (INFOSYS-3-100)  Once data has been recorded on a _______________ drive, it can be repeatedly accessed but not altered.

28. b (INFOSYS-3-97)  To access a specific piece of information, _________ are usually faster than ________.

29. c (INFOSYS-3-110)  Most computers today have a(n) _______________ output display.

30. d (INFOSYS-3-103)  Which of the following storage devices has the highest capacity:

31. c (INFOSYS-4-139)  Operating systems such as ESA/370 and MVS/ESA are found on _________ computers.

32. b (INFOSYS-4-139)  If general ledger software were classified by software type and sphere of influence, it would be considered _____________________.

33. b (INFOSYS-4-142)  In Figure 4.2, the box labeled 'A' would represent ______ and the box labeled 'B' would represent ________.

34. d (INFOSYS-4-142)  Which of the following is not a common activity performed by the operating system?

35. d (INFOSYS-4-145)  Virtual memory allocates hard disk space to supplement the immediate, functional memory capacity of ___________.

36. b (INFOSYS-4-144)  ___________ refers to the idea that application programs can be isolated from system hardware and remain insulated from hardware changes.

37. d (INFOSYS-4-146)  A computer system that can smoothly manage the addition of another concurrent user exhibits ___________.

38. a (INFOSYS-4-146)  ____________ means that several parts of the same application can work simultaneously.

39. c (INFOSYS-4-155)  Which of the following is an example of a utility program:

40. c (INFOSYS-4-146)  Figure 4.4 demonstrates how paging or _________ is implemented in a computer system.

41. a (INFOSYS-5-191)  In a relational database, the customer record contains information regarding the customer's last name. The last name is a(n) __________.

42. a (INFOSYS-5-190)  A key element of most organizations' information systems is the  ___________.

43. d (INFOSYS-5-192)  In a database, key fields are used to ___________.

44. b (INFOSYS-5-191)  In Figure 5.1, Label 'C' represents ____________ in the hierarchy of data.

45. c (INFOSYS-5-195)  A key advantage of using a DBMS is _____________.

46. c (INFOSYS-5-194)  If the accounting department kept a file that contained Jane Doe's address and the marketing department kept its own file that also contained Ms. Doe's address, _____________ would exist.

47. b (INFOSYS-5-197)  Currently, most businesses use a ________________ for data management.

48. a (INFOSYS-5-197)  A DBMS is primarily a(n) ____________________.

49. a (INFOSYS-5-204)  Projecting and joining are done in ____________.

50. b (INFOSYS-5-200)  A schematic modeling technique used in relational database design is a(n)_______.

51. c (INFOSYS-6-246)  A ____________ can be considered a microwave station placed in space.

52. b (INFOSYS-6-242)  In Figure 6.1, what does the arrow labeled 'A' represent?

53. c (INFOSYS-6-248)  Infrared transmission relies on ________ for signal transmission.

54. a (INFOSYS-6-248)  A(n) _______ signal is transmitted by a computer while a(n) ________ signal is transmitted across a traditional phone line.

55. a (INFOSYS-6-249)  The devices marked 'A' and 'B' on Figure 6.10 are _______.

56. b (INFOSYS-6-249)  If an organization needs to transmit several signals over the same communications medium, a ________ may be required.

57. c (INFOSYS-6-253)  A private branch exchange (PBX) manages _____________ communication.

58. d (INFOSYS-6-251)  Another name for standard telephone lines is ___________.

59. b (INFOSYS-6-266)  IBM's communication protocol is called ____________.

60. b (INFOSYS-6-259)  Figure 6.14 shows a __________ network topology

Part B – Excel

1.

Cell

Formula

Fill to…

 

C8

=B1

 

 

D8

=C8 + $B$2

H8

 

B9

=B3

 

 

B10

=B9 + $B$4

B14

 

C9

=PMT($B9 / 12, $B$5 * 12, -C$8)

H14

 

2.

Cell

Formula

Fill to…

 

E3

=sum(B3:D3)

E5

 

F3

=E3 * 1.10

F5

 

H3

=if(G3-F3 >= 0, G3 – F3, “off target”)

H5

 

B6

=sum(B3:B5)

G6

3.

 

Part C – HTML

Click here and then “view source”