Ict Revision Flashcards
(25 cards)
What is computer hardware?
Computer hardware is the physical part of the computer you can touch
What does an input device do?
It puts information from the real life world into the computer system
What does an output device do?
It takes information from the computer system and outputs it to the real life world
Examples of input devices
Keyboard
Scanner
Bar code reader
Keypad
Computer mouse
Motion sensor
Microphone
Examples of output devices
Printer
Headphones
Projector
Example of storage devices
USB drive
Hard drive
What is computer software?
A set of computer programs and associated documentation and data
What does an Operating System do?
It manages all of software and hardware on the computer
What does Applications Software do?
It is to aid the user in doing a specified task
What does Utilities Software do?
It helps users configure, analyse, optimise and maintain a computer
Operating system examples
Android, macOS and Unix
Applications Software examples
PowerPoint, Excel and outlook
Utilities Software examples
Anti Virus, File management system and compression tools
What is the top row of a table used for?
The title
What is a formula
an expression telling the computer what mathematical operation to perform upon a specific value
Why are table designs used?
Displaying large amount of data in rows and columns
To store information neatly
Fast and efficient
What does the “=“ symbol at the start of a formula or function do?
It lets the computer know that you want to write in a formula
What is a function?
A function is a group of instructions, also known as a named procedure, used by programming languages to return a single result or a set of results
What does the spreadsheet tool “sort” do?
It helps you organise data
What does the spreadsheet tool “filter” do?
It lets you hide specific data into a range of cells that you select so that you can see what your spreadsheet looks like without this information
What is a database?
A database is a organized collection of data stored electronically
What is a field(Database)
It is a column
What is a record(Database)
It is a row
Where would you see electronic databases being used?
Hospitals
Schools
Offices
