information systems midterm

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas? a) A5 b) $A$5 c) $A5 d) A$5

$A$5

EXTRA CREDIT: The small publishing company you work for wants to create a new database for storing information about all of their author contracts. What factors will influence how you design the database?

-Prioritization of data, that is, analyzing which data is important and which is not. -Deciding the management of contracts. -Technical difficulties, which may occur during linking the new system with existing systems. -Data accuracy, while storing new data and while accessing previously stored data. -Use and need of data by the end-user so that it can be decided that in which manner the data will be stored and how it will be accessed.

20) Select the accurate statement(s). 1) The world's most valuable retailer, China's Alibana, also carries the world's largest product inventory. 2) Uber, the world's largest taxi service, owns no vehicles for hire. 3) Airbnb, the world's largest accommodation provider, owns several major hotel corporations 4) Facebook does not create media content.

2 and 4

What is the correct formula to insert the date January 12, 1998 into a cell? a) =DATE(1998,1,12) b) =DATE(1998,12,1) c) =DATE(12-1-1998) d) =DATE(1/12/1998)

=DATE(1998,1,12)

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed? a) =IF(B2>=60, "Pass", "Fail") b) =OR(B2>=60, "Pass", "Fail") c) =AND(B2>=60, "Pass", "Fail") d) =NOT(OR((B2>=60, "Pass", "Fail"))

=IF(B2>=60, "Pass", "Fail")

17) Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below? * a) =IF(B2>=E2,"Accept","Reject") b) =IF(B2>=$E2,"Accept","Reject") c) =IF(B2>=E$2,"Accept","Reject") d) =IF(B2>=$E$2,"Accept","Reject")

=IF(B2>=E2,"Accept","Reject")

cells Q12-Q16 question

=SUM(Q12:Q14, Q16)

EXTRA CREDIT: You have been hired by a national furniture leasing company to implement its first business intelligence systems and infrastructure. To prepare for your initial report, describe the types of data in their firm they can use to support business intelligence and the systems that you will implement to support both their power users and casual users, and explain how these systems or tools work together.

All types of data can be used for their business intelligence systems, including operational, historical, machine-generated, Web/social data, audio and video data, and external data. The large datasets can be collected in a Hadoop cluster, and used by an analytic platform to support power user queries, data mining, OLAP, etc. A data warehouse can be used to house all data, including smaller data sets and operational data, and be used to support casual use, for queries, reports, and digital dashboards, as well as support the analytic platforms. Smaller data marts can be created from the data warehouse to enable faster querying and typical queries from casual users.

EXTRA CREDIT: You have been hired by Santori, Inc., a small company that imports and distributes an Italian sparkling water. The company is interested in what benefits an enterprise system would bring. Would an enterprise system be appropriate for this company? What steps would you take in determining this?

An enterprise system may be too expensive, although there are enterprise software packages that are available to smaller companies. A cloud-based enterprise application might be the most economical way to implement an enterprise system. To determine whether this would be beneficial to Santori, I would first look at their existing business processes. It would be ideal to determine if their efficiency meets benchmarks in their industry and allows them to be competitive with other businesses in their niche. Then I would review cloud-based or open-source enterprise systems to see how each application's business processes matched up with Santori's. It would be important to compare the costs of instituting new business processes with the benefits and cost savings. Because their business is based on imports and distribution, and working with suppliers in different countries, it might be best to start off with a supply chain management system.

EXTRA CREDIT: You have been hired by Croydon Visiting Nurse Services, whose business processes are all manual, paper-based processes. How might a CRM system benefit them?

Customer Relationship Management (CRM) focuses on improving the business 's productivity by doing the task efficiently. It is done by improving customer and service provider communication, also helps in branding the products or services this enhances the marketing and sales number. CRM not only tends to increase business growth but also focuses on improving the business environment by taking into considerations like reviewing own products or services, satisfying the consumer's needs and making the service better.

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use? a) IFERROR b) VLOOKUP c) IF d) RAND

IF

EXTRA CREDIT: The value of information is the difference between the benefits realized from using that information and the costs of producing it. Would you, or any organization, ever produce information if its expected costs exceeded its benefits? If so, provide some examples. If not, why?

Most of the organisations in most of the situations produce information only if its value exceeds its cost but in the following situations, the organisations may produce information even if its costs exceeds its value which are as follows: 1. As the accruate estimation of value of information and cost of producing information is often difficult, the organisations may produce information that they expect to produce more benefits when compared to costs. 2.Sometimes production of information may be mandated by a government agency or a private organization like tax reports required by the IRS and disclosure requirements for financial reporting.

