Info Systems Exam Review 10 21 2013 Operational Effectiveness vs Strategic Position Company without operational effectiveness cannot sustain its competitive advantage Straddling Companies spread themselves thin by not concentrating on a certain area of business Assests and businesses that will help sustain competitive advantage Resources that are valuable rare hard to imitate hard to substitute o All form capabilities o Use the brand name scale data reputation Identify the role of technology in attaining a competitive advantage Transaction Processing System TPS Point of sale analyze the data summarize and generate reports Very structured not interactive Types of Interactive systems Executive support systems Decision support systems o Both help with long term decision making Variable vs Parameter Parameters cannot change must be observed Variable is up to change Value web Vertical integration Helps companies coordinate different parts of their supply chain firm owns pretty much all aspects of manufacturing value chain 5 Forces Model shows how attractive it is to enter a new industry Power of supplier Power of customer Product substitution Entering the industry Data definition language Gives a reference of what everything in the data means A person place event or thing for which we want to capture data If you are looking for a specific number in Excel do What If analysis and find Entity goal seek Difference between table 1 and table 2 Table 1 only change one variable Table 2 change two variables at the same time No empty spaces when using names on excel Questions will be more theoretical use rather than step by step process 45 MC or True and False 9 Excel based questions 10 21 2013 10 21 2013
View Full Document