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