CIS300 Wiley Review

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

An entity is the same thing as a field. True False

False

Managing data is easier nowadays since there is so much of it. True False

False

The implementation of the Emergency Department Information Exchange database was originally met with __________ from hospitals. A. Enthusiasm B. Acceptance C. Resistance D. A neutral attitude

Resistance

The manufacturing equipment a company purchases is a(n) __________ for a business process. A. Output B. Feedback C. Resource D. Input

Resource

Alignment often fails because business and IT managers have different objectives.

True

AngelList assists startups in the US and the United Kingdom. True False

True

BI can support organizational transformation. True False

True

BI encompasses applications, processes, and technology. True False

True

Baxter is different from existing industrial robots because it is less expensive and safer. True False

True

Big Data predictions come from applying mathematics to huge quantities of data to infer probabilities. True False

True

Databases maximize data independence. True False

True

ERP systems and TPSs function primarily within a single organization. True False

True

Effectiveness focuses on doing the right things. True False

True

Expert systems help doctors diagnose diseases. True False

True

IT has positive and negative impacts on our lives. True False

True

Warby Parker has a social mission, which means they help people in need buy their stylish glasses. True False

True

SQL is the most popular query language used for interacting with ________________.

a database

Sarbanes-Oxley is an example of ________ A. an ethical issue B. a government regulation C. our social responsibility D. customer focus

a government regulation

ConocoPhillips addressed employee resistance to using PLOT by ____________. A. hiring better employees B. decentralizing the monitoring process C. centralizing the monitoring process D. firing those people

centralizing the monitoring process

There are 3 distinct characteristics of Big Data. The collection of social network data is an example of __________. A. Variety B. Vintage C. Velocity D. Volume

Variety

Robots are useful ___________. A. as companions (e.g. cyberpooches) B. only in science fiction (e.g. Terminator) C. for driving cars (e.g. cyberchauffer) D. for handling monotonous tasks (e.g. factory work)

for handling monotonous tasks (e.g. factory work)

Data are scattered throughout organizations. An example of this is ________________. A. customers moving B. human vs. computer languages C. media changing (cassette to CD) D. data hoarding

human vs. computer languages

Big Data _____________ the same thing as large amounts of traditional data.

is NOT or does NOT refer to

MetLife implemented a database system to address its problem with data __________. A. redundancy B. inconsistency C. security D. isolation

isolation

Employee # is the _______ in the Employee file and the _________ in the Class File.

primary key; secondary key

WebMD is a(n) _________ that allows doctors to ___________. A. expert; perform long-distance surgery B. expert; diagnose diseases C. ERP; diagnose diseases D. ERP; perform long-distance surgery

expert; diagnose diseases

Which of the following is a type of societal/political/legal pressure? A. Powerful customers B. Carbon management C. Innovation D. Globalization

Carbon management

If your university has a policy that states you must take a minimum of 12 hours to be considered a full-time student and take no more than 21 hours without special permission, the 21 hours rule is referred to as ____________. A. Mandatory B. Cardinality C. Connectivity D. Optional

Cardinality

Information ______________ utilize information created by others. A. Users B. Producers C. Creators D. Consumers

Consumers

The _________ stage in BPI is characterized by establishing process metrics and monitoring the improved processes. A. Improve B. Analysis C. Measure D. Control

Control

__________ is the result of optimizing operations and supplier processes. A. Productivity B. Differentiation C. Cost reduction D. Quality

Cost reduction

Which of the following is NOT a benefit of PLOT for ConocoPhillips? A. Data variability B. Reduced greenhouse emissions C. Increased production D. Improved revenue

Data variability

The OLPC's experiment with solar-powered tablets took place in _______. A. Bangladesh B. Rural US communities C. Uganda D. Ethiopia

Ethiopia

Data warehouses maintain historical data while data marts are real-time. True False

False

IT increases the number of middle managers. True False

False

The IDC is a linear process. True False

False

The IS Director is the executive who is in charge of the IS function. True False

False

When data are normalized, attributes in the table depend only on the secondary key. True False

False

If your sales team shows a customer's name is "Johnny Smith" but your shipping department says it is "John A. Smith", this is a data __________ issue. A. Isolation B. Redundancy C. Inconsistency D. Security

Inconsistency

________ are materials, services, and information that flow through and are transformed as a result of process activities. A. Outputs B. Resources C. Inputs D. Processes

Inputs

Examination of a problem occurs in the _________________________ phase.

Intelligence

In which stage of the IDC do you examine the problem? A. Intelligence B. Choice C. Design D. Implementation

Intelligence

Why is it so difficult and complex to manage information resources in today's organizations? If you were a CIO, how would you handle these issues?

It is difficult/complex because: 1) Dependence - if they aren't working, the firm can't function 2) Expensive to acquire, operate, and maintain 3) Evolution from IT managed to end user computing a. Who's responsible b. What is IT supposed to do c. What is the right relationship As the CIO: • There isn't a right answer to this, but one option is to discuss the consultative functions of the MIS (e.g. initiate and design strategic IS, manage system integration, education, partnership, managing outsourcing, etc.)

Status access is the latest data available on _____________, often in real time. A. CSF B. KPI C. ERP D. CRM

KPI

Intellectual capital is also called __________. A. Data B. Knowledge C. Wisdom D. Information

Knowledge

On AngelList, a wealthy investor is known as a ____________. A. Backer B. Syndicate C. Carrier D. Lead

Lead

Chevron has used _________, a methodology that combines statistical process analysis with techniques to eliminate waste and improve process flow, since 2006. A. Six Sigma B. SAP C. Nimbus D. Lean Six Sigma

Lean Six Sigma

Which industry is currently using drones as part of its business model? A. Retail B. Automobile C. National defense D. Agriculture

National Defense

When a customer receives a product, this is a(n) ___________ for a business process. A. Resource B. Feedback C. Input D. Output

Output

Which of the following is a decisional role? A. Liaison B. Resource allocator C. Spokesperson D. Analyzer

Resource allocator

____________are the people and equipment that perform process activities.

Resources

______________ analysis is the study of the impact that changes in one or more parts of a decision-making model have on other parts. A. What-if B. Goal-seeking C. Sensitivity D. Market basket

Sensitivity

____________________ analysis is the study of the impact that changes in one or more parts of a decision-making model have on other parts.

Sensitivity

DSS support semistructured and unstructured problems. True False

True

Data governance is implemented through master data management. True False

True

The Emergency Department Information Exchange database was implemented in _________ to help reduce ___________. A. New York; doctor fees B. Washington; Medicaid costs C. New York; Medicaid costs D. Washington; doctor fees

Washington; Medicaid costs

Strategic information systems provide a ____________________ by helping an organization implement its strategic goals and improve its performance and productivity.

competitive advantage

Being a(n) ___________ means you are knowledgeable about information systems and technology. A. web master B. technology guru C. Homo conexus D. informed user

informed user

Thinking about your university, what kinds of issues make it so difficult for the administration to manage data?

• Amount of data increasing - more new students every year, more employees, need to keep all the data on students (transcripts), etc. • Data are scattered - lots of different systems (class management, payment, hospital, registration, etc.) • Data are generated from multiple sources o Internal - grades, paychecks, etc. o Personal - Facebook, memes, etc. o External - government reports (if public), university website, etc. • Data degrade - employees moving, students moving (in-state vs. out-of-state), etc. • Data rot - storing data in less than ideal places (lots of paper for most universities) • Data security - protecting social security numbers, grades • Data quality/integrity - getting student information correct • Diverse systems - most universities probably have many, many systems that need to be maintained • Federal regulation - FERPA, HIPAA

(Excel) Match the following types of error messages that may occur when working with formulas in a worksheet with their respective descriptions. #NAME? #REF! #VALUE! #NUM! A. Wrong argument type or operand B. Invalid cell reference C. Invalid numeric values in a formula or function D. Unrecognized text in a formula

#NAME? - D. Unrecognized text in a formula #REF! - B. Invalid cell reference #VALUE! - A. Wrong argument type or operand #NUM! - . Invalid numeric values in a formula or function

