Informatics Grade 10 Test No. 1.

1. Information stored in books on magnetic media, gramophone records are called:

a) archival;

c) Internal;

c) Useful;

e) External.

e) operational.

2. Figurative information that can be stored on external media is:

a) taste images;

c) Image and sound;

c) Tactile images;

e) Text written in any language;

f) Image only.

3. The student writes a presentation, what information processes are performed by the student?

a) Reception and departure;

c) Reception and processing;

c) Reception, processing and storage;

e) Reception, storage, departure.

f) Reception, processing, storage, dispatch.

4. Vanya is in the first grade and knows the multiplication table well, but does not know in English. Which of the messages will be informative for Vanya?

c) MY FRIEND IS SCHOOLBOY;

c) Vanya goes to school;

e) there are 26 letters in the English alphabet;

e) 6 MULTIPLAY 8 EQUAL 48.

5. From the proposed messages, select declarative information

a) bit - a unit of measurement of information;

c) the sum of the angles in a triangle is 180 degrees;

c) Pushkin is a great Russian poet;

e) circle - a set of points equidistant from the center;

e) when multiplying simple fractions, their numerators and denominators are multiplied.

6. For 5 minutes, at a speed of 20 bytes / s, the leader of the Multi tribe transmitted an information message. How many characters did it contain if the tribe's alphabet consisted of 32 characters?

7. 1.5 megabytes are equal to:

a) 1536 KB;

c) 1500 Kb;

c) 1536 bytes;

e) 1500 bytes;

e) 0.015 GB.

8. An information message of 1.5 KB contains 3072 characters. How many characters are in the alphabet in which this message is written?

9. The result of adding two numbers written in Roman numerals MSM +LXIV, is equal to:

e) 1164.

10. The number 30111011 can exist in number systems with bases:

Answers to test number 1

Informatics Grade 10 Test No. 2.

Before turning off the computer, you can save information:

a) in random access memory;

c) during external memory;

c) in computer registers;

e) on a disk drive;

f) in the magnetic disk controller.

2. An electronic unit that controls the operation of an external device is called:

a) adapter (controller);

c) a driver;

c) processor register;

e) a common bus;

e) interface.

3. The smallest addressable part of computer memory:

c) kilobyte;

e) cell.

4. "The catalog contains information about .... stored in ...". Instead of ellipsis, you need to insert the words:

c) external memory files;

e) programs, processor.

5. Driver is:

a) a device for long-term storage of information;

c) a program that controls a specific external device;

c) input device;

e) a device that allows you to connect a new external device to your computer;

f) output device.

6. While the computer is running, the RAM constantly contains:

a) the kernel of the operating system;

c) all operating system;

c) application software;

e) programming system;

f) the program is an archiver.

c) directory;

c) directories;

e) programs;

The template that is used for file search, whose names begin with the symbol "F»:

The application is unloaded from memory and terminates if:

a) launch another application;

c) minimize the application window;

c) switch to another window;

e) move the application window;

e) close the application window.

The taskbar is used for:

a) switching between running applications;

c) shutdown Windows;

c) communication between applications;

e) launching MS DOS programs;

f) directory browsing.

11. Filetetris. comlocated on the C drive in the directoryGAMES, which is a subdirectory of the directoryDAY. Full filename:

a) C:\\GAMES\DAY;

c) C:\GAMES\ ;

c) C:\ DAY\ GAMES\ ;

e) C:\ GAMES\ DAY \ ;

e) C:\GAMES\ .

12. Proposed set of commands:

create a filehome. txt;

create directoryTOWN;

create directorySTREET;

enter the created directory;

make drive A current.

To obtain an algorithm by which a file with a full name is created on an empty disketteA:\ TOWN\ STREET\home. txt, these commands should be placed like this:

a) 5; 2; 4; 3; 4; one;

c) 5; one; 3; 4; 2;

e) 5; one; 2; 3; 4;

13. "... memory means that any information is entered into memory and retrieved from it by ...". Instead of ellipsis, you need to insert the words:

a) discreteness; addresses;

c) addressability; values;

c) discreteness; bits;

e) addressability; bytes;

e) addressability; addresses.

14. Application software includes:

a) programming languages;

c) operating systems;

c) dialog shell;

e) the totality of all programs installed on the computer;

f) text editors.

15. “A program stored in external memory, after being called for execution, enters ... and is processed ...”. Instead of ellipsis, you need to insert the words:

a) an input device; processor

c) processor; processor registers;

c) processor; processor

e) working memory; processor

e) file, processor.

Answers to test number 2

Informatics Grade 10 Test No. 3

Text editor cursor coordinates are fixed:

a) in the text editor menu;

c) in the dictionary of a text editor;

c) in the text editor status bar;

e) in a text editor window;

e) in the buffer for copying.

While the text editor is running, the spelling dictionary:

a) loaded into external memory as needed;

c) is constantly in the input device;

c) resides permanently in RAM;

e) is loaded into RAM as needed;

e) resides in the output device.

The character encoding table maps between:

a) symbols, their decimal numbers and binary codes;

c) symbols of different alphabets;

c) characters and the number of bytes they occupy;

e) symbols and numbers of memory cells they occupy;

e) symbols and keys.

To output devices graphic information applies to:

a) display;

c) keyboard;

e) scanner;

e) graphic editor.

Text formatting includes the following:

a) copying fragments of text;

c) correcting typos;

c) spell check;

e) change of paragraph indents;

f) moving text fragments.

When the following (their) command(s) is executed, the selected text fragment is placed on the clipboard:

a) insert;

c) replace;

c) check spelling;

d) align to the center;

e) cut and copy.

The text takes up 0.25 KB of computer memory. How many characters does the text contain?

Symbol numbers "Z" and "B" in the encoding tableASCIIare respectively equal to:

The size of the video memory page is 125 KB. The graphic display works with a 16 color palette. What is the resolution of the graphic display?

The code for green is 010. How many colors does the palette contain?

Code (number) of the letter "j" in the character encoding table is 106. Which sequence of codes will match the word "file"? Latin letters alphabet:a b c d e fg hijklmnop …

a) 110 107 104 111;

c) 74 98 120 66;

c) 132 112 90 140;

e) 102 105 108 101;

f) 90 102 114 86.

The sequence of codes 105 162 109 of the encoding table encrypts some characters. Among these symbols:

a) there cannot be letters of the Russian alphabet;

c) there cannot be letters of the Latin alphabet;

c) there may be letters of the Russian and Latin alphabets;

e) there cannot be letters of the Russian and Latin alphabets;

f) there can be only one letter of the Latin alphabet.

It takes 84,000 bits to store text. How many pages will this text take if the page contains 30 lines of 70 characters per line?

The amount of video memory is 62.5 KB. Graphic display works in 640 modeX400 pixels. Which maximum amount colors can contain a palette?

To delete an incorrectly typed character, use the key:

The text editor window contains 25 lines of 60 characters per line. The window of the graphic editor working in two-color mode - 80 X 25 pixels. Compare the amount of memory required to store text that occupies the entire text editor window and to encode an image that occupies the entire field graphic editor:

a) text requires more memory than pictures;

c) text requires less memory than pictures;

c) text requires as much memory as a picture;

e) there is not enough information to answer the question;

What characters can be encrypted with table codes

ASCII 119 b 235?

a) "e" and "w";

c) "j" and "s";

c) "d" and "D";

e) "I" and "t";

e) "w" and "s".

Part of the book is represented by color images in 16 color palette in 320 formatX 640 points. Pages containing text are formatted as 64 lines of 48 characters per line. Determine the maximum possible number of pages that can be stored on a 40 MB hard disk if the number of pages represented by color images is 80 more than the number of pages containing only text.

"The contents of the video memory are continuously viewed ... and displayed ... on the screen." Instead of ellipsis, you need to insert the words:

a) display processor, central processing unit;

c) central processing unit, display processor;

c) display processor, display processor;

e) central processor, graphic adapter;

e) graphics adapter, the central processing unit.

IN text editor you can use only one font and two buttons to set effects such as bold and italic. How many different character styles can you get?

For 5 minutes, at a speed of 10 bytes / sec, the leader of the Multi tribe transmitted an information message. How many characters did it contain if the tribe's alphabet consisted of 32 characters?

An information message of 3 kilobytes contains 1024 characters. How many characters are in the alphabet in which this message is written?

"The directory contains information about ... stored in ...". Dots should be replaced with the words:

a) programs, RAM;

c) files, RAM;

c) programs, external memory;

e) files, external memory;

e) programs, processor.

A program that controls the operation of a particular external device, is called:

a) an adapter

c) a driver;

c) command processor;

e) an archiver;

e) controller.

File,line. exelocated on disk in a directoryGAMES, which is a subdirectory of the directoryMY. Full file name:

a) C:\Line. exe\GAMES\MY;

c) C:\GAMES\lines.exe;

c) C:\ MY\ GAMES\ lines.exe;

e) C:\ GAMES\ MY\ lines.exe;

f) C:\GAMES\lines.exe.

With the help of chopped vector font, the word is typed:

but) CRAB;

in) ? ? ? ?;

from) CRAB;

e) CRAB;

The information content of a message received by a person is:

a) how the message is transmitted;

c) how the received message is processed;

c) how the message was received;

e) the time of receipt of the message;

f) the availability of new knowledge and comprehensibility.

A magnetic disk drive is a device for:

a) records of information only;

c) storage of information;

c) information processing;

e) read-only information;

e) reading and writing information.

With which (their) element (s) of the desktop control you can switch between open windows of folders and applications with the environment Windows?

a) start buttons

c) taskbar;

c) system clock indicator;

e) keyboard layout indicator;

f) menu open windows and applications.

30. The application software includes (yat):

a) programming systems;

c) operating system;

c) text editors;

e) an operating system with a dialog shell;

e) shared devices.

Answers to test number 3

When using materials from this site - and placement of the banner is MANDATORY!!!

The character encoding table maps between

1) symbols, their decimal numbers and binary codes

2) characters of different alphabets

3) characters and the number of bytes they occupy

4) symbols and numbers of memory cells they occupy

5) symbols and keys

What will change when a symbol is presented on the monitor screen in different

encodings (Windows, MS-DOS, KOI8-R, etc.)?

1) typeface

2) character size

4) character outline

5) there will be no changes

The code (number) of the letter "j" in the character encoding table is 106.

What sequence of letters will correspond to the word "file"?

Latin letters alphabet: abcdefghijklmn ...

1) 110 107 104 111

3) 132 112 90 140

4) 102 105 108 101

5) 90 102 114 86

The sequence of codes 105 162 109 of the encoding table encrypts some

Insert the correct statement in place of the ellipsis.

"Among these characters..."

1) there cannot be letters of the Russian alphabet

2) there cannot be letters of the Latin alphabet

3) there may be letters of the Russian and Latin alphabets

4) there cannot be letters of the Russian and Latin alphabets

5) there can be only one letter of the Latin alphabet

Text storage requires 10 KB.

How many pages will this text take?

if the page has 40 lines of 64 characters per line?

Text editor cursor coordinates are fixed

1) in the text editor menu

2) in the text editor dictionary

3) in the text editor status bar

4) in the text editor window

5) in the buffer for copying

Select a phrase whose spelling corresponds to the rules for typing on a computer:

1) All trams have ice windows. White trees, roofs, wires

2) I keep a bright image in my heart: near the winter Volga Yaroslavl in the snow.

3) All trams have ice windows. Trees, roofs, wires are white.

4) I keep a bright image in my heart: near the winter Volga Yaroslavl in the snow.

5) In all trams, windows are made of ice. Trees, roofs, wires are white.

Select an action related to text formatting:

1) copying text fragments

2) fix typos

3) spell check

4) change the size of the fields

5) moving text fragments

When printing a document, 60 lines of 80 characters each fit on a page. What parameters need to be changed to fit fewer characters on the page?

1) change encoding

2) change the font style

3) reduce the size of the page margins

4) reduce the typeface

5) increase line spacing

What characters can be encoded with the ASCII table codes: 119 and 251?

In the text editor, you can use only one font and two buttons to set effects such as bold and italic. How many different character styles can you get?

The size of the text editor window is 20 lines, 64 characters per line. The cursor is located in the upper left corner of the screen and points to the character in the 25th line and 5th position of the text. Which of the following characters will be visible in the window?

1) standing in the 25th line and 70th position of the text

2) standing in the 35th line and 50th position of the text

3) standing in the 1st line and 1 position of the text

4) standing in the 46th line and 57th position of the text

5) standing in the 20th line and 5th position of the text

The minimum set of functions that a text editor should perform does not include:

1) saving files

3) text formatting

4) work with graphics

5) text editing

To edit incorrectly typed characters, use the keys:

1) Backspace, Delete, Insert

2) Home, End, Insert

4) Backspace, Delete

The clipboard is:

1) section of RAM

2) hard section magnetic disk

3) part of the input device

4) ROM section

5) output device part

The text takes up 0.25 KB of computer memory. How many characters does the text contain?

While the text editor is running, the spelling dictionary

1) loaded into RAM as needed

2) as needed is loaded into external memory

3) is constantly in the input device

4) is permanently in ROM

5) is constantly in the output device

To move a piece of text from one place in the document to another, you need to execute the command(s):

1) Copy, Paste

2) Cut

5) Paste

The text consists of 50 lines of 60 characters each. The size of the text editor window is 20 ´ 50 characters. The cursor is in the upper left corner of the working field and its position is displayed in the status bar: (11,11). How many characters will be visible on the screen?

How many words (from the point of view of a text editor) are contained in the following text containing a number of errors:

One, two, three, four, five. The bunny went out for a walk. As a friend of the hunter you run around.

Testing in the section "Text editors" Grade 10.

B. in the text editor's dictionary

C. in the text editor status bar

D. in a text editor window

E. in the clipboard for copying

2. While the text editor is running, the spelling dictionary

A. Loaded into external memory as needed

B. is constantly on the input device

C. resides in RAM

D. Loaded into RAM as needed

E. is constantly on the input device

3. The character encoding table establishes a correspondence between

A. symbols, their decimal numbers and binary codes

B. characters of different alphabets

C. characters and the number of bytes they occupy

D. symbols and the numbers of the memory cells they occupy

E. symbols and keys

4. Graphic output devices include

A. Display B. Mouse C. Keyboard

D. scanner E. graphic editor

5. Select an action related to text formatting:

A. copying fragments of text B. correcting typos

C. spell checker D. change font size

E. moving pieces of text

6. Specify the command(s) at which(s) the selected text fragment goes to the clipboard

A. paste B. spell check C. spell check

D. center align E. cut and copy.

7. The text takes up 0.25 KB of computer memory. How many characters does the text contain

A. 256 B. 2048 C. 32 D. 250 E. 2000

8. The numbers of the characters "Z" and "B" in the ASCII encoding table, respectively, are

A. 80 and 90 B. 130 and 140 C. 90 and 129

D. 160 and 50 E. 10 and 250

9. The code (number) of the letter "j" in the character encoding table is 106. What sequence of numbers will correspond to the word "file"? Latin alphabet: a b c d e f g h i j k l m n o p ...

A. 110 107 104 111 B. 74 98 120 66 C. 132 112 90 140

D. 102 105 108 101 E. 90 102 114 86

10. The sequence of codes 105 162 109 of the encoding table encrypts some characters. Insert the correct statement in place of the ellipsis.

"among these characters..."

A. cannot be letters of the Russian alphabet

B. cannot contain letters of the Latin alphabet

C. can be letters of the Russian and Latin alphabets

D. cannot contain letters of the Russian and Latin alphabets

E. can be one letter of the Latin alphabet

11. Text storage requires 84,000 bits. How many pages will this text take if the page contains 30 lines of 70 characters per line?

A.40 B.5 C.50 D.400 E.350
12. The size of the text editor window is 20 lines, 64 characters per line. The cursor is in the upper left corner of the screen and points to the character in the 25th line and 5th position of the text. Which of the following characters will be visible in the window?

A. standing in the 25th line and 70th position of the text

B. standing in the 35th line and 50th position of the text

C. standing in the 1st line and 1st position of the text

D. standing in the 46th line and 57th position of the text

E. standing in the 20th line and 5th position of the text

13. Text is typed in a text editor

IT JUST CONTAINS PROCEDURES FOR PROCESSING THE DATE AND TIME OF THE DAY, ANALYZING THE STATE OF MAGNETIC DISKS, ROBOT TOOLS WITH DIRECTORIES AND SEPARATE FILES. The "Find and Replace All" command to execute all errors might look like this:

1) Find ROB, replace with RAB 2) Find P, replace with RA

3) Find BROBO replace with BRAB 4) Find BROBO replace with BRABO

5) Find RO replace with RA

14. In the process of formatting a paragraph may change

1) page orientation 2) font size

3) the width and position of the text on the page

4) the sequence of typed characters 5) the content of the text

15. How many words will be found (highlighted, indicated) in the process automatic search in the text: "Far beyond the shallows, in the spruce forest, a bird trill was heard" if the word "spruce" is set as a sample?

1) 1 2) 0 3) 3 4) 2 5) there is no correct answer among answers 1-4

16. In a text editor, you can use only one font and two buttons ( FTO ) to set effects such as bold, italic. How many different character styles can you get?

1) 1 2) 2 3) 3 4) 4 5) 6

