chapter 1-6 using mis-gary

Chapter 1 Using MIS

Question 1

The process of automation is a process of moving work from ________.

Selected Answer: human side to computer side

Answers: procedures to people

processes to procedures

human side to computer side

instructions to actors

Question 2 1 out of 1 points

Which of the following statements is true of business users who administer the

development of information systems?

Selected

Answer:

They should take an active role in the system's development.

Answers: They should take an active role in the system's development.

It is mandatory that they hold a degree in database management.

They should refrain from specifying the system's requirements.

When the system fails, they must refrain from performing tasks

related to system recovery.


The CEO of a large company asks the sales manager to report the sales figures of

the previous quarter. The manager immediately sends her the list of products

sold in the previous quarter. These details do not qualify as good information

because they are ________.

Selected Answer: not timely

Answers: not relevant

not timely

too narrow in scope

too expensive


You are looking to buy a home that costs less than $700,000, but your real estate

agent keeps sending you fliers for homes that cost $1,000,000 or more. This

information is likely to be useless because it is ________.

Selected Answer: irrelevant

Answers: inaccurate

not reliable

late

irrelevant


Caroline asks her secretary to send information on the meetings that she needs to

attend next month. Her secretary, Joanne, provides her with the details

immediately, but leaves out certain additional details that are irrelevant to

Caroline's requirements. Which of the following statements is true about this

scenario?

Selected

Answer:

The information that Joanne gave was accurate and sufficient for

Caroline's purpose.

Answers: Joanne provided adequate and timely information, but the

information was of no value to Caroline.


Caroline's purpose.

The information that Joanne provided was partly good as it was

timely but insufficient.

The information that Caroline obtained through Joanne was not

timely or worth its cost.


The most important skill for effective collaboration is to be able to give and

receive critical feedback.

Selected Answer: True

Answers: True

False


Which of the following is categorized as a nonroutine cognitive skill?

Selected Answer: computer programming

Answers: computer programming

systems thinking

tax accounting

marketing knowledge


Which of the following is the least critical aspect of good information?

Selected Answer: data accuracy

Answers: timeliness of data

data accuracy

relevance of data

additional data


________ states that the number of transistors per square inch on an integrated

chip doubles every 18 months.

Selected Answer: Moore's Law

Answers: Newton's Law

Faraday's Law

Moore's Law

Nielsen's Law


The CEO of an organization asks the human resources manager to send

information about the rate of employee turnover in the organization for the last

quarter. The manager sends the salary details of new hires during this period.

This information is likely to be of little use to the CEO because it is ________.

Selected Answer: irrelevant

Answers: too expensive

not timely

inaccurate

irrelevant

Which of the following best describes data?

Selected Answer:

recorded facts or figures

Answers: processed information

information presented in a meaningful context

recorded facts or figures

knowledge derived from facts or figures


Moore's Law predicts that the price to performance ratio of computers will double once

in eighteen months.

Selected Answer: False

Answers: True

False


Which of the following is a low-tech information system?

Selected Answer:

a file of email addresses stored in an email program

Answers:

a file of email addresses stored in an email program

a decision support system that analyzes multiple variables

an inventory tracking system that produces reports every 24 hours

a customer support system that keeps track of product issues


Which of the following is considered information rather than mere data?

Selected Answer:

the return on investment of an advertising campaign

Answers:

the return on investment of an advertising campaign

a list of property prices in a neighborhood

the price of a company's shares on a given day

the total number of students in a school


Information systems become a waste of time and money when users work with

inaccurate data.


Answers: True

False


Obtaining or developing new programs is more difficult than ordering additional

hardware.


Answers: True

False


A good password is one that contains the user's name or company name.


Answers: True

False


Identify how information technology differs from information systems.

Selected

Answer:

One can buy information technology, but not information systems.

Answers: Information systems are a subset of information technology.

Unlike information systems, information technology is used for

producing information.

People are an important component of information technology, but not

of information systems.

One can buy information technology, but not information systems.


Information technology is an assembly of hardware, software, data, procedures, and

people that produces information.