(Excel) What is the proper way to reference Cell D22 on a Worksheet named "My Sheet"? My Sheet'D22' None of the answers provided is correct My Sheet$D$22 'My Sheet'!D22 My Sheet!D22

'My Sheet'!D22

List, describe, and provide a real world example of the five different strategies for competitive advantage.

1) Cost leader - selling at the lowest price; Walmart 2) Differentiation - selling a different product; Porsche 3) Innovation - selling something new; Apple 4) Operational effectiveness - being more efficient; Walmart 5) Customer oriented - treating customers better; Zappos

How could the movie industry put Big Data to use? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

1) Making big data available - making people aware of how bad piracy is and how harmful it is to the economy...getting customers to help address these issues 2) Enabling organizations to conduct experiments - figuring out what movies should be played at which movie theatre locations 3) Microsegmentation of customers - customizing loyalty and rewards programs - choice seating for new releases, short-line for popcorn, etc. 4) Creating new business models - finding ways to compete with online movies (Redbox, YouTube, etc.) or other movie theatres - making the concession stand more efficient or ticket sales 5) Organizations can analyze more data - not restricted to a certain location or one movie; can analyze thousands of locations and movies simultaneously

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. Many cells have a numeric value (such as cell C5 with a value of 7), while others have a text string as a value (for example, cell B7 is "Software"). What is the result of evaluating the following formula? =COUNT(D4:E8) 10 7 9 229.8 Function has a syntax error or cannot be evaluated by Excel

7

Big Data primarily deals with ______________ data. A. Semi-structured B. Structured C. Unstructured D. All of the above

All of the above

Which company used software to disrupt the previous market-leading companies in the book industry? A. Walmart B. Barnes and Noble C. Amazon D. Books-a-Million

Amazon

Blackstone Group initially focused on the most depressed housing markets in ________. A. Atlanta, GA B. Seattle, WA C. Las Vegas, NV D. Detroit, MI

Atlanta, GA

70% of industrial robots are utilized in ___________. A. automobile factories B. retail warehouses C. toy factories D. a combination of the above

Automobile factories

Six Sigma is a popular _________ methodology. A. BPM B. BPI C. BPS D. BPR

BPI

__________ is a methodology for achieving incremental improvements in the effectiveness and efficiency of a process. A. BPS B. BPM C. BPR D. BPI

BPI

_________ is the most difficult, radical, lengthy, and comprehensive strategy. A. BPS B. BPR C. BPM D. BPI

BPR

Cardlytics services the ________ industry. A. Housing B. Healthcare C. Banking D. Automobile

Banking

BYOD stands for A. Be Your Own Deadline B. Bring Your Own Device C. Be Your Online Discussion D. Bring Your Online Decision

Be Your Own Device

Which of the following is TRUE in regard to Big Data? A. Big Data refers to large amounts of traditional data. B. Big Data systems work because people have taught those systems to think like humans; they just work faster than humans. C. Big Data systems need human intervention to improve over time. D. Big Data is about predictions.

Big Data is about predictions.

Which of the following is FALSE? A. Big Data is often inaccurate, incomplete, incorrect, or erroneous. B. Big Data is valuable because it is structured. C. Big Data changes, especially in data streams. D. Big Data can come from untrusted sources.

Big Data is valuable because it is structured.

___________ is a competitor of GrubHub. A. Boost B. Eat24 C. Seamless D. Amazon

Boost

The Sarbanes-Oxley Act of 2002 holds ______________ personally responsible for disclosing the effectiveness of their financial controls. A. CFOs B. CSOs C. CIOs D. COOs

CFOs

Which of the following is NOT an example of a quasi-autonomous device used for cleaning our houses or belongings? A. CleanIt B. Scooba C. Roomba D. iRobot

CleanIt

List and describe the five different groups of employees within the organization. How do different systems support each group?

Correct 1) Clerical workers - support managers at all levels → office automation systems 2) Lower level managers - day-to-day operations → office automation systems, functional area information systems, dashboards 3) Middle managers - tactical decisions → office automation systems, functional area information systems, business intelligence systems, dashboards 4) Knowledge workers - professional employees, experts in a subject area, advisors to middle managers and executives → office automation systems, business intelligence systems 5) Executives - make decisions that deal with high-level, strategic decisions, dashboards

WalMart has a(n) ___________ strategy. A. Customer orientation B. Innovation C. Differentiation D. Cost leadership

Cost leadership

Alaska Airlines used ______________ to solve their flight delay problems. A. Nearshore outsourcing B. Crowdsourcing C. Offshore outsourcing D. Insourcing

Crowdsourcing

___________ relationship management is an organization-wide effort toward maximizing the customer experience.

Customer

___________ are the "capstone" information systems in an organization. A. TPSs B. Dashboards C. FAISs D. ERP systems

Dashboards

Which of the following is NOT a BI tool? A. Dashboards B. Data mining C. Data dictionary D. Data visualization

Data dictionary

Validation of the model occurs in the _______ phase of the IDC. A. Choice B. Design C. Intelligence D. Implementation

Design

Data marts are used to __________________. A. Support business analytics as a subcategory of BI B. Develop infrastructure to support enterprisewide BI C. Develop few, related BI applications D. Support organizational transformation

Develop few, related BI applications

________ is the result of optimizing the marketing and innovation processes. A. Cost reduction B. Quality C. Productivity D. Differentiation

Differentiation

Which of the following is an informational role? A. Disseminator B. Figurehead C. Disturbance handler D. Entrepreneur

Disseminator

_____________________ is the ability to go to details, at several levels; it can be done by a series of menus or by clicking on a drillable portion of the screen. A. KPI B. Trend analysis C. Drill down D. CSF

Drill down

____________ is one form of data integration. A. EDI B. SAP C. SQL D. ETL

ETL

Mobile RTB allows advertisers to bid on __________. A. Bundles of impressions B. Tablets C. PCs D. Each impression

Each impression

IT has changed the manager's job in many ways. Which of the following is NOT the result of this change? A. Easier to make a decision B. More information to address C. Real-time information D. Remote supervision

Easier to make a decision

Which of the following is a new and consultative function of the MIS department? A. Infrastructure planning B. Managing systems development C. Providing technical services D. Educating the MIS staff about the business

Educating the MIS staff about the business

An instance is a specific, unique representation of a(n) _____________________.

Entity

Small companies typically use _______ for their BI. A. Dashboards B. Data mining C. Excel D. Data visualization

Excel

The most popular BI tool is _______________. A. Excel B. CRM C. Word D. ERP

Excel

IBM's Watson is a(n) _______________. A. ERP system B. Dashboard C. Expert system D. FAIS

Expert system

_______________ is knowledge that has been codified or documented. A. Data B. Information C. Explicit knowledge D. Tacit knowledge

Explicit knowledge

(Excel) Assume cell B1 in the following formula contains the date you were born in MM/DD/YY format: =NOT(TODAY()<>B1) Which of the following is the result of evaluating this expression? #VALUE! TRUE #NUM! #REF! FALSE

FALSE

An order from a customer is a(n) __________ for a business process. A. Output B. Resource C. Input D. Feedback

Feedback

Which of the following is NOT a fundamental element of a business process? A. Feedback B. Resources C. Input D. Output

Feedback

ERP systems are designed to correct a lack of communication among the ________ ISs.

Functional Area

Display the Spelling dialog box to check spelling in the worksheet Display the Microsoft Excel Help dialog box Paste an item from the clipboard into designated cell Select all cells in any given worksheet Save workbook with a *.xlsx or *.xls file extension Toggles between relative, absolute, and mixed cell references Copy the active dialog box or screen image to the clipboard Erases the last change done to the worksheet, reverting it to an older state A. Ctrl + z B. F1 C. F4 D. Alt + PrntScr E. Ctrl + v F. Ctrl + s G. F7 H. Ctrl + a

G, B, E, H, F, C, D, A

Environmental Systems Research Institute is an international supplier of _________. A. ERP B. DSS C. AI D. GIS

GIS