17. Is one 3.5-inch standard format floppy disk enough to store the text of a medium-sized book (about 300 pages)

1) Yes, definitely enough 2) No, some floppy disks will probably be required

3) Yes, but only if you compress the text using an archiver program

4) the information volume of such a book is 1.2-1.5 MB, so it is impossible to give a definite answer 5) You cannot store texts on a floppy disk

18. In which of the following pairs of data are of the same type

1) 04/12/98 and 123 2) "123" and 189 3) "Ivanov" and "1313"

4) "FALSE" and TRUE 5) 45

19. In a text editor, the text is typed: FOUR BLACK SCARY CHETENKA DRAWING CHETEZH WITH BLACK INK. The "Find and Replace" command for executing errors can look like this:

1) find THUNDER replace with DEVIL 2) find CHET replace with BLACK

3) find ET replace with EPT 4) find CHETE replace with DASH

5) find ETE replace with DASH

20. The user corrects the text in a text editor. When the cursor was at the beginning of the second line of text, he pressed the BackSpace key (backspace). In this case, the entire contents of the second line moved to the end of the first line. Why did this happen?

1) A machine crash occurred and the user did not automatically save changes to the text

2) User deleted invisible character"end of line", which was at the end of the first line.

3) Pressing this key always changes the automatic text formatting

4) Pressing this key tells the text editor to move to the layout of the text on paper in two columns.

5) Pressing this key destroys the paragraph break

21. Editing is

1) set indents and spacing 2) pagination

3) select paper orientation 4) make any changes to the text

5) font change

22. Select those actions that do not provide text formatting

1) change line spacing

2) text alignment to the left

3) making any changes to the document 4) changing the font

23. The code (number) of the letter "K" in the encoding table is 138. What sequence of codes will correspond to the word "WEDGE"

1) 138 139 140 141 2) 138 142 146 150

3) 138 140 142 144 4) 138 139 136 141

5) 138 146 154 162

24. Typed text in a text editor

INSTEAD OF THE MORNING EXERCISES IN THE MORNING THEY PLAY HIDE-AND-Seek, AND THEIR HEELS SHINE

The "Find and Replace All" command for executing all errors might look like

1) Find T, replace with D 2) Find RAT, replace with RAD

3) Find YAT, replace it with YAD 4) Find YTK, replace it with YADK

5) Find ARYAT replace with ARYAD

25. Hypertext is

1) a method of presenting text information in the form of a running line, when the written text is accompanied by speech from speakers connected to a computer

2) the text displayed on the screen with highlighted keywords, by activating which, the user can choose the order of viewing both the text itself and the accompanying graphic or program information

3) the only way to organize Web pages on the Internet

4) very voluminous text, which includes graphic illustrations, footnotes and a table of contents, and cannot be copied by conventional means of copying and transferring information on small diskettes

5) new generation macrovirus

26. If a text version has an average volume of 20 kilobytes (each page has 40 lines of 64 characters each), then the number of pages in the text is

1) 10 2) 16 3) 8 4) 4 5) 12

27. If the dossier of criminals is 45 MB, and each of them has a volume of 12 pages (48 lines of 64 characters per line), then the number of dossiers is

1) 1280 2) 3840 3) 1250 4) 1560 5)1024

28. Text editor menu -

1) a kind of "window" through which the text is viewed on the screen

2) a part of its interface that provides a transition to performing various operations on the text

3) a subroutine that provides PC resource management when creating a document

4) information about current state text editor

5) status line

29. Information about the employee of the company is stored as a string of 2048 characters. Information about all 8192 employees of the company can be placed on the minimum number of diskettes with a capacity of 1.2 MB equal to

1) 14 2) 12 3) 10 4) 8 5) 16

30. When working with a text editor, the following personal computer hardware is required

1) keyboard, display, modem, plotter

2) keyboard, display, mouse, scanner, hard drive

3) keyboard, display, processor, RAM, external storage, printer

4) keyboard, display, scanner, plotter

5) keyboard, display, processor, external storage, printer

31. In the WORD text editor, rearrange the rows of the table in alphabetical order of the records of a certain column, you should

1) select a column and issue a command Sorting from the menu table

2) select the column entries to be ordered and issue the command Sorting from the menu table

3) select a column and issue a command Auto Format from the menu table

4) select the column entries to be ordered and issue the command Text direction from the menu Format

5) select the column entries to be ordered and issue the command Tabulation from the menu Format

32. To transfer a text fragment to another place in the document, you should

1) select a fragment and issue a command Insert from the menu Edit

2) select a fragment and issue a command Cut from the menu Edit

3) select a fragment and issue a command Replace from the menu Edit

4) select a fragment and issue a command Gap from the menu Insert

5) select a fragment and issue a command Footnote from the menu Insert

33. To copy a piece of text using the clipboard in a WORD text editor, you need to follow the steps (write down the correct order of actions)

1) select the menu item Edit - Paste 2) place the cursor in the desired location

3) highlight the text you want to copy

4) select the Copy command from the Edit menu

34. Hypertext is

1) very large text

2) structured text in which you can navigate using "hot keys"

3) text typed on the computer

4) text that uses the maximum font size

5) text used only on the Internet

35. In order to prepare for copying a word, you need ...

1) Select the word 2) Place the cursor on the word

3) Select a paragraph 4) Place the cursor at the beginning of a word

36. To save a document in a WORD text editor with a new name, you should:

1) click on the "Diskette" icon on the toolbar

5) select the File command from the Insert menu

37. To create an empty table in a text Word editor actions to be taken (write down the correct order of actions)

1) in the dialog box, specify the required number of rows and columns

2) select the menu item Table - Insert Table

3) click OK

4) set the text cursor in the place where the table should be located

38. The maximum number of book pages (32 lines of 64 characters) that will fit in a 640 KB file

1) 320 2) 640 3) 160 4) 540 5) 1280

39. Word text editor is

1) application program 2) basic software

3) service program 4) font editor

40. The minimum object to encode in text is...

1) bit 2) pixel 3) character 4) byte

41. Changing the font settings of a paragraph inside a text document is called..

1) editing 2) fragmenting

3) formatting 4) tabulation

42. The printer buffer is

1) a device for connecting a printer to a computer

2) the printer's memory, where the printed text enters

3) part of the computer's RAM, where the printed text enters

4) a program that connects the printer to the processor

5) a program that connects the printer with the computer's RAM

43. Text input devices include

1) text editor 2) keyboard

3) hard disk 4) display screen

5) floppy disk

44. What characters can be encrypted with ASCII table codes: 82 and 143?

1) "R" and "Q" 2) "R" and "P" 3) "U" and "Y"

4) "B" and "b" 5) "b" and "B"

45. Specify commands, when executed, the selected text fragment gets into the clipboard

1) insert 2) replace 3) check spelling

4) center align 5) cut and copy

46 Select actions to format text

1) copying fragments of text 2) correcting typos

3) spell checker 4) change font size

5) moving text fragments

47. The sequence of codes 105 162 109 of the encoding table encrypts some characters. Choose the correct statement: "Among these characters ...

1) there cannot be letters of the Russian alphabet

2) there cannot be letters of the Latin alphabet

3) there may be letters of the Russian and Latin alphabets

4) there cannot be letters of the Russian and Latin alphabets

5) there can be only one letter of the Latin alphabet

48. The printed text filled the printer's buffer twice. How many pages contains text if the printer's buffer size is 5120 bits, and one page has 20 lines of 64 characters per line?

1) 2 2) 1 3) 4 4) 3 5) 8

49. Text occupies a full 10 sectors on a single-sided 180 KB floppy disk. The floppy disk is divided into 40 tracks of 9 sectors. How many characters does the text contain?

1) 640 2) 512 3) 500 4) 5000 5) 5120

50. The Word text editor is unloaded from memory and stops working if

1) close the text document window 2) close the text editor window

3) minimize the text editor window 4) minimize the text document window 5) switch to another application window

51. To move a selected piece of text to a new location in a text document, use the command(s)

1) cut 2) cut and paste 3) copy and paste

4) copy 5) Paste

52. The text is given: "A storm covers the sky with mist." For each word (in order) the following commands are applied: highlight a word copy word. What will be displayed on the screen if, after executing these commands, the command was executed insert?

1) A storm covers the sky with darkness

2) Storm

3) covers 4) A storm covers the sky with darkness A storm covers the sky with darkness

53. The code (number) of the letter "j" in the character encoding table is 106. What sequence of codes will correspond to the word "file"? Latin alphabet: a b c d e f g h i j k l m n o p...

1) 110 107 104 111 2) 74 98 120 66 3) 132 112 90 140 4) 102 105 108 101 5) 90 102 114 86

54. Special (control) characters

