Ict Flashcards
What is computer hardware
The physical part of the computer that 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 gets information from the computer and outputs it to the real world
Examples of input devices
Keyboard
Games controller
Scanner
Bar code reader
Keypad
Computer mouse
Motion sensor
Microphone
Digital camera
Examples of an output device
Printer
Headphones
Projector
Examples of storage devices
USB drive
Hard drive
What is computer software
A set of computer programs and associated documentation and data
Operating system (what it does)
Manages all of the software and hardware on the computer.
3 examples of an operating system
Android
Macos
Unix
Applications software (what it does)
To aid the user in doing specified tasks
3 examples of an application software
PowerPoint
Excel
Outlook
Utilities software
Helps users configure, analyse, optimize and maintain a computer
3 examples of utilities software
Anti virus
File management system
Compression tools
What is the top row of a table used for
The title
Why are table designs used
To store information neatly.
Displaying large amount of data in rows and columns.
Fast and easy to read.
What is a database
An organized collection of structured info or data typically stored electronically in a computer system
A field
A column of data
A record
The complete set of data about one person or thing
How can you protect your computer from viruses?
Download anti virus
What is the function of the equals sign at the start of a formula
It let’s excel know that a formula is being used
What is a formula
Equations that preform calculations on values in your sheet
What is a function
A chunk of code that you can use over and over again rather than writing it out multiple times
What do the following spreadsheet tools do (sort)
Helps you organize data eg.( Biggest to smallest, A-Z)
What do the following spreadsheet tools do (filter)
A quick way to display only the information relevant at a given time and remove all other data from view