__________ analysis focuses on the outputs rather than the inputs. A. Solution B. Goal-seeking C. What-if D. Sensitivity

Goal-seeking

____________ is NOT categorized as BI. A. Hardware B. Processes C. Technologies D. Applications

Hardware

Which of the following is a support activity in Porter's value chain model? A. Operations B. Customer service C. Human resource management D. Logistics

Human resource management

The _______________ manages all systems throughout the organization and the day-to-day operations of the entire IS organization. A. Operations managers B. CIO C. IS director D. Network manager

IS director

____________ is developed through learning and is the experience and expertise that managers can apply to business problems. A. Data B. Knowledge C. Information D. All of the above

Knowledge

The Chief _________ Officer is the highest-ranking IS manager.

Information

_________________________________ refers to any computer-based tools that people use to work with information and to support the information and information-processing needs of an organization.

Information technology

Corporate databases are an example of a(n) _________ source of data. A. Clickstream B. External C. Personal D. Internal

Internal

Which of the following is NOT true of Knowledge Graph? A. It was started by a startup company called Metaweb in 2010 with only 12 million entries. B. It adds useful context and detail to the list of links that Google provides by using past searches to determine what information is most relevant. C. It is a vast database that enables Google software to connect facts on people, places, and things to one another. D. It is an algorithm that looks for matches with the search teams, rather than the actual meaning of the information entered into the search box.

It is an algorithm that looks for matches with the search teams, rather than the actual meaning of the information entered into the search box.

Warby Parker is competitor of __________. A. Google B. LensCrafters C. Amazon D. Warner Brothers

LensCrafters

Which of the following is a fast-growing company that is disrupting the traditional job recruiting industry? A. Amazon B. LinkedIn C. Google D. Facebook

LinkedIn

The Weather Channel is a powerful and well-known brand that is ________ viewers. A. maintaining B. losing C. training D. gaining

Losing

(Excel) When the format of a cell within a worksheet is changed, which of the following occurs? Neither the display or value are changed The display as well as the underlying value is changed Only the display of the actual cell contents changes Only the underlying value is changed

Only the display of the actual cell contents changes Only the underlying value is changed

Draw a mandatory single, optional single, mandatory many, and optional many ER diagram for activities at your university. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

Mandatory single - food plan freshmen year (for most) Optional single - parking pass Mandatory many - at least 12 hours of classes for full-time undergraduates Optional many - each professor teaches at least one class but can teach more than one

Which of the following is NOT a major BI vendor? A. Microsoft B. Business Objects C. Cognos D. SAS

Microsoft

___________ handle tactical decisions. A. Lower-level managers B. Knowledge workers C. Middle managers D. Clerical

Middle managers

Which of the following is TRUE of NASCAR's pre-race inspection app? A. It makes it easier for race car drivers to ensure their cars pass inspection the first time. B. The dashboard makes it easy to quickly enter violations into the system. C. It probably met with little resistance from people who were used to the tedious paper forms. D. Officials can annotate violations with digital notes and photographs.

Officials can annotate violations with digital notes and photographs.

Which of the following is NOT a reason for flight delays? A. Passengers B. Pilots C. Wind D. Weather

Pilots

A major issue facing Cardlytics is ________. A. Integration B. Privacy C. Training D. Cost

Privacy

__________ analysis involves identifying the best advertising channels. A. Product B. Site C. Promotion D. Price

Promotion

________ is the result of optimizing the design, development, and production processes. A. Differentiation B. Cost reduction C. Productivity D. Quality

Quality

Which of the following is NOT a service provided by GrubHub? A. Restaurant reviews B. Recommending healthy options C. 24/7 customer service D. Coupons

Recommending healthy options

Fulfillment is triggered in the _________ department. A. Warehouse B. Sales C. Accounting D. Purchasing

Sales

Which of the following is NOT a stated benefit of MetLife's Wall? A. Speed B. Security C. Efficiency D. Customer satisfaction

Security

Which of the following is a problem with BYOD? A. Cost B. Security C. Productivity D. Satisfaction

Security

The yearly employee evaluation is a(n) __________________ problem. A. Unstructured B. Structured C. Semistructured D. Unistructured

Semistructured

Which of the following is an example of an efficiency metric? A. High-quality products B. Short customer wait-times C. Helpful customer service D. Good work environment

Short customer wait-times

Which of the following is a good example of a primary key in a student table? A. Social security number B. First and Last Name C. Birthdate D. Address

Social security number

Which of the following is a traditional function of the MIS department? A. Staffing, training, and developing IS skills B. Educating non-MIS managers about IT C. Initiating and designing strategic IS D. Creating business alliances

Staffing, training, and developing IS skills

Which of the following is FALSE in regard to how IT has helped make improvements in healthcare? A. Expert systems help doctors diagnose diseases. B. Surgeons use virtual reality to perform complex surgeries. C. IT has streamlined the process of researching and developing new drugs. D. Medical personnel use IT to make better and faster diagnoses.

Surgeons use virtual reality to perform complex surgeries.

=OR(FALSE,TRUE,TRUE) results in the final value of ____. TRUE FALSE EQUAL ERROR

TRUE

You've been working at ABC Corp for 20 years. Even though they say they are an Equal Opportunity Employer, you know they prefer to hire people who personally know someone at the company. This is _________. A. Data B. Information C. Tacit knowledge D. Explicit knowledge

Tacit knowledge

Nonvolatile in the context of data storage means ________________. A. The data can only be changed by IT professionals. B. The data can only be changed by users. C. The data can't be changed in the source system. D. The data can't be changed in a data warehouse.

The data can only be changed by IT professionals.

(Excel) The ISNUMBER function may be used to determine if a specific cell is actually a numeric value or not, simply by returning a Boolean TRUE or FALSE. True False

True

The book discusses over 15 industries and how they've been impacted by IT. One industry that has been transformed tremendously but was not mentioned specifically is the telecommunications industry (think about smartphones). How has this industry been transformed over the years by technology? How has this industry impacted other industries? This last question was mentioned by the book, but you are not restricted to using examples provided by the book.

There is no right answer to this question but phones are smaller, cheaper, and are basically little computers now Industries impacted: • Photography (book) • Financial services (book) • Education (book section 1.1) • Retail (book section 1.1) • Job hunting (book section 1.1) • Travel (book section 1.1) • Retail

Which of the following is NOT a reason The Weather Channel is losing customers? A. They don't have a mobile app. B. Mobile devices are now the primary source of weather information. C. People prefer highly accurate short-term weather predictions rather than semi-reliable five-day forecasts. D. They show too many reality TV shows.

They don't have a mobile app.

"Organizations promote business and IT professionals within their departments so they become the experts in their functional area" is NOT a characteristic of excellent alignment. True False

True

In the past, BI was used to support __________. A. Low-level managers B. Corporate boards C. Middle-level managers D. Top managers

Top managers

____________ is the short-, medium-, and long-term trends of metrics, which is projected using forecasting methods. A. KPI B. Trend analysis C. CSF D. Drill-down

Trend analysis

A ___________ relationship exists when an association is maintained within a single entity. A. Ternary B. Unary C. Quarterly D. Binary

Unary

Knowledge and knowledge management processes usually have a(n) ________ format. A. Semi-structured B. Mini-structured C. Structured D. Unstructured

Unstructured

Business analytics answers the question ___________ A. What actions are needed? B. What is the best (or worst) that can happen? C. What happened? D. Where is the problem?

What is the best (or worst) that can happen?

If you are trying to figure out the impact of a 2 versus a 4 percent inflation rate on your profit, that is a ______________ analysis. A. Goal-seeking B. What-if C. Market basket D. Sensitivity

What-if

BI answers the question _________________ A. What will happen next? B. Why is this happening? C. What will happen if these trends continue? D. Where is the problem?

Where is the problem?

Data mining helps explain _____________ happened. A. When B. Why it C. What D. How

Why it

Being able to work from home is ________ IT. A. a curse of B. a benefit and a curse of C. not possible with D. a benefit of

a benefit and a curse of

(Excel) Evaluate each of the following formulas and provide your response in the respective answer box below. (1 point each) A) =(5+4-3)*4^2/4 B) =4+3^2*2/9-7

