OIM2000 DTE - Data Storage: Spreadsheets

These flashcards cover key vocabulary and concepts related to data storage and spreadsheet usage from the OIM2000 DTE lecture.

User Testing

A method of evaluating a wireframe or prototype through observation of users as they navigate the app.

Usability Testing

Conducted throughout the design process to assess and improve the app's functionality based on user feedback.

Entity

Something about which information is captured, such as a person, place, event, or object.

Attribute

A detail or characteristic about an entity, such as first name or last name for a student.

Spreadsheet

A digital document organized in rows and columns for data management and analysis.

VLOOKUP Function

A function that searches for a value in the first column of a range and returns a value in the same row from a specified column.

HLOOKUP Function

A function that searches for a value in the first row of a range and returns a value in the same column from a specified row.

XLOOKUP Function

An advanced lookup function that combines VLOOKUP and HLOOKUP features and allows lookups in any direction.

Data Management

The practice of collecting and managing data from various sources to provide meaningful information.

Data Culture

An organizational environment where data is viewed as an essential part of everyone's role.