You have been hired by a worldwide non-profit agency to implement a system to handle their donations. The system must be able to handle and record telephone, sms, and Internet donations, provide up-to-the-minute reports, and create highly customizable mailing lists. In addition, event fundraisers need to be able to quickly access a donor's information and history. Which of the following systems will best meet these needs? a) TPS b) TPS with DSS capabilities c) TPS with MIS capabilities d) TPS with ESS capabilities

TPS with MIS capabilities

EXTRA CREDIT: You and a few of your classmates decided to become entrepreneurs. You came up with a great idea for a new mobile phone application that you think will make lots of money. Your business plan won second place in a local competition, and you are using the $10,000 prize to support yourselves as you start your company. a. Identify the key decisions you need to make to be successful entrepreneurs, the information you need to make them, and the business processes you will need to engage in. b. Your company will need to exchange information with various external parties. Identify the external parties, and specify the information received from and sent to each of them.

a) make decisions on recommitting the idea to a real business. make a business plan. more marketing b) The external parties include the investors who we will major on in order to maintain our flow of business in cases of financial fluctuations. Another external party is the government who we will rely on for the provision of subsidies and incentive provision foe the business.

difference between abs. and relative

abs is copied exactly relative changes

In the formula =B6*$B$2, which of the following describes $B$2? a) Relative cell reference b) Absolute cell reference c) Function d) Average

absolute reference

20) Which area of corporate law is connected to technology? a) Privacy b) Patents c) Intellectual Property d) All of the above

all of the above

tech developments over the decade question

all of the above

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of a) identifying associations. b) identifying clusters. c) identifying sequences. d) classification.

classification

Big data does not refer to a) datasets with fewer than a billion records. b) datasets with unstructured data. c) machine-generated data (i.e. from sensors). d) data created by social media (i.e. tweets, Facebook Likes).

datasets with fewer than a billion records

data cleansing not only corrects errors but also a) establishes logical relationships between data. b) structures data. c) normalizes data. d) enforces consistency among different sets of data.

enforces consistency among different sets of data

data mining tool is for allowing users to a) quickly compare transaction data gathered over many years. b) find hidden relationships in data. c) obtain online answers to ad-hoc questions in a rapid amount of time. d) summarize massive amounts of data into much smaller, traditional reports.

find hidden relationships in data

formatting in excel challenge

finding a balance

In a complex formula, how does Excel determine which calculation to perform first? a) It calculates the leftmost formulas first. b) It calculates operations outside parentheses first. c) It follows the order of operations. d) It calculates functions first.

follows order of operations

use simulation models because

helps make predictions

a data warehouse is composed of a) historical data from legacy systems. b) current data. c) internal and external data sources. d) historic and current internal data.

historic and current internal data

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of a) identifying associations. b) identifying clusters. c) identifying sequences. d) classification

identifying sequences

parentheses in excel indicate what

indicate which operations to perform

20) Technology experts in the area of process design: a) work to make sure systems are easy to use. b) leverage technology to make firms more efficient. c) specialize in technology for competitive advantage. focus on systems dealing with critical business data

leverage technology to make firms more efficient

custodial and janitorial question

neither is a good way

20) A company uses radio frequency identification (RFID) tags to keep track of its inventory. This is an example of the impact of technology in the area of _____. a) accounting b) operations c) advertising d) human resources

operations

model of online stock question about price and competitor

price you change is variable, competitor is uncontrollable

19) You have been asked to implement enterprise software for a manufacturer of kitchen appliances. What is the first step you should take? a) Select the functions of the system you wish to use. b) Select the business processes you wish to automate. c) Map the company's business processes to the software's business processes. d) Map the software's business processes to the company's business processes.

select the business process you wish to automate

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data? a) text mining tools b) sentiment analysis software c) Web usage mining technologies d) data mining software for identifying associations

sentiment analysis software

copy paste B2*$A$3 question

stays the same

20) Technology experts in the area of _____ specialize in technology for competitive advantage. a) user-interface design b) process design c) strategy d) database design

strategy

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option? a) Sum b) Count c) Average d) %Total

sum

which statement that Gallagher said is true

tech is affecting more industries

ON TEST !!!!! Some of the radical changes brought about by new technologies include: a) the stagnation of advertising. b) the proliferation of telecommunications into the hands of a few. c) an increase in computing costs owing to the growth of licensed software. d) the creation of an unprecedented set of security and espionage threats.

the creation of an unprecedented set of security and espionage threats

20) Experts working in the area of _____ work to make sure systems are easy to use, while people working in the area of _____ work to leverage technology to make firms more efficient. a) user-interface design; process design b) process design; user-interface design c) strategy; process design d) process design; strategy

user-interface design; process design

20) Technology experts in the area of user-interface design: a) work to make sure systems are intuitive and easy to use. b) leverage technology to make legacy systems more efficient. c) specialize in technology for competitive advantage. provide direction on technology-related security issues

work to make sure systems are intuitive and easy to use