Database Terms
Database: A software program used to store information. Very text-oriented.
Able to display information sorted by a range of categories.
Field: Each field in a database holds one piece of information,
which can be textual or numerical, e.g., name, phone number, date, address.
Record: A set of all the fields relating to one person, place,
or thing.
Report: A view that shows data from multiple records on a single
"page."
Query: A request to find a specific kind of information within
the database (for example, for an individual, or all the individuals from
a region, or all those who work on Tuesdays, etc.)
Sort: Once the database responds to a query, information can be
rearranged through a "sort." A sort can order information by
zip code, alphabetically, numerically, by date, etc.
Spreadsheet Terms
Spreadsheet: A software program that manages numbers and text in
a row/column format.
Cell: The building blocks of the spreadsheet, where a column and
a row intersect. Text or numbers can be entered into each cell. If numbers
are entered, they can be programmed to be included in part of a formula
with other cells. Cells are defined by the row and column they are in,
so a cell in Column C, Row 3 would be Cell C3.
Labels: Cells with textual information.
Values: Cells with numeric information.
Active Cell or Selected Cell: The cell you are working in. Usually
defined with a dark border.
Block: A group of adjacent cells in a rectangle is called a block.
A block is defined by the addresses of the two cells that are in the opposite
corners of the rectangle block area, from the top left cell in the block
to the bottom right cell in the block. Once a block is defined, you can
move it, copy it, delete it, or change the contents, format, or mathematical
functions.
Formulas: A sequence of values, cell references, names, functions,
or operators linking a sequences of cells together. The result of the
operation or formula will be displayed in a new cell (for example, you
want to add your total volunteer hours for May. Each cell where volunteer
hours are entered can be linked and made to total the hours, which will
appear in another cell). As numbers affecting the formula change, the
formula value will change. |