a. 24 b. -1

Which of the following is the correct order of the data hierarchy, from smallest to largest? A. bit, byte, field, record, file, database B. byte, bit, field, file, record, database C. byte, bit, field, record, file, database D. bit, byte, field, file, record, database

bit, byte, field, record, file, database

ConocoPhillips uses ________ to monitor _________ data. A. dashboards; real-time B. data warehouses; historical C. data warehouses; real-time D. dashboards; historical

dashboards; real-time

A(n) _________________ is a person, place, or thing that can be identified in the users' work environment.

entity

The science of designing machines and work settings that minimize injury and illness is called ____________.

ergonomics

A _____________________________________________ is a computer-based system for capturing, integrating, manipulating, and displaying data using digitized maps.

geographic information system (GIS)

The web ____________ buyer power. A. decreases B. increases C. has a mixed impact on D. has no impact on

has a mixed impact on

SQL is the most popular query language because it ___________. A. has relatively simple statements B. uses structured data C. is so easy to point and click on the different icons D. doesn't require training

has relatively simple statements

Data warehouses store _________ data, used primarily by _______ companies. A. historical; small B. real-time; small C. real-time; large D. historical; large

historical; large

RentRange is currently in the _______ industry but could move to the ________ industry. A. credit card; home appliance B. credit card; housing C. housing; credit card D. housing; home appliance

housing; credit card

The goal of OLPC's experiment with solar-powered tablets in Ethiopia was to ____. A. test alternatives to battery power B. reduce the digital divide C. improve literacy in children D. see if under-developed countries could use technology

improve literacy in children

Revenue, ROI, overhead, and operational costs are ___________________________.

key performance indicators (KPIs)

Intellectual capital is another term for _______________.

knowledge or intellectual assets

Data warehouses and data marts are __________; this means users cannot change or update the data in data warehouses or data marts. A. nonvolatile B. time variant C. organized by business dimension or subject D. integrated

nonvolatile

Flurry uses a ________ in its data collection efforts. A. opt-in model of informed consent B. opt-out model of informed consent C. information privacy policy D. digital dossier policy

opt-out model of informed consent

The purpose of Flurry is to ___________. A. provide a high-speed auction system for targeting ads to individuals B. allow users to block ads they don't want to see on their mobile device C. guarantee an internet surfer will look at a particular ad D. send as many relevant ads as possible to a mobile device

provide a high-speed auction system for targeting ads to individuals

Continuous computing is NOT facilitated by _________. A. digital devices B. web-based tools C. wired and wireless networks D. societal standards

societal standards

R&D tasks are ________________. A. strategic and unstructured B. operational and unstructured C. operational and structured D. strategic and structured

strategic and unstructured

Career opportunities in IS are ___________. A. strong but are projected to stagnate or even decrease over the next 10 years B. strong and are projected to remain strong for the next 10 years C. weak and are projected to remain weak for the next 10 years D. weak but are projected to strengthen over the next 10 years

strong and are projected to remain strong for the next 10 years

The University System of Georgia's CIO believes the best way to collaborate with 31 independent-minded university CIO's is to look for scenarios where three to five universities are planning to purchase the same product and therefore can consolidate their buying or centralize their service. One specific example of how the CIO utilized this strategy to resolve a problem was to develop a centralized system for _________. A. student registration B. paying tuition C. managing faculty benefits D. class management

student registration

Sentiment analysis extracts _________ information in source materials, which is particularly useful in __________. A. objective; social media B. subjective; social media C. subjective; business databases D. objective; business databases

subjective; social media

CPM is closely aligned with ___________ A. the development of infrastructure to support enterprise BI B. the development of one or a few related BI applications C. support for organizational transformation D. support for business analytics as a subcategory of BI

support for organizational transformation

The OLPC's experiment with solar-powered tablets in Ethiopia ________. A. was a major failure B. showed very little promise of being successful C. showed some promise of being successful D. was a major success

was a major success

IBM's Watson _______________ Jeopardy!. A. lost to Ken Jennings on B. was able to access Wikipedia while on C. won $1 million on D. none of the above

won $1 million on

Suppose you are failing one of your classes. How would you follow the IDC to address this problem?

• Intelligence - What is the problem? I'm failing • Design - What are my options? I can get a tutor, start studying harder, get a study partner, or talk to the instructor. • Choice - Pick and option and decide how to implement it. I will talk to the instructor. • Implementation - I will do what the instructor recommends.

IBM's Watson _______________. A. can process structured and unstructured content B. can diagnose diseases and recommend treatment C. won Jeopardy! D. All of the above

All of the above

Information systems do NOT play a vital role in __________. A. capturing and storing process data B. executing business processes C. monitoring process performance D. All of the above

All of the above

___________ is a subset of BI according to Thomas Davenport. A. Business analytics B. Querying C. Reporting D. OLAP

Business analytics

NASCAR's pre-race inspection is a ___________. A. Business process B. Response to societal pressure C. Reengineering tool D. Strategic advantage

Business process

Which of the following is TRUE? A. Businesses can utilize enterprise architectures to foster alignment. B. Most IT and business executives agree on their level of alignment. C. Most organizations are able to achieve alignment. D. Alignment within a single organization is fairly easy.

Businesses can utilize enterprise architectures to foster alignment.

(Excel) Which of the following represents the mixed reference of the cell located in a worksheet at the intersection of the 4th row and the 3rd column? $C3 C$4 $D$3 D4

C$4

_________ is NOT an example of something you can do on your smartphone. A. Accessing class information like syllabi B. Applying for jobs C. Making travel reservations D. Creating a LAN

Creating a LAN

__________________________ is an approach to managing information across an entire organization. A. Master data B. Big Data C. Data governance D. Master data management

Data governance

The bargaining power of buyers is low when buyers have many choices and high when buyers have few choices. True False

False

Suppose you want to ensure your Northwest Division generates at least $2 million in revenue. You then use _____________ analysis to determine how much advertising dollars and how many salesmen need to be hired. A. What-if B. Goal-seeking C. Solution D. Sensitivity

Goal-seeking

In the lost hiker example, which of the following was NOT used to improve the ArcGIS suggestions? A. Google B. Twitter C. Park ranger knowledge D. Facebook

Google

_____________ is use to plan and control Business Intelligence activities. A. Metadata B. Governance C. A data dictionary D. ETL

Governance

IBM's Watson is used in which of the following industries? A. Energy B. Healthcare C. Retail D. Agriculture

Healthcare

Which of the following is TRUE of the IS function today? A. It should only be managed by the IS department. B. It should only be managed by end users. C. It is not the exclusive responsibility of the IS department. D. None of the above are true since the IS function is an outdated term.

It is not the exclusive responsibility of the IS department.

Which of the following is NOT a benefit of NASCAR's pre-race inspection app? A. NASCAR executives can identify trends and patterns to help maintain a level playing field for all racers. B. It makes it easier for race car drivers to ensure their cars pass inspection the first time. C. NASCAR officials can drill down on any vehicle to review details about any pending issues. D. The pre-race inspection process has been simplified.

It makes it easier for race car drivers to ensure their cars pass inspection the first time.

The ____________ coordinates and manages new systems development projects. A. information center manager B. business analyst C. applications development manager D. database administrator

applications development manager

Apricot Forest does NOT make money by _________. A. charging patients for follow-up phone calls with their physicians via the apps B. taking a cut of the sales of books and other publications made accessible through their apps C. selling ad space to pharmaceutical companies inside the apps D. charging physicians for downloading the apps

charging physicians for downloading the apps

Tacit knowledge is easier to document than explicit knowledge. True False

False

The CIO Curtis Carver has the final say over the IT purchasing for all universities in the system. True False

False

(Excel) If you enter 2% into a given cell, the actual numeric value that is stored by the worksheet is which of the following? 2 .002 text string "2%" .2 .02

.02

In what three areas do information systems play a vital role? For each area, where is the information system involved? Describe a business example for each area.

