Term
|
Definition
Enables the user to control numbers, manipulating them in various ways |
|
|
Term
|
Definition
| The intersection of a row and a column on the grid of a spreadsheet. |
|
|
Term
|
Definition
| A function of spreadsheet software that enables users to change the appearance of the contents of a cell. |
|
|
Term
|
Definition
| Along with columns, compromise the grid of the spreadsheet. (horizontal with numbers) |
|
|
Term
|
Definition
| Along with rows, compromise the grid of the spreadsheet (vertical, represent letters) |
|
|
Term
|
Definition
| In a spreadsheet, the location of a cell, determined by row number and column number. |
|
|
Term
|
Definition
| A rectangular block of cells. |
|
|
Term
|
Definition
| In a spreadsheet, a text entry that provides information on what a column or row represents. |
|
|
Term
|
Definition
| The numbers that are the raw material used by spreadsheet software to perform calculations |
|
|
Term
|
Definition
| A predefined set of calculations, such as SUM and AVERAGE, in spreadsheet software |
|
|
Term
|
Definition
| Step-by-step procedure for calculating a number on a spreadsheet. |
|
|
Term
|
Definition
| Custom-designed embedded procedure program that automates tasks in application programs |
|
|
Term
|
Definition
| Automatic replication of values, labels, and formulas, a feature of spreadsheet software. |
|
|
Term
|
Definition
| A spreadsheet capability that allows for easy correction of errors and makes easy to try out different values while searching for solutions |
|
|
Term
|
Definition
A spreadsheet document that appears on the screen as a grid of numbered rows and columns. |
|
|
Term
|
Definition
| The equivalent of spelling and grammar checkers for calculations that helps users check complex worksheets for consistency of entries and formula logic |
|
|
Term
|
Definition
| A feature of spreadsheet software that allows speculation by providing instant answers to hypothetical questions |
|
|
Term
|
Definition
| A link between worksheets in a spreadsheet that ensures that a change in one worksheet is reflected in the other. |
|
|
Term
|
Definition
| A reference in a spreadsheet to a specific cell address. (the value does not change when copied) |
|
|
Term
|
Definition
| A reference to a spreadsheet cell in relation to the current cell |
|
|
Term
|
Definition
| A round pie-shaped chart with slices that show the relative proportions of the parts of a whole. |
|
|
Term
|
Definition
| A chart that shows trends or relationships over time, or a relative distribution of one variable through another. |
|
|
Term
|
Definition
| A chart that shows relative values with bars, appropriate when data falls into a few categories. |
|
|
Term
|
Definition
| Stacked bars to show how proportions of a whole change over time. |
|
|
Term
|
Definition
| Discovers a relationship between two variables. (used often in science data) |
|
|
Term
|
Definition
| The use of computers to create abstract models of objects, organisms, organizations, and processes. |
|
|
Term
|
Definition
| A computer model of a real life situation used to see how a model responds under certain conditions. |
|
|
Term
| Feedback loop (and an example) |
|
Definition
In a copmuter simulation, the user and the computer responding to data from each other
Ex: flight simulators: humans making a decision and the computer model responding to the variables. |
|
|
Term
|
Definition
-Safety: easier to see the effect of a nuclear meltdown
-Economy: cheaper to fly simulation than to make the plane.
-Projection: The environment and applying variables to see the effect
-Visualization: Speeding or slowing of time
-Replication: multiple science experiments |
|
|
Term
| Examples of Spreadsheet Software (uses) |
|
Definition
| Can manage budgeting, investment management, business projections, grade books, scientific simulations, check books, financial planning and speculation, and other tasks involving numbers. |
|
|
Term
| Disadvantages of Simulation |
|
Definition
Reliability: Faulty Software
Infalibility: People assuming computers are always correct
Computer Power: Might have to cut down program size to fit computer |
|
|
