WorksheetsICT 2 level
Total questions: 99
Worksheet time: 1hrs 14mins
The term informatigue (informatics) is formed by merging the words ... and ... .
Information
Automatigue
Accounting
Informational
Auto
Choose information processes.
To collect
To store
To process
To manage
To control
The acronym ICT is used to denote a new concept which is a combination of two concepts:
Information technology
Communication technology
Computer technology
Information processing
Computing machine
Choose output devices.
Speaker
Plotter
Keyboard
Mouse
Scanner
Choose peripheral devices.
Speaker
Microphone
Scanner
Keyboard
System unit
A CPU clock rate is measured in:
GHz
Hz
1/sec
Inch
dpi
These keys are used to type capital letters:
Caps Lock
Shift
Space Bar
Windows
ESC
Choose types of printers.
Laser
Dot-matrix
Ink-jet
Sheet-fed
Mechanical
Choose display types.
LCD
CRT
LED
Mechanical
Lapel
A CPU consists of these parts:arc
Register
ALU
Control unit
HDD
ROM
Small programs used to reduce a file size:
WinZip
7-Zip
WinRAR
Unix
Dr.Web
A central circuit board.
Motherboard
Mainboard
Fan
Processor
Heat sink
The speed of a CPU is determined by these factors:
Clock rate
Cache memory amount
Core number
Speed of ROM
Amount of RAM
Charts which display information as a series of data points called «markers» connected by straight line segments.
Line chart
Area chart
Pie chart
Radar chart
Column chart
Page orientations used in Ms Word:
Portrait
Landscape
Hyphenation
Margin
Watermark
Choose tabs, which are not used in MS Excel.
Animation
Slide show
Formulas
Insert
Home
Choose data types used in MS Access.
Memo
OLE
Integer
Scientific
Percentage
Choose examples of utility programs.
File management programs
Uninstall programs
File compression programs
Application software
Driver
Operating systems developed by Microsoft:
Windows
MS-DOS
Mac
iOS
Unix
In Ms Access tables are related on the base of these keys:
Foreign
Primary
Secondary
Compulsory
Mandatory
Choose audio file extensions.
.wav
.mp3
.mp4
doc
.avi
Cell references used in Ms Excel:
Absolute
Relative
Mixed
Direct
Private
Line spacing types used in Ms Word:
Single
1.5 lines
Underline
Double
Italic
Interface styles:
GUІ
ООI
WUІ
TGI
GUІ
HCI comprises three major parts within the framework…
interaction
human
interface
computer
machine
The graphical interface allows human-computer interaction in the form of a dialogue using…
windows
menus and elements
diagrams
graphics
tables
Researchers in the field of HCI both
observe the ways in which humans interact with computers
design technologies that let humans interact with computers in novel ways
Only programming technologies that let humans interact with computers in novel ways
observe the ways in which humans interact with hardware
observe the ways in which humans interact with software
Human–computer interaction is a field of study that deals with:
Any communication
Users
Technology
Only hardware
All Information about a computer
Classical database models are:
Network model
Hierarchical model
Relational model
Star model
Double model
Hierarchical database modeling:
Each record has a single parent
structure arranges the various data elements in a hierarchy
data is organized into an inverted tree-like structure
Each unit in the model is a report which is also known as a node
Each record in the database can have multiple parents
Database models are defined by three components:
the set of admissible operations
integrity constraints
an acceptable data organization
the value of the data elements
some set of features
The terminological basis for the hierarchical and network models are concepts:
aggregate
attribute
record
fields
tables
The concept of a network data model is associated with the name of…
Niels Bohr
S. Lebedev
C. Bachmann
V.N.Sukachev
E.F.Codd
As defining characteristics for large data, "three V" is traditionally distinguished:
voice
volume
variety
velocity
vibe
vulture
Data mining methods are based on various methods of:
modeling
forecasting
classification
clustering
programming
Which company created MapReduce technology?
Apple
Oracle
Yahoo
EMC
Name the factors that led to the emergence and development of Data Mining:
Improvement of data storage and recording technologies
Hardware and software development
Accumulation of a large amount of retrospective data
Factors of evolution
Heredity, variability and natural selection
In what year was the term Big Data first introduced?
2008
1999
2006
2018
2001
Examples of end network devices include:
security cameras
computers, laptops, file servers, web servers
network printers
repeater
router
What is a hub?
It’s the central controlling device
this device typically provides from 4 to 24 connections
a device used to extend a network so that additional workstations can be attached
a PC or a workstation on a network using services provided from the network file server
a device used to reduce a network so that additional workstations cannot be attached
Specify main features of network bridges?
do send broadcasts to all ports except the one on which the broadcast was received
do not promiscuously copy traffic to all ports
connects multiple network segments at the data link layer (layer 2) of the OSI model
a device used to reduce a network so that additional workstations cannot be attached
a PC or a workstation on a network using services provided from the network file server
Computer networks can be classified by considering following different aspects as the basis
the functional relationship (Network Architectures)
the scale
the connection method
the generations of computers
the usage technologies
Network topology
ring
bus
star
square
single
An intermediary devices include:
Firewalls
Switches and wireless access points
Routers and modems
Microphone
File servers, web servers
Every node has a unique network address which is called
a Data Link Collect (DLC)
a Data Lost Control (DLC) address
a Data Link Control (DLC) address
Media Access Collect (MAC) address
Media Access Control (MAC) address
In the network client is
a computer which is capable of receiving the information from the server in the Internet
a device or application that uses the services provided by a server
a more advanced processor, more memory, a larger cache, and more disk storage than a single-user workstation
a device or application that uses the services provided by a client
any computer that makes access to files, printing, communications, and other services available to users of the network
Server in the network
a more advanced processor, more memory, a larger cache, and more disk storage than a single-user workstation
any computer that makes access to files, printing, communications, and other services available to users of the network
a PC or a workstation on a network using services provided from the network administrator
a device or application that uses the services provided by a OSI model
a device or application that uses the services provided by a browser
What is a router?
A networking device that forwards packets between networks using information in protocol headers and forwarding tables to determine the best for each packet
Routers work at the Network Layer of the OSI model and the Internet Layer of TCP/IP
A device or application that uses the services provided by a server
A PC or a workstation on a network using services provided from the network file server
A device used to reduce a network so that additional workstations can not be attached
Three primary principles of Information security
Accessibility
Reliability
Confidentiality
Integrity
Availability
Possible attacks that may arise with your computer if not proper security measures taken
Record keystrokes and steal passwords
Harvest and sell email addresses and passwords
Send spam and phishing emails
Automate series of operations
Works properly and fast
The following steps can be followed to prevent being attacked your computer
Keep your passwords secret
Use good, cryptic passwords
Do not click on unknown links or attachments
Click on unknown links or attachments
Update OS
What is a computer virus?
A program just simply destroys the files system of computer making it completely unusable
A program that damages important files such as documents beyond recovery
A harmful computer program developed by a person that disrupts operations of a computer in various ways
A program just simply corrects the files system of computer making it completely usable
A program that do not damage important files such as documents beyond recovery
What do you know about worms (computer virus)?
Do not require user actions to spread, they move from system to system over networks on their own
Can do nasty actions such as creating unnecessary files inside system folders
Steal information from user’s computers and upload to web sites
Do not steal information from user’s computers and upload to web sites
A program just simply corrects the files system of computer making it completely usable
Examples of macro viruses
Relax
Bablas
Melissa.A
Mapson
Trile.C
Trojan horse
Any malicious software that disguises itself in order to deceive users of its true intent
It can take the form of just about anything: an innocuous download link, an email attachment sent from a work colleague or an image sent via social media.
They account for about 8 in 10 of all new malware infections
They disrupt for about 8 in 10 of all new malware infections
They save for about 8 in 10 of all new malware infections
Hackers may use your computer …
They modify for about 8 in 10 of all new malware infections
host Web site
to send spam or viruses
do other activities that cause computer malfunctions
They disrupt for about 8 in 10 of all new malware infections
Cyber security is aimed … , or others, …
to send spam or viruses
from accessing, harming, disrupting or modifying IT systems and applications
malicious insiders
at preventing cybercriminals
comprehend for about 8 in 10 of all new malware infections
The Internet Protocol is one of the main protocols used at the network layer, along with several other protocols for …
encryption
routing
testing
disruption
doing other activities that cause computer malfunctions
WWW is the software which is used ... and it consists of …, which are stored in different computers.
files, folders
the documents
to access the information from the Internet
to read the information from the Internet
to save the information from the Internet
HTML
allows the documents author to embed hyperlinks
stands for Hyper Text Markup Language
describes the structure of a Web page
stands for Hyper Text Market Language
allows the user of a computer to embed hyperlinks.
Common Internet file extensions include
Ppts, docxt, xlcs
Cgi, xml
Jpg, gif
Html or htm, php, asp
Obj, bmp
Search engine system is … which is programmed … and… .
give the websites and Internet based documents as a result
an automated web-site
to search specified keywords
give the web addresses and list of files as a result
Non-automated web-site
HTTPS …
stands for “Hyper Text Transfer Protocol Secure”
cannot be accessed by unauthorized people
Secure means that the data transferred electronically is encrypted
stands for “Hyper Text Transfer Protocol Safety”
Secure means that the data transferred electronically is descripted
CSS … and may be used to change …, …
size and color
the type of font
stands for Cascading Style Sheet
Location of all resources
Address of the website
Email servers …, … , and … messages
store
deliver
accept, forward
provide, backup
duplicate
The POP3
Stands for Post Office Protocol3
have mail accounts (our email IDs).
The number ‘3’ is the version number of the protocol in use
The number ‘3’ is the order number of the protocol in use
Stands for Pre Office Protocol3
An email client is … used to … and … a user's email
access
a computer program
manage
receive
An information technology
Which of them are included to the core components of a data Centre?
Computing resources
Storage infrastructure
Network infrastructure
Database of organization
The server of organization
Cloud computing is the delivery of computing services such as …,…, … , and more over the Internet
databases, networking
software, analytics
servers, storage
The server of organization
Resources of organization
What you can do with the cloud?
Host websites and blogs
Store, back up and recover data
Create new apps and services
Create a new computer
Store, back up and recover data only on your computer’s HDD
A few of the things you can do with the cloud:
Remove resources from the server of organization’s library
Analyse data for patterns and make predictions
Stream audio and video
Deliver software on demand
Read information on illegal sites
Types of cloud services:
Infrastructure as a service
Platform as a service
Spam as a service
Software as a service
Processor as a service
Types of cloud deployments:
public
hybrid
private
common
individual
What terms are related to the virtualization?
Software that separates physical infrastructures to develop different dedicated resources
Software of them makes it possible to run multiple operating systems and multiple applications on the same server at the same time
It is the fundamental technology that powers cloud computing
Hardware that separates physical infrastructures to develop different dedicated resources
It is the fundamental technology that helps to the library programs in your organization
With a public cloud, …, … and … is owned and managed by the cloud provider
other supporting infrastructure
software
all hardware
All Input devices
The Central Processing Unit
Advantages of Software as a service
Pay only for what you use
Use free client software
Access app data from anywhere
Access app data from organization’s computer
Pay all for what you do not use
Advantages of Infrastructure as a service
Increase stability, reliability and supportability
Gets new apps to users faster
Better security
Increase non-stability, non-reliability and non-supportability
Gets new apps to users slower
The most famous image editors are
Adobe Illustrator
Adobe PhotoShop
Corel DRAW
MS Publisher
DEV C++
Publishing systems
Combine the possibilities of text and graphic editors
For formatting strips with graphic materials and then printed
Targeted for use in publishing and typesetting systems
Manage and control budgets to ensure maximum value for money
Provide information to aid effective panel review of requests
The Basic Elements of Multimedia
Text
Audio
Graphics, Animation, Video
Social nets
Networks
Audio is …
speech
other sound
music
sequence
picture
Graphics are digital representations of non-text information such as …
drawings
charts
pictures
sounds
sentence
The popular file compressions
WinRAR
WinZIP
7ZIP
Windows Explorer
Avast
Compression formats that used for reduce the file size of images:
GIF
TIFF
GPEG
MP4
XLS
Text was originally defined by printed media such as …
books
podcasts
newspapers
films
images
Which of the following is NOT a video file extension?
PPT
JPG
MP4
AVI
To build multimedia application we require
Hardware
Software
Printer
Talent and Skill
Browser
SMART as a diagnostic method is originally developed by … and introduced with the … specification
Intel
Compaq
IBM
ATA-3
Apple company
Big data is a term that describes the process of handling and analyzing evolving data that is in the … and … range.
Kilobyte
Exabyte
Gigabyte
Megabyte
Petabyte
Big Data is generally stored and organized …
In a server of the universities
in a distributed file system.
In a web browsers
In your own computer
in multiple (sometimes thousands) hard drives on standard computers.
Select e-commerce objects:
production products
Goods
individuals
securities
Currency
Select e-commerce subjects:
individuals
organization-entrepreneurs
Currency
consumers of goods and services
production products
Electronic learning includes:
E-marketing
E-books
E- auctions
E-commerce
Intelligent learning systems
Select Computer-aided design systems:
ZwCAD
NanoCAD
3D Studio MAX
Adobe Audition
AutoCAD
Select video editors:
Corel Video Studio Pro
Windows Movie Marker
Adobe Audition
Sony Sound Forge
Adobe Premiere Pro
Select audio editors:
Sony Sound Forge
Adobe Audition
Autodesk 3ds MAX
Corel Video Studio Pro
Windows Movie Marker
Select the small and medium-sized businesses
Gym
Apple Company
Samsung Company
Hair Salon
Dentist
Choose features typical for medium and small businesses:
Employees: Over 1000 employees
Annual Revenue: $5-$10 million
IT Staff: Typically one or a few
IT Staff: Full time IT staff, including several specialists
Employees: 0-100
Choose features typical for large businesses:
Some capital expenditure
Annual Revenue: Over $1 billion
IT Staff: Full time IT staff, including several specialists
Annual Revenue: $5-$10 million
Employees: Over 1000 employees
