wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT 8 Review 1

Total questions: 123

Worksheet time: 3hrs 6mins

Name
Class
Date
1.

What is this?

a)

A cheese grater

b)

An abacus

c)

A game

d)

An early camera

2.

Who invented the Difference Engine?

a)

Charles Blubber

b)

Charles Babbage

c)

Charles Baggage

d)

Charles Blagger

3.

Many early computers were big enough to fill a whole room and weighed thousands of pounds.

a)

TRUE

b)

FALSE

4.

The first electronic computing machine was invented by _________ to compile data for the 1890 United States census.

a)

Francis Holberton

b)

Ada Byron

c)

Herman Hollerith

d)

Grace Hopper

5.

Who is this icon of Computing?

a)

Steve Jobs

b)

Charles Babbage

c)

Alan Turing

d)

Grace Hopper

e)

Bill Gates

6.

Who is this icon of Computing?

a)

Steve Jobs

b)

Charles Babbage

c)

Alan Turing

d)

Grace Hopper

e)

Bill Gates

7.

Often credited with being the first ever computer programmer, Who is this?

a)

Ada Lovelace

b)

Taylor Swift

c)

Margaret Thatcher

d)

Eva Longoria

e)

Carrie-Anne Matthews

8.

Grace Hopper found a moth stuck in a relay responsible for a malfunction, and removed it, calling it _______.

a)

Operating

b)

Cleaning

c)

Hacking

d)

Debugging

9.

Which one of these is NOT a Google product

a)
b)
c)
d)
10.

What was the Colossus Computer used for

a)

Defrosting frozen chickens

b)

Decoding German secret messages

c)

Preparing canapes for a party

d)

Calculating the time

11.

What does the 'PC' stand for?

a)

Personal Computer

b)

Private Computer

c)

Posh Computer

d)

Petite Computer

12.

When was the ENIAC invented?

a)

February 15, 1946

b)

November 14, 1946

c)

February 24, 1955

d)

October 5, 2001

13.

(a)   is the physical appearance/characteristics of a computer system.

14.

What system component is this?

a)

RFID card

b)

Motherboard

c)

CPU

d)

GPU

e)

ENIAC

15.
What is a "Web Browser"?
a)
A program for displaying web pages
b)
A program for finding web sites using key word searches
c)
A computer
d)
For moving around the Internet
16.
When was the first computer built?
a)
1822
b)
1922
c)
1980
d)
1950
17.

What does the 'e' in e-mail stand for?

a)

Earlobe

b)

Electronic

c)

Electric

d)

Elephant

18.
The Internet was first invented in the late 1960's.
a)
True
b)
False
19.

The brain of the computer is:

a)

Monitor

b)

Central Processing Unit (CPU)

c)

Mouse

d)

External Hard Drive

20.
Why was a computer mouse called a 'mouse'
a)
It is the same size
b)
A wire comes out of it like a tail
c)
It is usually grey
d)
It has two eyes
21.
When was the first email sent
a)
1972
b)
1872
c)
1953
d)
2001
22.

a two-digit system of 0's and 1's that computers use to store and transfer information on computers is known as:

a)

base 10 numbers

b)

hexadecimals

c)

decimal numbers

d)

binary numbers

23.

The slide rule assisted with _____________.

a)

algrebra

b)

multiplication and division

c)

measuring things

d)

square roots

24.

The astrolabe was another mechanical calculating device used enabled sailors to calculate _____________.

a)

their latitude at sea

b)

their speed

c)

their direction

d)

the date

25.

What was the first electronic general-purpose computer?

a)

IBM PC

b)

UNIVAC

c)

Colossus

d)

ENIAC

26.
Who invented calculating rods in the 1600s?
a)
John Napier
b)
Charles Babish
c)
Bill Gates
d)
Steve Jobs
27.

What 'special' feature could you do with Napier's Bones?

a)
Multiply
b)
Add
c)
Subtract
d)
Divide
28.
Who invented a machine to add long columns of numbers quickly?
a)
Charles Babbish
b)
 Blaise Pascal
