ICT Theory

What is an organised set of data called?
A database
1 of 74
What is a set of data associated with one person called?
A record
2 of 74
What are fields?
The data in each record is different, but each record has the same structure. (each one has a name, d.o.b., phone, etc.) We say that each record contains the same fields.
3 of 74
What is a field name?
Each field has a field name (e.g. 'Date of Birth')
4 of 74
It is very important that every record in a database can be individually identified. How is this done?
Each record is given an ID number
5 of 74
What is a Primary Key?
The unique identity for each individual record
6 of 74
What is a flat-file database?
One that contains a single table of data
7 of 74
What is a relational database?
One that contains two or more tables of data connected by links or relationships
8 of 74
Why is repeated data in a database a bad thing?
It wastes space in the database It takes time to input, typing the same data over and over (and mistakes may be made) It is a pain to update
9 of 74
What is a foreign key?
When a key field from one table appears in a different table
10 of 74
What is computer software?
Computer software is a collection of numeric codes which tell the computer what to do
11 of 74
How is text that is typed into a computer stored?
As numeric codes
12 of 74
How are images stored in the computer?
As numeric values (different values for different coloured pixels)
13 of 74
How would you attach an analogue input device to a digital device such as a computer
You will need an analogue to digital convertor (ADC).
14 of 74
Give an example of a computer peripheral that requires an ADC
A microphone. When you plug a microphone into a computer, you are actually plugging it into an ADC which converts the analogue signals from the microphone into digital data that the computer can then process.
15 of 74
How would you attach an analogue output device to a digital device such as a computer?
You will need a digital to analogue convertor (DAC)
16 of 74
Give an example of a computer peripheral that requires a DAC
A loudspeaker or headphones
17 of 74
Name some areas that have experienced decreased employment due to computers
Manufacturing, secretarial, accounting, newspaper printing
18 of 74
How have computers affected jobs in manufacturing?
Many factories now have fully automated production lines. Instead of using people to build things, computer-controlled robots are used. Robots can run day and night, never needing a break, and don’t need to be paid!
19 of 74
How have computers affected jobs in secretarial work?
Offices used to employee many secretaries to produce the documents required for the business to run. Now people have personal computers, they tend to type and print their own documents.
20 of 74
How have computers affected jobs in accounting?
Companies once had large departments full of people whose job it was to do calculations (e.g. profit, loss, billing, etc.) A personal computer running a spreadsheet can now do the same work.
21 of 74
How have computers affected jobs in newspaper printing?
It used to take a team of highly skilled printers. The same task can now be performed far more quickly using computers with DTP software and computer-controlled printing presses.
22 of 74
In what areas have computers increased jobs?
IT Technicians, Computer Programmers, Web Design, Help Desk Staff
23 of 74
Why have IT Technician jobs been created?
All of the computers in a business need to be maintained: hardware fixed, software installed, etc. IT technicians do this work.
24 of 74
Why have Computer programmer jobs been created?
All of the software that is now used by businesses has to be created by computer programmers
25 of 74
Whay have Web Designer jobs been created?
Much of modern business is conducted on-line, and company websites are very important. Company websites need to be designed and built which is the role of web designers.
26 of 74
Why have more help desk jobs been created?
People often need help using computers, and software applications. Computer and software company have help-desks staffed by trained operators who can give advice.
27 of 74
What is a microprocessor?
A microprocessor is a small CPU built into a single 'chip'
28 of 74
What sort of microprocessor is typically used in everyday devices in our homes?
A microcontroller
29 of 74
What is in a microcontroller?
A CPU Some RAM Some ROM (Used for storing the devices software) Often microcontrollers also contain ADCs and DACs to allow easy connection to devices such as sensors and actuators.
30 of 74
List some entertainment devices that used microcontrollers
Games consoles DVD players MP3 players
31 of 74
List some "labour saving" devices that contain microcontrollers
Programmable microwave ovens Programmable washing machines Home security systems Mobile telephones
32 of 74
What effects do microprocessor controlled devices have on our lives?
More leisure time, easier communication, online shopping
33 of 74
List some safety issues relating to computers
Trailing cables, spilt drinks or food, overloaded power sockets, heavy objects falling
34 of 74
How can trailing cables be made safe?
Place cables inside cable ducts, or under the carpet / flooring
35 of 74
How can spilt drinks and food be avoided?
Keep drinks and food away from computers
36 of 74
How can overloaded power sockets be made safe?
Never plug too many cables into a socket. Always make sure there are fire extinguishers nearby
37 of 74
How can we avoid heavy objects falling?
Make sure equipment is placed on strong tables / shelves
38 of 74
What sensors could you use to detect illegal deforestation?
Light, temperature, movement, moisture
39 of 74
In what ways does photoshop allow users to manipulate an image?
Crop (cut off bits that you don't want) Resize Distort (e.g. bend, twist, stretch, etc.) Alter colour (e.g. brighten, make black & white, etc.) Add effects (e.g. shadows, glow, texture) Add graphics (e.g. lines, circles, borders, etc.) Add text
40 of 74
What types of documents could be produced using desktop publishing?
books posters flyers magazine newspapers
41 of 74
Why is DTP software described as WYSIWYG?
The document looks the same on the screen as it will when it's printed).
42 of 74
What is a website?
A collection of web 'pages' that provide a mixtures of content: Text Images Animations Video Audio Hyperlinks (to jump to other content)
43 of 74
'Multimedia' refers to documents / software applications that contain a mixture of what?
text, images, animations, video, audio
44 of 74
How could you produce a musical score using your computer?
You can use a WYSIWYG editor to write the music on the computer, edit it, print copies, etc.
45 of 74
List some weather conditions that could be monitored using sensors
Rainfall, temperature, wind-speed, wind-direction
46 of 74
Why is it useful to use computers to measure things?
Computers do not need to take breaks, more accurate readings, take data readings more frequently, data can be analysed more quickly and easily, can operate in difficult environments
47 of 74
A computer system is made up of which 3 parts?
Input, processes and output
48 of 74
What do input devices do?
Input devices called sensors feed data into the computer
49 of 74
What is a system process?
The computer then processes the input data (by following a set of instructions)
50 of 74
What do output devices do?
As a result of the processing, the computer can turn on or off output devices called actuators.
51 of 74
What is a actuator?
An actuator is a device, controlled by a computer, that can affect the real-world.
52 of 74
List some examples of actuators
Light bulb or LED, Heater, Cooling Unit, Motor, Pump, Buzzer / Bell / Siren
53 of 74
What is a computer model?
a computer program that attempts to simulate a real-life system. In other words, it is a ‘virtual’ version of something in the real-world.
54 of 74
Why might computer models be used?
To test a system without having to create the system for real, To predict what might happen, To train people , To investigate a system in great detail
55 of 74
How might computer modelling be used?
Designing Safer Cars, Weather Forecasting, Building Better Bridges, Running a Business, Training Pilots to Fly an Airplane
56 of 74
Why is using a computer model a good idea when designing cars?
A computer model of a car can be used to test how safe the design of the car is in a crash. The virtual car can be crashed over and over again,
57 of 74
Why is using a computer model a good idea when forecasting the weather?
A computer model of a weather system can be used to predict storms. The wind patterns, temperatures, etc. for the whole planet are simulated using very powerful computers
58 of 74
Why is using a computer model useful when building bridges?
Bridges have to be able to survive extreme weather conditions. It is obvious not practical to build a real bridge and then wait to see if it falls down in a storm. Instead, a computer model of the bridge is created and tested in virtual storms.
59 of 74
Why is a computer model useful when running a business?
A computer model of a business can be used to help predict future profits.
60 of 74
Why are computer models useful when training pilots to fly aeroplanes?
Trainee pilots have many hours of lessons in flight simulators before being allowed to fly a real airplane. Pilots can make mistakes without putting anyone’s life at risk.
61 of 74
What is batch processing?
we can prepare the data into a set or 'batch' and hand it over to the computer to be processed in one go. Once we have prepared the batch of data, no user input is required - the computer works its way through the data automatically.
62 of 74
What is the advantage of batch processing?
The processing can occur when the computer is not being used for anything else (e.g. at night).
63 of 74
How is payroll processed?
Working hours data is collected into a batch The data can be processed in one go at the end of the week/month The same calculations will be performed on all the data No user input is required during the processing The processing can be done during qu
64 of 74
What is "point of sale (POS)"?
A method of inputting the codes of goods purchased - usually a bar-code scanner. The codes are then used to find more information about the goods, such as price, from a database
65 of 74
What is Electronic Fund Transfer at Point-of-Sale (EFTPOS)?
A system used when you use a bank card to pay for a purchase in a store,
66 of 74
What are sensors used to measure in hospitals?
Pulse rate (heart beats per minute) Temperature Breathing rate (breathes per minute) Blood oxygen levels Blood pressure
67 of 74
Several outputs from the computer system let hospital staff the know the patient's condition: What are they?
A large display / monitor shows graphs of pulse, breathing, etc. A loud buzzer / alarm can be sounded if there is a problem to attract the attention of a nurse/doctor A small printer can produce a hard-copy of the data
68 of 74
What do MRI and CT scanners do?
The complex signals that come back from these huge machines are picked up by sensors and fed into a computer. The computer processes the data, then outputs full-colour images, sometimes in 3D, for the doctor, giving views of the patient's body.
69 of 74
Why are computerised databases used in hospitals?
Patient data can be easily shared between doctors, pharmacies and other hospitals It is easy to search for and retrieve patient records Doctors can instruct a pharmacy to issue medication for a patient (no paper note needs to be written)
70 of 74
What data do schools need to manage?
Pupil information (name, contact details, etc.) Staff information (name, bank details for pay, etc.) Timetable (rooms, times, subject, staff, classes, etc.) Pupil attainment (marks, grades, comments, etc.) Pupil behaviour (dates, incidents, notes)
71 of 74
What advantages do a computerised database bring to a library?
Quick and easy searching for books Easy printing out of book lists / labels Easy tracking of book loans (who has it, when it was borrowed, etc.) Automatic printing of warning letters for borrowers who have not returned books
72 of 74
What details might a typical library database contain?
Book ID (number / text) Title (text) Author (text) Publisher (text) ISBN (number) Fiction / non-fiction (boolean) Genre / category (text) Cost (number) Date of purchase (date)
73 of 74
When designing a database, what does the system designer needs to consider?
The type of data being stored (numbers, text, dates, etc.) The size of the data (how long is a typical name, etc.) The field names to use How many records will need to be stored
74 of 74

Other cards in this set

Card 2


What is a set of data associated with one person called?


A record

Card 3


What are fields?


Preview of the front of card 3

Card 4


What is a field name?


Preview of the front of card 4

Card 5


It is very important that every record in a database can be individually identified. How is this done?


Preview of the front of card 5
View more cards


No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Data and Information resources »