1) Executing the process a. Embedded/intertwined; Process fails without system working b. Example - if the system is down, the company can't take orders 2) Capturing and storing process data a. Sometimes happens inside the system but sometimes has to be entered into it b. Example - analytics, decision-making systems 3) Monitoring process performance a. Instance level (specific task) or process level (the whole process); evaluation b. Example - making sure everything is running smoothly (dashboards)

What are the three market pressures discussed in the book? List one positive and one negative for businesses that result from these pressures.

1) Globalization a. Positive = more customers because businesses can be everywhere b. Negative = having to deal with many different cultures/needs 2) Changing Nature of the Workforce a. Positive = access to many more people who couldn't work in the past b. Negative = have to adjust environments to work with those people 3) Powerful Customers a. Positive = getting a lot more feedback from customers b. Negative = customers with bad experiences have a lot more power to influence potential customers in a bad way

In your own words (i.e. go beyond the book definitions), what is the difference between BPI, BPM, and BPR? If you joined the upper management team of a local manufacturing company, how could you potentially use BPI, BPM, and BPR?

1) BPI = incremental improvements; BPM = maintaining BPI over time; BPR = radical improvements 2) BPI = getting employees to recommend ways their department could do things better; BPM = ensure business processes are continually aligned with the strategy (meeting frequently with lower management); BPR = implementing a new ERP system

List and describe the six basic characteristics of data warehouses and data marts. How do each of these distinguish data warehouses and data marts from other enterprise systems?

1) Organized by business dimension or subject - not organized by business process (e.g. transaction) 2) Use OLAP - online analytical processing, analysis of accumulated data rather than OLTP (online transaction processing - per transaction) 3) Integrated - collected from multiple systems rather than a single system 4) Time variant - historical rather than real-time 5) Nonvolatile - the data cannot be changed and are IT controlled instead of user-controlled and user-updateable 6) Multidimensional - data cubes rather than 2-dimensional tables

List and describe Porter's five forces and the ways the Web influences them. Evaluate a SINGLE COMPANY with each force (include your logic for your evaluation).

1) Threat of entry of new competitors = the threat that new competitors will enter your market is high when entry is easy and low when there are significant barriers to entry; web = increases because easy to create a website but decreases because first mover will set the standard 2) Bargaining power of suppliers = supplier power is high when buyers have few choices from whom to buy and low when buyers have many choices; web = increases because integrating supply chain increases switching costs but decreases because it is easier to shop around 3) Bargaining power of buyers = buyer power is high when buyers have many choices from whom to buy and low when buyers have few choices; web = decreases because loyalty programs increase switching costs but increases because it is easier to shop around 4) Threat of substitute products or services = the threat of substitutes is high when there are many alternatives to an organization's products or services; web = increases because substitutes can be created rapidly where information-based industries have highest threat but decreases if can create switching costs 5) Rivalry among existing firms in the industry = threat from rivalry is high when there is intense competition among many firms in an industry; web = increases because of transparency NOTE: for the evaluation piece, students can argue high or low but their logic must be sound as noted above

As of February 15, 2015, the FAA had granted a total of _________ exemptions for the commercial use of drones and had received ____________ requests for exemptions. A. 342; 342 B. 24; 342 C. 150; 342 D. 24; 24

24; 342

Airline predictions are off by an average of _______. A. 57 minutes B. 7 minutes C. 2 hours D. 4 hours

7 minutes

_____ percent of GIS users employ Environmental Systems Research Institute products. A. 70 B. 20 C. 100 D. 50

70

(Excel) Which part of the following formula is considered to be a constant value? =99 + (E4/O6 * AVERAGE(C7:C11)) - MAX(F1:F8) ^ G9 AVERAGE(C7:C11) E4/O6 G9 MAX(F1:F8) 99

99

(Excel) Which of the following formulas should be used in a spreadsheet to determine the percent mark-up of a home theater system, assuming that the wholesale price is $450 and it is being sold by a high-end retail outlet for $999? Note: Assume that the cell format is set to General, not Percentage. =(999-450)/450*100 =(999-450)/999/100 =(999-450)/999*100 =(999-450)*100 =(999-450)/100

=(999-450)/450*100

(Excel) Consider a worksheet in which Cells A1, C1, and E1 contain the names of three individuals and Cells B1, D1, and F1 contain their respective ages. Which of the following formulas should be entered in cell G1 to verify that all of the individuals are at least 65 years old? =IF(AND(B1>=65, D1>=65, F1>=65), "FALSE", "TRUE") =OR(B1>65, D1>65, F1>65) =IF(AND(B1>65, D1>65, F1>65), "FALSE", "TRUE") =AND(B1>65, D1>65, F1>65) =AND(B1>=65, D1>=65, F1>=65)

=AND(B1>=65, D1>=65, F1>=65)

Chloe is creating an Excel spreadsheet using a number of formulas to help make some business decisions regarding her company's customers. Please refer to the figure above as you answer the question below. Chloe also intends to send out a letter congratulating those valued customers who have the value TRUE in all three columns of C, D, and E. She first wants to write a simple formula to generate a TRUE if a customer matches this criteria, demonstrating their strong creditworthiness. IF a customer doesn't meet her high credit expectations, then a FALSE should be displayed. Which of the following Boolean logical constructs should Chloe use as a formula in cell F5, then copied down that column to correctly determine whether a letter should be sent (or not) to all of the customers on her list? =OR(C5:E9) =OR(C5:E9) =AND(C5:E5) =NOT(OR(C5:E9) =NOT(AND(C5:E9))

=AND(C5:E5)

(Excel) You are creating a new forecast for you company's Sales Department and have entered the sales for 2009 into cell B4 of a worksheet. The expected rate of increase is in cell C2. What formula would you enter in cell C4 to compute the sales for 2009, given that you will copy that formula to cells D4:E4 to calculate the forecast for 2010 and 2011? =$B$4+$B$4*C2 =B4+B4*C2 =B4*(1+$C$2) =$B4+$B4*$C2 =B$4+B$4*C$2

=B4*(1+$C$2)

Excel) A tollway truck plaza gives a discount on diesel fuel to truckers based on the total quantity they purchase. Which of the formulas below calculates the correct total price to charge a customer for the diesel pumped based on the following conditions: no discount (zero dollars off the total due) if the trucker purchases less than 50 gallons of diesel a 2% discount on all diesel purchased if the trucker buys at least 50 gallons of fuel Assume that cell A1 shows the total quantity (in gallons) of diesel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that the trucker should pay, after discount (if any) has been applied. =A1*B1*IF(A1<50,1,2%) =IF(A1>=50,A1*B1*98%,A1*B1) =IF(A1<50,A1*B1,A1*B1-(A1*B1*98%)) =A1*IF(A1<50,B1,2%*B1) None of the answers provided is correct

=IF(A1>=50,A1*B1*98%,A1*B1)

(Excel) A customer applies for a loan and the bank reviewing the application uses the following rules: If the applicant's FICO score (entered in cell A5) is less than 650, then the application is rejected. However, if the applicant's FICO score is greater than 750, then the applicant is approved and the interest rate is set at 5.5%. Otherwise, the interest rate is set at 6.5%. Which of the following formulas will give the correct answer? =IF(A5 >= 650, 6.5%, IF(A5 > 750, 5.5%, "Rejected")) =IF(A5 < 650, "Rejected", IF(A5 > 650, 6.5%, IF(A5 > 750, 5.5%))) =IF(A5 < 650, "Rejected", IF(A5 > 750, 5.5%, 6.5%)) =IF(A5 <= 650, "Rejected", IF(A5 >= 650, 6.5%, IF(A5 > 750, 5.5%, ""))) =IF(A5 < 650, "Rejected", IF(A5 >= 650, 6.5%, IF(A5 >= 750, 5.5%, "")))

