GB 310 FINAL EXAM
Which of the following is not one of the three Vs of "Big Data"?
(ALL OF THE ABOVE ARE APART OF THE THREE Vs) Volume, Variety, Velocity
Which of the following Excel formula calculate the average correctly in Excel (you can use Excel to help you figure this out?)
=AVERAGE(80,90,100)
A data cube refers to a:
A special database used to store data in OLAP reporting.
Tech firms are among the best performing firms in the world. According to the chapter, which firm is the most valuable firm in the United States, and has also posted some of the most profitable quarters of any business in any industry.
Apple
Which type of chart would you use if you wanted to get an idea about the distribution of a single variable including outliers?
Box and Whisker chart
A(n) ________ is the symbolic embodiment of all the information connected with a product or service
Brand
Why is it important to be proficient in Excel?
Excel is a commonly used powerful software tool
All versions of Excel work in the exactly same fashion. For example, data can be imported using the power query editor in all versions of excel.
False
In a typical dataset, variables are the rows and records are the columns
False
Legacy systems are popular among large firms because they have a large storage capacity and are design to share data
False
The black box nature of AI makes it easy to transparently demonstrate how machine learning software has arrived at decisions
False
What is the difference between sorting and filtering the data?
Filtering removes or "hides" data and sorting reorders the data
What is the primary reason for filtering your data?
Filtering the data makes it easier to see trends in subset of interest
Which of the following is not a key component of an information system?
Hardware, Software, People (ALL OF THE ABOVE)
If a computer system can be equated to a layered cake, which of the following combinations represents the computer system in the bottom-to-top order?
Hardware, operating system, application, user
What are three components of information technology?
Hardware, software, and data
What is the most important reason to avoid hand entering data if possible?
It is error prone
What is the significance of the total row?
It makes it easy to calculate various statistics for the columns
Java is not optimized to take advantage of interface elements specific to the Mac or Windows operating systems. As a result:
Java is unsuitable for desktop applications
Amazon was started by:
Jeff Bezos
Which of the following types of charts are an effective way of displaying trends over time for different companies?
Line charts
Which series fill option allows you to complete additive series (e.g. 22, 25, 28...)
Linear
Which of the following is not a calculation performed by Excel?
MINIMUM()
Which of the following is an example of application software?
MS Word
Which of the following represents one of the primary components of the value chain?
Outbound logistics
How do you toggle between absolute and relatively referencing a cell?
Press F4
In database systems, a row is also known as a __________.
Record
Which of the following allows you to view the data in separate panels that have separate scroll bars?
Split screen
Which of the following conditions is essential for data mining to work?
The events in the data should reflect current and future trends.
Which cursor type indicates that you will select the value in the cell?
The white plus
(T/F) It is important to make sure the data are saved as an Excel workbook instead of a "csv" file to retain its formatting.
True
Data analytics and business intelligence are driving discovery and innovation.
True
Data are raw facts that must be turned into information in order to be useful and valuable.
True
True or False: Scatter plots are an effective way to describe the relationship between two quantitative variables
True
True or False: There are functions designed to format and modify text.
True
Dell, previously the world's number one PC manufacturer, has seen its market share shrink because of rivals copying its value chain and reducing the price advantage it enjoyed over rivals. Dell's present struggles:
Underscore the importance of continually assessing a firm's strategic position among changing market conditions
How can you tell that these data are formatted as a table?
When you click in the data range the Design tab becomes visible
What are the tabs located at the bottom left of an Excel file called?
Worksheets
Tony Hsieh served as CEO of _____, and eventually sold the firm to Amazon for $900 million.
Zappos
What are the two most common delimiters used to separate data values?
comma (,) and tab
The patent system is often considered to be unfairly stacked against start-ups because:
high litigation costs coupled with a few months of litigation can sink an early stage firm.
Technology experts in the area of process design:
leverage technology to make firms more efficient.
If a customer pays a retailer in cash, he is likely to remain a mystery to the retailer because his name is not attached to the money. Retailers can tie the customer to cash transactions and track the customer's activity if they can convince the customer to use a _____.
loyalty card
A ____________ is a system that provides rewards and usage incentives, typically in exchange for a method that provides a more detailed tracking and recording of consumer activity.
loyalty program
The degree to which complete information is available is known as _____.
price transparency
Knowledge is defined as:
the insight derived from experience and expertise.
Computer hardware refers to:
the physical components of information technology
Leveraging consumers to promote a product or service is known as _____.
viral marketing