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