1) are listed in the encoding table and are always displayed on the screen as symbols

2) are listed in the encoding table, but are not always displayed on the screen as symbols

3) are not listed in the encoding table and are not displayed on the screen as symbols

4). are not listed in the encoding table, but are displayed on the screen as characters

5) do not take up space in the computer's memory and are displayed on the screen as symbols

55.From the suggested text, select the correct formatting options for the first paragraph (1).

1. 
   Font 12, Times New Roman, italic, start with capitals, right margin, right indent 1 cm.
2. 
   Font 12, Times New Roman, regular, as in sentences, in width, first line indent.
3. 
   Font 12, Courier, bold, as in sentences, on the left, indented on the left by 2.25 cm
4. 
   Font 16, Times New Roman, normal, all caps, centered.

57. From the suggested text (see 55) select the correct formatting options for the first paragraph (3).

58. From the suggested text (see 55) choose the correct formatting options for the first paragraph (4).

59. How much information is contained in the word "INFORMATICS" in eight-bit encoding?

1. 
   11 bits 2)11 baud 3) 11 bytes 4)11KB

1. 
   indent 2) footnote 3) footer 4) paragraph

1) 1 bit 2) 8 bits 3) 8 bytes 4) 1 KB

62. In text editors, the Edit command allows Word to

1) saving the document in a folder 2) inserting a table into the document

3) choice of paragraph and font options

4) paste objects from the clipboard

63. * The "File" menu item of the WORD text editor contains the following commands:

1) create 2) open 3) font 4) paragraph

64* The "View" menu item of the Word editor contains the following commands:

1) cut 2) paste 3) normal 4) page markup

5) toolbars 6) preview

65. To set the field values ​​for a new document in the Word editor, you must:

1) select the "Templates" command from the "File" menu

2) select the command "Page setup." from the "File" menu

3) select the "Paragraph" command from the "Format" menu

66. To select a rectangular fragment of text in WORD, you must:

1) set the mouse pointer to the beginning of the selection, when you press the ALT key and the left mouse button, drag the mouse vertically and horizontally

2) set the mouse pointer to the end of the selection, when you press the ALT key and right button mouse drag the mouse vertically and horizontally

3) set the mouse pointer to the beginning of the selection, when you press the CTRL key and the left mouse button, drag the mouse vertically and horizontally

4) set the mouse pointer to the beginning of the selection, when you press the CTRL key and the right mouse button, drag the mouse vertically and horizontally

67. How many different encodings of letters of the Russian alphabet exist

68. How many different encodings of letters of the Latin alphabet exist

1) one 2) three 3) two 4) several

69. Which encoding contains more than 330 characters

1) Windows CP1251 2) MS-DOS PC866 3) KOI8-R

4) MAC 5) UNICODE 6) ISO

70. What will change when a character is presented on the monitor screen in various encodings (Windows, MS-DOS, KOI, etc.)

1) typeface 2) character size

3) character 4) character style

71. Text files of what format contain only character codes and do not contain formatting characters

1) HTM 2) DOC 3) TXT 4) RTF

72. How many times will the information volume of a text page decrease (the text does not contain formatting control characters) when it is converted from Unicode encoding to Windows CP-1251 encoding

1) 256 times 2) 8 times 3) 4 times 4) 2 times 5) 32 times

73. A paragraph in a text editor is...

1) document fragment between paragraph markers 2) character string

3) selected fragment of documents

4) document fragment starting with an indent

74. What is a universal (available for various text editors) format text files retain the formatting of the document

1) HTML 2) RTF 3) DOC 4) TXT

75. What is the most universal text file format (available for most text editors on various operating systems)

1) WPS 2) RTF 3) DOC 4) TXT

76. What is the maximum number of characters that an encoding table can contain if one character from this table occupies 12 bits of memory during storage

1) 24 2) 96 3) 4096 4) 2048 5) 256

77. The words HORN, GANGRENE are encrypted with one of the following sequences of letters

1) TsLVG, VGAVTsBAG 2) VLATS, VGTSBAAVG

3) TSALV, GABTSVAGV 4) TsVGL, BAGTSVAGV 5) LVCG, GABVGTSAL

78. Two texts contain the same number of characters. The amount of information in the first text is 3 times more than in the second. How many characters are contained in the alphabets with which the messages are written, if it is known that the power of each alphabet does not exceed 10 characters and each character is encoded by an integer number of bits

1) 8 and 2 2) 3 and 1 3) 9 and 3 4) 6 and 2 5) 8 and 4

79. Compare the amount of memory required to store 1 page of text typed in text mode (30 lines of 60 characters per line) and the same text entered when scanning from a 20x27 cm page with a resolution of 30 dots per 1 cm2 and encoding 1 bytes per dot

1) Scanned text requires 1080 times more memory

2) Scanned text requires 2.4 times more memory

3) Scanned text requires 72 times more memory

4) the text entered during scanning requires 9 times more memory

5) Scanned text requires 270 times more memory

80. The capacity of one printed sheet is 32 Kbytes. How much time (excluding paper changes) will it take to print the text of one newspaper (2 standard printed sheets) on laser printer at 512 characters per second.

1) 64 sec 2) 128 sec 3) 32 sec 4) 16 sec 5) 1600 sec

81. Arrange text fragments "1Gb", "10Gb", "500Mb", "5Gb" in descending order

1) "10Gb", "5Gb", "1Gb", "500Mb" 2) "10Gb", "1Gb", "500Mb", "5Gb"

3) "500Mb", "5Gb", "10Gb", "1Gb" 4) "5Gb", "500Mb", "1Gb", "10Gb"

5) "500Mb", "10Gb", "5Gb", "1Gb"

82. A greeting to the participants of the Olympiad, written using all the characters of a certain alphabet, looks like this AA:BB+!*ABBA:+BABA:?FAB*+!!!

How much information does it carry

1) 28 bytes 2) 28 bits 3) 84 bytes

4) 9.3 bytes 5) 10.5 bytes

83. In text document is a string containing three words separated by a space: "February January December". What will be received after executing the following sequence of commands:

Highlight the word December; Cut; Press the Home key; Insert

Highlight the word February; Cut; Press the End key; Insert

84. What is the maximum number of characters that an encoding table can contain if one character from this table occupies 10 bits of memory during storage

1) 800 2) 80 3) 1024 4) 512 5) 256

85. The vocabulary of a certain language is 64 words, each of which consists of exactly 2 letters. How many letters are in the alphabet of the language

1) 32 2) 8 3) 64 4) 16 5) 128

86. In what order will the text fragments "excel", "byte", "8v", "10g", "9a", "10a" go, if sorted in descending order

1) "byte", "excel", "8v", "9a", "10g", "10a"

2) "byte", "excel", "9a", "8v", "10g", "10a"

3) "10a", "10g", "9a", "8v", "byte", "excel"

4) "byte", "excel", "10g", "10a", "9a", "8v"

5) "excel", "byte", "10g", "10a", "9a", "8v"

87. Fragments of the text "54disk", "disk22", "5disk4", "52disk" are given. Arrange them in descending order

1) "52disk", "54disk", "5disk4", "disk22"

2) "disk22", "54disk", "52disk", "5disk4"

3) "52disk", "54disk", "disk22", "5disk4"

4) "disk22", "5disk4", "54disk", "52disk"

5) "52disk", "5disk4", "54disk", "disk22"

88. Select a text fragment with the maximum sum of character codes from the ASCII encoding table (do not use the table)

Search for materials:

Number of your materials: 0.

Add 1 material

Certificate
about creating an electronic portfolio

Add 5 materials

Secret
gift

Add 10 materials

Diploma for
informatization of education

Add 12 materials

Review
on any material for free

Add 15 materials

Video lessons
on rapid creation spectacular presentations

Add 17 materials

File:

tests class 9.docx

Municipal budgetary educational institution
"Secondary school No. 25"
APPROVED at the MC meeting
Minutes No. 1 dated 30.08.2017
MC Chairman
_________ E.A. Maksimova
Fund for evaluation funds for the current
and intermediate certification in the subject
"Informatics and ICT"
Grade 9
(EMC N.D. Ugrinovich)
Compiled by: Voropaeva O.V., teacher of computer science
DISCUSSED at the meeting of the MO
29.08.2017
Head of MO
____________I.E. Denisova

Passport of a set of control and evaluation tools
Control and measuring materials were compiled by Voropaeva O.V. on the basis of mandatory
minimum content of education in informatics, are universal and can
used by teachers working on any computer science textbook for grade 9.
The proposed test work can be used in the lesson of knowledge control, as well as in
consolidation of the material covered, repetition of the studied, etc. All tests are given in three
equivalent options with answers.
The main topics of the course:
1. Coding and processing of graphic and multimedia information
2. Coding and processing of text information
3. Coding and processing of numerical information
4. Algorithmization and programming language basics

