Exam Revision Flashcards
Data
Facts and figures without any real context or meaning
Information
Data that has been made meaningful and helps someone understand something.
Knowledge
Information that has been incorporated into someone’s view of the world. typically defined with reference to information. information having been processed, organised or structured in some way, or else as being applied or put into action.
Rich Picture
- Technique used in Soft Systems Methodology (SSM) (but can be used elsewhere for dealing with messy problems)
- A pictorial caricature of what the organisation (or group of people) is ‘about’
- Should be self-explanatory and easy to understand
- Should identify the elements of structure, process, climate, and issues/symptoms in the situation
System
A system is a collection of interrelated components that function together to achieve
some predefined purposes or objectives.
Component
a part, or aggregation of parts, of a system, commonly referred to as a subsystem;
Interrelated components
the dependency of one subsystem on one or more
other subsystems. Subsystems are related and usually interact with each other in order to achieve their pre-declared objectives, within their environment;
Boundary
the line that distinguishes the inside from the outside of a system and so distinguishes the system from its environment;
Environment
everything external to a system that interacts with the system;
Interfaces
points of contact where a system meets its environment or where subsystems meet each other;
Inputs
whatever a system takes from its environment in order to fulfil its purpose
Outputs
whatever a system returns to its environment in order to fulfil its
purpose
Constraints
limits or conditions within which a system can accomplish its objectives;
Open and closed systems
Systems can be classified on a continuum between the extremes of open systems
and closed systems. Open systems interact freely with their environments, taking in
inputs and returning outputs. Closed systems don’t interact with their environments,
so changes in the environment do not affect the system.
Systems thinking
Business problem solvers, sometimes referred to as “systems analysts”, use the nine
systems characteristics to understand, in a holistic way, business situations. They
consider businesses as if they were open systems. This is termed applying “systems
thinking” to a business situation.
Stakeholder
A person, group or organization that has interest or concern in an organization.
Stakeholders can affect or be affected by the organisation’s actions, objectives and policies.
VLOOKUP FUNCTION
VLOOKUP( lookup_value, table_array, col_index_num, range_lookup)
VLOOKUP EXPLANATION
Searches for a value (lookup_value) in the leftmost column of a table (table_array),
and then returns a value in the same row from a column you specify in the table
(col_index_num). If range_lookup is FALSE, VLOOKUP will only find an exact
match. If TRUE, then it will find an exact match or a “best” approximate match.
IF FUNCTION
IF( logical_test, value_if_true, value_if_false )
IF EXPLANATION
Returns one value (i.e. value_if_true), if a condition you specify (i.e. logical_test)
evaluates to TRUE and another value (i.e. value_if_false) if the condition evaluates to
FALSE.
SUMIF FUNCTION
SUMIF(Range, Criteria, Sum_range)
SUMIF EXPLANATION
Sums the values in a range (Sum_range) where the values in an associated range
(Range) meet a criteria (Criteria) that has been specified.
Describe 2 Excel spreadsheet features that will help City Used Cars to improve the way they
manage and use their car sales profit data.
. The calculations are automatically carried out – eliminating human error
. Calculations and outcomes are saved/recorded
. Calculation template can be reused for future calculations
. Updates to the vehicle costs table are automatically reflected in the calculations
. Information generated is organised, easy to understand, and well presented
. Data Visualisation - Pivot tables and graphs providing display of relative car category
sales
Business intelligence
Information that results from the processing of operational data to create information. It exposes patterns, relationships, and trends of importance to an organisation