CIS 235

  1. CHAPTER 1
    What are the 5 components of information systems?
    • Sofware
    • Hardware
    • Data
    • Procedures
    • People
  2. CHAPTER 1
    Why are information systems created?
    To help people who work in a business to acheive goals and objective.
  3. CHAPTER 1
    Give an example of each of the 5 components of IS
    • Software: microsoft word, etc
    • Hardware: computer, keyboard, monitor
    • Data: the words, sentences/RAW facts and figures
    • Procudures: the methods you use/step by step way of running business/flow charts, etc.
    • BMP-Business process management
    • People: you
  4. CHAPTER 1
    Which comonent of IS does
    "words and sentences"
    belong to?
  5. CHAPTER 1
    Which comonent of IS does
    "Microsoft Excel"
    belong to?
  6. CHAPTER 1
    Which comonent of IS does
    belong to?
  7. CHAPTER 1
    Which comonent of IS does
    belong to?
  8. CHAPTER 1
    What is the differnce between IT & IS?
    IT refers to the products, methods, inventions, and standards that are used fro the purpose of producing information. IT is hardware, software, and data components.

    IS-the ASSEMBLY of hardware, software, data, procedures, and people that produce information.

    You can buy IT but you can NEVER buy IS
  9. CHAPTER 1
    What is the difference between IS and MIS?
  10. CHAPTER 1
    List different types of IS
  11. CHAPTER 1
    Definition IT
    The products, methods, inventions and standards that are used for the purpose of producing information.
  12. CHAPTER 1
    Definition IS
    A group of components that interact to produce information.
  13. CHAPTER 1
    Definition MIS
    the development and use of information systems that help businesses achieve their goals and objectives.
  14. CE1-2
    Content Management Systems
    • Information systems that tranck organizational documents, Wev pages, and related material. pg 342
    • Google is the world's largest content management system
  15. CE1-2
    What are the tools for content management?
  16. CE1-2
    What is version management?
    • systems that track changes to documents and provide features to accommodate concurrent work.
    • (Google Docs, Windows Sky Drive)
  17. CE1-2
    What are the tools for version management? What do they track?
    Google Docs, Windows Live Sky Drive

    Track changes and provide features to accomodate concurrent work
  18. CE1-2
    What is a WIKI?
    A wiki is a website whose users can add, modify, or delete its content via a web browser using a simplified markup language or a rich-text editor.

    Wikis are typically powered by wiki software and are often created collaboratively by multiple users. Examples include community websites, corporate intranets, knowledge management systems, and notetaking.
  19. CHAPTER 1
    Moore's Law
    • 1965 Gordon Moore.
    • "the number of transistors per square inch on an intergrated chip doubles every 18 months"
  20. CHAPTER 1
    What is "Systems Thinking" vs "Abstract Thinking"
    Abstract reasoning-the ability to make and manipulate models.

    Systems Thinking-the ability to model the components of the system, to connect the inputs and outputs among those components into a sensible whole
  21. CHAPTER 1
    Why do companies create new information systems
    The existing ones don't adequately meet business needs
  22. CHAPTER 2
    What is a business process?
    network of activites, roles, resources, repositories, and data flows that interact to accomplish a business function
  23. CHAPTER 2
    What are the compnents of a business process?
    • Activities
    • Roles
    • Resources
    • Repositories
    • Data Flows
  24. CHAPTER 2
    On a business flow chart a DIAMOND represents
  25. CHAPTER 2
    On a busines flow chart a SCROLL represents
  26. CHAPTER 2
    On a business flow chart, DIRECTED ARROWS represent
  27. CHAPTER 2
    On a business flow chart, RECTANGLES represent
  28. CHAPTER 2
    Which one of the 5 components of IS serves as a bridge between the human side and the computer side?
  29. CHAPTER 2
    What does it mean to automate a manual processs?
    moves work from the human side to the computer side
  30. CHAPTER 2
    What is data vs. information
    data is recorded facts and figures

    • Information is Data presented in a meaningful context
  31. CHAPTER 2
    How do you make a decision using data?
    take data, present in a meaningful manner (information), then derive knowledge from the information, and then make a decision.
  32. CHAPTER 2
    What is knowledge
    • What you know-the answer
    • *now you can make decisions
  33. CHAPTER 2
    Data vs Information
    Qualaties of good information
    • Information must be
    • accurate
    • tiemley
    • relevant
    • just barely sufficient info??
    • worth its cost
  34. CE 3
    What is an operational decision? Give an example.
    • day to day activities
    • ex. How many widgets should we order from vendor A?/ Should we extend credit to vendor B?

    Systems that support Operational Decision Making: Transaction Processing Systems (TPS)-information systems that support operational decison making/lowest level of decision made by machines.
  35. CE 3
    What are managerial decisions?
    • concerns the allocation and utilization of resources-some automated/some augmented
    • ex. how much should we budget for computer hardware and programs for the dept/how many engineers should we assign to project B

    Information Systems that support managerial decision making-Managerial Information Systems (MIS)
  36. CE 3
    What is an MIS? Give an example
    Managerial Information Systems
  37. CE 3
    What are strategic decisions?
    • concerns broader-scope, significant magnitude, organizational issues-Augmented
    • ex, Should we start a new product line?/Should we acquire company A?

    Information systems that support strategic decision making are - EIS-Executive Information Systems
  38. CE 3
    What is an EIS? Give an example.
    • Executive Information System
    • Example:
  39. CE 3

    Given the name of a system, identify if it is a
    TPS,MIS, EIS??
  40. CE 3
    Automation vs Augmentation
    Automated-hardware and software do most of the work

    Augmented-humans do the bulk of the work
  41. CE 3
    What is the relationship between the decision type and the IS type?
    • DT-Intellingence Gathering
    • IS-communication applications (email, video conferencing, word processing, presentation/Query and reporting sytems/Data analysis applications

    • DT-Alternatives formulation
    • IS-communication applications (email,etc)

    • DT-Choice
    • IS-spreadsheets, financial modeling, other modeling

    • DT Implementation
    • IS-Communication applications (email, etc)

    • DT Review
    • IS-Communications/query and reporting/spreadsheets and other analysis
  42. Decision Making Steps
    • 1-Intellingence Gathering
    • 2-Alternatives formulatin
    • 3-Choice
    • 4-Implementation
    • 5-Review
  43. CHAPTER 3
    What 5 forces determine industry structure?
    • 1-Competition from vendors of substitutes
    • 2-Competition from NEW competitors (entrants)
    • 3-existing rivals
    • 4-Bargaining Power of - suppliers
    • 5-Bargaining Power of - customers
  44. CHAPTER 3
    Give "strong" and "weak" examples of each force (that determine industry structure)
    pg 49
  45. CHAPTER 3
    What is the model of 4 competitive strategies?
    How do businesses use it as a differentitaion strategy?
  46. CHAPTER 3
    What is a value chain?
    network of value created activities
  47. CHAPTER 3
    What are the primary activities in the value chain?
    • 5 primary-directly to the production
    • Inbound Logistics
    • Operations Manufacturing
    • Outbound Logistics
    • Sales and Marketing
    • Customer Service
  48. CHAPTER 3
    What are the supporting activities in the value chain?
    4 support-assist and facilitate primaryprocurmenttechnologyHRfirm infrastucture
  49. CHAPTER 3
    Explain the difference between Walmart's and Ferrari's competitive strategy
  50. CHAPTER 3
    What is margin?
    The difference between the value the activity generates and the cost of the activity
  51. CHAPTER 3
    What are the three principles of product impletmentation for a competitive advantage?
    • 1) Create a new product or service
    • 2) Enhance products or services
    • 3) Differnetiate products or services
  52. CHAPTER 3
    What are the 5 principles of PROCESS implementation?
    • 1) Lock in customers and buyers
    • 2) Lock in suppliers
    • 3) raise barriers to market entry
    • 4) establish alliances
    • 5) reduce costs
  53. CHAPTER 3
    How did Harrah's gain competive advantage?
    They developed a customer relationship system that the other casinos didn't have.
  54. CHAPTER 3
    What was the barrier to entry for Harrah's rivals?
    money, time (customers harder to et new than retain)
  55. CHAPTER 3
    What is closed loop marketing?
    is NOT loyalty marketing!!

    • Send offer
    • analize results (measure, test, track)
    • evaluate
    • Refine
  56. CHAPTER 3
    Why and how do organizations create barries to entry?
    To make it harder for competors to "catch up"

    How? patents, complex and innovative systems, customer loyalty????
  57. CHAPTER 3
    What are different types of barriers to entry?
    • Financial
    • Technology
    • Customer Loyalty (brand recognition)
  58. Knowledge Management System (KMS)
    An informatin system for storing and retrieving organizational knowledge, whether that knowledge is in the form of data, documents, or employee know-how p 211
  59. CE 4
    What is knowledge management? (KM)
    • The process of creating value from intellectual capital and sharing that knowledge with empoyees, managers, suppliers, customers, and others who need that captial.
    • (Although KM is supported by IS technology, KM is NOT technology. It's a process supported by the 5 compnents of IS with an emphasis on people, their knowledge,and effective menas for sharing that knowledge with others.)
  60. CE 4
    What are the benefits of KM?
    • 1-fosters innovation by encouraging the free flow of ideas
    • 2-improves customer service by streamlining response time
    • 3-boosts revenues by getting products and services to market faster.
    • 4-enhances employee retention rates by recognizing the value of employees' knowledge and rewarding them for it.
    • 5-streamlines operations and reduces costs by eliminating redundanct or unnecessary porcesses.
  61. CE 4
    What are the basic functions of content management systems?
  62. CE 4
    What are the challenges of content management systems?
    • 1-huge
    • 2-documents do not exist in isolation from each other
    • 3-document contents are perishable
    • 4-every doc must be translated into all language
    • 5-content must be arranged and indexed
  63. CE 4
    What are expert systems?
    form of KM. Rule-based sytems that encode knowledge in the form of IF/Then rules.
  64. CHAPTER 5
    self-describing collection of intergrated records. Collection of tables PLUS relationships among the rows in those tables PUS special data called metadata, that describes the structure of the database.
  65. CHAPTER 5
    What are the 3 components of a Database?
    • 1-tables or files
    • 2-relationships
    • 3-metadata
  66. CHAPTER 5
    What is database vs DMBS?
    DBMS-the PROGRAM use to create, process, and administer a database.
  67. CHAPTER 5
    What is a record?
    • row-
    • the collection of data for all columns is called a row (record)
  68. CHAPTER 5
    What is another name for a record?
  69. CHAPTER 5
    What is a column?
  70. CHAPTER 5
    What is another name for a column?
  71. CHAPTER 5
    What is a file?
    • aka, table
    • a group of similar rows or records
  72. CHAPTER 5
    character of data
  73. CHAPTER 5
    What is another name for a file?
  74. CHAPTER 5
    What is a primary key?
    uniquely identifies each record in the table
  75. CHAPTER 5
    What is a foreign key? Why do we use them?
    a column or group of colums used to represent relationships. Values of the foreign key match values of the promary key in a different (foreign) table. pg 103
  76. CHAPTER 5
    What is metadata? How do you describe it?
    • data that describes data
    • Field Properites are meta data
  77. CHAPTER 5
    What is a data base application system vs DBMS?
    DBMS is the program and a database aplication is a collection of forms , reports, queries, and application programs that process a database.
  78. CHAPTER 5
    What are the components of a datbase application system?
    forms, queries, and application programs
  79. CE 7
    What is a data model? Why is it important to build a data model?
    summary of the requirements of the database in a logical representation of the structure of the data
  80. CE 7
    What is an ER Diagram?
    A data model that visualy describes the entities (things) that will be stored in the database and the relationships amonth those entities.
  81. CE 7
    What is an identifier?
    an attribute (or group of) whose value is associated with one and only one entity instance. p 385

    ex. OrderNumber is an identifier of Order because only one Order insatance has a given value of OrderNumber
  82. CE 7
    What are the attributes? Define and give and example.
    describe the characteristics of the entity.

    • ex attributes of Salesperson are
    • SalespersonName
    • Email
    • Phone
  83. CE 7
    What is normalization? What is normal form?
    the process of converting poorly structured tables into two or more well-structured tables.

    Every table should only have ONE theme
  84. CE 7
    How do you solve data integrity problems?
    by normalizing data and having tables have only 1 theme so if they need to be changed there is not a problem
  85. CE 7
    What is cardinality?
    • the relationship of one table to another
    • One-to Many
    • Many to Many
    • one to one
    • etc.
  86. CE 7
    Know the figures that depict different type of cardinality
  87. CE 7
    In a one-to-many relationship, in which table is the foreign key stored?
    in the many
  88. CE 7
    Is "name" a good identifier? Why or why not?
    no, should be first and last name separate
  89. CE 7
    Who are the final judges as to what data the database should contain?
    the users
  90. CE 8
    How do you use the Criteria row in the Design View in Access?
    select critera in the column you want to limit and put it your criteria
  91. CE 8
    How do you run a Cross Tab Query in Access?
    make sure all data is where you want it and run a simple query if necessary. select query wizzard. cross tab query. choose colums and rows and calculations.
  92. CE 8
    What is the difference between a simple query and a cross tab query?
    in a simple query you choose which tables to combine, in a cross tab query you must create a simple query first to make sure all of the data is inculded and then you choose rows and column and a calculation in the intersecting cells.
  93. CE 8
    Given an IIF statement you should be able to tell the outcome.
    • IIF constraint, if true, if false
    • <field names>
  94. CHAPTER 7/CE 11-12-13
    Scope of IS

    • Workgroup

    • Enterprise

  95. Personal Information Systems
    • ex: contact manager
    • single user; procedures informal; problems isolated; data duplication among employees; easy to manage change
  96. Workgroup Information Systems
    • ex: scheduling of groundskeeping
    • 10 to 100 users; procedures understood witin group; problem solutions within group; data duplication amongh departments; somewhat difficult to change
  97. Enterprise Information Systems
    • ex: Charging of membership fees
    • 100 to 1000's of users; procedures formalized; problems solutions affect enterprise; data duplication minimized; very difficult to change
  98. Interenterprise Information Systems
    ex: ordering of restaurant supplies from suppliers

    1000's of users; procedures formalized; problems solutions affect multiple organizations, controlled data duplication; difficult to change; interorganization IS required.
  99. CHAPTER 7/CE 11-12-13
    What is a silo and how do they arise?
    A silo is a condition that existswhen data are isolated in separated information systems.

    They arise as a consequence of an organization's growth and increasing use of information systems.
  100. CHAPTER 7/CE 11-12-13
    Why are silos problematic?
    They are not a problem until they begin to share data about the same entities (duplicate data).
  101. CHAPTER 7/CE 11-12-13
    What are common departmental applications?
    List Departments
    • Sales and marketing
    • Operations
    • Manufacturing
    • Customer Service
    • Human Resources
    • Accounting
  102. CHAPTER 7
    Common Departmental Applications for:
    Sales and Marketing
    • Lead generation
    • lead tracking
    • customer management
    • sales forecasting
    • product and brand management
  103. CHAPTER 7
    Common Departmental Applications for:
    • order entry
    • order management
    • finsihed-goods inventory managment
  104. CHAPTER 7
    Common Departmental Applications for:
    • inventory (raw materials, goods-in-process)
    • planning
    • scheduling
    • operations
  105. CHAPTER 7
    Common Departmental Applications for:
    Customer Service
    • order tracking
    • account tracking
    • customer support and training
  106. CHAPTER 7
    Common Departmental Applications for:
    Human Resources
    • recruiting
    • compensation
    • assessment
    • HR planning
  107. CHAPTER 7
    Common Departmental Applications for:
    • general ledger
    • financial reporting
    • cost accounting
    • accounts receivable
    • accounts payable
    • cash management
    • budgeting
    • treasury management
  108. Enterprise Information Systems
    Information systems that span an organization and support activities in mulitple departments.
  109. Interenterprise systems
    information systems that are shared by two or more independent organizations.
  110. CHAPTER 7/CE 11-12-13
    How do ERP, CRM, EAI suppport Enterprise Systems?
  111. Inherent Processes
    predesigned prodedures for using the software, products that saved organizations from expensive and time-consuming business processes reengineering. Supposedly based on industry's "best practices"
  112. CHAPTER 7
    What are the 4 phases of a customer life cycle>
    • 1-Marketing
    • 2-Aquisition
    • 3-Relationship Management
    • 4-Loss/Churn
  113. CHAPTER 7/CE 11-12-13
    What are some CRM applications?
    • Act! Goldmine (lower end)
    • Sugar (larger organizations)
    • Microsof Dynamics
    • Oracle/Siebel-suite of products
  114. ERP
    • Enterprise Resource Planning
    • suite of applications, a database and a set of inherent processes for consolidating business operations into a single, consistent, computing platform.
    • (supply chain, manufacturing,CRM,HR, Accounting)
    • SAP leader of ERPs
  115. EAI
    Enterprise Application Integration-suite of software aplications that integrates existing sustems by providing layers of software that connect applications together.
  116. CHAPTER 7/CE 11-12-13
    What are the challenges of ERP implementation?
    • Collaborative managment
    • Requirements Gaps
    • Transition Problems
    • Employee Resistance
  117. CHAPTER 7/CE 11-12-13
    What are Functional Processes, applications and systems vs ERP?
  118. CE 13
    What is a suppy chain?
  119. CHAPTER 7/CE 11-12-13
    What factors (drivers) affect Supply Chain Performance?
    • facilities-location, size, and operations methodology of the places where products are fabricated, assembled, or stored.
    • inventory-size, inventory managment (includes all the materials in the supply chain, including raw, wip, and fg.)
    • transportation-in-house/outsourced, mode, routing
    • information-affecting the wyas that organizations in the supply chain request, respond, and inform one another-purpose, availability, means
  120. Bullwhip Effect
    a phenomenon in which the variability in the size and timing of orders increases at each stage up the supply chain, from customer to supplier.
  121. CHAPTER 7/CE 11-12-13
    How do IS affect Supply Chain Performance?
    • 1-reduced costs of buying and selling
    • 2-supply chain speed-$ value of goods exchanged in given period of time
    • 3-reduce size of inventories
    • 4-improve delivery scheduling-JIT
  122. CHAPTER 1
    4 Key skills needed in 21st century
    • Abstract Reasoning
    • Systems Thinking
    • Collaboration
    • Ability to Experiment
  123. CE-1
    Occurs when two or more people work together to achieve a common goal, result, or work product.
  124. CE2
    Synchronous communication
    occurs when all tem members meet at he same time.

    • shared calendars, invitation, and attendence
    • can be conference calls, webinars, multi party chat, etc.
  125. CE 2
    Asynchronous communication
    When team members do not meet at the same time.

    ex, email, discussion forums, team surveys, google docs, sharepoint, etc.
  126. CE 2
    Version Control
    limit actions that can be taken by any particular user, and give control over the changes to particular users
Card Set
CIS 235
Spring 2012-Balkan Arizona State University