Term
|
Definition
| are unprocessed, unorganised and distinct facts or ideas. |
|
|
Term
|
Definition
| is processed, organised and value-added data. It can be paper-based (hard copy) or digital (soft copy). |
|
|
Term
|
Definition
| is a method for solving a problem. In information technology, the problem-solving methodology is a way of developing solutions. |
|
|
Term
| Solutions need to serve a PURPOSE |
|
Definition
| in order to enhance decision-making and solve information problems. Solutions aim to inform, educate, persuade or entertain. |
|
|
Term
|
Definition
| meets the desired purpose. To identify relevant data, you need to be able to assess the usability of the data and determine the characteristics of the targeted audience. |
|
|
Term
|
Definition
| has the properties of suitability, reliability, accuracy, timelessness and freedom from bias. |
|
|
Term
| CHARACTERISTICS OF AUDIENCES |
|
Definition
| are gender, special needs, culture, age, education level, status and location. |
|
|
Term
|
Definition
| is a set of data with predefined characteristics. The most common data types are integer, floating point numbers, character and string. |
|
|
Term
|
Definition
| is a pictorial diagram that shows the interdependencies between variables. Common types derived from numerical data are column graphs, line charts, pie graphs, bar charts, area charts, scatter diagrams and bubble charts. |
|
|
Term
|
Definition
| detail the content of a solution. They are a visul sketch of a grpahic representation, and contain detailed descriptions of each element of the content. |
|
|
Term
|
Definition
| is made up of worksheets (rows and columns). |
|
|
Term
|
Definition
| include conditional, lookup, date and time,financial, statistical, math, counting, conversation and text. |
|
|
Term
|
Definition
| include the ability to format data, sort and filter data, and perform mathematical, logical, financial,statistical and scientific functions and create charts and graphs. |
|
|
Term
|
Definition
| are factors that influence the appearance and effectiveness of graphic representations. These elements include proportion, orientation, carity and consistency, colour and contrast, usability and accessability, appropriatness and relevance. |
|
|
Term
|
Definition
| is measured in terms of time, cost, and effort. Spreadsheets include functions that enable a user to work quicjly and with less effort in order to produce graphic representations, therefore minimising cost. |
|
|
Term
|
Definition
| relates to how well a solution meets the specified need and fulfils the specified purpose. It is measured in terms of completeness, readability, attractiveness, clarity, accuracy, accessibility, timelessness, communication of message, relevance and reliability. |
|
|
Term
|
Definition
| checks that data input to a computer system is appropriate and reasonable. |
|
|
Term
|
Definition
| is performed by a person, not a compputer, and includes proofreading and checkng for illegal data types, for reasonableness, for correct spelling to ensure that data falls within a correct 'range', or that any codes used are consistent and reasonable. |
|
|
Term
|
Definition
| is performed by a computer and includes range checking, existence checking, data-type checking,m and restricted data entry. |
|
|
Term
|
Definition
| communicate to the user that the data entered does not adhere to the validation rules set. |
|
|
Term
|
Definition
| is a way of presenting data, such as centring text or adding dollar signs to represent currency. |
|
|
Term
|
Definition
| is an accepted and standard way of formatting data. |
|
|
Term
|
Definition
| is performed to ensure that the process, functions and formulas of a solution operate and manipulate data as expected. A solution needs to be tested for its effectiveness. |
|
|