=IF(A5 < 650, "Rejected", IF(A5 > 750, 5.5%, 6.5%))

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. Employees of Acme Manufacturing, Inc. have been rated on three different dimensions (Effectiveness, Professionalism, and Quality) of job performance. The scores provided in the worksheet are used to determine the dollar amount awarded to each employee as a bonus. Bonuses are calculated as follows: if the Effectiveness rating is greater than 85 and the Professionalism rating is greater than 85, then the employee receives a bonus of $5,000. Otherwise, the person will receive no bonus (zero dollars). Which of the following formulas should be entered in cell E5 to determine the correct bonus amount for the employee listed in cell A5? (Note: Your formula must work for all of the other employees when copied down the column =IF(B5>85, 0, IF(C5>85, 5000, 0)) =IF(B5, C5 > 85, 5000, "No Bonus") =IF(C5>85, B5>85, 5000, "No Bonus") None of the answers provided is correct =IF(B5>85, IF(C5>85, 5000, 0), 0)

=IF(B5>85, IF(C5>85, 5000, 0), 0)

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. Employees of Acme Manufacturing, Inc. have been rated on three different dimensions (Effectiveness, Professionalism, and Quality) of job performance. The scores provided in the worksheet are used to determine the dollar amount awarded to each employee as a bonus. Bonuses are calculated as follows: if the Effectiveness rating is greater than 85 and the Professionalism rating is greater than 85, then the employee receives a bonus of $5,000. Otherwise, the person will receive no bonus (zero dollars). Which of the following formulas should be entered in cell E5 to determine the correct bonus amount for the employee listed in cell A5? (Note: Your formula must work for all of the other employees when copied down the column.) =IF(B5, C5 > 85, 5000, "No Bonus") =IF(B5>85, 0, IF(C5>85, 5000, 0)) =IF(C5>85, B5>85, 5000, "No Bonus") None of the answers provided is correct =IF(B5>85, IF(C5>85, 5000, 0), 0)

=IF(B5>85, IF(C5>85, 5000, 0), 0)

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. Which of the following formulas will determine the second highest property value listed in the Property Value Table? =COUNTIF(B4:B16, ">800000") =MAX(B4:B16,2) =SUMIF(B4:B16, ">800000") None of the responses provided is correct =LARGE(B4:B16, 2)

=LARGE(B4:B16, 2)

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. Which of the following formulas will determine the second highest property value listed in the Property Value Table? =LARGE(B4:B16, 2) =MAX(B4:B16,2) =COUNTIF(B4:B16, ">800000") None of the responses provided is correct =SUMIF(B4:B16, ">800000")

=LARGE(B4:B16, 2)

(Excel) Which of the following is not considered to be a logical expression as used within a worksheet? =ROUND(99.99,1)=ROUND(99.99,-1) =MIN(TRUE,FALSE)=MAX(FALSE,TRUE) =SUM(FALSE,TRUE,FALSE)="TRUE" =LARGE({1,3,5,7,9},1)><MAX({1,3,5,7,9}) =AVERAGE({2,4,6,8})/MEDIAN({2,4,6,8})=1

=LARGE({1,3,5,7,9},1)><MAX({1,3,5,7,9})

(Excel) Assume that cells A1, C1, and E1 in a worksheet contain the names of three students. Cells B1, D1, and F1 contain their current ages in the adjacent cells, respectively. Which of the following formulas will verify that at least one of these students is 21 years old or older? =OR(B1>21, OR(D1>21), OR(F1>21)) =NOT(OR(B1>20, D1>20, F1>20)) =AND(B1>=21, D1>=21, F1>=21) =OR(B1>=21, D1>=21, F1>=21) =AND(B1>21), OR(D1>21), OR(F1>21)

=OR(B1>=21, D1>=21, F1>=21)

(Excel) Closely examine the accompanying worksheet image. Which of the following formulas will determine the arithmetic mean for all of the flights, rounded to the nearest 6 minutes? (Note: Assume the cell format is set to General.) =ROUND(AVERAGE(C4:C10),-1) =ROUND(AVERAGE(C4:C10),1) =ROUND(AVERAGE(C4:C10),-2) =ROUND(AVERAGE(C4:C10),0) =ROUND(AVERAGE(C4:C10),2)

=ROUND(AVERAGE(C4:C10),1)

(Excel) The cell designation: $AZ$123 is considered to be a(n) ____________ reference. absolute relative invalid fixed mixed

Absolute

__________ information system can be strategic ___________. A. Any; if it is used properly B. Any; because technology always provides an advantage C. No; since everyone has access to technology D. No; when it is customized

Any; because technology always provides an advantage

List and describe the variety of BI applications for analyzing data. What is the goal/purpose of each of these applications? Suppose you are trying to figure out why a particular region isn't doing as well as other regions; which BI application would you use to evaluate the problem and why?

Applications • Multidimensional analysis/OLAP - slicing and dicing, drilling down, or aggregating data • Data mining - searching for valuable business information in a large database, data warehouse, or data mart • DSS - combine models and data to analyze semistructured and unstructured problems Goal • Multidimensional analysis/OLAP - answering questions using reports (this is a difficult conclusion to draw since it is not spelled out in the book) • Data mining - predicting trends and behaviors, identifying previously unknown patterns • DSS - access data interactively, manipulate data, and conduct appropriate analyses → enhance learning Evaluation - OLAP; manipulating data files to compare sales' figures (e.g. slice and dice, drilling down)

Chevron initially utilized ___________ to improve their supply chain, followed by employee-driven ________ initiatives, and then adopted a unified _____ approach to standardize business processes. A. BPI, BPM, BPR B. BPS, BPR, BPM C. BPM, BPI, BPR D. BPR, BPI, BPM

BPR, BPI, BPM

Banks have a lot of competition locally in addition to competing with online banks. This concept applies to ____________. A. Bargaining power of suppliers B. Bargaining power of buyers C. Threat of substitute products or services D. Threat of entry of new competitors

Bargaining power of buyers

__________________ are/is the most effective and efficient way of doing things, readily available to a wide range of employees. A. Knowledge management B. Best practices C. Knowledge management systems D. Intellectual capital

Best practices

The color ___________ in the Management Cockpit represents performance of internal processes and employees. A. Black B. Red C. White D. Blue

Blue

(Excel) Review the accompanying worksheet image and then answer the question below. The first row and column in the table refer to Excel column and row labels, respectively. What is the result of evaluating the following formula? 16 9 D7 D5 None of the answers provided is correct

D5

A(n) _________________ is a set of programs that provide users with tools to add, delete, access, modify, and analyze data stored in a single location.

DBMS

List and describe the capabilities of dashboards. Assuming you are the CEO of your campus bookstore, draw a dashboard that you would like to see. HINT: Think about what kind of information you would want to see to make decisions as a CEO.

Dashboard: Students should draw pie charts, meters, etc. (see Figure 12.3) Information should include things like bookstore hits (e.g. in-store, website, mobile, social media), revenue (e.g. sales, rentals), expenses (e.g. marketing, promotions, books, merchandise)

_____________ are low-cost, scaled-down versions of data warehouses.

Data marts

___________ support local control, whereas ____________ support central control. A. Data warehouses; data marts B. Data marts; data dictionaries C. Data warehouses; data dictionaries D. Data marts; data warehouses

Data marts; data warehouses

Your company decides to keep copies of your invoices on CDs. You decide the safest place to store them is in your company's basement since it is secure and people rarely go down there. When you get audited, you find the CDs got ruined during a recent rainstorm when the basement got flooded; you don't have access to the information for your audit. This is an example of _______. A. Data rot B. Low data quality C. Data integrity failure D. Data degradation

Data rot

Reality mining is a type of _____________. A. Dashboard B. Database C. Data visualization technology D. Data mining

Data visualization technology

Nordea Bank implemented a __________ to address regulations developed by various authorities around the globe. A. Database B. Data mart C. Data warehouse D. Data dictionary

Data warehouse

Google's Knowledge Graph is a _______________. A. Data warehouse B. Database C. Data mart D. Repository

Database

The MetLife Wall is a ____________. A. wiki B. social networking site C. expert system D. database

Database

Which of the following is NOT a major driver of change in US higher education? A. Dealing with online competitors that make it easier to get an education no matter where the student is located. B. Lowering costs so that higher education is more attainable for those in low- and middle-income families. C. Maintaining a high-quality educational experience with more graduates. D. All of the above are major drivers of change in US higher education.

Dealing with online competitors that make it easier to get an education no matter where the student is located.

All _______ are ____________. A. ERP; TPS B. TPS; dashboards C. dashboards; TPS D. TPS; ERP

ERP; TPS

(Excel) The ISBLANK function may be used to determine whether or not there is any blank text (one or more space characters) in a specific cell, simply by returning a Boolean TRUE or FALSE. True False

False

Chevron's strategy was to analyze its existing processes to identify specific areas to improve. True False

False

In mass production, a company produces a large quantity of items that are customized to individual customers. True False

False

NoSQL databases only allow businesses to manipulate structured data. True False

False

Organizations adopt BPI to sustain BPM over time. True False

False

Reality mining is data mining that uses GIS and GPS together. True False

False

Secondary keys identify a file with complete accuracy. True False

False

Sensitivity analysis studies the impact that changing outputs has on given inputs. True False

False

Which of the following FALSE in regard to how IT affects our quality of life? A. The workplace can be expanded from the traditional 9-to-5 job at a central location to 24 hours a day at any location. B. IT can provide employees with flexibility that can significantly increase their total amount of leisure time. C. IT places employees on "constant call" such that they are never truly away from the office, even when they are on vacation. D. All of the above are true

IT can provide employees with flexibility that can significantly increase their total amount of leisure time.

Business-information technology alignment is the tight integration of the ____________ with the organization's strategy, mission, and goals.

IT function

Which of the following is TRUE? A. IT opens up jobs for middle managers. B. IT impacts entire industries. C. IT can eliminate any job. D. IT only helps improve employees' health and safety.

IT impacts entire industries

Which of the following is NOT a benefit of Nordea Bank's data warehouse? A. The data warehouse enabled Nordea Bank to meet relevant regulatory requirements more quickly and accurately. B. Reporting lead times decreased from eight to four days. C. Nordea Bank was able to introduce a customer profitability application for customer relationship managers. D. Identity theft of Nordea Bank's customers is not quite as easy as in the past.

Identity theft of Nordea Bank's customers is not quite as easy as in the past.

_______________ are a set of core data that span the enterprise information systems.

Master data

Which Apricot Forest app is designed to help physicians stay current on the latest research literature? A. MedClip B. e-Pocket C. Medical Journals D. LitMe

Medical Jounrals

Chevron employed ________ to provided detailed work instructions to its employees. A. Nimbus B. SAP C. Six Sigma D. Lean Six Sigma

Nimbus

Multidimensional analysis is also called ________. A. OLAP B. ERP C. DSS D. OLTP

OLAP

A(n) __________ refers to a small number of companies that dominate the business and are making large margins. A. autopoly B. oligopoly C. monopoly D. minopoly

Oligopoly

___________________ control is executing specific tasks efficiently and effectively. A. Tactical B. Management C. Strategic D. Operational

Operational

____________________ control is executing specific tasks efficiently and effectively.

Operational

Which of the following is NOT a characteristic of alignment? A. Organizations provide overarching goals that are completely clear to each IT and business employee B. Organizations create a vibrant and inclusive company culture C. Organizations rotate business and IT professionals across departments and job functions D. Organizations view their IT department employees as supremely important

Organizations view their IT department employees as supremely important

Which of the following is NOT a KPI? A. Operational costs B. Overhead C. ROI D. Product quality

Product quality

Procurement is NOT completed in this functional area: A. Warehouse B. Purchasing C. Sales D. Accounting

Sales

(Excel) What is wrong with the following function? =IF(A2<>(MEAN(B4:B6)),"D9","") Assume that the function is entered in cell A1. There are too many sets of parenthesis within the entire IF function The function denoted as "MEAN" is not valid in an Excel worksheet There is no text in the literal string ("") at the end of the function Nothing is wrong with the formula as written D9 is a valid cell reference and should not be a text string

The function denoted as "MEAN" is not valid in an Excel worksheet

How has IT positively and negatively affected the quality of your life and society as a whole? While this is partially opinion, your answer should be informed by material in the book.

There is no right answer to this question, but the student should/could discuss: Positives - • Continuous access to information, everywhere (continuous computing) • Ability to do pretty much anything on smartphones (classes, pay bills, purchase goods, banking, etc.) • More career opportunities • Better customer service • So much free stuff (paid for by ads on huge social networks, etc.) • Industry changes benefit us (book, music, video, software, etc.) • Health and safety improvements • More opportunities for people with disabilities or who need/want to work from home • Robots to do our chores Negatives - • We can't really get away and relax • IT has eliminated many careers (and likely will in the future) • Too easy to steal (piracy is a big problem) • Dangerous (phones while driving) • Drone dilemmas (spying, etc.)

Per the Closing Case, what is the United States' policy on commercial drones? What are the advantages and disadvantages of commercial drones?

They are working on creating a policy, but for now it is based on exemptions. Recreational users can already use them, with restrictions (flying below a certain height, line of sight, etc.). Advantages: • Agricultural - improve crop yield • Construction - monitor progress • Energy - monitoring • Mining - safety Disadvantages: • Safety • Privacy

Which of the following countries is the least supportive of drones (as evidence by their regulations supporting drone integration)? A. Japan B. United Kingdom C. Australia D. United States

United States

__________________ problems are fuzzy and complex. A. Unistructured B. Structured C. Semistructured D. Unstructured

Unstructured

___________ is a challenge of KMS. A. Being willing to invest resources B. Getting employees to share information C. Maintaining and updating the knowledge D. Utilizing the knowledge

Utilizing the knowledge

The Emergency Department Information Exchange database was designed to address which of the following problems? A. Emergency surgeries result in too many drugs being administered to the patient. B. Ambulance drivers needed a way to communicate with the hospital when they were at a patient's location. C. With the expansion of the Affordable Care Act, Medicaid patients visit hospital ERs too many times. D. Communication between doctors and nurses is hindered by systems that don't display the correct data.

With the expansion of the Affordable Care Act, Medicaid patients visit hospital ERs too many times.

__________ is NOT one of The Weather Channel's main competitors. A. Sky Motion B. WeatherSphere C. Dark Sky D. Wunderground

Wunderground

Knowledge Graph has been integrated into ____________. A. Amazon B. YouTube C. LinkedIn D. Facebook

YouTube

What is the result of evaluating each of the following formulas? (3 points each) (a) =IF(AND(6>3,3>8,2>7),"Access","Excel") (b) =IF(OR(1>3,8>2),"yes",5) (c) =IF(OR(AND(4>2,2>3),OR(8>7,4>5)),7,9) (d) =IF(AND(6>3,4>7),IF(5>2,8,7),IF(5>3,3,9)) (e)=IF(SUM(3,5,7)=MAX(11,19,15),23,IF(NOT(OR(4=5,MIN(4,1,3)=1)),IF(4>2,6,7),9))

a. Excel b. yes c. 7 d. 3 e. 9

(Excel) Review the accompanying worksheet image and then answer the questions below. The first row and column in the table refer to Excel column and row labels, respectively. (3 points each) What is the result of evaluating each of the following formulas? (a) =IF(SUM(B4:B7)>=MIN(B6,C5,D4,E7),E4,"Goodbye") (b) =IF(E6=MAX(C4:C8),SUM(E5:E8),IF(D4>C7,B7,D6)) (c) =IF(D4=16,SUM(B5:C6)-MAX(C5:D6),MIN(D5:E8)) (d) =COUNT(C4:D8) (e) =(AVERAGE(B4:B6)-2)/C6 (f) =IF(B5=SMALL(E5:E8,2),SUM(C4:C8),IF(D4>C7,B7,D6)) (g) =COUNTIF(B4:C8,">0")+SUMIF(B4:C8,"<0")

a. Hello b. Coffee c. -25 d. 8 e. 1 f. Coffee g. -8

(Excel) Review the accompanying worksheet image and then answer the questions below. The first row and column in the table refer to Excel column and row labels, respectively. (3 points each) What is the result of evaluating the following formulas? (a) =IF(SUM(B4:B7)>=D5,A4,"Nope") (b) =IF(C4=26,IF(B5=19,2,4),IF(A8=56,6,8)) (c) =IF(AND(D8<10,D8>20),A4,B7) (d) =IF(OR(D8>10,D8<20),A4,B7) (e) =IF(AND(OR(B6=7,C6="Excel"),NOT(B7>20)),44,33) (f) =IF(OR(NOT(B5<6),D7>3),A7,IF(AND(C4=2*B4,D8>D7),C6,D4))

a. Nope b. 6 c. 18 d. 18 e. 86 f. 44 g. fun

The IT infrastructure is ___________. A. the IT components B. the IT personnel C. the IT services D. all of the above put together

all of the above put together

A(n) _____________ is an individual who provides capital for a startup, usually in exchange for convertible debt or ownership equity. A. banker B. venture capitalist C. angel investor D. peer-to-peer lender

angel investor

IT allows the workplace to expand to 24 hours a day at _______________, which is a benefit for ___________. A. any location; employers and employees B. a central location; employers and employees C. any location; only employers D. a central location; only employees

any location; employers and employees

A competitive advantage refers to any ___________ that provide an organization with an edge against its ___________ in some measure such as cost, quality, or speed. A. costs; customers B. assets; competitors C. assets; customers D. costs; competitors

assets; competitors

IT __________ be used to create a competitive advantage ___________. A. cannot; even when it is used effectively B. cannot; because everyone has access to technology C. can; when it is used effectively D. can; because everyone has access to technology

can; when it is used effectively

Dashboards are used in which process? A. capturing and storing process data B. executing a process C. monitoring process performance D. all of the above

capturing and storing process data

RFID tags and bar codes are used in which process? A. capturing and storing process data B. executing a process C. monitoring process performance D. all of the above

capturing and storing process data

Which of the following is NOT a benefit of GrubHub to restaurants? A. commission percentage B. managing orders C. accurately predicting demand D. free tablet

commission percentage

The most important principle for Nordea Bank's data warehouse was to ________. A. improve customer service B. comply with all relevant regulations C. reduce costs to improve financial performance D. create a single version of the truth

create a single version of the truth

GE's goal for Flight Quest is to ____________. A. create smart assistants for pilots B. replace pilot decisions C. alter the practices and official handbooks of air traffic controllers D. own the data created by airlines

create smart assistants for pilots

Which of the following is the correct order for the KMS cycle? A. create, capture, store, refine, manage, disseminate B. create, capture, refine, store, manage, disseminate C. create, capture, store, manage, refine, disseminate D. create, capture, refine, manage, store, disseminate

create, capture, refine, store, manage, disseminate

As you are walking to the cafeteria to pick up your lunch, you see a poster with the word "apple" on it with a picture of an apple below it. This is ____. A. information B. data C. knowledge D. business intelligence

data

A __________________________ defines the required format for entering the data into the database A. DBMS B. entity C. primary key D. data dictionary

data dictionary

Big Data helps companies treat customers as individuals. This is called __________. A. experimentation B. business model creation C. microsegmentation D. data analyzation

microsegmentation

Apricot Forest does NOT help improve overall healthcare in China by ___________. A. improving the efficiency and effectiveness of patient care B. increasing doctor's pay, which is roughly equivalent to what taxi drivers make C. helping doctors and patients communicate more D. giving China's physicians more data about patients, their records, and their illnesses

increasing doctor's pay, which is roughly equivalent to what taxi drivers make

Which of the following is NOT an advantage of central management of information systems in the University System of Georgia? A. consolidation of purchasing B. independence C. convenience for students D. standardization

independence

Data ___________ means all applications are able to access the same data, which is ___________ by databases. A. isolation; maximized B. independence; maximized C. isolation; minimized D. independence; minimized

independence; maximized

Baxter is a(n) __________ that improves upon existing technology by _________. A. drone; being more autonomous B. industrial robot; being more autonomous C. industrial robot; being less expensive and easier to work with D. drone; being less expensive and easier to work with

industrial robot; being less expensive and easier to work with

In the following table, column A is _____, column B is _____, and column C is ______. A. information; knowledge; data B. information; data; knowledge C. knowledge; information; data D. knowledge; data; information

information; data; knowledge

Startups like Dark Sky can predict to the minute when it is going to start raining or snowing within the next hour because they ______________. A. integrate and analyze data to improve short-term forecasting B. really understand the weather better than anybody else C. hired superior weather forecasters with PhDs D. are magicians and psychics

integrate and analyze data to improve short-term forecasting

AngelList's mission is to _______________. A. make startup investing transparent and efficient B. help people find the best service providers C. create a list of charitable givers D. collect money for people in need

make startup investing transparent and efficient

Business process__________ is a management system that includes methods and tools to support the design, analysis, implementation, management, and continuous optimization of core business processes throughout the organization.

management

The entertainment industry primarily uses sentiment analysis to improve their ______. A. TV show times B. movie release dates C. advertising revenue D. marketing campaigns

marketing campaigns

RentRange uses _____________ to provide information about purchasing foreclosed and low-priced single-family homes and then renting them out. A. dashboards B. predictive analytics C. data visualization D. historical analytics

predictive analytics

Palantir is NOT primarily used for ____________. A. detecting fraud B. identifying patterns C. privacy protection D. pricing mortgages

privacy protection

Flurry's main issues surround ______ concerns, particularly in _____. A. security; Europe B. privacy; the US C. security; the US D. privacy; Europe

privacy; Europe

IT changes managers' job by _________ A. providing near real-time information so managers can make quicker decisions. B. improving an employee's sense of connectedness. C. decreasing the volume of information they have to process. D. making it easier to get all employees to work from one location.

providing near real-time information so managers can make quicker decisions. Answers:

The FAA proposal for drone use does not apply to __________ activities, for which the FAA had already issued a policy. A. recreational B. agricultural C. construction D. commercial

recreational

____________ is a benefit of a data dictionary. A. managing security and user access B. recovering information if the system fails C. reducing the chances that the same attribute will be used in multiple applications under different names D. all of the above are benefits of a data dictionary

reducing the chances that the same attribute will be used in multiple applications under different names

Rethink Robotics' stated goal/mission for Baxter is to __________. A. lower manufacturing costs by replacing expensive human workers B. constantly adjust to changing environments C. rescue US manufacturing through technological innovation D. train employees how to use machines more effectively

rescue US manufacturing through technological innovation

Sentiment analysis algorithms use simple terms to express sentiment about a product or service, so ________ makes it __________ to classify online content as positive, negative, or neutral. A. exaggeration; simple B. exaggeration; difficult C. sarcasm; difficult D. sarcasm; simple

sarcasm; difficult

Apricot Forest addresses problems in __________. A. the Chinese medical system B. the Chinese food industry C. the US food industry D. the US medical system

the Chinese medical system

The main purpose of Cardlytics is to ______________. A. securely share customer information between banks and merchants B. track and understand consumer buying behavior C. target potential new customers for retailers D. collect personally identifying information

track and understand consumer buying behavior

Warby Parker can offer cheaper glasses than their competition because they _______. A. write-off their donated glasses on their taxes B. allow shoppers to upload pictures of themselves in glasses C. use the same materials and factories as Luxottica without the licensing fees D. use better retailers that pay more for the glasses

use the same materials and factories as Luxottica without the licensing fees

From smallest to largest, what is the hierarchy of data for a computer-based file? Give an example for each one for a company like Walmart, building on the lower level where possible. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

• Bit - 0 • Byte - 01010101 • Field - John • Record - John; Smith; New York, New York • File - Customer: John; Smith; New York, New York Jane; Doe; Chicago, Illinois • Database - Customer and Product files

Why is BI so important in today's business world?

• The number of alternatives is constantly increasing • Decisions must be made under time pressure • Sophisticated analyses are required to make good decisions • Data and decision makers are all in different locations; these things must be brought together quickly and cost effectively


Ensembles d'études connexes

Structural and Functional Divisions of Nervous System

View Set

ECO-231: Chapter 2: The Market System and the Circular Flow Homework

View Set