c)
John Napier
d)
Bill Gates
29.
a)
Monitor
b)
Computer
c)
CPU
d)
Printer
30.
a)
Hard Drive
b)
CD-ROM Drive
c)
USB Drive
d)
Floppy Disc
31.
a)
Recorder
b)
Radio
c)
Digital Camera
d)
Scanner
32.
a)
Screen
b)
Printer
c)
CD
d)
Speakers
33.
a)
Microphone
b)
Key
c)
Keyboard
d)
Peripheral
34.
The computer instructions
a)
Hardware
b)
Software
c)
RAM
d)
ROM
35.
CPU stands for 
a)
Century Process Unit
b)
Central Product Unit
c)
Central Processing Unit
d)
Central Processing Uno
36.
An external device attached to the computer
a)
Peripheral Device
b)
Input Device
c)
Output Device
d)
Rom
37.
RAM stand for 
a)
Random Access Memory
b)
Read Access Memory
c)
Ram Access Memory
d)
Read Only Memory
38.
ROM is
a)
Temporary Memory
b)
Permanent Memory
c)
Short Memory
d)
Long term memory
39.
A hard drive is a ______________ device
a)
input
b)
output
c)
storage 
d)
input, output, and storage
40.
A scanner is a ___________ device.
a)
Input
b)
Output
c)
Storage
d)
Input, Output, and Storage
41.
Remote Control
a)
Input 
b)
Output
42.
Projector 
a)
Input 
b)
Output
43.
Headphones
a)
Input 
b)
Output
44.
Scanner
a)
Input 
b)
Output
45.
Barcode Reader
a)
Input 
b)
Output
46.
a)
input
b)
output
47.

A computer has the ability to:

a)

It has the ability to store, retrieve, and process data.

b)

It has the ability to store, retrieve, and pastas data.

c)

It has the ability to stage, retrieve, and process data.

48.

What is a computer?

a)

A computer is case that manipulates information or data.

b)

A computer is an electronic device that manipulates information or data.

c)

A computer is powered box that manipulates information or data.

49.

Identify the picture

a)

Random Access Memory

b)

Read Only Memory

c)

USB Flash Drive

d)

Memory Card

50.

Identify the picture

a)

Random Access Memory

b)

Read Only Memory

c)

USB Flash Drive

d)

Hard Disk Drive

51.

Identify the picture

a)

Random Access Memory

b)

Read Only Memory

c)

USB Flash Drive

d)

Memory Card

52.

Which of these terms best describes the average computer buyer in the 1960s?

a)

Small business

b)

Large institution (colleges, big business, government)

c)

Elementary schools

d)

Train enthusiast

53.

Charles Babbage designed the Difference Engine and the Analytical Engine. What were these?

a)

Mechanical Computers

b)

Thermometers

c)

Rulers

54.

If you wanted to enter data on a 19th century computer, you would do it with:

a)

Disks

b)

Gears

c)

Cards

d)

Tape

55.

Which of the following word pairs best symbolizes the ones and zeroes in binary code?

a)

Sight and sound

b)

Yes and no

c)

Red and blue

d)

Want and need

56.

Analytical engine was invented in

a)

1933

b)

1733

c)

1833

d)

1803

57.

Choose the best answer for this image.

a)

microprocessors

b)

integrated circuits

c)

transistors

d)

artificial intelligence

58.

Choose the best answer for this image.

a)

integrated circuits

b)

microprocessors

c)

transistors

d)

artificial intelligence

59.

Choose the best answer for this image.

a)

vacuum tubes

b)

microprocessors

c)

transistors

d)

integrated circuits

60.

Choose the best answer for this image.

a)

integrated circuit

b)

microprocessor

c)

vacuum tube

d)

transistor

61.

A database is used to

a)

Calculate figures

b)

Store data in a logical order

c)

Layout pages attractively

d)

Present material using animations

