MIS 200 FINAL EXAM|125 QUESTIONS
AND ANSWERS
Organizational Information pyramid - -Bottom: *Information LEVELS*:
individual, department, enterprise
Middle: *Information FORMATS*: document, presentation, spreadsheet,
database
Top: *Information GRANULARITIES*: Fine detail, Summary (reports),
aggregate (coarse) (??)
- 4 Primary Traits of the Value of Information - -Information Type
Information Timeliness
Information Quality
Information Governance
- Information Type - -Transaction and Analytical
- Transactional Information - -Encompasses all info contained in a single
business process/unit of work.
Purpose is to support daily *operational* tasks
Ex: Packing slips, receipts, tickets
- Analytical Information - -Encompasses all organizational info.
Primary purpose is to support the performing of *managerial* analysis tasks
Ex: stats, projections, trends
- Information Timeliness - -Real-time info: immediate, up to date info
Real-time system: real-time info in response to requests
- Information Quality - -Decisions are only as good as the quality of the info
used to make decisions
Info inconsistency: same data element has different values
info integrity issues: system produces incorrect, inconsistent, or duplicate
data
- High Quality info characteristics - -Accuracy
Completeness
Consistency
Uniqueness
Timeliness
, - 4 primary sources of low quality info - -- Customer intentionally enters
inaccurate info
- Different entry standards and formats
- Operators enter abbreviated or erroneous info by accident or to save time
- 3rd party/external info contains inconsistencies, inaccuracies, and errors
- Effects of low qual info - -- inability to accurately track customers
- can't identify valuable customers
- can't identify selling opportunities
- marketing to nonexistent customer
- can't track revenue
- Can't build strong customer relationships
- Benefits of high qual info - -Improve chances of good decision
that can directly impact bottom line
- Information Governance - -Data governance: overall management of the
availability, usability, integrity, and security of company data. Policies and
procedures on how the info is organized/updated/maintained/accessed
- Master Data Management (MDM) - -Practice of gathering data and
ensuring that it is uniform, accurate, consistent, and complete from critical
entities that are commonly integrated across organizational systems
(customers, suppliers, etc)
- Data Validation - -tests and evals used to determine compliance w data
governance policies to ensure correctness of data
- Database - -Maintains info about various types of objects (inventory),
events (transactions), people (employees), and places (warehouses)
- Database Management Systems (DBMS) - -Allows users to create, read,
update, and delete data in a relational db (CRUD)
- Data model - -Logical data structures that detail the relationship between
data elements using pics
- Data-driven websites - -Interactive website kept constantly updated and
relevant to the needs of its customers using a db
Roles:
- Content creator
- Content editor
- Static info
- Dynamic info
- Dynamic catalog
AND ANSWERS
Organizational Information pyramid - -Bottom: *Information LEVELS*:
individual, department, enterprise
Middle: *Information FORMATS*: document, presentation, spreadsheet,
database
Top: *Information GRANULARITIES*: Fine detail, Summary (reports),
aggregate (coarse) (??)
- 4 Primary Traits of the Value of Information - -Information Type
Information Timeliness
Information Quality
Information Governance
- Information Type - -Transaction and Analytical
- Transactional Information - -Encompasses all info contained in a single
business process/unit of work.
Purpose is to support daily *operational* tasks
Ex: Packing slips, receipts, tickets
- Analytical Information - -Encompasses all organizational info.
Primary purpose is to support the performing of *managerial* analysis tasks
Ex: stats, projections, trends
- Information Timeliness - -Real-time info: immediate, up to date info
Real-time system: real-time info in response to requests
- Information Quality - -Decisions are only as good as the quality of the info
used to make decisions
Info inconsistency: same data element has different values
info integrity issues: system produces incorrect, inconsistent, or duplicate
data
- High Quality info characteristics - -Accuracy
Completeness
Consistency
Uniqueness
Timeliness
, - 4 primary sources of low quality info - -- Customer intentionally enters
inaccurate info
- Different entry standards and formats
- Operators enter abbreviated or erroneous info by accident or to save time
- 3rd party/external info contains inconsistencies, inaccuracies, and errors
- Effects of low qual info - -- inability to accurately track customers
- can't identify valuable customers
- can't identify selling opportunities
- marketing to nonexistent customer
- can't track revenue
- Can't build strong customer relationships
- Benefits of high qual info - -Improve chances of good decision
that can directly impact bottom line
- Information Governance - -Data governance: overall management of the
availability, usability, integrity, and security of company data. Policies and
procedures on how the info is organized/updated/maintained/accessed
- Master Data Management (MDM) - -Practice of gathering data and
ensuring that it is uniform, accurate, consistent, and complete from critical
entities that are commonly integrated across organizational systems
(customers, suppliers, etc)
- Data Validation - -tests and evals used to determine compliance w data
governance policies to ensure correctness of data
- Database - -Maintains info about various types of objects (inventory),
events (transactions), people (employees), and places (warehouses)
- Database Management Systems (DBMS) - -Allows users to create, read,
update, and delete data in a relational db (CRUD)
- Data model - -Logical data structures that detail the relationship between
data elements using pics
- Data-driven websites - -Interactive website kept constantly updated and
relevant to the needs of its customers using a db
Roles:
- Content creator
- Content editor
- Static info
- Dynamic info
- Dynamic catalog
