Exam One Flashcards

1
Q

Information

A

data with some context that makes it useful (the stock price of apple on Aug 26th 2014 was $101)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

System

A

components that allow information to be captured, stored, processed, and communicated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Information System Example

A

I obtained the info using google finance website that aggregates financial and other information related to companies and makes it available on the web

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Information Technology (IT)

A

the hardware, software, and media used to store, organize, retrieve, and communicate information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Information System (IS)

A

an organized combination of hardware, software, infrastructure, data and people that is used to accomplish a specified organizational or personal objective

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Use of info in organization

A

communication
business processes
decision making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Business process

A

an ongoing collection of related activities that create a product or service or value to the organization, its business partners, and/or its customers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Business Process compromised of three elements

A

Inputs
Resources
Outputs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Flowchart

A

a diagram that provide a logical description of a process or an algorithm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Moore’s Law

A

observation that number of transitors in electronic chips double every couple of years

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Strategic information systems

A

information systems are considered strategic when they provide a competitive advantage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Information system’s vital role in three areas of business processes

A

Executing the process
Capturing and storing process data
Monitoring process performance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Business Process Reengineering (BPR)

A

a radical redesign of an organization’s business processes to increase productivity and profitability

  • Examines business processes with a “clean slate” approach
  • Example: the process of hailing a cab has changed completely through the use of mobile apps
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Business Process Improvement (BPI)

A

an incremental approach to move an organization toward business process centered operations, focuses on reducing variation in process outputs by identifying the underlying cause of variation
- Six sigma is a popular methodology for BPI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Globalization

A

the integration and interdependence of economic, social, cultural, and ecological facets of life, made possible, by rapid advances in IT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Three eras

A

Globalization 1.0 countries
Globalization 2.-0 companies
Globalization 3.0- individuals and groups

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Three pillars of information technology growth

A

exponential
digital
combinatorial

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Goal seek

A

excel provides a goal seek function where you can provide the desired ouput value for a cell and also the input cell that may be varied to get the desired value. The excel then searches for an input value that will provide the desired output value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Nesting functions

A

OUTPUT 2 = FUNCTION 2(INPUT B, FUNCTION 1(INPUTS A))

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Collaborative consumption and sharing economy

A

new marketplaces where excess capacity in goods and services can be shared efficiently using information technology

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Basic functions to combine logical conditions

22
Q

Function to provide the opposite of a condition

23
Q

Porter’s five competitive forces

A
  • Threats of new entrants
  • Supplier power (bargaining power of suppliers)
  • Buyer power (bargaining power of buyers)
  • Threats of substitute products or services
  • Rivalry (competing organizations)
24
Q

Big data

A

diverse, high-volume, high-velocity, information assets that require new forms of processing to enable enhanced decision making, insight discover, and process optimization

25
Database
an organized collection of data
26
Databases minimize three main problems
- Data redundancy - Data isolation - Data inconsistency
27
Databases maximize the following three
- Data security - Data integrity - Data independence
28
Entities
things we store information about
29
Field
individual characteristics about an entity, fields are also called attributes or columns
30
Record
a group of fields or attributes to describe a single instance of an entity, these are also called rows
31
Table
a collection of records or instances for a given entity
32
Database
a collection of tables containing information to support a given system or a particular topic area
33
Primary key
a unique attribute used to identify a single instance of an entity
34
Foreign key
a primary key of one entity that is duplicated in another entity to identify instances of a relationship
35
One of the main reasons global communication of data is fast and low cost is because of the availability of
submarine fiber optic cables
36
Value chain describes the XXXXX that transforms an organizations inputs into valuable outputs
primary and support activities
37
Routine Information System
Information system that provides a service that competitors also offer, giving no competitive advantage (website of a bank allowing account holders to view their balance)
38
Strategic Planning Process
- Strategic Business Planning (Know Who You Are) - Information Systems Assessment (Know What You Have (Resources))) - Information Systems Vision(Know Where You Want to Go) - Information Systems Architecture (Know How You Can Get There) - Strategic Initiatives Identification (Know What You Need To Do)
39
http
protocol
40
www.microsoft.com
domain or host name
41
/security
directory name
42
default.html
file name
43
Prameter
anything before the =
44
Value
anything after the =
45
Roles of information systems in organizational culture
process improvement automation process control information flow
46
An associative table must have
two foreign key columns
47
VLOOKUP
=VLOOKUP(cell, absolute reference table, column index number, true)*cell
48
True
approximate match
49
False
exact match
50
If function
=IF(a>b,i,d)
51
Goal seek
=GOALSEEK