Answers: True

False


Caroline asks her secretary to send information on the meetings that she needs to attend

next month. Her secretary, Joanne, provides her with the details immediately, but leaves

out certain additional details that are irrelevant to Caroline's requirements. Which of the

following statements is true about this scenario?

Selected

Answer:


Caroline's purpose.

Answers:


Caroline's purpose.

The information that Caroline obtained through Joanne was not timely

or worth its cost.

The information that Joanne provided was partly good as it was timely

but insufficient.

Joanne provided adequate and timely information, but the information

was of no value to Caroline.

Chapter 2 - Using MIS Question 1

1 out of 1 points

The facility manager of an insurance company makes decisions on the monthly purchase

of office supplies. This is an example of an operational decision.


Answers: True

False


Project teams should document project results and information for future teams. Which

of the following is the project management phase in which the teams perform this

function?

Selected Answer:

finalizing

Answers: starting

planning

finalizing

doing


An organization defines the rules that govern a project that it needs to undertake and the

responsibilities of the project team. The project is in the ________ phase of project

management.

Selected Answer:

starting

Answers: finalizing

doing

starting

planning

Question 4

1 out of 1 points

The fundamental purpose of the starting phase of a project is ________.

Selected Answer:

setting the ground rules for the project and team

Answers: accomplishing the project tasks effectively

determining tasks and dependencies

setting the ground rules for the project and team

managing tasks and budgets of the project


Only one user at a time can open Google Drive documents for editing.


Answers: True

False


The task lists of SharePoint are industrial-strength.


Answers: True

False


All text messages that the user sends via Lync are automatically recorded and stored in

the user's email folder.


Answers: True

False


Which of the following statements is true about working with Google Drive?

Selected

Answer:

Google tracks document revisions, with brief summaries of changes

made.

Answers: Documents are stored on the user's personal computer.

Multiple users are not allowed to simultaneously see and edit

documents.

Google tracks document revisions, with brief summaries of changes

made.

Google accounts are not necessarily required to edit documents.


________ communication occurs within a team when all team members meet at the

same time.

Selected Answer:

Synchronous

Answers: Sequential

Virtual

Synchronous

Unidirectional


Which of the following decisions is least likely to involve collaboration?

Selected

Answer:

How much of product A should be ordered from vendor B?

Answers: Should our company acquire company A?

What type of relationship should the company maintain with company

A?

How much of product A should be ordered from vendor B?

What products should we include in the new product line?

Chapter 3 - Using MIS Question 1

1 out of 1 points

A furniture dealer offering a wide variety of designs to premium customers exclusively

is following an industry-wide cost leadership strategy.


Answers: True

False


An inventory of raw materials is an example of a repository.


Answers: True

False


According to Porter's five forces model, in which of the following examples would

rivalry be considered as a weak force affecting the market?

Selected Answer:

Cancer drug manufacturers

Answers: packaged food manufacturers

Cancer drug manufacturers

book sellers

used car dealers


Locking in customers by making it difficult or expensive for customers to move to

another product is called establishing high ________.

Selected Answer:

switching costs

Answers: value differentiation

switching costs

entry barriers

product standards


In the value chain, the primary activity of customer service is concerned with inducing

buyers to purchase the product and providing a means for them to do so.


Answers: True

False


Which of the following principles of competitive advantage is related to process

implementations?

Selected Answer:

locking in buyers

Answers:

locking in buyers

enhancing services

differentiating services

creating new products


Which of the following is a primary activity in the value chain?

Selected Answer:

receiving and distributing inputs to the product

Answers: negotiating prices with vendors

receiving and distributing inputs to the product

setting up contractual arrangements with various suppliers

finding suitable vendors to supply raw materials


An organization implements an information system to optimize its supply chain. The

system helps the organization decrease wastages. Hence, the system provides a

competitive advantage to the organization. Here, the information system helped the

organization achieve competitive advantage by ________.

Selected Answer:

reducing costs

Answers:

reducing costs

locking in customers

locking in suppliers

differentiating the products


