MIS 180 Barra In Person Exam Study
Guide 2025
What is data? Provide and example Correct answer-Data: Points of information
Ex: text, numbers, photos
What is information? Provide an example Correct answer-Information: Data converted into
meaningful and useful context
What is business intelligence? Provide an example Correct answer-Business Intelligence:
information collected from multiple sources such as suppliers, customers, and competitors that
analyzes patters, trends and relationships for strategic decision making
What is a fact? What qualities does it have? Correct answer-a statement that can be proven
What is the difference between a useful fact and misleading fact? Correct answer-Useful:
Verifiable, relevant, credible
Misleading: Partial, redundant, requires extensive verifying
What is triangulation? Correct answer-Gathering information
What is corroboration? Correct answer-evidence that confirms or supports a statement
What does "information literacy" mean? Correct answer-The ability to find, evaluate, and use
information effectively to achieve goals
What is a relative address/reference in excel? Correct answer-A cell reference that adjusts when
copied or used with AutoFill
- "Drag down"
What is an absolute address/reference in excel? Correct answer-A cell reference that DOES NOT
adjust when used with autofill
- "$"
What is the proper format for a calculation if you want to add, subtract, divide, or multiply 2
numbers by referencing their cell reference? Correct answer-= Cell A +,-,/,* Cell B
What is the proper format/syntax for the IF function? Correct answer-=IF(logical test, value if true,
value if false)
Which function would you use to sum a columns or row of 50 numbers? Given a range, what is the
proper format? Be able to apply this to avg, max, and min Correct answer-=SUM(G1:G50)
What is the difference between a system and a process? Correct answer-They effectively mean the
same thing.
A structured collection of processes that work together to produce an outcome
What are the 6 parts of any system? Correct answer-1. Inputs
2. processes (that transform inputs)
, 3. Outputs
4. Controls
5. Feedback
6. Adjustment
How do supersystems, systems, subsystems, and processes relate to each other? Correct answer-
Supersystem --> The greater system
System --> the general system
Subsystem --> systems within the system
What is interdependence? Provide an example Correct answer-Parts that depend on each other
Ex: The food web
What is synergy? Provide an example Correct answer-Cooperative effort of complementary parts is
greater than the sum of the individual parts
Ex: Automated packaging systems
What is entropy/obsolesce? Provide an example Correct answer-All systems fall apart over time if
they don't adapt
Ex: Campfire, solid wood turns into ash, smoke, gasses
What is optimization/sup-optimization? Provide an example Correct answer-Subsystems often
must optimize to enable the system to operate at maximum efficentcy
What is an open system? Correct answer-The transformation process set but inputs and outputs
can vary
- designed to adapt and evolve
Ex: Algorithms
What is a closed system? Correct answer-A system where neither matter nor energy can enter or
leave
Ex: TV Remote
What are the functional parts of an enterprise and what do they do?
Hint: know "Internal View of an Enterprise" Slide Correct answer-Sales - selling goods or services
Accounting - Records monetary transactions
Finance - tracks strategic financial issues
HR - Maintains policies for effective management
Marketing - supports sales by planning, pricing, and promoting goods and services
Operations Mgmt. - Manage the process of converting resources into goods and services
What are stakeholders? Who are they for most enterprises?
Hint: Know "External View of Enterprises" Correct answer-Those who benefit in someway from the
operation of the company, which may not include owning stock
Ex: customers and suppliers
Stakeholder vs shareholder Correct answer-- a stakeholder is customer of a business
- a shareholder owns part of a company through stock ownership
What are parts of a business information system and how do they work together? Provide examples
Correct answer-Data - audio, video, text, numbers
Guide 2025
What is data? Provide and example Correct answer-Data: Points of information
Ex: text, numbers, photos
What is information? Provide an example Correct answer-Information: Data converted into
meaningful and useful context
What is business intelligence? Provide an example Correct answer-Business Intelligence:
information collected from multiple sources such as suppliers, customers, and competitors that
analyzes patters, trends and relationships for strategic decision making
What is a fact? What qualities does it have? Correct answer-a statement that can be proven
What is the difference between a useful fact and misleading fact? Correct answer-Useful:
Verifiable, relevant, credible
Misleading: Partial, redundant, requires extensive verifying
What is triangulation? Correct answer-Gathering information
What is corroboration? Correct answer-evidence that confirms or supports a statement
What does "information literacy" mean? Correct answer-The ability to find, evaluate, and use
information effectively to achieve goals
What is a relative address/reference in excel? Correct answer-A cell reference that adjusts when
copied or used with AutoFill
- "Drag down"
What is an absolute address/reference in excel? Correct answer-A cell reference that DOES NOT
adjust when used with autofill
- "$"
What is the proper format for a calculation if you want to add, subtract, divide, or multiply 2
numbers by referencing their cell reference? Correct answer-= Cell A +,-,/,* Cell B
What is the proper format/syntax for the IF function? Correct answer-=IF(logical test, value if true,
value if false)
Which function would you use to sum a columns or row of 50 numbers? Given a range, what is the
proper format? Be able to apply this to avg, max, and min Correct answer-=SUM(G1:G50)
What is the difference between a system and a process? Correct answer-They effectively mean the
same thing.
A structured collection of processes that work together to produce an outcome
What are the 6 parts of any system? Correct answer-1. Inputs
2. processes (that transform inputs)
, 3. Outputs
4. Controls
5. Feedback
6. Adjustment
How do supersystems, systems, subsystems, and processes relate to each other? Correct answer-
Supersystem --> The greater system
System --> the general system
Subsystem --> systems within the system
What is interdependence? Provide an example Correct answer-Parts that depend on each other
Ex: The food web
What is synergy? Provide an example Correct answer-Cooperative effort of complementary parts is
greater than the sum of the individual parts
Ex: Automated packaging systems
What is entropy/obsolesce? Provide an example Correct answer-All systems fall apart over time if
they don't adapt
Ex: Campfire, solid wood turns into ash, smoke, gasses
What is optimization/sup-optimization? Provide an example Correct answer-Subsystems often
must optimize to enable the system to operate at maximum efficentcy
What is an open system? Correct answer-The transformation process set but inputs and outputs
can vary
- designed to adapt and evolve
Ex: Algorithms
What is a closed system? Correct answer-A system where neither matter nor energy can enter or
leave
Ex: TV Remote
What are the functional parts of an enterprise and what do they do?
Hint: know "Internal View of an Enterprise" Slide Correct answer-Sales - selling goods or services
Accounting - Records monetary transactions
Finance - tracks strategic financial issues
HR - Maintains policies for effective management
Marketing - supports sales by planning, pricing, and promoting goods and services
Operations Mgmt. - Manage the process of converting resources into goods and services
What are stakeholders? Who are they for most enterprises?
Hint: Know "External View of Enterprises" Correct answer-Those who benefit in someway from the
operation of the company, which may not include owning stock
Ex: customers and suppliers
Stakeholder vs shareholder Correct answer-- a stakeholder is customer of a business
- a shareholder owns part of a company through stock ownership
What are parts of a business information system and how do they work together? Provide examples
Correct answer-Data - audio, video, text, numbers
