DATA LITERACY BY DAVID HERZOG EXAM WITH
SOLUTIONS #10
Algorithm - correct answer A set of steps that computer uses to solve a problem
Alphanumeric - correct answer A method of computer encoding that uses a mixture of
text and numbers
Amount change - correct answer The raw change from one point in time to another.
Formula: new number - original
ASCII - correct answer The American Standard Code for Information Interchange, which
was developed in 1963 and is used to represent text on all computers in the US. ASCII
text is the most portable data format and comes in two main styles: delimited and fixed
width
.asp - correct answer Stands for Active Server pages, Microsoft's scripting language.
Web forms that have this extension use the script to pass data between the form and
databases
Audit reports - correct answer Official reports that investigate the operations of
government agencies. These reports can be used to uncover data held by these
agencies. The US Government Accountability Office examines federal agencies, while
state auditors examine state agencies
Bar chart - correct answer Charts that display data using horizontal bars. Good for
displaying data that fall into a few categories
Benchmarks - correct answer Points of comparison that help make data more
meaningful. These can be internal — or within a data set — or external
Bit - correct answer The smallest unit of computerized data, literally a binary digit. Eight
bits make up one byte
Cell reference - correct answer An address that refers to a cell's position in a
spreadsheet, using the intersection of the column letter and row number
Central tendency - correct answer The average or number that's used to best describe a
set of numbers. Averages include the mean, median and mode
.cfm - correct answer Stands for Cold Fusion, Adobe's scripting language. Web forms
that have his extension are using the script to pass data between the form and
databases
, CKAN - correct answer An open-source web portal that's used for government open-
data platforms. Users include the federal government's Data.gov
Clustering - correct answer A function of data-cleaning tool openrefine that uses
algorithms to identify text values
Column chart - correct answer Charts that display time-series data using vertical
columns. Good for displaying events that occur at well-defined, discrete points in time
Concatenation - correct answer Merge two or more text values using spreadsheets or
other programs. In Excel, the concatenation character is the ampersand(&)
CSV - correct answer Short for comma-separated-values, a type of delimited ASCII file.
Sometimes used as a file extension
Data - correct answer Any computerized file that uses columns and rows (a tabular
structure) to organize information that's represented as text, numbers and dates
Data documentation - correct answer Detailed data description that allows users to
more easily understand and work with data sets. Also referred to as data dictionary,
record layout, file layout or metadata
Data integrity check - correct answer A systematic examination of data that occurs
before the analysis; used to uncover shortcomings in the data
Data_notebook - correct answer A text or word processing file in which your record
information about your data sources, as well as any data cleaning or analysis performed
Data portal - correct answer A web platform used to distribute data; usually
administered by government agencies
Database managers - correct answer Computer software designed to work with large
data sets that are stored in multiple tables. Examples include Microsoft Access and the
open-source mysql
Dbase - correct answer A popular database file format used by a number of commercial
database manager programs
Decennial census - correct answer An attempt to count every person in the US that
takes place every 10 years, those years ending with a "0." The most recent decennial
census was in 2010
Delimited text - correct answer An ASCII text file that uses special characters to mark
the location of column breaks
SOLUTIONS #10
Algorithm - correct answer A set of steps that computer uses to solve a problem
Alphanumeric - correct answer A method of computer encoding that uses a mixture of
text and numbers
Amount change - correct answer The raw change from one point in time to another.
Formula: new number - original
ASCII - correct answer The American Standard Code for Information Interchange, which
was developed in 1963 and is used to represent text on all computers in the US. ASCII
text is the most portable data format and comes in two main styles: delimited and fixed
width
.asp - correct answer Stands for Active Server pages, Microsoft's scripting language.
Web forms that have this extension use the script to pass data between the form and
databases
Audit reports - correct answer Official reports that investigate the operations of
government agencies. These reports can be used to uncover data held by these
agencies. The US Government Accountability Office examines federal agencies, while
state auditors examine state agencies
Bar chart - correct answer Charts that display data using horizontal bars. Good for
displaying data that fall into a few categories
Benchmarks - correct answer Points of comparison that help make data more
meaningful. These can be internal — or within a data set — or external
Bit - correct answer The smallest unit of computerized data, literally a binary digit. Eight
bits make up one byte
Cell reference - correct answer An address that refers to a cell's position in a
spreadsheet, using the intersection of the column letter and row number
Central tendency - correct answer The average or number that's used to best describe a
set of numbers. Averages include the mean, median and mode
.cfm - correct answer Stands for Cold Fusion, Adobe's scripting language. Web forms
that have his extension are using the script to pass data between the form and
databases
, CKAN - correct answer An open-source web portal that's used for government open-
data platforms. Users include the federal government's Data.gov
Clustering - correct answer A function of data-cleaning tool openrefine that uses
algorithms to identify text values
Column chart - correct answer Charts that display time-series data using vertical
columns. Good for displaying events that occur at well-defined, discrete points in time
Concatenation - correct answer Merge two or more text values using spreadsheets or
other programs. In Excel, the concatenation character is the ampersand(&)
CSV - correct answer Short for comma-separated-values, a type of delimited ASCII file.
Sometimes used as a file extension
Data - correct answer Any computerized file that uses columns and rows (a tabular
structure) to organize information that's represented as text, numbers and dates
Data documentation - correct answer Detailed data description that allows users to
more easily understand and work with data sets. Also referred to as data dictionary,
record layout, file layout or metadata
Data integrity check - correct answer A systematic examination of data that occurs
before the analysis; used to uncover shortcomings in the data
Data_notebook - correct answer A text or word processing file in which your record
information about your data sources, as well as any data cleaning or analysis performed
Data portal - correct answer A web platform used to distribute data; usually
administered by government agencies
Database managers - correct answer Computer software designed to work with large
data sets that are stored in multiple tables. Examples include Microsoft Access and the
open-source mysql
Dbase - correct answer A popular database file format used by a number of commercial
database manager programs
Decennial census - correct answer An attempt to count every person in the US that
takes place every 10 years, those years ending with a "0." The most recent decennial
census was in 2010
Delimited text - correct answer An ASCII text file that uses special characters to mark
the location of column breaks
