Font size
WorksheetsICT1
Total questions: 150
Worksheet time: 1hrs 15mins
What is the Computer science?
science of collecting, storing, processing and transmission of information through computers
the science of e-mail
way of learning about the world by means of signals and symbols, a man perceived by the senses
unit recording information on a floppy disk
is the study of general and fundamental problems concerning matters such as existence, knowledge, values, reason, mind, and language
… - a set of physical processes signals perceived by the subject through his sense organs
Computer
Protocol
Information
Data
Information processes
Data obtained by measuring, monitoring, logical or arithmetic operations presented in a form suitable for storage, transmission and processing
Information processes
Computer
Protocol
Information
Data
Under ….. is offered to understand the complex objects, actions, and rules relating to the preparation, processing and delivery of information at the personal, mass communication and production, as well as all technologies and sectors, providing integrated these processes.
Computer Science
Information processes
the information and communication technologies
Data
Information
Ergonomics- it
the science of the economically correct solutions.
the science of the psychological impact of computers on the person.
the science of designing the user interface.
science that studies the application scope of our mental characteristics.
science on the development of products that interact with us physically.
… is an extended term for information technology which stresses the role of unified communications and the integration of telecommunications (telephone lines and wireless signals), computers as well as necessary enterprise software, middleware, storage, and audio-visual systems, which enable users to access, store, transmit, and manipulate information.
Network technology
Digital technology
Multimedia technology
Information and communications technology
Cloud technology
The term is … used to refer to the convergence of audio-visual and telephone networks with computer networks\through a single cabling or link system.
LAN
WAN
Cloud
ICT
Multimedia
What is multimedia?
Integration of still and moving images, text, and sounds by means of computer technology
Images and audio
Programs that combine text and images on a television screen
A video game
Moving images and text
.............used for the formation of an ideology in the field of information and modern information culture, i.e. the ability to interact with information, professional use for receiving, processing, transmitting and storing it.
Idea of “ICT”
Discipline “ICT”
Purpose of “ICT”
Mission of “ICT”
Ideology of “ICT”
Which of the following in not a pointing device?
mouse
joystick
monitor
keyboard
trackball
................offer services pertaining to processing transactions, documentation, presentations, inventory management and gathering product information
Е- Subject
e-service
e-document
e-business
e-commerce
Communication
are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.
is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.
is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.
Technology
are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.
is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.
is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.
Information
refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.
is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.
is an act of transmitting messages. It is a process whereby information is exchanged between individuals using symbols, signs or verbal interactions. Communication is important in order to gain knowledge.
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
are critical to the interoperability of ICTs and whether we exchange voice, video or data messages, standards enable global communications by ensuring that countries’ ICT networks and devices are speaking the same language.
Тhe European standardization organizations: ETSI-
the science of designing the user interface
the science of the psychological impact of computers on the person
the European Committee for Standardization
the European Committee for Electrotechnical Standardization
the European Telecommunications Standards Institute
Тhe European standardization organizations: CEN –
the science of the psychological impact of computers on the person
the European Telecommunications Standards Institute
the European Committee for Standardization
the European Committee for Electrotechnical Standardization
Sustainable Development Goals
Тhe European standardization organizations: Standardization-
the science of the psychological impact of computers on the person
Sustainable Development Goals
the European Telecommunications Standards Institute
the European Committee for Electrotechnical Standardization
the European Committee for Standardization
ICT development
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
includes many types of infrastructure and services, ranging from telecommunications, such as voice, data, and media services, to specific applications, such as banking, education, or health, to the implementation of electronic government (e-government).
is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.
refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
ICT standardization
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
includes many types of infrastructure and services, ranging from telecommunications, such as voice, data, and media services, to specific applications, such as banking, education, or health, to the implementation of electronic government (e-government).
refers to the knowledge obtained from reading, investigation, study or research. The tools to transmit information are the telephone, television and radio. Information is knowledge and helps us to fulfill our daily tasks.
is the use of scientific knowledge, experience and resources to create processes products that fulfill human needs.
is the voluntary cooperation for the development of technical specifications that outlines the agreed properties for a particular product, service, or procedure.
Interface -…
a method for storing and organizing computer files and the data they contain to make it easy to find and access them.
a method for storing and organizing computer files and the data they contain to make it easy to find and access them.
the physical components of a computer system
network internal to an organization that uses Internet protocols
the hardware or software that connects two systems and allows them to communicate with each other
What did Ch. Babbage invent in 1812?
IBM PC
the first calculating machine
Xerox
the driver
Windows
Father of the computer -
Ada Lovelace
Charles Babbage
Konrad Zuse
Frederick P. Brooks
Mohammad Usman Khan
ALU-
arithmetic unit
arithmetic logic unprocess
arithmetic logic unit
arithmetic low unit
algebra logic unit
Static RAM is used as:
arithmetic unit
Flash memory
Video Memory
Cache
Memory in hard drives
… is a computer program that you use for writing letters, reports, documents, or the software that is used for this purpose
A word processor
Databases
Graphics
Laptop
It is a portable computer weighing about 2-4 kg.
PC
mainframe
mobile
laptop
supercomputer
Computer architecture is:
technical description of the details of the devices;
a description of the device and the principles of operation of the computer, sufficient to understand the user.
a description of the computer's software;
a description of the devices for input and output of information;
technical description of the details of the computer devices;
A computer is:
a universal device for recording
a universal device for transmitting and receiving information.
an electronic device for processing information;
a universal, electronic device for storing, processing and transmitting information;
a universal device for recording and reading information;
Hardware is:
a universal device for recording
a universal device for transmitting and receiving information.
a system for the creation of new programmes
computer hardware
the most popular system for IBM PC computers
Software is:
computer software
only programs to connect new devices to the computer
support program
a system for the creation of new programmes
the most popular system for IBM PC computers
The speed of information processing in the computer depends on:
RAD
hard drive
RAM
clock speed
ROM
Specify the unit of measurement of memory capacity:
test
tact
GHz
beat
KB
Peripherals are designed for:
exchange of information between the computer and the user
performing arithmetic-logical operations
information between the computer and the user
computer design improvements
design improvements
The refresh rate of a monitor is measured in
KB
seconds
design
GHz
volts
The resolution of the monitor is:
exchange of information between the computer and the user
number of pixels horizontally
number of pixels vertically and horizontally
information between the computer and the user
computer design improvements
What function do peripherals perform?
information between the computer and the user
information processing
storage of information
input-output of information
number of pixels horizontally
The chipset on the motherboard is:
Combination of system bus and RAM
The totality of all ports and connectors on the motherboard
The totality of all devices located on the motherboard
The totality of al connectors on the motherboard
A set of chips of the north and south bridge
What is not a characteristic of RAM?
type
Timings
Cost
Throughput
Memory type
The North Bridge on the motherboard supports:
System bus, RAM, video card
Keyboards, mice, printers, scanners
Sound card and modem
Hard drives and optical drives
printers, scanners
Common types of CPU sockets
PJA
TCP, ICMP
UDP, NS
PGA, LGA
PAG, LAG
A graphical user interface operating system front-end to MSDOS developed by the Microsoft Corporation
Paint
Word
Windows
Mac OS X
Lunix
A clone of the Unix operating system created by Linus Torvalds for use on personal computers -
Memory
Linux
Mac OS X
Macromedia
Windows
File system-…
network internal to an organization that uses Internet protocols
the hardware or software that connects two systems and allows them to communicate with each other
a type of user interface which allows people to interact with a computer and computer-controlled devices which employ graphical icons, visual indicators or special graphical elements called "widgets", along with text
the physical components of a computer system
a method for storing and organizing computer files and the data they contain to make it easy to find and access them.
A systems program that controls a peripheral device
Expert system
Embedded software
Driver
Duplex
Eiffel
Pick out the right definition: Operating system
a piece of hardware
a table of contents for the disk
a disk drive
a complex of the system and control programs intended for the most effective using of all resources of the computing system and convenience of work with it.
is a disk copy command
Pick out the right definition: Programme
instructions written in computer language
devices to perform commands
a place where information is stored
error message
device name
Android is a mobile operating system developed by …
Apple
Windows
Microsoft
Nokia
Simbian is a mobile operating system developed by …
Microsoft
Windows
Apple
Nokia
iOs (originally iPhone OS) is a mobile operating system created and developed by …
Nokia
Microsoft
Windows
Apple Inc
Android is a mobile operating system developed by Google, based on the …(?) kernel and designed primarily for touch screen mobile devices such as smartphones and tablets.
Microsoft
Windows
Linux
iOS
Yandex
An …(?).. is system software that control computer hardware and software resources and provides common services for computer programs.
Microsoft
operating system (OS)
Internet Explorer
Windows hardware
Yandex
A single-tasking operating system can only run (?) program at a time
Many
4
One
Two
3
OS (abbreviation)
un system
operating system
open system
offen system
old system
If you or your computer makes a mistake when using a device or MS-DOS command, MS-DOS displays an appropriate….
device errors
Result
error message
diskcopy.exe
Device names
Microsoft Windows (or simply Windows) is a system software that makes your ….(or compatible) easy to use
PC
device errors
Result
diskcopy.exe
Device names
What is the file?
a named collection of data on disk
Several programs
fragment of a text document
segment of the program, which stores some value
hard disk
In OS Windows «clipboard» is ...
The special area of memory for temporary storage of information when moving objects
Windows applications Word
Land of memory on your hard drive
Writes the selected piece in a file
Part of the memory where the operating system
The types of operating systems:
Data creating
Natural Language
Time sharing
Graphical
Real time
An open source operating system is used primarily for handheld devices:
Android
Windows 10
iOS
Mac OS
Windows 7
To access the services of the operating system, the interface is provided by the
Assembly instructions
API
CPU
System calls
Library
Human Computer Interaction is a multidisciplinary field of study focusing on the design of computer technology and in particular, the interaction between humans (the users) and _________________________________.
Machine
Computer
ICT
Application
Engine
Interaction between ______________________________ occurs at the user interface which includes both software and hardware.
usable and safe systems
user and computers
robot
easy to remember how to use
people and machine
The goals of HCI is to produce ______________________________, as well as functional systems.
usable and safe systems
easy to remember how to use
put people first
usable and safety systems
enjoyable to use
HCI should always consider about what ____________________________, what physical abilities and limitations they may have, how their perceptual systems work, and what they find attractive and enjoyable when they use computers.
usable and safe systems
achieve efficient and safe interaction
put people first
user interaction
users aspect and needs
"During this time, HCI was mainly focused on creating systems that were easy-to-learn and easy-to-use. There were endless possibilities for personal computing, but desktop computers were not very usable tools at first. "The description above best described the waves from _____________________.
Wave 3: Self-expression, social change (mid 2000s — 2010s)
Wave 4: Millennium era (end of 2010s — 2050s)
Wave 2: Collaboration & communication (1990s — early 1995s)
Wave 2: Collaboration (1995s — early 2000s)
Wave 1 : Desktops and mental models (1980s - 1990s)
Human-computer interaction (HCI) is a relatively new science that includes study, planning and development of interaction between:
people and animals
people and computers
people and robots
humanoids and robots
robots and computers
The main objective of the human-computer interaction (HCI) is:
to communicate with other people
to create super-intelligent robots
to understand the user, his motivation and the problem he is solving
to study the anatomy of animals
to conduct contact with aliens
A user interface in which a person interacts with digital information through the physical environment-
Brain Computer Interface (BCI)
Natural User Interface (NUI)
Voice User Interface (VUI)
Tangible user interface (TUI)
Command Line Interface (CLI)
Two basic categories of network topologies exist, physical topologies and
mesh topology
logical topologies
logical ring topology
network topology
a physical star
A computer is a
output device
technical device for storing information
technical device for transmitting information
input device
universal technical device for working with information
What is a command-line interface?
Is a means of interacting with a computer program where the user issues commands to the program in the form of successive lines of text
should be able to combine the concepts of both the GUI
is a user interface that is effectively invisible, and remains invisible as the user continuously learns increasingly complex interactions
is a perception driven user interface that is currently still being explored
typically text to speech to play a reply
Principles of user interface development
software product design
reducing user memory usage
objects
server
Testing for usability of container
A type of user interface that features on-screen objects, such as menus and icons, manipulated by a mouse
Basic Input Output System (BIOS)
Natural Language Interface (NLI)
Menu Driven Interface (MDI)
Graphical User Interface (GUI)
Command Line Interface (CLI)
A key aspect for using the interface
Abailability
Compatibility
Availability
Efficiency
Profitability
Type of attacks which begins with mailing the e-mails containing reference to the known resource (or imitating such link)
Scam
Spyware
Phishing
SQL-Injection
Social engineering
The file is
a software package for a specific task
An application program that allows you to work with text
Named data recorded on a data carrier
A necessary piece of software, without which a computer cannot work
Recording information in computer memory
_______ factual information(as measurements or statistics) used as a basis for reasoning, discussion, or calculation.
Data mining
Data visualization
Information
Bit
Data management
The main function of the computer:
HCI
Task development
Human and machine communication
Program Application
Principle of program management
The main element that organize data is:
server
mining
objects
system
administrator
Where and when the first LTE standard network was put into commercial operation?
Sweden, 2009
USA, 2008
France, 2009
Japan, 2012
Denmark, 2012
A relational database consists of a collection of
Road
Column
Tables
Row
Values
A……is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes ,and primary keys and foreign keys
Relational database
Shema flow
Database diagram
schema diagram
Relational algebra
A……is a property of the entire relation, rather than of the individual tuples in which each tuple is unique
Fields
Attribute
Key
Keyword
Rows
Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
NAME, CITY
ID
CITY, ID
CITY
NAME
Database which Is the logical design of the database, and the database-which is a snapshot of the data in the database at a given instant in time:
Fields
Shema, Instance
Tables
Records
Keys
What is a collection of data or information called, that is stored in a logical and structured way?
Spreadsheet
Column
Field
Database
Story
One piece of information stored about a thing or person is called a
Field
Spreadsheet
Story
Database
Column
In a Database, what is Data or Information stored in?
Filing cabinet
Garage
Storeroom
Online Server
Table
In a Database, a RECORD is...?
is the single piece of information about a person or item
is the name of the vinyl disk to store music recordings
is the single identification label given to a person or item
is all of the data about one person or item
is the diagonal line of data made up from a number of random fields
A collection of related files is called a
table
character
adjusting
field
database
A person’s First name, Last name, Date of Birth (DOB), Height, Eye colour and Address are all types of what?
Fields
Tags
Tables
Files
Records
What should a database always contain?
Tags
Tables
Files
Field
Records
Where is data stored?
Fields
Tags
Table
Files
Records
What is a database in which ALL the data is stored in a single table known as?
Records
Functional
Relational database
Hierarchical database
Network
What is a data capture form specifically designed to collect?
Files
Tags
Data
Records
Tables
What is a database accessible by many users on different computers known as?
relational database management system (RDBMS)
object-oriented database management system (OODBMS)
end-user database
a multi-access database
in-memory database (IMDB)
A type of software program used to create, maintain, and access databases.
object-oriented database management system (OODBMS
database management system (DBMS)
A multi-access database.
in-memory database (IMDB)
relational database management system (RDBMS)
In a database a field
Column
Tables
Files
Records
Tags
A single category of data to be stored in a database, such as customer names or employee telephone numbers. Also called a column
Tags
Data
Records
Tables
Field
In a database, a record.
Field
Row
Data
Tables
Records
Data mining is an interdisciplinary subfield of …
statistical graphics
infographics
computer science
mathematic
data visualization
Is a graph that uses a branching method to illustrate every possible outcome of a decision
data analytics
data mining
user interface
decision tree
black box
Data mining methods establishing relationships among items that occur together:
Visualization
Clustering
Forecasting
Classification
Association
Data Visualization is connected with the visualization of …
PC
mathematical and scientific research
tablets
users
information, infographics, scientific visualization, exploratory data analysis and statistical graphics.
Data mining is an interdisciplinary subfield of …
mathematic
computer science
statistical graphics
infographics
data visualization
Which type of modelling are decision trees?
Spam e-mail filtering
Financial fraud detection
Descriptive modelling
Prescriptive modelling
Predictive modelling
Analyzing data to discover patterns and relationships that are important to decision making
Invest manager
Database
Operating system
Data mining
BitTorrent
A numerical representation of a realistic situation, such as a cash flow model of a business, a question or set of instructions that describes the data
Decision model
Data mining
Data analyses
Operating system
Database
Big data technology has some advantage than relational data base systems
Operates with binary digits
Operates just with structured data
Operates just with unstructured data
Operates with structured data
Operates with decimal digits
Methods and analysis techniques applicable to big data, allocated at McKinsey report
Logical class
Operating system
Binary class
Procedure class
Class Methods Data Mining
Data mining technology has some methods
Business to business approach
Middle term equation
Atanasov profit model
Regression trees, factor analysis
Microeconomic view
Input device:
screen system
notebook
printer
keyboard
monitor
Data Mining models that allows you to predict data values by using known results from a different data sample:
descriptive models
predictive models
physical models
statistical models
intelligent models
Data mining is:
a process of automatically converting weakly structured data and obtaining an array of data of optimal structure
a process of analyzing numerical data about economic systems
a process of performing automated extraction and generating predictive information from large data banks
a process of automatic extraction of textual information from large data banks
a process of automatic extraction of numerical information from large data banks
Correct record of the cells' unit in MS Excel:
LN1-AE5
A1:C5
H5xA13
ll:8L
A3:CE
How cell coordinates in MS Excel are called?
Number
Digit
Cell
Letter
Address
MS Excel. The cell which located on intersection 3 lines and 1 column is designated:
B1
A3
AA
C1
3A
What is a workbook?
file in MS Outlook
file in MS PowerPoint
file in MS Word
file in MS Access
file in MS Excel
What is the expansion in the file name for MS Excel?
*. xls
object for automation of frequently performed
*. bmp
*. com
*. exe
What are the shortcut keys for AutoSum?
ALT + +
CTRL + S
CTRL + =
ALT + =
ALT + S
In order to get a registration certificate you need to install some software.
NSLayer program
ESLayer program
EDSLayer program
HardDiscDriveLayer program
NCALayer program
An e-mail address consists these components
The numbers of a cell phone that handles e-mail accounts
User home address followed by an any symbol
The name of a region that handles e-mail accounts
The name of a computer that handles e-mail accounts
User Auto increment followed by an @ symbol
A collection of computers and related devices connected in a way that allows them to share data, hardware, and software:
Students network
Touch Screen network
System board network
Computer network
NVidia network
A set of rules that ensures the orderly and accurate transmission and reception of data
Communications protocol
System board network
Transmission of information
Control of transmission
Accurate transmission
A popular network technology in which network nodes are connected by coaxial cable or twisted-pair wire
Star-ring
Token Ring
Domain
Ethernet
Ring
What type of network is this?
Tree
Ring
Mesh
Star
Bus
A computer that stores and distributes files to remote client computers
ATM server
PCI server
FDDI server
IP server
FTP server
The Internet provider is:
set of rules which helps to get information from another address
a peripheral device that is used to communicate with another computer
the organization provider of Internet services
a local administration
an organization engaged in the creation of web-sites
E-mail messages have a standard format that consists of
e-mail account
message header
e-mail system
e-mail message
e-mail server
A term sometimes used to refer to the interconnection of personal digital devices or consumer electronics within a range of about 30 feet (10 meters) and without the use of wires or cables:
LAN (local area network)
PAN (personal area network)
GAN (great area network)
MAN (middle area network)
SAN (storage all area network)
A data communications network that connects personal computers within a very limited geographical area—usually a single building. Its use a variety of wired and wireless technologies:
LAN (local area network)
GAN (great area network)
SAN (storage area network)
PAN (personal area network)
MAN (middle area network)
Public high-speed network capable of voice and data transmission within a range of about 50 miles (80 km). For example local Internet service providers, small cable television companies, and local telephone companies:
MAN (metropolitan area network)
SAN (storage area network)
PAN (personal area network)
MAN (middle area network)
LAN (local area network)
Type of networks covers a large geographical area and usually consists of several smaller networks, which might use different computer platforms and network technologies:
WAN (wide area network)
MAN (middle area network)
PAN (personal area network)
LAN (local area network)
MAN (metropolitan area network)
The number of bits made up the IP address:
24
16
20
32
10
Internet was originally developed as a(n):
Transportation project
Scientific project
Military project
Healthcare project
Educational project
Type of computing provides access to information, applications, communications, and storage over the internet:
Digital
Cloud
Internet
Network
Web
A dorm-room network covers a limited area and is an example of network.
limited
local
narrow
wide
personal
Each connection point on a network is referred to as a network
group
protocol
virus
node
computer
Set standards for encoding and decoding data, guiding data to its destination, and mitigating the effects of noise are communications:
protocols
nodes
laws
computers
regulations
A way to transfer files from one computer to another over any TCP/IP network, such as a LAN or the Internet provides:
Cloud computing
FTP (File Transfer Protocol)
VoIP
Grid computing
Real-time messaging
Is a modem a device?
for storing information and for printing information
to process information at a given time
for printing information
to transfer information via telephone communication channels
to store information
Formalized rules governing the sequence and format of messages exchanged between network components, OSI models lying at the same level, but in different nodes, are called:
By route
Standard
Interface
Protocol
Protocol stack
Global computer network means:
WAN
LAN
MAN
CAN
SAN
The server that controls client file access is called:
Provider
Server
File server
Post
Proxy
The main types of computer networks are networks:
Regional
Social, entertainment, business oriented
Local, global
Local, global, regional
Client, corporate, international
What components of a computer network are required to organize a peer-to-peer local area network?
Modem, server computer
Workstations
Communication lines, network card, network software
Network card, network software
Server computer, workstations
Which is the best description of WANs?
Local area networks located within a large building.
Connects local area networks located within a large building.
Combine workstations, terminals and other devices located within the building.
Combine workstations, terminals and other devices located within the city.
Used to connect LANs separated by significant geographic distances.
Choose the devices, which purpose is to expand the size of the network in the current environment:
Protocol
TCP/IP Model
Modem
Internet Protocol
Bridge
The purpose of digital signatures, which respect to security on the Internet:
To post anonymous messages to bulletin boards
To encrypt messages
To encrypt mail messages
To verify the identity of a messages sender
To request receipts for all sent messages
What type of network is this?
Bus
Tree
Ring
Star
Mesh
