Apple
A data that is stored in an organised way to make
searching through it to find information easier.
What is a database?
Fields.
What do you call the columns in a database?
Records.
What do you call the rows in a database?
Random Access Memory.
What does RAM stand for?
It means multiplication in spreadsheets.
What does * mean in spreadsheets?
A field that uniquely identifies a record in that table.
What is a primary key?
Checks to see if the data being entered is sensible and valid and in the correct format.
What is data validation?
A keyboard.
What is an example of an input device?
A foreign key.
What is used to create a link between tables?
A speaker.
What is an example of an output device?
An external hardware component that connects to a computer to add functionality
What is a peripheral device?
Data redundancy.
What is duplicating data known as?
It looks up a value from one table and compares it to the value in a second table
What is VLOOKUP?
A floppy disk.
Example of a magnetic storage media.
It has no moving parts.
What is an advantage of a solid state device?
5.6 x 10-⁴
Write 0.00056 in standard form.
It uses $.
What do you use in Absolute cell referencing?
Refers to the programs that run and control a computer’s hardware and application software.
What is system software?
Optical storage.
Which storage is the slowest?
A linear equation.
What is this y=mx+c
System software and application software.
What two types of software are there?
The process of reorganizing data on a hard disk drive (HDD) so that related pieces of information are stored together in contiguous, sequential blocks.
What is defragmentation?
5, 8, 11, 14, ...
What is an example of an arithmetic sequences?
A reflex angle.
How do you call an angle greater than 180 degrees?
2, 3, 5, 7 and 11.
What are the first five prime numbers?