Hi,

I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded everything is perfect, except for step 3a. I cannot fathom why. The feedback I'm getting is "Data validation for cells G6 to G10 in worksheet "Brentwood, TN" are not based on 2000, 5000, None as a source." As you can see from my worksheet, I created the list and referenced it. The values are there as options, yet I'm not getting credit for it. Any help would be very much appreciated.

Brentwood, TN Classic Gardens and Landscapes (CGL) Actual Orders Sales Categories April May June Landscape Care Trees and Shrubs Furniture Water Features Consulting Q2 Total Forecasted - Page 1 24,500 37,600 43,000 11,500 11,250 Bonus Information Systems: A Manager's Guide to Harness Technology Information Systems: A Manager's Guide to Harness Technology [Author removed at request of original publisher] University of Minnesota Libraries Publishing edition, 2015. This edition adapted from a work originally produced in 2011 by a publisher who has requested that it not receive attribution. Minneapolis, MN Information Systems: A Manager's Guide to Harness Technology by [Author removed at request of original publisher] is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted. Contents Publisher Information About the Author Acknowledgments Dedication Preface vii viii ix xi xii Chapter 1: Setting the Stage: Technology and the Modern Enterprise 1.1 Tech's Tectonic Shift: Radically Changing Business Landscapes 1.2 It's Your Revolution 1.3 Geek UpTech Is Everywhere and You'll Need It to Thrive 1.4 The Pages Ahead 2 4 7 13 Chapter 2: Strategy and Technology: Concepts and Frameworks for Understanding What Separates Winners from Losers 2.1 Introduction 18 2.2 Powerful Resources 24 2.3 Barriers to Entry, Technology, and Timing 35 2.4 Key Framework: The Five Forces of Industry Competitive Advantage 38 Chapter 3: Zara: Fast Fashion from Savvy Systems 3.1 Introduction 3.2 Don't Guess, Gather Data 3.3 Moving Forward 43 48 54 Chapter 4: Netflix: The Making of an E-commerce Giant and the Uncertain Future of Atoms to Bits 4.1 Introduction 4.2 Tech and Timing: Creating Killer Assets 4.3 From Atoms to Bits: Opportunity or Threat? 58 61 71 Chapter 5: Moore's Law: Fast, Cheap Computing and What It Means for the Manager 5.1 Introduction 5.2 The Death of Moore's Law? 5.3 Bringing Brains Together: Supercomputing and Grid Computing 5.4 E-waste: The Dark Side of Moore's Law 78 91 95 99 iv Chapter 6: Understanding Network Effects 6.1 Introduction 6.2 Where's All That Value Come From? 6.3 One-Sided or Two-Sided Markets? 6.4 How Are These Markets Different? 6.5 Competing When Network Effects Matter 105 107 111 113 117 Chapter 7: Peer Production, Social Media, and Web 2.0 7.1 Introduction 7.2 Blogs 7.3 Wikis 7.4 Electronic Social Networks 7.5 Twitter and the Rise of Microblogging 7.6 Other Key Web 2.0 Terms and Concepts 7.7 Prediction Markets and the Wisdom of Crowds 7.8 Crowdsourcing 7.9 Get SMART: The Social Media Awareness and Response Team 128 137 141 146 152 158 165 168 171 Chapter 8: Facebook: Building a Business from the Social Graph 8.1 Introduction 8.2 What's the Big Deal? 8.3 The Social Graph 8.4 Facebook FeedsEbola for Data Flows 8.5 Facebook as a Platform 8.6 Advertising and Social Networks: A Work in Progress 8.7 Privacy Peril: Beacon and the TOS Debacle 8.8 Predators and Privacy 8.9 One Graph to Rule Them All: Facebook Takes Over the Web 8.10 Is Facebook Worth It? 184 187 191 194 196 200 207 211 213 218 Chapter 9: Understanding Software: A Primer for Managers 9.1 Introduction 9.2 Operating Systems 9.3 Application Software 9.4 Distributed Computing 9.5 Writing Software 9.6 Total Cost of Ownership (TCO): Tech Costs Go Way beyond the Price Tag 223 226 231 236 242 246 Chapter 10: Software in Flux: Partly Cloudy and Sometimes Free 10.1 Introduction 10.2 Open Source 10.3 Why Open Source? 10.4 Examples of Open Source Software 10.5 Why Give It Away? The Business of Open Source 10.6 Cloud Computing: Hype or Hope? 10.7 The Software Cloud: Why Buy When You Can Rent? 10.8 SaaS: Not without Risks 10.9 The Hardware Cloud: Utility Computing and Its Cousins 251 253 257 260 262 267 269 275 278 v 10.10 Clouds and Tech Industry Impact 10.11 Virtualization: Software That Makes One Computer Act Like Many 10.12 Make, Buy, or Rent 282 286 288 Chapter 11: The Data Asset: Databases, Business Intelligence, and Competitive Advantage 11.1 Introduction 11.2 Data, Information, and Knowledge 11.3 Where Does Data Come From? 11.4 Data Rich, Information Poor 11.5 Data Warehouses and Data Marts 11.6 The Business Intelligence Toolkit 11.7 Data Asset in Action: Technology and the Rise of Wal-Mart 11.8 Data Asset in Action: Harrah's Solid Gold CRM for the Service Sector 292 295 299 306 309 313 319 323 Chapter 12: A Manager's Guide to the Internet and Telecommunications 12.1 Introduction 12.2 Internet 101: Understanding How the Internet Works 12.3 Getting Where You're Going 12.4 Last Mile: Faster Speed, Broader Access 329 330 339 347 Chapter 13: Information Security: Barbarians at the Gateway (and Just About Everywhere Else) 13.1 Introduction 13.2 Why Is This Happening? Who Is Doing It? And What's Their Motivation? 13.3 Where Are Vulnerabilities? Understanding the Weaknesses 13.4 Taking Action 357 359 363 381 Chapter 14: Google: Search, Online Advertising, and Beyond 14.1 Introduction 14.2 Understanding Search 14.3 Understanding the Increase in Online Ad Spending 14.4 Search Advertising 14.5 Ad NetworksDistribution beyond Search 14.6 More Ad Formats and Payment Schemes 14.7 Customer Profiling and Behavioral Targeting 14.8 Profiling and Privacy 14.9 Search Engines, Ad Networks, and Fraud 14.10 The Battle Unfolds 390 396 403 405 411 416 420 424 429 433 vi Publisher Information Information Systems: A Manager's Guide to Harness Technology is adapted from a work produced and distributed under a Creative Commons license (CC BY-NC-SA) in 2010 by a publisher who has requested that they and the original author not receive attribution. This adapted edition is produced by the University of Minnesota Libraries Publishing through the eLearning Support Initiative. This adaptation has reformatted the original text, and replaced some images and figures to make the resulting whole more shareable. This adaptation has not significantly altered or updated the original 2011 text. This work is made available under the terms of a Creative Commons Attribution-NonCommercial-ShareAlike license. vii viii INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY About the Author Information Systems: A Manager's Guide to Harness Technology is adapted from a work produced by a publisher who has requested that they and the original author not receive attribution. This adaptation is produced by the University of Minnesota Libraries Publishing through the eLearning Support Initiative. Though the publisher has requested that they and the original author not receive attribution, this adapted edition reproduces all original text and sections of the book, except for publisher and author name attribution. Unnamed Author is an associate professor of information systems (IS) at Boston College's Carroll School of Management. A dedicated teacher and active researcher, Professor Unnamed Author has been recognized for excellence and innovation in teaching by several organizations, including Boston College, BusinessWeek, the Decision Sciences Institute, Beta Gamma Sigma (the business honor society), and The Heights (Boston College's student newspaper). Professor Unnamed Author's research has been published in the Harvard Business Review, MIS Quarterly, and other leading IS journals. Professor Unnamed Author has consulted for and taught executive seminars for several organizations, including Accenture, Alcoa, Duke Corporate Education, ING, Partners Healthcare, Staples, State Street, the University of Ulster, and the U.S. Information Agency. His comments on business and technology have appeared in the New York Times, the Associated Press, The Daily Yomiuri (Japan), and The Nation (Thailand), and on National Public Radio and WCVB-TV, among others. Professor Unnamed Author's courses and research focus on strategy and technology, and he has co-led the Boston College MBA program's international field study courses to Europe and Asia. As coordinator of the graduate and undergraduate Boston College TechTrek West field studies, Unnamed Author regularly spends time with executives, managers, entrepreneurs, and venture capitalists in Silicon Valley and Seattle. This fieldwork helps him bring current, practice-oriented examples into both the classroom and his writing. He is also the faculty advisor for the BC Information Systems Academy, and co-advisor to the student-run Boston College Venture Competition (which has spawned several venture-backed start-ups). Professor Unnamed Author earned his PhD in information systems from the Syracuse University School of Management, and he holds an MBA and an undergraduate degree in computer science, both from Boston College. viii Acknowledgments Sincerest thanks to Jeff Shelstad and Eric Frank, for their leadership and passion in restructuring the textbook industry and for approaching me to be involved with their efforts. Thanks also to Flat World's dynamite team of editorial, marketing, and sales professionalsin particular to Jenn Yee, Sharon Koch, and Brett Sullivan. A tremendous thanks to my student research team at Boston College. In particular, the work of Xin (Steven) Liu, Justin Tease, Liz Dean, Nina Stingo, Phil Gill, and Marco Barbosa sped things along and helped me fill this project with rich, interesting examples. I am also deeply grateful to my colleagues at Boston College, especially to my department chair, Jim Gips, and dean, Andy Boynton, for their unwavering support of the project; to Rob Fichman and Jerry Kane for helping shape the social media section; to Sam Ransbotham for guiding me through the minefield of information security; and to Mary Cronin, Peter Olivieri, and Jack Spang for suggestions and encouragement. Thanks also to the many alumni, parents, and friends of Boston College who have so generously invited me to bring my students to visit with and learn from them. The East and West Coast leadership of the Boston College Technology Council have played a particularly important role in making this happen. From Bangalore to Boston, Seoul to Silicon Valley, you've provided my students with world-class opportunities, enabling us to meet with scores of CEOs, senior executives, partners, and entrepreneurs. My students and I remain deeply grateful for your commitment and support. And my enduring thanks to my current and former students, who continue to inspire, impress, and teach me more than I thought possible. Serving as your professor has been my great privilege. I would also like to thank the following colleagues who so kindly offered their time and comments while reviewing this work: Donald Army, Dominican University of California David Bloomquist, Georgia State University Teuta Cata, Northern Kentucky University Chuck Downing, Northern Illinois University John Durand, Pepperdine University Marvin Golland, Polytechnic Institute of New York University Brandi Guidry, University of Louisiana Kiku Jones, The University of Tulsa Fred Kellinger, Pennsylvania State University-Beaver Campus Ram Kumar, University of North Carolina-Charlotte Eric Kyper, Lynchburg College Alireza Lari, Fayetteville State University Mark Lewis, Missouri Western State University Eric Malm, Cabrini College Roberto Mejias, University of Arizona Esmail Mohebbi, University of West Florida John Preston, Eastern Michigan University Shu Schiller, Wright State University Tod Sedbrook, University of Northern Colorado Richard Segall, Arkansas State University Ahmad Syamil, Arkansas State University ix x INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY Sascha Vitzthum, Illinois Wesleyan University I'm also grateful to the kindness and insight provided by early adopters of this text. Your comments, encouragement, and student feedback were extremely helpful in keeping me focused and motivated on advancing the current edition: Animesh Animesh, McGill University Michel Benaroch, Syracuse University Barney Corwin, University of Maryland-College Park Lauren B. Eder, Rider University Rob Fichman, Boston College James Gips, Boston College Roy Jones, University of Rochester Jerry Kane, Boston College Fred Kellinger, Penn State University-Beaver Campus Eric Kyper, Lynchburg College Ann Majchrzak, University of Southern California Eric Malm, Cabrini College Michael Martel, Ohio University Ido Millet, Pennsylvania State University-Erie Campus Ellen Monk, University of Delaware Sam Ransbotham, Boston College Nachiketa Sahoo, Carnegie Mellon University Shu Schiller, Wright State University Tom Schambach, Illinois State University Avi Seidman, University of Rochester Jack Spang, Boston College Sascha Vitzthum, Illinois Wesleyan University I'll continue to share what I hope are useful insights via my blog, The Week In Geek (http://www.gallaugher.com), and Twitter (@gallaugher). Do feel free to offer comments, encouragement, ideas, and examples for future versions. Sincerest thanks to all who continue to share the word about this project with others. Your continued advocacy helps make this model work! Dedication For Ian, Maya, Lily, and Kimzettabytes of love! xi xii INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY Preface Thanks for using this book. I very much hope that you enjoy it! I find the space where business and technology meet to be tremendously exciting, but it's been painful to see the anemic national enrollment trends in tech disciplines. The information systems (IS) course should be the most exciting class within any university. No discipline is having a greater impact on restructuring work, disrupting industries, and creating opportunity. And none more prominently features young people as leaders and visionaries. But far too often students resist rather than embrace the study of tech. My university has had great success restructuring the way we teach our IS core courses, and much of the material used in this approach has made it into this book. The results we've seen include a threefold increase in IS enrollments in three years, stellar student ratings for the IS core course, a jump in student placement, and an increase in the number of employers recruiting on campus for tech-focused jobs. Material in this book is used at both the graduate and undergraduate levels. I think it's a mistake to classify books as focused on just grad or undergrad students. After all, we'd expect our students at all levels to be able to leverage articles in the Wall Street Journal or BusinessWeek. Why can't our textbooks be equally useful? You'll also find this work to be written in an unconventional style for a textbook, but hey, why be boring? Let's face it, Fortune and Wired wouldn't sell a single issue if forced to write with the dry-encyclopedic prose used by most textbooks. Many students and faculty have written with kind words for the tone and writing style used in this book, and it's been incredibly rewarding to hear from students who claim they have actually looked forward to assigned readings and have even read ahead or explored unassigned chapters. I hope you find it to be equally engaging. The mix of chapter and cases is also meant to provide a holistic view of how technology and business interrelate. Don't look for an \"international\" chapter, an \"ethics\" chapter, or a \"systems development and deployment\" chapter. Instead, you'll see these topics woven throughout many of our cases and within chapter examples. This is how professionals encounter these topics \"in the wild,\" so we ought to study them not in isolation but as integrated parts of real-world examples. Examples are consumer-focused and Internet-heavy for approachability, but the topics themselves are applicable far beyond the context presented. There's a lot that's different about this approach, but a lot that's worked exceptionally well, too. I hope that you find the material to be as useful as we have. I also look forward to continually improving this work, and I encourage you to share your ideas with me via Twitter (@gallaugher) or the Web (http://www.gallaugher.com). Best wishes! Professor John Gallaugher Carroll School of Management Boston College xii Chapter 1: Setting the Stage: Technology and the Modern Enterprise 1.1 Tech's Tectonic Shift: Radically Changing Business Landscapes 1.2 It's Your Revolution 1.3 Geek UpTech Is Everywhere and You'll Need It to Thrive 1.4 The Pages Ahead 1.1 Tech's Tectonic Shift: Radically Changing Business Landscapes Learning Objective After studying this section you should be able to do the following: 1. Appreciate how in the past decade, technology has helped bring about radical changes across industries and throughout societies. This book is written for a world that has changed radically in the past decade. At the start of the prior decade, Google barely existed and well-known strategists dismissed Internet advertising models (Porter, 2001). By decade's end, Google brought in more advertising revenue than any firm, online or off, and had risen to become the most profitable media company on the planet. Today billions in advertising dollars flee old media and are pouring into digital efforts, and this shift is reshaping industries and redefining skills needed to reach today's consumers. A decade ago the iPod also didn't exist and Apple was widely considered a tech-industry has-been. By spring 2010 Apple had grown to be the most valuable tech firm in the United States, selling more music and generating more profits from mobile device sales than any firm in the world. Moore's Law and other factors that make technology faster and cheaper have thrust computing and telecommunications into the hands of billions in ways that are both empowering the poor and poisoning the planet. Social media barely warranted a mention a decade ago, but today, Facebook's user base is larger than any nation, save for China and India. Firms are harnessing social media for new product ideas and for millions in sales. But with promise comes peril. When mobile phones are cameras just a short hop from YouTube, Flickr, and Twitter, every ethical lapse can be captured, every customer service flaw graffiti-tagged on the permanent record that is the Internet. The service and ethics bar for today's manager has never been higher. Speaking of globalization, China started the prior decade largely as a nation unplugged and offline. But today China has more Internet users than any other country and has spectacularly launched several publicly traded Internet firms including Baidu, Tencent, and Alibaba. By 2009, China Mobile was more valuable than any firm in the United States except for Exxon Mobil and Wal-Mart. Think the United States holds the number one ranking in home broadband access? Not even closethe United States is ranked fifteenth (Shankland, 2010). The way we conceive of software and the software industry is also changing radically. IBM, HP, and Oracle are among the firms that collectively pay thousands of programmers to write code that is then given away for free. Today, open source software powers most of the Web sites you visit. And the rise of open source has rewritten the revenue models for the computing industry and lowered computing costs for start-ups to blue chips worldwide. Cloud computing and software as a service is turning sophisticated, high-powered computing into a utility available to even the smallest businesses and nonprofits. Data analytics and business intelligence are driving discovery and innovation, redefining modern marketing, and creating a shifting knife-edge of privacy concerns that can shred corporate reputations if mishandled. And the pervasiveness of computing has created a set of security and espionage threats unimaginable to the prior generation. As the last ten years have shown, tech creates both treasure and tumult. These disruptions aren't going away and 2 1.1 TECH'S TECTONIC SHIFT: RADICALLY CHANGING BUSINESS LANDSCAPES 3 will almost certainly accelerate, impacting organizations, careers, and job functions throughout your lifetime. It's time to place tech at the center of the managerial playbook. Key Takeaways In the prior decade, firms like Google and Facebook have created profound shifts in the way firms advertise and individuals and organizations communicate. New technologies have fueled globalization, redefined our concepts of software and computing, crushed costs, fueled data-driven decision making, and raised privacy and security concerns. Questions and Exercises 1. Visit a finance Web site such as http://www.google.com/finance. Compare Google's profits to those of other major media companies. How have Google's profits changed over the past few years? Why have the profits changed? How do these compare with changes in the firm you chose? 2. How is social media impacting firms, individuals, and society? 3. How do recent changes in computing impact consumers? Are these changes good or bad? Explain. How do they impact businesses? 4. What kinds of skills do today's managers need that weren't required a decade ago? 5. Work with your instructor to decide ways in which your class can use social media. For example, you might create a Facebook group where you can share ideas with your classmates, join Twitter and create a hash tag for your class, or create a course wiki. References Porter, M., \"Strategy and the Internet,\" Harvard Business Review 79, no. 3 (March 2001): 62-78. Shankland, S., \"Google to Test Ultrafast Broadband to the Home,\" CNET, February 10, 2010. 1.2 It's Your Revolution Learning Objective After studying this section you should be able to do the following: 1. Name firms across hardware, software, and Internet businesses that were founded by people in their twenties (or younger). The intersection where technology and business meet is both terrifying and exhilarating. But if you're under the age of thirty, realize that this is your space. While the fortunes of any individual or firm rise and fall over time, it's abundantly clear that many of the world's most successful technology firmsorganizations that have had tremendous impact on consumers and businesses across industrieswere created by young people. Consider just a few: Bill Gates was an undergraduate when he left college to found Microsofta firm that would eventually become the world's largest software firm and catapult Gates to the top of the Forbes list of world's wealthiest people (enabling him to also become the most generous philanthropist of our time). Figure 1.1 Young Bill Gates appears in a mug shot for a New Mexico traffic violation. Microsoft, now headquartered in Washington State, had its roots in New Mexico when Gates and partner Paul Allen moved there to be near early PC maker Altair. Albuquerque, New Mexico police department - Bill Gates mugshot - public domain. 4 1.2 IT'S YOUR REVOLUTION 5 Michael Dell was just a sophomore when he began building computers in his dorm room at the University of Texas. His firm would one day claim the top spot among PC manufacturers worldwide. Mark Zuckerberg founded Facebook as a nineteen-year-old college sophomore. Steve Jobs was just twenty-one when he founded Apple. Tony Hsieh proved his entrepreneurial chops when, at twenty-four, he sold LinkExchange to Microsoft for over a quarter of a billion dollars (Chafkin, 2009). He'd later serve as CEO of Zappos, eventually selling that firm to Amazon for $900 million (Lacy, 2009). Sergey Brin and Larry Page were both twenty-something doctoral students at Stanford University when they founded Google. So were Jerry Yang and David Filo of Yahoo! All would become billionaires. If you want to go a little older, Kevin Rose of Digg and Steve Chen and Chad Hurley of YouTube were all in their late twenties when they launched their firms. Jeff Bezos hadn't yet reached thirty when he began working on what would eventually become Amazon. Of course, those folks would seem downright ancient to Catherine Cook, who founded MyYearbook.com, a firm that at one point grew to become the third most popular social network in the United States. Cook started the firm when she was a sophomorein high school. But you don't have to build a successful firm to have an impact as a tech revolutionary. Shawn Fanning's Napster, widely criticized as a piracy playground, was written when he was just nineteen. Fanning's code was the first significant salvo in the tech-fueled revolution that brought about an upending of the entire music industry. Finland's Linus Torvals wrote the first version of the Linux operating system when he was just twenty-one. Today Linux has grown to be the most influential component of the open source arsenal, powering everything from cell phones to supercomputers. BusinessWeek regularly runs a list of America's Best Young Entrepreneursthe top twenty-five aged twenty-five and under. Inc. magazine's list of the Coolest Young Entrepreneurs is subtitled the \"30 under 30\" (Fenn, 2009). While not exclusively filled with the ranks of tech start-ups, both of these lists are nonetheless dominated with technology entrepreneurs. Whenever you see young people on the cover of a business magazine, it's almost certainly because they've done something groundbreaking with technology. The generals and foot soldiers of the technology revolution are filled with the ranks of the young, some not even old enough to legally have a beer. For the old-timers reading this, all is not lost, but you'd best get cracking with technology, quick. Junior might be on the way to either eat your lunch or be your next boss. Key Takeaways Recognize that anyone reading this book has the potential to build an impactful business. Entrepreneurship has no minimum age requirement. The ranks of technology revolutionaries are filled with young people, with several leading firms and innovations launched by entrepreneurs who started while roughly the age of the average university student. Questions and Exercises 1. Look online for lists of young entrepreneurs. How many of these firms are tech firms or heavily rely on technology? Are there any sectors more heavily represented than tech? 6 INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY 2. Have you ever thought of starting your own tech-enabled business? Brainstorm with some friends. What kinds of ideas do you think might make a good business? 3. How have the costs of entrepreneurship changed over the past decade? What forces are behind these changes? What does this mean for the future of entrepreneurship? 4. Many universities and regions have competitions for entrepreneurs (e.g., business plan competitions, elevator pitch competitions). Does your school have such a program? What are the criteria for participation? If your school doesn't have one, consider forming such a program. 5. Research business accelerator programs such as Y-Combinator, TechStars, and DreamIt. Do you have a program like this in your area? What do entrepreneurs get from participating in these programs? What do they give up? Do you think these programs are worth it? Why or why not? Have you ever used a product or service from a firm that has participated in one of these programs? 6. Explore online for lists of resources for entrepreneurship. Share links to these resources using social media created for class. 7. Have any alumni from your institution founded technology firms or risen to positions of prominence in tech-focused careers? If so, work with your professor to invite them to come speak to your class or to student groups on campus. Your career services, development (alumni giving), alumni association, and LinkedIn searches may be able to help uncover potential speakers. References Chafkin, M. \"The Zappos Way of Managing,\" Inc., May 1, 2009. Fenn, D. \"30 Under 30: For Young Entrepreneurs, Safety in Numbers,\" Inc., October 1, 2009. Lacy, S. \"Amazon Buys Zappos; The Price Is $928m., Not $847m.,\" TechCrunch, July 22, 2009. 1.3 Geek UpTech Is Everywhere and You'll Need It to Thrive Learning Objectives After studying this section you should be able to do the following: 1. Appreciate the degree to which technology has permeated every management discipline. 2. See that tech careers are varied, richly rewarding, and poised for continued growth. Shortly after the start of the prior decade, there was a lot of concern that tech jobs would be outsourced, leading many to conclude that tech skills carried less value and that workers with tech backgrounds had little to offer. Turns out this thinking was stunningly wrong. Tech jobs boomed, and as technology pervades all other management disciplines, tech skills are becoming more important, not less. Today, tech knowledge can be a key differentiator for the job seeker. It's the worker without tech skills that needs to be concerned. As we'll present in depth in a future chapter, there's a principle called Moore's Law that's behind fast, cheap computing. And as computing gets both faster and cheaper, it gets \"baked into\" all sorts of products and shows up everywhere: in your pocket, in your vacuum, and on the radio frequency identification (RFID) tags that track your luggage at the airport. Well, there's also a sort of Moore's Law corollary that's taking place with people, too. As technology becomes faster and cheaper and developments like open source software, cloud computing, software as a service (SaaS), and outsourcing push technology costs even lower, tech skills are being embedded inside more and more job functions. What this means is that even if you're not expecting to become the next Tech Titan, your career will doubtless be shaped by the forces of technology. Make no mistake about itthere isn't a single modern managerial discipline that isn't being deeply and profoundly impacted by tech. Finance Many business school students who study finance aspire to careers in investment banking. Many i-bankers will work on IPOs, or initial public stock offerings, in effect helping value companies the first time these firms wish to sell their stock on the public markets. IPO markets need new firms, and the tech industry is a fertile ground that continually sprouts new businesses like no other. Other i-bankers will be involved in valuing merger and acquisition (M&A) deals, and tech firms are active in this space, too. Leading tech firms are flush with cash and constantly on the hunt for new firms to acquire. Cisco bought forty-eight firms in the prior decade; Oracle bought five firms in 2009 alone. And even in nontech industries, technology impacts nearly every endeavor as an opportunity catalyst or a disruptive wealth destroyer. The aspiring investment banker who doesn't understand the role of technology in firms and industries can't possibly provide an accurate guess at how much a company is worth. Table 1.1 Top Acquirers of VC-Backed Companies 2000-2009 7 8 INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY Acquiring Company Acquisitions Cisco 48 IBM 35 Microsoft 30 EMC Corporation 25 Oracle Corp. 23 Broadcom 18 Symantec 18 Hewlett-Packard 18 Google 17 Sun Microsystems 16 Source: VentureSource. Those in other finance careers will be lending to tech firms and evaluating the role of technology in firms in an investment portfolio. Most of you will want to consider tech's role as part of your personal investments. And modern finance simply wouldn't exist without tech. When someone arranges for a bridge to be built in Shanghai, those funds aren't carried over in a suitcasethey're digitally transferred from bank to bank. And forces of technology blasted open the two-hundred-year-old floor trading mechanism of the New York Stock Exchange, in effect forcing the NYSE to sell shares in itself to finance the acquisition of technology-based trading platforms that were threatening to replace it. As another example of the importance of tech in finance, consider that Boston-based Fidelity Investments, one of the nation's largest mutual fund firms, spends roughly $2.8 billion a year on technology. Tech isn't a commodity for financeit's the discipline's lifeblood. Accounting If you're an accountant, your career is built on a foundation of technology. The numbers used by accountants are all recorded, stored, and reported by information systems, and the reliability of any audit is inherently tied to the reliability of the underlying technology. Increased regulation, such as the heavy executive penalties tied to the Sarbanes-Oxley Act in the United States, have ratcheted up the importance of making sure accountants (and executives) get their numbers right. Negligence could mean jail time. This means the link between accounting and tech have never been tighter, and the stakes for ensuring systems accuracy have never been higher. Business students might also consider that while accounting firms regularly rank near the top of BusinessWeek's \"Best Places to Start Your Career\" list, many of the careers at these firms are highly tech-centric. Every major accounting firm has spawned a tech-focused consulting practice, and in many cases, these firms have grown to be larger than the accounting services functions from which they sprang. Today, Deloitte's tech-centric consulting division is larger than 1.3 GEEK UPTECH IS EVERYWHERE AND YOU'LL NEED IT TO THRIVE 9 the firm's audit, tax, and risk practices. At the time of its spin-off, Accenture was larger than the accounting practice at former parent Arthur Andersen (Accenture executives are also grateful they split before Andersen's collapse in the wake of the prior decade's accounting scandals). Now, many accounting firms that had previously spun off technology practices are once again building up these functions, finding strong similarities between the skills of an auditor and skills needed in emerging disciplines such as information security and privacy. Marketing Technology has thrown a grenade onto the marketing landscape, and as a result, the skill set needed by today's marketers is radically different from what was leveraged by the prior generation. Online channels have provided a way to track and monitor consumer activities, and firms are leveraging this insight to understand how to get the right product to the right customer, through the right channel, with the right message, at the right price, at the right time. The success or failure of a campaign can often be immediately assessed base on online activity such as Web site visit patterns and whether a campaign results in an online purchase. The ability to track customers, analyze campaign results, and modify tactics has amped up the return on investment of marketing dollars, with firms increasingly shifting spending from tough-to-track media such as print, radio, and television to the Web (Pontin 2009). And new channels continue to emerge. Firms as diverse as Southwest Airlines, Starbucks, UPS, and Zara have introduced apps for the iPhone and iPod touch. In less than four years, the iPhone has emerged as a channel capable of reaching over 75 million consumers, delivering location-based messages and services, and even allowing for cashless payment. The rise of social media is also part of this blown-apart marketing landscape. Now all customers can leverage an enduring and permanent voice, capable of broadcasting word-of-mouth influence in ways that can benefit and harm a firm. Savvy firms are using social media to generate sales, improve their reputations, better serve customers, and innovate. Those who don't understand this landscape risk being embarrassed, blindsided, and out of touch with their customers. Search engine marketing (SEM), search engine optimization (SEO), customer relationship management (CRM), personalization systems, and a sensitivity to managing the delicate balance between gathering and leveraging data and respecting consumer privacy are all central components of the new marketing toolkit. And there's no looking backtech's role in marketing will only grow in prominence. Operations A firm's operations management function is focused on producing goods and services, and operations students usually get the point that tech is the key to their future. Quality programs, process redesign, supply chain management, factory automation, and service operations are all tech-centric. These points are underscored in this book as we introduce several examples of how firms have designed fundamentally different ways of conducting business (and even entirely different industries), where value and competitive advantage are created through technology-enabled operations. Human Resources Technology helps firms harness the untapped power of employees. Knowledge management systems are morphing into social media technologiessocial networks, wikis, and Twitter-style messaging systems that can accelerate the ability of a firm to quickly organize and leverage teams of experts. Human resources (HR) directors are using technology for employee training, screening, and evaluation. The accessibility of end-user technology means that every employee can reach the public, creating an imperative for firms to set policy on issues such as firm representation and disclosure and to continually monitor and enforce policies as well as capture and push out best practices. The successful HR manager recognizes that technology continually changes an organization's required skill sets, as well as employee expectations. The hiring and retention practices of the prior generation are also in flux. Recruiting hasn't just moved online; 10 INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY it's now grounded in information systems that scour databases for specific skill sets, allowing recruiters to cast a wider talent net than ever before. Job seekers are writing rsums with keywords in mind, aware that the first cut is likely made by a database search program, not a human being. The rise of professional social networks also puts added pressure on employee satisfaction and retention. Prior HR managers fiercely guarded employee directories for fear that a headhunter or competitive firm might raid top talent. Now the equivalent of a corporate directory can be easily pulled up via LinkedIn, a service complete with discrete messaging capabilities that can allow competitors to rifle-scope target your firm's best and brightest. Thanks to technology, the firm that can't keep employees happy, engaged, and feeling valued has never been more vulnerable. The Law And for those looking for careers in corporate law, many of the hottest areas involve technology. Intellectual property, patents, piracy, and privacy are all areas where activity has escalated dramatically in recent years. The number of U.S. patent applications waiting approval has tripled in the past decade, while China saw a threefold increase in patent applications in just five years (Schmid & Poston, 2009). Firms planning to leverage new inventions and business methods need legal teams with the skills to sleuth out whether a firm can legally do what it plans to. Others will need legal expertise to help them protect proprietary methods and content, as well as to help enforce claims in the home country and abroad. Information Systems Careers While the job market goes through ebbs and flows, recent surveys have shown there to be more IT openings than in any 2 field except health care1. Money magazine ranked tech jobs as two of the top five \"Best Jobs in America.\" BusinessWeek ranks consulting (which heavily hires tech grads) and technology as the second and third highest paying industries for recent college graduates (Gerdes, 2008). Technology careers have actually ranked among the safest careers to have during the most recent downturn (Kaneshige, 2009). And Fortune's ranks of the \"Best Companies to Work For\" is full of 3 technology firms and has been topped by a tech business for four years straight . Students studying technology can leverage skills in ways that range from the highly technical to those that emphasize a tech-centric use of other skills. Opportunities for programmers abound, particularly for those versed in new technologies, but there are also roles for experts in areas such as user-interface design (who work to make sure systems are easy to use), process design (who leverage technology to make firms more efficient), and strategy (who specialize in technology for competitive advantage). Nearly every large organization has its own information systems department. That group not only ensures that systems get built and keep running but also increasingly takes on strategic roles targeted at proposing solutions for how technology can give the firm a competitive edge. Career paths allow for developing expertise in a particular technology (e.g., business intelligence analyst, database administrator, social media manager), while project management careers leverage skills in taking projects from conception through deployment. Even in consulting firms, careers range from hard-core programmers who \"build stuff\" to analysts who do no programming but might work identifying problems and developing a solutions blueprint that is then turned over to another team to code. Careers at tech giants like Apple, Google, and Microsoft don't all involve coding end-user programs either. Each of these firms has their own client-facing staff that works with customers and partners to implement solutions. Field engineers at these firms may work as part of a sales team to show how a given company's software and services can be used. These engineers often put together prototypes that are then turned over to a client's in-house staff for further development. An Apple field engineer might show how a firm can leverage podcasting in its organization, while a Google field engineer can help a firm incorporate search, banner, and video ads into its online efforts. Careers that involve consulting and field engineering are often particularly attractive for those who enjoy working with an ever-changing list of clients and problems across various industries and in many different geographies. Upper-level career opportunities are also increasingly diverse. Consultants can become partners who work with the most senior executives of client firms, helping identify opportunities for those organizations to become more 1.3 GEEK UPTECH IS EVERYWHERE AND YOU'LL NEED IT TO THRIVE 11 effective. Within a firm, technology specialists can rise to be chief information officer or chief technology officerpositions focused on overseeing a firm's information systems development and deployment. And many firms are developing so-called C-level specialties in emerging areas with a technology focus, such as chief information security officer (CISO), and chief privacy officer (CPO). Senior technology positions may also be a ticket to the chief executive's suite. A recent Fortune article pointed out how the prominence of technology provides a training ground for executives to learn the breadth and depth of a firm's operations and an understanding of the ways in which firms are vulnerable to attack and where it can leverage opportunities for growth (Fort, 2009). Your Future With tech at the center of so much change, realize that you may very well be preparing for careers that don't yet exist. But by studying the intersection of business and technology today, you develop a base to build upon and critical thinking skills that will help evaluate new, emerging technologies. Think you can afford to wait on tech study, then quickly get up to speed? Think about it. Whom do you expect to have an easier time adapting and leveraging a technology like social mediatoday's college students who are immersed in technology or their parents who are embarrassingly dipping their toes into the waters of Facebook? Those who put off an understanding of technology risk being left in the dust. Consider the nontechnologists who have tried to enter the technology space these past few years. Newscorp head Rupert Murdoch piloted his firm to the purchase of MySpace only to see this one-time leader lose share to rivals (Malik, 2010). Former Warner executive Terry Semel presided over Yahoo!'s malaise as Google blasted past it (Thaw, 2007). Barry Diller, the man widely credited with creating the Fox Network, led InterActive Corp (IAC) in the acquisition of a slew of tech firms ranging from Expedia to Ask.com, only to break the empire up as it foundered. And Time Warner head Jerry Levin presided over the acquisition of AOL, executing what many consider to be one of the most disastrous mergers in U.S. business history (Quinn, 2009). Contrast these guys against the technology-centric successes of Mark Zuckerberg (Facebook), Steve Jobs (Apple), and Sergey Brin and Larry Page (Google). While we'll make it abundantly clear that a focus solely on technology is a recipe for disaster, a business perspective that lacks an appreciation for tech's role is also likely to be doomed. At this point in history, technology and business are inexorably linked, and those not trained to evaluate and make decisions in this ever-shifting space risk irrelevance, marginalization, and failure. Key Takeaways As technology becomes cheaper and more powerful, it pervades more industries and is becoming increasingly baked into what were once nontech functional areas. Technology is impacting every major business discipline, including finance, accounting, marketing, operations, human resources, and the law. Tech jobs rank among the best and highest-growth positions, and tech firms rank among the best and highest-paying firms to work for. Information systems (IS) jobs are profoundly diverse, ranging from those that require heavy programming skills to those that are focused on design, process, project management, privacy, and strategy. 12 INFORMATION SYSTEMS: A MANAGER'S GUIDE TO HARNESS TECHNOLOGY Questions and Exercises 1. Look at Fortune's \"Best Companies to Work For\" list. How many of these firms are technology firms? Which firm would you like to work for? Are they represented on this list? 2. Look at BusinessWeek's \"Best Places to Start Your Career\" list. Is the firm you mentioned above also on this list? 3. What are you considering studying? What are your short-term and long-term job goals? What role will technology play in that career path? What should you be doing to ensure that you have the skills needed to compete? 4. Which jobs that exist today likely won't exist at the start of the next decade? Based on your best guess on how technology will develop, can you think of jobs and skill sets that will likely emerge as critical five and ten years from now? 1 2009 figures are from http://www.indeed.com. 2 CNNMoney, \"Best Jobs in America,\" 2009, http://money.cnn.com/magazines/moneymag/bestjobs/2009/ snapshots/1.html. 3 Fortune, \"Best Companies to Work For,\" 2007-2010. For 2010 list, see http://money.cnn.com/magazines/fortune/ bestcompanies/2010/full_list/index.html. References Fortt, J., \"Tech Execs Get Sexy,\" Fortune, February 12, 2009. Gerdes, L., \"The Best Places to Launch a Career,\" BusinessWeek, September 15, 2008. Technology careers have actually ranked among the safest careers to have during the most recent downturn. Kaneshige, T., \"Surprise! Tech Is a Safe Career Choice Today,\" InfoWorld, February 4, 2009. Malik, O., \"MySpace, R.I.P.,\" GigaOM, February 10, 2010. Pontin, J., \"But Who's Counting?\" Technology Review, March/April 2009. Quinn, J., \"Final Farewell to Worst Deal in HistoryAOL-Time Warner,\" Telegraph (UK), November 21, 2009. Schmid, J. and B. Poston, \"Patent Backlog Clogs Recovery,\" Milwaukee Journal Sentinel, August 15, 2009. Thaw, J., \"Yahoo's Semel Resigns as Chief amid Google's Gains,\" Bloomberg, June 18, 2007. 1.4 The Pages Ahead Learning Objective After studying this section you should be able to do the following: 1. Understand the structure of this text, the issues and examples that will be introduced, and why they are important. Hopefully this first chapter has helped get you excited for what's to come. The text is written in a style meant to be as engaging as the material you'll be reading for the rest of your management careerarticles in business magazines and newspapers. The introduction of concepts in this text are also example rich, and every concept introduced or technology discussed is always grounded in a real-world example to show why it's important. But also know that while we celebrate successes and expose failures in that space where business and technology come together, we also recognize that firms and circumstances change. Today's winners have no guarantee of sustained dominance. What you should acquire in the pages that follow are a fourfold set of benefits that (1) provide a description of what's happening in industry today, (2) offer an introduction to key business and technology concepts, (3) offer a durable set of concepts and frameworks that can be applied even as technologies and industries change, and (4) develop critical thinking that will serve you well throughout your career as a manager. Chapters don't have to be read in order, so feel free to bounce around, if you'd like. But here's what you can expect: Chapter 2 \"Strategy and Technology: Concepts and Frameworks for Understanding What Separates Winners from Losers\" focuses on building big-picture skills to think about how to leverage technology for competitive advantage. Technology alone is rarely the answer, but through a rich set of examples, we'll show how firms can weave technology into their operations in ways that create and reinforce resources that can garner profits while repelling competitors. A mini case examines tech's role at FreshDirect, a firm that has defied the many failures in the online grocery space and devastated traditional rivals. BlueNile, Dell, Lands' End, TiVo and Yahoo! are among the many firms providing a rich set of examples illustrating successes and failures in leveraging technology. The chapter will show how firms use technology to create and leverage brand, scale economies, switching costs, data assets, network effects, and distribution channels. We'll introduce how technology relates to two popular management frameworksthe value chain and the five forces model. And we'll provide a solid decision framework for considering the controversial and often misunderstood role that technology plays among firms that seek an early-mover advantage. In Chapter 3 \"Zara: Fast Fashion from Savvy Systems\USING MICROSOFT EXCEL 2013 Independent Project 7-4 Independent Project 7-4 Employees at Classic Gardens and Landscapes (CGL) are requesting that management create a password-protected workbook from a template that allows employee access to selected cells to update relevant data. Share the workbook draft to allow multiple employees to edit the file. After merging the changes, save the file as a template and create the new requested encrypted workbook. This project has been modified for use in SIMnet. The complete project is available in the Microsoft Office 2013 In Practice Excel Complete as well as the SIMBook edition. Skills Covered in This Project Set data validation for lists. Create an input message. Create an alert message. Share a workbook. Protect a shared workbook. Apply edit options. Merge workbooks. Highlight changes. Accept or reject edits. Unlock cells for editing. Protect a worksheet. Encrypt a workbook Step 1 Download start file 1. Open the ActualOrders-07 start file. Click the Enable Editing button. 2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 3. Apply data validation. a. Set the range of G6:G10 to allow the user to choose a bonus of 2000, 5000, or None from a list. b. Create an input message titled Data Entry that displays Please select 2000, 5000, or None. as the message to appear when you select the cell. c. Create a Stop error message titled Entry Error that displays Incorrect Entry! You must select one of the following options: 2000, 5000, None. as the message to appear when the cell contents is incorrect. 4. Unlock cells A6:D10 and G6:G10 in the worksheet for users to edit. 5. Protect the worksheet with PasswordA as the password and allow users to Select locked cells, Select unlocked cells, and Edit objects. Save the file. 6. Share the workbook to Allow changes by more than one user at the same time and set the Keep change history for option to 25 days. 7. Protect the shared workbook and allow for Sharing with track changes. 8. Insert the following comment in cell A7: Please confirm that this is the correct category title. and save the file. 9. Make a copy of the shared workbook and name the copy [your initials] Excel 7-4User2. 10. Edit [your initials] Excel 7-4User2. a. Click cell A6 and type Landscape Care. b. c. Insert the following comment in cell A10: Can we drop \"Design\" from this category? Save and close the file. (Do not close Excel.) Excel 2013 Chapter 7 Setting Validation, Creating Forms, Sharing and Protecting Workbooks Last Updated: 10/13/15 Page 1 USING MICROSOFT EXCEL 2013 Independent Project 7-4 11. Add the Compare and Merge Workbooks command to the Quick Access toolbar. 12. Open your project file (Your.Name-ActualOrders-07.xlsx) if necessary. 13. Merge the [your initials] Excel 7-4User2 copy of the shared workbook. 14. Highlight changes Not yet reviewed from Everyone. 15. Accept all the changes Not yet reviewed by Everyone and save the file. Only one change is made. 16. Unshare the workbook and incorporate the comments. a. Select the Unprotect Shared Workbook button [Review tab, Changes group]. b. Click the Share Workbook button [Review tab, Changes group] and clear the check box in the Editing tab. Select OK in the Editing tab and Yes in the message box. c. Step 2 Type Trees and Shrubs in A7 and Consulting in A10. 17. Save and close the workbook. Upload & Save 18. Upload and save your project file (Your.Name-ActualOrders-07.xlsx). Step 3 19. Submit project for grading. Grade my Project Excel 7-4 Completed, with Error message showing Excel 2013 Chapter 7 Setting Validation, Creating Forms, Sharing and Protecting Workbooks Last Updated: 10/13/15 Page 2