Streamtech, a manufacturer of automobiles, recently received a patent for an unmanned

search boat. By doing this, Streamtech has ________.

Selected Answer:

created an entry barrier

Answers: locked in its suppliers

created an entry barrier

introduced product differentiation

reduced the cost of operations


In the next ten years, the ________ is most likely to change.

Selected Answer:

pace of integration of new technology

Answers:

pace of integration of new technology

relationship between competitive advantage and IS

model of business strategy

competitive advantage mechanism


Which of the following factors determines the structure, features, and functions of an

information system used in a company?

Selected Answer:

the competitive strategy

Answers: the technology used by competitors

the competitive strategy

the size of the company

the value of its brands


The difference between the value that an activity generates and the cost of the activity is

called the ________.

Selected Answer:

margin

Answers: revenue

value-addition

margin

turnover


________ argues that firms should create new, more efficient business processes that

integrate the activities of all departments involved in a value chain.

Selected Answer:

Business process design

Answers:

Business process design

Product differentiation model

Market differentiation model

Business process reengineering


A ________ is a collection of something, such as data and raw materials.

Selected Answer:

repository

Answers: linkage

cache

repository

value chain


Focused differentiation refers to providing a better product or service within an industry

segment.


Answers: True

False


Which of the following principles of competitive advantage is related to process

implementations?

Selected Answer:

differentiating products

Answers:


differentiating products

creating new products

enhancing services


In the context of Porter's five forces model, the bargaining power of suppliers is a weak

force when considering the example of students purchasing gasoline.


Answers: True

False

Question 8

1 out of 1 points

According to Porter's model of business activities, interactions across value activities are

called ________.

Selected Answer:

linkages

Answers: cross-functionalities

support activities

linkages

triggers


In the inbound logistics activity of a value chain, the manufacturer receives, stores, and

disseminates inputs to a product.


Answers: True

False


Hueblue Software, an application provider to the gaming industry, decided to increase

its portfolio by developing motion-control-enabled games for the mobile gaming

industry. In this scenario, which competitive strategy is Hueblue Software

implementing?

Selected Answer:

product differentiation

Answers: reduction of cost


product differentiation

establishment of alliances

Chapter 4 - Using MISQuestion 1 1 out of 1 points

Mobile systems offer the potential of just-in-time data, which is data delivered to the

user at the precise time it is needed.


Answers: True

False


Which of the following is a computer architecture and instruction set that is designed for

portable devices such as phones and tablets?

Selected Answer:

ARM

Answers:

ARM

ASCII

Unix

Mac OS


Mobile applications can share their device with other mobile applications.


Answers: True

False


Mac OS and iOS applications are constructed using Java.


Answers: True

False


Programmers cannot alter or add to an open source code.


Answers: True

False


A spreadsheet program is an example of ________.

Selected Answer:

horizontal-market application software

Answers:

horizontal-market application software

a firmware

vertical-market application software

an operating system

Question 7

1 out of 1 points

Which of the following statements is true of firmware?

Selected Answer:

Users do not need to load firmware into the device's memory.

Answers: The software is coded differently from other software.

Firmware is the same as cache memory.

Users do not need to load firmware into the device's memory.

Firmware cannot be changed or upgraded.


A 64-bit, dual processor is needed to effectively utilize more than 4 GB of main

memory.


Answers: True

False


A CPU is an example of an input device.


Answers: True

False


Quad-processor computers have two CPUs.


Answers: True

False

Chapter 5 - Using MIS

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of

the relationship and that the number of entities on each side can be different.


Answers: True

False


Every table in a normalized database has a ________.

Selected Answer:

single theme

Answers:

single theme

foreign key

one-to-one relationship between entities

specialized query format


The database administrator of an organization constantly manages the processing rights

and responsibilities of employees. This is an example of a(n) ________ task.

Selected Answer:

operational

Answers: recovery

operational

development

adaptation


A database application is a collection of forms, reports, queries, and application

programs that serves as an intermediary between users and database data.


Answers: True

False


________ are the final judges as to what data the database should contain and how the

records in that database should be related to one another.