62.

A record is made up of

a)

Fields

b)

Primary Key

c)

Foreign key

d)

Currency

63.

Rows in a database tables are called...

a)

Fields

b)

Tables

c)

Records

d)

Forms

64.

Which of the following would be used to uniquely identify a record

a)

Field size

b)

Validation

c)

Data type

d)

Primary Key

65.

Columns in a database are called...

a)

Rows

b)

Tables

c)

Fields

d)

Forms

66.

Everything on one row is a record.

a)

True

b)

False

67.

Each item from this list is classified as...

Name, Birthdate, Street, County , PostCode

a)

Form

b)

Table

c)

Record

d)

Field

68.

Which of the following is an example of a record?

a)

5

b)

5, Thorpe, Steven, 12/17/1982, 25

c)

25

d)

2, 1, 8, 9, 3, 6, 4, 5, 7

69.

Which of the following is an example of a field?

a)

5

b)

Birth Date

c)

Thorpe

d)

25

70.

The best data type to choose for a postal code would be:

a)

Percentage

b)

Date/Time

c)

Text

d)

Currency

71.

The best data type to choose for date of birth would be:

a)

Text

b)

Number

c)

Currency

d)

Date/Time

72.

To find a particular set of data in a database you would use a:

a)

Table

b)

Form

c)

Query

d)

Report

73.

What do we use to connect tables in a relational database:

a)

Foreign Key

b)

Query

c)

Fields

d)

Table

74.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
75.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
76.

A data type used for storing numbers with a fractional/decimal part e.g. 3.142

a)

Integer

b)

Boolean

c)

Real

d)

String

77.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
78.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
79.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
80.

A sports club needs to store information about each member.  All the information about the members can be entered as a:

a)

Field

b)

File

c)

Table

d)

Record

81.
One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
82.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
83.
One specific piece of information about a person or thing is called:
a)

Data

b)

File

c)

Record

d)

Table

84.
A health club wants to find all the members who use the club 3 days or more a week.  What will they put in the query in the 'days' SQL query criteria?
a)
>3
b)
<3
c)
<=3
d)
>=3
85.

The school wants to sort the data by staff Surname from A to Z.  How will they sort it?

a)

Ascending order

b)

Descending order

86.
A Primary Key is a code that uniquely identifies a _____________ in a Database.
a)
Record 
b)
Field 
c)
Text 
d)
Number
87.
What program should you use if you want to store and organize large amounts of information?
a)
Word
b)
Excel
c)
PowerPoint
d)
Access
88.
Reports are used to _____________.
a)
organize data
b)
display data on the screen
c)
print out data
d)
store data
89.
8. Which ribbon tab do you use to make a new table?
a)
File
b)
Home
c)
Create
d)
External Data 
90.

Which of these examples uses a database?

Select 3.

a)

Phone contacts

b)

I-Tunes

c)

Hospital records

d)

Word Processor

e)

MS Paint

91.

Text, Number and Date/Time are all examples of...

a)

Data Types

b)

Filters

c)

Sorts

d)

Validations

92.

A method of only displaying records in a table that match specific criteria...

a)

Search/Filter

b)

Validation

c)

Sort

d)

Verification

93.

A collection of fields and records in a specific category

a)

Record

b)

Table

c)

Field

d)

Spreadsheet

94.

Which of the following is an example of a record?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

95.

What is a database?

a)

A piece of software to do calculations

b)

A device to load information onto the computer.

c)

A structured collection of records

d)

A calculator

96.

What is the main purpose of sorting/searching data?

a)

Makes it nicer to look at

b)

Makes it easier to input new data

c)

Helps to find specific information quickly

d)

Gives me something to do when I'm bored

97.

if you wanted to show only people who are older than 10, what would the search criteria for age be?

a)

=10

b)

<10

c)

=>10

d)

>10

98.

What can be a description of a query?

a)

A Table

b)

A Question

c)

A Spreadsheet

d)

A Report

99.