6. Informatization of society
Specification:
Class Quantity
control
works
9
6
Topics of certification works
1. Encoding and processing
graphic and multimedia
information
2. Coding and processing
text information
3. Encoding and processing
numerical information
4. Algorithmization and language basics
programming
5. Modeling and formalization
6. Informatization of society
Forms
attestation
works
Control and
practical
work
Control
(testing) and
practical
work
Control
(testing) and
practical
work
Control and
practical
work
Control
Job
Control
Job
(testing)
2

Requirements for learning outcomes









As a result of learning computer science, students should be able to:
enjoy personal computer and its peripheral equipment (printer,
scanner, modem, multimedia projector, digital camera, digital sensor);
follow the requirements of safety, hygiene, ergonomics and resource saving when
work with means of information and communication technologies;
create drawings, drawings, graphic representations of a real object, in particular, in
the design process using the basic operations of graphic editors,
educational systems of computer-aided design;
realize the simplest processing digital images;
structure the text using pagination, lists, links, tables of contents;
check spelling;
use tables, images in the text;
create and use various forms of information presentation: formulas, graphs,
charts,
create and use tables (including dynamic, electronic, in particular - in
practical tasks)
move from one data view to another;
create records in the database;


use the acquired knowledge and skills in practical activities and everyday
life for:
 creation of information objects, including for registration of results of educational
work;
creation of the simplest models of objects and processes in the form of images and drawings,
creation of the simplest models of objects and processes in the form of (electronic) tables,
conducting computer experiments using ready-made models of objects and
processes;
creation of the simplest models of objects and processes in the form of programs (including in the form
block diagrams);
3





Criteria and norms for assessing knowledge, skills and abilities of students
Control involves identifying the level of development of educational material in the study of how
individual sections, as well as the entire course of informatics and information technologies generally.
When testing, all correct answers are taken as 100%, then the mark is set to
according to the table:
Job completion percentage
95% or more
8094%%
6679%%
less than 66%
mark
Great
Okay
satisfactorily
unsatisfactory
When performing practical work and control work:
The content and volume of the material to be checked in the control work is determined
program. When checking the assimilation of the material, the completeness, strength of assimilation is revealed
students of theory and the ability to apply it in practice in familiar and unfamiliar situations.
The mark also depends on the presence and nature of the errors made by the students.
gross mistake - the semantic meaning of the concept, definition is completely distorted;


error reflects inaccurate formulations, indicating fuzzy
representation of the object in question;
a flaw is a misconception about an object that does not drastically affect knowledge
determined by the training program;
minor errors - inaccuracies in oral and written speech that do not distort the meaning
answer or solution, random typos, etc.
The standard against which students' knowledge is assessed is the mandatory
minimum content of computer science and information technology. Require from students
definitions that are not included in the school course of computer science - this means incurring
problems related to the violation of the rights of the student (“Education Law”).
Based on the norms (five-point system) laid down in all subject areas
mark:

errors;




4

CMM kit
1. Control and practical work on the topic "Coding and processing of graphics and
multimedia information"
Option 1
1. Two-channel (stereo) sound is recorded with a sampling frequency of 11 kHz and
coding depth 16 bits. The recording lasts 6 minutes, its results are written to a file,


2. Color (with a palette of 256 colors) bitmap graphic image has a size of 10x10
points. How much memory will this image take in bytes?

decreased from 512 to 8. How many times has the information volume of the file decreased?
4. P.R. Create animation in GIMP
Option 2
1. Single-channel (mono) sound is recorded with a sampling frequency of 8 kHz and a depth
16 bit encoding. The recording lasts 2 minutes, its results are written to a file, compression
data is not produced. Which of the following numbers is closest to the size
received file expressed in megabytes?
2. A 64 x 64 pixel bitmap takes up 2 KB of memory. Specify
maximum number of colors in an image palette?
3. File
contained uncompressed
stereophonic musical composition
4 minutes 16 seconds long, digitized with 32768 quantization levels.
After converting the file by reducing the number of quantization levels to 8192
while maintaining the sampling rate, its volume has decreased by 5500 KB. C what
sample rate was the file digitized? Give your answer as an integer Hz.
4. P.R. Create a drawing in CORELDROW
Option 3
1. Two-channel (stereo) sound is recorded at a sampling frequency of 8 kHz and
coding depth 24 bits. The recording lasts 4 minutes, its results are written to a file,
data is not compressed. Which of the following numbers is closest to
the size of the resulting file, expressed in megabytes?
2. A raster file containing a black and white drawing has a volume of one and a half kilobytes. Which
Will the image be sized in pixels?
3. In the process of bitmap conversion graphic file number of colors
5

increased from 16 to 65 536. How many times has the information volume of the file increased?
4. P.R. Using Audacity, record your voice (read any quatrain), overdub
music to words, swap in verse. first and second pair of lines. Decrease
(slightly) playback speed. Save under the name "Kr_OwnSurname"
Answers:
Option 1
1. 15Mb
2. 100 b
3. 3 times
Option 2
1. 2Mb
2. 16
3. 44,000Hz
Option 3
1. 11Mb
2. 12 288
3. 4 times

 "5" is set when all tasks are completed completely or in the presence of 12 small
errors;
 “4” is put if there are 12 shortcomings or one mistake:
 "3" is placed when 2/3 of the volume of the proposed tasks is completed;
 "2" is put if significant errors are made, showing that the student does not know
obligatory skills of the given topic to the full extent (ignorance of the main software
material) or refusal to perform academic duties:
2. Control and practical work "Coding and processing of text information"
Option 1
1. In one version of the Unicode encoding, each character is encoded with two bytes.
Determine the number of characters in the message if the information volume of the message in
this encoding is 480 bits.
2. Through some connection, a 32 KB file is transferred within 16 seconds.
Determine the size of the file (in KB) that is being transferred over the same connection to
within a minute.
1. Which of the sentences below follows all the typing rules if

1) The stone is heavy while it lies in place; move it, it becomes easier.
2) The stone is heavy while it lies in place; Move it and it becomes easier.
3) The stone is heavy while it lies in place; move it, it becomes easier.
4) A stone is heavy while it lies in place; move it, it becomes easier.
4. What characters can be encrypted with ASCII table codes: 82 and 143?
1. R and Q
6

2. R&P
3. Shch and Ya
5. An article typed on a computer contains 16 pages, each page has 32 lines, each
line 64 characters. Determine the information volume of the article in the KOI8 encoding, in which
each character is encoded with 8 bits.
1) 280 bytes
2) 32 KB
3) 35840 bits
4) 70 KB
6. An information message with a volume of 1.5 KB contains 3072 characters. How
how many bits encode each character of this message?
7. Text editor cursor coordinates are fixed:
A) in the text editor menu;
B) in the dictionary of a text editor;
C) in the status bar of a text editor;
D) in a text editor window;
E) in the buffer for copying.
8. The sequence of codes 105 162 109 of the encoding table encrypts some characters.
Insert the correct continuation instead of the ellipsis. "Among these symbols..."
A) there cannot be letters of the Russian alphabet;
B) there cannot be letters of the Latin alphabet;
C) there may be letters of the Russian and Latin alphabets;
D) there cannot be letters of the Russian and Latin alphabets;
E) there can be only one letter of the Latin alphabet.
9. The character encoding table establishes a correspondence between:
A) symbols, their decimal numbers and binary codes;
B) characters of different alphabets;
C) characters and the number of bytes they occupy;
D) symbols and numbers of memory cells they occupy;
E) symbols and keys.
10. Select an action related to text formatting:
A) copying fragments of text;
B) correction of typographical errors;
C) spell checker;
D) changing the indentation of the red line;
E) moving fragments of text.
11. Specify the command(s), upon execution of which(s) the selected text fragment gets into
clipboard:
7

A) paste;
B) replace;
C) check spelling;
D) align to the center;
E) cut and copy.
12. Text takes up 0.25 kilobytes of computer memory. How many characters does the text contain?
A) 256; B) 2048; C)32; D)250; E) 2000.
13. The code (number) of the letter "j" in the character encoding table is 106. What sequence
letters will match the word "file"? Latin letters alphabet:
a b c d e f g h i j k l m n o p . . .
A) 110 107 104 111;
B) 74 98 120 66;
C) 132 112 90 140;
D) 102 105 108 101;
E) 90 102 114 86.
14. Text editor can only use one font and two buttons to install
effects such as bold and italic. How many different styles
characters can be obtained?
A) 1; IN 2; C) 3; D)4; E) 6.

