Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

IS 201 > Exam 2- Final > Flashcards

Exam 2- Final Flashcards

1
Q

The VBA Environment

A

P. 141

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

What does VBA stand for?

A

Visual basics for applications p. 141

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

What are the 2 types of coding mistakes?

A

Syntax errors and logic errors. p. 143

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

Which kind of coding mistake is less often caught by the syntax checker?

A

logical mistakes p. 144

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

Dim is short for

A

dimension

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

Why should you avoid the variant data type?

A

It increases processing time because the interpreter must take extra steps to figure out what type of data is stored in the variable. p. 147

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

T/F You must use Dim as for each variable you declare

A 
True
You can do 
Dim J,K,L as long
It has to be
Dim J as long, K as long, L as long
p. 148
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does typing option explicit at the top of your module do?

A

Forces you to declare variables. (Helps you avoid errors)

p. 148

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

Workbook Navigation

A

p. 162

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

What are the 2 types of objects?

A

Data-centric objects
Tool-centric objects
p. 162

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

What is the difference between data-centric objects and tool-centric objects?

A

Data-centric objects contain data and a set of predefined methods that manipulate the data. (Range of cells, worksheet, a cell)
Tool-centric objects are tools with specific functionality that can be added to a workbook (button, text box)
p.162

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

In workbook navigation, what are methods?

A

A set of predefined actions that can be performed on the data contained in the object. p. 162

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

In workbook navigation, what are properties?

A

Characteristics of an object. p.162

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

What 2 kinds of databases are there?

A

operational and analytical

BI slides

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

Which kind of database is used for daily business process, accounting, reports?

A

operational

BI slides

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

What is data mining?

A

Predicting the future

BI slides

17
Q

What is the difference between a data warehouse and a data mart?

A

A data warehouse has an enterprisewide organizational focus, while a data mart focuses on a subset of information for a given business unit such as finance
BI Slides

18
Q

What are the 2 primary tools to summarize data and characterize present status in BI?

A

Cubes
Dashboards
BI slides

19
Q

What is the common term for the representation of multidimensional information?

A

Cubes

BI slide 10

20
Q

What is a small scale, offline version of a data cube?

A

Excel pivot tables?

BI slide 11

21
Q

___ allow users (typically managers) to get a high level overview of the organization’s “health” or current status—as told by the data being gathered.

A

Dashboards

BI slide 12

22
Q

The data points included in the dashboard are referred to as

A

Key performance indicators

BI slide 12

23
Q

Common forms of data-mining analysis capabilities include (5)

A 
Cluster analysis
Association detection
Statistical analysis
Key influencers analysis
Time series forecasts

Bi Slide 13

24
Q

___ is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible

A

Cluster analysis

Bi slide 15

25
Q

___ reveals the degree to which variables are related and the nature and frequency of these relationships in the information

A

Association detection

BI slide 16

26
Q

___ analyzes such items as Web sites and checkout scanner information to detect customers’ buying behavior and predict future behavior by identifying affinities among customers’ choices of products and services

A

Market basket analysis

BI slide 16

27
Q

___ are the factors that can significantly predict (to some degree between 0-100%) or explain the variance in another factor.

A

key influencers

Bi slide 17

28
Q

___ is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete info

A

Data cleaning

Bi slide 21

29
Q

A ___ process is program code that is executed at specified intervals (every minute, hour, day, week, month) to
Copy the data from operational DBs and external sources
Clean the data
Insert it into the data warehouse

A

ETL

BI slide 22

IS 201 (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions