MIS 180 Barra Final Exam Study
Guide 2024 – Complete, Verified &
Easy to Learn (Includes Diagrams
& Key Terms)
What is data? Provide and example
Data: Points of information
Ex: text, numbers, photos
What is information? Provide an example
Information: Data converted into meaningful and useful context
What is business intelligence? Provide an example
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?
a statement that can be proven
What is the difference between a useful fact and misleading fact?
Useful: Verifiable, relevant, credible
Misleading: Partial, redundant, requires extensive verifying
What is triangulation?
Gathering information
What is corroboration?
evidence that confirms or supports a statement
What does "information literacy" mean?
The ability to find, evaluate, and use information effectively to achieve goals
What is a relative address/reference in excel?
A cell reference that adjusts when copied or used with AutoFill
- "Drag down"
What is an absolute address/reference in excel?
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?
= Cell A +,-,/,* Cell B
What is the proper format/syntax for the IF function?
=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
=SUM(G1:G50)
What is the difference between a system and a process?
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?
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?
Supersystem --> The greater system
System --> the general system
Subsystem --> systems within the system
What is interdependence? Provide an example
Parts that depend on each other
Ex: The food web
What is synergy? Provide an example
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
Guide 2024 – Complete, Verified &
Easy to Learn (Includes Diagrams
& Key Terms)
What is data? Provide and example
Data: Points of information
Ex: text, numbers, photos
What is information? Provide an example
Information: Data converted into meaningful and useful context
What is business intelligence? Provide an example
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?
a statement that can be proven
What is the difference between a useful fact and misleading fact?
Useful: Verifiable, relevant, credible
Misleading: Partial, redundant, requires extensive verifying
What is triangulation?
Gathering information
What is corroboration?
evidence that confirms or supports a statement
What does "information literacy" mean?
The ability to find, evaluate, and use information effectively to achieve goals
What is a relative address/reference in excel?
A cell reference that adjusts when copied or used with AutoFill
- "Drag down"
What is an absolute address/reference in excel?
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?
= Cell A +,-,/,* Cell B
What is the proper format/syntax for the IF function?
=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
=SUM(G1:G50)
What is the difference between a system and a process?
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?
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?
Supersystem --> The greater system
System --> the general system
Subsystem --> systems within the system
What is interdependence? Provide an example
Parts that depend on each other
Ex: The food web
What is synergy? Provide an example
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