My father Andrei Pe
trovich grinev in molo
to achieve his served under
Count Minich and went out to
resign
prime minister
major in 17 ... year. FROM
since then he lived in his
Simbirsk village, where
married a girl
Avdotya Vasilievna Yu.,
daughters
poor
local nobleman.
There were nine of us
children.

Laundress Palashka, thick
and a pockmarked girl, and a curve
cowshed Akulka somehow
agreed at the same time
throw yourself at your mother's feet, apologizing
in criminal weakness and with weeping
complaining about the monsieur who seduced
their inexperience.
Mother don't joke about it
loved and complained to the father.
His reprisal was short.
He immediately demanded a canal
French.
Practical work: Type the formula and draw up an anecdote according to the model.
8

Option 2
1. In one version of the Unicode encoding, each character is encoded with 16 bits.
Determine the message size of 512 characters in this encoding.
2. It took 2 minutes to transfer a 3750 KB file over some connection. What is
the data transfer rate through this connection in bits per second?
3. Which of the sentences below follows all the typing rules, if
Are there any spelling and punctuation errors?
1) He who does not respond with anger to anger saves both himself and the other.
2) He who does not respond with anger to anger saves both himself and the other.
3) Whoever does not respond with anger to anger saves both himself and the other.
4) Whoever does not respond with anger to anger Saves both himself and the other.
4. The text is typed without indenting the first line and aligned to the left.
How many paragraphs, in terms of typing in a text editor, do not have a paragraph indent
on the left in this piece of text?
5. How many bits are needed to encode a character from a 64 character alphabet?
6. In a text editor, the main parameters when setting paragraph parameters are:
1) typeface, size, style
9

2) indent, spacing
3) fields, orientation
4) color, number of characters
7. How to word processor Word set a red line (according to the rules of the Russian language)?
1) Page Setup - First Line - Indent
2) Paragraph - First line - Indent
3) move "spaces" the first line of the paragraph
4) Paragraph - First line - Protrusion
8. What characters can be encrypted with ASCII table codes 119 and 251?
A) "d" and "w"; C) "d" and "D"; E) "w" and "s".
B) "j" and "s"; D) "I" and "t";
9. Remove column Word tables along with its contents, by highlighting the line, then:
1) press the Esc key
2) press the Delete key
3) press the Insert key
4) execute the command Work with Table Layout - Delete columns
10. Button
1) merge multiple cells
2) split cells
3) delete a group of cells
4) insert a group of cells
11. Machine translation systems of texts are programs that carry out automated
translation:
1) from programming language to machine code language
2) text from one natural language to another
3) from one programming language to another
4) words or phrases from one natural language to another
12. Systems optical recognition texts are:
1) programs that allow you to convert text presented as a bitmap
images, into an editable, full-text searchable view
2) programs for working with the scanner
3) programs for editing texts
4) programs for translating texts
13. What information volume contains the word PROCESSOR, if the symbols are taken from the table
Unicode?
1) 9 bit
2) 18 bit
3) 72 bits
4) 18 bytes
10

14.
Which formula, entered into a cell in a Word table, calculates the maximum of the values,
located in the cells to the right of the cell with the formula?
15.
It takes 84,000 bits to store text. How many pages will this text take if
does the page have 30 lines of 70 characters per line?
A) 40; AT 5; C) 50; D) 400; E) 350.
Practical work: Type a formula and a multilevel list.
Option 3.
1. The user created a message of 128 characters in KOI8 encoding, in which each
A character is encoded with 8 bits. After editing, the information volume of the message
was 1280 bits. Determine how many characters were added to the message if it
encoding has not changed.
2. In KOI8 encoding, each character is encoded with one byte. Determine
the information volume of the next message in this encoding:
Water wears away earth and stone.
1) 184 bit
2) 232 bit
3) 24 bytes
4) 216 bytes
3. How many paragraphs, in terms of typing in a text editor, contains the following fragment
text:
11

1) 8
2) 6
3) 3
4) 4
4. How many mistakes were made when typing A. Schnabel's statements, if spelling and
no punctuation errors?
The notes I take are no better than those of many other pianists. pauses between notes
where art lies!

1) 5
2) 2
3) 3
4) 4
5. Which of the following actions relate to text formatting?
1. Copying a fragment
2. Deleting a character
3. Setting the alignment mode
4. Insert a word
6. How many characters can be encoded with a 5-bit code?
7. Text information in the computer memory is encoded:
1) decimal code
2) using symbols
3) octal code
4) binary code
8. How to set double line spacing in Word?
1) Font - Spacing - Interline - Double
2) Paragraph - Spacing - Interline - Double
3) Paragraph - Spacing - Before - 6 pt
4) when typing with the Enter key, insert empty lines between lines
in word processor Word allows you to:
9. Button
1) create bulleted list
2) create a numbered list
3) split text into columns
12

4) align text to center
10 How to highlight one row of a table in a Word document?
1) put the cursor on the left side of the column cell until it becomes a white arrow and click
left mouse button
2) click on the selection bar to the left of the selected rows of the column when the cursor becomes
white arrow
3) put the cursor over the column, when it becomes a black vertical arrow, left click
mouse button
4) put the cursor in a column of the table and execute the command Table - Select table
11. Programs that allow you to convert text presented as a bitmap
images into an editable, full-text searchable view:
1) machine translation systems
2) OCR systems
3) word processors
4) programs for working with the scanner
12. Program for optical text recognition:
1) Abby FineReader
2) Mozilla Firefox
3) Adobe Photoshop
4) Prompt
13. How many bits are there per character in the Unicode encoding standard?
1) 2
2) 8
3) 16
4) 4
14. A 4 MB file is transferred over some connection in 16 seconds. Determine
the time in seconds it takes to transfer a 2048 file over the same connection
KB.
15. Complete comparative characteristic character and paragraph properties for the following
texts. Make a comparison according to the following parameters: typeface, font size, style,
saturation, paragraph settings.
My father Andrei Pe
trovich grinev in molo
to achieve his served under
Count Minich and went out to
prime minister's resignation
major in 17 ... year. Ever since
since he lived in his
Simbirsk village, where
and married a girl
Avdotya Vasilievna Yu.,
Laundress Palashka, fat and
a pockmarked girl, and a crooked cowshed
Akulka somehow agreed to
one time to rush to mother in
feet, guilty of a criminal sla
bosti and crying complaining about
Monsieur
who seduced them
inexperience.
Mother don't joke about it
loved and complained
father. He had a massacre
13

short.
demanded a French channel.
immediately
He
daughter of the poor
local nobleman.
There were nine of us
children.
Practical work:
1. Create a table with data about your family members (name, height, weight), their average age,
total weight.
2. Make a three-level list.
Answers:
Option 1
Option 2
Option 3
1. 30 characters
2. 120 Kb
3. 3)
4. 1)
5. 32 Kb
6. 4 bits
7. C)
8. C)
9. A)
10.D)
11. E)
12. A)
13.D)
14.D)
15. Same: size
and typeface.
1. 1024 b
2. 256,000 bps
3. 2)
4. 8)
5. 6 bit
6. 2)
7. 2)
8. E)
9. 4)
10. 1)
11. 2)
12. 1)
13. 4)
14. MAX
15. B)
1. 32 characters
2. 232 bit
3. 4)
4. 4)
5. 3)
6. 32 characters
7. 4)
8. 2)
9. 2)
10. 2)
11. 2)
12. 1)
13. 3)
14.8 sec
15. Same only
headset
Evaluation criteria:
Job completion percentage
95% or more
8094%%
6679%%
less than 66%
mark
Great
Okay
satisfactorily
unsatisfactory

OPTION 1
1. Spreadsheet is designed for:
1. processing predominantly numerical data structured using tables;
2. orderly storage and processing of significant data arrays;
3. visualization structural ties between the data presented in the tables;
4. editing graphic representations large amounts of information.
14

2. In a spreadsheet, the main worksheet element is:
1) cell;
2) line;
3) column;
4) formula.
3. Select the correct row designation in the spreadsheet:
a. 18D;
b. K13;
c. 34;
d. AB.
4. Select the correct cell address in the spreadsheet:
a. 11D;
b. F12;
c. AB3;
d. B1A.
5. The expression 5(A2+C3):3(2B23D3) in the spreadsheet looks like:
1. 5(A2+C3)/3(2B23D3) ;
2. 5*(A2+C3)/3*(2*B23*D3) ;
3. 5*(A2+C3)/(3*(2*B23*D3)) ;
4. 5(A2+C3)/(3(2B23D3)) .
6. Active cell this is the cell:
1. for recording commands;
2. containing a formula that includes the name of the cell in which data is entered;
3. a formula that contains links to the contents of a dependent cell;
4. in which commands are entered.
7. Range is:
1. a set of cells that form a rectangular area in the table;
2. all cells of one line;
3. all cells of one column;
4. set of admissible values.
8. What will be the value of cell A8 if you enter the formula = SUM (A1: A7) / 2 into it:

