WorksheetsICT 8 Review 1
Total questions: 123
Worksheet time: 3hrs 6mins
What is this?
A cheese grater
An abacus
A game
An early camera
Who invented the Difference Engine?
Charles Blubber
Charles Babbage
Charles Baggage
Charles Blagger
Many early computers were big enough to fill a whole room and weighed thousands of pounds.
TRUE
FALSE
The first electronic computing machine was invented by _________ to compile data for the 1890 United States census.
Francis Holberton
Ada Byron
Herman Hollerith
Grace Hopper
Who is this icon of Computing?
Steve Jobs
Charles Babbage
Alan Turing
Grace Hopper
Bill Gates
Who is this icon of Computing?
Steve Jobs
Charles Babbage
Alan Turing
Grace Hopper
Bill Gates
Often credited with being the first ever computer programmer, Who is this?
Ada Lovelace
Taylor Swift
Margaret Thatcher
Eva Longoria
Carrie-Anne Matthews
Grace Hopper found a moth stuck in a relay responsible for a malfunction, and removed it, calling it _______.
Operating
Cleaning
Hacking
Debugging
Which one of these is NOT a Google product
What was the Colossus Computer used for
Defrosting frozen chickens
Decoding German secret messages
Preparing canapes for a party
Calculating the time
What does the 'PC' stand for?
Personal Computer
Private Computer
Posh Computer
Petite Computer
When was the ENIAC invented?
February 15, 1946
November 14, 1946
February 24, 1955
October 5, 2001
(a) is the physical appearance/characteristics of a computer system.
What system component is this?
RFID card
Motherboard
CPU
GPU
ENIAC
What does the 'e' in e-mail stand for?
Earlobe
Electronic
Electric
Elephant
The brain of the computer is:
Monitor
Central Processing Unit (CPU)
Mouse
External Hard Drive
a two-digit system of 0's and 1's that computers use to store and transfer information on computers is known as:
base 10 numbers
hexadecimals
decimal numbers
binary numbers
The slide rule assisted with _____________.
algrebra
multiplication and division
measuring things
square roots
The astrolabe was another mechanical calculating device used enabled sailors to calculate _____________.
their latitude at sea
their speed
their direction
the date
What was the first electronic general-purpose computer?
IBM PC
UNIVAC
Colossus
ENIAC
What 'special' feature could you do with Napier's Bones?
A computer has the ability to:
It has the ability to store, retrieve, and process data.
It has the ability to store, retrieve, and pastas data.
It has the ability to stage, retrieve, and process data.
What is a computer?
A computer is case that manipulates information or data.
A computer is an electronic device that manipulates information or data.
A computer is powered box that manipulates information or data.
Identify the picture
Random Access Memory
Read Only Memory
USB Flash Drive
Memory Card
Identify the picture
Random Access Memory
Read Only Memory
USB Flash Drive
Hard Disk Drive
Identify the picture
Random Access Memory
Read Only Memory
USB Flash Drive
Memory Card
Which of these terms best describes the average computer buyer in the 1960s?
Small business
Large institution (colleges, big business, government)
Elementary schools
Train enthusiast
Charles Babbage designed the Difference Engine and the Analytical Engine. What were these?
Mechanical Computers
Thermometers
Rulers
If you wanted to enter data on a 19th century computer, you would do it with:
Disks
Gears
Cards
Tape
Which of the following word pairs best symbolizes the ones and zeroes in binary code?
Sight and sound
Yes and no
Red and blue
Want and need
Analytical engine was invented in
1933
1733
1833
1803
Choose the best answer for this image.
microprocessors
integrated circuits
transistors
artificial intelligence
Choose the best answer for this image.
integrated circuits
microprocessors
transistors
artificial intelligence
Choose the best answer for this image.
vacuum tubes
microprocessors
transistors
integrated circuits
Choose the best answer for this image.
integrated circuit
microprocessor
vacuum tube
transistor
A database is used to
Calculate figures
Store data in a logical order
Layout pages attractively
Present material using animations
A record is made up of
Fields
Primary Key
Foreign key
Currency
Rows in a database tables are called...
Fields
Tables
Records
Forms
Which of the following would be used to uniquely identify a record
Field size
Validation
Data type
Primary Key
Columns in a database are called...
Rows
Tables
Fields
Forms
Everything on one row is a record.
True
False
Each item from this list is classified as...
Name, Birthdate, Street, County , PostCode
Form
Table
Record
Field
Which of the following is an example of a record?
5
5, Thorpe, Steven, 12/17/1982, 25
25
2, 1, 8, 9, 3, 6, 4, 5, 7
Which of the following is an example of a field?
5
Birth Date
Thorpe
25
The best data type to choose for a postal code would be:
Percentage
Date/Time
Text
Currency
The best data type to choose for date of birth would be:
Text
Number
Currency
Date/Time
To find a particular set of data in a database you would use a:
Table
Form
Query
Report
What do we use to connect tables in a relational database:
Foreign Key
Query
Fields
Table
A data type used for storing numbers with a fractional/decimal part e.g. 3.142
Integer
Boolean
Real
String
A sports club needs to store information about each member. All the information about the members can be entered as a:
Field
File
Table
Record
Data
File
Record
Table
The school wants to sort the data by staff Surname from A to Z. How will they sort it?
Ascending order
Descending order
Which of these examples uses a database?
Select 3.
Phone contacts
I-Tunes
Hospital records
Word Processor
MS Paint
Text, Number and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
A method of only displaying records in a table that match specific criteria...
Search/Filter
Validation
Sort
Verification
A collection of fields and records in a specific category
Record
Table
Field
Spreadsheet
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
What is the main purpose of sorting/searching data?
Makes it nicer to look at
Makes it easier to input new data
Helps to find specific information quickly
Gives me something to do when I'm bored
if you wanted to show only people who are older than 10, what would the search criteria for age be?
=10
<10
=>10
>10
What can be a description of a query?
A Table
A Question
A Spreadsheet
A Report
Ted is creating a database for several customers. He needs to use USD and Pounds. What is the data type for these?
Date/Time
Text
Number
Currency
Your boss has required all products from highest price to lowest. How would this information be retrieved?
Sort Ascending
Sort Descending
Filter
Find
Which of the following is NOT true of databases?
You can store large amounts of data.
You have to use a computer.
You can search the data.
Which of the following can be an advantage of paper-based databases?
It is easy to add or amend records.
You do not need any training on how to use the database.
Data can be sorted and re-sorted easily.
Thinking of data, information and knowledge - which of the following is an example of information?
The average men's shoe size is nine.
9
If you are to open a shoe shop, you must stock plenty of size nine shoes.
Which of the following holds a single piece of data?
Table
Record
Field
Which field would be inappropriate in a database of countries?
Continent
Population
First Name
What is the correct definition of primary key?
The first field in a table.
A field that contains unique data in each record.
The field which we will use to search with.
What criteria has been applied in this table?
Gender - Male
Eyes - Blue
Name - Descending Order
Height - Ascending Order
Identify the 2 criteria filters that has been applied in this table.
Eyes (Blue) & Real Name (Sort Ascending)
Weight (Sort Descending) & Gender (Male)
Superhero (Sort Descending) & Lives (Gotham City)
Gender (Male) & Superhero (Sort Ascending)
Which of the following holds a single piece of data?
Table
Record
Field
Numeric data without decimals are known as
integer
real
percent
currency
Data that uses money symbols
integer
real
percent
currency
Data that uses %
integer
real
percentage
currency
Type of database with TWO or more tables
Playlist
Excel File
Flat File
Relational
Which of the following can be useful in a query?
?
/
*
~
