CIS300 Wiley Review
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
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
_____________ 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
