Review

Quiz yourself on the concepts covered in this module. There may be multiple correct answers for some questions.

You can read more about the answers in the Solutions Appendix.

  1. Match the statement, "structured and organized collection of data and/or information held on a computer" to the correct term.

    • database language

    • database program

    • database

    • database language

    • database program

    • database

  2. Match the statement, "the way by which a human communicates with a computer" to the correct term.

    • database language

    • database program

    • database

    • database language

    • database program

    • database

  3. Match the statement, "combines and presents functions and features for manipulating data, together in a unified interface" to the correct term.

    • database language

    • database program

    • database

    • database language

    • database program

    • database

  4. If you open a data file and see the following, what would you suspect is the issue?

    �tre, ou ne pas �tre, c�est l� la question.

    • Nothing

    • It is corrupt

    • The wrong encoding was used to open the file

    • The sender used a weird font

    • Nothing

    • It is corrupt

    • The wrong encoding was used to open the file

    • The sender used a weird font

  5. What type of software is the Integrated Publishing Toolkit (IPT)?

    • data capture

    • data cleaning

    • data management

    • data publishing

    • data capture

    • data cleaning

    • data management

    • data publishing

  6. What type of software is Specify?

    • data capture

    • data cleaning

    • data management

    • data publishing

    • data capture

    • data cleaning

    • data management

    • data publishing

  7. What type of software is iNaturalist?

    • data capture

    • data cleaning

    • data management

    • data publishing

    • data capture

    • data cleaning

    • data management

    • data publishing

  8. What type of software is OpenRefine?

    • data capture

    • data cleaning

    • data management

    • data publishing

    • data capture

    • data cleaning

    • data management

    • data publishing

  9. What data type is "1236975"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  10. What data type is "01101111"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  11. What data type is "We walked 5 miles down the road west from the post office in the center of town. We then went 2 miles north on a dirt path to the river. Then we continued west along the river for another 5 miles."?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  12. What data type is "1024"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  13. What data type is "29.0"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  14. What data type is "Yes/No"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  15. What data type is "6 rabbits were observed"?

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

    • binary

    • boolean

    • float

    • integer

    • long integer

    • text

    • unstructured text

  16. Which of these terms describes a "field/column name"?

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

  17. Which of these terms describes a "field label"?

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

  18. What is the correct structure for this statement, "All data refers to a SINGLE concept"?

    • column

    • row

    • table

    • column

    • row

    • table

  19. What is the correct structure for this statement, "An attribute has the SAME field/data type for every record"?

    • column

    • row

    • table

    • column

    • row

    • table

  20. What is the correct structure for this statement, "Attributes of a record ALWAYS stay together"?

    • column

    • row

    • table

    • column

    • row

    • table

  21. Who determines the fitness for use of your data?

    • The museum or department director

    • The users of the data for research or education

    • The collector of the data in the field

    • The person entering the data into the database

    • The museum or department director

    • The users of the data for research or education

    • The collector of the data in the field

    • The person entering the data into the database

  22. For the given statement, "High accuracy, low precision", input the matching image. image::foundations::accuracyandprecision.png[align=center,width=640,height=360]

  • A

  • B

  • C

  • D

  • A

  • B

  • C

  • D

  1. For the given statement, "Low accuracy, high precision", input the matching image. image::foundations::accuracyandprecision.png[align=center,width=640,height=360]

  • A

  • B

  • C

  • D

  • A

  • B

  • C

  • D

  1. For the given statement, "High accuracy, high precision", input the matching image. image::foundations::accuracyandprecision.png[align=center,width=640,height=360]

  • A

  • B

  • C

  • D

  • A

  • B

  • C

  • D

  1. For the given statement, "Low accuracy, low precision", input the matching image. image::foundations::accuracyandprecision.png[align=center,width=640,height=360]

  • A

  • B

  • C

  • D

  • A

  • B

  • C

  • D

  1. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "Collector field exists in both dataset A and B".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  2. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "Country field only exists in dataset B".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  3. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "Name field exists in dataset A, but dataset B contains First Name and Last Name fields".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  4. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "ID field exists in both dataset A and B".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  5. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "Elevation exists in dataset A, but not in dataset B".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  6. Identify the data relationships where Dataset B needs to be merged into Dataset A for the statement, "Date exists in dataset A, but Day, Month, and Year are separate fields in dataset B".

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

    • 0:1

    • 1:0

    • 1:1

    • 1:∞

    • ∞:1

    • ∞:∞

  7. Metadata is important because (select the TRUE statements):

    • it allows users to determine if a dataset is fit for their use.

    • it allows you to share exact coordinates for each occurrence.

    • it allows you to know under which legal terms the reuse of data is permitted.

    • it also applies to all supplemental and associated materials, including images, video, and other media.

    • it allows you know about the institution’s next exhibition/opening hours.

    • it allows users to determine if a dataset is fit for their use.

    • it allows you to share exact coordinates for each occurrence.

    • it allows you to know under which legal terms the reuse of data is permitted.

    • it also applies to all supplemental and associated materials, including images, video, and other media.

    • it allows you know about the institution’s next exhibition/opening hours.