New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
exploring management
Experiencing MIS 3rd Edition David Kroenke - Solutions
Neil at FlexTime used his studio database with Excel to obtain the data that he needs. A more common scenario is to use Microsoft Access with Excel: Users process relational data with Access, import some of the data into Excel, and use Excel’s tools for creating professional looking charts and
Reread the Guide on pages 114–115. Suppose you are given the task of converting the salesperson’s data into a database. Because his data are so poorly structured, it will be a challenge, as you will see.a. Download the Excel file named Ex23 from www.pearsonhighered.com/kroenke. This spreadsheet
In this exercise, you will create a two-table database, define relationships, create a form and a report, and use them to enter data and view results.a. Download the Excel file Ex24 from www.pearsonhighered.com/kroenke. Open the spreadsheet and review the data in the Employee and Computer
Numerous Web sites are available that will test your Internet data communications speed.You can find a good one at www.speakeasy.net/speedtest/. (If that site is no longer active, Google or Bing “What is my Internet speed?” to find another speed-testing site. Use it.)a. While connected to your
Suppose you work for a company that will install the FlexTime network. Assume that you have been given the task of creating spreadsheets to generate cost estimates, not just for FlexTime, but for many different clients.a. Create a spreadsheet to estimate hardware costs. Assume that the user of the
Assume you have been asked to create a spreadsheet to help make a buy-versus-lease decision for the servers on your organization’s Web farm.Assume that you are considering the servers for a 5-year period, but you do not know exactly how many servers you will need. Initially, you know you will
Suppose your manager asks you to create a spreadsheet to compute a production schedule.Your schedule should stipulate a production quantity for seven products that is based on sales projections made by three regional managers at your company’s three sales regions.a. Create a separate worksheet
Microsoft created Windows Live SkyDrive and the Office Web applications as part of the Office 2010 launch. Somewhere in the middle of that launch, Microsoft Fuse realized that it would be a simple matter to put Facebook trappings (in tech parlance, Facebook Chrome) on top of SkyDrive, call it Docs,
Figure CE11-5, the sample bill of materials, is a form produced using Microsoft Access.Producing such a form is a bit tricky, so this exercise will guide you through the steps required.You can then apply what you learn to produce a similar report. You can also use Access to experiment on extensions
Assume that you have been given the task of compiling evaluations that your company’s purchasing agents make of their vendors. Each month, every purchasing agent evaluates all of the vendors that he or she has worked with in the past month on three factors: price, quality, and
It is surprisingly easy to create a market-basket report using table data in Access. To do so, however, you will need to enter SQL expressions into the Access query builder. Here, you can just copy SQL statements to type them in. If you take a database class, you will learn how to code SQL
In this exercise, you’ll have an opportunity to practice creating reports in Access using the data shown in Figure CE16-1.a. Open Access, create a new database, and import the data in the text file Ex33. Notice that the data includes an identifier; the four fields in Figure CE16-1; and a sixth
OLAP cubes are very similar to Microsoft Excel pivot tables. For this exercise, assume that your organization’s purchasing agents rate vendors, similar to the situation described in Application Exercise 31.a. Open Excel and import the data in the worksheet named Vendors from the Excel file Ex34,
In this exercise, you will use Visio to create process diagrams in BPMN notation.a. Download the Visio file Ex35 from this text’s support site. Open the file and familiarize yourself with this diagram. Match the diagram to the correct figure in Chapter Extension 18.b. Notice that Visio includes
Suppose you are given the task of keeping track of the number of labor hours invested in meetings for systems development projects. Assume your company uses the traditional SDLC and that each phase requires two types of meetings:working meetings and review meetings. Working meetings involve users,
Use Access to develop a failure-tracking database application. Use the data in the Excel file Ex37 for this exercise. The file includes columns for the following:FailureNumber DateReported FailureDescription ReportedBy (the name of the PQA engineer reporting the failure)ReportedBy_email (the email
At Fox Lake, the wedding events and facilities departments are having problems with repeated maintenance requests. They need to keep better track of requests so that management can get involved when requests are repeatedly made for the same problem or when too many problems are being reported for
This is an easy exercise with a major lesson!a. Open any HTML editor, such as Dreamweaver or Expression Web.b. Create a Web page with the title “Phishing Examples” and the subtitle “Go to These Sites.”c. Under the subtitle, create a hyperlink that will display the text “www.msn.com.”
In the Fox Lake case at the start of Chapter 12, Chris was able to use Mike’s computer in the middle of the night, when no one was around. And, Fox Lake is about to discover that Jason, Chris’s accomplice, stole more than $2,500 worth of equipment. Jason will be living in another state by the
What is the purpose of a database? appendix
What does a database contain? appendix
What is a DBMS, and what does it do? appendix
What is a database application? appendix
What is the difference between an enterprise DBMS and a personal DBMS?
Suppose you had a national database of student data. Assume your database includes the name, email address, university, grade level, and major for each student. Name five companies that would find that data valuable, and explain how they might use it. (For example, Pizza Hut could solicit orders
Describe a product or service that you could develop that would induce students to provide the data in step 3. appendix
Prepare a 1-minute statement of what you have learned from this exercise that you could use in a job interview to illustrate your ability to innovate the use of technology in business. appendix
Present your responses to steps 1 through 6 to the rest of the class. Where did Chris go wrong? appendix
Do you think it was illegal, unethical, or neither for Chris to take the database home and query the data? appendix
Does the company share culpability with Chris? appendix
What do you think Chris should have done upon discovering the odd pattern in Jason’s orders? appendix
What should the company have done before firing Chris? appendix
Is it possible that someone other than Jason is involved in the arrangement with Valley Appliances? What should Chris have done in light of that possibility?
What should Chris do now? appendix
“Metadata make databases easy to use—for both authorized and unauthorized purposes.”Explain what organizations should do in light of this fact. appendix
To what extent do you agree with the opinions presented here? To what extent are the concerns expressed here justified?To what extent might they be due to other factors? appendix
What problems do you see with the way that the car salesperson stores address data? What will he have to do if he ever does want to send a letter or an email to all of his customers?
From his comments, how many different themes are there in his data? What does this imply about his ability to keep his data in a spreadsheet? appendix
Does the concern about not sharing data relate to whether he uses a database? appendix
Apparently, management at the car dealership allows the salespeople to keep their contact data in whatever format they want. If you were management, how would you justify this policy? What disadvantages are there to this policy?
Suppose you manage the sales representatives, and you decide to require all of them to use a database to keep track of customers and customer car interest data. How would you sell your decision to this salesperson?
Given the limited information in this scenario, do you think a database or a spreadsheet is a better solution?
FiredUp, Inc., (the same FiredUp we met at the end of Chapter 3, p. 65) is a small business owned by Curt and Julie Robards. Based in Brisbane, Australia, FiredUp manufactures and sells FiredNow, a lightweight camping stove. Recall that Curt used his previous experience as an aerospace engineer to
A three-table database design for the data in the spreadsheet in Figure 5-15 is as follows:ChoirMember (LastName, FirstName, Email, Phone, Part)MusicalWork (NameOfWork)CheckOut (LastName, FirstName,NameOfWork, Part, CopyNumber,DateOut,DateIn)a. Redraw the data in Figure 5-15 into this threetable
Assume you manage the choir and you foresee two possibilities:• Keep the spreadsheet, but create procedures to reduce the likelihood of data integrity problems.• Create an Access database and database application for the three-table design.Describe the advantages and disadvantages of each of
All of the data included in this database is available in public documents. Thus, what is the value of the Aviation Safety Network? Why don’t users just consult the online version of the underlying references?In your answer, consider the difference between data and information.
What was the cause of the incident shown in Figure 5-17? That incident, in which no one was fatally injured, was caused by geese that stuck an Airbus 320 that was flown by US Airways out of La Guardia Airport in New York. It would be illogical to conclude from this one incident that it is dangerous
The ASN database and Web site were created and are maintained by two individuals. The database might be complete and accurate, or it might not be. To what extent should you rely on these data? What can you do to decide whether you should rely on the data at this site?
Consider the data in Figure 5-18. Do you notice anything that indicates that this figure might not include all accident data? If you believe that not all data is included, what value does this figure have to you? What would be legitimate uses for this data, and what uses are likely to be erroneous?
Suppose you work in the marketing department for an airline. Can you use these data in your marketing efforts? If so, how? What are the dangers of basing a marketing campaign on safety? appendix
Suppose you are a maintenance manager for a major airline. How can you use these data? Would it be wise to develop your own, similar database? Why or why not? appendix
What is a computer network? Appendix
What are the components of a LAN? Appendix
What are the alternatives for connecting to a WAN? Appendix
What are the fundamental concepts you should know about the Internet? Appendix
What happens on a typical Web server? Appendix
How do organizations benefit from VPNs? Appendix
Imagine that you have graduated, have the job of your dreams, and want to install a wireless stereo system in your new condo. Assume that the spare bedroom that you use as an office has a LAN device connected to the Internet. You have an existing stereo system in your living room, a pair of unused
Visit www.Pandora.com. Using the free trial membership, build a radio station for your group. Base your station on whatever song or music your group chooses. Appendix
The Sonos equipment does not have an on-off switch. Apparently it is designed to be permanently on, like your LAN device. You can mute each station, but to turn a station off, you must unplug it, an action few people take. Suppose you have tuned a Sonos device to a Pandora station, and you mute
Using your group’s imagination and curiosity, describe the consequences of Internet-based audio on:a. Existing radio stationsb. Vendors of traditional audio receiversc. Audio entertainmentd. Cisco (a vendor of Internet routers)e. Your local ISPf. Any other companies or entities you believe will
Using history as a guide, we can assume that audio leads the way for video.a. Explain how you could use a wireless video system in your new condo.b. In the opinion of your group, is having multiple wireless video players in your condo more or less desirable than wireless audio? Explain your
Considering all of your answers to steps 1 through 5:a. What industries are the winners and losers?b. What companies are the winners and losers?c. How does your answer to parts a and b guide your job search? Appendix
Use the knowledge you have gained in answering steps 1 through 6 to prepare a 1-minute statement that you could make in a job interview about the emerging opportunities in Internet-based audio and video. Assume that with this statement you want to demonstrate your ability to think innovatively.
Is it ethical for you to send the email and picture to your friend at work? Appendix
Does your answer to question 1 change depending on the size of the pictures? Does your answer change if you send 100 pictures?If you send 1,000 pictures? If your answer does change, where do you draw the line?
Once the pictures are stored on the Ohio company’s email server, who owns the pictures? Who controls those pictures? Does the company have the right to inspect the contents of its employees’ mailboxes? If so, what should managers do when they find your picture that has absolutely nothing to do
What do you think is the greater cost to your friend’s company: the cost of the infrastructure to transmit and store the email or the cost of the time your friend takes at work to read and view your pictures? Does this consideration change any of your answers above?
How does the 2008 update change the ethics of the situation? Explain. Is it ethical for your friend to read and update Facebook using the company’s computers? Appendix
How does the 2010 update change the ethics of the situation? Is it any of the company’s business what your friend does with his iPhone or other device at work? Appendix
Describe a reasonable policy for computer/phone/communicating device use at work. Consider email, Facebook, and Twitter, as well as the 2008 and 2010 updates. Endeavor to develop a policy that will be robust in the face of likely data communication changes in the future.
In your own words, explain the meaning of the claim that no one can think exponentially.Do you agree with this claim? Appendix
Describe a phenomenon besides connectivity or magnetic memory that you believe is increasing exponentially. Explain why it is difficult to predict the consequences of this phenomenon in 3 years. Appendix
To what extent do you think technology is responsible for the growth in the number of news sources? On balance, do you think having many news sources of varying quality is better than having a few with high quality control?
List three products or services, such as group movie viewing, that could dramatically change because of increased connectivity.Do not include movie viewing.5. Rate your answers to question 4 in terms of how closely they fit with problems that people have today.
Suppose that you have a consulting practice implementing LANs for fraternities and sororities on your campus.a. Consider a fraternity house. Explain how a LAN could be used to connect all of the computers in the house. Would you recommend an Ethernet LAN, an 802.11 LAN, or a combination of the
Consider Neil’s problem at FlexTime. He wants to carefully review the $175,000 network infrastructure proposal and eliminate any equipment or services that he can. At the same time, as the building is being remodeled the walls will be open, so this will be the best possible time to add cabling
Thinking about Baby Boomers whom you know, brainstorm with your team on the skills that you possess that they do not. Consider all of the items just described and others that come to mind. If you have not read MIS InClass Exercise 6 (page 136), do so now. Make a list of all those skills that
Interview, survey, or informally discuss the items on your list in part a with your parents and other Baby Boomers. As a team, determine the five most important skills that these people do not possess.
How viable is your concept? Do you think you can make money with these products? If so, summarize an implementation plan. If not, explain why not.
The Baby Boomer market has both money and time, but not as much information technology capability as they need, and they do not like it.With your team, brainstorm products that you could sell to this market that would address the Baby Boomers’ techno-ignorance. For example, you might create a
Develop sales material that describes your services, the benefits they provide, and why your target market should buy those products. Try your sales pitch on friends and family.
Read the “Thinking Exponentially” Guide on pages 146–147. Keeping the principles of that Guide in mind, list five possible commercial applications for mobile WiMax. Consider applications that necessitate mobility.
Evaluate each of the possible applications in your answer to question 1. Select the three most promising applications and justify your selection.
Clearwire went public in March 2007 at an initial price of $27.25. As of April, 2010, the price was $8.00.Go online and research the company to find out what happened to its share price. Explain why its share price has dropped.
AT&T and T-Mobile have endorsed HSDPA, but it does not have the same potential maximum transmission rates. Rather than jump on the WiMax bandwagon, those companies plan to deploy a different technology called Long Term Evolution(LTE). Search the Web for LTE versus WiMax comparisons and compare and
Where will this end? On which of these technologies would you be willing to invest $100 million? Why? Appendix
How do information systems vary by scope? Appendix
When are information silos a problem? Appendix
How do enterprise information systems eliminate silos? Appendix
How do CRM, ERP, and EAI support enterprise systems? Appendix
What are the challenges when implementing new enterprise systems? Appendix
How does the knowledge in this chapter help Fox Lake and you? Appendix
Act! and GoldMine are two of the lower-end CRM products. They began as sales lead tracking tools for individuals and small offices but have evolved since then.a. To learn about those products, visit www.act.com and www.frontrange.com/goldmine.aspx.b. As you can see, it is difficult to know how
Salesforce.com and Sugar are CRM products that are intended for use by larger organizations than Act! and GoldMine.a. To learn about these products, visit www.salesforce.com and www.sugarcrm.com.b. These two products seem to differ in orientation. To learn how others view these differences, Google
Of course, the major software vendors have CRM offerings as well.Using a combination of acquisition and internal development, Microsoft created the Dynamics CRM product. Oracle, meanwhile, through acquisition of Siebel Systems in 2005 and other acquisitions, has developed a suite of CRM
Given your answers to parts 1–3 (and those of other teams, if you have been presenting to each other), consider the desirability of CRM product offerings for a variety of businesses. Specifically, suppose you have been asked to recommend two of the CRM products you’ve explored for further
Is it ethical for you to write the email agreeing to take the product back? If that email comes to light later, what do you think your boss will say?
Is it ethical for you to offer the “advertising”discount? What effect does that discount have on your company’s balance sheet?
Is it ethical for you to ship to the fictitious company? Is it legal? Appendix
Showing 1800 - 1900
of 2370
First
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Step by Step Answers