Fundamental Info. Systems: Module 7

Task that would be handled by a management support system:

determining how much raw material should be ordered

True or False

True

Task that would be handled by a management support system:

processing customer orders

True or False

False

Task that would be handled by a management support system:

projecting future sales

True or False

True

Task that would be handled by a management support system:

negotiating long-term purchase contracts

True or False

True

Task that would be handled by a management support system:

choosing which supplier to use

True or False

True

Task that would be handled by a management support system:

enrolling students into classes

True or False

False

Task that would be handled by a management support system:

paying bills

True or False

False

Task that would be handled by a management support system:

deciding which equipment to purchase

True or False

True

A task which estimates a future output value given a set of input values is a(n)___________ type of analytical task

prediction

A task which chooses from a set of alternatives is a(n)___________ type of analytical task

prescription or optimization

A(n) __________ type of decision involves solving routine, repetitive problems with widely accepted solution approaches

structured

A(n)___________ is a type of analytical task that answers the question: why something has happened?

explanation

A(n)___________ is a type of analytical task that answers the question: what has happened?

description

A(n)___________ type of analytical task involves summarizing historical data.

description

A(n)___________ type of analytical task involves making a decision recommendation

prescription or optimization

A(n) __________ decision involves solving non-routine problems that do not have completely understood solution procedures

semi-structured

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

choosing which promotions to offer to customers

prescription or optimization

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

categorizing advertisements according to revenue generated

description

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

summarizing product sales by geography

description

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

estimating the likelihood that a consumer will accept an offer

prediction

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

deciding on the price of a product

prescription or optimization

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

grouping customers according to demographic characteristics

description

Select the correct type of analytical task for the item below

options: description, prescription or optimization, prediction

projecting annual demand for a new service

prediction

a concise visual summary of key performance indicators of some aspect of a business and is usually interactive and role-based

a dashboard

a general process for transforming data into images using shapes, color and text

data vizualization

a storage repository that contains standardized data from multiple source systems and is used for specific managerial tasks including analysis, planning, decision-making and control

data warehouse

uses the metaphor of a data cube to support descriptive reporting along multiple dimensions through roll-up, drill-down, slice and dice functions

on-line analytical processing (OLAP)

___________ is an unsupervised technique that finds things that commonly happen or appear together.

Association rules

__________ is a supervised learning technique which estimates a numerical function mapping a set of input values to an output value. A linear functional form is commonly used to support both prediction and explanation tasks.

Regression

__________ is a supervised learning technique which estimates a numerical function mapping a set of input values to an output value in order to support prediction tasks. Complex non-linear functional forms are represented by weighted connections between layers of nodes and are difficult to interpret.

Artificial neural networks

___________ creates groups or categories of things persons, places, things or events which have similar features.

Clustering

___________ is a prescriptive or optimization technique which determines the best decision to achieve an objective subject to one or more constraints.

Linear programming

Match the task below to the most appropriate analytical technique to accomplish that task.

options: association rules, artificial neural network, regression, linear programming, clustering

determine what other products consumers who buy milk and beer are also likely to buy

association rules

Match the task below to the most appropriate analytical technique to accomplish that task.

options: association rules, artificial neural network, regression, linear programming, clustering

predict lung disease by estimating weights on layers of connected nodes which map symptoms to disease diagnosis

artificial neural network

Match each task below to the most appropriate analytical technique to accomplish that task.

options: association rules, artificial neural network, regression, linear programming, clustering

assign staff to work shifts in order to minimize labor cost subject to minimum staff requirements and required days off constraints

linear programming

Match the task below to the most appropriate analytical technique to accomplish that task.

options: association rules, artificial neural network, regression, linear programming, clustering

construct a mathematical model to predict first year college GPA with a functional form like the following:

CollegeGPA = 1.2 + .49(HighSchoolGPA) + .11 (SAT_MathScore) + .1 (SAT_ReadingScore)

regression

Match the task below to the most appropriate analytical technique to accomplish that task.

options: association rules, artificial neural network, regression, linear programming, clustering

categorize competitors’ products according to the similarity of the product features

clustering

Differences between expert systems and decision support systems: indicate the system that applies to the statement below.