1. 280;
2. 140;
3. 40;
4. 35?

IN
15
BUT

1
5
=A1*2
=A1+B1
A) 5
10. Expression 3(A1 + B1) : 5(2B1 - 3A2), written in accordance with the rules adopted in
mathematics, in a spreadsheet looks like:
B) 10
C) 15
D) 20

1. 3*(A1 + B1) / (5*(2*B1 – 3*A2))
2. 3(A1 + B1) : 5(2B1 - 3A2)
3. 3(A1 + B1) / (5(2B1 – 3A2))
4. 3(A1 + B1) / 5(2B1 - 3A2)

A
3
B
4
C
2
D
5
=D1C1+1 =D11
=B1*4
1
2

performing calculations, did the chart for the values ​​of the range of cells A2:D2 correspond to the figure?
1)=D1A1 2)=B1+1
Practical work:
1.Build a histogram and a pie chart (computer science) according to the table:
4) =C1*D1
3)=D1+A1

The test result is presented in the table:
Surname
Aganyan
Voronin
Grigorchuk
Rodnina
Sergeenko
Cherepanov
Chemistry
46
45
68
56
74
83
Informatics
32
74
75
82
38
28
2. Graph the function:
Test No. 3 "Coding and processing of numerical information"
x

2
1 0

1 6
,
x

,0[
1 0
]
y

1
2 0
OPTION 2
1. The spreadsheet cannot be used for:
1) sorting tabular data;
2) performing mathematical and economic calculations;
16

3) construction of graphs and diagrams;
4) processing of graphic images.
11. Spreadsheet is:
1. a set of numbered lines and named letters of the Latin alphabet
columns;
2. a set of lines named by letters of the Latin alphabet and numbered
columns;
3. a set of numbered rows and columns;
4. a set of rows and columns, arbitrarily named by the user.
11. Strings spreadsheet:
1. are named arbitrarily by users;
2. are indicated by the letters of the Russian alphabet;
3. are indicated by letters of the Latin alphabet;
4. are numbered.
11. In a spreadsheet, a cell is called:
1. horizontal line;
2. vertical column;
3. intersection of row and column;
4. cursor - a frame on the screen.
5. Select the correct column designation in the spreadsheet:
1.DF;
2. F12;
3.AB;
4. 113.
6. A spreadsheet cell cannot contain:
1. number;
2. text;
3. sheet;
4. formula.
11. Select the correct formula entry for the spreadsheet:
1.C3+4*D4
2.C3=C1+2*C2
3.A5B5+23
4.=A2*A3A4
8. What will be the value of cell C1 if you enter the formula \u003d A1 + B1 into it:

1. 20;
2. 15;
3. 10;
4. 30?
9. The result of calculations in cell C1 will be:
A B
FROM
17

A1*2
1 5
1. 25 2. 50 3. 75 4. 100
=SUM(A1:B1)*A1
10. What formula will be obtained when copying to cell C3, formulas from cell C2:

1.=A1*A2+B2;
2. =$A$1*$A$2+$B$2;
3.=$A$1*A3+B3;
4.=$A$2*A3+B3;
5.=$B$2*A3+B4?
11. Given a fragment of a spreadsheet:

A
2
B
4
C
6
D
8
=B1/A1
=C1/A1+1
=D1/A1
1
2

Which of the formulas given below can be written in cell C2, so that built after
performing calculations to diagrams (cid: 0) And according to the values ​​of the range of cells A2: D2 corresponded to the figure?
1)=С1В1
4) \u003d C 1 + 1
2)=A11
3)=D11
Practical work:
1.Build a histogram and a pie chart according to the table.
(change the design of data series, chart background)
Table of results of weightlifting competitions
Full name
Ayvazyan G.S.
Viktorov M.P.
Gordeziani B.Sh.
Mikhalchik M.S.
Weight
athlete
77,1
79,1
78,2
78,2
Taken in
snatch
150
147,5
147,5
147,5
18

Pai S.V.
Shapsugov M.Kh.
79,5
77,1
150
147,5
13  xxy
]12,8[,8)10(
2
2. Graph the function:
Answers:
Option 1
Option 2
1. 1
2. 1
3. With
4.B
5. 3
6. 4
7. 1
8. 2
9.B
10. 1
11. 3
1. 4
2. 1
3. 4
4. 3
5. 1
6. 3
7. 4
8. 4
9. 3
10. 3
11.1
Evaluation criteria:
Job completion percentage
95% or more
8094%%
6679%%
less than 66%
mark
Great
Okay
satisfactorily
unsatisfactory
4. Control work and practical work on the topic "Algorithms"
1. Define the concepts: algorithm, cyclic algorithm
Option 1


table.
X
Y
19

Algorithm 1
Algorithm 2
4. Make an algorithm (program) for finding the sum of all two-digit numbers that are multiples of three, using
loop with parameter.
Option 2
1. Define the concepts: program, branching algorithm
2. Find the value of x after executing Algorithm 1 if x=5.
3. Run the algorithm 2. Enter the values ​​of the variables that change during the execution of the algorithm in
table.
X
Y
20

Algorithm 1
Algorithm 2
21

4. Make an algorithm (program) for finding the product of all two-digit numbers that are multiples of five,
using a loop with a parameter.
Answers:
22

Option 1
Option 2
2
1.
2.
3. 10-13, 15-18, 20-21, 25-24, 30-27
4.
1.
2. 39
3. 35i40, 33i45, 31i50, 29i55, 37i60
4.
Performance Evaluation Criteria
 "5" is set when all tasks are completed completely or in the presence of 12 small
errors;
 “4” is put if there are 12 shortcomings or one mistake:
 "3" is placed when 2/3 of the volume of the proposed tasks is completed;
 "2" is put if significant errors are made, showing that the student does not know
obligatory skills of the given topic to the full extent (ignorance of the main software
material) or refusal to perform work:
5. Test work on the topic "Modeling"
Option 1
1) Roads were built between settlements A, B, C, D, E, F, the length of which
shown in the table. (The absence of a number in the table means that a direct road between
no points.)
A
5
B
5
9
3
8
C
9
4
D
3
2
F
7
E
8
4
2
7
A
B
C
D
E
F

4) 17
1) 11
2) The transport company carries out cargo transportation different types transport between
2) 13
3) 15
four cities: CHEREPOVETS, MOSCOW, KURSK, PERM. Shipping cost
and travel time are shown in the table:
Departure point Destination Cost (c.u.) Travel time
MOSCOW
MOSCOW
MOSCOW
PERMIAN
CHEREPOVETS
CHEREPOVETS
CHEREPOVETS
KURSK
KURSK
KURSK
KURSK
PERMIAN
KURSK
CHEREPOVETS
MOSCOW
PERMIAN
MOSCOW
KURSK
PERMIAN
MOSCOW
CHEREPOVETS
CHEREPOVETS
100
30
50
100
140
50
100
60
30
100
90
70
10
15
69
80
15
80
40
10
80
100
Determine the route of the cheapest option for the delivery of goods from CHEREPOVETS to PERM.
If there are several such routes, indicate the most advantageous option in terms of time in your answer.
1) CHEREPOVETS - PERM
23

2) CHEREPOVETS - KURSK - PERM
3) CHEREPOVETS - MOSCOW - PERM
4) CHEREPOVETS - MOSCOW - KURSK - PERM
3) The figure shows a diagram of roads connecting cities A, B, C, D, E, F, G, H, I, K. For each road
different ways from city A to city K?
B
IN
BUT
G
D
E
F
TO
W
AND
4) The Grasshopper has two teams:
1. add 3,
2. subtract 2.
The first of them increases the number on the screen by 3, the second one decreases it by 2 (negative numbers
allowed). The program for the Grasshopper is a sequence of commands. How many different
numbers can be obtained from the number 1 using a program that contains exactly 5 instructions?

1. add 1
2. multiply by 3



Justify the answer.
Option 2
1) Roads were built between settlements A, B, C, D, E, F, the length
which are shown in the table. (The absence of a number in the table means that the direct
there is no road between points.)
A
B
3
9
4
C
3
9
3
8
D
3
2
F
7
E
4
8
2
7
A
B
C
D
E
F
Determine the length of the shortest path between points A and F (assuming that
You can only move on the built roads).
4) 17
1) 11
2) 13
3) 15
2) The tourist pilgrim must get from MURMANSK to KIEV. bus
the company offered him the following list of routes that pass through
cities: MURMANSK, KIEV, MOSCOW and SMOLENSK.
24

