Download IT techology answers exams and more Exams Information Technology in PDF only on Docsity!
№1 Information and communication technologies (ICT) are software and hardware tools that are integrated with the aim of collecting, processing, storing, distribution, display and use of information in the interests of its users wide range of digital technologies used to create, transfer and dissemination of information and services (computer hardware, software, telephone lines, cellular communications, e-mail, wireless and satellite technologies, network and wireless cable communications, multimedia, and the Internet)
2 ICT features. Point irrelevant variant Optimality 3 tools can be divided into the following types: Software, hardware 4 Three main organizations developing standards in the field of information technology ISO, IEC, ITU 5 Information is : Information about persons, objects, facts, events, phenomena and processes, regardless of the form of their presentation. 6 Information processed by the computer is encoded: only using ones and zeros;
7 The coding is: expression of data of one type through data of a different type.
8 The property of information characterizing the quality of information and determining the sufficiency of the data for decision making: Completeness
9 The property of information reflecting the true state of the object: Accurate 10 The quality of information that indicates the possibility of obtaining the necessary information: Accessibility 11 The information property that determines the correspondence of information to the current time: Relevance
12 The property of the relevance of information is ... Timeliness and importance of information
13 Information that is independent of personal opinion or judgment can be called: Objective
14 Operation with data, which is used to filter out unnecessary data that are not necessary for decision-making: Data collection
15 Operation with data that is used to order the data: Sorting the data
16 Information on the processing stage is divided into: Input, output, internal and external.
17 One byte is equal to: 8 bits. 18 According to the form of presentation, information can be divided into: Continuous (analog) and discrete.
19 Byte is: Information unit equal to 8 bits. 20 Number systems are positional and non-positional. 21 To represent numbers in hexadecimal notation used: 0 - 9 and letters A to F; 22 To represent numbers in octal number system uses digits 0 – 7 23 To represent numbers in the binary number system uses digits 0 – 1
24 To represent numbers in the decimal system use numbers 0 – 9
25 Number systems can be positional and non-positional. 26 Convert decimal number 9 to binary system: 1001;
27 Convert a binary number 1011 in decimal notation? 11; 28 Calculate 1011 + 1000 in binary system 10011; 29 Calculate 10111 - 10101in binary system 10; 30 Convert decimal number 25 to octal number system: 31; 31 Convert decimal number160 to hexadecimal number system: А0; 32 Convert number 10 from decimal system to binary number system: 1010;
33 Convert decimal number 64 to octal number system: 100;
34 Execute addition in the binary system 1011+ 11000;
35 Convert number 11 from the decimal system to binary system:; 1011; 36 Convert number 13 from the decimal system to binary system: 1101;
37 Convert binary number 1111 to decimal number system 15; 38 Execute addition in the binary system 1001+ 10101; 39 Convert decimal number 100 to octal number system 144;
40 Convert decimal number 101 to octal number system 145; № 1 A computer is: device for searching, collecting, storing, converting and using information in digital format .
2 A multimedia computer is called: computer capable of working with numbers, text, graphics, audio and video
3 An architecture is general principles of computer construction, realizing the programmatic control of the operation and interaction of its main functional nodes.
4 The minimum required set of devices for computer operation contains: system unit, monitor, keyboard.
5 The device providing protection of the computer at voltage drops and power outage: Uninterruptible Power Supply (UPS).
6 Computer devices that do not belong to the main computer are called: Peripheral
7 Which of the items is an input device? Keyboard
8 Video card is designed for: To create an image on the display screen.
9 The main element of the computer that executes programs and controls hardware is: processor;
10 The complex consisting of electronic circuits and providing information transfer inside the computer is called: System bus.
11 The main computer board, designed to mount all the main devices - the CPU and RAM modules, is called: Motherboard.
12 Device for visual representation of data: Monitor. 13 Random Access Memory of the computer is: a device that systematically addresses the machine during the execution of operations.
14 External memory is:. a device for storing programs, various data on the magnetic disks or magnetic tapes.
15 A Hard disk is a device for: storage of large amounts of data and programs used when working with a PC.
16 The bit width of the microprocessor is: the number of bits of information that it can accept and process in registers in one cycle.
17 The clock speed of the microprocessor is measured in: megahertz
18 The number of operations executed by the processor per second: the clock speed
19 The functions of the processor are: processing the data entered into the computer
20 The main parameters of the processor are: Operating voltage, operating clock frequency, bit width, the size of the cache
21 A scanner is a device for: read graphic and text information into the computer.
22 The coprocessor is designed to: help the main processor in performing mathematical operations.
23 One Terabyte (1 Tb) is equal to 1024 Gb 24 The mouse is a device used for:. facilitate entry of information into the computer.
25 Plotter is a device for: output of drawings on paper.
26 A printer is a device for: printing of text and graphic information. .
27 A special type of memory chip that holds software that can be read but not written to.
ROM
28 What is the name of the device responsible for performing arithmetic and logical operations and control operations written in the machine code? RAM.
29 The process of storing information in RAM is fundamentally different from the process of storing information on external media The fact that on external storage media, information can be stored after the computer's power is turned off; 30 Primary memory stores the programs currently running and the data being processed; .
31 Secondary memory and data for later use; .
32 Principle of addressing: the main memory structurally consists of numbered cells;
33 Processor bit width: is the number of bits simultaneously stored, processed or transferred to another device;
34 Arithmetic logic unit (ALU) is an integral part of ... microprocessor
35 Functions of the processor are ... processing of data entered into the computer 36 The first generation computers used ___ for circuitry. Vacuum tube 37 Computers of the second generation were based on transistors
38 Computers of the third generation were based on integrated circuits
39 The coprocessor is intended for: help the main processor in performing mathematical operations. 40 Number of operations performed by the processor per second: processor clock speed
41 Which of the following commands is given to reboot the computer? Ctrl + Alt + Del
42 A multimedia computer is ... computer capable of working with numbers, text, graphics, audio and video
43 What the operative memory is intended for? For temporary storage, reception and delivery of information.
44 Which of the following devices is located in the system unit? motherboard
45 What is formatting? Drive initialization (markup)
46 The type of device which data is recorded when it is made into a microchip and that can not be changed, and the programs running on the computer can only read these data is called: Constant-memory device.
47 The keys F1 - F12 are called:
42 Copying a file / directory in the NC program is done with a key...// +F5;// 43 MSDOS. The full file name consists of://
- Two words - name and type, separated by a "dot".// ".
44 MSDOS. The command issuing directory tree:// +TREE.//
45 MS DOS. Command file to be processed when MSDOS is loaded:// +Autoexec.bat// 46 Which driver is loaded first when loading MS-DOS // // +IO.SYS
47 What letters can the file name contain in the DOS operating system?// +1-8 characters, including Latin letters, numbers and special signs;//
48 File extension .exe means that the file://
49 Files containing text have an extension:// +txt, doc
50 MSDOS. Quick access to the root directory:// +Cd//
51 The command to set the DOS prompt:// +PATH//
52 Command for setting parameters:// +SET//
53 BIOS is://
- A permanent memory designed to store programs that provide a test mode
54 Which program in the DOS operating system performs the functions of an interpreter from the programming language to the language of the machine codes?// +COMMAND.COM
55 Earlier versions of MS-DOS and Windows use a file system:// +FAT16//
56 Norton Commander. The search command for the record (word, sentence) of the file being viewed or edited in the embedded NC editor is performed when you press the keys:// +F7//
57 Norton Commander. The command to write the contents of a file to an external storage device:// +Save//
58 If you need to copy all the files from one disk to another in Norton Commander, you must select a template...// +.//
59 The short form of the table of contents on the left panel of NC is displayed when you press the keys...// +F9 L B;// 60 The full form of the table of contents on the right panel of NC is displayed when you press the keys...// +F9 R F;// 61 The command MS DOS C: \ DOC \ STR.DOC indicates the path to://
- The STR.DOC file of the DOC subdirectory of the root directory
62 The EKG.txt file is located on drive C in the PHYSICS directory. Specify its full path:// +С:\ PHYSICS \ EKG.txt//
63 The operating system can be stored on: +1 and 3//
64 The file test.txt is located on drive D in the school directory, in the test subdirectory, its full path:// +d:\school\test\test.txt.//
65 MSDOS. The directory of the first level STUDENT of the current drive C can be deleted with the command:// +RD C:\STUDENT//
66 What is a desktop in Windows OS //
- the entire surface of the screen while the Windows shell is running // 67 The document is saved as //
- file //
68 Application in the Windows environment is called //
- the program is designed to work in this environment // 69 To select a standard or scientific mode of the calculator you have to click in the horizontal menu //
- View // 70 In the control of the Windows window, the system menu is not executed //
- rename //
71 Find the correct statement //
- OS are divided into single-task and multitasking // 72 The smallest addressable unit of the workspace on the disk?//
- cluster //
73 What are defects?//
- hard disk surface violation //
74 Working in the Windows environment, when you select several files arranged in random order, you must hold down the key:// +Ctrl// 75 Windows OS. When working in the Windows environment, the Paste command corresponds to a key combination:// +Ctrl+V//
76 Windows OS. You can Cut the selected item in Windows OS by pressing the keys:// +Ctrl+X//
77 Windows OS. You can Copy the selected item in Windows OS by pressing the keys:// +Ctrl+C// 78 Windows OS. You can Undo an action in Windows OS by pressing the keys:// +Ctrl+Z//
79 Windows OS. You can Delete the selected item without moving it to the Recycle Bin first in Windows OS by pressing the keys:// +Shift + Delete //
80 Windows OS. By double-clicking on the program name, you can://
81 Windows OS. Windows 7 Operating System is an upgrade from
+Window XP or Vista// Window 8
82 Windows OS. Programmes designed to make users more productive// +Application Software//
83 Windows OS. Instructions that control the allocation of computer hardware// +Operating system//
84 Windows OS. Help you manage folders and files stored in various location// +Library//
85 Windows 7 is an Operating System launched by Microsoft in// +2009//
86 Moving an item across the screen with the mouse// Recycle bin// +Drag//
87 The primary purpose of an operating system is:// +To make the most efficient use of the computer hardware// 88 Which is the first program run on a computer when the computer boots up?// +Operating system//
89 What programs relate to programs for working with multimedia data in Windows: 1) a laser player (CD Player), 2) a universal player (Media Player), 3) a volume control (Volume Control), 4) bitmaps (Bitmap) // +1,2,3//
90 Windows OS. The window in the minimized state is located:
91 By pressing the keyboard shortcut Ctrl + C, you can //
- copy, send a copy of the object to the clipboard //
92 By pressing the keyboard shortcut Ctrl + Х, you can // +cut, send the object to the clipboard
93 In order to specify an object with the mouse, you must do one of the following actions //
- Move the mouse pointer to establish its image on the desired object //
94 To use the mouse to open an object or start the program, you must perform one of the following actions //
- double-click and release the left mouse button twice on the desired object //
95 In order to move the object, select text and move the selected text with the mouse, you must perform one of the following actions //
- place the mouse pointer over the object, click the left mouse button and without releasing it, move the pointer to the desired location, then release //
96 What is the browser supplied with Windows:// +Internet Explorer//
97 The appearance on the calculator of the M sign in the upper left corner of the keyboard means that //
- in memory is the number // 98 What is a file system?//
- The general structure, according to which the operating system assigns names to files and places them on the disk // 99 Choose examples of file systems?// +FAT16 and FAT32//
100 Earlier versions of MS DOS and Windows use the following file system //
+FAT16//
101 Windows. What is the Main Menu for?//
- To change the settings of Microsoft Windows, launch programs, search for files and perform other actions.//
102 Utilities that perform the necessary checks of the software and hardware are …//
- diagnostic tools // 103 Disk cleanup - //
- program to check the disk and output a list of temporary files, as well as files downloaded from the Internet, and unnecessary program files that do not mind removing // 104 Windows. Command for formatting the drive in MS Windows:// +My computer - Disk - Right click – Format.//
105 What should you do if I need to rename the file, and the system does not accept the suggested name://
- Offer another name that does not contain the specified characters.//
106 Windows. To create the shortcut you need //
- Call the context menu (right-click), select New-Shortcut // № 1 Basic functions of text editor:// To edit, format, print the text.//
2 Extensions of text editor Microsoft Word:// DOC, Docx//
3 File name in a text editor MS Word must not exceed:// 256 symbols//
4 The window of Microsoft Word contains the following elements:// office button, title bar, quick access tool bar, ribbon, rulers, text area, scroll bars and status bar// 5 Function of command "To Save as..."// Saves the copy of basic file in another location or changes extension of file. //
6 Types of List in MSWord:// Bullets, numbered, multilevel //
7 MS Word 2007. Group of symbols is located in a following tab:// Insert//
8 MS Word 2007. Using which tab we can create a table?// Insert// 9 MS Word 2007. An icon of formulas is in a tab:// Insert//
10 MS Word 2007. An icon of chart is in a tab:// Insert//
11 Standard size of format of А4 // 21 х29,7 cm//
12 Sizes of viewing of document in MS Word:// from 10 % to 500% //
13 The Paragraph group of the Home tab allows to set up…// Indents and spacing, alignment.//
14 MS Word 2007. A line on that is located the group of commands is named ...: // Ribbon. //
The number of pages of the document are automatically numbered.//
54 The MS WORD contains the next text alignments:// Left, right, center and justify.// .
55 MS Word. How to make the selected text bold: // Select the text fragment, Click the icon. // .
56 Function of the Office button in Microsoft Word: // create, open, save, print files, and etc.// .
57 MS Word 2007. How to add and change the border around the page: // Page Layout – Page Background - Page Borders.//
58 MS Word 2007. Where are located Find and Replace commands: Home – Editing - Find or replace.// .
59 Actions that can not be performed using the Font dialog window: // Changing the line spacing.
60 MS Word 2007. Header & Footer function:// Edit the header and footer of the document.// 61 How to put a chart in a document:// Insert –Illustrations – Chart
62 Table is: // A grid of rows and columns that intersect to form cells//
63 MS Word 2007. How to insert the symbol:// Insert – Symbols – Symbol // 64 MS Word 2007. How to insert the equation:// Insert – Symbols – Equation //
65 How to run Microsoft Equation 3.0 editor in MS Word? // Insert – Text - Object – choose Microsoft Equation 3.0//
66 Table editing in MS WORD includes: // Add a specified number of rows and columns, merge and split cells, remove selected cells, rows, and columns
67 MS Word 2007. How to insert a Picture into a document:// Insert – Illustrations - Picture
68 MS Word 2007. How to insert the Shapes:// Insert – Illustrations -Shapes
69 What happens when you highlight the text in the MS Word, then press (Ctrl + B) and (Ctrl + I) key combinations:// The text moves to bold and italics.//
71 Hypertext is a: // points to a whole document or to a specific element within a document //
72 Style// a set of text formatting characteristics such as font size, color, and alignment //
73 A point is: // a typographical term for a unit of measure. It is roughly equivalent to 1/72 of an inch//
74 MS Word. How to merge two tables into one? // Delete spaces between tables using the Delete key
75 What parameters are displayed when insert table in Word?// number of rows and columns and autofit behavior//
76 How to merge selected cells In MS Word:// Layout – Merge - Merge Cells //
77 Groups of commands in Insert tab:// pages, tables, illustrations, links, head & footer, text, symbols.//
78 Groups of commands in View tab:// document views, show/hide, zoom, window, macros.
79 The Font dialog box contains the following packages// Font, Character Spacing.//
80 MS Word 2007. Where are located Date & Time commands: Insert – Text – Date & Time.// 81 To set page parameters, do the following: //. Page Layout – Page Setup group– then to set up the required page parameters // 82 MS Word. To replace the words in the text, do the following: Select the words–click Home tab – Editing group – Replace with// 83 To Сut a part of an MS Word document, do the following: // Select the Text –click Home tab – Clipboard group – Cut. //
84 How to Merge two or more adjacent cells in Microsoft Word: Table Tools – Layout – Merge Group – Merge Cells. // 85 How to resize a Word graphic object: // Select the object, hover your mouse over one of the Resizing Handles, which are located on each corner of the object and drag it to resize object. // 86 How to group several graphic elements in the Word editor: // Select a grouping items – run context menu - click Grouping - group. // 87 How to bring a graphic element to the front? // Select the graphic objects and click Order / Bring Forward command from context menu. // 88 To split table cells in a text editor: // Select cell that you wish to split – click Split Cells from the context menu. //
89 To merge cells in a text editor: // Select cells that you wish to merge – click Merge Cells from the context menu. //
90 Show actions that cannot be performed using the Font Formatting dialog box : // Turn the first character of a paragraph to a Drop Cap. //
91 To indent the first line of a paragraph, follow these steps: // Put the cursor at the beginning of the paragraph and press the Tab key. //
92 Word. The Page Layout Tab holds the group of commands:// Themes, Page Setup, Page Background, Paragraph, Arrange. // 93 To double the segment in MS Word use the command: // View– Zoom– 200%.
94 MS Word. There are all the commands for combining table cells, except for one //: Select cells you want to merge, press the Delete key. //
95 We can change the thickness of a table borders using commands… Select table – click Borders and Shading from the context menu, then choose width of the line. //
96 Which of the following best describes the function of the button on the Ribbon circled in orange in the screenshot above? // You use it to copy the formatting of selected text. // 97 Which of the following represent pre-set paper size types which you can select from the Size button in the Page Setup group? // // Envelope, Letter, A3, A4. //
98 If you have to write a paper where the margins need to be set to the following exact measurements: Left: 1.5", Right: 4", Bottom: 1", Top: 1", how can you go about setting this up? // Page Layout– Page Setup group – Margins section, then enter the page margin values as noted in the question above. //
99 Which of the following items cannot be inserted into a Header or Footer of a document?// All of the above items can be inserted into either a Header or a Footer.
100 How do you exit the header and continue working in the body of the document? // Double click on the body of the document or click the Close Header and Footer button. //
101 Which of the following are NOT numbering formats available from the Number Format list? // (1), (2), (3), (4), (5), etc. // № 1 Choose the command to add the row to the Sheet in MS Excel:// Context Menu – Insert – Entire Row// 2 How to put a border (frame) in a table of MS Excel?// Home – Font – Borders// 3 Indicate the error in the writing of formula SUMM (C7:C10) in MS Excel: // Nosign "=" before the formula 4 What is $B1 and B$1 in MS Excel? Combining cell address// 5 MS Excel. How to adjust the size of columns and rows in a cell? // Home –Cells – Format - Row height – Column width// 6 Formula for summation the range of cells: =SUM(А1:А7) // 7 Correct version of the formula in MS Excel: // =А3!*100/В3. //
8 MS Excel. Inserted number 0.3674 in cell B6. If you select this cell and select Percentage format, how does this number change? // 36,74%
9 MS Excel. Inserted number 8675in cell B6. If you select this cell and select Currency format, how does this number change? 8 675,00//
10 Command that can be used to merge cells in MS Excel: // Home – Alignment – Merge cells// 11 What is the following record in MS Excel = $B3 * C$3? // Multiplication the values of cell B3 and C3//
12 What commands do you need to completelycopythe pagein MS Excel?// Sheet label – Context Menu – Move or copy – OK//
13 What is the type of chart shown in figure? // Pie// 14 What is the type of chart shown in figure? // Cone//
15 What is the type of chart shown in figure? // Line//
16 What is the type of chart shown in figure? // Doughnut// 17 MSExcel. What to do if data does not fit in the visible part of the cell? // To increase the cell width or select the check box wrap text for that cell. // 18 MS Excel.A command to remove the sheet protection: Review– Changes-Unprotect Sheet// . 19 How to get the command to calculate the square root of a value in Excel? // Formulas tab – Insert function – Math & Trig – SQRT//
20 MS Excel. A command of the formulas for calculating SIN, COS: // Formulas-Insert function-Math & Trig// \21 In cell B6 was entered a number 8675. If you select this cell and select "Scientific", then this number turns into:// 5,68E+09//
22 The formula for calculating the mean values of cells in MS Excel (A1: A10):// AVERAGE (A1: A10)// 23 Correct version of the function to determine the absolute value of the number in MS Excel: // =АВS(F5) //
24 MSExcel. The HOME tab includes the following groups of commands: // Font, Alignment, Number, Cells //
54 Office button in MS Excel includes the following commands: // New, Open, Save, Print //
55 What is the best way to higlight a row in MS Excel? // Click the row number .//
56 What is a Link in MS Excel? // Displays the cell addresses in the formulas. // 57 A cell cannot contain data in the form of ... // picture; //
58 Which type of cell address contains rows number and column name? // relative // 59 Which type of cell address contains «$» before rows number or column name? // mixed //
60 Which type of cell address contains «$» before rows number and column name? // absolute // 61 In MS Excel A1: // relative cell address //
62 $A$1 in MSExcel: // absolute cell address // 63 Formula bar in MS Excel displays? // Cell contents//
64 What is the current date in MS Excel? // = TODAY () .// 65 What is the beginning of the formula in MS Excel? // equality // 66 What are the functions in the MS Excel? // Math.//
67 When computing in MS Excel # NAME! What does the mark appear in the form:// The cell name in the formula is invalid 68 What happens when you type in MS Excel # REF: // The cell reference is invalid
69 In MS Excel # VALUE! What does the mark appear in the form: // The function indicates that an argument can not be used
70 MS Excel. How is a syntax error calculated? // The system will prevent you from entering a formula containing a syntax error. // 71 In Excel, you need to specify the names of the source and last cells in the cell and then place them in the cell // colon
72 What type of function does MS Excel have? // Dictionary functions.
73 When you fill in the cell mark, the shape of the mouse is: // Cross. //
74 A group of cells: // We speak the working area. //
75 MS Excel. Graphical representation of table data: // Cells. // 76 MS Excel. Element of chart is linked to the data being graphically displayed in the plot area of the chart:// Legend.//
77 MS Excel. The number of typical diagrams:// 11.// 78 The chart is ...// graphical representation of data;//
79 Chart, where some values are represented by vertical columns of different heights, called:// histogram;//
80 The histogram is:// Chart, where some values are represented by vertical columns of different heights; //
81 MS Excel. Construction of the chart is based:// data table;// 82 Region, which allows to match for each of data set the color and design:// The legend;//
83 A pie chart is a chart: // in the form of a circle divided into sectors; // .
84 A line chart is called:// display the initial data as points connected by line segments;//
85 MS Excel. In the category of logic functions comprises the functions:// IF, TRUE, FALSE; //
86 MS Excel. The category of statistical functions includes functions:// VAR, CORREL.
87 MS Excel. The command to delete the sheet:// Contextual menu - Delete;//
88 The cell address in Excel consisting of the column name, row number and a dollar sign "$" which placed before column name and before row number is called// absolute//
89 MS Excel. In $A$2 the absolute is :// The row number and column name.// 90 MS Excel. In $A2 the absolute is:// Name of the column.//
91 MS Excel. What is the Insert Function :/// Library of functions under the various categories.//
92 MS Excel. The command for adding a column to a sheet:// Context menu – Insert –Entire Column.//
93 MS Excel. Impossible options for the Date format:// 30/32/1996.//
94 Specify in which case Excel correctly specified range of cells С4:К6// 95 MS Excel. The types of data that can be entered in the cells:// Numeric information, character information, dates, formulas.//
96 MS Excel. AutoFilter is used for: // Extract the necessary data from the table//
97 Excel. Autofilling can be used:// Months, weekdays, numbers.// .
98 MS Excel. A function that determines the sum of the numbers: // SUM//
99 MS Excel. Where does dialog window appear by clicking the Insert Function icon? // On the formula bar//"
100 A row or column of numbers that are plotted in a chart is called: Data series; //
№ MS Access. The MEMO field consist of the next: 65 536 characters//
MS Access. The exact format of the date or time is set as follows: // Field format. //
MS Access. Tables of MS Access consist of .... Field and Record // MS Access. The name of data fields is: // Database name. //
MS Access. The rows of the table are called: // Records. // MS Access. The columns of the table are called: // Fields. // MS Access. Name a specially designed object to enter data or visualize the data in a table: // Form. // In MS Access the object REPORT is used ... // to print data based on queries/tables that you have created//
Choose one of the data types in MS Access: // Number. //
The maximum number of characters you can enter in the Text field: //
MS Access 2007. Which Tab contains the "Table" groups of commands:// Create.//
MS Access 2007. A clipboard is located: // Home//
MS Access 2007. Which Tab contains the "Forms" groups of commands:// Create.// MS Access 2007. Group of Sort & Filter is located in a tab:// Home .// MS Access 2007. Home tab consists of the following groups: // Views, Clipboard, Font, Rich Text, Records, Sort & Filter, Find.//
MS Access 2007. Create tab consists of the following groups: // Tables, Forms, Reports, Other.// .
A Database is: // a collection of information that is organized so that it can be easily accessed, managed and updated.// MS Access. The "Create" Tab lets you: // Create a new table //
MS Access. The "Form Design" icon lets you:// Create a new blank from in Design view.
MS Access. What does Table Design button in Crate tab allow us: // Create a new table, change the current table properties
MS Access. icon is used for:// Set up relationship between tables.// .
MS Access. icon is used for:// Creating a form //
MS Access. icon is used for:// Creating a new Report in Design View // \
MS Access. icon is used for:// Creating a new table in Design View // Which of these buttons are used for creating a simple query: // +
Which of the buttons are used for creating a table in Design View: // + //
Choose the correct list of data types in the fields of tables in MS Access: / Time, Currency, OLE Object, Lookup Wizard;
MS Access 2007. Where are located Filter commands: Home – Sort & Filter – Filter.//
MS Access 2007. Where are located Find and Replace commands: Home – Sort & Filter – Find.// .
MS Access. The property size is: // Increase and decrease the text field size .// .
MS Access. "Autonumber" data type is used for To automatically set the number of new records as sequential numbers // MS Access. Standard Logical Operators Used to Create or Modify Selection Terms: // And, Or, Note, Like.// MS Access. Entering data in table cells is done as follows: // By activating the cell and entering it from the keyboard .//
MS Access 2007. In which group of command The "Sort Data" button is located: // Home - Sort and Filter// Access. What object is used to group multiple orders? // Macros //
Inserted file;//
Where the letter is saved after sending e-mail?// in the mail service;//
Which extension it has a hypertext document on the Internet?// .html, .htm;//
What is the name of network architectures that components the basis of any network service? // Client and server// Specify the program that allows you to work with e-mail, contacts and time-table, keep a record of your actions: // Outlook// Specify the program browser:// Opera//
Domain .KZ in the name of the site indicates the country: // Kazakhstan. //
Which tag is used to put an image in the HTML document?// //
HTML. Choose the correct path to the file named logo,which is located in the folder images:// ../images/logo.png// String sets:// font size 5 text and font color// What will be the result of the next string great holidays ?// The text moves from left to right, reaching the edge, changes direction//
How to set the link to the email? // // How to set the title alignment to the left?// //
What does the behavior attribute do in this string ?// sets the types of movements //
You have entered an e-mail address on the Internet: [email protected]. Enter the name of the owner of the email address. // usupova //
You have entered an e-mail address on the Internet: [email protected]. Specify the name of the computer on which mail is stored. // nursat.kz .//
Specify the login email address [email protected] - //ivan_petrov; //
Which of the record is the e-mail address (e-mai1): // [email protected].// An email address is specified on the Internet [email protected]. glasnet.ru. //
What browser is popularin the first place because of it comes with Internet Explorer//
What first-level domains that cover educational institutions?// .edu//
What protocol is used to receive email messages?// POP3// What protocol is used to send emails? SMTP//
Specify an email access protocol? IMAP//
What protocol is used for transmission of hypertext?// HTTP
Who developed e-mail?// Ray Tomlinson// CSS is: language of hierarchical rules//
Specify the universal designation of the location of the resource:// URL// Specify a system for obtaining information about domains:// DNS// Specify URL of NJSC MUA:// htttp://www.amu.kz//
Specify popular free instant text messaging system for mobile and other platforms:// WhatsApp//
Which type of network topology is shown in the picture? // tree network //
Which type of network topology is shown in the picture? // ring topology //
The way to connect computers, forming the following network topology.
The way to connect computers, forming the following network topology.
- this…// star topology. //
For information transfer in computer networks usually are used: // Cable "twisted pair" //
Which mailing lists do publications come to subscribers? // subscribe //
To store files intended for sharing by network users, use: //
file server; //
The transport protocol (TCP) provides: // reliable, streaming, connection-oriented data delivery. // .
TCP/IP –is…// a group of standard protocols for exchanging data between computers on the Internet.// What is the information transfer rate measurement:// bit/second//
Network node is…// a computer connected to the network and supporting the IP protocol.//
Rules for the exchange of information between computers over the network protocol//
Local area network is…// a network which encompasses computers and peripherals connected within a room, building or nearby buildings.//
A global area network refers to …// a network composed of different interconnected networks that cover an unlimited geographical area.// The computer to which a permanent IP address is assigned: // host computer //
What is the name of the organization that has an IP address? // provider //
The hub is: // Communication device that connects computers to the network. //
The host computer is: // Powerful computers that are nodes of computer networks. //
The computer network is: // combining several computers to solve problems together; //
The provider is // Society of direct communication of the consumer with the Internet //
The communication data exchange device is ... // modem //
The correct entry IP-address is:// 18.209.33.68;//
Specify the optimal topologies of the local network:// Bus topology //
What is the name of the local network configuration (connection network)?// Topology
What are the rules that determine the transfer of mail from one computer in the network to another?// Protocol;// Devices for exchanging information with other computers over the telephone network: // Modem. //
Unit of data transfer rate via modem: // Baud.//
Specify the most important modem characteristics: // Data transfer rate;//
A device that allows a computer to work in a local network;// Network adapter;//
A device required to connect computers to a local network;// Network Card;//
The person, who manages the organization of work for participants of a local computer network is: // System Administrator.// A special computer dedicated for sharing by network members is called: // Server // .
Which type of computer stores the common files in a network?// Server//
What characterizes a WLAN network?// It has a wireless connection//
A telecommunications network is: A system of technical means through which telecommunications are carried. //
Telecommunications networks include:// Computer networks, telephone networks, radio networks, television networks.//
Fiber – optic cable is:// A glass or plastic thread used to transfer light within itself through total internal reflection.//
Which of these schemes connects computers to one cable?// // // //+ //
Which of these computer circuits connected to cable segments from a single point?// // // //+ / Mail servers, firewalls, proxy servers belong to the ... telecommunication// 1 What is a computer virus? // A program that can self-replicate and attach itself to various objects or resources of computer systems, networks without user knowledge. // .
2 Which option isn’t used for the classification of computer viruses?/ The memorysize occupied by the virus.//
3 Network viruses use for their spread // Protocols or commands of computer networks and e-mail. //
4 Non-resident viruses //
Convert the following Morse Code into words (use _ for spaces) . .-. --- -.-. ..- ...--- -.- .... ._--. --- --- -.. // ++Focus on the good//
37 The text “CRYPTO” isencrypted using the encryption table. Find the correct cipher using the substitution cipher in the table above.// ++XYPASM//
38 The above table shows the Morse Code Characters for all letters. Convert the following Morse Code into words -- --- - .. ...-. // ++Motive// 39 The text “SYMBOL” is encrypted using the encryption table. Find the correct cipher using the substitution cipher in the table above.// ++944819236370//
40 The word is encoded using a substitution method and looks like “946150556175”. Decipher the word using the encryption table: // ++SECRET// Which type of cloud computing model is primarily considered as Infrastructure as a service (IaaS)
What deployment models does cloud computing provide? Private cloud, public cloud, hybrid cloud;
What Web services does cloud computing provide?// IaaS, PaaS, SaaS//
What are the four main types of cloud services provided by Windows Azure? Could services, virtual services, web services, application services. Platform services, virtual services, network services,web services.
What is a hybridcloud?// A cloud consisting of two or more different types of a cloud, for example, public and private.
What is a public cloud?// Resources are available to multiple organizations with similar needs in terms of information resources.//
What is a privatecloud?// Resources are only available to a limited number of users.//
A combination of two or more different cloud infrastructures is called. a hybrid cloud
An infrastructure for a free used by more people is called. a public cloud
A cloud infrastructure intended for use by one organization is called. a private cloud
What are the main characteristics of cloud computing? On-demand self-service, universal access network, resource pooling, elasticity, accounting for consumption.
What is a mobile operating system? This is a system that allows you to make a full- fledged personal computer out of a multifunction phone.
Data access services ____ (specify not valid)// Mobile voice
Mobile technology is –// The technology used for cellular communication//
What is Dropbox?// Cloud data storage allows customers to store their data on servers in the cloud and allows you to use them to other users on the Internet
Android is a mobile operating system (OS) developed by_____// Google//
A convenient environment for processing and storing information in various formats that combines hardware, software and provides support for web users is…// Cloud technologies// One of the most important features in the______mobile networks is the domination of high-speed packet transmissions or burst traffic in the channels.// 4G//
What is Google Drive?// Free cloud data store. It allows customers to store their data on servers in the cloud and makes it possible to use them to other users on the Internet//
_______is the first completely open source mobile OS, meaning that it is free to any cell phone mobile network// Android//
The tool used to host computer systems and related components is ...// Specialty products for writing distributed web-services// Data processing center//
Many types of mobile operating systems (OS) are available for smartphones, including (specify not valid):// Jobs Disk
What are the main operating systems for mobile phones? Android, Windows Phone, IOS.//
Basic service models in the cloud. Choose irrelevant variant. LaaS
_______provision of a set of computing resources or their logical combination, abstracted from the hardware implementation, and providing a logical isolation from each other computing processes performed on the same physical resources. Virtualization
Types of computer graphics are// Vector and raster//
Vector graphics is composed of// Paths//
Raster graphics are composed of// Pixels//
Term which refers to the sharpness or clarity of an image, is// resolution//
List the major graphic file formats.// *.BMP, *.JPG, *.GIF, *.TIF, *.PSD//
List the major video file formats.// *.VHS, *.DV, *.SWF, *.FLV, *.AVI//
List the major audio file formats.// *.MIDI, *.MP3, *.DSS, *.WMA, *.M4A
What audio file formats is used for audio books?// *.M4B//
Video file formats MOV is developed by Apple Inc. …// for creating, editing, viewing and publishing multimedia files.// What is multimedia?// integration of still and moving images, text, and sounds by means of computer technology//
What aresequencers?// designed to create music//
Specify the method of compression of multimedia data, after which the image will be exactly the same as the original?// compression without Loss of Data//
Specify the method of compression of multimedia data, after which the data do not coincide with the original data?// compression Lossless in Terms of Perception// Specify the method of compression of multimedia data, after which can be observed quality losses, if information was lost during the compression process?// compression without Loss of Quality// Specify the method of compression of multimedia data, after which so-called natural degradation of the image, in which some small details of the scene are lost?// compression with Natural Loss of Quality//
Specify the method of compression of multimedia data, after which observed low quality of compression, which largery distorts the image and brings into it artificial details of the scene?// compression with Unnatural Loss of Quality
MPEG stands for:// Moving Picture Experts Group//
Types of multimedia are// linear and interactive// Artificially created world in which a person is immersed is called:// virtual reality//
Automation of moving and transforming 3D models in space over // animation//
Representing the movement or transformation of an object as graphs for each of its XYZ coordinates is called:// motion curves//
Specify graphics designed for automatic image generation using mathematical calculations: fractal// Specify graphics intended to create decoration and drawings: vector//
Specify graphics used in processing publications and printing raster//
Specify graphics operates with objects in the 3D space:
3D//
Specify object the elements of which inherit properties of parent structures: fractal//
What is the minimal surface in 3D graphics called? polygon
Receiving moving images on the display screen is called:// computer animation//
Arbitrary drawing and sketching on a computer screen is called:// illustrative graphics
What advances in multimedia were made in the early 1970's?// advances in graphics, movies, and audio//
Which program can create an animated slide? Power Point.//
Which command corresponds to the F5 key in the Power Point program? // Slide Show //
A button to exit the presentation viewer ... ESC // What key is the start of the slide show in Power Point ?. F5 //
Which button of the Power Point program interface is for inserting the text block directly into a slide? Text box //
What is a Power Point? Microsoft Office Application for Creating Presentations //
The smallest unit of presentation which consists of different objects. slide //
A set of slides that are collected in one file ... // presentation //
In Which tab is located the New Slide command in Power Point 2007? // Home
Where is the Spelling command in Power Point? // Review //
Where you can find Crop button for pictures in MS Power Point? // Format
MS Power Point. Purposeof the icon function:// Start the slide show from the current slide.//
Where you can find commands for adding animations in MS Animations //
Which of the following buttons used for adding slides in the presentation: // // MS Power Point. icon is used for:// Add a slide to the presentation. // MS Power Point. icon is used for:// Change the layout of the selected slide.
E-mail address of the electronic government of the Republic of Kazakhstanweb portal:// www.e.gov.kz//
External contour of the electronic government of the Republic of Kazakhstan:// G2C, G2B.//
Internal contour of the electronic government of the Republic of Kazakhstan:// G2G.//
Service provided by information and communication tools:// E - service.//
Bank account management with the organization of access via the Internet is called:// E - banking.//
Name of government agencies, organizations and other business entities that provide services using ICT facilities:// Providers of e - services.// .
Citizens, government agencies, organizations and other business entities using the services of e-government:// Consumers of e- services.
A set of electronic digital symbols created by means of a digital signature and confirming the authenticity of an electronic document, its ownership and immutability of the content is called:// Electronic digital signature.//
An information system that provides a single point of access to all electronic services and electronic information resources of e- government is called: // Web portal of e-government.//
The transfer of electronic information resources and the provision of access of individuals to electronic information resources and information systems of local government agencies through the use of information technologies is called:// Electronic local authorities (akimat).//
A sequence of electronic digital symbols, accessible to any person and intended to confirm the authenticity of a digital signature in an electronic document, is called:// Registration certificate.// .
The activity of providing electronic information resources to users upon their requests or by agreement of the sides, requiring the mutual exchange of information, making payments and other actions using electronic digital signature is called:// Transactional services.//
Providing individuals and legal entities with information, interactive and transactional services using informational technology:// Transactional services.//
The individual documents that make up the Web space are called:// Web-pages.
Name of the domain representing the Republic of Kazakhstan in the Internet address system:// Kz//
E-government is// system providing direct communication of the population with the government of the country.//
E-government created for// simplification of the appeal of the population to government agencies //
Authorized agency is// government agency implementingthe realization state policy and state regulation of activities in the field of informatization.// .
Information system is// set of information technologies, information networks and means of their software and hardware, designed to implement information processes// Information processes are // the processes of creation, collection, processing, accumulation, storage, search, transfer, use and dissemination of information using information technologies;
Informatization is // organizational, socio-economic and scientific-technical process aimed at the formation and development of information resources, information systems based on the use of information technology //;
The basic technological component of the concept of electronic media and business (production) is// Internet//
The purpose of creating e-government - // creating a system that provides a direct connection of the people with the government of the country. // // .
Internet site that provides a user access to several network services at once : catalog, news, search engine, etc., or several sites closely integrated into one system - this is // portal//
A Gateway is// tool for integration and information exchange. // \
What is URL (Uniform Resource Locator)?// A string of characters that describes an Internet resource such as a http web address or image location.// .
A specialized storage of information about a unified architecture, models, regulations, subjects of interaction and metadata is called repository // .
E-banking is// electronic service that provides easy and safe access to your bank account//
The main stages of the formation of e-government in the Republic of Kazakhstan:// Informational, interactive, transactional.// E-government portal of the Republic of Kazakhstan: // 12.04.2006.//
G2G means: // The interaction of the government with the state apparatus. //
G2B means: // The interaction of the government with private business. //
G2Сmeans: // State interaction with citizens. // .
The number of information services provided on the portal "e- Government": //
.
All Internet web pages have one thing in common: // They are created using HTML.// G2G intergovernmental e-government sector implements // interaction between government and citizens. // intra-government relations // .
The sector of e-government activities that ensures the participation of citizens in public life, access to government information, the receipt of public services is // G2C // E-learning is// a learning environment which uses information and communication technologies (ICT's) as a platform for teaching and learning activities.// ………. is a learning environment which uses information and communication technologies (ICT's) as a platform for teaching and learning activities. E-learning LMS - Learning Management System LMS allows you to use technology ..... blended learning technology, social forums, gamification, and sometimes mobile learning. .
Before you even begin the actual eLearning designing process, you need to identify: format of the e-learning course, curriculum model, types of e- learning, and finally, choose the right technology for learning. E-learning can focus on three main aspects:. users, technology and services
The theoretical basis of e-learning systems contains three main components of information systems. These components are…. people, technology, and services.
Who developed the five-stage model of e-learning and e- moderation, which for some time had a significant impact on the use of online courses and online discussion forums? Gilli Salmon
The term ICT is also used to… Refer to the convergence of audio-visual and telephone networks with computer networks
________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
_______is technology that records, communicates, synthesizes or organizes information Information technology
Worldwide use of computer technology in medicine began in the early____ 1950s ____________is the use of engineering and manufacturing technology to make production faster, simpler and more efficient. Industrial technology
Healthinformationtechnology (HIT)-…….. is the application of information processing involving both computer hardware and software that deals with the storage, retrieval, sharing, and use of health care information, data, and knowledge for communication and decision making. Industrial technology- is the use of engineering and manufacturing technology to make production faster, simpler and more efficient
Information technology- is technology that records, communicates, synthesizes or organizes information
Information and Communications Technology- 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.
People, technology, and services these is… three main components of information systems
_________________:users, technology and services- E-learning can focus on three main aspects
1950s _______________________. Worldwide use of computer technology in medicine began in the early
Which is not true for the main characteristics of e-learning? Fast speed of study of the material
Which is not true for the types of e-learning? lectures in the classroom
The most dynamically developing direction of financial decisions internet banking
