Mississippi State University
MIS 307 SPRING 2022 CHAPTER 1-4 UNIT 1 EXAM KEY
MULTIPLE CHOICE (Answer on green scantron with no. 2 pencil)
1) ________ were developed to make systems developers' work easier and mor
...
Mississippi State University
MIS 307 SPRING 2022 CHAPTER 1-4 UNIT 1 EXAM KEY
MULTIPLE CHOICE (Answer on green scantron with no. 2 pencil)
1) ________ were developed to make systems developers' work easier and more consistent.
A) Data analysis tools
B) Computer-aided software engineering (CASE) tools
C) Software designing tools
D) Modeling tools
2) _______________ is a systems development approach characterized by short term deliverables
to the customer.
A) Agile systems development
B) Supply chain management systems development
C) Analytical processing systems development
D) Customer relationship management systems development
3) Which of the below is a traditional methodology used to develop, maintain, and replace
information systems?
A) Prototyping
B) OOAD
C) RAD
D) SDLC
4) What is the first phase in the Systems Development Life Cycle?
A) Analysis
B) Design
C) Planning
D) Procedure
5) Which of the below is NOT a true statement regarding the SDLC?
A) It is a highly linked set of phases whose products feed the activities in subsequent phases.
B) The different phases are clearly defined.
C) The relationships between phases are well specified.
D) It is a rapid method to prototype and develop an application.
6) As the _________, Barbara has the primary responsibility to articulate the business process to the
systems analyst for design of the new software development project.
A) Chief information officer
B) Primary user of the system
C) Methodology specialist
D) Business analyst
7) ________ is/are the property that occurs when entity types or object classes are arranged in a
hierarchy and each entity type or object class assumes the attributes and methods of its ancestors,
that is, those higher up in the hierarchy.
A) Inheritance
B) Objects
C) Participatory design
D) Object-oriented analysis and design
8) ________ is the practice of turning over responsibility of some to all of an organization's
information systems applications and operations to an outside firm.
A) Outsourcing
B) Reuse
C) Nearshoring
D) Time to market
9) Which firm is best known for its Enterprise Resource Planning software solution? Hint: In class, I
mentioned that Ole Miss uses this solution.
A) SAP AG
B) Oracle
C) Microsoft
D) Google
10) Why is open-source software different than the other types of software?
A) Companies make money by offering maintenance contracts.
B) It is available via the Internet.
C) The source code is free.
D) Only major corporations offer it.
11) When an organization’s own IT personnel develops and manages the software system for their
organization it is referred to as being _____________?
A) On Prim
B) Prepackaged software
C) Off the shelf
D) Open source
12) Which of the following is a characteristic of off-the-shelf software?
A) The Code is available to see, copy, and edit freely
B) No licensing fee
C) The software is generally not highly customizable
D) It is developed by a world wide collaborative community of coders
13) Salesforce.com is an example of ___________.
A) IT service firms
B) in-house developers
C) cloud computing
D) ERP
14) ________ refers to the use of previously written software resources, especially objects and
components, in new applications.
A) Reorganization
B) Reuse
C) IT vendor support
D) Software
15) Which of the following is an organization that hosts and runs computer applications for other
companies, typically on a per use or license basis?
A) ERP firm
B) Cloud computing application provider
C) The Internet
D) A software analyst
16) Which of the following is NOT a part of the project management process?
A) Planning
B) Initiating
C) Executing
D) Adjoining
17) ________ is a controlled process of initiating, planning, executing, and closing down a project.
A) System design
B) System analysis
C) Project scheduling
D) Project management
18) In class I referred to this term that describes when a company is investing in research and
development for a tech product but is still in the process of trouble shooting the problems of the
product before introducing it to the market.
A) Bleeding Edge
B) Cutting Edge
C) Mass Market
D) Protocol customization
19) During ________, the project manager performs several activities to assess the size, scope, and
complexity of the project and to establish procedures to support subsequent activities.
A) Project bidding
B) Project development
C) Project initiation
D) Project delivery
20) What is the next step taken after project initiation?
A) Project bidding
B) Project planning
C) Project execution
D) Project development
21) ________ is the process of dividing the project into manageable tasks and logically ordering
them to ensure a smooth evolution between tasks.
A) Work breakdown structure
B) Task breakdown structure
C) Project breakdown structure
D) Management breakdown structure
22) A Gantt chart is the graphical representation of a project that shows each task as a ________ bar
whose length is proportional to its time for completion. Hint: I referred to this in class a glorified “To
Do List”.
A) Vertical
B) Linear
C) Curve
D) Horizontal
23) The term ________ refers to concept that an application will be easily viewable and workable on
a variety of devices such as laptops, mobile phones, or tablets.
A) Scope
B) Scalability
C) Inheritance
D) Scrum
24) A ___________ refers to a sequence of task activities that have to be completed before the next
set of tasks are undertaken.
A) Duration
B) Order
C) Sequence
D) Critical Path
25) ________ refers to the amount of time a task can be delayed without delaying the early start of
any immediately following tasks.
A) Response time
B) Lead time
C) Shortest time
D) Slack time
26) Georgia was contacted by the CEO to research if adding a new data center makes sense for the
organization from an economic stand point. Georgia agreed to perform a(n) ________.
A) A systems service request
B) System enhancement study
C) Feasibility study
D) End product
27) The term __________ refers to a set of software components that link an entire organization.
A) Information Silo
B) Departmental Applications
C) Open Source
D) Enterprise systems
28) Which of the following is a characteristic of top management when choosing an IS project
selection?
A) Departmental level focus
B) Bottom – Up Collaboration
C) Enterprise wide consideration
D) Individual level focus
29) Which group is best suited for determining cross-functional and cross-departmental needs of an
organization?
A) Business unit
B) Steering committee
C) Functional manager
D) Development group
30) Which of the following groups does NOT identify a bottom-up development project?
A) Business units
B) Managers
C) Top Management
D) IS development group
EXCEL APPLIED SECTION (Perform the tasks on the template in Blackboard)
1. (1 point) Orientate cell A2 to a 47 degree angle.
2. (1 point) Apply the Title Cell Style to A5:G6. Apply the Heading 3 cell style to A7:G7. Apply the Total
cell Style to A20:G20.
3. (1 point) Apply formatting such that a fixed dollar sign is applied to cells F8:G8 and F20:G20. Apply
formatting such that a floating dollar sign is applied to cells F21:G21.
4. (1 point) In cell G8, enter a formula to calculate commission that will:
a. multiply the receipt value in cell F8 by its appropriate Complex Commission Rate in
cell B2.
b. Use absolute referencing in the above formula to lock in the Complex Commission
Rate’s (or B2’s) row reference.
c. Use the fill handle to copy the formula in cell G8 down to cell G19 such that the
formatting is not copied down along with the formula.
5. (1 point) Total the cells F20:G20 for the Receipts and Commissions columns respectively using an
appropriate function.
6. (1 point) Average the cells F21:G21 for the Receipts and Commissions columns using an appropriate
function, and edit it to not include the total row.
7. (1 point) Best fit the width so that the numbers are visible in cell G20.
8. (1 point) Write a conditional formatting rule in cells F8:F19 such that if Receipts are below $60,000.00
the background of the cell will be formatted as red with a white font.
9. (1 point) Change the name of the Sheet1 tab to Commissions.
10. (1 point) Change the color of the sheet tab to Green.
11. (1 point) Delete the tabs Sheet2 and Sheet3.
12. (1 point) Add a second line to cell B7 and C7 such that the word “Name” is on the second line of the
cell.
13. (1 point) Add a header that reads the name of the sheet and places it in the center portion of header.
14. (1 point) On the left side of the header area add the code that displays the page number and total
number of pages automatically, so that it displays Page 1 of 1.
15. (1 point) In cell A28, type whether this Excel lesson was a refresher, you learned something new, or
you learned several things that were new to you. (I’m trying to get a feel for what the class’ experience
level is with Excel)
[Show More]