Point of departure Point of arrival Cost (c.u.) Number of monasteries
MURMANSK
MURMANSK
MURMANSK
MOSCOW
MOSCOW
MOSCOW
SMOLENSK
SMOLENSK
KYIV
KYIV
KYIV
KYIV
MOSCOW
SMOLENSK
KYIV
MURMANSK
SMOLENSK
KYIV
MOSCOW
MOSCOW
SMOLENSK
MURMANSK
200
100
110
60
100
20
40
30
60
35
190
81
10
30
7
9
15
15
15
7
10
37
In the table, the traveler indicated for himself the number of monasteries that he would pass by.
pass the bus. Help the traveler get to their destination by spending on
the road is not more than 190 c.u. and seeing the maximum number of monasteries. Please indicate in your answer
pilgrim route:
1) MURMANSK - SMOLENSK - KIEV
2) MURMANSK - MOSCOW - KIEV
3) MURMANSK - MOSCOW - SMOLENSK - KIEV
4) MURMANSK - SMOLENSK - MOSCOW - KIEV
3. The figure shows a diagram of roads connecting cities A, B, C, D, E, F, G, Z. For each road
You can only move in one direction indicated by the arrow. How many exist
different ways from city A to city Z?
BUT
B
IN
G
D
E
W
F
4) The performer Calculator has two commands:
1. add 1
2. multiply by 2.
The first of them increases the number on the screen by 1, the second doubles it.
A calculator program is a sequence of commands. How many different
numbers can be obtained from the number 2 using a program that contains exactly 4
commands?
5*) The performer Triple has two teams, which are assigned numbers:
1. add 1
2. multiply by 3
The first of them increases the number on the screen by 1, the second triples it.
The Triple program is a sequence of commands.
How many programs are there that convert the number 1 to the number 20?
Justify the answer.
25

Answers:
Option 1
1. 17
2. 4)
3. 12
4. 6
Option 2
1. 15
2. 1)
3. 14
4. 15
Performance Evaluation Criteria
 "5" is set when all tasks are completed completely or in the presence of 12 small
errors;
 “4” is put if there are 12 shortcomings or one mistake:
 "3" is placed when 2/3 of the volume of the proposed tasks is completed;
 "2" is put if significant errors are made, showing that the student does not know
obligatory skills of the given topic to the full extent (ignorance of the main software
material) or refusal to perform academic duties:
Examination No. 6 "Informatization of society"
1 The computers of your informatics office are networked. This network...
a Local
b Regional
in Global
2 What device is needed to transmit data over telephone lines?
a Drive
b Modem
to Scanner
3 One of the computers in the office has network printer. Can others
students from their computers to use this printer?
a yes
b No
c Yes, if access to the printer is allowed
4 Which type of access can be set for the My Documents folder on your
computer so that other students in the classroom can use documents from
this folder?
a Local
b Read only
in Full
5. Greatest Opportunities for access to information resources provides
Internet connection method:
a) terminal connection via a switched telephone channel;
b) remote access on telephone channels communications;
c) permanent connection via fiber optic channel;
d) a permanent connection on a dedicated channel.
6. Computer telecommunications- this:
a) connection of several computers into a single network;
26

and back;
b) transferring information from one computer to another using floppy disks;
c) remote data transfer from one computer to another;
d) exchange of information between users about the state of the computer;
7. Server is:
a) a network program that conducts a dialogue of one user with another;
b) powerful computer, to which other computers are connected;
c) a computer of an individual user connected to a common network;
d) a standard that defines the form of presentation and the method of sending a message.
8. Modem is:
a) a powerful computer to which other computers are connected;
b) a device that converts digital computer signals into an analog telephone signal
c) a program with the help of which a dialogue is carried out between several computers;
d) a personal computer used to receive and send correspondence.
9. Data transfer rate is:
a) the amount of information transmitted in one second;
b) the number of bytes of information transmitted in one minute;
c) the number of bytes of information transferred from one computer to another;
d) the number of bits of information transmitted through the modem per unit of time.
10. Addressing is:
a) a method for identifying subscribers in the network;
b) server address;
c) the postal address of the network user;
d) the number of bauds (symbols / sec) sent by your modem.
11. Local computer networks are:
a) a network to which all computers in your city are connected;
b) a network to which all computers in your country are connected;
c) the network to which the computers of your computer science office or one building are connected;
d) a network to which all computers are connected.
12. Network adapter- this:
but) special program, through which several computers are connected;
b) special hardware for effective interaction of personal
network computers;
c) special control system network resources general access;
d) a system for exchanging information between different computers.
13. Domain is:
a) part of the address that defines the address of the user's computer on the network;
b) the name of the program for communication between computers;
c) the name of the device that communicates between computers;
G)
14. Which of the following methods of connecting to the Internet provides
unit of measurement of information.
the greatest opportunities for access to information resources:
a) a permanent connection over a fiber optic channel;
b) remote access via telephone channels;
c) permanent connection on a dedicated channel;
d) terminal connection via dial-up telephone channel;
e) temporary access via telephone channels.
27

15. Exchange of information between computer networks in which different
carried out with
information presentation standards (network protocols),
using:
a) host computers;
b) email;
c) gateways;
d) modems;
e) file servers.
16. Mailbox email subscriber is:
a) an ordinary mailbox;
b) some area of ​​the file server RAM;
c) part of the memory on the hard drive mail server assigned to the user;
d) part of the memory on the hard drive of the workstation;
e) special electronic device for storing text files.
17. A distinctive feature of a Web document is:
a) the absence of a strictly defined format for the presentation of the document;
b) the fact that its replication is carried out by the compiler of the document;
c) the presence of hypertext links in it;
d) the presence of illustrations in it;
e) its compactness.
18.
Complex of hardware and software tools allowing computers
exchange data is:
a) highway
b) interface;
c) adapter;
G) computer network;
e) data buses.
19. The global computer network is:
a) an information system with hyperlinks;
b) a set of computers connected by information transmission channels and located in
within one room, building;
c) a set of host computers and file servers;
d) a system for exchanging information on a specific topic;
e) aggregate local networks and computers located at long distances and
connected via communication channels into a single system.
20. Many computers connected by information transmission channels and located
within the same room, building, is called:
a) a global computer network;
b) information system with hyperlinks;
c) local computer network;
d) email;
e) regional computer network.
21. Information resources include:
a) a set of documents on paper media;
b) the entire set of individual documents, as well as all documents in the
special repositories (libraries, video libraries, collections, archives);
c) all documents that are stored in the archives;
d) books and other printed publications;
e) information stored on paper and magnetic media.
28

22. To store files intended for the general access of network users,
used:
a) host computer
b) fileserver;
c) workstation;
d) client-server;
e) switch.
23. network protocol- this:
a) a set of agreements on interactions in a computer network;
b) sequential recording of events occurring in a computer network;
c) rules for interpreting data transmitted over the network;
d) rules for establishing communication between two computers in the network;
e) agreement various processes in time.
24. Activities aimed at collecting, storing, processing, transferring and using
information is called:
a) labor activity;
b) sports activities;
c) information activities;
d) artistic activity;
e) scientific activity.
25. Transport protocol (TCP) provides:
a) splitting files into IP packets in the process of transmission and assembling files in the process of receiving;
b) receiving, transmitting and issuing one communication session;
c) providing the user with already processed information;
d) delivery of information from the sender's computer to the recipient's computer;
e) collection of files from IP packets during file transfer.
26. Routing protocol (IP) provides:
a) delivery of information from the sender's computer to the recipient's computer;
b) data interpretation and preparation for the user level;
c) preservation of mechanical, functional parameters of physical connection in a computer
networks;
d) control of data transmission equipment and communication channels;
e) splitting files into IP packets in the process of transmission and assembling files in the process of receiving.
27. A computer connected to the Internet must have:
a) IP address;
b) WEB page;
c) home WEB-page;
d) domain name;
e) URL.
28. Email(email) allows you to send:
a) messages and attached files;
b) exclusively text messages;
c) executable programs;
d) www pages;
e) exclusively databases.
29. WEB pages have the extension:
a) *.HTM;
b) *.THT;
c) *.WEB;
29

d) *.EXE;
e) *. WWW.
30. HTML (HYPER TEXT MARKUP LANGUAGE) is
a) means of creating WEB pages;
b) programming system;
c) graphic editor;
d) database management system;
e) expert system.
Answers:
1
but
2
b
3
in
4
in
5
in
6
in
7
b
8
b
9
G
10 11 12 13 14 15 16 17
but
in
b
but
but
in
in
in
18
19
20
21
22
23
24
25
26
27
28
29
30
G
d
in
d
b
but
in
but
but
but
but
but
but
Evaluation criteria:
Job completion percentage
95% or more
8094%%
6679%%
less than 66%
mark
Great
Okay
satisfactorily
unsatisfactory
Change Registration Sheet
Accepted/Date
Content changes made
date of
Causes
30