Font size
WorksheetsIGCSE ICT revision
Total questions: 78
Worksheet time: 52mins
This type of interface allows the user to use their voices to carry out a function.
GUI
CLI
Dialogue-based interface
Gesture-based interface
It is an internal hardware device that connects a computer to a local area network.
router
switch
bridge
NIC
It is an input device that is used to read the temperature.
keyboard
mouse
sensor
joystick
It is the physical component such as monitor, printer or projector.
Input Device
Output Device
sensor
Analogue
It is an input device that is used to move the objects around the screen in computer games.
keyboard
mouse
sensor
joystick
It is an input device that is used to read the answers to the multiple-choice examination papers.
RFID
OMR
Sensor
OCR
It is a symbol or a pictorial representation of programs, files and folders.
word
windows
icons
spreadsheet
It is the physical component that allows data to be entered into a computer system.
input device
output device
sensor
analogue
It is the physical data that changes smoothly.
Input device
Output device
Sensor
Analogue
It is an input device that is attached to a monitor.
Keyboard
Touchpad
Webcam
Speaker
It is an external device that retains a computer’s data even after the computer is turned off.
SSD
HDD
Pen Drive
RAM
It is a printer that prints by pressing metal pins against an ink ribbon onto the paper.
Inkjet Printer
Laser Printer
3D Printer
Dot-Matrix
It is a printer that sprays tiny droplets of ink directly onto the paper.
Inkjet Printer
Laser Printer
3D Printer
Dot-Matrix
It is a printer that uses resin to create solid objects.
Inkjet Printer
Laser Printer
3D Printer
Dot-Matrix
This device helps the LAN to connect to the internet.
Bridge
Switch
Router
Hub
This device transmits data to a specific computer on the LAN.
Bridge
Switch
Router
Hub
This device broadcasts data to all computers on the LAN.
Bridge
Switch
Router
Hub
This device connects one LAN to another LAN that uses the same protocol to make a single LAN.
Bridge
Switch
Router
Hub
It is a printer that uses toner to transfer the print image to plain paper.
Inkjet Printer
Laser Printer
3D Printer
Dot-Matrix
Identify a device that is part of the smartphone and could be used to output the data.
(a)
Name the volatile memory that is used to store the currently use data.
(a)
Name the non-volatile memory that is used to store startup instructions.
(a)
This storage device uses platters to store data.
(a)
MAC address uses (a) bits which are separated into four groups of denary.
IPv6 address uses (a) bits which are separated into eight groups of hex digits.
Which of the following are NOT labour saving devices?
Television
Air-conditioning Systems
Dishwasher
Automatic Washing Machine
Which of the following are labour saving devices?
Robotic Vacuum cleaners
Air-conditioning Systems
Automatic Dishwashers
Automatic Washing Machines
Which of the following are DISADVANTAGES of having labour saving devices?
Make people lazy.
Make people lose skills.
Make people waste time.
Make people unhealthy.
Which of the following are ADVANTAGES of having labour saving devices?
Give people more leisure time.
Make people do manual tasks.
Give people cybersecurity threats.
Give people a sense of security.
In autonomous vehicles, microprocessors send signals to ____________ to operate the throttle.
Sensors
Cameras
Actuators
Gear
In autonomous vehicles, microprocessors process the data received from __________.
Sensors
Cameras
Actuators
Gear
Which of the following devices can be found in an autonomous vehicle?
Radar
GPS
Solar
LIDAR
Which of the following is not an example of potential health problems related to the prolonged use of IT equipment?
Obesity
Neck Pain
Eyestrain
What causes Ozone Irritation in the workplace?
Air-conditioning Unit
Computers
Monitor
Laser Printer
Which of the following health risks can be reduced by using fully adjustable chairs?
Back and neck pain
RSI
Eyestrain
Headaches
Which of the following health risks can be reduced by using anti-glare screens?
Back and neck pain
RSI
Eyestrain
Headaches
Which of the following health risks can be reduced by using footrests?
Back and neck pain
RSI
Eyestrain
Headaches
Which of the following health risks can be reduced with proper ventilation?
Ozone Irritation
RSI
Eyestrain
Headaches
Choose the sub-types of numeric data type.
Alphanumeric
Integer
Date and Time
Currency
Ergonomic keyboard can be used to reduce the risk of (a) .
Having a microprocessor-controlled device connected to the internet can lead to (a) issues.
A (a) is an organised collection of data.
A (a) is a single item of data such as DOB.
A (a) is collection of fields, i.e. all the information about one person or one item.
In database terms, a (a) is an organised collection of records.
MS Excel is an example of (a) database.
MS Access is an example of (a) database.
A (a) key is a key field that holds unique data that can be used to identify a record.
(a) key field stores values from a primary key field in another table.
(a) key field stores values from a primary key field in another table.
This data type stores data as 0/ but display it as Yes/No.
(a)
MS Access supports three main types of field. They are:
Numeric
Decimal
Alphanumeric
In absolute cell referencing, we use a (a) sign between the part of the reference that is to be fixed.
A formula in Excel starts with an (a) sign.
Which of the following functions will not count any blank cells within the range.
Count
CountA
CountIF
Counts
What is a "generic file format"?
A file type that can only be opened by specific programs or platforms.
Files that are saved in "package-specific formats."
Files create on PC's that can be read or imported on Apple Macs or other operating systems.
A file type that can be opened by multiple programs and platforms.
Default file formats used by Microsoft Office programs are generic.
True
False
Generic file formats contain all of the formatting that can be saved in package-specific formats.
True
False
What is a "package-specific format"?
A file type that can be used by multiple programs.
A file type that can usually be used by only one program.
Files that often have more formatting features than other formats.
What program uses the extension ".XLSX" as it's default file format?
Microsoft Excel 2007+
Microsoft Word
Google Sheets
Microsoft Excel 2003
Which are generic file formats/file extensions for spreadsheets?
.CSV
.XLSX
.DOCX
.TSV
Which are generic file formats for word processing software programs?
.DOCX
.TXT
.RTF
Which are generic file formats for still image files?
.BMP
.JPG / .JPEG
.PNG
.MP4
Which are generic file formats for video files?
.MP4
.GIF
.JPG / .JPEG
.FLV
.MWV
Which are generic file formats for audio files?
.MP3
.WAV
.AIFF
.AAC
Which are generic file formats for website authoring?
.CSS
.HTM / .HTML
.DOCX
.ACCDB
What are compressed file formats?
File formats that are used to reduce the size of files.
File formats that allow you to combine multiple files into a single file.
File formats that are often used when sending files from one device to another.
File formats that help reduce the time needed to download files from webpages or online storage sites.
Which are some generic file formats for compressed files?
.RAR
.ZIP
.PPTX
.SMAL
What program uses the extension ".DOCX" as it's default file format?
Microsoft Word 2007+
Apple Pages
Microsoft Word 2003
Google Docs
What program uses the extension ".PPTX" as it's default file format?
Microsoft PowerPoint 2007+
Microsoft PowerPoint 2003
Apple Keynote
Google Sheets
A subfolder is a new folder created in the same location as another folder.
True
False
Maybe.... I don't know much about computers.
A planned folder structure is a set of folders and subfolders used to hold different types of files, or files related to each other to help keep your hard drive neat and organized.
True
False
Whatcha' talking about, teacher?
What are ways to create a new folder in Windows 10?
CTRL + Shift + N
right click/New/Folder
use create folder button in Quick Access Menu or folder ribbon
Cast a magic spell
What are the ways to open a file located in a folder?
right click/Open
double click on the file icon
select the file then choose Open from File Explorer ribbon
CTRL + Shift + O
What is NOT a way to open a file without using its default program?
"right click/Open with", choose a compatible program
File Explorer Ribbon: drop down menu in "Open", choose a compatible program
open the program 1st, then load/open the file from the program
open the program 1st, drag the file into the program window
"right click/Edit"
A _______________ is the creation of a model of a real system in order to study the behaviour of the system.
Encryption
simulation
modelling
application
(a) is a continuous transmission of video or audio files from a remote server where the files are stored.
(a) makes sure the video plays back smoothly without freezing.
