MIS Test 3 Flashcards
To calculate the present value of a loan or an investment use the?
PV Function
What function is used to calculate the amount of a payment used to pay the interest on a loan?
IPMT
What function is used to calculate the interest on a loan or an investment?
RATE
___automates the trial-and-error process by allowing you to specify a value for a calculated item, and then Excel returns the ___ needed to reach that goal.
goal seek, input value
T/F. Referencing data in other workbooks creates a link between the workbooks
True
What are the functions of an IF function?
Returns one value if the condition is true & returns one value if the condition is false
Calculating an investment’s length with the NPER function
Returns the number of payment periods
What type of depreciation depreciates assets by equal amounts each year of its lifetime until it reaches the salvage value?
Straight-line
Functions that can determine if a cell contains an error value and then display the message you choose rather than the default error value.
INFERROR function
A rule that specifies the condition, the formatting, and the cell or range to apply the rule to.
Conditional formatting rule
Worksheets that are grouped must have the same ___ & ___.
Rows, columns
The ____ function tests two or more conditions and determines whether all conditions are true.
AND
T/F E-business is a major factor in the widespread use of global information systems.
True
T/F Case-based reasoning is a problem-solving technique that matches a new casee with preciously solved case and tis solution, both stored in a database.
True
Describe what happens in Phase 1: Planning?
In phase 1 the issue that the company is facing is define. It mainly focused on the problem.
T/F A cost-effectiveness analysis is based on the concept that one dollar today is worth more than one dollar from the past.
False (not past, but future)
T/F Internal users are not employees who sue the information system, including customers and suppliers.
False (external users
Which of the following is prototyping NOT used for?
Sold as the final version of a product
A CRM system includes all of the following:
Sales Automation, Order Processing, Customer Supportt
T/F Executive Information Systems are interactive information systems that give executives easy access to only internal data.
False
T/F An intelligent system is a machine with an embedded, Internet-connected computer that has the capacity to gather and analyze data and communicate with other systems.
False
Optimal supply chains ___ disruptions and volatility.
anticipate, control, and react to
T/F Artificial Intelligence is a push towards a replica of people in all respects
True
Under the systems development life cycle, which phase uses the four ws?
Planning
Intelligent agents are becoming more popular in ___.
e-commerce
What is feasibility analysis?
A continuous measure of how beneficial or practical an information system will be to an organization.
What does ERP stand for?
Enterprise Resource Planning
DSS is an abbreviation for?
Decision Support System
What are the 4 key decisions in Supply Chain Management?
Location, Inventory, Production, and Transportation
Citibank: The new CRM provided a comprehensive yet granular security solution which solved which of Citibank’s prior issues?
Some sensitive data lacked adequate security while other data was overprotected
T/F Coca-Cola Enterprise: Coca Cola Enterprise never acknowledged that their communication platforms were no longer enabling innovation.
False
Menchie’s : What are some key issues found in the Menchie’s case study?
Francisee’s used personal email accounts & the server’s IP address was often blacklisted.
According to the Coca Coal Enterprises case study, the company had relied largely on ___ based communications for years.
Similarly to the Coca-Cola case study, what type of unreliable communication method was being used by Menchie’s Frozen Yogurt?
When Menchies employees had their email accounts compromised, what was often blacklisted?
IP Address
What was the negative aspect of Citi’s CRM system the wealth management advisers were using?
The system provided only a partial view of their client’s financial information.
What did the new CRM solution provide Citibank?
A central ‘dashboard’ of key client data, a comprehensive yet granular security, & a salesforce.com mobile CRM solution that gave advisors secure access to client data.
T/F SAP HANA simplifies IT operations and implementations.
True
What does Xiaoyu Liu, the VP of Lenovo, say SAP HANA will solve in terms of their day-to-day business operations?
SAP HANA will help provide real-time data for business decisions.
What are the four qualities of empathy according to the animated RSA short?
Perspective-taking & Staying out of judgement
Which is NOT a benefit the company experience after implementing a tailored salesforce.com CRM?
Decrease in need for security of client information.
Who spent 2 years of his life building the user experience team for the Google X division of Google?
Tom Chi
What is the Prototyping Rule #1?
Find the quickest path to experience
Shell KMS: What allows Shell to manage valuable data passed through valuable assets?
IBM Rational Asset Manager
What did Coca-Cola Enterprises use to solve their key business challenges?
Microsoft online Services Technologies
Informal Introductions
Hey there!, What’s up?, Hi Dude
T/F Forni believes that the reason why civility has suffered throughout the years is because people have now made themselves the central concern.
True
An important civility lessons we want to impress upon the next generation is that the way we treat animals is a/an
measure of our self-worth
The main difference between empathy in relation to sympathy is?
Empathy fuels connections