options: decisions support system, expert system

This is a special purpose system that supports a narrow range of applications.

expert system

Differences between expert systems and decision support systems: indicate the system that applied to the statement below.

options: decisions support system, expert system

This type of system was originally intended to replace human decision-makers.

expert system

Differences between expert systems and decision support systems: indicate the system to which each statement below applies.

options: decisions support system, expert system

This system is an early type of artificial intelligence system developed in the computer science community.

expert system

Differences between expert systems and decision support systems: indicate the system that applied to the statement below.

options: decisions support system, expert system

This type of system was originally intended to augment the capabilities of human decision makers.

decision support system

Differences between expert systems and decision support systems: indicate the system to which each statement below applies.

options: decisions support system, expert system

This type of system has model and data management components.

decision support system

Differences between expert systems and decision support systems: indicate the system that applies to the statement below.

options: decisions support system, expert system

This type of system relies on the use mathematical models to make decisions.

decision support system

Differences between expert systems and decision support systems: indicate the system that applied to the statement below.

options: decisions support system, expert system

This is a general purpose system that supports a wide range of applications.

decision support system

Differences between expert systems and decision support systems: indicate the system that applies to the statement below.

options: decisions support system, expert system

This type of system relies on the use of if then rules to make decisions.

expert system

Differences between expert systems and decision support systems: indicate the system to which each statement below applies.

options: decisions support system, expert system

This type of system has an inference engine.

expert system

Differences between expert systems and decision support systems, indicate the system that applies to the statement below.

options: decisions support system, expert system

MS-Excel is an example of this type of system.

decision support system

Match the definition below to the correct type of machine learning

An algorithm that interacts with its environment and learns what actions to take in given situations through trial and error in order to achieve some goal. In subsequent interactions, actions which previously led to greater goal achievement are more likely to be repeated and actions which led to less goal achievement are less likely to be repeated.

reinforcement learning

Match the definition below to the correct type of machine learning

An algorithm that learns descriptive patterns in a data set such as similarities and associations without having known correctly labeled outputs.

unsupervised learning

Match the definition below to the correct type of machine learning

An algorithm that is given a data set with input features and known correctly “labeled” outputs and then learns a function which maps inputs to the correct output.

supervised learning

Indicate the correct type of machine learning for the application below.

An algorithm is given features of prior loans and a label which indicates whether the loan was paid on time, paid late or defaulted. The system must use the features to predict the correct label. This is an example of ___________.

supervised learning

Indicate the correct type of machine learning for the application below.

An algorithm is given the dollar amounts spent on different breakfast cereals for a sample of customers. The algorithm must use this data to group customers according to similarity of cereal preferences This is an example of ____________.

unsupervised learning

Indicate the correct type of machine learning for the application below.

An algorithm is given data about accounts followed on a social media platform for a sample of users and must learn if there are common co-occurrences of accounts followed. This is an example of ______________.

unsupervised learning

Indicate the correct type of machine learning for each application below.

An algorithm is programmed to learn how to play chess through trial and error. Actions which lead to a win are rewarded and are more likely to be repeated in subsequent games. This is an example of ___________.

reinforcement learning

Indicate the correct type of machine learning for the application below.

An algorithm is given weekly retail sales data for a sample of products and must learn if there are common patterns of weekly sales across products. This is an example of ______________.

unsupervised learning

relative cell addressing means that cell addresses in formulas change relative to where they are copied

True or False

True

The cell address $B4 is row absolute and column relative.

False

The concept of "isolating assumptions" refers to the correct use of relative and absolute addressing.

False

The concept of "isolating assumptions" means that assumption input values should be placed in clearly labeled cells and formulas should refer to those cells.

True

If assumption input values are correctly isolated then formulas have to be changed whenever those input values change.

True or False

False

If the formula =C$2 is copied one column to the right, the new copied formula will be =D$2.

True

The concept of "isolating assumptions" means that numeric values should be placed into formulas to make them easier to understand.

True or False

False

The concept of "isolating assumptions" ensures that formulas can be copied correctly.

False

Consider the MS-Excel spreadsheet below. If you copy the formula from cell A4 to cell B4, the resulting value will be __________.

11