Selected Answer:

Users

Answers:

Users

Administrators

Designers

Developers


To modify an existing table, a developer can open the metadata form for that table and

add a new row of metadata.


Answers: True

False


A DBMS and database mean the same thing and are synonymous terms that can be used

interchangeably.


Answers: True

False


When you modify or delete data present in a database, you are ________.

Selected Answer:

processing the database

Answers:

processing the database

forming a data model

simplifying the data structure

creating a new database


The purpose of a database is to keep track of things that involve a single theme.


Answers: True

False


A database is best described as a collection of unrelated tables.


Answers: True

False

Chapter 6 - Using MISQuestion 1 1 out of 1 points

Wired LAN connections use a protocol standard called Ethernet to communicate.


Answers: True

False


In cloud computing, resources are said to be "pooled" because organizations ________.

Selected

Answer:

share the same physical hardware through virtualization

Answers: use open source standards that enable users to modify a program's

source code

offer their services to each other free of charge, in a give-and-take

arrangement

share the same physical hardware through virtualization

use the public Internet to create the appearance of a private connection


As DSL signals interfere with telephone signals, DSL data transmission and telephone

conversations cannot occur simultaneously.


Answers: True

False


Which of the following is true about a VPN?

Selected

Answer:

A VPN client software encrypts messages to ensure secure

transmissions.

Answers: A VPN network does not provide users with remote access.

A VPN connection appears as a secure connection, though it is not.

A VPN client software encrypts messages to ensure secure

transmissions.

A VPN connection utilizes private networks instead of the public

network.


The address bar reads "http://www.baron-olufsen.com/" when one visits the Web page of

the luxury brand Baron & Olufsen. This information in the address bar is the ________

of the Web page.

Selected Answer:

URL

Answers: IP address

URL

protocol

email ID


SOAP is a protocol for requesting web services and for sending responses to web

service requests.


Answers: True

False


A URL consists of a protocol followed by a domain name or public IP address.


Answers: True

False


A switch detects the speed that a given device can handle and communicates with it at

that speed.


Answers: True

False


Which of the following TCP/IP application-layer protocols is used to move files over

the Internet and to maintain Web sites?

Selected Answer:

ftp

Answers:

ftp

http

https

smtp


Which of the following refers to the three tiers in the three-tier architecture?

Selected Answer:

user,

server,

and

database

Answers: HTML,

XML, and

JSON

TCP, IP,

and HTTP

user,

server,

and

database

tunnel,

switch,

and

access

point

Access Quiz 1 Question 1

1 out of 1 points

Enforce referential integrity is one of only two options available

when setting a database relationship with another database.


Answers: True

False


________ a database rearranges data and objects in a database to

make its size smaller.

Selected Answer:

Compacting

Answers: Compressing

Backing up

Fragmenting

Compacting


Why would you enforce referential integrity?

Selected

Answer:

So data cannot be entered into a related table until

the data is entered in the primary table

Answers:

So data cannot be entered into a related table until

the data is entered in the primary table

To determine which software to use Excel or

Access

To avoid accidental deletion of macros

To confirm error free data


Alice is working in a database containing the names, service

locations, and services offered by landscapers. She needs to find

landscapers that offer services in the Phoenix area and that

service rare plants. The best way for her to search for this data is

to perform a:

Selected Answer:

Filter by Form.

Answers: Filter by Selection.

Sort Descending.

Filter by Form.

Sort Ascending.


The F2 key puts you in Edit mode when in Access.


Answers: True

False


What is an advantage of using Filter by Form?

Selected

Answer:

The records are also sorted.

Answers: Access automatically saves the results to

storage.

There is no minimum number of records that

can be filtered.

The records are also sorted.

You can use the AND and OR operators.


A field that is defined as a primary key in one table is defined as

a(n) ________ in a related table.

Selected Answer:

foreign key

Answers: referential integrity key

foreign key

primary2 key

relational database

Question 8

0 out of 1 points

How does the Getting Started page help learn about a database?

Selected

Answer:

The Getting Stated page shows how to create

relationships between tables.

