Brainscape's Knowledge GenomeTM

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


See full index

GIS 1479 > Test1 > Flashcards

Test1 Flashcards

1
Q

The 3 concepts that will be a lecture topic

A
  1. Transforming data
  2. Topology
  3. Data automation
    Not coordinate systems
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the geospatial technology competency model student learning outcome for this course?

A

Develop conceptual, logical, and physical geospatial data models in response to user requirements within the life cycle of a GIS project or work-flow of a GIS program

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

Quizzes are worth what percent of your grade?

A

10%

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

The fourth test is?

A

cumulative

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

What is considered a primary data source?

A

You backyard rain gauge

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

Place data storage units in order from smallest to largest

A 
Bit
Byte
Kilobyte
Megabyte
Gigabyte
Terabyte
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Weight is a type of data best described as nominal, ordered, interval or ratio?

A

ratio

quantitative, names, ordered, measured with an absolute zero

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

Row =
column =
cell =
table =

A 
Row = record 
Column = field 
Cell = value
Table = table
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Standardizing the date format in a table of values is best categorized as which type of basic data transformation include:

A

Cleaning

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

advanced data transformation types

Derivation

A

Calculate new values

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

advanced data transformation types

Joining

A

Concatenate values

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

advanced data transformation types

Splitting

A

Parse Values

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

advanced data transformation types

Integrating

A

Reconcile values

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

advanced data transformation types

Filtering

A

selecting only certain rows or columns

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

advanced data transformation types

validating

A

check quality of data

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

advanced data transformation types

enriching

A

enhance and/or refine data

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

advanced data transformation types

Aggregating

A

Combine multiple data sources into a target dataset

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

A1

A

Relative reference

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

$A$!

A

Absolute reference

20
Q

!Cell Reference

A

Transactions!A1

21
Q

Foobar

A

Named Reference

22
Q

Convert 97°44’25.0”W longitude from degrees, minutes, seconds to decimal degrees.

A

-97.74028

The answer is -97.74028. The formula for converting 97°44’25.0”W longitude from degrees, minutes, seconds to decimal degrees is DEG + MIN/60 + SEC/3600. So 97 + 44/60 + 25/3600 = 97 + 0.73333333 + 0.00694444 = - 97.74028. Don’t forget to add the negative because 97° W is west of the Prime Meridian.

23
Q

Convert 30.274691 latitude from decimal degrees to degrees, minutes, seconds.

A

30°16’28.9”N

  1. 274691 = 30°
  2. 274691*60 = 16.48146 = 16’
  3. 48146*60 = 28.9”
24
Q

What formula would allow you to parse data from a field

A

SPLIT(B2,” “)

25
Q

How to make a pivot table

A

select any cell in the source table and select Data>Pivot. In the Pivot Table Editor pane; add ZIP_CODE as rows, ID as values, and set the ID field to Summarize by Count to see the number of records for each ZIP_CODE.

26
Q

How to determine how many unique zip codes are there

A

Enter the formula =UNIQUE((I2:I1001)) into cell J2…then select all of the resulting records and view the statistics to see the count. Alternatively, you can create a pivot table and set the ZIP_Code column to Rows to see a unique list of values.

27
Q

Which of the following formulas would be best for concatenating values in columns STREET_NUMBER, STREET_NAME, STREET_SUFFIX, and ZIP_CODE into a new column named ADDRESS?

A

The answer is =F2&” “&G2&” “&H2&” “&TEXT(I2,”00000”) which would combine the text fields STREET_NUMBER, STREET_NAME, STREET_SUFFIX separated by spaces with the numeric field ZIP_CODE (which is converted to a text value with 5 characters).

28
Q

Which of the following statements best reflects Ed Tufte’s guidelines for visualizing data?

A

“Good design is invisible” best reflects Ed Tufte’s guidelines for visualizing data. Good design cannot make good data…you must start with good data. You should show data variation, not design variation. Last, good design maximizes data-ink.

29
Q

What is the name for a very small line chart devleloped by Ed Tufte?

A

A sparkline is a very small line chart, typically drawn without axes or coordinates. Ed Tufte introduced the term sparkline in 2006 for “small, high resolution graphics embedded in a context of words, numbers, images.”

30
Q

Which of the following is NOT a best practice for visualizing tables?

A

Repeat data for emphasis

31
Q

You should always remove data repetition when possible. Best practices for data visualization include:

A 
Don’t Stretch Tables
Keep it Simple
Left Align Text
Right Align Numbers
Align Headings with Data
Resize columns to Data
Put whitespace to Work
Use Consistent Precision
Round Numbers
Remove Repetition
Request Peer Review
32
Q

In spreadsheets, you can highlight cells that meet a specified criteria using what type of formatting?

A

Conditional

33
Q

Match the letters in the image below with the corresponding chart element. y-axis

A

Series

34
Q

the graph

A

Plot

35
Q

X-axis

A

Axis

36
Q

x axis title

A

categories

37
Q

Which of the following chart types would best show the relationship between two variables?

A

Scatter Plot

38
Q

a historgram show

A

the distribution of data

39
Q

A bar chart

A

charts shows comparison of categorical data;

40
Q

a pie chart shows

A

data composition.

41
Q

When creating a Geo Chart in Google Sheets, you must map the geography column (e.g. Country, State, City, etc.) to which setting type?

A

Region

42
Q

Which of the lettered charts pictured below is visualizing the least amount of data?

A

The pie chart

43
Q

Strategic dashboard

A

High level measures and forecast

44
Q

Analytical dashboard

A

Data interaction and drill down

45
Q

Operational dashboard

A

System and event monitoring

46
Q

Informational dashboard

A

General information

GIS 1479 (4 decks)

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