Ted is creating a database for several customers. He needs to use USD and Pounds. What is the data type for these?

a)

Date/Time

b)

Text

c)

Number

d)

Currency

100.

Your boss has required all products from highest price to lowest. How would this information be retrieved?

a)

 Sort Ascending 

b)

 Sort Descending 

c)

 Filter 

d)

 Find

101.

Which of the following is NOT true of databases?

a)

You can store large amounts of data.

b)

You have to use a computer.

c)

You can search the data.

102.

Which of the following can be an advantage of paper-based databases?

a)

It is easy to add or amend records.

b)

You do not need any training on how to use the database.

c)

Data can be sorted and re-sorted easily.

103.

Thinking of data, information and knowledge - which of the following is an example of information?

a)

The average men's shoe size is nine.

b)

9

c)

If you are to open a shoe shop, you must stock plenty of size nine shoes.

104.

Which of the following holds a single piece of data?

a)

Table

b)

Record

c)

Field

105.

Which field would be inappropriate in a database of countries?

a)

Continent

b)

Population

c)

First Name

106.

What is the correct definition of primary key?

a)

The first field in a table.

b)

A field that contains unique data in each record.

c)

The field which we will use to search with.

107.
Which of these is not an advantage of using an electronic database?
a)
Faster to find information
b)
Easy to move information - portable
c)
Could be hacked
d)
Can keep a back-up copy
108.
Which of these is an advantage of a paper database?
a)
Easily damaged or lost
b)
Hard to update information
c)
Can share from one computer to another
d)
They are cheap to use
109.
What is a flat file database?
a)
A database that's squashed like a pancake
b)
A database with only 1 table
c)
A database that doesn't contain much data
d)
A database with multiple tables that are linked together
110.
Which description is correct for a record?
a)
All the information about one person or item 
b)
Used to print information from the database
c)
A method of searching the database for specific information
d)
A place where all records are stored
111.

What criteria has been applied in this table?

a)

Gender - Male

b)

Eyes - Blue

c)

Name - Descending Order

d)

Height - Ascending Order

112.

Identify the 2 criteria filters that has been applied in this table.

a)

Eyes (Blue) & Real Name (Sort Ascending)

b)

Weight (Sort Descending) & Gender (Male)

c)

Superhero (Sort Descending) & Lives (Gotham City)

d)

Gender (Male) & Superhero (Sort Ascending)

113.
Which description is correct for a query?
a)
Used to print information from the database
b)
A method of searching the database for specific information
c)
A place where all records are stored
d)
All the information about one person or item
114.
In this query - what 2 pieces of criteria have been used?
a)
Gender (Male) Lives (Gotham City)
b)
Hair (Black) Gender (Male)
c)
Eyes (Blue) Lives (Gotham City)
d)
Eyes (Blue) Hair (Black)
115.
What would you expect the results of this query to show?
a)
All the superheroes with black eyes and blue hair
b)
All the female superheroes with black hair
c)
All the male superheroes with blue eyes
d)
All the superheroes with blue eyes and black hair
116.
What is the purpose of a database Report?
a)
Store records and fields
b)
To search a database for information
c)
Present data in a printable format
d)
To provide a more friendly way to input data
117.
Which option is an advantage of using a report to present information rather than a table?
a)
Can search for information
b)
Can be formatted to make it easier to read the information
c)
Can input new data easily
d)
Checks that data is correct
118.

Which of the following holds a single piece of data?

a)

Table

b)

Record

c)

Field

119.

Numeric data without decimals are known as

a)

integer

b)

real

c)

percent

d)

currency

120.

Data that uses money symbols

a)

integer

b)

real

c)

percent

d)

currency

121.

Data that uses %

a)

integer

b)

real

c)

percentage

d)

currency

122.

Type of database with TWO or more tables

a)

Playlist

b)

Excel File

c)

Flat File

d)

Relational

123.

Which of the following can be useful in a query?

a)

?

b)

/

c)

*

d)

~