Answers: The Getting Stated page explains what to do if

your system crashes.

The Getting Started page links you to

introductory Access videos.

The Getting Started page details how to install

software.

The Getting Stated page shows how to create

relationships between tables.


Information is what is typically entered into a database. Data is

the finished product of the database.


Answers: True

False


A template is a predefined database that can be used to jumpstart

the creation of a database.


Answers: True

False


Enforce referential integrity is one of only two options available

when setting a database relationship with another database.


Answers: True

False


Filter by Selection displays only records that match a criterion

that you select.


Answers: True

False


You can create a Web app from a Web app template from the

Backstage view.


Answers: True

False


A ________ key is the field in the related table that you would

use to connect to the primary key in another table.

Selected Answer:

foreign

Answers: merged

secondary

composite

foreign


SharePoint is an add-on program for Access.


Answers: True

False


You can use Access to create a Web app for sharing data with

others through the Internet.


Answers: True

False


People use databases to store collections of data.


Answers: True

False


When performing a filter by

selection, equals and contains produce the same result.


Answers: True

False


A sort can only list records in a database in a specific numeric

sequence.


Answers: True

False


An Access database can MOST accurately be described as a

structured collection of:

Selected Answer:

objects.

Answers:

objects.

modules.

tables.

records.


1 out of 1 points

A query is a question asked about the data in a database.


Answers: True

False


When creating a multitable query, in the top section of the query

design, you use ________ lines to connect common fields in

related tables.

Selected Answer:

join

Answers: relationship

connection

common field

join


Table modification may be needed after an Excel spreadsheet

has been imported such as:

Selected Answer:

renaming a field.

Answers: updating hyperlinks.

changing the font size.

changing the font type.

renaming a field.


If data from an Excel worksheet is imported into Access and no

column headings exist, the data will import using:

Selected Answer:

Field1, Field2, Field3, etc.

Answers: Access1, Access2, Access3, etc.

Import1, Import2, Import3, etc.

FieldA, FieldB, FieldC, etc.

Field1, Field2, Field3, etc.


Referential integrity should be enforced in a database with

related tables because it:

Selected

Answer:

helps ensure invalid data is not entered into a

table.

Answers: creates a primary key in every table of a

database.

makes the database easier to repair.

helps ensure data is automatically updated.

helps ensure invalid data is not entered into a

table.


Data redundancy may result in errors.


Answers: True

False


The Run command appears as a red exclamation point in Design

view.


Answers: True

False


When using Design view, a query can only be sorted on a single

criteria.


Answers: True

False


A(n) ________ operator, such as the greater than or less than

symbol, can be used in a query criterion to limits the results

produced by the query.

Selected Answer:

comparison

Answers:

comparison

wildcard

delimiter

operand


All Excel spreadsheets are ready to import into an Access

database.


Answers: True

False


1 out of 1 points

It is NOT possible to add a condition to a Totals query.


Answers: True

False


When you use a table field in an expression, Access will

automatically correct any spelling errors in the field name.

Selected Answer: [None Given]

Answers: True

False


Aggregate functions are most commonly used in all of the

following Access objects EXCEPT:

Selected Answer:

macros.

Answers: reports.

tables.

queries.

macros.


Forgetting the colon between a column title and the formula

would give you an invalid syntax error.


Answers: True

False


When creating a calculated field using field names, Access

automatically surrounds the field names with ________.

Selected Answer:

parentheses ( )

Answers:

brackets [ ]

parentheses ( )

braces { }

quotation marks " "


When designing a calculated field, complex formulas can be

created with the:

Selected Answer:

Expression Builder.

Answers: Form Wizard.

Expression Builder.

Table Wizard.

Report Builder.


The order of operations specifies that any exponents are

performed first.


Answers: True

False


When using date data, the date is surrounded by ________.

Selected Answer:

brackets [ ]

Answers: braces { }

parentheses ( )

brackets [ ]

pound signs # #


The Calculated fields in Datasheet view can be edited in the

same way other fields from a table are edited.


Answers: True

False


