Validation Please
The raw unprocessed facts and figures that a computer processes following a set of instructions.
What is Data?
It enables you to store not only numerical data but also formulae to carry out operations on the numerical data.
What is a Spreadsheet?
It allows us to execute a statement or group of statements multiple times.
What is a loop?
A collection of data files that may be used by a number of applications with storage and access to the data controlled by a set of programs.
What is a Database?
Connects computers so that peripherals such as printers can be shared among the computers.
What is a Computer Network?
Involves a set of actions that converts the data into useful information.
What is Data Processing?
Another name for a pre-programmed formula in Excel
What is a Function?
It repeats a statement or group of statements while a given condition is true. It tests the condition before executing the loop body.
What is a While-do Loop?
A particular field of each record containing an item which is used to identify the record.
What is a Primary Key?
The basic building block of any computer network but it is confined to a limited geographic area.
What is a Local Area Network (LAN)?
Compares the contents of two or more fields to make sure that they make sense.
What is Consistency Check?
The basic unit of a worksheet into which you enter data.
What is a Cell?
It is a symbolic name given to a specific memory location in the computer that stores a particular value.
What is a Variable?
A method used to enter, view or print the information in a table or query in a format other than rows and columns.
What is a Form?
It is large enough to extend to an area like a city or campus. Might therefore be owned and operated by a single organisation or a university and accessed by students and other associated organisations.
What is a Metropolitan Area Network (MAN)?
The checking for mistakes such as transcription errors when data is copied from one medium or device to another.
What is Data Verification?
The function in Excel that tells how many numeric entries there are..
What is COUNT?
A sequence of instructions that has a finite number of steps, which, if followed, produces a precise solution to the given problem, or part of the problem.
What is an Algorithm?
An Access object that enables you to view data from one or more tables in a specified order.
What is a Query?
A communications network that spans over a large area, wirelessly connecting many sites.
What is a mobile network?
Entering details twice using a program that checks each second entry against the first.
What is Double Data Entry?
The address of the cell in the seventh column of the sixth row in a worksheet.
What is G6?
Sequential, Selection (the use of if then else), Iteration or loops – (for loop, While loop and repeat and until)
What are Algorithm Constructs?
Organise and group information from tables and queries, and format the data to make it suitable for online viewing or for printing from the database.
What is a Report?
Has no geographical limit. It can connect computers and other devices on opposite sides of the world.
What is a Wide Area Network (WAN)?