The Pmt function returns the monthly payment due on a loan.


Answers: True

False

Question 1

1 out of 1 points

When the results of using the COUNT or MAXIMUM aggregate

functions in a query are displayed, they appear in the Total row.


Answers: True

False


The arguments to a function are enclosed in:

Selected Answer:

parentheses.

Answers: braces.

parentheses.

brackets.

single-quotation marks.


An expression or integer value specifying total number of

payments in a loan is the ________ argument in the PMT

function.

Selected Answer:

num_periods

Answers: rate

present_value

future_value

num_periods


A ________ query is used to summarize data organized by field

values.

Selected Answer:

grouping

Answers: digest

hierarchical

summary

grouping


Which aggregate function would be used to find the least valued

item in a column?

Selected Answer:

MINIMUM

Answers: LOWEST

COUNT

MINIMUM

LEAST


A query with a Total row is the same as a totals query.


Answers: True

False


Which of the following is NOT an Expression Builder

component used when constructing an expression?

Selected Answer:

Expression Arguments

Answers: Expression Categories

Expression Arguments

Expression Elements

Expression Values


Which of the following is NOT a Pmt function argument?

Selected Answer:

loan_payment

Answers: present_value

rate

loan_payment

future_value


It is NOT possible to add a condition to a Totals query.


Answers: True

False


The SUM aggregate function can work with Date/Time data.


Answers: True

False


Sum, Count, and Avg are all examples of aggregate functions.


Answers: True

False


Which of the following is NOT a total row option?

Selected Answer:

Pmt

Answers: Where

Pmt

Avg

Count


A(n) ________ is used to change settings such as formatting and

captions.

Selected Answer:

property sheet

Answers: dialog box

argument menu

parameter list

property sheet


Sum, Avg, and Max are examples of ________ functions that are

used to evaluate entire columns of data.

Selected Answer:

aggregate

Answers: number

summary

compound

aggregate


Multiple arguments in a function are separated by:

Selected Answer:

commas.

Answers:

commas.

colons.

spaces.

semicolons.


Calculated fields are created in the Datasheet view of a table.


Answers: True

False


Following the rules for the order of operations, what is the result

of the following expression: 1 + 2 * 5 ^ 2?

Selected Answer:

101

Answers: 121

225

101

51


The Pmt function is BEST suited to determine:

Selected Answer:

the monthly payment on a car loan.

Answers:

the monthly payment on a car loan.

the rate of interest on a car loan.

the due date of a car loan.

the average payment of a car loan.


The future_value argument of the Pmt Function is the amount

that is being borrowed.


Answers: True

False


The present_value argument of the Pmt Function is the amount

owed after the final payment has been made.


Answers: True

False

Wednesday, September


1 out of 1 points

A field can be deleted from a report in either Layout or Design

views.


Answers: True

False


Form view is used to change a form's data and layout.


Answers: True

False


The ________ displays data horizontally across the page.

Selected Answer:

Tabular Layout

Answers: Layout

Design View

Stacked Layout

Tabular Layout


A ________report is a specialized report that comes

preformatted to coordinate with products such as those

manufactured by Avery.

Selected Answer:

mailing label

Answers: value added

mailing label

rapid distribution

mass distribution


When in Layout or Design view, which of the follow is NOT a

form layout tab?

Selected Answer:

Design

Answers: Format

Edit

Layout

Design


You can sort the data in a form by double-clicking a field and

selecting Sort A to Z or Sort Z to A.


Answers: True

False


Which of the following is NOT a view when working with

forms?

Selected Answer:

Tabular

Answers: Form

Tabular

Design

Layout


What type of form displays records in a tabular layout similar to

a table's Datasheet view but has more editing options, such as

adding graphics and buttons, than a datasheet?

Selected Answer:

multiple Items Form

Answers: subform

multiple Items Form

compound form

split Form


Referencing the image above, this form is shown in ________

view.

Selected Answer:

Design

Answers: Layout

Format

Design

Form


Which database object is used to add data into or edit data in a table?

Selected Answer:

form

Answers:

form

report

query

macro